MrTigreroux / TigerReports

Spigot plugin to manage player reports.
16 stars 17 forks source link

[ERROR] Database file is locked #117

Closed ilfarpro closed 1 year ago

ilfarpro commented 2 years ago

TigerReports version 5.0.16 Purpur 1.18.2-1628 build

[ср 16:08:24 ERROR Minecraft] [TigerReports] An error has occurred with the database:
org.sqlite.SQLiteException: [SQLITE_BUSY]  The database file is locked (database is locked)
    at org.sqlite.core.DB.newSQLException(DB.java:1030)
    at org.sqlite.core.DB.newSQLException(DB.java:1042)
    at org.sqlite.core.DB.execute(DB.java:881)
    at org.sqlite.core.DB.executeUpdate(DB.java:922)
    at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:98)
    at TigerReports.jar//fr.mrtigreroux.tigerreports.data.database.Database.update(Database.java:59)
    at TigerReports.jar//fr.mrtigreroux.tigerreports.data.database.Database$1.run(Database.java:81)
    at org.bukkit.craftbukkit.v1_18_R2.scheduler.CraftTask.run(CraftTask.java:101)
    at org.bukkit.craftbukkit.v1_18_R2.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57)
    at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
    at java.base/java.lang.Thread.run(Thread.java:833)
MrTigreroux commented 2 years ago

Hello,

Could you give me the full logs from "[TigerReports] Enabling ..." to that error (removing sensitive informations like IPs..., you can send them in SpigotMC if you are not sure). Thank you in advance.

Does typing /reports reload make the plugin work again ? Does a server restart does too ?

ilfarpro commented 2 years ago

I can't give full logs right now, because logs with this error are too long (weeks) and fragmented to parts. I've restarted my server and once I catch this error again I will provide logs. Worth to mention that I previously tried to restart server and it did not helped to get rid of this error. This error not breaks plugin, it continues to work as intended. I tried to use /report and /reports command and it's not triggering this error. No any erorrs or warnings at plugin startup. Please, do not close this issue for a while.

MrTigreroux commented 2 years ago

Ok, then could you give me one logs file (the last before that error) ?

Worth to mention that I previously tried to restart server and it did not helped to get rid of this error.

Do you mean that your restarted your server and the error still happened ? If so it would be really interesting to see the logs (that I understand are really short) before the error happened (again).

MrTigreroux commented 1 year ago

Hello, the issue you had should be fixed in the new version 5.1. It took a lot of time but I think that I finally found the cause of the problem. Please let me know if it's not the case.