shardingsphere icon indicating copy to clipboard operation
shardingsphere copied to clipboard

NPE occurs when execute show table status

Open RaigorJiang opened this issue 1 year ago • 0 comments

Bug Report

Which version of ShardingSphere did you use?

5.5.1-SNAPSHOT master e55969073952e82c9192f1876d48bec3dba511c6

Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?

ShardingSphere-Proxy

Actual behavior

  • Client
mysql> show table status;
ERROR 30000 (HY000): Unknown exception.
More details: java.lang.NullPointerException: Cannot invoke "java.math.BigInteger.add(java.math.BigInteger)" because "num1" is null
mysql> 
  • Proxy log
[INFO ] 2024-08-26 18:04:06.880 [ShardingSphere-Command-0] ShardingSphere-SQL - Logic SQL: show table status
[INFO ] 2024-08-26 18:04:06.880 [ShardingSphere-Command-0] ShardingSphere-SQL - Actual SQL: ds_1 ::: show table status
[INFO ] 2024-08-26 18:04:06.880 [ShardingSphere-Command-0] ShardingSphere-SQL - Actual SQL: ds_0 ::: show table status
[ERROR] 2024-08-26 18:04:07.089 [ShardingSphere-Command-0] o.a.s.p.f.c.CommandExecutorTask - Exception occur: 
java.lang.NullPointerException: Cannot invoke "java.math.BigInteger.add(java.math.BigInteger)" because "num1" is null
	at org.apache.shardingsphere.sharding.merge.dal.show.ShowTableStatusMergedResult.sum(ShowTableStatusMergedResult.java:77)
	at org.apache.shardingsphere.sharding.merge.dal.show.ShowTableStatusMergedResult.merge(ShowTableStatusMergedResult.java:68)
	at org.apache.shardingsphere.sharding.merge.dal.show.ShowTableStatusMergedResult.init(ShowTableStatusMergedResult.java:58)
	at org.apache.shardingsphere.sharding.merge.dal.show.ShowTableStatusMergedResult.init(ShowTableStatusMergedResult.java:39)
	at org.apache.shardingsphere.infra.merge.result.impl.memory.MemoryMergedResult.<init>(MemoryMergedResult.java:57)
	at org.apache.shardingsphere.sharding.merge.dal.show.ShowTableStatusMergedResult.<init>(ShowTableStatusMergedResult.java:43)
	at org.apache.shardingsphere.sharding.merge.dal.ShardingDALResultMerger.merge(ShardingDALResultMerger.java:71)
	at org.apache.shardingsphere.infra.merge.MergeEngine.executeMerge(MergeEngine.java:88)
	at org.apache.shardingsphere.infra.merge.MergeEngine.merge(MergeEngine.java:78)
	at org.apache.shardingsphere.proxy.backend.connector.DatabaseConnector.mergeQuery(DatabaseConnector.java:320)
	at org.apache.shardingsphere.proxy.backend.connector.DatabaseConnector.processExecuteQuery(DatabaseConnector.java:290)
	at org.apache.shardingsphere.proxy.backend.connector.DatabaseConnector.doExecute(DatabaseConnector.java:251)
	at org.apache.shardingsphere.proxy.backend.connector.DatabaseConnector.execute(DatabaseConnector.java:199)
	at org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.execute(MySQLComQueryPacketExecutor.java:86)
	at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.doExecuteCommand(CommandExecutorTask.java:126)
	at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:121)
	at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:78)

RaigorJiang avatar Aug 26 '24 10:08 RaigorJiang