Connect Mysql #9914

CaladoLucas · 2023-10-02T17:09:51Z

CaladoLucas
Oct 2, 2023

Hello, friends,
I'm trying to connect to my MySQL database, but I'm getting the following error:
[
{
"definition": "db_tita",
"message": {
"stacktrace": "java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"$[]" COLUMNS(schemaname VARCHAR(255) PATH "$.s", tablename VARCHAR(255) PATH "' at line 14\n\tat com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)\n\tat com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)\n\tat com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)\n\tat com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)\n\tat io.agroal.pool.wrapper.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:78)\n\tat io.opentelemetry.instrumentation.jdbc.internal.OpenTelemetryStatement.wrapCall(OpenTelemetryStatement.java:294)\n\tat io.opentelemetry.instrumentation.jdbc.internal.OpenTelemetryPreparedStatement.executeQuery(OpenTelemetryPreparedStatement.java:60)\n\tat io.hasura.services.schemaGenerators.MySQLSchemaGenerator.queryDatabase(MySQLSchemaGenerator.kt:106)\n\tat io.hasura.services.schemaGenerators.BaseSchemaGenerator.getSchema(BaseSchemaGenerator.kt:36)\n\tat io.hasura.services.dataConnectors.MySQLDataConnectorService.executeGetSchema(MySQLDataConnectorService.kt:65)\n\tat io.hasura.services.dataConnectors.BaseDataConnectorService.getSchema(BaseDataConnectorService.kt:127)\n\tat io.hasura.services.dataConnectors.MySQLDataConnectorService_Subclass.getSchema$$superforward(Unknown Source)\n\tat io.hasura.services.dataConnectors.MySQLDataConnectorService_Subclass$$function$$7.apply(Unknown Source)\n\tat io.quarkus.arc.impl.AroundInvokeInvocationContext.proceed(AroundInvokeInvocationContext.java:77)\n\tat io.quarkus.arc.impl.AroundInvokeInvocationContext.proceed(AroundInvokeInvocationContext.java:66)\n\tat io.quarkus.opentelemetry.runtime.tracing.cdi.WithSpanInterceptor.span(WithSpanInterceptor.java:66)\n\tat io.quarkus.opentelemetry.runtime.tracing.cdi.WithSpanInterceptor_Bean.intercept(Unknown Source)\n\tat io.quarkus.arc.impl.InterceptorInvocation.invoke(InterceptorInvocation.java:42)\n\tat io.quarkus.arc.impl.AroundInvokeInvocationContext.perform(AroundInvokeInvocationContext.java:34)\n\tat io.quarkus.arc.impl.InvocationContexts.performAroundInvoke(InvocationContexts.java:27)\n\tat io.hasura.services.dataConnectors.MySQLDataConnectorService_Subclass.getSchema(Unknown Source)\n\tat io.hasura.controllers.DataConnectorResource.getSchemaWithRequest(DataConnectorResource.kt:106)\n\tat io.hasura.controllers.DataConnectorResource_Subclass.getSchemaWithRequest$$superforward(Unknown Source)\n\tat io.hasura.controllers.DataConnectorResource_Subclass$$function$$4.apply(Unknown Source)\n\tat io.quarkus.arc.impl.AroundInvokeInvocationContext.proceed(AroundInvokeInvocationContext.java:77)\n\tat io.quarkus.arc.impl.AroundInvokeInvocationContext.proceed(AroundInvokeInvocationContext.java:66)\n\tat io.quarkus.opentelemetry.runtime.tracing.cdi.WithSpanInterceptor.span(WithSpanInterceptor.java:66)\n\tat io.quarkus.opentelemetry.runtime.tracing.cdi.WithSpanInterceptor_Bean.intercept(Unknown Source)\n\tat io.quarkus.arc.impl.InterceptorInvocation.invoke(InterceptorInvocation.java:42)\n\tat io.quarkus.arc.impl.AroundInvokeInvocationContext.perform(AroundInvokeInvocationContext.java:34)\n\tat io.quarkus.arc.impl.InvocationContexts.performAroundInvoke(InvocationContexts.java:27)\n\tat io.hasura.controllers.DataConnectorResource_Subclass.getSchemaWithRequest(Unknown Source)\n\tat io.hasura.controllers.DataConnectorResource$quarkusrestinvoker$getSchemaWithRequest_346619f777a11d1f6019d5b502ea626944986626.invoke(Unknown Source)\n\tat org.jboss.resteasy.reactive.server.handlers.InvocationHandler.handle(InvocationHandler.java:29)\n\tat io.quarkus.resteasy.reactive.server.runtime.QuarkusResteasyReactiveRequestContext.invokeHandler(QuarkusResteasyReactiveRequestContext.java:141)\n\tat org.jboss.resteasy.reactive.common.core.AbstractResteasyReactiveContext.run(AbstractResteasyReactiveContext.java:145)\n\tat io.quarkus.vertx.core.runtime.VertxCoreRecorder$14.runWith(VertxCoreRecorder.java:576)\n\tat org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)\n\tat org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)\n\tat org.jboss.threads.DelegatingRunnable.run(DelegatingRunnable.java:29)\n\tat org.jboss.threads.ThreadLocalResettingRunnable.run(ThreadLocalResettingRunnable.java:29)\n\tat io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)\n\tat java.base/java.lang.Thread.run(Thread.java:833)\n"
},
"name": "source db_tita",
"reason": "Inconsistent object: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"$[]" COLUMNS(schemaname VARCHAR(255) PATH "$.s", tablename VARCHAR(255) PATH "' at line 14",
"type": "source"
}
]

