Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Database Not Selected Error Despite Database Being Chosen #2871

Open
matthieukhl opened this issue Aug 22, 2024 · 14 comments
Open

Database Not Selected Error Despite Database Being Chosen #2871

matthieukhl opened this issue Aug 22, 2024 · 14 comments
Assignees

Comments

@matthieukhl
Copy link
Contributor

Context

Our team is encountering an issue where Cloudbeaver does not recognize that a database has been selected, leading to an error that suggests no database is chosen.

The query fails as if no database has been selected, even though the user explicitly chooses a database beforehand (see screenshot below).

This issue occurs intermittently when using the MySQL connector with TiDB.

Restarting the Docker container hosting Cloudbeaver temporarily resolves the issue, but it eventually reoccurs. The database is correctly selected within the UI, yet queries fail with an error stating that no database has been selected.

image

Steps to reproduce

1.	Open Cloudbeaver and access the SQL editor.
2.	Choose the desired database from the dropdown or via USE <database>.
3.	Execute a query (e.g., SELECT * FROM table;).
4.	The query execution fails, returning an error message indicating that no database has been selected.

Logs

Log Snippet When Bug Occurs (After Running a SELECT Query) BEFORE Docker Restart

22-08-2024 14:13:55.474 [qtp1338332733-1031] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
22-08-2024 14:13:55.474 [qtp1338332733-1028] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
22-08-2024 14:13:55.551 [qtp1338332733-1022] DEBUG i.c.server.graphql.GraphQLEndpoint - API > asyncSqlExecuteQuery
22-08-2024 14:13:55.552 [qtp1338332733-1022] DEBUG o.j.d.registry.DataSourceDescriptor - Connect with '<connection_name>' (mysql8-18fc41f9991-1b960a80b59fd6e4)
22-08-2024 14:13:55.553 [qtp1338332733-1022] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Main; 2979)
22-08-2024 14:13:55.600 [qtp1338332733-1022] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
22-08-2024 14:13:55.600 [qtp1338332733-1022] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
22-08-2024 14:13:55.600 [qtp1338332733-1022] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
22-08-2024 14:13:55.600 [qtp1338332733-1022] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
22-08-2024 14:13:55.697 [qtp1338332733-1022] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Metadata; 2980)
22-08-2024 14:13:55.744 [qtp1338332733-1022] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
22-08-2024 14:13:55.744 [qtp1338332733-1022] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
22-08-2024 14:13:55.744 [qtp1338332733-1022] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
22-08-2024 14:13:55.744 [qtp1338332733-1022] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
22-08-2024 14:13:55.965 [qtp1338332733-1022] DEBUG o.j.d.registry.DataSourceDescriptor - Connected (mysql8-18fc41f9991-1b960a80b59fd6e4, MySQL Connector/J [mysql-connector-j-8.2.0 (Revision: 06a1f724497fd81c6a659131fda822c9e5085b6c)])
22-08-2024 14:13:56.060 [qtp1338332733-1023] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
22-08-2024 14:13:56.106 [qtp1338332733-1028] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
22-08-2024 14:13:58.570 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 2979)
22-08-2024 14:13:58.580 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 2980)
22-08-2024 14:13:58.580 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.registry.DataSourceDescriptor - Disconnected (mysql8-18fc41f9991-1b960a80b59fd6e4)

Log Snippet When Running the USE Query BEFORE Docker Restart

22-08-2024 14:15:13.841 [qtp1338332733-1028] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
22-08-2024 14:15:13.841 [qtp1338332733-1023] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
22-08-2024 14:15:13.912 [qtp1338332733-1022] DEBUG i.c.server.graphql.GraphQLEndpoint - API > asyncSqlExecuteQuery
22-08-2024 14:15:13.913 [qtp1338332733-1022] DEBUG o.j.d.registry.DataSourceDescriptor - Connect with '<connection_name>' (mysql8-18fc41f9991-1b960a80b59fd6e4)
22-08-2024 14:15:13.913 [qtp1338332733-1022] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Main; 2981)
22-08-2024 14:15:13.960 [qtp1338332733-1022] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
22-08-2024 14:15:13.960 [qtp1338332733-1022] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
22-08-2024 14:15:13.960 [qtp1338332733-1022] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
22-08-2024 14:15:13.960 [qtp1338332733-1022] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
22-08-2024 14:15:14.043 [qtp1338332733-1022] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Metadata; 2982)
22-08-2024 14:15:14.088 [qtp1338332733-1022] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
22-08-2024 14:15:14.088 [qtp1338332733-1022] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
22-08-2024 14:15:14.088 [qtp1338332733-1022] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
22-08-2024 14:15:14.088 [qtp1338332733-1022] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
22-08-2024 14:15:14.298 [qtp1338332733-1022] DEBUG o.j.d.registry.DataSourceDescriptor - Connected (mysql8-18fc41f9991-1b960a80b59fd6e4, MySQL Connector/J [mysql-connector-j-8.2.0 (Revision: 06a1f724497fd81c6a659131fda822c9e5085b6c)])
22-08-2024 14:15:14.424 [qtp1338332733-1032] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
22-08-2024 14:15:14.473 [qtp1338332733-1028] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getSqlExecuteTaskResults
22-08-2024 14:15:14.520 [qtp1338332733-1022] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
22-08-2024 14:15:14.520 [qtp1338332733-1032] DEBUG i.c.server.graphql.GraphQLEndpoint - API > closeResult
22-08-2024 14:15:17.156 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 2981)
22-08-2024 14:15:17.166 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 2982)
22-08-2024 14:15:17.166 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.registry.DataSourceDescriptor - Disconnected (mysql8-18fc41f9991-1b960a80b59fd6e4)
22-08-2024 14:15:27.440 [qtp1338332733-1017] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getTemplateConnections

Log Snippet AFTER Restarting Docker

