[16:31:29 ERROR]: [Slimefun] Exception thrown while executing write task:
[16:31:29 WARN]: java.lang.IllegalStateException: An exception thrown while executing sql: INSERT OR IGNORE INTO block_data (data_val, loc, data_key) VALUES ('MC4w', 'world;1671:64:303', 'fuel');
[16:31:29 WARN]: at Slimefun-226af9b-Beta_build180.jar//com.xzavier0722.mc.plugin.slimefun4.storage.adapter.sqlcommon.SqlCommonAdapter.executeSql(SqlCommonAdapter.java:30)
[16:31:29 WARN]: at Slimefun-226af9b-Beta_build180.jar//com.xzavier0722.mc.plugin.slimefun4.storage.adapter.sqlite.SqliteAdapter.executeSql(SqliteAdapter.java:317)
[16:31:29 WARN]: at Slimefun-226af9b-Beta_build180.jar//com.xzavier0722.mc.plugin.slimefun4.storage.adapter.sqlite.SqliteAdapter.setData(SqliteAdapter.java:88)
[16:31:29 WARN]: at Slimefun-226af9b-Beta_build180.jar//com.xzavier0722.mc.plugin.slimefun4.storage.controller.ADataController.lambda$scheduleWriteTask$1(ADataController.java:87)
[16:31:29 WARN]: at Slimefun-226af9b-Beta_build180.jar//com.xzavier0722.mc.plugin.slimefun4.storage.task.QueuedWriteTask.run(QueuedWriteTask.java:24)
[16:31:29 WARN]: at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
[16:31:29 WARN]: at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
[16:31:29 WARN]: at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
[16:31:29 WARN]: at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
[16:31:29 WARN]: at java.base/java.lang.Thread.run(Thread.java:1583)
[16:31:29 WARN]: Caused by: org.sqlite.SQLiteException: [SQLITE_CONSTRAINT_FOREIGNKEY] A foreign key constraint failed (FOREIGN KEY constraint failed)
[16:31:29 WARN]: at org.sqlite.core.DB.newSQLException(DB.java:1179)
[16:31:29 WARN]: at org.sqlite.core.DB.newSQLException(DB.java:1190)
[16:31:29 WARN]: at org.sqlite.core.DB.execute(DB.java:985)
[16:31:29 WARN]: at org.sqlite.core.CoreStatement.exec(CoreStatement.java:79)
[16:31:29 WARN]: at org.sqlite.jdbc3.JDBC3Statement.lambda$execute$0(JDBC3Statement.java:52)
[16:31:29 WARN]: at org.sqlite.jdbc3.JDBC3Statement.withConnectionTimeout(JDBC3Statement.java:454)
[16:31:29 WARN]: at org.sqlite.jdbc3.JDBC3Statement.execute(JDBC3Statement.java:40)
[16:31:29 WARN]: at Slimefun-226af9b-Beta_build180.jar//com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94)
[16:31:29 WARN]: at Slimefun-226af9b-Beta_build180.jar//com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
[16:31:29 WARN]: at Slimefun-226af9b-Beta_build180.jar//com.xzavier0722.mc.plugin.slimefun4.storage.adapter.sqlcommon.SqlUtils.execSql(SqlUtils.java:148)
[16:31:29 WARN]: at Slimefun-226af9b-Beta_build180.jar//com.xzavier0722.mc.plugin.slimefun4.storage.adapter.sqlcommon.SqlCommonAdapter.executeSql(SqlCommonAdapter.java:28)
[16:31:29 WARN]: ... 9 more
问题描述
机器人运行几秒钟后频繁产生数据库错误:
[16:31:29 ERROR]: [Slimefun] Exception thrown while executing write task: [16:31:29 WARN]: java.lang.IllegalStateException: An exception thrown while executing sql: INSERT OR IGNORE INTO block_data (data_val, loc, data_key) VALUES ('MC4w', 'world;1671:64:303', 'fuel'); [16:31:29 WARN]: at Slimefun-226af9b-Beta_build180.jar//com.xzavier0722.mc.plugin.slimefun4.storage.adapter.sqlcommon.SqlCommonAdapter.executeSql(SqlCommonAdapter.java:30) [16:31:29 WARN]: at Slimefun-226af9b-Beta_build180.jar//com.xzavier0722.mc.plugin.slimefun4.storage.adapter.sqlite.SqliteAdapter.executeSql(SqliteAdapter.java:317) [16:31:29 WARN]: at Slimefun-226af9b-Beta_build180.jar//com.xzavier0722.mc.plugin.slimefun4.storage.adapter.sqlite.SqliteAdapter.setData(SqliteAdapter.java:88) [16:31:29 WARN]: at Slimefun-226af9b-Beta_build180.jar//com.xzavier0722.mc.plugin.slimefun4.storage.controller.ADataController.lambda$scheduleWriteTask$1(ADataController.java:87) [16:31:29 WARN]: at Slimefun-226af9b-Beta_build180.jar//com.xzavier0722.mc.plugin.slimefun4.storage.task.QueuedWriteTask.run(QueuedWriteTask.java:24) [16:31:29 WARN]: at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572) [16:31:29 WARN]: at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317) [16:31:29 WARN]: at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) [16:31:29 WARN]: at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) [16:31:29 WARN]: at java.base/java.lang.Thread.run(Thread.java:1583) [16:31:29 WARN]: Caused by: org.sqlite.SQLiteException: [SQLITE_CONSTRAINT_FOREIGNKEY] A foreign key constraint failed (FOREIGN KEY constraint failed) [16:31:29 WARN]: at org.sqlite.core.DB.newSQLException(DB.java:1179) [16:31:29 WARN]: at org.sqlite.core.DB.newSQLException(DB.java:1190) [16:31:29 WARN]: at org.sqlite.core.DB.execute(DB.java:985) [16:31:29 WARN]: at org.sqlite.core.CoreStatement.exec(CoreStatement.java:79) [16:31:29 WARN]: at org.sqlite.jdbc3.JDBC3Statement.lambda$execute$0(JDBC3Statement.java:52) [16:31:29 WARN]: at org.sqlite.jdbc3.JDBC3Statement.withConnectionTimeout(JDBC3Statement.java:454) [16:31:29 WARN]: at org.sqlite.jdbc3.JDBC3Statement.execute(JDBC3Statement.java:40) [16:31:29 WARN]: at Slimefun-226af9b-Beta_build180.jar//com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) [16:31:29 WARN]: at Slimefun-226af9b-Beta_build180.jar//com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) [16:31:29 WARN]: at Slimefun-226af9b-Beta_build180.jar//com.xzavier0722.mc.plugin.slimefun4.storage.adapter.sqlcommon.SqlUtils.execSql(SqlUtils.java:148) [16:31:29 WARN]: at Slimefun-226af9b-Beta_build180.jar//com.xzavier0722.mc.plugin.slimefun4.storage.adapter.sqlcommon.SqlCommonAdapter.executeSql(SqlCommonAdapter.java:28) [16:31:29 WARN]: ... 9 more
问题复现率
必现
复现步骤
服务端类型
Paper
Minecraft 版本
1.20.x
Slimefun 版本
2024.3 和 build 180
其他插件信息
No response
补充信息
No response