[GitHub] [shardingsphere] RaigorJiang opened a new issue, #22183: NPE when select from `shardingsphere.sharding_table_statistics`

[GitBox <gi...@apache.org>]

RaigorJiang opened a new issue, #22183:
URL: https://github.com/apache/shardingsphere/issues/22183

   ## Bug Report
   ### Which version of ShardingSphere did you use?
   master a1de9c34
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   
   ### Expected behavior
   select from shardingsphere.sharding_table_statistics can get correct results
   
   ### Actual behavior
   ```sql
   mysql> show tables;
   +---------------------------+------------+
   | Tables_in_shardingsphere  | Table_type |
   +---------------------------+------------+
   | sharding_table_statistics | BASE TABLE |
   +---------------------------+------------+
   1 row in set (0.00 sec)
   
   mysql> select * from sharding_table_statistics;
   ERROR 30000 (HY000): Unknown exception: null
   ```
   
   Log
   ```
   java.util.NoSuchElementException: null
   	at java.util.LinkedHashMap$LinkedHashIterator.nextNode(LinkedHashMap.java:721)
   	at java.util.LinkedHashMap$LinkedValueIterator.next(LinkedHashMap.java:747)
   	at org.apache.shardingsphere.infra.rewrite.engine.GenericSQLRewriteEngine.rewrite(GenericSQLRewriteEngine.java:50)
   	at org.apache.shardingsphere.infra.rewrite.SQLRewriteEntry.rewrite(SQLRewriteEntry.java:78)
   	at org.apache.shardingsphere.infra.context.kernel.KernelProcessor.rewrite(KernelProcessor.java:65)
   	at org.apache.shardingsphere.infra.context.kernel.KernelProcessor.generateExecutionContext(KernelProcessor.java:52)
   	at org.apache.shardingsphere.proxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.execute(JDBCDatabaseCommunicationEngine.java:125)
   	at org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.fieldlist.MySQLComFieldListPacketExecutor.execute(MySQLComFieldListPacketExecutor.java:74)
   	at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:111)
   	at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:78)
   	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)
   
   ```
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   1. Start Proxy
   2. Use shardingsphere;
   3. select * from sharding_table_statistics;
   


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] strongduanmu closed issue #22183: NPE when select from `shardingsphere.sharding_table_statistics`

["strongduanmu (via GitHub)" <gi...@apache.org>]

strongduanmu closed issue #22183: NPE when select from `shardingsphere.sharding_table_statistics`
URL: https://github.com/apache/shardingsphere/issues/22183


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org