22-08-2024 14:16:36.264 [qtp1338332733-38] DEBUG i.c.model.session.WebUserContext - refresh permissions <username> 03c589d5-b3fe-4792-aa55-51e93b97ec62
22-08-2024 14:16:36.267 [qtp1338332733-38] DEBUG i.c.model.session.WebUserContext - refresh permissions <username> 03c589d5-b3fe-4792-aa55-51e93b97ec62
22-08-2024 14:16:38.430 [qtp1338332733-34] DEBUG o.j.d.registry.DataSourceDescriptor - Connect with '<connection_name>' (mysql8-18fc41f9991-1b960a80b59fd6e4)
22-08-2024 14:16:38.464 [qtp1338332733-34] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Main; 0)
22-08-2024 14:16:38.614 [qtp1338332733-34] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
22-08-2024 14:16:38.614 [qtp1338332733-34] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
22-08-2024 14:16:38.614 [qtp1338332733-34] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
22-08-2024 14:16:38.614 [qtp1338332733-34] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
22-08-2024 14:16:39.173 [qtp1338332733-34] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Metadata; 1)
22-08-2024 14:16:39.257 [qtp1338332733-34] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
22-08-2024 14:16:39.257 [qtp1338332733-34] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
22-08-2024 14:16:39.257 [qtp1338332733-34] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
22-08-2024 14:16:39.257 [qtp1338332733-34] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
22-08-2024 14:16:39.417 [qtp1338332733-34] DEBUG o.j.d.model.impl.jdbc.JDBCSQLDialect - Error reading SQL keywords: Table 'information_schema.KEYWORDS' doesn't exist
22-08-2024 14:16:39.586 [qtp1338332733-34] DEBUG o.j.d.registry.DataSourceDescriptor - Connected (mysql8-18fc41f9991-1b960a80b59fd6e4, MySQL Connector/J [mysql-connector-j-8.2.0 (Revision: 06a1f724497fd81c6a659131fda822c9e5085b6c)])
22-08-2024 14:16:39.649 [qtp1338332733-39] DEBUG i.c.server.graphql.GraphQLEndpoint - API > navGetStructContainers
22-08-2024 14:16:39.649 [qtp1338332733-38] DEBUG i.c.server.graphql.GraphQLEndpoint - API > executionContextCreate
22-08-2024 14:16:39.678 [qtp1338332733-32] DEBUG i.c.server.graphql.GraphQLEndpoint - API > executionContextList
22-08-2024 14:16:39.744 [qtp1338332733-33] DEBUG i.c.server.graphql.GraphQLEndpoint - API > querySqlDialectInfo
22-08-2024 14:16:39.745 [qtp1338332733-38] DEBUG i.c.server.graphql.GraphQLEndpoint - API > navGetStructContainers
22-08-2024 14:16:41.829 [qtp1338332733-34] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
22-08-2024 14:16:41.830 [qtp1338332733-39] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
22-08-2024 14:16:41.831 [qtp1338332733-35] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
22-08-2024 14:16:41.867 [qtp1338332733-38] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
22-08-2024 14:16:41.874 [qtp1338332733-33] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
22-08-2024 14:16:41.874 [qtp1338332733-49] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
22-08-2024 14:16:41.876 [qtp1338332733-46] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
22-08-2024 14:16:41.878 [qtp1338332733-37] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
22-08-2024 14:17:01.943 [qtp1338332733-32] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getTemplateConnections
22-08-2024 14:17:01.953 [qtp1338332733-32] DEBUG i.c.s.session.WebSessionManager - New web session 'l5vud7nn8ryp10zd18ibnazkd2'
22-08-2024 14:17:01.953 [qtp1338332733-32] DEBUG i.c.service.WebServiceBindingBase - Anonymous access to getTemplateConnections restricted
22-08-2024 14:17:01.953 [qtp1338332733-32] ERROR i.c.service.WebServiceBindingBase - Unexpected error during gql request

Log Snippet After Running the Same SELECT Query AFTER Docker Restart

22-08-2024 14:17:58.588 [qtp1338332733-47] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
22-08-2024 14:17:58.594 [qtp1338332733-38] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
22-08-2024 14:17:58.645 [qtp1338332733-52] DEBUG i.c.server.graphql.GraphQLEndpoint - API > asyncSqlExecuteQuery
22-08-2024 14:17:58.905 [qtp1338332733-51] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
22-08-2024 14:17:58.950 [qtp1338332733-35] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getSqlExecuteTaskResults
22-08-2024 14:17:59.067 [qtp1338332733-38] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo

Additional Information

We are using the Community Edition of Cloudbeaver with the MySQL connector to connect to our TiDB Cluster.

We are currently running Cloudbeaver 24.1.3 and will update to Cloudbeaver 24.1.5.

Most of our team is using Cloudbeaver on Google Chrome.

Could you please investigate this issue? Thank you.

@matthieukhl matthieukhl added bug Something isn't working wait for review labels Aug 22, 2024
@EvgeniaBzzz
Copy link
Contributor

Hi @matthieukhl
Please try updating your version to 24.1.5 and see if the problem persists.
There may still be consequences from this issue

@matthieukhl
Copy link
Contributor Author

Hi

Thanks for your quick reply. I have updated CloudBeaver to v24.1.5 and will monitor this issue.

I will update this issue in about a week or so to inform you if the described behaviour happened again or not.

@matthieukhl
Copy link
Contributor Author

matthieukhl commented Aug 26, 2024

Hi,

I've reproduced the bug today on Cloudbeaver Community Edition v24.1.5.

Here are the logs when I execute a "USE database" query:

26-08-2024 11:59:06.009 [qtp658563862-277] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getTemplateConnections
26-08-2024 11:59:09.071 [qtp658563862-236] DEBUG i.c.server.graphql.GraphQLEndpoint - API > asyncSqlExecuteQuery
26-08-2024 11:59:09.072 [qtp658563862-236] DEBUG o.j.d.registry.DataSourceDescriptor - Connect with '<connecion_name>' (mysql8-1917e344a69-414fd7d0233665ed)
26-08-2024 11:59:09.072 [qtp658563862-236] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connecion_name>; Main; 512)
26-08-2024 11:59:09.119 [qtp658563862-236] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
26-08-2024 11:59:09.119 [qtp658563862-236] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
26-08-2024 11:59:09.119 [qtp658563862-236] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
26-08-2024 11:59:09.119 [qtp658563862-236] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
26-08-2024 11:59:09.233 [qtp658563862-236] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connecion_name>; Metadata; 513)
26-08-2024 11:59:09.280 [qtp658563862-236] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
26-08-2024 11:59:09.280 [qtp658563862-236] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
26-08-2024 11:59:09.280 [qtp658563862-236] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
26-08-2024 11:59:09.280 [qtp658563862-236] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
26-08-2024 11:59:09.417 [qtp658563862-236] DEBUG o.j.d.registry.DataSourceDescriptor - Connected (mysql8-1917e344a69-414fd7d0233665ed, MySQL Connector/J [mysql-connector-j-8.2.0 (Revision: 06a1f724497fd81c6a659131fda822c9e5085b6c)])
26-08-2024 11:59:09.560 [qtp658563862-273] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
26-08-2024 11:59:09.608 [qtp658563862-277] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getSqlExecuteTaskResults
26-08-2024 11:59:09.613 [DBeaver: Disconnect from '<connecion_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connecion_name>, 512)
26-08-2024 11:59:09.623 [DBeaver: Disconnect from '<connecion_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connecion_name>, 513)
26-08-2024 11:59:09.623 [DBeaver: Disconnect from '<connecion_name>'] DEBUG o.j.d.registry.DataSourceDescriptor - Disconnected (mysql8-1917e344a69-414fd7d0233665ed)
26-08-2024 11:59:09.656 [qtp658563862-236] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
26-08-2024 11:59:09.660 [qtp658563862-273] DEBUG i.c.server.graphql.GraphQLEndpoint - API > closeResult
26-08-2024 11:59:09.660 [qtp658563862-273] DEBUG i.c.server.graphql.GraphQLEndpoint - GraphQL call failed at '/result'
io.cloudbeaver.DBWebException: SQL context not found
	at io.cloudbeaver.service.sql.WebServiceBindingSQL.lambda$13(WebServiceBindingSQL.java:128)
	at graphql.execution.ExecutionStrategy.invokeDataFetcher(ExecutionStrategy.java:327)
	at graphql.execution.ExecutionStrategy.fetchField(ExecutionStrategy.java:304)
	at graphql.execution.ExecutionStrategy.fetchField(ExecutionStrategy.java:242)
	at graphql.execution.ExecutionStrategy.resolveFieldWithInfo(ExecutionStrategy.java:213)
	at graphql.execution.AsyncExecutionStrategy.execute(AsyncExecutionStrategy.java:63)
	at graphql.execution.Execution.executeOperation(Execution.java:162)
	at graphql.execution.Execution.execute(Execution.java:105)
	at graphql.GraphQL.execute(GraphQL.java:557)
	at graphql.GraphQL.lambda$parseValidateAndExecute$11(GraphQL.java:476)
	at java.base/java.util.concurrent.CompletableFuture.uniComposeStage(CompletableFuture.java:1187)
	at java.base/java.util.concurrent.CompletableFuture.thenCompose(CompletableFuture.java:2309)
	at graphql.GraphQL.parseValidateAndExecute(GraphQL.java:471)
	at graphql.GraphQL.executeAsync(GraphQL.java:439)
	at graphql.GraphQL.execute(GraphQL.java:365)
	at io.cloudbeaver.server.graphql.GraphQLEndpoint.executeQuery(GraphQLEndpoint.java:257)
	at io.cloudbeaver.server.graphql.GraphQLEndpoint.executeSingleQuery(GraphQLEndpoint.java:203)
	at io.cloudbeaver.server.graphql.GraphQLEndpoint.doPost(GraphQLEndpoint.java:186)
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:520)
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:587)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:764)
	at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1665)
	at org.eclipse.jetty.websocket.servlet.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:170)
	at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:202)
	at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1635)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:527)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1570)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1381)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:176)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:484)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1543)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:174)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1303)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:129)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122)
	at org.eclipse.jetty.server.Server.handle(Server.java:563)
	at org.eclipse.jetty.server.HttpChannel$RequestDispatchable.dispatch(HttpChannel.java:1598)
	at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:753)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:501)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:287)
	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314)
	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100)
	at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53)
	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:421)
	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:390)
	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:277)
	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.run(AdaptiveExecutionStrategy.java:199)
	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:969)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1194)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1149)
	at java.base/java.lang.Thread.run(Thread.java:840)

Here are the logs when I execute a SELECT query:

