Sign in to follow this  
Zyzyx

sqlite database image is malformed

Recommended Posts

Hi there.

 

A few days ago I swapped my wurm map for a new one. This worked fine.

 

I deleted all creatures from wurmcreatures.db. New creatures spawned in fine.

 

I found guards were unresponsive and NPCs would reset every time the server restarted, so I removed all guards from wurmzones.db. This fixed this issue.

 

A day later the server began to crash every 15~ minutes or so. I deleted all item hooks from wurmitems.db > Items, since I believe they were left over from old missions and the NPCs they were bound to no longer existed.

 

 

Unfortunately the server is still crashing, and after having read the server console I now believe this is in response to non-existing items taking decay hits.

 

My initial action was to delete these items from the database, however I receive the error "database image is malformed".

 

I've performed the pragma integrity_check; which yields the following

"*** in database main ***
On tree page 5746 cell 65: Rowid 82971 out of order
On tree page 5746 cell 64: Rowid 82964 out of order
On tree page 5746 cell 63: Rowid 82957 out of order
On tree page 5746 cell 62: Rowid 82950 out of order
On tree page 5746 cell 61: Rowid 82943 out of order
On tree page 5746 cell 60: Rowid 82936 out of order
On tree page 5746 cell 59: Rowid 82929 out of order
On tree page 3643 cell 1: Rowid 82918 out of order"
"wrong # of entries in index sqlite_autoindex_ITEMDATA_1"
"row 2581 missing from index sqlite_autoindex_ITEMS_1"

I must confess I am at a loss for what to do.

 

Some users have claimed that exporting their database files and then importing them into a new database has fixed this, but importing into a new database seems to cause an error.

Edited by Zyzyx

Share this post


Link to post
Share on other sites

If you are exporting and then importing them into a new db make sure you are not doing it while its running. If the db did not close all the way then you may have the -shm and -wal files still present, basically temp entries that have not be saved yet. If those are already there while the server is not running delete them and try restarting. Depending on how to server got shut down it could leave the database files open and it wont start up correctly, if the server did not shut down properly.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this