MySql Error
cdmvirt opened this issue ยท 10 comments
Please help me testing this build
https://fractal.lindegaard.one:8181/job/MobHunting/697/
That should not be needed :-)
I decided to drop the CONSTRAINT completely
PLease test build 700
https://fractal.lindegaard.one:8181/job/MobHunting/700/
still not fixed... I have another ๐
[21:22:03 WARN]: one.lindegaard.MobHunting.storage.DataStoreException: java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (
mobhunting.
mh_Bounties, CONSTRAINT
mh_Bounties_Player_Id_1 FOREIGN KEY (
BOUNTYOWNER_ID) REFERENCES
mh_Players (
PLAYER_ID) ON DELETE CASCADE) [21:22:03 WARN]: at one.lindegaard.MobHunting.storage.MySQLDataStore.saveBounties(MySQLDataStore.java:336) [21:22:03 WARN]: at one.lindegaard.MobHunting.storage.asynch.StoreTask.run(StoreTask.java:53) [21:22:03 WARN]: at one.lindegaard.MobHunting.storage.asynch.StoreTask.run(StoreTask.java:13) [21:22:03 WARN]: at one.lindegaard.MobHunting.storage.DataStoreManager$TaskThread.run(DataStoreManager.java:404) [21:22:03 WARN]: Caused by: java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (
mobhunting.
mh_Bounties, CONSTRAINT
mh_Bounties_Player_Id_1 FOREIGN KEY (
BOUNTYOWNER_ID) REFERENCES
mh_Players (
PLAYER_ID) ON DELETE CASCADE) [21:22:03 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [21:22:03 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [21:22:03 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [21:22:03 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423) [21:22:03 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) [21:22:03 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408) [21:22:03 WARN]: at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1163) [21:22:03 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1778) [21:22:03 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1262) [21:22:03 WARN]: at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:970) [21:22:03 WARN]: at one.lindegaard.MobHunting.storage.MySQLDataStore.saveBounties(MySQLDataStore.java:329) [21:22:03 WARN]: ... 3 more [21:22:03 WARN]: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (
mobhunting.
mh_Bounties, CONSTRAINT
mh_Bounties_Player_Id_1 FOREIGN KEY (
BOUNTYOWNER_ID) REFERENCES
mh_Players (
PLAYER_ID) ON DELETE CASCADE) [21:22:03 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [21:22:03 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [21:22:03 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [21:22:03 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423) [21:22:03 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) [21:22:03 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408) [21:22:03 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) [21:22:03 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976) [21:22:03 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912) [21:22:03 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) [21:22:03 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) [21:22:03 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486) [21:22:03 WARN]: at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) [21:22:03 WARN]: at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079) [21:22:03 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1756) [21:22:03 WARN]: ... 6 more