26-08-2024 11:59:57.641 [qtp658563862-273] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
26-08-2024 11:59:57.641 [qtp658563862-284] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
26-08-2024 11:59:57.703 [qtp658563862-277] DEBUG i.c.server.graphql.GraphQLEndpoint - API > asyncSqlExecuteQuery
26-08-2024 11:59:57.703 [qtp658563862-277] DEBUG o.j.d.registry.DataSourceDescriptor - Connect with '<connecion_name>' (mysql8-1917e344a69-414fd7d0233665ed)
26-08-2024 11:59:57.704 [qtp658563862-277] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connecion_name>; Main; 514)
26-08-2024 11:59:57.751 [qtp658563862-277] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
26-08-2024 11:59:57.751 [qtp658563862-277] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
26-08-2024 11:59:57.751 [qtp658563862-277] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
26-08-2024 11:59:57.751 [qtp658563862-277] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
26-08-2024 11:59:57.864 [qtp658563862-277] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connecion_name>; Metadata; 515)
26-08-2024 11:59:57.910 [qtp658563862-277] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
26-08-2024 11:59:57.910 [qtp658563862-277] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
26-08-2024 11:59:57.910 [qtp658563862-277] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
26-08-2024 11:59:57.910 [qtp658563862-277] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
26-08-2024 11:59:58.047 [qtp658563862-277] DEBUG o.j.d.registry.DataSourceDescriptor - Connected (mysql8-1917e344a69-414fd7d0233665ed, MySQL Connector/J [mysql-connector-j-8.2.0 (Revision: 06a1f724497fd81c6a659131fda822c9e5085b6c)])
26-08-2024 11:59:58.216 [qtp658563862-236] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
26-08-2024 11:59:58.282 [qtp658563862-273] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
26-08-2024 12:00:01.076 [DBeaver: Disconnect from '<connecion_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connecion_name>, 514)
26-08-2024 12:00:01.086 [DBeaver: Disconnect from '<connecion_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connecion_name>, 515)
26-08-2024 12:00:01.086 [DBeaver: Disconnect from '<connecion_name>'] DEBUG o.j.d.registry.DataSourceDescriptor - Disconnected (mysql8-1917e344a69-414fd7d0233665ed)

Note: if I specify the database in the SELECT query it does run the query correctly

@LonwoLonwo
Copy link
Member

LonwoLonwo commented Aug 26, 2024

Hello.
Please let me know if I am wrong.
Are you trying to use the USE database query instead of the change-default-database-dropdown? Because it doesn't work in CloudBeaver, only in DBeaver. It would be best to use the dropdown to change your default database. Or use the full table name, yes.

@matthieukhl
Copy link
Contributor Author

Hi @LonwoLonwo,

Thanks for taking some time to check in on that issue.

I have been able to effectively execute a USE database statement and then query my database without specifying the database.table_name but only table_name by the past on Cloudbeaver.

Either way, in this particular issue, even selecting the database, or container as it says, in the dropdown menu, it still produces the error.

@LonwoLonwo
Copy link
Member

LonwoLonwo commented Aug 30, 2024

Maybe this case is connected with dbeaver/dbeaver#35040

Waiting for the fix from DBeaver-side. Will see in the 24.2.0 release.

@LonwoLonwo
Copy link
Member

Please check the latest release 24.2.0.
The catalog changing behavior may be correct now.

@matthieukhl
Copy link
Contributor Author

Hi @LonwoLonwo will upgrade to 24.2.0 next week and update this thread. Thanks for your time and for your work, Cloudbeaver is greatly appreciated by our teams :)

@EvgeniaBzzz
Copy link
Contributor

Hi @matthieukhl
Any news here?

@matthieukhl
Copy link
Contributor Author

Hi @EvgeniaBzzz sorry for the late response.

I've asked around the teams, they are still reporting the issue but I haven't had time to investigate the logs. Will share some news as soon as possible.

@matthieukhl
Copy link
Contributor Author

Hi @EvgeniaBzzz

The issue just happened again. Below you'll find logs I've extracted while the issue was happening:

05-11-2024 12:34:49.319 [qtp294505405-95] DEBUG o.j.d.registry.DataSourceDescriptor - Connect with '<connection_name>' (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:34:49.320 [qtp294505405-95] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Main; 33)
05-11-2024 12:34:49.368 [qtp294505405-95] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:34:49.368 [qtp294505405-95] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:34:49.368 [qtp294505405-95] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:34:49.368 [qtp294505405-95] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:34:49.456 [qtp294505405-95] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Metadata; 34)
05-11-2024 12:34:49.505 [qtp294505405-95] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:34:49.505 [qtp294505405-95] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:34:49.505 [qtp294505405-95] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:34:49.505 [qtp294505405-95] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:34:49.594 [qtp294505405-95] DEBUG o.j.d.model.impl.jdbc.JDBCSQLDialect - Error reading SQL keywords: Table 'information_schema.KEYWORDS' doesn't exist
05-11-2024 12:34:50.001 [qtp294505405-95] DEBUG o.j.d.registry.DataSourceDescriptor - Connected (mysql8-18f141d6ffb-52adddd702d0ca41, MySQL Connector/J [mysql-connector-j-8.2.0 (Revision: 06a1f724497fd81c6a659131fda822c9e5085b6c)])
05-11-2024 12:34:50.306 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > querySqlCompletionProposals
05-11-2024 12:34:50.684 [qtp294505405-95] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
05-11-2024 12:34:50.723 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
05-11-2024 12:34:50.743 [qtp294505405-95] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
05-11-2024 12:34:50.794 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > asyncSqlExecuteQuery
05-11-2024 12:34:50.880 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 33)
05-11-2024 12:34:50.891 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 34)
05-11-2024 12:34:50.891 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.registry.DataSourceDescriptor - Disconnected (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:34:51.057 [qtp294505405-95] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
05-11-2024 12:34:51.094 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getSqlExecuteTaskResults
05-11-2024 12:34:51.135 [qtp294505405-95] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
05-11-2024 12:34:51.140 [qtp294505405-109] DEBUG i.c.server.graphql.GraphQLEndpoint - API > closeResult
05-11-2024 12:34:51.141 [qtp294505405-109] DEBUG i.c.server.graphql.GraphQLEndpoint - GraphQL call failed at '/result'
io.cloudbeaver.DBWebException: SQL context not found
	at io.cloudbeaver.service.sql.WebServiceBindingSQL.lambda$13(WebServiceBindingSQL.java:128)
	at graphql.execution.ExecutionStrategy.invokeDataFetcher(ExecutionStrategy.java:327)
	at graphql.execution.ExecutionStrategy.fetchField(ExecutionStrategy.java:304)
	at graphql.execution.ExecutionStrategy.fetchField(ExecutionStrategy.java:242)
	at graphql.execution.ExecutionStrategy.resolveFieldWithInfo(ExecutionStrategy.java:213)
	at graphql.execution.AsyncExecutionStrategy.execute(AsyncExecutionStrategy.java:63)
	at graphql.execution.Execution.executeOperation(Execution.java:162)
	at graphql.execution.Execution.execute(Execution.java:105)
	at graphql.GraphQL.execute(GraphQL.java:557)
	at graphql.GraphQL.lambda$parseValidateAndExecute$11(GraphQL.java:476)
	at java.base/java.util.concurrent.CompletableFuture.uniComposeStage(CompletableFuture.java:1187)
	at java.base/java.util.concurrent.CompletableFuture.thenCompose(CompletableFuture.java:2309)
	at graphql.GraphQL.parseValidateAndExecute(GraphQL.java:471)
	at graphql.GraphQL.executeAsync(GraphQL.java:439)
	at graphql.GraphQL.execute(GraphQL.java:365)
	at io.cloudbeaver.server.graphql.GraphQLEndpoint.executeQuery(GraphQLEndpoint.java:257)
	at io.cloudbeaver.server.graphql.GraphQLEndpoint.executeSingleQuery(GraphQLEndpoint.java:203)
	at io.cloudbeaver.server.graphql.GraphQLEndpoint.doPost(GraphQLEndpoint.java:186)
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:520)
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:587)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:764)
	at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1665)
	at org.eclipse.jetty.websocket.servlet.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:170)
	at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:202)
	at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1635)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:527)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1570)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1381)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:176)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:484)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1543)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:174)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1303)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:129)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122)
	at org.eclipse.jetty.server.Server.handle(Server.java:563)
	at org.eclipse.jetty.server.HttpChannel$RequestDispatchable.dispatch(HttpChannel.java:1598)
	at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:753)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:501)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:287)
	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314)
	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100)
	at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53)
	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:421)
	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:390)
	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:277)
	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.run(AdaptiveExecutionStrategy.java:199)
	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:969)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1194)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1149)
	at java.base/java.lang.Thread.run(Thread.java:840)
