awnurrk commented on issue #6429:
URL: https://github.com/apache/shardingsphere/issues/6429#issuecomment-663318598
2020-07-24 10:04:35.916 INFO 10204 --- [
main] c.a.nacos.client.config.impl.CacheData :
[fixed-localhost_8848] [add-listener] ok, tenant=, dataId=keyi-module-base.yml,
group=DEFAULT_GROUP, cnt=1
2020-07-24 10:04:36.820 INFO 10204 --- [
main] ShardingSphere-SQL
: Rule Type: sharding
2020-07-24 10:04:36.821 INFO 10204 --- [
main] ShardingSphere-SQL
: Logic SQL: INSERT INTO
template_sickness_detail_temporary (
price,
`usage`,
frequency,
doctor_advice
)
VALUES
(56, 'dddd', 'deee', 'good')
2020-07-24 10:04:36.821 INFO 10204 --- [
main] ShardingSphere-SQL
: SQLStatement:
InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML,
tables=Tables(tables=[Table(name=template_sickness_detail_temporary,
alias=Optional.absent())]),
routeConditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[])])),
encryptConditions=Conditions(orCondition=OrCondition(andConditions=[])),
sqlTokens=[TableToken(tableName=template_sickness_detail_temporary,
quoteCharacter=NONE, schemaNameLength=0), SQLToken(startIndex=47)],
parametersIndex=0, logicSQL=INSERT INTO template_sickness_detail_temporary (
price,
`usage`,
frequency,
doctor_advice
)
VALUES
(56, 'dddd', 'deee', 'good')), deleteStatement=false,
updateTableAlias={}, updateColumnValues={}, whereStartIndex=0,
whereStopIndex=0, whereParameterStartIndex=0, whereParameterEndIndex=0),
columnNames=[price, usage, frequency, doctor_advice],
values=[InsertValue(columnValues=[org.apache.shardingsphere.core.parse.old.parser.expression.SQLNumberExpression@3cbe75ce,
org.apache.shardingsphere.core.parse.old.parser.expression.SQLTextExpression@b945c43,
org.apache.shardingsphere.core.parse.old.parser.expression.SQLTextExpression@9bd2d60,
org.apache.shardingsphere.core.parse.old.parser.expression.SQLTextExpression@69052034])])
2020-07-24 10:04:36.821 INFO 10204 --- [
main] ShardingSphere-SQL
: Actual SQL: master0 ::: INSERT INTO
template_sickness_detail_temporary (price, usage, frequency,
doctor_advice) VALUES (56, 'dddd', 'deee', 'good')
org.springframework.jdbc.BadSqlGrammarException:
### Error updating database. Cause: java.sql.SQLSyntaxErrorException:
You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'usage, frequency,
doctor_advice) VALUES (56, 'dddd', 'deee', 'good')' at line 1
### The error may exist in file
[E:\developcode\could_master_0608\internet_hospital_could\keyi-module\keyi-module-base\target\classes\mapper\TemplateSicknessDetailTemporaryMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: INSERT INTO template_sickness_detail_temporary (
price, `usage`, frequency,
doctor_advice ) VALUES (56, 'dddd', 'deee', 'good')
### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version for the
right syntax to use near 'usage, frequency, doctor_advice) VALUES (56, 'dddd',
'deee', 'good')' at line 1
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException:
You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'usage, frequency,
doctor_advice) VALUES (56, 'dddd', 'deee', 'good')' at line 1
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:235)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at
org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
at com.sun.proxy.$Proxy167.insert(Unknown Source)
at
org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:271)
at
com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:60)
at
com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:96)
at com.sun.proxy.$Proxy311.insertByMySelf(Unknown Source)
at com.keyi.base.TestMapper.test5(TestMapper.java:71)
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:74)
at
org.springframework.test.context.junit4.statements.RunAfterTestExecutionCallbacks.evaluate(RunAfterTestExecutionCallbacks.java:84)
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:68)
at
com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
at
com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
at
com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version for the
right syntax to use near 'usage, frequency, doctor_advice) VALUES (56, 'dddd',
'deee', 'good')' at line 1
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at
com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at
com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:370)
at
com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:498)
at
org.apache.shardingsphere.shardingjdbc.executor.SQLExecuteCallbackFactory$2.executeSQL(SQLExecuteCallbackFactory.java:65)
at
org.apache.shardingsphere.shardingjdbc.executor.SQLExecuteCallbackFactory$2.executeSQL(SQLExecuteCallbackFactory.java:61)
at
org.apache.shardingsphere.core.execute.sql.execute.SQLExecuteCallback.execute0(SQLExecuteCallback.java:69)
at
org.apache.shardingsphere.core.execute.sql.execute.SQLExecuteCallback.execute(SQLExecuteCallback.java:58)
at
org.apache.shardingsphere.core.execute.ShardingExecuteEngine.syncGroupExecute(ShardingExecuteEngine.java:126)
at
org.apache.shardingsphere.core.execute.ShardingExecuteEngine.parallelExecute(ShardingExecuteEngine.java:103)
at
org.apache.shardingsphere.core.execute.ShardingExecuteEngine.groupExecute(ShardingExecuteEngine.java:83)
at
org.apache.shardingsphere.core.execute.sql.execute.SQLExecuteTemplate.executeGroup(SQLExecuteTemplate.java:73)
at
org.apache.shardingsphere.core.execute.sql.execute.SQLExecuteTemplate.executeGroup(SQLExecuteTemplate.java:56)
at
org.apache.shardingsphere.shardingjdbc.executor.AbstractStatementExecutor.executeCallback(AbstractStatementExecutor.java:128)
at
org.apache.shardingsphere.shardingjdbc.executor.PreparedStatementExecutor.execute(PreparedStatementExecutor.java:156)
at
org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.execute(ShardingPreparedStatement.java:172)
at
org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
at
org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
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.$Proxy383.update(Unknown Source)
at
com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doUpdate(MybatisSimpleExecutor.java:54)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
at
com.baomidou.mybatisplus.core.executor.MybatisCachingExecutor.update(MybatisCachingExecutor.java:83)
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.Invocation.proceed(Invocation.java:49)
at
com.baomidou.mybatisplus.extension.plugins.OptimisticLockerInterceptor.intercept(OptimisticLockerInterceptor.java:69)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy382.update(Unknown Source)
at
org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
at
org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)
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:426)
... 36 more
2020-07-24 10:04:36.997 INFO 10204 --- [
Thread-10] org.quartz.core.QuartzScheduler :
Scheduler quartzScheduler_$_NON_CLUSTERED paused.
2020-07-24 10:04:37.009 INFO 10204 --- [
Thread-10] o.s.s.c.ThreadPoolTaskScheduler :
Shutting down ExecutorService 'taskScheduler'
2020-07-24 10:04:37.009 INFO 10204 --- [
Thread-10] o.s.s.quartz.SchedulerFactoryBean :
Shutting down Quartz Scheduler
2020-07-24 10:04:37.009 INFO 10204 --- [
Thread-10] org.quartz.core.QuartzScheduler :
Scheduler quartzScheduler_$_NON_CLUSTERED shutting down.
2020-07-24 10:04:37.010 INFO 10204 --- [
Thread-10] org.quartz.core.QuartzScheduler :
Scheduler quartzScheduler_$_NON_CLUSTERED paused.
2020-07-24 10:04:37.010 INFO 10204 --- [
Thread-10] org.quartz.core.QuartzScheduler :
Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete.
2020-07-24 10:04:37.054 INFO 10204 --- [
Thread-10] o.s.s.concurrent.ThreadPoolTaskExecutor : Shutting down
ExecutorService 'threadpool'
2020-07-24 10:04:37.084 INFO 10204 --- [
Thread-10] o.s.s.concurrent.ThreadPoolTaskExecutor : Shutting down
ExecutorService
2020-07-24 10:04:37.103 INFO 10204 --- [
Thread-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-1}
closed
2020-07-24 10:04:37.104 INFO 10204 --- [
Thread-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-2}
closed
2020-07-24 10:04:37.105 INFO 10204 --- [
Thread-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-3}
closed
Disconnected from the target VM, address: '127.0.0.1:64317', transport:
'socket'
----------------------------------------------------------------
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]
