dbeaver / dbeaver/cloudbeaver

Database Not Selected Error Despite Database Being Chosen

Open
#2,871 14 comments 0 reactions 0 assignees View on GitHub
wait for review xf:connection xf:sql editor
Dominant language
TypeScript
Stars
5.1k
Forks
563
Avg merge
3d 9h
Merged PRs (30d)
59

Description

# 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](https://github.com/user-attachments/assets/1c57a0b3-5a75-4e4a-a3d0-61e2f7254960)

## Steps to reproduce
1. Open Cloudbeaver and access the SQL editor.
2. Choose the desired database from the dropdown or via USE .
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 '' (mysql8-18fc41f9991-1b960a80b59fd6e4)
22-08-2024 14:13:55.553 [qtp1338332733-1022] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (; 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 (; 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 ''] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (, 2979)
22-08-2024 14:13:58.580 [DBeaver: Disconnect from ''] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (, 2980)
22-08-2024 14:13:58.580 [DBeaver: Disconnect from ''] 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 '' (mysql8-18fc41f9991-1b960a80b59fd6e4)
22-08-2024 14:15:13.913 [qtp1338332733-1022] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (; 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 (; 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 ''] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (, 2981)
22-08-2024 14:15:17.166 [DBeaver: Disconnect from ''] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context closed (, 2982)
22-08-2024 14:15:17.166 [DBeaver: Disconnect from ''] 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 03c589d5-b3fe-4792-aa55-51e93b97ec62
22-08-2024 14:16:36.267 [qtp1338332733-38] DEBUG i.c.model.session.WebUserContext - refresh permissions 03c589d5-b3fe-4792-aa55-51e93b97ec62
22-08-2024 14:16:38.430 [qtp1338332733-34] DEBUG o.j.d.registry.DataSourceDescriptor - Connect with '' (mysql8-18fc41f9991-1b960a80b59fd6e4)
22-08-2024 14:16:38.464 [qtp1338332733-34] DEBUG o.j.d.m.i.AbstractExecutionContext - Execution context opened (; 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 (; 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.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.