I have already checked the connection data and they are all correct.

Answered by robertjdominguez

Nov 1, 2023

@CaladoLucas and @kostovaljubica7 — happy to report we found the bug in the way we were parsing the SQL for MySQL (and MariaDB), and a fix was pushed in v2.35.0 that was released yesterday 🚀

When I tested this yesterday afternoon, I found a bug in the UI that may or may not have been merged into this release. If you encounter it, it will be when you click Connect Database — this is/wasn't initialized properly. So, the workaround is to induce a state change by toggling the Advanced Settings dropdown. Then, you can click Connect Database.

Silly, I know — but, hopefully a moot point and fixed by the team already 🎉

Let me know if you run into any issues — otherwise, I'll close this by week's …

View full answer

robertjdominguez · 2023-10-23T15:45:41Z

robertjdominguez
Oct 23, 2023
Maintainer

Hi @CaladoLucas 👋

Sorry someone's just getting to this. Out of curiosity, who is the provider for this database? Answering this will help us help you troubleshoot! 🚀

1 reply

CaladoLucas Nov 1, 2023
Author

is a Mysql database at DigitalOcean

kostovaljubica7 · 2023-11-01T14:28:42Z

kostovaljubica7
Nov 1, 2023

Hello
I have same problem when trying to connect my db (dockerize) selfhosted on Digital Ocean node
Database Server

Server: db.test via TCP/IP
Server type: MariaDB
Server version: 10.5.16-MariaDB-1:10.5.16+maria~focal - mariadb.org binary distribution
Protocol version: 10
User: [email protected]
Server charset: UTF-8 Unicode (utf8mb4)

Node is running on Ubuntu 20.04 (LTS) x64
Docker version 20.10.17

0 replies

robertjdominguez · 2023-11-01T15:30:08Z

robertjdominguez
Nov 1, 2023
Maintainer

@CaladoLucas and @kostovaljubica7 — happy to report we found the bug in the way we were parsing the SQL for MySQL (and MariaDB), and a fix was pushed in v2.35.0 that was released yesterday 🚀

When I tested this yesterday afternoon, I found a bug in the UI that may or may not have been merged into this release. If you encounter it, it will be when you click Connect Database — this is/wasn't initialized properly. So, the workaround is to induce a state change by toggling the Advanced Settings dropdown. Then, you can click Connect Database.

