本帖最后由 NCxiedi 于 2021-6-19 21:35 编辑
java.sql.SQLException: [SQLITE_BUSY] The database file is locked (database is locked)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.sqlite.DB.newSQLException(DB.java:383)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.sqlite.DB.newSQLException(DB.java:387)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.sqlite.DB.throwex(DB.java:374)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.sqlite.NestedDB.prepare(NestedDB.java:134)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.sqlite.DB.prepare(DB.java:123)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.sqlite.PrepStmt.<init>(PrepStmt.java:42)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.sqlite.Conn.prepareStatement(Conn.java:404)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.sqlite.Conn.prepareStatement(Conn.java:399)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.sqlite.Conn.prepareStatement(Conn.java:383)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at com.handy.playertitle.service.TitleListService.findAllByBuyType(TitleListService.java:245)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at com.handy.playertitle.listener.PermissionTitleListener$1.run(PermissionTitleListener.java:37)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftTask.run(CraftTask.java:71)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at java.lang.Thread.run(Thread.java:748)
[20:21:31] [Craft Scheduler Thread - 395/WARN]: [AuthMe] Error during SQL operation: [SQLException]: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file)
[20:21:31] [Craft Scheduler Thread - 405/WARN]: [AuthMe] Error during SQL operation: [SQLException]: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file)
[20:21:31] [Craft Scheduler Thread - 398/WARN]: [AuthMe] Error during SQL operation: [SQLException]: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file)
[20:21:31] [Craft Scheduler Thread - 342/WARN]: [AuthMe] Error during SQL operation: [SQLException]: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file)
[20:21:31] [Craft Scheduler Thread - 342/WARN]: [AuthMe] Error during SQL operation: [SQLException]: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file)
[20:21:31] [Craft Scheduler Thread - 405/WARN]: [AuthMe] Error during SQL operation: [SQLException]: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file)
[20:21:31] [Craft Scheduler Thread - 402/WARN]: [AuthMe] Error during SQL operation: [SQLException]: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file)
[20:21:31] [Craft Scheduler Thread - 395/WARN]: [AuthMe] Error during SQL operation: [SQLException]: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file)
[20:21:31] [Craft Scheduler Thread - 400/WARN]: [AuthMe] Error during SQL operation: [SQLException]: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file)
如上,这是截取的报错。每次报错就蹦服,求dalao告诉下怎么解决
java.sql.SQLException: [SQLITE_BUSY] The database file is locked (database is locked)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.sqlite.DB.newSQLException(DB.java:383)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.sqlite.DB.newSQLException(DB.java:387)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.sqlite.DB.throwex(DB.java:374)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.sqlite.NestedDB.prepare(NestedDB.java:134)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.sqlite.DB.prepare(DB.java:123)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.sqlite.PrepStmt.<init>(PrepStmt.java:42)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.sqlite.Conn.prepareStatement(Conn.java:404)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.sqlite.Conn.prepareStatement(Conn.java:399)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.sqlite.Conn.prepareStatement(Conn.java:383)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at com.handy.playertitle.service.TitleListService.findAllByBuyType(TitleListService.java:245)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at com.handy.playertitle.listener.PermissionTitleListener$1.run(PermissionTitleListener.java:37)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftTask.run(CraftTask.java:71)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[20:21:06] [Craft Scheduler Thread - 342/WARN]: at java.lang.Thread.run(Thread.java:748)
[20:21:31] [Craft Scheduler Thread - 395/WARN]: [AuthMe] Error during SQL operation: [SQLException]: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file)
[20:21:31] [Craft Scheduler Thread - 405/WARN]: [AuthMe] Error during SQL operation: [SQLException]: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file)
[20:21:31] [Craft Scheduler Thread - 398/WARN]: [AuthMe] Error during SQL operation: [SQLException]: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file)
[20:21:31] [Craft Scheduler Thread - 342/WARN]: [AuthMe] Error during SQL operation: [SQLException]: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file)
[20:21:31] [Craft Scheduler Thread - 342/WARN]: [AuthMe] Error during SQL operation: [SQLException]: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file)
[20:21:31] [Craft Scheduler Thread - 405/WARN]: [AuthMe] Error during SQL operation: [SQLException]: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file)
[20:21:31] [Craft Scheduler Thread - 402/WARN]: [AuthMe] Error during SQL operation: [SQLException]: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file)
[20:21:31] [Craft Scheduler Thread - 395/WARN]: [AuthMe] Error during SQL operation: [SQLException]: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file)
[20:21:31] [Craft Scheduler Thread - 400/WARN]: [AuthMe] Error during SQL operation: [SQLException]: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file)
如上,这是截取的报错。每次报错就蹦服,求dalao告诉下怎么解决
删掉数据库文件重新生成试试
不好,快跑! 发表于 2021-6-20 14:48
删掉数据库文件重新生成试试
昨天删过一次数据库前置后服务器就无法启动了,你说的文件是哪个。是不是这个SpringBootPlugin
删掉plugins\AuthMe\authme.db
注意 删了之后所有玩家的登录数据会丢失
SpringBootPlugin不用删
注意 删了之后所有玩家的登录数据会丢失
SpringBootPlugin不用删
不好,快跑! 发表于 2021-6-20 15:23
删掉plugins\AuthMe\authme.db
注意 删了之后所有玩家的登录数据会丢失
SpringBootPlugin不用删 ...
好的我去试试
不好,快跑! 发表于 2021-6-20 15:23
删掉plugins\AuthMe\authme.db
注意 删了之后所有玩家的登录数据会丢失
SpringBootPlugin不用删 ...
就是要重新注册么,玩家物品不会丢吧
不好,快跑! 发表于 2021-6-20 17:52
对
物品不会丢
目前删了之后当时不会出问题,但是玩了半个小时之后又报错了
把Authme的目录下所有文件删了
Authme的数据库貌似有问题,一连就报错崩服
中文也有问题,语言调成中文后也会崩服
Authme的数据库貌似有问题,一连就报错崩服
中文也有问题,语言调成中文后也会崩服
梦小白 发表于 2021-6-23 13:50
把Authme的目录下所有文件删了
Authme的数据库貌似有问题,一连就报错崩服
中文也有问题,语言调成中文后也 ...
不能删,删了服务器就启动不了一直重启
请问你能够手动连接数据库 并且在数据库进入Authme所生成的表中?
Cinniao 发表于 2021-6-23 20:25
请问你能够手动连接数据库 并且在数据库进入Authme所生成的表中?
这个不会,都是插件自动操作的
本帖最后由 Cinniao 于 2021-6-23 21:01 编辑
可以下载Navicat Premium 然后输入对应的信息,进入数据库。
然后看是否有Authme的表生成
如果无法进入数据库那么
1.确认所有信息均正确,那么确认是否开放数据库的权限
2.数据库信息填写错误
如果没有什么必要对于数据库,可以不选择使用数据库
可以下载Navicat Premium 然后输入对应的信息,进入数据库。
然后看是否有Authme的表生成

如果无法进入数据库那么
1.确认所有信息均正确,那么确认是否开放数据库的权限
2.数据库信息填写错误
如果没有什么必要对于数据库,可以不选择使用数据库