insert 返回0,errno:1023 program err:java.lang.NullPointerException
mycat版本:5.6.29-mycat-1.6-RELEASE jdk版本:1.7.0_80
spring开启了事务,先select,然后执行insert语句,insert有获取Mysql生成的ID
<selectKey resultType="java.lang.Integer" keyProperty="id" order="AFTER"> <![CDATA[select LAST_INSERT_ID() AS ID ]]> </selectKey>
返回0,提交的时候报错,回滚也报错: org.springframework.transaction.IllegalTransactionStateException: Transaction is already completed - do not call commit or rollback more than once per transaction.
mycat报错:
2018-12-26 15:10:00.249 WARN [$_NIOREACTOR-1-RW] (io.mycat.backend.mysql.nio.handler.SingleNodeHandler.backConnectionErr(SingleNo deHandler.java:249)) - execute sql err : errno:1023 program err:java.lang.NullPointerException con:MySQLConnection [id=234647, la stTime=1545808200213, user=xxx, schema=mydb, old shema=mydb, borrowed=true, fromSlaveDB=false, threadId=872486856, charset=utf8, txIsolation=2, autocommit=false, attachment=dn_1{insert into my_table...
2018-12-26 15:10:00.248 INFO [$_NIOREACTOR-1-RW] (io.mycat.net.AbstractConnection.close(AbstractConnection.java:508)) - close con nection,reason:program err:java.lang.NullPointerException
后续的sql执行报错: java.sql.SQLException: Transaction error, need to rollback. errno:1023 program err: java.lang.NullPointerException
Source: MyCATApache/Mycat-Server