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 2019/06/19 08:02:25 UTC
[GitHub] [incubator-shardingsphere] wangenji2015 edited a comment on issue
#2573: insert into happen exception when used mysql keywords
wangenji2015 edited a comment on issue #2573: insert into happen exception when used mysql keywords
URL: https://github.com/apache/incubator-shardingsphere/issues/2573#issuecomment-503361997
> @Liuwanwu If your problem did not relate with this issue, can you open a new issue?
```
08:36:18.212 - org.springframework.test.context.support.AbstractDirtiesContextTestExecutionListener - Before test method: context [DefaultTestContext@23a5fd2 testClass = UserAccountServiceTest, testInstance = com.sanxiang.services.UserAccountServiceTest@7ff2a664, testMethod = _registerTest@UserAccountServiceTest, testException = [null], mergedContextConfiguration = [MergedContextConfiguration@78a2da20 testClass = UserAccountServiceTest, locations = '{classpath:META-INF/spring/service-*.xml}', classes = '{}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{}', contextCustomizers = set[[empty]], contextLoader = 'org.springframework.test.context.support.DelegatingSmartContextLoader', parent = [null]]], class annotated with @DirtiesContext [false] with mode [null], method annotated with @DirtiesContext [false] with mode [null].
08:36:18.215 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'org.springframework.transaction.interceptor.TransactionInterceptor#0'
08:36:18.217 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'transactionManager'
08:36:18.220 - org.springframework.jdbc.datasource.DataSourceTransactionManager - Creating new transaction with name [com.sanxiang.services.UserAccountServiceImpl.register]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; '',-java.lang.Exception
08:36:18.222 - org.springframework.jdbc.datasource.DataSourceTransactionManager - Acquired Connection [org.apache.shardingsphere.shardingjdbc.jdbc.core.connection.ShardingConnection@588545ac] for JDBC transaction
08:36:18.225 - org.springframework.jdbc.datasource.DataSourceTransactionManager - Switching JDBC Connection [org.apache.shardingsphere.shardingjdbc.jdbc.core.connection.ShardingConnection@588545ac] to manual commit
08:36:18.230 - org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
08:36:18.239 - org.mybatis.spring.SqlSessionUtils - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2d5a1588]
08:36:18.248 - org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [org.apache.shardingsphere.shardingjdbc.jdbc.core.connection.ShardingConnection@588545ac] will be managed by Spring
08:36:18.250 - com.sanxiang.dal.persistence.UserMapper.findUserByPhone - ==> Preparing: select id, username, password, status, create_time, update_time, openid, phone, email, weibo, qq, small_id, jm_flag, activate_flag, `from`, union_id, uuid from user where phone = ?
08:36:18.269 - org.apache.kafka.common.metrics.Metrics - Added sensor with name topic.order_notify_dev.bytes-fetched
08:36:18.269 - org.apache.kafka.common.metrics.Metrics - Added sensor with name topic.order_notify_dev.records-fetched
08:36:18.270 - org.apache.kafka.common.metrics.Metrics - Added sensor with name order_notify_dev-0.records-lag
08:36:18.276 - com.sanxiang.dal.persistence.UserMapper.findUserByPhone - ==> Parameters: 12345678910(String)
08:36:18.710 - ShardingSphere-SQL - Rule Type: sharding
08:36:18.710 - ShardingSphere-SQL - Logic SQL: select
id, username, password, status, create_time, update_time, openid, phone, email, weibo,
qq, small_id, jm_flag, activate_flag, `from`, union_id, uuid
from user
where phone = ?
08:36:18.710 - ShardingSphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=user, alias=Optional.absent())]), routeConditions=Conditions(orCondition=OrCondition(andConditions=[])), encryptConditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(tableName=user, quoteCharacter=NONE, schemaNameLength=0)], parametersIndex=1, logicSQL=select
id, username, password, status, create_time, update_time, openid, phone, email, weibo,
qq, small_id, jm_flag, activate_flag, `from`, union_id, uuid
from user
where phone = ?)), containStar=false, firstSelectItemStartIndex=25, selectListStopIndex=179, groupByLastIndex=0, items=[CommonSelectItem(expression=id, alias=Optional.absent()), CommonSelectItem(expression=username, alias=Optional.absent()), CommonSelectItem(expression=password, alias=Optional.absent()), CommonSelectItem(expression=status, alias=Optional.absent()), CommonSelectItem(expression=create_time, alias=Optional.absent()), CommonSelectItem(expression=update_time, alias=Optional.absent()), CommonSelectItem(expression=openid, alias=Optional.absent()), CommonSelectItem(expression=phone, alias=Optional.absent()), CommonSelectItem(expression=email, alias=Optional.absent()), CommonSelectItem(expression=weibo, alias=Optional.absent()), CommonSelectItem(expression=qq, alias=Optional.absent()), CommonSelectItem(expression=small_id, alias=Optional.absent()), CommonSelectItem(expression=jm_flag, alias=Optional.absent()), CommonSelectItem(expression=activate_flag, alias=Optional.absent()), CommonSelectItem(expression=from, alias=Optional.absent()), CommonSelectItem(expression=union_id, alias=Optional.absent()), CommonSelectItem(expression=uuid, alias=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subqueryStatement=null, subqueryStatements=[], subqueryConditions=[])
08:36:18.710 - ShardingSphere-SQL - Actual SQL: userDataSource ::: select
id, username, password, status, create_time, update_time, openid, phone, email, weibo,
qq, small_id, jm_flag, activate_flag, `from`, union_id, uuid
from user_0
where phone = ? ::: [12345678910]
08:36:18.710 - ShardingSphere-SQL - Actual SQL: userDataSource ::: select
id, username, password, status, create_time, update_time, openid, phone, email, weibo,
qq, small_id, jm_flag, activate_flag, `from`, union_id, uuid
from user_1
where phone = ? ::: [12345678910]
08:36:18.710 - ShardingSphere-SQL - Actual SQL: userDataSource ::: select
id, username, password, status, create_time, update_time, openid, phone, email, weibo,
qq, small_id, jm_flag, activate_flag, `from`, union_id, uuid
from user_2
where phone = ? ::: [12345678910]
08:36:18.818 - com.sanxiang.dal.persistence.UserMapper.findUserByPhone - <== Total: 0
08:36:18.819 - org.mybatis.spring.SqlSessionUtils - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2d5a1588]
08:36:18.820 - org.mybatis.spring.SqlSessionUtils - Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2d5a1588] from current transaction
08:36:18.820 - com.sanxiang.dal.persistence.VerifyCodeMapper.findRecordLatest - ==> Preparing: select phone,code,create_time,active_time,type from verifycode where phone=? and code=? order by create_time desc limit 1;
08:36:18.820 - com.sanxiang.dal.persistence.VerifyCodeMapper.findRecordLatest - ==> Parameters: 12345678910(String), 1111(String)
08:36:18.843 - ShardingSphere-SQL - Rule Type: sharding
08:36:18.844 - ShardingSphere-SQL - Logic SQL: select
phone,code,create_time,active_time,type
from verifycode where phone=? and code=? order by create_time desc limit 1;
08:36:18.844 - ShardingSphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=verifycode, alias=Optional.absent())]), routeConditions=Conditions(orCondition=OrCondition(andConditions=[])), encryptConditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(tableName=verifycode, quoteCharacter=NONE, schemaNameLength=0), SQLToken(startIndex=136)], parametersIndex=2, logicSQL=select
phone,code,create_time,active_time,type
from verifycode where phone=? and code=? order by create_time desc limit 1;)), containStar=false, firstSelectItemStartIndex=17, selectListStopIndex=55, groupByLastIndex=0, items=[CommonSelectItem(expression=phone, alias=Optional.absent()), CommonSelectItem(expression=code, alias=Optional.absent()), CommonSelectItem(expression=create_time, alias=Optional.absent()), CommonSelectItem(expression=active_time, alias=Optional.absent()), CommonSelectItem(expression=type, alias=Optional.absent())], groupByItems=[], orderByItems=[OrderItem(owner=Optional.absent(), name=Optional.of(create_time), orderDirection=DESC, nullOrderDirection=ASC, index=-1, expression=null, alias=Optional.absent())], limit=Limit(offset=null, rowCount=LimitValue(value=1, index=-1, boundOpened=false)), subqueryStatement=null, subqueryStatements=[], subqueryConditions=[])
08:36:18.844 - ShardingSphere-SQL - Actual SQL: userDataSource ::: select
phone,code,create_time,active_time,type
from verifycode where phone=? and code=? order by create_time desc limit 1; ::: [12345678910, 1111]
08:36:18.862 - com.sanxiang.dal.persistence.VerifyCodeMapper.findRecordLatest - <== Total: 1
08:36:18.863 - org.mybatis.spring.SqlSessionUtils - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2d5a1588]
08:36:18.966 - org.mybatis.spring.SqlSessionUtils - Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2d5a1588] from current transaction
08:36:18.992 - com.sanxiang.dal.persistence.UserMapper.insertSelective - ==> Preparing: insert into `user` ( password, status, phone, jm_flag, activate_flag, `from` ) values ( ?, ?, ?, ?, ?, ? )
08:36:18.992 - com.sanxiang.dal.persistence.UserMapper.insertSelective - ==> Parameters: $2a$10$4MqyUbZ70.Y9m7cjOUwHz.Eks3I7SsimA4ekiecvs0RZ/HNU6/kqC(String), 1(Short), 12345678910(String), 0(Byte), 1(Byte), 1(Byte)
08:36:19.064 - ShardingSphere-SQL - Rule Type: sharding
08:36:19.064 - ShardingSphere-SQL - Logic SQL: insert into `user`
( password,
status,
phone,
jm_flag,
activate_flag,
`from` )
values ( ?,
?,
?,
?,
?,
? )
08:36:19.064 - ShardingSphere-SQL - SQLStatement: InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML, tables=Tables(tables=[Table(name=user, alias=Optional.absent())]), routeConditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[])])), encryptConditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(tableName=user, quoteCharacter=BACK_QUOTE, schemaNameLength=0), SQLToken(startIndex=28)], parametersIndex=6, logicSQL=insert into `user`
( password,
status,
phone,
jm_flag,
activate_flag,
`from` )
values ( ?,
?,
?,
?,
?,
? )), deleteStatement=false, updateTableAlias={}, updateColumnValues={}, whereStartIndex=0, whereStopIndex=0, whereParameterStartIndex=0, whereParameterEndIndex=0), columnNames=[password, status, phone, jm_flag, activate_flag, from], values=[InsertValue(columnValues=[org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@3f3c8b60, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@16bbaab3, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@3f357c9d, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@fe42a09, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@5458c71e, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@1ffd0114])])
08:36:19.065 - ShardingSphere-SQL - Actual SQL: userDataSource ::: insert into `user_1`
(password, status, phone, jm_flag, activate_flag, from, id) VALUES (?, ?, ?, ?, ?, ?, ?) ::: [$2a$10$4MqyUbZ70.Y9m7cjOUwHz.Eks3I7SsimA4ekiecvs0RZ/HNU6/kqC, 1, 12345678910, 0, 1, 1, 348022286353170433]
08:36:19.101 - org.mybatis.spring.SqlSessionUtils - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2d5a1588]
08:36:19.107 - org.springframework.core.env.StandardEnvironment - Adding PropertySource 'systemProperties' with lowest search precedence
08:36:19.108 - org.springframework.core.env.StandardEnvironment - Adding PropertySource 'systemEnvironment' with lowest search precedence
08:36:19.108 - org.springframework.core.env.StandardEnvironment - Initialized StandardEnvironment with PropertySources [MapPropertySource@705258430 {name='systemProperties', properties={java.runtime.name=Java(TM) SE Runtime Environment, sun.boot.library.path=/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib, java.vm.version=25.172-b11, gopherProxySet=false, java.vm.vendor=Oracle Corporation, java.vendor.url=http://java.oracle.com/, path.separator=:, java.vm.name=Java HotSpot(TM) 64-Bit Server VM, file.encoding.pkg=sun.io, user.country=CN, sun.java.launcher=SUN_STANDARD, env=DEV, sun.os.patch.level=unknown, java.vm.specification.name=Java Virtual Machine Specification, user.dir=/Users/liruiguang/IdeaProjects/sxapp-all/sxapp-user-service/user-provider, java.runtime.version=1.8.0_172-b11, java.awt.graphicsenv=sun.awt.CGraphicsEnvironment, java.endorsed.dirs=/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/endorsed, os.arch=x86_64, java.io.tmpdir=/var/folders/fk/4xggy7lx7cl87pqf29nxg0640000gn/T/, line.separator=
, java.vm.specification.vendor=Oracle Corporation, os.name=Mac OS X, sun.jnu.encoding=UTF-8, java.library.path=/Users/liruiguang/Library/Java/Extensions:/Library/Java/Extensions:/Network/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java:., java.specification.name=Java Platform API Specification, java.class.version=52.0, sun.management.compiler=HotSpot 64-Bit Tiered Compilers, os.version=10.14.5, user.home=/Users/liruiguang, user.timezone=Asia/Shanghai, java.awt.printerjob=sun.lwawt.macosx.CPrinterJob, file.encoding=UTF-8, java.specification.version=1.8, java.class.path=/Applications/IntelliJ IDEA.app/Contents/lib/idea_rt.jar:/Applications/IntelliJ IDEA.app/Contents/plugins/junit/lib/junit-rt.jar:/Applications/IntelliJ IDEA.app/Contents/plugins/junit/lib/junit5-rt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/charsets.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/deploy.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/ext/cldrdata.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/ext/dnsns.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/ext/jaccess.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/ext/jfxrt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/ext/localedata.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/ext/nashorn.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/ext/sunec.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/ext/sunjce_provider.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/ext/sunpkcs11.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/ext/zipfs.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/javaws.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/jce.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/jfr.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/jfxswt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/jsse.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/management-agent.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/plugin.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/resources.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/rt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/lib/ant-javafx.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/lib/dt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/lib/javafx-mx.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/lib/jconsole.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/lib/packager.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/lib/sa-jdi.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/lib/tools.jar:/Users/liruiguang/IdeaProjects/sxapp-all/sxapp-user-service/user-provider/target/test-classes:/Users/liruiguang/IdeaProjects/sxapp-all/sxapp-user-service/user-provider/target/classes:/Users/liruiguang/.m2/repository/org/springframework/spring-context/4.3.12.RELEASE/spring-context-4.3.12.RELEASE.jar:/Users/liruiguang/.m2/repository/org/springframework/spring-aop/4.3.12.RELEASE/spring-aop-4.3.12.RELEASE.jar:/Users/liruiguang/.m2/repository/org/springframework/spring-expression/4.3.12.RELEASE/spring-expression-4.3.12.RELEASE.jar:/Users/liruiguang/.m2/repository/org/springframework/spring-core/4.3.12.RELEASE/spring-core-4.3.12.RELEASE.jar:/Users/liruiguang/.m2/repository/commons-logging/commons-logging/1.2/commons-logging-1.2.jar:/Users/liruiguang/.m2/repository/org/springframework/spring-beans/4.3.12.RELEASE/spring-beans-4.3.12.RELEASE.jar:/Users/liruiguang/.m2/repository/org/springframework/spring-context-support/4.3.12.RELEASE/spring-context-support-4.3.12.RELEASE.jar:/Users/liruiguang/.m2/repository/org/springframework/spring-jdbc/4.3.12.RELEASE/spring-jdbc-4.3.12.RELEASE.jar:/Users/liruiguang/.m2/repository/org/springframework/spring-orm/4.3.12.RELEASE/spring-orm-4.3.12.RELEASE.jar:/Users/liruiguang/.m2/repository/org/springframework/spring-tx/4.3.12.RELEASE/spring-tx-4.3.12.RELEASE.jar:/Users/liruiguang/.m2/repository/org/springframework/spring-webmvc/4.3.12.RELEASE/spring-webmvc-4.3.12.RELEASE.jar:/Users/liruiguang/.m2/repository/org/springframework/spring-web/4.3.12.RELEASE/spring-web-4.3.12.RELEASE.jar:/Users/liruiguang/.m2/repository/org/springframework/spring-test/4.3.13.RELEASE/spring-test-4.3.13.RELEASE.jar:/Users/liruiguang/.m2/repository/com/alibaba/dubbo/2.5.3/dubbo-2.5.3.jar:/Users/liruiguang/.m2/repository/org/javassist/javassist/3.15.0-GA/javassist-3.15.0-GA.jar:/Users/liruiguang/.m2/repository/org/jboss/netty/netty/3.2.5.Final/netty-3.2.5.Final.jar:/Users/liruiguang/.m2/repository/com/101tec/zkclient/0.10/zkclient-0.10.jar:/Users/liruiguang/.m2/repository/org/slf4j/slf4j-api/1.7.21/slf4j-api-1.7.21.jar:/Users/liruiguang/.m2/repository/org/apache/zookeeper/zookeeper/3.4.8/zookeeper-3.4.8.jar:/Users/liruiguang/.m2/repository/jline/jline/0.9.94/jline-0.9.94.jar:/Users/liruiguang/.m2/repository/io/netty/netty/3.7.0.Final/netty-3.7.0.Final.jar:/Users/liruiguang/.m2/repository/org/mybatis/mybatis/3.4.6/mybatis-3.4.6.jar:/Users/liruiguang/.m2/repository/mysql/mysql-connector-java/5.1.38/mysql-connector-java-5.1.38.jar:/Users/liruiguang/.m2/repository/org/mybatis/mybatis-spring/1.3.2/mybatis-spring-1.3.2.jar:/Users/liruiguang/.m2/repository/com/alibaba/druid/1.1.10/druid-1.1.10.jar:/Users/liruiguang/.m2/repository/com/github/pagehelper/pagehelper/5.1.9/pagehelper-5.1.9.jar:/Users/liruiguang/.m2/repository/com/github/jsqlparser/jsqlparser/2.0/jsqlparser-2.0.jar:/Users/liruiguang/.m2/repository/org/apache/shardingsphere/sharding-jdbc-spring-namespace/4.0.0-RC1/sharding-jdbc-spring-namespace-4.0.0-RC1.jar:/Users/liruiguang/.m2/repository/org/apache/shardingsphere/sharding-jdbc-core/4.0.0-RC1/sharding-jdbc-core-4.0.0-RC1.jar:/Users/liruiguang/.m2/repository/org/apache/shardingsphere/sharding-core-entry/4.0.0-RC1/sharding-core-entry-4.0.0-RC1.jar:/Users/liruiguang/.m2/repository/org/apache/shardingsphere/sharding-core-api/4.0.0-RC1/sharding-core-api-4.0.0-RC1.jar:/Users/liruiguang/.m2/repository/org/apache/shardingsphere/sharding-core-common/4.0.0-RC1/sharding-core-common-4.0.0-RC1.jar:/Users/liruiguang/.m2/repository/org/codehaus/groovy/groovy/2.4.5/groovy-2.4.5-indy.jar:/Users/liruiguang/.m2/repository/org/apache/shardingsphere/sharding-core-parse-common/4.0.0-RC1/sharding-core-parse-common-4.0.0-RC1.jar:/Users/liruiguang/.m2/repository/org/apache/shardingsphere/sharding-core-parse-spi/4.0.0-RC1/sharding-core-parse-spi-4.0.0-RC1.jar:/Users/liruiguang/.m2/repository/org/apache/commons/commons-collections4/4.2/commons-collections4-4.2.jar:/Users/liruiguang/.m2/repository/org/antlr/antlr4-runtime/4.7.1/antlr4-runtime-4.7.1.jar:/Users/liruiguang/.m2/repository/org/apache/shardingsphere/sharding-core-parse-mysql/4.0.0-RC1/sharding-core-parse-mysql-4.0.0-RC1.jar:/Users/liruiguang/.m2/repository/org/apache/shardingsphere/sharding-core-parse-postgresql/4.0.0-RC1/sharding-core-parse-postgresql-4.0.0-RC1.jar:/Users/liruiguang/.m2/repository/org/apache/shardingsphere/sharding-core-parse-oracle/4.0.0-RC1/sharding-core-parse-oracle-4.0.0-RC1.jar:/Users/liruiguang/.m2/repository/org/apache/shardingsphere/sharding-core-parse-sqlserver/4.0.0-RC1/sharding-core-parse-sqlserver-4.0.0-RC1.jar:/Users/liruiguang/.m2/repository/org/apache/shardingsphere/sharding-core-optimize/4.0.0-RC1/sharding-core-optimize-4.0.0-RC1.jar:/Users/liruiguang/.m2/repository/org/apache/shardingsphere/sharding-core-route/4.0.0-RC1/sharding-core-route-4.0.0-RC1.jar:/Users/liruiguang/.m2/repository/org/apache/shardingsphere/sharding-core-rewrite/4.0.0-RC1/sharding-core-rewrite-4.0.0-RC1.jar:/Users/liruiguang/.m2/repository/org/apache/shardingsphere/sharding-core-execute/4.0.0-RC1/sharding-core-execute-4.0.0-RC1.jar:/Users/liruiguang/.m2/repository/org/apache/shardingsphere/sharding-core-merge/4.0.0-RC1/sharding-core-merge-4.0.0-RC1.jar:/Users/liruiguang/.m2/repository/org/apache/shardingsphere/sharding-transaction-core/4.0.0-RC1/sharding-transaction-core-4.0.0-RC1.jar:/Users/liruiguang/.m2/repository/com/google/guava/guava/18.0/guava-18.0.jar:/Users/liruiguang/.m2/repository/org/slf4j/jcl-over-slf4j/1.7.7/jcl-over-slf4j-1.7.7.jar:/Users/liruiguang/.m2/repository/com/ctrip/framework/apollo/apollo-client/1.3.0/apollo-client-1.3.0.jar:/Users/liruiguang/.m2/repository/com/ctrip/framework/apollo/apollo-core/1.3.0/apollo-core-1.3.0.jar:/Users/liruiguang/.m2/repository/com/google/code/gson/gson/2.8.0/gson-2.8.0.jar:/Users/liruiguang/.m2/repository/com/google/inject/guice/4.1.0/guice-4.1.0.jar:/Users/liruiguang/.m2/repository/javax/inject/javax.inject/1/javax.inject-1.jar:/Users/liruiguang/.m2/repository/aopalliance/aopalliance/1.0/aopalliance-1.0.jar:/Users/liruiguang/.m2/repository/org/yaml/snakeyaml/1.17/snakeyaml-1.17.jar:/Users/liruiguang/IdeaProjects/sxapp-all/sxapp-user-service/user-api/target/classes:/Users/liruiguang/IdeaProjects/sxapp-all/sxapp-tools/target/classes:/Users/liruiguang/.m2/repository/ch/qos/logback/logback-core/1.1.2/logback-core-1.1.2.jar:/Users/liruiguang/.m2/repository/ch/qos/logback/logback-access/1.1.2/logback-access-1.1.2.jar:/Users/liruiguang/.m2/repository/ch/qos/logback/logback-classic/1.1.2/logback-classic-1.1.2.jar:/Users/liruiguang/.m2/repository/org/slf4j/log4j-over-slf4j/1.7.25/log4j-over-slf4j-1.7.25.jar:/Users/liruiguang/.m2/repository/com/auth0/java-jwt/3.8.0/java-jwt-3.8.0.jar:/Users/liruiguang/.m2/repository/com/fasterxml/jackson/core/jackson-databind/2.9.8/jackson-databind-2.9.8.jar:/Users/liruiguang/.m2/repository/com/fasterxml/jackson/core/jackson-annotations/2.9.0/jackson-annotations-2.9.0.jar:/Users/liruiguang/.m2/repository/com/fasterxml/jackson/core/jackson-core/2.9.8/jackson-core-2.9.8.jar:/Users/liruiguang/.m2/repository/commons-codec/commons-codec/1.10/commons-codec-1.10.jar:/Users/liruiguang/.m2/repository/com/alibaba/fastjson/1.2.58/fastjson-1.2.58.jar:/Users/liruiguang/.m2/repository/org/apache/commons/commons-lang3/3.9/commons-lang3-3.9.jar:/Users/liruiguang/.m2/repository/com/aliyun/oss/aliyun-sdk-oss/2.8.3/aliyun-sdk-oss-2.8.3.jar:/Users/liruiguang/.m2/repository/org/apache/httpcomponents/httpclient/4.4.1/httpclient-4.4.1.jar:/Users/liruiguang/.m2/repository/org/apache/httpcomponents/httpcore/4.4.1/httpcore-4.4.1.jar:/Users/liruiguang/.m2/repository/org/jdom/jdom/1.1/jdom-1.1.jar:/Users/liruiguang/.m2/repository/io/springfox/springfox-swagger-ui/2.9.2/springfox-swagger-ui-2.9.2.jar:/Users/liruiguang/.m2/repository/io/springfox/springfox-spring-web/2.9.2/springfox-spring-web-2.9.2.jar:/Users/liruiguang/.m2/repository/io/springfox/springfox-swagger2/2.9.2/springfox-swagger2-2.9.2.jar:/Users/liruiguang/.m2/repository/io/swagger/swagger-annotations/1.5.20/swagger-annotations-1.5.20.jar:/Users/liruiguang/.m2/repository/io/swagger/swagger-models/1.5.20/swagger-models-1.5.20.jar:/Users/liruiguang/.m2/repository/io/springfox/springfox-spi/2.9.2/springfox-spi-2.9.2.jar:/Users/liruiguang/.m2/repository/io/springfox/springfox-core/2.9.2/springfox-core-2.9.2.jar:/Users/liruiguang/.m2/repository/net/bytebuddy/byte-buddy/1.8.12/byte-buddy-1.8.12.jar:/Users/liruiguang/.m2/repository/io/springfox/springfox-schema/2.9.2/springfox-schema-2.9.2.jar:/Users/liruiguang/.m2/repository/io/springfox/springfox-swagger-common/2.9.2/springfox-swagger-common-2.9.2.jar:/Users/liruiguang/.m2/repository/com/fasterxml/classmate/1.4.0/classmate-1.4.0.jar:/Users/liruiguang/.m2/repository/org/springframework/plugin/spring-plugin-core/1.2.0.RELEASE/spring-plugin-core-1.2.0.RELEASE.jar:/Users/liruiguang/.m2/repository/org/springframework/plugin/spring-plugin-metadata/1.2.0.RELEASE/spring-plugin-metadata-1.2.0.RELEASE.jar:/Users/liruiguang/.m2/repository/org/mapstruct/mapstruct/1.2.0.Final/mapstruct-1.2.0.Final.jar:/Users/liruiguang/IdeaProjects/sxapp-all/sxapp-gift-service/gift-api/target/classes:/Users/liruiguang/.m2/repository/junit/junit/4.12/junit-4.12.jar:/Users/liruiguang/.m2/repository/org/hamcrest/hamcrest-core/1.3/hamcrest-core-1.3.jar:/Users/liruiguang/.m2/repository/io/zipkin/brave/brave-instrumentation-dubbo-rpc/5.4.2/brave-instrumentation-dubbo-rpc-5.4.2.jar:/Users/liruiguang/.m2/repository/io/zipkin/brave/brave/5.4.2/brave-5.4.2.jar:/Users/liruiguang/.m2/repository/io/zipkin/brave/brave-spring-beans/5.4.2/brave-spring-beans-5.4.2.jar:/Users/liruiguang/.m2/repository/io/zipkin/brave/brave-instrumentation-http/5.4.2/brave-instrumentation-http-5.4.2.jar:/Users/liruiguang/.m2/repository/io/zipkin/reporter2/zipkin-reporter-spring-beans/2.7.9/zipkin-reporter-spring-beans-2.7.9.jar:/Users/liruiguang/.m2/repository/io/zipkin/brave/brave-context-slf4j/5.4.2/brave-context-slf4j-5.4.2.jar:/Users/liruiguang/.m2/repository/io/zipkin/reporter2/zipkin-sender-okhttp3/2.7.9/zipkin-sender-okhttp3-2.7.9.jar:/Users/liruiguang/.m2/repository/io/zipkin/reporter2/zipkin-reporter/2.7.9/zipkin-reporter-2.7.9.jar:/Users/liruiguang/.m2/repository/com/squareup/okhttp3/okhttp/3.11.0/okhttp-3.11.0.jar:/Users/liruiguang/.m2/repository/com/squareup/okio/okio/1.14.0/okio-1.14.0.jar:/Users/liruiguang/.m2/repository/io/zipkin/zipkin2/zipkin/2.11.6/zipkin-2.11.6.jar:/Users/liruiguang/.m2/repository/org/springframework/kafka/spring-kafka/2.1.7.RELEASE/spring-kafka-2.1.7.RELEASE.jar:/Users/liruiguang/.m2/repository/org/springframework/spring-messaging/5.0.6.RELEASE/spring-messaging-5.0.6.RELEASE.jar:/Users/liruiguang/.m2/repository/org/springframework/retry/spring-retry/1.2.2.RELEASE/spring-retry-1.2.2.RELEASE.jar:/Users/liruiguang/.m2/repository/org/apache/kafka/kafka-clients/1.0.1/kafka-clients-1.0.1.jar:/Users/liruiguang/.m2/repository/org/lz4/lz4-java/1.4/lz4-java-1.4.jar:/Users/liruiguang/.m2/repository/org/xerial/snappy/snappy-java/1.1.4/snappy-java-1.1.4.jar:/Users/liruiguang/.m2/repository/org/springframework/data/spring-data-redis/1.8.9.RELEASE/spring-data-redis-1.8.9.RELEASE.jar:/Users/liruiguang/.m2/repository/org/springframework/data/spring-data-keyvalue/1.2.9.RELEASE/spring-data-keyvalue-1.2.9.RELEASE.jar:/Users/liruiguang/.m2/repository/org/springframework/data/spring-data-commons/1.13.9.RELEASE/spring-data-commons-1.13.9.RELEASE.jar:/Users/liruiguang/.m2/repository/org/springframework/spring-oxm/4.3.13.RELEASE/spring-oxm-4.3.13.RELEASE.jar:/Users/liruiguang/.m2/repository/redis/clients/jedis/2.9.0/jedis-2.9.0.jar:/Users/liruiguang/.m2/repository/org/apache/commons/commons-pool2/2.4.2/commons-pool2-2.4.2.jar:/Users/liruiguang/.m2/repository/org/mindrot/jbcrypt/0.4/jbcrypt-0.4.jar:/Users/liruiguang/IdeaProjects/sxapp-all/sxapp-img-service/img-api/target/classes:/Users/liruiguang/IdeaProjects/sxapp-all/book-course-service/content-api/target/classes:/Users/liruiguang/IdeaProjects/sxapp-all/sxapp-order-service/order-api/target/classes:/Users/liruiguang/IdeaProjects/sxapp-all/sxapp-pay-service/pay-api/target/classes:/Applications/IntelliJ IDEA.app/Contents/lib/idea_rt.jar, user.name=liruiguang, java.vm.specification.version=1.8, sun.java.command=com.intellij.rt.execution.junit.JUnitStarter -ideVersion5 -junit4 com.sanxiang.services.UserAccountServiceTest, java.home=/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre, sun.arch.data.model=64, user.language=zh, java.specification.vendor=Oracle Corporation, awt.toolkit=sun.lwawt.macosx.LWCToolkit, java.vm.info=mixed mode, java.version=1.8.0_172, java.ext.dirs=/Users/liruiguang/Library/Java/Extensions:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/ext:/Library/Java/Extensions:/Network/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java, sun.boot.class.path=/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/resources.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/rt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/sunrsasign.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/jsse.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/jce.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/charsets.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/lib/jfr.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home/jre/classes, java.vendor=Oracle Corporation, file.separator=/, java.vendor.url.bug=http://bugreport.sun.com/bugreport/, idea.test.cyclic.buffer.size=1048576, sun.io.unicode.encoding=UnicodeBig, sun.cpu.endian=little, sun.cpu.isalist=}}, SystemEnvironmentPropertySource@2101082331 {name='systemEnvironment', properties={PATH=/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin, SHELL=/bin/bash, USER=liruiguang, VERSIONER_PYTHON_PREFER_32_BIT=no, TMPDIR=/var/folders/fk/4xggy7lx7cl87pqf29nxg0640000gn/T/, SSH_AUTH_SOCK=/private/tmp/com.apple.launchd.ECOeTyYX6h/Listeners, XPC_FLAGS=0x0, VERSIONER_PYTHON_VERSION=2.7, JAVA_MAIN_CLASS_34428=com.intellij.rt.execution.junit.JUnitStarter, __CF_USER_TEXT_ENCODING=0x1F5:0x19:0x34, Apple_PubSub_Socket_Render=/private/tmp/com.apple.launchd.vkN6mmVWi1/Render, LOGNAME=liruiguang, LC_CTYPE=zh_CN.UTF-8, PWD=/Users/liruiguang/IdeaProjects/sxapp-all/sxapp-user-service/user-provider, XPC_SERVICE_NAME=com.jetbrains.intellij.17624, HOME=/Users/liruiguang}}]
08:36:19.108 - org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
08:36:19.109 - org.springframework.beans.factory.xml.DefaultDocumentLoader - Using JAXP provider [com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl]
08:36:19.111 - org.springframework.beans.factory.xml.BeansDtdResolver - Found beans DTD [http://www.springframework.org/dtd/spring-beans-2.0.dtd] in classpath: spring-beans-2.0.dtd
08:36:19.114 - org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader - Loading bean definitions
08:36:19.117 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'DB2'
08:36:19.117 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating instance of bean 'DB2'
08:36:19.118 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Eagerly caching bean 'DB2' to allow for resolving potential circular references
08:36:19.121 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Finished creating instance of bean 'DB2'
08:36:19.121 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'Derby'
08:36:19.121 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating instance of bean 'Derby'
08:36:19.121 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Eagerly caching bean 'Derby' to allow for resolving potential circular references
08:36:19.121 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Finished creating instance of bean 'Derby'
08:36:19.121 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'H2'
08:36:19.121 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating instance of bean 'H2'
08:36:19.121 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Eagerly caching bean 'H2' to allow for resolving potential circular references
08:36:19.122 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Finished creating instance of bean 'H2'
08:36:19.122 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'HSQL'
08:36:19.122 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating instance of bean 'HSQL'
08:36:19.122 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Eagerly caching bean 'HSQL' to allow for resolving potential circular references
08:36:19.122 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Finished creating instance of bean 'HSQL'
08:36:19.122 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'Informix'
08:36:19.122 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating instance of bean 'Informix'
08:36:19.122 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Eagerly caching bean 'Informix' to allow for resolving potential circular references
08:36:19.122 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Finished creating instance of bean 'Informix'
08:36:19.122 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'MS-SQL'
08:36:19.122 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating instance of bean 'MS-SQL'
08:36:19.122 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Eagerly caching bean 'MS-SQL' to allow for resolving potential circular references
08:36:19.123 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Finished creating instance of bean 'MS-SQL'
08:36:19.123 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'MySQL'
08:36:19.123 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating instance of bean 'MySQL'
08:36:19.123 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Eagerly caching bean 'MySQL' to allow for resolving potential circular references
08:36:19.123 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Finished creating instance of bean 'MySQL'
08:36:19.123 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'Oracle'
08:36:19.123 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating instance of bean 'Oracle'
08:36:19.123 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Eagerly caching bean 'Oracle' to allow for resolving potential circular references
08:36:19.124 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Finished creating instance of bean 'Oracle'
08:36:19.124 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'PostgreSQL'
08:36:19.124 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating instance of bean 'PostgreSQL'
08:36:19.124 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Eagerly caching bean 'PostgreSQL' to allow for resolving potential circular references
08:36:19.125 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Finished creating instance of bean 'PostgreSQL'
08:36:19.125 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'Sybase'
08:36:19.125 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating instance of bean 'Sybase'
08:36:19.125 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Eagerly caching bean 'Sybase' to allow for resolving potential circular references
08:36:19.125 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Finished creating instance of bean 'Sybase'
08:36:19.125 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'Hana'
08:36:19.125 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating instance of bean 'Hana'
08:36:19.125 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Eagerly caching bean 'Hana' to allow for resolving potential circular references
08:36:19.126 - org.springframework.beans.factory.support.DefaultListableBeanFactory - Finished creating instance of bean 'Hana'
08:36:19.126 - org.springframework.jdbc.support.SQLErrorCodesFactory - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase, Hana]
08:36:19.126 - org.springframework.jdbc.support.SQLErrorCodesFactory - Looking up default SQLErrorCodes for DataSource [org.apache.shardingsphere.shardingjdbc.spring.datasource.SpringShardingDataSource@422ab737]
08:36:19.129 - org.springframework.jdbc.support.SQLErrorCodesFactory - SQL error codes for 'MySQL' found
08:36:19.129 - org.springframework.jdbc.support.SQLErrorCodesFactory - Caching SQL error codes for DataSource [org.apache.shardingsphere.shardingjdbc.spring.datasource.SpringShardingDataSource@422ab737]: database product name is 'MySQL'
08:36:19.129 - org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator - Translating SQLException with SQL state '42000', error code '1064', message [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 'from, id) VALUES ('$2a$10$4MqyUbZ70.Y9m7cjOUwHz.Eks3I7SsimA4ekiecvs0RZ/HNU6/kqC'' at line 2]; SQL was [] for task [
### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'from, id) VALUES ('$2a$10$4MqyUbZ70.Y9m7cjOUwHz.Eks3I7SsimA4ekiecvs0RZ/HNU6/kqC'' at line 2
### The error may involve com.sanxiang.dal.persistence.UserMapper.insertSelective-Inline
### The error occurred while setting parameters
### SQL: insert into `user` ( password, status, phone, jm_flag, activate_flag, `from` ) values ( ?, ?, ?, ?, ?, ? )
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'from, id) VALUES ('$2a$10$4MqyUbZ70.Y9m7cjOUwHz.Eks3I7SsimA4ekiecvs0RZ/HNU6/kqC'' at line 2
]
08:36:19.130 - org.mybatis.spring.SqlSessionUtils - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2d5a1588]
08:36:19.130 - org.mybatis.spring.SqlSessionUtils - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2d5a1588]
08:36:19.130 - org.springframework.jdbc.datasource.DataSourceTransactionManager - Initiating transaction rollback
08:36:19.130 - org.springframework.jdbc.datasource.DataSourceTransactionManager - Rolling back JDBC transaction on Connection [org.apache.shardingsphere.shardingjdbc.jdbc.core.connection.ShardingConnection@588545ac]
08:36:19.161 - org.springframework.jdbc.datasource.DataSourceUtils - Resetting read-only flag of JDBC Connection [org.apache.shardingsphere.shardingjdbc.jdbc.core.connection.ShardingConnection@588545ac]
08:36:19.162 - org.springframework.jdbc.datasource.DataSourceTransactionManager - Releasing JDBC Connection [org.apache.shardingsphere.shardingjdbc.jdbc.core.connection.ShardingConnection@588545ac] after transaction
08:36:19.162 - org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
08:36:19.164 - org.springframework.test.context.support.AbstractDirtiesContextTestExecutionListener - After test method: context [DefaultTestContext@23a5fd2 testClass = UserAccountServiceTest, testInstance = com.sanxiang.services.UserAccountServiceTest@7ff2a664, testMethod = _registerTest@UserAccountServiceTest, testException = org.springframework.jdbc.BadSqlGrammarException:
### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'from, id) VALUES ('$2a$10$4MqyUbZ70.Y9m7cjOUwHz.Eks3I7SsimA4ekiecvs0RZ/HNU6/kqC'' at line 2
### The error may involve com.sanxiang.dal.persistence.UserMapper.insertSelective-Inline
### The error occurred while setting parameters
### SQL: insert into `user` ( password, status, phone, jm_flag, activate_flag, `from` ) values ( ?, ?, ?, ?, ?, ? )
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'from, id) VALUES ('$2a$10$4MqyUbZ70.Y9m7cjOUwHz.Eks3I7SsimA4ekiecvs0RZ/HNU6/kqC'' at line 2
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'from, id) VALUES ('$2a$10$4MqyUbZ70.Y9m7cjOUwHz.Eks3I7SsimA4ekiecvs0RZ/HNU6/kqC'' at line 2, mergedContextConfiguration = [MergedContextConfiguration@78a2da20 testClass = UserAccountServiceTest, locations = '{classpath:META-INF/spring/service-*.xml}', classes = '{}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{}', contextCustomizers = set[[empty]], contextLoader = 'org.springframework.test.context.support.DelegatingSmartContextLoader', parent = [null]]], class annotated with @DirtiesContext [false] with mode [null], method annotated with @DirtiesContext [false] with mode [null].
org.springframework.jdbc.BadSqlGrammarException:
### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'from, id) VALUES ('$2a$10$4MqyUbZ70.Y9m7cjOUwHz.Eks3I7SsimA4ekiecvs0RZ/HNU6/kqC'' at line 2
### The error may involve com.sanxiang.dal.persistence.UserMapper.insertSelective-Inline
### The error occurred while setting parameters
### SQL: insert into `user` ( password, status, phone, jm_flag, activate_flag, `from` ) values ( ?, ?, ?, ?, ?, ? )
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'from, id) VALUES ('$2a$10$4MqyUbZ70.Y9m7cjOUwHz.Eks3I7SsimA4ekiecvs0RZ/HNU6/kqC'' at line 2
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'from, id) VALUES ('$2a$10$4MqyUbZ70.Y9m7cjOUwHz.Eks3I7SsimA4ekiecvs0RZ/HNU6/kqC'' at line 2
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
at com.sun.proxy.$Proxy34.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.$Proxy37.insertSelective(Unknown Source)
at com.sanxiang.dal.repository.UserRepository.save(UserRepository.java:16)
at com.sanxiang.services.UserAccountServiceImpl.register(UserAccountServiceImpl.java:322)
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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy44.register(Unknown Source)
at com.sanxiang.services.UserAccountServiceTest._registerTest(UserAccountServiceTest.java:60)
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.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
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:252)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94)
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.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
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:191)
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: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'from, id) VALUES ('$2a$10$4MqyUbZ70.Y9m7cjOUwHz.Eks3I7SsimA4ekiecvs0RZ/HNU6/kqC'' at line 2
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
at com.mysql.jdbc.Util.getInstance(Util.java:387)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1192)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3409)
at com.alibaba.druid.filter.FilterAdapter.preparedStatement_execute(FilterAdapter.java:1080)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407)
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407)
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)
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.serialExecute(ShardingExecuteEngine.java:91)
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 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.$Proxy60.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.$Proxy58.update(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
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)
... 51 more
```
----------------------------------------------------------------
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
With regards,
Apache Git Services