MobHunting

MobHunting

114k Downloads

Mysql error

cdmvirt opened this issue ยท 5 comments

commented

[04:17:54 WARN]: one.lindegaard.MobHunting.storage.DataStoreException: java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DUPLICATE KEY UPDATE SET CREATED_DATE=1532765871259, END_DATE=1535357871259, ' at line 1
[04:17:54 WARN]: at one.lindegaard.MobHunting.storage.MySQLDataStore.saveBounties(MySQLDataStore.java:334)
[04:17:54 WARN]: at one.lindegaard.MobHunting.storage.asynch.StoreTask.run(StoreTask.java:53)
[04:17:54 WARN]: at one.lindegaard.MobHunting.storage.asynch.StoreTask.run(StoreTask.java:13)
[04:17:54 WARN]: at one.lindegaard.MobHunting.storage.DataStoreManager$TaskThread.run(DataStoreManager.java:404)
[04:17:54 WARN]: Caused by: java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DUPLICATE KEY UPDATE SET CREATED_DATE=1532765871259, END_DATE=1535357871259, ' at line 1
[04:17:54 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[04:17:54 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[04:17:54 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[04:17:54 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
[04:17:54 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[04:17:54 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
[04:17:54 WARN]: at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1163)
[04:17:54 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1778)
[04:17:54 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1262)
[04:17:54 WARN]: at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:970)
[04:17:54 WARN]: at one.lindegaard.MobHunting.storage.MySQLDataStore.saveBounties(MySQLDataStore.java:327)
[04:17:54 WARN]: ... 3 more
[04:17:54 WARN]: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DUPLICATE KEY UPDATE SET CREATED_DATE=1532765871259, END_DATE=1535357871259, ' at line 1
[04:17:54 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[04:17:54 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[04:17:54 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[04:17:54 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
[04:17:54 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[04:17:54 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
[04:17:54 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
[04:17:54 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
[04:17:54 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
[04:17:54 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
[04:17:54 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
[04:17:54 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
[04:17:54 WARN]: at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
[04:17:54 WARN]: at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)
[04:17:54 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1756)
[04:17:54 WARN]: ... 6 more

commented

Does this happen all the time or only once?

commented

I think I found this bug.

Please test buil 682

https://fractal.lindegaard.one:8181/job/MobHunting/682/

commented

[04:42:43 WARN]: one.lindegaard.MobHunting.storage.DataStoreException: java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DUPLICATE KEY UPDATE CREATED_DATE=1533285737552, END_DATE=1535877737552, PRIZ' at line 1
[04:42:43 WARN]: at one.lindegaard.MobHunting.storage.MySQLDataStore.saveBounties(MySQLDataStore.java:341)
[04:42:43 WARN]: at one.lindegaard.MobHunting.storage.asynch.StoreTask.run(StoreTask.java:53)
[04:42:43 WARN]: at one.lindegaard.MobHunting.storage.asynch.StoreTask.run(StoreTask.java:13)
[04:42:43 WARN]: at one.lindegaard.MobHunting.storage.DataStoreManager$TaskThread.run(DataStoreManager.java:404)
[04:42:43 WARN]: Caused by: java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DUPLICATE KEY UPDATE CREATED_DATE=1533285737552, END_DATE=1535877737552, PRIZ' at line 1
[04:42:43 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[04:42:43 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[04:42:43 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[04:42:43 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
[04:42:43 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[04:42:43 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
[04:42:43 WARN]: at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1163)
[04:42:43 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1778)
[04:42:43 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1262)
[04:42:43 WARN]: at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:970)
[04:42:43 WARN]: at one.lindegaard.MobHunting.storage.MySQLDataStore.saveBounties(MySQLDataStore.java:334)
[04:42:43 WARN]: ... 3 more
[04:42:43 WARN]: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DUPLICATE KEY UPDATE CREATED_DATE=1533285737552, END_DATE=1535877737552, PRIZ' at line 1
[04:42:43 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[04:42:43 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[04:42:43 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[04:42:43 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
[04:42:43 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[04:42:43 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
[04:42:43 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
[04:42:43 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
[04:42:43 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
[04:42:43 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
[04:42:43 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
[04:42:43 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
[04:42:43 WARN]: at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
[04:42:43 WARN]: at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)
[04:42:43 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1756)
[04:42:43 WARN]: ... 6 more

commented
commented

PLease confirm, when you have tried the snapshot