sql异常

[addpromax]

问题描述

出现数据库报错

问题复现率

必现

复现步骤

[10:44:59 ERROR]: [Slimefun] Exception thrown while executing write task:
[10:44:59 WARN]: java.lang.IllegalStateException: An exception thrown while executing sql: INSERT OR IGNORE INTO block_data (data_val, loc, data_key) VALUES ('MTMuMA==', 'sc1;893:63:4201', 'fuel');
[10:44:59 WARN]: at Slimefun-af4cb3b-Beta.jar//com.xzavier0722.mc.plugin.slimefun4.storage.adapter.sqlcommon.SqlCommonAdapter.executeSql(SqlCommonAdapter.java:30)
[10:44:59 WARN]: at Slimefun-af4cb3b-Beta.jar//com.xzavier0722.mc.plugin.slimefun4.storage.adapter.sqlite.SqliteAdapter.executeSql(SqliteAdapter.java:317)
[10:44:59 WARN]: at Slimefun-af4cb3b-Beta.jar//com.xzavier0722.mc.plugin.slimefun4.storage.adapter.sqlite.SqliteAdapter.setData(SqliteAdapter.java:88)
[10:44:59 WARN]: at Slimefun-af4cb3b-Beta.jar//com.xzavier0722.mc.plugin.slimefun4.storage.controller.ADataController.lambda$scheduleWriteTask$1(ADataController.java:87)
[10:44:59 WARN]: at Slimefun-af4cb3b-Beta.jar//com.xzavier0722.mc.plugin.slimefun4.storage.task.QueuedWriteTask.run(QueuedWriteTask.java:24)
[10:44:59 WARN]: at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
[10:44:59 WARN]: at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
[10:44:59 WARN]: at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
[10:44:59 WARN]: at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
[10:44:59 WARN]: at java.base/java.lang.Thread.run(Thread.java:833)
[10:44:59 WARN]: Caused by: org.sqlite.SQLiteException: [SQLITE_CONSTRAINT_FOREIGNKEY] A foreign key constraint failed (FOREIGN KEY constraint failed)
[10:44:59 WARN]: at org.sqlite.core.DB.newSQLException(DB.java:1179)
[10:44:59 WARN]: at org.sqlite.core.DB.newSQLException(DB.java:1190)
[10:44:59 WARN]: at org.sqlite.core.DB.execute(DB.java:985)
[10:44:59 WARN]: at org.sqlite.core.CoreStatement.exec(CoreStatement.java:79)
[10:44:59 WARN]: at org.sqlite.jdbc3.JDBC3Statement.lambda$execute$0(JDBC3Statement.java:52)
[10:44:59 WARN]: at org.sqlite.jdbc3.JDBC3Statement.withConnectionTimeout(JDBC3Statement.java:454)
[10:44:59 WARN]: at org.sqlite.jdbc3.JDBC3Statement.execute(JDBC3Statement.java:40)
[10:44:59 WARN]: at Slimefun-af4cb3b-Beta.jar//com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94)
[10:44:59 WARN]: at Slimefun-af4cb3b-Beta.jar//com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
[10:44:59 WARN]: at Slimefun-af4cb3b-Beta.jar//com.xzavier0722.mc.plugin.slimefun4.storage.adapter.sqlcommon.SqlUtils.execSql(SqlUtils.java:148)
[10:44:59 WARN]: at Slimefun-af4cb3b-Beta.jar//com.xzavier0722.mc.plugin.slimefun4.storage.adapter.sqlcommon.SqlCommonAdapter.executeSql(SqlCommonAdapter.java:28)
[10:44:59 WARN]: ... 9 more

服务端类型

Purpur

Minecraft 版本

1.20.x

Slimefun 版本

Slimefun vaf4cb3b-Beta

其他插件信息

No response

补充信息

No response

[mcchampions]

#807 ？

[Xzavier0722]

已知问题，#807