Advertisement
adamferg123

database error

Oct 29th, 2018
335
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.61 KB | None | 0 0
  1. [23:17:41 INFO]: Getblock issued server command: /resident claimtransfer test 5
  2. [23:17:41 WARN]: java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`game_live_kingdoms`.`kingdoms_logs`, CONSTRAINT `kingdoms_logs_ibfk_1` FOREIGN KEY (`empireId`) REFERENCES `kingdoms_empires` (`id`) ON DELETE CASCADE)
  3. [23:17:41 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  4. [23:17:41 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  5. [23:17:41 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  6. [23:17:41 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  7. [23:17:41 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  8. [23:17:41 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
  9. [23:17:41 WARN]: at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1163)
  10. [23:17:41 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1823)
  11. [23:17:41 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1307)
  12. [23:17:41 WARN]: at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:970)
  13. [23:17:41 WARN]: at me.crz.minecraft.kingdoms.libs.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:128)
  14. [23:17:41 WARN]: at me.crz.minecraft.kingdoms.libs.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
  15. [23:17:41 WARN]: at me.crz.minecraft.kingdoms.db.MySqlDatabaseManager.log(MySqlDatabaseManager.java:647)
  16. [23:17:41 WARN]: at me.crz.minecraft.kingdoms.db.DatabaseManager.log(DatabaseManager.java:88)
  17. [23:17:41 WARN]: at me.crz.minecraft.kingdoms.command.resident.ResidentClaimTransferCommand.lambda$run$0(ResidentClaimTransferCommand.java:68)
  18. [23:17:41 WARN]: at org.bukkit.craftbukkit.v1_13_R2.scheduler.CraftTask.run(CraftTask.java:63)
  19. [23:17:41 WARN]: at org.bukkit.craftbukkit.v1_13_R2.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:52)
  20. [23:17:41 WARN]: at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
  21. [23:17:41 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  22. [23:17:41 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  23. [23:17:41 WARN]: at java.lang.Thread.run(Thread.java:748)
  24. [23:17:41 WARN]: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`game_live_kingdoms`.`kingdoms_logs`, CONSTRAINT `kingdoms_logs_ibfk_1` FOREIGN KEY (`empireId`) REFERENCES `kingdoms_empires` (`id`) ON DELETE CASCADE)
  25. [23:17:41 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  26. [23:17:41 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  27. [23:17:41 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  28. [23:17:41 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  29. [23:17:41 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  30. [23:17:41 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
  31. [23:17:41 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
  32. [23:17:41 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
  33. [23:17:41 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
  34. [23:17:41 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
  35. [23:17:41 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
  36. [23:17:41 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
  37. [23:17:41 WARN]: at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
  38. [23:17:41 WARN]: at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2124)
  39. [23:17:41 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1801)
  40. [23:17:41 WARN]: ... 13 more
  41. [23:17:43 INFO]: [Admin]Manish1267 ➦ and remove ./chat s from swear
  42. [23:17:45 INFO]: Getblock issued server command: /resident claimtransfer boya 5
  43. [23:17:45 WARN]: java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`game_live_kingdoms`.`kingdoms_logs`, CONSTRAINT `kingdoms_logs_ibfk_1` FOREIGN KEY (`empireId`) REFERENCES `kingdoms_empires` (`id`) ON DELETE CASCADE)
  44. [23:17:45 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  45. [23:17:45 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  46. [23:17:45 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  47. [23:17:45 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  48. [23:17:45 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  49. [23:17:45 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
  50. [23:17:45 WARN]: at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1163)
  51. [23:17:45 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1823)
  52. [23:17:45 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1307)
  53. [23:17:45 WARN]: at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:970)
  54. [23:17:45 WARN]: at me.crz.minecraft.kingdoms.libs.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:128)
  55. [23:17:45 WARN]: at me.crz.minecraft.kingdoms.libs.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
  56. [23:17:45 WARN]: at me.crz.minecraft.kingdoms.db.MySqlDatabaseManager.log(MySqlDatabaseManager.java:647)
  57. [23:17:45 WARN]: at me.crz.minecraft.kingdoms.db.DatabaseManager.log(DatabaseManager.java:88)
  58. [23:17:45 WARN]: at me.crz.minecraft.kingdoms.command.resident.ResidentClaimTransferCommand.lambda$run$0(ResidentClaimTransferCommand.java:68)
  59. [23:17:45 WARN]: at org.bukkit.craftbukkit.v1_13_R2.scheduler.CraftTask.run(CraftTask.java:63)
  60. [23:17:45 WARN]: at org.bukkit.craftbukkit.v1_13_R2.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:52)
  61. [23:17:45 WARN]: at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
  62. [23:17:45 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  63. [23:17:45 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  64. [23:17:45 WARN]: at java.lang.Thread.run(Thread.java:748)
  65. [23:17:45 WARN]: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`game_live_kingdoms`.`kingdoms_logs`, CONSTRAINT `kingdoms_logs_ibfk_1` FOREIGN KEY (`empireId`) REFERENCES `kingdoms_empires` (`id`) ON DELETE CASCADE)
  66. [23:17:45 WARN]: at sun.reflect.GeneratedConstructorAccessor114.newInstance(Unknown Source)
  67. [23:17:45 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  68. [23:17:45 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  69. [23:17:45 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  70. [23:17:45 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
  71. [23:17:45 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
  72. [23:17:45 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
  73. [23:17:45 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
  74. [23:17:45 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
  75. [23:17:45 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
  76. [23:17:45 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
  77. [23:17:45 WARN]: at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
  78. [23:17:45 WARN]: at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2124)
  79. [23:17:45 WARN]: at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1801)
  80. [23:17:45 WARN]: ... 13 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement