You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/04/07 03:25:58 UTC
[GitHub] [shardingsphere] farawayliu opened a new issue #9956: NullPointerException occurred while executing "INSERT", but the execution of "SELECT" worked properly
farawayliu opened a new issue #9956:
URL: https://github.com/apache/shardingsphere/issues/9956
## Bug Report
**For English only**, other languages will not accept.
Before report a bug, make sure you have:
- Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
- Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
Please pay attention on issues you submitted, because we maybe need more details.
If no response anymore and we cannot reproduce it on current information, we will **close it**.
Please answer these questions before submitting your issue. Thanks!
### Which version of ShardingSphere did you use?
org.apache.shardingsphere:sharding-jdbc-core:4.1.1
com.alibaba:druid-spring-boot-starter:1.1.10
org.mybatis.spring.boot:mybatis-spring-boot-starter:1.3.2
#### java config
```
@Configuration
public class DataSourceConfig {
public DataSource getDuridDataSource() {
DruidDataSource pool = new DruidDataSource();
// pool.set.....
return pool;
}
@Bean(name = "shardingDataSource")
public DataSource getShardingDataSource() throws SQLException {
DataSource druidDataSource = getDuridDataSource();
ShardingRuleConfiguration shardingRuleConfig = new ShardingRuleConfiguration();
shardingRuleConfig.getTableRuleConfigs().add(policyRule());
Map<String, DataSource> result = new HashMap<>();
result.put("ds0", druidDataSource);
Properties props = new Properties();
props.setProperty("sql.show", "true");
return ShardingDataSourceFactory.createDataSource(result, shardingRuleConfig, props);
}
private TableRuleConfiguration policyRule() {
TableRuleConfiguration dp_original_policy = new TableRuleConfiguration("dp_original_policy", "ds0.dp_original_policy_${0000..9999}");
dp_original_policy.setDatabaseShardingStrategyConfig(new NoneShardingStrategyConfiguration());
dp_original_policy.setTableShardingStrategyConfig(new StandardShardingStrategyConfiguration("INS_COMPANY_CODE", new PolicyShardingAlgorithm()));
return dp_original_policy;
}
}
```
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Expected behavior
“INSERT” is working properly
### Actual behavior
throw excpetion：
```
2021-04-07 10:50:31,359 DEBUG [main] com.xinji.directpayment.dao.mapper.DpOriginalPolicyDOMapperExt.insertSelective (BaseJdbcLogger.java:159) ==> Preparing: insert into dp_original_policy ( IS_DELETED, CREATOR, MODIFIER, GMT_MODIFIED, GMT_CREATE, POLICY_JSON, POLICY_NO, INS_COMPANY_CODE, INSURED_CERT_NO, INSURED_NAME, INSURED_PHONE, POLICY_STATUS, IS_REGISTER, VERSION, DELETE_PK, POLICY_UNIQUE_NO, CHANNEL, GMT_PUSH ) values ( 'n', 'system', 'system', current_timestamp, current_timestamp, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
2021-04-07 10:50:31,378 DEBUG [main] com.xinji.directpayment.dao.mapper.DpOriginalPolicyDOMapperExt.insertSelective (BaseJdbcLogger.java:159) ==> Parameters: test_content(String), test_content(String), test_content(String), test_content(String), test_content(String), test_content(String), 001(String), n(String), test_content(String), 0(Long), test_content(String), T(String), 2021-04-07 10:50:31.354(Timestamp)
line 71:25 no viable alternative at input 'current_timestamp,'
line 71:25 no viable alternative at input 'current_timestamp,'
line 74:25 no viable alternative at input 'current_timestamp,'
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: java.lang.NullPointerException
### The error may involve com.xinji.directpayment.dao.mapper.DpOriginalPolicyDOMapperExt.insertSelective-Inline
### The error occurred while setting parameters
### SQL: insert into dp_original_policy ( IS_DELETED, CREATOR, MODIFIER, GMT_MODIFIED, GMT_CREATE, POLICY_JSON, POLICY_NO, INS_COMPANY_CODE, INSURED_CERT_NO, INSURED_NAME, INSURED_PHONE, POLICY_STATUS, IS_REGISTER, VERSION, DELETE_PK, POLICY_UNIQUE_NO, CHANNEL, GMT_PUSH ) values ( 'n', 'system', 'system', current_timestamp, current_timestamp, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
### Cause: java.lang.NullPointerException
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
at com.sun.proxy.$Proxy139.insert(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:58)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.$Proxy192.insertSelective(Unknown Source)
at com.xinji.directpayment.web.dao.ShardingTest.insertData(ShardingTest.java:111)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.springframework.test.context.junit4.statements.RunBeforeTestExecutionCallbacks.evaluate(RunBeforeTestExecutionCallbacks.java:73)
at org.springframework.test.context.junit4.statements.RunAfterTestExecutionCallbacks.evaluate(RunAfterTestExecutionCallbacks.java:83)
at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)
at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)
at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:251)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:97)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:190)
at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)
at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33)
at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:220)
at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:53)
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: java.lang.NullPointerException
### The error may involve com.xinji.directpayment.dao.mapper.DpOriginalPolicyDOMapperExt.insertSelective-Inline
### The error occurred while setting parameters
### SQL: insert into dp_original_policy ( IS_DELETED, CREATOR, MODIFIER, GMT_MODIFIED, GMT_CREATE, POLICY_JSON, POLICY_NO, INS_COMPANY_CODE, INSURED_CERT_NO, INSURED_NAME, INSURED_PHONE, POLICY_STATUS, IS_REGISTER, VERSION, DELETE_PK, POLICY_UNIQUE_NO, CHANNEL, GMT_PUSH ) values ( 'n', 'system', 'system', current_timestamp, current_timestamp, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
### Cause: java.lang.NullPointerException
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:200)
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
... 36 more
Caused by: java.lang.NullPointerException
at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at org.apache.shardingsphere.sql.parser.mysql.visitor.MySQLVisitor.visitPredicate(MySQLVisitor.java:316)
at org.apache.shardingsphere.sql.parser.mysql.visitor.MySQLVisitor.visitPredicate(MySQLVisitor.java:121)
at org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser$PredicateContext.accept(MySQLStatementParser.java:11690)
at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at org.apache.shardingsphere.sql.parser.mysql.visitor.MySQLVisitor.visitBooleanPrimary(MySQLVisitor.java:273)
at org.apache.shardingsphere.sql.parser.mysql.visitor.MySQLVisitor.visitBooleanPrimary(MySQLVisitor.java:121)
at org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser$BooleanPrimaryContext.accept(MySQLStatementParser.java:11463)
at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at org.apache.shardingsphere.sql.parser.mysql.visitor.MySQLVisitor.visitExpr(MySQLVisitor.java:258)
at org.apache.shardingsphere.sql.parser.mysql.visitor.MySQLVisitor.visitExpr(MySQLVisitor.java:121)
at org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser$ExprContext.accept(MySQLStatementParser.java:11241)
at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at org.apache.shardingsphere.sql.parser.mysql.visitor.impl.MySQLDMLVisitor.visitAssignmentValue(MySQLDMLVisitor.java:250)
at org.apache.shardingsphere.sql.parser.mysql.visitor.impl.MySQLDMLVisitor.visitAssignmentValue(MySQLDMLVisitor.java:127)
at org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser$AssignmentValueContext.accept(MySQLStatementParser.java:1941)
at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at org.apache.shardingsphere.sql.parser.mysql.visitor.impl.MySQLDMLVisitor.visitAssignmentValues(MySQLDMLVisitor.java:234)
at org.apache.shardingsphere.sql.parser.mysql.visitor.impl.MySQLDMLVisitor.visitAssignmentValues(MySQLDMLVisitor.java:127)
at org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser$AssignmentValuesContext.accept(MySQLStatementParser.java:1865)
at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at org.apache.shardingsphere.sql.parser.mysql.visitor.impl.MySQLDMLVisitor.createInsertValuesSegments(MySQLDMLVisitor.java:191)
at org.apache.shardingsphere.sql.parser.mysql.visitor.impl.MySQLDMLVisitor.visitInsertValuesClause(MySQLDMLVisitor.java:184)
at org.apache.shardingsphere.sql.parser.mysql.visitor.impl.MySQLDMLVisitor.visitInsertValuesClause(MySQLDMLVisitor.java:127)
at org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser$InsertValuesClauseContext.accept(MySQLStatementParser.java:1259)
at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at org.apache.shardingsphere.sql.parser.mysql.visitor.impl.MySQLDMLVisitor.visitInsert(MySQLDMLVisitor.java:144)
at org.apache.shardingsphere.sql.parser.mysql.visitor.impl.MySQLDMLVisitor.visitInsert(MySQLDMLVisitor.java:127)
at org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser$InsertContext.accept(MySQLStatementParser.java:1090)
at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at org.apache.shardingsphere.sql.parser.SQLParserEngine.parse0(SQLParserEngine.java:80)
at org.apache.shardingsphere.sql.parser.SQLParserEngine.parse(SQLParserEngine.java:61)
at org.apache.shardingsphere.underlying.route.DataNodeRouter.createRouteContext(DataNodeRouter.java:97)
at org.apache.shardingsphere.underlying.route.DataNodeRouter.executeRoute(DataNodeRouter.java:89)
at org.apache.shardingsphere.underlying.route.DataNodeRouter.route(DataNodeRouter.java:76)
at org.apache.shardingsphere.underlying.pluggble.prepare.PreparedQueryPrepareEngine.route(PreparedQueryPrepareEngine.java:54)
at org.apache.shardingsphere.underlying.pluggble.prepare.BasePrepareEngine.executeRoute(BasePrepareEngine.java:96)
at org.apache.shardingsphere.underlying.pluggble.prepare.BasePrepareEngine.prepare(BasePrepareEngine.java:83)
at org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.prepare(ShardingPreparedStatement.java:183)
at org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.execute(ShardingPreparedStatement.java:143)
at io.seata.rm.datasource.PreparedStatementProxy.lambda$execute$0(PreparedStatementProxy.java:55)
at io.seata.rm.datasource.exec.ExecuteTemplate.execute(ExecuteTemplate.java:73)
at io.seata.rm.datasource.exec.ExecuteTemplate.execute(ExecuteTemplate.java:51)
at io.seata.rm.datasource.PreparedStatementProxy.execute(PreparedStatementProxy.java:55)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
at com.sun.proxy.$Proxy146.execute(Unknown Source)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
at com.sun.proxy.$Proxy318.update(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
... 42 more
```
### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
sql: normal "INSERT" statement
rule: pls look at my java config
### Example codes for reproduce this issue (such as a github link).
--
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:
users@infra.apache.org
[GitHub] [shardingsphere] farawayliu commented on issue #9956: NullPointerException occurred while executing "INSERT", but the execution of "SELECT" worked properly
Posted by GitBox <gi...@apache.org>.
farawayliu commented on issue #9956:
URL: https://github.com/apache/shardingsphere/issues/9956#issuecomment-815488126
@tristaZero @terrymanu tks for ur help. i use sharding-jdbc version 4.0.0, and both "select" and "insert" work well. i am sorry to i don't have time to test 5.0.0.
--
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:
users@infra.apache.org
[GitHub] [shardingsphere] farawayliu closed issue #9956: NullPointerException occurred while executing "INSERT", but the execution of "SELECT" worked properly
Posted by GitBox <gi...@apache.org>.
farawayliu closed issue #9956:
URL: https://github.com/apache/shardingsphere/issues/9956
--
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:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu closed issue #9956: NullPointerException occurred while executing "INSERT", but the execution of "SELECT" worked properly
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #9956:
URL: https://github.com/apache/shardingsphere/issues/9956
--
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
[GitHub] [shardingsphere] terrymanu edited a comment on issue #9956: NullPointerException occurred while executing "INSERT", but the execution of "SELECT" worked properly
Posted by GitBox <gi...@apache.org>.
terrymanu edited a comment on issue #9956:
URL: https://github.com/apache/shardingsphere/issues/9956#issuecomment-814879519
The artifact ID is changed, FYI:
https://mvnrepository.com/artifact/org.apache.shardingsphere/shardingsphere-jdbc-core
--
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:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #9956: NullPointerException occurred while executing "INSERT", but the execution of "SELECT" worked properly
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #9956:
URL: https://github.com/apache/shardingsphere/issues/9956#issuecomment-814879519
https://mvnrepository.com/artifact/org.apache.shardingsphere/shardingsphere-jdbc-core
--
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:
users@infra.apache.org
[GitHub] [shardingsphere] farawayliu removed a comment on issue #9956: NullPointerException occurred while executing "INSERT", but the execution of "SELECT" worked properly
Posted by GitBox <gi...@apache.org>.
farawayliu removed a comment on issue #9956:
URL: https://github.com/apache/shardingsphere/issues/9956#issuecomment-814663390
> 5.0.0-alpha
> Hi @farawayliu could you try 5.0.0-alpha?
--
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:
users@infra.apache.org
[GitHub] [shardingsphere] farawayliu commented on issue #9956: NullPointerException occurred while executing "INSERT", but the execution of "SELECT" worked properly
Posted by GitBox <gi...@apache.org>.
farawayliu commented on issue #9956:
URL: https://github.com/apache/shardingsphere/issues/9956#issuecomment-814663390
> 5.0.0-alpha
> Hi @farawayliu could you try 5.0.0-alpha?
--
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:
users@infra.apache.org
[GitHub] [shardingsphere] farawayliu commented on issue #9956: NullPointerException occurred while executing "INSERT", but the execution of "SELECT" worked properly
Posted by GitBox <gi...@apache.org>.
farawayliu commented on issue #9956:
URL: https://github.com/apache/shardingsphere/issues/9956#issuecomment-814663886
> Hi @farawayliu could you try 5.0.0-alpha?
Could not find artifact org.apache.shardingsphere:sharding-jdbc-core:pom:5.0.0-alpha
--
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:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #9956: NullPointerException occurred while executing "INSERT", but the execution of "SELECT" worked properly
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #9956:
URL: https://github.com/apache/shardingsphere/issues/9956#issuecomment-814659678
Hi @farawayliu could you try 5.0.0-alpha?
--
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:
users@infra.apache.org