The database file is locked (database is locked) ???

[RDecline]

Hosted on HostHavoc
Vanilla - no mods
Has been running for about 1 year real time with no issue

ERROR: General , 1732469479039> 38,000,256,839> DebugLogStream.printException> Stack trace:
org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)
at org.sqlite.core.DB.newSQLException(DB.java:941)
at org.sqlite.core.DB.newSQLException(DB.java:953)
at org.sqlite.core.DB.throwex(DB.java:918)
at org.sqlite.core.DB.exec(DB.java:178)
at org.sqlite.SQLiteConnection.commit(SQLiteConnection.java:404)
at zombie.vehicles.VehiclesDB2$SQLStore.updateDB(VehiclesDB2.java:360)
at zombie.vehicles.VehiclesDB2$SQLStore.updateVehicle(VehiclesDB2.java:296)
at zombie.vehicles.VehiclesDB2$QueueUpdateVehicle.processWorldStreamer(VehiclesDB2.java:1048)
at zombie.vehicles.VehiclesDB2$WorldStreamerThread.update(VehiclesDB2.java:651)
at zombie.vehicles.VehiclesDB2.updateWorldStreamer(VehiclesDB2.java:1076)
at zombie.network.ServerPlayersVehicles$SPVThread.runInner(ServerPlayersVehicles.java:35)
at zombie.network.ServerPlayersVehicles$SPVThread.run(ServerPlayersVehicles.java:23)

[Beard]

It generally means that the vehicle database is being used, such as if you are basically trying to run two servers and the same file is used. Or it can mean that the server does not have access to the file due to various permission settings.

Lastly it can mean the file is corrupted.

When did this issue start happening? And do you have access to the vehicle.db file?

[RDecline]

It just started happening out of the blue a few days ago. I logged in, played for a bit just doing some general tidying around the base area. Then took off to another location. And did notice there were a lot of missing cars. (Weirdly all the vehicles around the base area were there but nowhere else.) Logged out.
Logged back in and the game had saved any of that progress. Character was right back to the main base, so was the car, as if they had never left.

HostHavoc does not have the best access...I'll have to see what I can do but I don't think I can get to the vehicle.db through their file manager.

[RDecline]

...I think I've located the vehicledb2$sqlStore... files.

[Beard]

I do not think those are the correct files, since you are referring to a .class file and not a database file.

The players.db file should specifically be located in the User/Zomboid/Saves/Multiplayer/servername folder, while the file you specified is in the server install location.

You might want to check if the server is also running out of space if that is a possibility? Database corruption can happen often due to that.

[RDecline]

First, I appreciate the responses, thanks!
Yeah...out of space I think is what caused it. I had some weird spike in memory on the server and it went off the chart. I'm not sure anyone was even on when it happened...
For the year the server has been running the memory has seemed weird to me. It seems to ramp up really high and then drop back down into the teens but I've never seen it go over the max like it did a few days ago.

[Lu5ck]

The last time I had that error was because I had two instances of PZ running, so naturally if one PZ is accessing the DB, the other PZ will not be able to access the DB. I then modified start-server.sh to check for multiple instances. On a game host, I assume you need to do a full restart but I am not sure if that is supported on game host panel, it did be quicker to just ask the support to check.