05-11-2024 12:34:52.024 [qtp294505405-99] DEBUG i.c.server.graphql.GraphQLEndpoint - API > querySqlCompletionProposals
05-11-2024 12:34:52.025 [qtp294505405-99] DEBUG o.j.d.registry.DataSourceDescriptor - Connect with '<connection_name>' (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:34:52.026 [qtp294505405-99] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Main; 35)
05-11-2024 12:34:52.074 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:34:52.074 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:34:52.074 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:34:52.074 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:34:52.161 [qtp294505405-99] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Metadata; 36)
05-11-2024 12:34:52.208 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:34:52.209 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:34:52.209 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:34:52.209 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:34:52.294 [qtp294505405-99] DEBUG o.j.d.model.impl.jdbc.JDBCSQLDialect - Error reading SQL keywords: Table 'information_schema.KEYWORDS' doesn't exist
05-11-2024 12:34:52.314 [qtp294505405-99] DEBUG o.j.d.registry.DataSourceDescriptor - Connected (mysql8-18f141d6ffb-52adddd702d0ca41, MySQL Connector/J [mysql-connector-j-8.2.0 (Revision: 06a1f724497fd81c6a659131fda822c9e5085b6c)])
05-11-2024 12:34:52.445 [qtp294505405-109] DEBUG i.c.server.graphql.GraphQLEndpoint - API > querySqlCompletionProposals
05-11-2024 12:34:53.831 [qtp294505405-109] DEBUG i.c.server.graphql.GraphQLEndpoint - API > serverConfig
05-11-2024 12:34:53.878 [qtp294505405-106] DEBUG i.c.server.graphql.GraphQLEndpoint - API > openSession
05-11-2024 12:34:53.921 [qtp294505405-109] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getActiveUser
05-11-2024 12:34:53.930 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 35)
05-11-2024 12:34:53.941 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 36)
05-11-2024 12:34:53.941 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.registry.DataSourceDescriptor - Disconnected (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:34:53.989 [qtp294505405-106] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getProductInfo
05-11-2024 12:34:54.055 [qtp294505405-109] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getServerLicenseStatus
05-11-2024 12:34:54.094 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > sessionPermissions
05-11-2024 12:34:54.107 [qtp294505405-106] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getProjectList
05-11-2024 12:34:54.159 [qtp294505405-109] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getTemplateConnections
05-11-2024 12:34:54.159 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getUserConnections
05-11-2024 12:34:54.194 [qtp294505405-95] DEBUG i.c.server.graphql.GraphQLEndpoint - API > navNodeChildren
05-11-2024 12:34:54.229 [qtp294505405-106] DEBUG i.c.server.graphql.GraphQLEndpoint - API > navGetStructContainers
05-11-2024 12:34:54.229 [qtp294505405-111] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getNodeParents
05-11-2024 12:34:54.235 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > driverList
05-11-2024 12:34:54.267 [qtp294505405-109] DEBUG i.c.server.graphql.GraphQLEndpoint - API > navNodeChildren
05-11-2024 12:34:54.351 [qtp294505405-106] DEBUG i.c.server.graphql.GraphQLEndpoint - API > executionContextList
05-11-2024 12:34:54.374 [qtp294505405-95] DEBUG i.c.server.graphql.GraphQLEndpoint - API > navNodeChildren
05-11-2024 12:34:54.374 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > navNodeChildren
05-11-2024 12:34:54.398 [qtp294505405-109] DEBUG i.c.server.graphql.GraphQLEndpoint - API > querySqlDialectInfo
05-11-2024 12:34:54.423 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > executionContextList
05-11-2024 12:34:54.429 [qtp294505405-109] DEBUG i.c.server.graphql.GraphQLEndpoint - API > navGetStructContainers
05-11-2024 12:34:54.461 [qtp294505405-99] DEBUG i.c.server.graphql.GraphQLEndpoint - API > querySqlCompletionProposals
05-11-2024 12:34:54.462 [qtp294505405-99] DEBUG o.j.d.registry.DataSourceDescriptor - Connect with '<connection_name>' (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:34:54.463 [qtp294505405-99] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Main; 37)
05-11-2024 12:34:54.493 [qtp294505405-111] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getNodeParents
05-11-2024 12:34:54.516 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:34:54.516 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:34:54.516 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:34:54.516 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:34:54.601 [qtp294505405-99] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Metadata; 38)
05-11-2024 12:34:54.648 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:34:54.648 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:34:54.648 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:34:54.648 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:34:54.735 [qtp294505405-99] DEBUG o.j.d.model.impl.jdbc.JDBCSQLDialect - Error reading SQL keywords: Table 'information_schema.KEYWORDS' doesn't exist
05-11-2024 12:34:54.796 [qtp294505405-99] DEBUG o.j.d.registry.DataSourceDescriptor - Connected (mysql8-18f141d6ffb-52adddd702d0ca41, MySQL Connector/J [mysql-connector-j-8.2.0 (Revision: 06a1f724497fd81c6a659131fda822c9e5085b6c)])
05-11-2024 12:34:54.866 [qtp294505405-109] DEBUG i.c.server.graphql.GraphQLEndpoint - API > querySqlCompletionProposals
05-11-2024 12:34:55.167 [qtp294505405-99] DEBUG i.c.server.graphql.GraphQLEndpoint - API > querySqlCompletionProposals
05-11-2024 12:34:56.034 [qtp294505405-109] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
05-11-2024 12:34:56.083 [qtp294505405-99] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
05-11-2024 12:34:56.112 [qtp294505405-106] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
05-11-2024 12:34:56.148 [qtp294505405-109] DEBUG i.c.server.graphql.GraphQLEndpoint - API > asyncSqlExecuteQuery
05-11-2024 12:34:56.432 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
05-11-2024 12:34:56.468 [qtp294505405-109] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
05-11-2024 12:34:56.486 [qtp294505405-99] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
05-11-2024 12:34:56.488 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
05-11-2024 12:34:56.488 [qtp294505405-106] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
05-11-2024 12:34:56.488 [qtp294505405-95] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
05-11-2024 12:34:56.489 [qtp294505405-111] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
05-11-2024 12:34:56.516 [qtp294505405-113] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
05-11-2024 12:34:56.517 [qtp294505405-112] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
05-11-2024 12:34:56.525 [qtp294505405-99] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
05-11-2024 12:34:56.527 [qtp294505405-111] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
05-11-2024 12:34:56.931 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 37)
05-11-2024 12:34:56.941 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 38)
05-11-2024 12:34:56.941 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.registry.DataSourceDescriptor - Disconnected (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:34:58.122 [qtp294505405-113] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
05-11-2024 12:34:58.185 [qtp294505405-111] DEBUG i.c.server.graphql.GraphQLEndpoint - API > asyncSqlExecuteQuery
05-11-2024 12:34:58.436 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
05-11-2024 12:34:58.483 [qtp294505405-112] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getSqlExecuteTaskResults
05-11-2024 12:34:58.540 [qtp294505405-109] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
05-11-2024 12:34:58.576 [qtp294505405-113] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getServerResourceQuotas
05-11-2024 12:34:58.914 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > querySqlCompletionProposals
05-11-2024 12:34:58.915 [qtp294505405-98] DEBUG o.j.d.registry.DataSourceDescriptor - Connect with '<connection_name>' (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:34:58.916 [qtp294505405-98] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Main; 39)
05-11-2024 12:34:58.964 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:34:58.964 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:34:58.964 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:34:58.964 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:34:59.050 [qtp294505405-98] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Metadata; 40)
05-11-2024 12:34:59.096 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:34:59.096 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:34:59.096 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:34:59.096 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:34:59.182 [qtp294505405-98] DEBUG o.j.d.model.impl.jdbc.JDBCSQLDialect - Error reading SQL keywords: Table 'information_schema.KEYWORDS' doesn't exist
05-11-2024 12:34:59.228 [qtp294505405-98] DEBUG o.j.d.registry.DataSourceDescriptor - Connected (mysql8-18f141d6ffb-52adddd702d0ca41, MySQL Connector/J [mysql-connector-j-8.2.0 (Revision: 06a1f724497fd81c6a659131fda822c9e5085b6c)])
05-11-2024 12:34:59.563 [qtp294505405-113] DEBUG i.c.server.graphql.GraphQLEndpoint - API > querySqlCompletionProposals
05-11-2024 12:34:59.859 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > querySqlCompletionProposals
05-11-2024 12:34:59.981 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 39)
05-11-2024 12:34:59.992 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 40)
05-11-2024 12:34:59.992 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.registry.DataSourceDescriptor - Disconnected (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:35:00.008 [qtp294505405-113] DEBUG i.c.server.graphql.GraphQLEndpoint - API > querySqlCompletionProposals
05-11-2024 12:35:00.009 [qtp294505405-113] DEBUG o.j.d.registry.DataSourceDescriptor - Connect with '<connection_name>' (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:35:00.010 [qtp294505405-113] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Main; 41)
05-11-2024 12:35:00.059 [qtp294505405-113] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:35:00.060 [qtp294505405-113] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:35:00.060 [qtp294505405-113] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:35:00.060 [qtp294505405-113] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:35:00.146 [qtp294505405-113] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Metadata; 42)
05-11-2024 12:35:00.198 [qtp294505405-113] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:35:00.198 [qtp294505405-113] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:35:00.198 [qtp294505405-113] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:35:00.198 [qtp294505405-113] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:35:00.284 [qtp294505405-113] DEBUG o.j.d.model.impl.jdbc.JDBCSQLDialect - Error reading SQL keywords: Table 'information_schema.KEYWORDS' doesn't exist
05-11-2024 12:35:00.306 [qtp294505405-113] DEBUG o.j.d.registry.DataSourceDescriptor - Connected (mysql8-18f141d6ffb-52adddd702d0ca41, MySQL Connector/J [mysql-connector-j-8.2.0 (Revision: 06a1f724497fd81c6a659131fda822c9e5085b6c)])
05-11-2024 12:35:01.133 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getTemplateConnections
05-11-2024 12:35:01.937 [qtp294505405-111] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
05-11-2024 12:35:01.938 [qtp294505405-113] DEBUG i.c.server.graphql.GraphQLEndpoint - API > executionContextUpdate
05-11-2024 12:35:01.996 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > navGetStructContainers
05-11-2024 12:35:02.009 [qtp294505405-99] DEBUG i.c.server.graphql.GraphQLEndpoint - API > executionContextList
05-11-2024 12:35:02.078 [qtp294505405-111] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getNodeParents
05-11-2024 12:35:03.032 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 41)
05-11-2024 12:35:03.042 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 42)
05-11-2024 12:35:03.042 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.registry.DataSourceDescriptor - Disconnected (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:35:03.534 [qtp294505405-113] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
05-11-2024 12:35:03.535 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
05-11-2024 12:35:03.592 [qtp294505405-111] DEBUG i.c.server.graphql.GraphQLEndpoint - API > asyncSqlExecuteQuery
05-11-2024 12:35:03.593 [qtp294505405-111] DEBUG o.j.d.registry.DataSourceDescriptor - Connect with '<connection_name>' (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:35:03.594 [qtp294505405-111] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Main; 43)
05-11-2024 12:35:03.643 [qtp294505405-111] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:35:03.643 [qtp294505405-111] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:35:03.643 [qtp294505405-111] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:35:03.643 [qtp294505405-111] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:35:03.749 [qtp294505405-111] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Metadata; 44)
05-11-2024 12:35:03.798 [qtp294505405-111] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:35:03.798 [qtp294505405-111] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:35:03.798 [qtp294505405-111] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:35:03.798 [qtp294505405-111] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:35:03.884 [qtp294505405-111] DEBUG o.j.d.model.impl.jdbc.JDBCSQLDialect - Error reading SQL keywords: Table 'information_schema.KEYWORDS' doesn't exist
05-11-2024 12:35:03.940 [qtp294505405-111] DEBUG o.j.d.registry.DataSourceDescriptor - Connected (mysql8-18f141d6ffb-52adddd702d0ca41, MySQL Connector/J [mysql-connector-j-8.2.0 (Revision: 06a1f724497fd81c6a659131fda822c9e5085b6c)])
05-11-2024 12:35:04.094 [qtp294505405-99] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
05-11-2024 12:35:04.131 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getSqlExecuteTaskResults
05-11-2024 12:35:04.170 [qtp294505405-111] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
05-11-2024 12:35:05.283 [qtp294505405-99] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
05-11-2024 12:35:05.322 [qtp294505405-111] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
05-11-2024 12:35:05.322 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
05-11-2024 12:35:05.374 [qtp294505405-113] DEBUG i.c.server.graphql.GraphQLEndpoint - API > asyncSqlExecuteQuery
05-11-2024 12:35:05.633 [qtp294505405-99] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
05-11-2024 12:35:05.671 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
05-11-2024 12:35:06.083 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 43)
05-11-2024 12:35:06.093 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 44)
05-11-2024 12:35:06.093 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.registry.DataSourceDescriptor - Disconnected (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:35:08.154 [qtp294505405-112] DEBUG i.c.server.graphql.GraphQLEndpoint - API > querySqlCompletionProposals
05-11-2024 12:35:08.155 [qtp294505405-112] DEBUG o.j.d.registry.DataSourceDescriptor - Connect with '<connection_name>' (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:35:08.156 [qtp294505405-112] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Main; 45)
05-11-2024 12:35:08.203 [qtp294505405-112] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:35:08.203 [qtp294505405-112] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:35:08.203 [qtp294505405-112] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:35:08.203 [qtp294505405-112] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:35:08.290 [qtp294505405-112] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Metadata; 46)
05-11-2024 12:35:08.337 [qtp294505405-112] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:35:08.337 [qtp294505405-112] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:35:08.337 [qtp294505405-112] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:35:08.337 [qtp294505405-112] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:35:08.421 [qtp294505405-112] DEBUG o.j.d.model.impl.jdbc.JDBCSQLDialect - Error reading SQL keywords: Table 'information_schema.KEYWORDS' doesn't exist
05-11-2024 12:35:08.469 [qtp294505405-112] DEBUG o.j.d.registry.DataSourceDescriptor - Connected (mysql8-18f141d6ffb-52adddd702d0ca41, MySQL Connector/J [mysql-connector-j-8.2.0 (Revision: 06a1f724497fd81c6a659131fda822c9e5085b6c)])
05-11-2024 12:35:09.133 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 45)
05-11-2024 12:35:09.144 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 46)
05-11-2024 12:35:09.144 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.registry.DataSourceDescriptor - Disconnected (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:35:09.343 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > querySqlCompletionProposals
05-11-2024 12:35:09.344 [qtp294505405-98] DEBUG o.j.d.registry.DataSourceDescriptor - Connect with '<connection_name>' (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:35:09.345 [qtp294505405-98] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Main; 47)
05-11-2024 12:35:09.399 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:35:09.399 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:35:09.399 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:35:09.399 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:35:09.486 [qtp294505405-98] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Metadata; 48)
05-11-2024 12:35:09.533 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:35:09.533 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:35:09.533 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:35:09.533 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:35:09.619 [qtp294505405-98] DEBUG o.j.d.model.impl.jdbc.JDBCSQLDialect - Error reading SQL keywords: Table 'information_schema.KEYWORDS' doesn't exist
05-11-2024 12:35:09.640 [qtp294505405-98] DEBUG o.j.d.registry.DataSourceDescriptor - Connected (mysql8-18f141d6ffb-52adddd702d0ca41, MySQL Connector/J [mysql-connector-j-8.2.0 (Revision: 06a1f724497fd81c6a659131fda822c9e5085b6c)])
05-11-2024 12:35:10.811 [qtp294505405-112] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
05-11-2024 12:35:10.846 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
05-11-2024 12:35:10.852 [qtp294505405-99] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
05-11-2024 12:35:10.897 [qtp294505405-112] DEBUG i.c.server.graphql.GraphQLEndpoint - API > asyncSqlExecuteQuery
05-11-2024 12:35:11.155 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
05-11-2024 12:35:11.196 [qtp294505405-99] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
05-11-2024 12:35:12.135 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 47)
05-11-2024 12:35:12.145 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 48)
05-11-2024 12:35:12.145 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.registry.DataSourceDescriptor - Disconnected (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:35:15.194 [qtp294505405-113] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getServerResourceQuotas
05-11-2024 12:35:22.335 [qtp294505405-99] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getTemplateConnections
05-11-2024 12:35:34.286 [qtp294505405-113] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getServerResourceQuotas
05-11-2024 12:35:39.194 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getTemplateConnections
05-11-2024 12:35:43.195 [qtp294505405-99] DEBUG i.c.server.graphql.GraphQLEndpoint - API > querySqlCompletionProposals
05-11-2024 12:35:43.196 [qtp294505405-99] DEBUG o.j.d.registry.DataSourceDescriptor - Connect with '<connection_name>' (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:35:43.197 [qtp294505405-99] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Main; 49)
05-11-2024 12:35:43.244 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:35:43.245 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:35:43.245 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:35:43.245 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:35:43.330 [qtp294505405-99] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Metadata; 50)
05-11-2024 12:35:43.377 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:35:43.377 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:35:43.377 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:35:43.377 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:35:43.463 [qtp294505405-99] DEBUG o.j.d.model.impl.jdbc.JDBCSQLDialect - Error reading SQL keywords: Table 'information_schema.KEYWORDS' doesn't exist
05-11-2024 12:35:43.547 [qtp294505405-99] DEBUG o.j.d.registry.DataSourceDescriptor - Connected (mysql8-18f141d6ffb-52adddd702d0ca41, MySQL Connector/J [mysql-connector-j-8.2.0 (Revision: 06a1f724497fd81c6a659131fda822c9e5085b6c)])
05-11-2024 12:35:44.648 [qtp294505405-112] DEBUG i.c.server.graphql.GraphQLEndpoint - API > querySqlCompletionProposals
05-11-2024 12:35:44.982 [qtp294505405-99] DEBUG i.c.server.graphql.GraphQLEndpoint - API > querySqlCompletionProposals
05-11-2024 12:35:45.542 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 49)
05-11-2024 12:35:45.552 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 50)
05-11-2024 12:35:45.552 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.registry.DataSourceDescriptor - Disconnected (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:35:47.480 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > querySqlCompletionProposals
05-11-2024 12:35:47.481 [qtp294505405-98] DEBUG o.j.d.registry.DataSourceDescriptor - Connect with '<connection_name>' (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:35:47.482 [qtp294505405-98] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Main; 51)
05-11-2024 12:35:47.530 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:35:47.530 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:35:47.530 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:35:47.530 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:35:47.615 [qtp294505405-98] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Metadata; 52)
05-11-2024 12:35:47.664 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:35:47.664 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:35:47.664 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:35:47.664 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:35:47.752 [qtp294505405-98] DEBUG o.j.d.model.impl.jdbc.JDBCSQLDialect - Error reading SQL keywords: Table 'information_schema.KEYWORDS' doesn't exist
05-11-2024 12:35:47.801 [qtp294505405-98] DEBUG o.j.d.registry.DataSourceDescriptor - Connected (mysql8-18f141d6ffb-52adddd702d0ca41, MySQL Connector/J [mysql-connector-j-8.2.0 (Revision: 06a1f724497fd81c6a659131fda822c9e5085b6c)])
05-11-2024 12:35:48.543 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 51)
05-11-2024 12:35:48.553 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 52)
05-11-2024 12:35:48.554 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.registry.DataSourceDescriptor - Disconnected (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:35:49.709 [qtp294505405-99] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
05-11-2024 12:35:50.925 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
05-11-2024 12:35:50.984 [qtp294505405-99] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
05-11-2024 12:35:51.016 [qtp294505405-112] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
05-11-2024 12:35:51.059 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > asyncSqlExecuteQuery
05-11-2024 12:35:51.060 [qtp294505405-98] DEBUG o.j.d.registry.DataSourceDescriptor - Connect with '<connection_name>' (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:35:51.061 [qtp294505405-98] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Main; 53)
05-11-2024 12:35:51.108 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:35:51.108 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:35:51.108 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:35:51.108 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:35:51.193 [qtp294505405-98] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Metadata; 54)
05-11-2024 12:35:51.241 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:35:51.241 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:35:51.241 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:35:51.241 [qtp294505405-98] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:35:51.329 [qtp294505405-98] DEBUG o.j.d.model.impl.jdbc.JDBCSQLDialect - Error reading SQL keywords: Table 'information_schema.KEYWORDS' doesn't exist
05-11-2024 12:35:51.378 [qtp294505405-98] DEBUG o.j.d.registry.DataSourceDescriptor - Connected (mysql8-18f141d6ffb-52adddd702d0ca41, MySQL Connector/J [mysql-connector-j-8.2.0 (Revision: 06a1f724497fd81c6a659131fda822c9e5085b6c)])
05-11-2024 12:35:51.570 [qtp294505405-99] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
05-11-2024 12:35:51.593 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 53)
05-11-2024 12:35:51.604 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 54)
05-11-2024 12:35:51.604 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.registry.DataSourceDescriptor - Disconnected (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:35:51.633 [qtp294505405-112] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getSqlExecuteTaskResults
05-11-2024 12:35:51.683 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
05-11-2024 12:35:55.724 [qtp294505405-99] DEBUG i.c.server.graphql.GraphQLEndpoint - API > querySqlCompletionProposals
05-11-2024 12:35:55.725 [qtp294505405-99] DEBUG o.j.d.registry.DataSourceDescriptor - Connect with '<connection_name>' (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:35:55.726 [qtp294505405-99] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Main; 55)
05-11-2024 12:35:55.774 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:35:55.774 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:35:55.774 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:35:55.774 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:35:55.860 [qtp294505405-99] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Metadata; 56)
05-11-2024 12:35:55.907 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:35:55.907 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:35:55.907 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:35:55.907 [qtp294505405-99] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:35:55.994 [qtp294505405-99] DEBUG o.j.d.model.impl.jdbc.JDBCSQLDialect - Error reading SQL keywords: Table 'information_schema.KEYWORDS' doesn't exist
05-11-2024 12:35:56.041 [qtp294505405-99] DEBUG o.j.d.registry.DataSourceDescriptor - Connected (mysql8-18f141d6ffb-52adddd702d0ca41, MySQL Connector/J [mysql-connector-j-8.2.0 (Revision: 06a1f724497fd81c6a659131fda822c9e5085b6c)])
05-11-2024 12:35:57.012 [qtp294505405-109] DEBUG i.c.server.graphql.GraphQLEndpoint - API > querySqlCompletionProposals
05-11-2024 12:35:57.645 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 55)
05-11-2024 12:35:57.656 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 56)
05-11-2024 12:35:57.656 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.registry.DataSourceDescriptor - Disconnected (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:35:58.342 [qtp294505405-113] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getServerResourceQuotas
05-11-2024 12:35:58.390 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getTemplateConnections
05-11-2024 12:36:01.843 [qtp294505405-112] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLScript
05-11-2024 12:36:01.878 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
05-11-2024 12:36:01.887 [qtp294505405-99] DEBUG i.c.server.graphql.GraphQLEndpoint - API > parseSQLQuery
05-11-2024 12:36:01.915 [qtp294505405-112] DEBUG i.c.server.graphql.GraphQLEndpoint - API > asyncSqlExecuteQuery
05-11-2024 12:36:01.916 [qtp294505405-112] DEBUG o.j.d.registry.DataSourceDescriptor - Connect with '<connection_name>' (mysql8-18f141d6ffb-52adddd702d0ca41)
05-11-2024 12:36:01.917 [qtp294505405-112] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Main; 57)
05-11-2024 12:36:01.965 [qtp294505405-112] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:36:01.965 [qtp294505405-112] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:36:01.965 [qtp294505405-112] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:36:01.965 [qtp294505405-112] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:36:02.050 [qtp294505405-112] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (<connection_name>; Metadata; 58)
05-11-2024 12:36:02.096 [qtp294505405-112] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set autoDeserialize:false
05-11-2024 12:36:02.097 [qtp294505405-112] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowUrlInLocalInfile:false
05-11-2024 12:36:02.097 [qtp294505405-112] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLocalInfile:false
05-11-2024 12:36:02.097 [qtp294505405-112] DEBUG o.j.d.e.mysql.model.MySQLDataSource - Set allowLoadLocalInfile:false
05-11-2024 12:36:02.182 [qtp294505405-112] DEBUG o.j.d.model.impl.jdbc.JDBCSQLDialect - Error reading SQL keywords: Table 'information_schema.KEYWORDS' doesn't exist
05-11-2024 12:36:02.232 [qtp294505405-112] DEBUG o.j.d.registry.DataSourceDescriptor - Connected (mysql8-18f141d6ffb-52adddd702d0ca41, MySQL Connector/J [mysql-connector-j-8.2.0 (Revision: 06a1f724497fd81c6a659131fda822c9e5085b6c)])
05-11-2024 12:36:02.423 [qtp294505405-98] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
05-11-2024 12:36:02.462 [qtp294505405-99] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAsyncTaskInfo
05-11-2024 12:36:03.747 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 57)
05-11-2024 12:36:03.757 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (<connection_name>, 58)
05-11-2024 12:36:03.757 [DBeaver: Disconnect from '<connection_name>'] DEBUG o.j.d.registry.DataSourceDescriptor - Disconnected (mysql8-18f141d6ffb-52adddd702d0ca41)

@EvgeniaBzzz
Copy link
Contributor

I see 😞
We need some extra time to investigate your issue

@DenisSinelnikov
Copy link
Contributor

Hi @matthieukhl,

I am trying to figure out your problem, but I have not been able to reproduce it. I would like to clarify the following things:

  1. Please provide the database and the version you are using,
  2. Can you provide full connection settings of your database (an example similar to yours)?
  3. How do you connect to the database? (Login/Password, SSH?).
  4. You say the problem occurs intermittently, does it occur after some specific actions, or does it occur randomly?

@matthieukhl
Copy link
Contributor Author

Hi @DenisSinelnikov thanks for taking some time to look into this issue.

  1. We are using the MySQL connector of Cloudbeaver Community Edition to connect to TiDB 7.5.2.
  2. hostname, port, username, password, require ssl, ca cert, client cert, client key
  3. We connect with login, password and SSL
  4. The problem seems to mostly happen after a certain period of time using Cloudbeaver.

I hope this satisfies your questions :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants