Issue Details#967 error?

  • Priority: Normal
  • Number: 967
  • Type: Bug
  • Status: New
  • Age: 672 Days

Description

error?

[25-05 18:50:06 ] [Server] [Informatie] [18:50:06 [Informatie]]: [Prism]: Cleared 0 rows from the database. Using: a:water-flow before:4w [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 [Informatie]]: [Prism]: Prism database error. We have to bail in the middle of building primary bulk insert query. [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (mine_mid16221.prism_data_extra, CONSTRAINT prism_data_extra_ibfk_1 FOREIGN KEY (data_id) REFERENCES prism_data (id) ON DELETE CASCADE ON UPDATE NO ACTION) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2018) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1449) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at me.botsko.prism.actionlibs.RecordingTask.insertExtraData(RecordingTask.java:322) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at me.botsko.prism.actionlibs.RecordingTask.insertActionsIntoDatabase(RecordingTask.java:256) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at me.botsko.prism.actionlibs.RecordingTask.save(RecordingTask.java:36) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at me.botsko.prism.actionlibs.RecordingTask.run(RecordingTask.java:352) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftTask.run(CraftTask.java:71) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at java.lang.Thread.run(Thread.java:745) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 [Informatie]]: [Prism]: Database connection error: Cannot add or update a child row: a foreign key constraint fails (mine_mid16221.prism_data_extra, CONSTRAINT prism_data_extra_ibfk_1 FOREIGN KEY (data_id) REFERENCES prism_data (id) ON DELETE CASCADE ON UPDATE NO ACTION) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (mine_mid16221.prism_data_extra, CONSTRAINT prism_data_extra_ibfk_1 FOREIGN KEY (data_id) REFERENCES prism_data (id) ON DELETE CASCADE ON UPDATE NO ACTION) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2018) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1449) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at me.botsko.prism.actionlibs.RecordingTask.insertExtraData(RecordingTask.java:322) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at me.botsko.prism.actionlibs.RecordingTask.insertActionsIntoDatabase(RecordingTask.java:256) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at me.botsko.prism.actionlibs.RecordingTask.save(RecordingTask.java:36) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at me.botsko.prism.actionlibs.RecordingTask.run(RecordingTask.java:352) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftTask.run(CraftTask.java:71) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [25-05 18:50:15 ] [Server] [Informatie] [18:50:15 WARN]: at java.lang.Thread.run(Thread.java:745) [25-05 18:53:42 ] [Server] [Informatie] [18:53:42 [Informatie]]: [Prism]: Prism database error. We have to bail in the middle of building extra data bulk insert query. [25-05 19:00:49 ] [Server] [Informatie] [19:00:49 [Informatie]]: [Prism]: Prism database error. We have to bail in the middle of building primary bulk insert query. [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (mine_mid16221.prism_data_extra, CONSTRAINT prism_data_extra_ibfk_1 FOREIGN KEY (data_id) REFERENCES prism_data (id) ON DELETE CASCADE ON UPDATE NO ACTION) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2018) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1449) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at me.botsko.prism.actionlibs.RecordingTask.insertExtraData(RecordingTask.java:322) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at me.botsko.prism.actionlibs.RecordingTask.insertActionsIntoDatabase(RecordingTask.java:256) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at me.botsko.prism.actionlibs.RecordingTask.save(RecordingTask.java:36) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at me.botsko.prism.actionlibs.RecordingTask.run(RecordingTask.java:352) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftTask.run(CraftTask.java:71) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at java.lang.Thread.run(Thread.java:745) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 [Informatie]]: [Prism]: Database connection error: Cannot add or update a child row: a foreign key constraint fails (mine_mid16221.prism_data_extra, CONSTRAINT prism_data_extra_ibfk_1 FOREIGN KEY (data_id) REFERENCES prism_data (id) ON DELETE CASCADE ON UPDATE NO ACTION) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (mine_mid16221.prism_data_extra, CONSTRAINT prism_data_extra_ibfk_1 FOREIGN KEY (data_id) REFERENCES prism_data (id) ON DELETE CASCADE ON UPDATE NO ACTION) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2018) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1449) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at me.botsko.prism.actionlibs.RecordingTask.insertExtraData(RecordingTask.java:322) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at me.botsko.prism.actionlibs.RecordingTask.insertActionsIntoDatabase(RecordingTask.java:256) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at me.botsko.prism.actionlibs.RecordingTask.save(RecordingTask.java:36) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at me.botsko.prism.actionlibs.RecordingTask.run(RecordingTask.java:352) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftTask.run(CraftTask.java:71) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [25-05 19:02:17 ] [Server] [Informatie] [19:02:17 WARN]: at java.lang.Thread.run(Thread.java:745) [25-05 19:04:37 ] [Server] [Informatie] [19:04:37 [Informatie]]: [Prism]: Prism database error. We have to bail in the middle of building extra data bulk insert query. [25-05 19:18:16 ] [Server] [Informatie] [19:18:16 [Informatie]]: [Prism]: Prism database error. We have to bail in the middle of building extra data bulk insert query.

History

kingvocalwolf Gravatar

kingvocalwolf May 25, 2015 5:36 PM

Issue reported.

Update Issue

Add your comments to this issue!

Creating a free account will let you immediately report issues on this project, as well as comment on existing issues, save your filters, and more!!