Silly, I know — but, hopefully a moot point and fixed by the team already 🎉

Let me know if you run into any issues — otherwise, I'll close this by week's end.

3 replies

CaladoLucas Nov 1, 2023
Author

I'm trying to use Hasura cloud, it's on v2.34.0-cloud.1, is it possible to force the update?

robertjdominguez Nov 1, 2023
Maintainer

2.35.0-cloud.1 will be deployed early next week.

CaladoLucas Nov 1, 2023
Author

Great! I'll wait! Thank you very much!

liudonghua123 · 2023-12-21T06:53:27Z

liudonghua123
Dec 21, 2023

Similar errors when connect to the eof mysql 5.7.

java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(CONVERT(x'5b5d' USING utf8), '$[*]' COLUMNS(schemaname VARCHAR(255) PATH '$.s',' at line 14
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)
    at io.agroal.pool.wrapper.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:78)
    at io.opentelemetry.instrumentation.jdbc.internal.OpenTelemetryStatement.wrapCall(OpenTelemetryStatement.java:294)
    at io.opentelemetry.instrumentation.jdbc.internal.OpenTelemetryPreparedStatement.executeQuery(OpenTelemetryPreparedStatement.java:60)
    at io.hasura.services.schemaGenerators.MySQLSchemaGenerator.queryDatabase(MySQLSchemaGenerator.kt:106)
    at io.hasura.services.schemaGenerators.BaseSchemaGenerator.getSchema(BaseSchemaGenerator.kt:36)
    at io.hasura.services.dataConnectors.MySQLDataConnectorService.executeGetSchema(MySQLDataConnectorService.kt:65)
    at io.hasura.services.dataConnectors.BaseDataConnectorService.getSchema(BaseDataConnectorService.kt:127)
    at io.hasura.services.dataConnectors.MySQLDataConnectorService_Subclass.getSchema$$superforward(Unknown Source)
    at io.hasura.services.dataConnectors.MySQLDataConnectorService_Subclass$$function$$7.apply(Unknown Source)
    at io.quarkus.arc.impl.AroundInvokeInvocationContext.proceed(AroundInvokeInvocationContext.java:73)
    at io.quarkus.arc.impl.AroundInvokeInvocationContext.proceed(AroundInvokeInvocationContext.java:62)
    at io.quarkus.opentelemetry.runtime.tracing.cdi.WithSpanInterceptor.span(WithSpanInterceptor.java:66)
    at io.quarkus.opentelemetry.runtime.tracing.cdi.WithSpanInterceptor_Bean.intercept(Unknown Source)
    at io.quarkus.arc.impl.InterceptorInvocation.invoke(InterceptorInvocation.java:42)
    at io.quarkus.arc.impl.AroundInvokeInvocationContext.perform(AroundInvokeInvocationContext.java:30)
    at io.quarkus.arc.impl.InvocationContexts.performAroundInvoke(InvocationContexts.java:27)
    at io.hasura.services.dataConnectors.MySQLDataConnectorService_Subclass.getSchema(Unknown Source)
    at io.hasura.controllers.DataConnectorResource.getSchemaWithRequest(DataConnectorResource.kt:106)
    at io.hasura.controllers.DataConnectorResource_Subclass.getSchemaWithRequest$$superforward(Unknown Source)
    at io.hasura.controllers.DataConnectorResource_Subclass$$function$$4.apply(Unknown Source)
    at io.quarkus.arc.impl.AroundInvokeInvocationContext.proceed(AroundInvokeInvocationContext.java:73)
    at io.quarkus.arc.impl.AroundInvokeInvocationContext.proceed(AroundInvokeInvocationContext.java:62)
    at io.quarkus.opentelemetry.runtime.tracing.cdi.WithSpanInterceptor.span(WithSpanInterceptor.java:66)
    at io.quarkus.opentelemetry.runtime.tracing.cdi.WithSpanInterceptor_Bean.intercept(Unknown Source)
    at io.quarkus.arc.impl.InterceptorInvocation.invoke(InterceptorInvocation.java:42)
    at io.quarkus.arc.impl.AroundInvokeInvocationContext.perform(AroundInvokeInvocationContext.java:30)
    at io.quarkus.arc.impl.InvocationContexts.performAroundInvoke(InvocationContexts.java:27)
    at io.hasura.controllers.DataConnectorResource_Subclass.getSchemaWithRequest(Unknown Source)
    at io.hasura.controllers.DataConnectorResource$quarkusrestinvoker$getSchemaWithRequest_23559ea216097e1aa0363aaaee9f7b60beabc35c.invoke(Unknown Source)
    at org.jboss.resteasy.reactive.server.handlers.InvocationHandler.handle(InvocationHandler.java:29)
    at io.quarkus.resteasy.reactive.server.runtime.QuarkusResteasyReactiveRequestContext.invokeHandler(QuarkusResteasyReactiveRequestContext.java:141)
    at org.jboss.resteasy.reactive.common.core.AbstractResteasyReactiveContext.run(AbstractResteasyReactiveContext.java:147)
    at io.quarkus.vertx.core.runtime.VertxCoreRecorder$14.runWith(VertxCoreRecorder.java:582)
    at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
    at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
    at org.jboss.threads.DelegatingRunnable.run(DelegatingRunnable.java:29)
    at org.jboss.threads.ThreadLocalResettingRunnable.run(ThreadLocalResettingRunnable.java:29)
    at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
    at java.base/java.lang.Thread.run(Thread.java:840)

I am just curious about where the error comes from, and I found it's in hasura-data-connector-agent:/app/app/app-1.0.0-SNAPSHOT.jar finally.

4 replies

robertjdominguez Dec 21, 2023
Maintainer

Hi, @liudonghua123 — which version of HGE are you encountering this on?

liudonghua123 Dec 21, 2023

I use version 2.36.0 running via docker, there is an related issue #10066 already. Maybe the SQL could update to compatible with mysql 5.

robertjdominguez Dec 21, 2023
Maintainer

Got it. As @codedmart said in #10066, HGE supports MySQL 8+.

liudonghua123 Dec 22, 2023

@robertjdominguez @codedmart Hi, is the related hasura-data-connector-agent open sourced, so maybe I can make some patches to make it compatible with mysql 5+ locally.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Connect Mysql #9914

{{title}}

Replies: 4 comments 8 replies

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

Select a reply

Connect Mysql #9914

CaladoLucas Oct 2, 2023

Replies: 4 comments · 8 replies

robertjdominguez Oct 23, 2023 Maintainer

CaladoLucas Nov 1, 2023 Author

kostovaljubica7 Nov 1, 2023

robertjdominguez Nov 1, 2023 Maintainer

CaladoLucas Nov 1, 2023 Author

robertjdominguez Nov 1, 2023 Maintainer

CaladoLucas Nov 1, 2023 Author

liudonghua123 Dec 21, 2023

robertjdominguez Dec 21, 2023 Maintainer

liudonghua123 Dec 21, 2023

robertjdominguez Dec 21, 2023 Maintainer

liudonghua123 Dec 22, 2023

CaladoLucas
Oct 2, 2023

Replies: 4 comments 8 replies

robertjdominguez
Oct 23, 2023
Maintainer

CaladoLucas Nov 1, 2023
Author

kostovaljubica7
Nov 1, 2023

robertjdominguez
Nov 1, 2023
Maintainer

CaladoLucas Nov 1, 2023
Author

robertjdominguez Nov 1, 2023
Maintainer

CaladoLucas Nov 1, 2023
Author

liudonghua123
Dec 21, 2023

robertjdominguez Dec 21, 2023
Maintainer

robertjdominguez Dec 21, 2023
Maintainer