Database Not Selected Error Despite Database Being Chosen
matthieukhl opened this issue · 14 comments
matthieukhl commented
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.
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.
EvgeniaBzzz commented
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 commented
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 commented
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 commented
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 commented
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 commented
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 commented
Please check the latest release 24.2.0.
The catalog changing behavior may be correct now.
matthieukhl commented
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 :)