org.nutz.dao.DaoException: org.nutz.dao.DaoException: !Nutz SQL Error: 'insert into t_modbus_get_test(cmdID,deviceID,createDateTime,dispatchDateTime,ackDateTime,lastDateTime,cmdStatus,address40001,address40002,address40003,address40004,address40005,address40006,address40007,address40008,address40009,address40010,address40011,address40012,address40013,address40014,address40015,address40016,address40017,address40018,address40019,address40020,address40021,address40022,address40023,address40024,address40025,address40026,address40027,address40028,address40029,address40030,address40031,address40032,address40033,address40034,address40035,address40036,address40037,address40038,address40039,address40040,address40041,address40042,address40043,address40044,address40045,address40046,address40047,address40048,address40049,address40050,address40051,address40052,address40053,address40054,address40055,address40056,address40057,address40058,address40059,address40060,address40061,address40062,address40063,address40064,address40065,address40066,address40067,address40068,address40069,address40070,address40071,address40072,address40073,address40074,address40075,address40076,address40077,address40078,address40079,address40080,address40081,address40082,address40083,address40084,address40085,address40086,address40087,address40088,address40089,address40090,address40091,address40092,address40093,address40094,address40095,address40096,address40097,address40098,address40099)values('2018-05-24 11:04:18_34694508062061797774','00123456','2018-05-24 11:04:17.4810','2018-05-24 11:04:17.4960','2018-05-24 11:04:18.6540','2018-05-24 11:04:22.7000','ok',253,156,532,123,250,248,143,544,125,240,243,153,525,132,270,257,146,537,131,260,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)'
PreparedStatement:
'insert into t_modbus_get_test(cmdID,deviceID,createDateTime,dispatchDateTime,ackDateTime,lastDateTime,cmdStatus,address40001,address40002,address40003,address40004,address40005,address40006,address40007,address40008,address40009,address40010,address40011,address40012,address40013,address40014,address40015,address40016,address40017,address40018,address40019,address40020,address40021,address40022,address40023,address40024,address40025,address40026,address40027,address40028,address40029,address40030,address40031,address40032,address40033,address40034,address40035,address40036,address40037,address40038,address40039,address40040,address40041,address40042,address40043,address40044,address40045,address40046,address40047,address40048,address40049,address40050,address40051,address40052,address40053,address40054,address40055,address40056,address40057,address40058,address40059,address40060,address40061,address40062,address40063,address40064,address40065,address40066,address40067,address40068,address40069,address40070,address40071,address40072,address40073,address40074,address40075,address40076,address40077,address40078,address40079,address40080,address40081,address40082,address40083,address40084,address40085,address40086,address40087,address40088,address40089,address40090,address40091,address40092,address40093,address40094,address40095,address40096,address40097,address40098,address40099)values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)'
at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:49)
at org.nutz.dao.impl.DaoSupport$DaoExec.run(DaoSupport.java:211)
at org.nutz.trans.Trans.exec(Trans.java:123)
at org.nutz.trans.Trans.exec(Trans.java:81)
at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:184)
at org.nutz.dao.impl.DaoSupport.execute(DaoSupport.java:175)
at com.hg.db.mariadb.DBManager.insertModbusGetResultWithOKStatus(DBManager.java:3024)
at com.hg.rocketmq.DeviceMsgConsumer.handleModbusGet(DeviceMsgConsumer.java:148)
at com.hg.rocketmq.DeviceMsgConsumer.consumeMessage(DeviceMsgConsumer.java:101)
at com.alibaba.rocketmq.client.impl.consumer.ConsumeMessageConcurrentlyService$ConsumeRequest.run(ConsumeMessageConcurrentlyService.java:142)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.nutz.dao.DaoException: !Nutz SQL Error: 'insert into t_modbus_get_test(cmdID,deviceID,createDateTime,dispatchDateTime,ackDateTime,lastDateTime,cmdStatus,address40001,address40002,address40003,address40004,address40005,address40006,address40007,address40008,address40009,address40010,address40011,address40012,address40013,address40014,address40015,address40016,address40017,address40018,address40019,address40020,address40021,address40022,address40023,address40024,address40025,address40026,address40027,address40028,address40029,address40030,address40031,address40032,address40033,address40034,address40035,address40036,address40037,address40038,address40039,address40040,address40041,address40042,address40043,address40044,address40045,address40046,address40047,address40048,address40049,address40050,address40051,address40052,address40053,address40054,address40055,address40056,address40057,address40058,address40059,address40060,address40061,address40062,address40063,address40064,address40065,address40066,address40067,address40068,address40069,address40070,address40071,address40072,address40073,address40074,address40075,address40076,address40077,address40078,address40079,address40080,address40081,address40082,address40083,address40084,address40085,address40086,address40087,address40088,address40089,address40090,address40091,address40092,address40093,address40094,address40095,address40096,address40097,address40098,address40099)values('2018-05-24 11:04:18_34694508062061797774','00123456','2018-05-24 11:04:17.4810','2018-05-24 11:04:17.4960','2018-05-24 11:04:18.6540','2018-05-24 11:04:22.7000','ok',253,156,532,123,250,248,143,544,125,240,243,153,525,132,270,257,146,537,131,260,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)'
PreparedStatement:
'insert into t_modbus_get_test(cmdID,deviceID,createDateTime,dispatchDateTime,ackDateTime,lastDateTime,cmdStatus,address40001,address40002,address40003,address40004,address40005,address40006,address40007,address40008,address40009,address40010,address40011,address40012,address40013,address40014,address40015,address40016,address40017,address40018,address40019,address40020,address40021,address40022,address40023,address40024,address40025,address40026,address40027,address40028,address40029,address40030,address40031,address40032,address40033,address40034,address40035,address40036,address40037,address40038,address40039,address40040,address40041,address40042,address40043,address40044,address40045,address40046,address40047,address40048,address40049,address40050,address40051,address40052,address40053,address40054,address40055,address40056,address40057,address40058,address40059,address40060,address40061,address40062,address40063,address40064,address40065,address40066,address40067,address40068,address40069,address40070,address40071,address40072,address40073,address40074,address40075,address40076,address40077,address40078,address40079,address40080,address40081,address40082,address40083,address40084,address40085,address40086,address40087,address40088,address40089,address40090,address40091,address40092,address40093,address40094,address40095,address40096,address40097,address40098,address40099)values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)'
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:172)
at org.nutz.dao.impl.DaoSupport$DaoExec.invoke(DaoSupport.java:221)
at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:30)
... 14 more
Caused by: java.sql.SQLException: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:149)
at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106)
at org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:263)
at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:287)
at org.mariadb.jdbc.MySQLPreparedStatement.execute(MySQLPreparedStatement.java:141)
at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:202)
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:162)
... 16 more
Caused by: org.mariadb.jdbc.internal.common.QueryException: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult(MySQLProtocol.java:934)
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:983)
at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:280)
... 19 more