Player data corrupted | SpigotMC | Page 1

lyric wave Apr 15, 2024, 6:55 AM

#

The player data on my server got corrupted, it gets reset every time a person logs off, so no matter what they do they spawn back at the server-spawn location without any items or anything
Not sure of what caused it, some of the plugins we use are essentialsx, dynmap and coreprotect
I have a text file of the log when it started going wrong too, not sure how to upload it

#

[04:28:16] [Thread-20/WARN]: org.sqlite.SQLiteException: [SQLITE_READONLY_DIRECTORY] Process does not have permission to create a journal file in the same directory as the database and the creation of a journal file is a prerequisite for writing (attempt to write a readonly database)
[04:28:16] [Thread-20/WARN]: at org.sqlite.core.DB.newSQLException(DB.java:1179)
[04:28:16] [Thread-20/WARN]: at org.sqlite.core.DB.newSQLException(DB.java:1190)
[04:28:16] [Thread-20/WARN]: at org.sqlite.core.DB.throwex(DB.java:1150)
[04:28:16] [Thread-20/WARN]: at org.sqlite.core.NativeDB._exec_utf8(Native Method)
[04:28:16] [Thread-20/WARN]: at org.sqlite.core.NativeDB._exec(NativeDB.java:93)
[04:28:16] [Thread-20/WARN]: at org.sqlite.jdbc3.JDBC3Statement.lambda$executeLargeUpdate$2(JDBC3Statement.java:128)
[04:28:16] [Thread-20/WARN]: at org.sqlite.jdbc3.JDBC3Statement.withConnectionTimeout(JDBC3Statement.java:454)
[04:28:16] [Thread-20/WARN]: at org.sqlite.jdbc3.JDBC3Statement.executeLargeUpdate(JDBC3Statement.java:115)
[04:28:16] [Thread-20/WARN]: at org.sqlite.jdbc3.JDBC3Statement.executeUpdate(JDBC3Statement.java:102)
[04:28:16] [Thread-20/WARN]: at CoreProtect-22.2.jar//net.coreprotect.database.Database.performCheckpoint(Database.java:94)

#

That's some stuff from the log, idk if it explains anything (._,)

static lotus Apr 15, 2024, 7:19 AM

#

are u saving player data in a database?

#

well this is a SQL(Database) error telling you the account it uses doesnt have the required permissions

lyric wave Apr 15, 2024, 7:23 AM

#

Do you know why it would happen or how to fix it? Since, it seemed to be working fine for a while, it just broke quite randomly, recently, whilst no one was online

static lotus Apr 15, 2024, 7:25 AM

#

static lotus are u saving player data in a database?

.

#

where is your database located?

lyric wave Apr 15, 2024, 7:30 AM

#

To be honest I don't even know really ;-;
We have a staff team and the person that knows more about this stuff went to sleep recently
I know we use a hosting service called Sparked host, if that helps, but if not then I might need to wait for the person that knows more about it to be awake, though he didn't know what caused it either

static lotus Apr 15, 2024, 7:31 AM

#

Yeah you should definitely wait for them to wake up then. I could try to help you now but i just gut way too little information.

lyric wave Apr 15, 2024, 7:33 AM

#

Sounds good, I'll let you know where it's located once I get the actual info myself lol
ty

#Player data corrupted