zhangwei1989 commented on issue #8525:
URL: https://github.com/apache/shardingsphere/issues/8525#issuecomment-741719682


   Hi @tristaZero ,
   
   The relative log is shown below:
   
   ```
   [INFO ] 19:42:07.377 [main] ShardingSphere-metadata - Loading 2 tables' meta 
data for unconfigured tables.
   [INFO ] 19:42:07.388 [main] ShardingSphere-metadata - Loading 2 tables' meta 
data for unconfigured tables.
   [INFO ] 19:42:07.390 [main] ShardingSphere-metadata - Loading 2 tables' meta 
data for unconfigured tables.
   [INFO ] 19:42:07.397 [main] ShardingSphere-metadata - Loading 2 tables' meta 
data for unconfigured tables.
   [INFO ] 19:42:07.399 [main] ShardingSphere-metadata - Loading 2 tables' meta 
data for unconfigured tables.
   [INFO ] 19:42:07.400 [main] ShardingSphere-metadata - Loading 2 tables' meta 
data for unconfigured tables.
   [INFO ] 19:42:07.408 [main] o.a.s.i.c.s.SchemaContextsBuilder - Load meta 
data for schema replica_query_db finished, cost 97 milliseconds.
   Thanks for using Atomikos! Evaluate 
http://www.atomikos.com/Main/ExtremeTransactions for advanced features and 
professional support
   or register at http://www.atomikos.com/Main/RegisterYourDownload to disable 
this message and receive FREE tips & advice
   [INFO ] 19:42:07.764 [main] o.a.s.p.i.i.AbstractBootstrapInitializer - 
Database name is `MySQL`, version is `5.7.32-log`
   [INFO ] 19:42:08.062 [main] o.a.s.p.frontend.ShardingSphereProxy - 
ShardingSphere-Proxy start success.
   [INFO ] 19:42:38.337 [ShardingSphere-Command-5] ShardingSphere-SQL - Logic 
SQL: show tables
   [INFO ] 19:42:38.337 [ShardingSphere-Command-5] ShardingSphere-SQL - 
SQLStatement: MySQLShowTablesStatement(fromSchema=Optional.empty)
   [INFO ] 19:42:38.337 [ShardingSphere-Command-5] ShardingSphere-SQL - Actual 
SQL: pr_ds ::: show tables
   [ERROR] 19:42:38.351 [ShardingSphere-Command-5] 
o.a.s.p.f.c.CommandExecutorTask - Exception occur:
   java.lang.NullPointerException: Can not get connection from datasource pr_ds.
        at 
com.google.common.base.Preconditions.checkNotNull(Preconditions.java:987)
        at 
org.apache.shardingsphere.proxy.backend.communication.jdbc.datasource.JDBCBackendDataSource.getConnections(JDBCBackendDataSource.java:80)
        at 
org.apache.shardingsphere.proxy.backend.communication.jdbc.datasource.JDBCBackendDataSource.getConnections(JDBCBackendDataSource.java:62)
        at 
org.apache.shardingsphere.proxy.backend.communication.jdbc.connection.BackendConnection.getConnectionsWithoutTransaction(BackendConnection.java:141)
        at 
org.apache.shardingsphere.proxy.backend.communication.jdbc.connection.BackendConnection.getConnections(BackendConnection.java:102)
        at 
org.apache.shardingsphere.infra.executor.sql.resourced.group.ResourceManagedExecuteGroupEngine.generateSQLExecuteGroups(ResourceManagedExecuteGroupEngine.java:66)
        at 
org.apache.shardingsphere.infra.executor.sql.group.AbstractExecuteGroupEngine.generate(AbstractExecuteGroupEngine.java:58)
        at 
org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.JDBCExecuteEngine.generateInputGroups(JDBCExecuteEngine.java:140)
        at 
org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.JDBCExecuteEngine.executeWithManagedResource(JDBCExecuteEngine.java:130)
        at 
org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.JDBCExecuteEngine.execute(JDBCExecuteEngine.java:123)
        at 
org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.JDBCExecuteEngine.execute(JDBCExecuteEngine.java:103)
        at 
org.apache.shardingsphere.proxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.doExecute(JDBCDatabaseCommunicationEngine.java:93)
        at 
org.apache.shardingsphere.proxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.execute(JDBCDatabaseCommunicationEngine.java:79)
        at 
org.apache.shardingsphere.proxy.backend.text.admin.ShowTablesBackendHandler.execute(ShowTablesBackendHandler.java:65)
        at 
org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.execute(MySQLComQueryPacketExecutor.java:62)
        at 
org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:100)
        at 
org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:76)
        at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
   [INFO ] 19:42:43.098 [ShardingSphere-Command-6] ShardingSphere-SQL - Logic 
SQL: show tables
   [INFO ] 19:42:43.099 [ShardingSphere-Command-6] ShardingSphere-SQL - 
SQLStatement: MySQLShowTablesStatement(fromSchema=Optional.empty)
   [INFO ] 19:42:43.099 [ShardingSphere-Command-6] ShardingSphere-SQL - Actual 
SQL: pr_ds ::: show tables
   [ERROR] 19:42:43.100 [ShardingSphere-Command-6] 
o.a.s.p.f.c.CommandExecutorTask - Exception occur:
   java.lang.NullPointerException: Can not get connection from datasource pr_ds.
        at 
com.google.common.base.Preconditions.checkNotNull(Preconditions.java:987)
        at 
org.apache.shardingsphere.proxy.backend.communication.jdbc.datasource.JDBCBackendDataSource.getConnections(JDBCBackendDataSource.java:80)
        at 
org.apache.shardingsphere.proxy.backend.communication.jdbc.datasource.JDBCBackendDataSource.getConnections(JDBCBackendDataSource.java:62)
        at 
org.apache.shardingsphere.proxy.backend.communication.jdbc.connection.BackendConnection.getConnectionsWithoutTransaction(BackendConnection.java:141)
        at 
org.apache.shardingsphere.proxy.backend.communication.jdbc.connection.BackendConnection.getConnections(BackendConnection.java:102)
        at 
org.apache.shardingsphere.infra.executor.sql.resourced.group.ResourceManagedExecuteGroupEngine.generateSQLExecuteGroups(ResourceManagedExecuteGroupEngine.java:66)
        at 
org.apache.shardingsphere.infra.executor.sql.group.AbstractExecuteGroupEngine.generate(AbstractExecuteGroupEngine.java:58)
        at 
org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.JDBCExecuteEngine.generateInputGroups(JDBCExecuteEngine.java:140)
        at 
org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.JDBCExecuteEngine.executeWithManagedResource(JDBCExecuteEngine.java:130)
        at 
org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.JDBCExecuteEngine.execute(JDBCExecuteEngine.java:123)
        at 
org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.JDBCExecuteEngine.execute(JDBCExecuteEngine.java:103)
        at 
org.apache.shardingsphere.proxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.doExecute(JDBCDatabaseCommunicationEngine.java:93)
        at 
org.apache.shardingsphere.proxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.execute(JDBCDatabaseCommunicationEngine.java:79)
        at 
org.apache.shardingsphere.proxy.backend.text.admin.ShowTablesBackendHandler.execute(ShowTablesBackendHandler.java:65)
        at 
org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.execute(MySQLComQueryPacketExecutor.java:62)
        at 
org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:100)
        at 
org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:76)
        at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
   ```


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to