lrichards-etsy opened a new issue, #241:
URL: https://github.com/apache/polaris/issues/241
### Is this a possible security vulnerability?
- [X] This is NOT a possible security vulnerability
### Describe the bug
When running `/app/bin/polaris-service bootstrap polaris-server.yml` against
a remote MySQL DB I get the following error:
`Internal Exception: java.sql.SQLSyntaxErrorException: Column length too big
for column 'INTERNALPROPERTIES' (max = 16383); use BLOB or TEXT instead`
and nothing gets created in the DB.
I got past that error by setting a smaller VARCHAR limit for those columns,
but hit a second error:
`Internal Exception: java.sql.SQLSyntaxErrorException: FUNCTION
<database>.NEXTVAL does not exist`
### To Reproduce
_No response_
### Actual Behavior
_No response_
### Expected Behavior
Bootstrapping to run without issue
### Additional context
_No response_
### System information
Connected to a CloudSQL MySQL - version 8
Dependencies needed
```
implementation("com.google.cloud.sql:mysql-socket-factory-connector-j-8:1.20.0")
implementation("com.mysql:mysql-connector-j:8.4.0")
```
persistence.xml info
```
<property name="jakarta.persistence.jdbc.url"
value="jdbc:mysql://google/<database>?cloudSqlInstance=<connection
info>&socketFactory=com.google.cloud.sql.mysql.SocketFactory"/>
<property name="jakarta.persistence.jdbc.user" value="<user>"/>
<property name="jakarta.persistence.jdbc.password" value="<password>"/>
<property name="jakarta.persistence.schema-generation.database.action"
value="create"/>
<property name="eclipselink.logging.level.sql" value="FINE"/>
<property name="eclipselink.logging.parameters" value="true"/>
<property name="eclipselink.persistence-context.flush-mode"
value="auto"/>
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
