duzhanfei commented on issue #8913:
URL: https://github.com/apache/shardingsphere/issues/8913#issuecomment-755925003
sql:
INSERT INTO PBCST_QRY_INFO (
ECIF_CUST_NO,
CUST_APLTN,
CUST_TYP_CD,
MP_NBR,
CTFTP_CD,
CRTF_NBR,
BLTO_PROV_ADMDV_CD,
BLTO_CITY_ADMDV_CD,
BLTO_DSTCY_ADMDV_CD,
CUST_ADDR
)
VALUES
('642054011658', '梅', '01', '1219123', '111', '6106060118', null, null,
null, null)
log：
[INFO ] 14:51:32.907 [pool-79-thread-1] ShardingSphere-SQL - Logic SQL: SET
PROFILING=1;
[INFO ] 14:51:32.907 [pool-79-thread-1] ShardingSphere-SQL - SQLStatement:
MySQLSetStatement()
[INFO ] 14:51:32.907 [pool-79-thread-1] ShardingSphere-SQL - Actual SQL:
ds_0 ::: SET PROFILING=1;
[INFO ] 14:51:32.907 [pool-79-thread-1] ShardingSphere-SQL - Actual SQL:
ds_1 ::: SET PROFILING=1;
[INFO ] 14:51:32.907 [pool-79-thread-1] ShardingSphere-SQL - Actual SQL:
ds_2 ::: SET PROFILING=1;
[INFO ] 14:51:32.907 [pool-79-thread-1] ShardingSphere-SQL - Actual SQL:
ds_3 ::: SET PROFILING=1;
[INFO ] 14:51:32.926 [pool-79-thread-1] ShardingSphere-SQL - Logic SQL: SHOW
STATUS
[INFO ] 14:51:32.926 [pool-79-thread-1] ShardingSphere-SQL - SQLStatement:
MySQLShowOtherStatement()
[INFO ] 14:51:32.926 [pool-79-thread-1] ShardingSphere-SQL - Actual SQL:
ds_0 ::: SHOW STATUS
[INFO ] 14:51:32.940 [pool-79-thread-1] ShardingSphere-SQL - Logic SQL: SHOW
STATUS
[INFO ] 14:51:32.940 [pool-79-thread-1] ShardingSphere-SQL - SQLStatement:
MySQLShowOtherStatement()
[INFO ] 14:51:32.940 [pool-79-thread-1] ShardingSphere-SQL - Actual SQL:
ds_0 ::: SHOW STATUS
[ERROR] 14:51:33.080 [pool-79-thread-1] o.a.s.p.f.c.CommandExecutorTask -
Exception occur:
java.lang.NullPointerException: Cannot invoke method hashCode() on null
object
at
org.codehaus.groovy.runtime.NullObject.hashCode(NullObject.java:174)
at org.codehaus.groovy.runtime.NullObject$hashCode.call(Unknown
Source)
at
org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47)
at
org.codehaus.groovy.runtime.callsite.NullCallSite.call(NullCallSite.java:34)
at
org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47)
at java_lang_String$hashCode.call(Unknown Source)
at Script40$_run_closure1.doCall(Script40.groovy:1)
at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:98)
at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:325)
at
org.codehaus.groovy.runtime.metaclass.ClosureMetaClass.invokeMethod(ClosureMetaClass.java:264)
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1034)
at groovy.lang.Closure.call(Closure.java:420)
at groovy.lang.Closure.call(Closure.java:414)
at
org.apache.shardingsphere.sharding.algorithm.sharding.inline.InlineShardingAlgorithm.doSharding(InlineShardingAlgorithm.java:69)
at
org.apache.shardingsphere.sharding.route.strategy.type.standard.StandardShardingStrategy.doSharding(StandardShardingStrategy.java:67)
at
org.apache.shardingsphere.sharding.route.strategy.type.standard.StandardShardingStrategy.doSharding(StandardShardingStrategy.java:56)
at
org.apache.shardingsphere.sharding.route.engine.type.standard.ShardingStandardRoutingEngine.routeDataSources(ShardingStandardRoutingEngine.java:203)
at
org.apache.shardingsphere.sharding.route.engine.type.standard.ShardingStandardRoutingEngine.route0(ShardingStandardRoutingEngine.java:191)
at
org.apache.shardingsphere.sharding.route.engine.type.standard.ShardingStandardRoutingEngine.routeByShardingConditionsWithCondition(ShardingStandardRoutingEngine.java:114)
at
org.apache.shardingsphere.sharding.route.engine.type.standard.ShardingStandardRoutingEngine.routeByShardingConditions(ShardingStandardRoutingEngine.java:107)
at
org.apache.shardingsphere.sharding.route.engine.type.standard.ShardingStandardRoutingEngine.getDataNodes(ShardingStandardRoutingEngine.java:84)
at
org.apache.shardingsphere.sharding.route.engine.type.standard.ShardingStandardRoutingEngine.route(ShardingStandardRoutingEngine.java:69)
at
org.apache.shardingsphere.sharding.route.engine.ShardingSQLRouter.createRouteContext(ShardingSQLRouter.java:70)
at
org.apache.shardingsphere.sharding.route.engine.ShardingSQLRouter.createRouteContext(ShardingSQLRouter.java:55)
at
org.apache.shardingsphere.infra.route.engine.impl.PartialSQLRouteExecutor.route(PartialSQLRouteExecutor.java:59)
at
org.apache.shardingsphere.infra.route.engine.SQLRouteEngine.route(SQLRouteEngine.java:57)
at
org.apache.shardingsphere.infra.context.kernel.KernelProcessor.generateExecutionContext(KernelProcessor.java:52)
at
org.apache.shardingsphere.proxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.execute(JDBCDatabaseCommunicationEngine.java:77)
at
org.apache.shardingsphere.proxy.backend.text.query.QueryBackendHandler.execute(QueryBackendHandler.java:61)
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 ] 14:51:42.764 [pool-73-thread-1] ShardingSphere-SQL - Logic SQL:
SELECT @@session.transaction_read_only
[INFO ] 14:51:42.764 [pool-73-thread-1] ShardingSphere-SQL - SQLStatement:
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty)
[INFO ] 14:51:42.764 [pool-73-thread-1] ShardingSphere-SQL - Actual SQL:
ds_0 ::: SELECT @@session.transaction_read_only
[ERROR] 14:51:42.767 [pool-73-thread-1] o.a.s.p.f.c.CommandExecutorTask -
Exception occur:
java.lang.NullPointerException: Cannot invoke method hashCode() on null
object
at
org.codehaus.groovy.runtime.NullObject.hashCode(NullObject.java:174)
at org.codehaus.groovy.runtime.NullObject$hashCode.call(Unknown
Source)
at
org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47)
at
org.codehaus.groovy.runtime.callsite.NullCallSite.call(NullCallSite.java:34)
at
org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47)
at org.codehaus.groovy.runtime.NullObject$hashCode.call(Unknown
Source)
at Script40$_run_closure1.doCall(Script40.groovy:1)
at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:98)
at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:325)
at
org.codehaus.groovy.runtime.metaclass.ClosureMetaClass.invokeMethod(ClosureMetaClass.java:264)
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1034)
at groovy.lang.Closure.call(Closure.java:420)
at groovy.lang.Closure.call(Closure.java:414)
at
org.apache.shardingsphere.sharding.algorithm.sharding.inline.InlineShardingAlgorithm.doSharding(InlineShardingAlgorithm.java:69)
at
org.apache.shardingsphere.sharding.route.strategy.type.standard.StandardShardingStrategy.doSharding(StandardShardingStrategy.java:67)
at
org.apache.shardingsphere.sharding.route.strategy.type.standard.StandardShardingStrategy.doSharding(StandardShardingStrategy.java:56)
at
org.apache.shardingsphere.sharding.route.engine.type.standard.ShardingStandardRoutingEngine.routeDataSources(ShardingStandardRoutingEngine.java:203)
at
org.apache.shardingsphere.sharding.route.engine.type.standard.ShardingStandardRoutingEngine.route0(ShardingStandardRoutingEngine.java:191)
----------------------------------------------------------------
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]
