Sign in to follow this  
Mewter

Problems after patch 1.0.0.6

Recommended Posts

I'm getting alot of errors in my console and it's telling me that my database is malformed, does anyone know a fix for this?

i'm running a couple of mods and modloader but this problem also occurs without mods and modloader.

 

Heres the errors: http://pastebin.com/kTW4xwF5

Share this post


Link to post
Share on other sites

Yea confirmed saw this as well telling me my item DB was malformed but things seem to be working fine so far

 

Share this post


Link to post
Share on other sites

Mewter which server mods are you running?

Share this post


Link to post
Share on other sites

That doesnt even look good at all. 

 

We have a whole set of errors showing up on 1.0.0.6 and at first I thought it was MOD's so i ran a test version of the login cluster and see the same log entries.  None of them appear to have any impact on the gameplay.. Just annoying to tail the logfile. 

 

 

 

Share this post


Link to post
Share on other sites

Are they all the same database and table?

Share this post


Link to post
Share on other sites
10 hours ago, Xyp said:

Mewter which server mods are you running?

I'm running these mods but i have also tested without them, it gives the same errors. Also the disabled ones prevents me from starting the server. (they are outdated)
26e3c4ed6618b2197810e6344d67ad4a.png

8 hours ago, razoreqx said:

That doesnt even look good at all. 

 

We have a whole set of errors showing up on 1.0.0.6 and at first I thought it was MOD's so i ran a test version of the login cluster and see the same log entries.  None of them appear to have any impact on the gameplay.. Just annoying to tail the logfile. 

 

 

 

Yes, 1.0.0.6 is the black sheep patch it seems, i had some small database issues with 1.0.0.5 but it was only occurring once a day or less.

6 hours ago, Keenan said:

Are they all the same database and table?

Yes, it seems as it's only the "Items" database that is malformed. i have checked the specified "Items" inside the database with Sqlitebrowser but i can't see any difference from other items.

Share this post


Link to post
Share on other sites

If you had several az fist enchants with the surface mining fix it will make your server fart. I had to remove them from the wurmitems.db -> spelleffects table. If you left properties default just look for type 34

 

I had so many my server just gave up and wouldnt start, this is with the mod enabled or not. Back up your database (just copy it somewhere else) then try to remove those records. Using sqlite browser just put 34 at the top of the type column, and it will filter out all that arent 34, then select everything and hit delete record at the top right. Remember you made a backup so you can always replace it if this doesnt change anything.

Edited by Xyp

Share this post


Link to post
Share on other sites

[09:22:31 AM] WARNING com.wurmonline.server.behaviours.FloorBehaviour: FloorBehaviour buildAction on a completed floor, it should not happen?!
[09:23:09 AM] WARNING com.wurmonline.server.behaviours.FloorBehaviour: FloorBehaviour buildAction on a completed floor, it should not happen?!
[09:23:40 AM] WARNING com.wurmonline.server.behaviours.FloorBehaviour: FloorBehaviour buildAction on a completed floor, it should not happen?!
[09:24:12 AM] WARNING com.wurmonline.server.behaviours.FloorBehaviour: FloorBehaviour buildAction on a completed floor, it should not happen?!

 

 

Hmm..  another new friendly warning   *sigh* I think tailing logs is going to give me PTSD

Share this post


Link to post
Share on other sites
4 hours ago, Xyp said:

If you had several az fist enchants with the surface mining fix it will make your server fart. I had to remove them from the wurmitems.db -> spelleffects table. If you left properties default just look for type 34

 

I had so many my server just gave up and wouldnt start, this is with the mod enabled or not. Back up your database (just copy it somewhere else) then try to remove those records. Using sqlite browser just put 34 at the top of the type column, and it will filter out all that arent 34, then select everything and hit delete record at the top right. Remember you made a backup so you can always replace it if this doesnt change anything.

Well, i did not enable the Enchants, i only enabled the instant surface mine, not the enchants to enable it.

ps: i don't have any of type 34 in the database

 

 

4 hours ago, razoreqx said:

[09:22:31 AM] WARNING com.wurmonline.server.behaviours.FloorBehaviour: FloorBehaviour buildAction on a completed floor, it should not happen?!
[09:23:09 AM] WARNING com.wurmonline.server.behaviours.FloorBehaviour: FloorBehaviour buildAction on a completed floor, it should not happen?!
[09:23:40 AM] WARNING com.wurmonline.server.behaviours.FloorBehaviour: FloorBehaviour buildAction on a completed floor, it should not happen?!
[09:24:12 AM] WARNING com.wurmonline.server.behaviours.FloorBehaviour: FloorBehaviour buildAction on a completed floor, it should not happen?!

 

 

Hmm..  another new friendly warning   *sigh* I think tailing logs is going to give me PTSD

i have no idea what this means to be honest :/

Edited by Mewter
  • Like 1

Share this post


Link to post
Share on other sites

That floor behaviour is when someone uses the crafting window, with max actions set, and continues, and has leftover queues. Nothing to be concerned with.

  • Like 1

Share this post


Link to post
Share on other sites

I am having random malformed all over the place since this patch what on earth did you guys do?

I had tons of random mushrooms malformed so i Deleted every mushroom on the map and new ones spawning are also malformed items in my itemDb.

I honestly don't want my server as a testing ground for patches that are not fully tested. nothing is more agrovating than having to roll back cause your data base is so dam corrupted do to a patch not to mention other people getting pissed or looking at you as if you caused the issue. This hasn't happened yet but it can happen. Like others have said this happens in modded or non moded servers where the item.db is getting malformed.

Share this post


Link to post
Share on other sites
bytes in: 65117 bytes out: 6255740 total in: 65117 total out: 6255740
Server uptime: 300 seconds. Unanswered questions:1
May 26, 2016 5:44:28 PM com.wurmonline.server.items.DbItem savePosition
WARNING: Failed to save item 38044435828994
java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)
	at org.sqlite.core.DB.newSQLException(DB.java:890)
	at org.sqlite.core.DB.newSQLException(DB.java:901)
	at org.sqlite.core.DB.execute(DB.java:810)
	at org.sqlite.core.DB.executeUpdate(DB.java:847)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)
	at com.wurmonline.server.items.DbItem.savePosition(DbItem.java:1751)
	at com.wurmonline.server.Items.stopDragging(Items.java:705)
	at com.wurmonline.server.Items.destroyItem(Items.java:547)
	at com.wurmonline.server.Items.destroyItem(Items.java:531)
	at com.wurmonline.server.Items.destroyItem(Items.java:526)
	at com.wurmonline.server.items.Item.checkDecay(Item.java:4435)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1812)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1779)
	at com.wurmonline.server.items.Item.poll(Item.java:5331)
	at com.wurmonline.server.zones.VolaTileItems.poll(VolaTileItems.java:368)
	at com.wurmonline.server.zones.VolaTile.poll(VolaTile.java:778)
	at com.wurmonline.server.zones.Zone.poll(Zone.java:335)
	at com.wurmonline.server.zones.Zones.pollNextZones(Zones.java:1583)
	at com.wurmonline.server.Server.run(Server.java:1812)
	at java.util.TimerThread.mainLoop(Unknown Source)
	at java.util.TimerThread.run(Unknown Source)
 
May 26, 2016 5:44:28 PM com.wurmonline.server.items.DbItem setZoneId
WARNING: Failed to set Zone ID to -10 for item 38044435828994
java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)
	at org.sqlite.core.DB.newSQLException(DB.java:890)
	at org.sqlite.core.DB.newSQLException(DB.java:901)
	at org.sqlite.core.DB.execute(DB.java:810)
	at org.sqlite.core.DB.executeUpdate(DB.java:847)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)
	at com.wurmonline.server.items.DbItem.setZoneId(DbItem.java:755)
	at com.wurmonline.server.zones.Zone.removeItem(Zone.java:1339)
	at com.wurmonline.server.zones.Zone.removeItem(Zone.java:1307)
	at com.wurmonline.server.items.Item.removeAndEmpty(Item.java:4258)
	at com.wurmonline.server.Items.destroyItem(Items.java:653)
	at com.wurmonline.server.Items.destroyItem(Items.java:531)
	at com.wurmonline.server.Items.destroyItem(Items.java:526)
	at com.wurmonline.server.items.Item.checkDecay(Item.java:4435)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1812)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1779)
	at com.wurmonline.server.items.Item.poll(Item.java:5331)
	at com.wurmonline.server.zones.VolaTileItems.poll(VolaTileItems.java:368)
	at com.wurmonline.server.zones.VolaTile.poll(VolaTile.java:778)
	at com.wurmonline.server.zones.Zone.poll(Zone.java:335)
	at com.wurmonline.server.zones.Zones.pollNextZones(Zones.java:1583)
	at com.wurmonline.server.Server.run(Server.java:1812)
	at java.util.TimerThread.mainLoop(Unknown Source)
	at java.util.TimerThread.run(Unknown Source)
 
May 26, 2016 5:44:28 PM com.wurmonline.server.items.ItemFactory decay
WARNING: Failed to decay item with id 38044435828994
java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)
	at org.sqlite.core.DB.newSQLException(DB.java:890)
	at org.sqlite.core.DB.newSQLException(DB.java:901)
	at org.sqlite.core.DB.execute(DB.java:810)
	at org.sqlite.core.DB.executeUpdate(DB.java:847)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)
	at com.wurmonline.server.items.ItemFactory.decay(ItemFactory.java:369)
	at com.wurmonline.server.Items.decay(Items.java:519)
	at com.wurmonline.server.Items.destroyItem(Items.java:660)
	at com.wurmonline.server.Items.destroyItem(Items.java:531)
	at com.wurmonline.server.Items.destroyItem(Items.java:526)
	at com.wurmonline.server.items.Item.checkDecay(Item.java:4435)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1812)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1779)
	at com.wurmonline.server.items.Item.poll(Item.java:5331)
	at com.wurmonline.server.zones.VolaTileItems.poll(VolaTileItems.java:368)
	at com.wurmonline.server.zones.VolaTile.poll(VolaTile.java:778)
	at com.wurmonline.server.zones.Zone.poll(Zone.java:335)
	at com.wurmonline.server.zones.Zones.pollNextZones(Zones.java:1583)
	at com.wurmonline.server.Server.run(Server.java:1812)
	at java.util.TimerThread.mainLoop(Unknown Source)
	at java.util.TimerThread.run(Unknown Source)
 
May 26, 2016 5:44:38 PM com.wurmonline.server.items.DbItem savePosition
WARNING: Failed to save item 38044402274562
java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)
	at org.sqlite.core.DB.newSQLException(DB.java:890)
	at org.sqlite.core.DB.newSQLException(DB.java:901)
	at org.sqlite.core.DB.execute(DB.java:810)
	at org.sqlite.core.DB.executeUpdate(DB.java:847)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)
	at com.wurmonline.server.items.DbItem.savePosition(DbItem.java:1751)
	at com.wurmonline.server.Items.stopDragging(Items.java:705)
	at com.wurmonline.server.Items.destroyItem(Items.java:547)
	at com.wurmonline.server.Items.destroyItem(Items.java:531)
	at com.wurmonline.server.Items.destroyItem(Items.java:526)
	at com.wurmonline.server.items.Item.checkDecay(Item.java:4435)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1812)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1779)
	at com.wurmonline.server.items.Item.poll(Item.java:5331)
	at com.wurmonline.server.zones.VolaTileItems.poll(VolaTileItems.java:368)
	at com.wurmonline.server.zones.VolaTile.poll(VolaTile.java:778)
	at com.wurmonline.server.zones.Zone.poll(Zone.java:335)
	at com.wurmonline.server.zones.Zones.pollNextZones(Zones.java:1583)
	at com.wurmonline.server.Server.run(Server.java:1812)
	at java.util.TimerThread.mainLoop(Unknown Source)
	at java.util.TimerThread.run(Unknown Source)
 
May 26, 2016 5:44:38 PM com.wurmonline.server.items.DbItem setZoneId
WARNING: Failed to set Zone ID to -10 for item 38044402274562
java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)
	at org.sqlite.core.DB.newSQLException(DB.java:890)
	at org.sqlite.core.DB.newSQLException(DB.java:901)
	at org.sqlite.core.DB.execute(DB.java:810)
	at org.sqlite.core.DB.executeUpdate(DB.java:847)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)
	at com.wurmonline.server.items.DbItem.setZoneId(DbItem.java:755)
	at com.wurmonline.server.zones.Zone.removeItem(Zone.java:1339)
	at com.wurmonline.server.zones.Zone.removeItem(Zone.java:1307)
	at com.wurmonline.server.items.Item.removeAndEmpty(Item.java:4258)
	at com.wurmonline.server.Items.destroyItem(Items.java:653)
	at com.wurmonline.server.Items.destroyItem(Items.java:531)
	at com.wurmonline.server.Items.destroyItem(Items.java:526)
	at com.wurmonline.server.items.Item.checkDecay(Item.java:4435)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1812)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1779)
	at com.wurmonline.server.items.Item.poll(Item.java:5331)
	at com.wurmonline.server.zones.VolaTileItems.poll(VolaTileItems.java:368)
	at com.wurmonline.server.zones.VolaTile.poll(VolaTile.java:778)
	at com.wurmonline.server.zones.Zone.poll(Zone.java:335)
	at com.wurmonline.server.zones.Zones.pollNextZones(Zones.java:1583)
	at com.wurmonline.server.Server.run(Server.java:1812)
	at java.util.TimerThread.mainLoop(Unknown Source)
	at java.util.TimerThread.run(Unknown Source)
 
May 26, 2016 5:44:38 PM com.wurmonline.server.items.ItemFactory decay
WARNING: Failed to decay item with id 38044402274562
java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)
	at org.sqlite.core.DB.newSQLException(DB.java:890)
	at org.sqlite.core.DB.newSQLException(DB.java:901)
	at org.sqlite.core.DB.execute(DB.java:810)
	at org.sqlite.core.DB.executeUpdate(DB.java:847)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)
	at com.wurmonline.server.items.ItemFactory.decay(ItemFactory.java:369)
	at com.wurmonline.server.Items.decay(Items.java:519)
	at com.wurmonline.server.Items.destroyItem(Items.java:660)
	at com.wurmonline.server.Items.destroyItem(Items.java:531)
	at com.wurmonline.server.Items.destroyItem(Items.java:526)
	at com.wurmonline.server.items.Item.checkDecay(Item.java:4435)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1812)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1779)
	at com.wurmonline.server.items.Item.poll(Item.java:5331)
	at com.wurmonline.server.zones.VolaTileItems.poll(VolaTileItems.java:368)
	at com.wurmonline.server.zones.VolaTile.poll(VolaTile.java:778)
	at com.wurmonline.server.zones.Zone.poll(Zone.java:335)
	at com.wurmonline.server.zones.Zones.pollNextZones(Zones.java:1583)
	at com.wurmonline.server.Server.run(Server.java:1812)
	at java.util.TimerThread.mainLoop(Unknown Source)
	at java.util.TimerThread.run(Unknown Source)
 
May 26, 2016 5:45:51 PM com.wurmonline.server.items.DbItem savePosition
WARNING: Failed to save item 38040912613634
java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)
	at org.sqlite.core.DB.newSQLException(DB.java:890)
	at org.sqlite.core.DB.newSQLException(DB.java:901)
	at org.sqlite.core.DB.execute(DB.java:810)
	at org.sqlite.core.DB.executeUpdate(DB.java:847)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)
	at com.wurmonline.server.items.DbItem.savePosition(DbItem.java:1751)
	at com.wurmonline.server.Items.stopDragging(Items.java:705)
	at com.wurmonline.server.Items.destroyItem(Items.java:547)
	at com.wurmonline.server.Items.destroyItem(Items.java:531)
	at com.wurmonline.server.Items.destroyItem(Items.java:526)
	at com.wurmonline.server.items.Item.checkDecay(Item.java:4435)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1812)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1779)
	at com.wurmonline.server.items.Item.poll(Item.java:5331)
	at com.wurmonline.server.zones.VolaTileItems.poll(VolaTileItems.java:368)
	at com.wurmonline.server.zones.VolaTile.poll(VolaTile.java:778)
	at com.wurmonline.server.zones.Zone.poll(Zone.java:335)
	at com.wurmonline.server.zones.Zones.pollNextZones(Zones.java:1583)
	at com.wurmonline.server.Server.run(Server.java:1812)
	at java.util.TimerThread.mainLoop(Unknown Source)
	at java.util.TimerThread.run(Unknown Source)
 
May 26, 2016 5:45:51 PM com.wurmonline.server.items.DbItem setZoneId
WARNING: Failed to set Zone ID to -10 for item 38040912613634
java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)
	at org.sqlite.core.DB.newSQLException(DB.java:890)
	at org.sqlite.core.DB.newSQLException(DB.java:901)
	at org.sqlite.core.DB.execute(DB.java:810)
	at org.sqlite.core.DB.executeUpdate(DB.java:847)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)
	at com.wurmonline.server.items.DbItem.setZoneId(DbItem.java:755)
	at com.wurmonline.server.zones.Zone.removeItem(Zone.java:1339)
	at com.wurmonline.server.zones.Zone.removeItem(Zone.java:1307)
	at com.wurmonline.server.items.Item.removeAndEmpty(Item.java:4258)
	at com.wurmonline.server.Items.destroyItem(Items.java:653)
	at com.wurmonline.server.Items.destroyItem(Items.java:531)
	at com.wurmonline.server.Items.destroyItem(Items.java:526)
	at com.wurmonline.server.items.Item.checkDecay(Item.java:4435)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1812)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1779)
	at com.wurmonline.server.items.Item.poll(Item.java:5331)
	at com.wurmonline.server.zones.VolaTileItems.poll(VolaTileItems.java:368)
	at com.wurmonline.server.zones.VolaTile.poll(VolaTile.java:778)
	at com.wurmonline.server.zones.Zone.poll(Zone.java:335)
	at com.wurmonline.server.zones.Zones.pollNextZones(Zones.java:1583)
	at com.wurmonline.server.Server.run(Server.java:1812)
	at java.util.TimerThread.mainLoop(Unknown Source)
	at java.util.TimerThread.run(Unknown Source)
 
May 26, 2016 5:45:51 PM com.wurmonline.server.items.ItemFactory decay
WARNING: Failed to decay item with id 38040912613634
java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)
	at org.sqlite.core.DB.newSQLException(DB.java:890)
	at org.sqlite.core.DB.newSQLException(DB.java:901)
	at org.sqlite.core.DB.execute(DB.java:810)
	at org.sqlite.core.DB.executeUpdate(DB.java:847)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)
	at com.wurmonline.server.items.ItemFactory.decay(ItemFactory.java:369)
	at com.wurmonline.server.Items.decay(Items.java:519)
	at com.wurmonline.server.Items.destroyItem(Items.java:660)
	at com.wurmonline.server.Items.destroyItem(Items.java:531)
	at com.wurmonline.server.Items.destroyItem(Items.java:526)
	at com.wurmonline.server.items.Item.checkDecay(Item.java:4435)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1812)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1779)
	at com.wurmonline.server.items.Item.poll(Item.java:5331)
	at com.wurmonline.server.zones.VolaTileItems.poll(VolaTileItems.java:368)
	at com.wurmonline.server.zones.VolaTile.poll(VolaTile.java:778)
	at com.wurmonline.server.zones.Zone.poll(Zone.java:335)
	at com.wurmonline.server.zones.Zones.pollNextZones(Zones.java:1583)
	at com.wurmonline.server.Server.run(Server.java:1812)
	at java.util.TimerThread.mainLoop(Unknown Source)
	at java.util.TimerThread.run(Unknown Source)
 
May 26, 2016 5:45:56 PM com.wurmonline.server.items.DbItem savePosition
WARNING: Failed to save item 38040895836418
java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)
	at org.sqlite.core.DB.newSQLException(DB.java:890)
	at org.sqlite.core.DB.newSQLException(DB.java:901)
	at org.sqlite.core.DB.execute(DB.java:810)
	at org.sqlite.core.DB.executeUpdate(DB.java:847)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)
	at com.wurmonline.server.items.DbItem.savePosition(DbItem.java:1751)
	at com.wurmonline.server.Items.stopDragging(Items.java:705)
	at com.wurmonline.server.Items.destroyItem(Items.java:547)
	at com.wurmonline.server.Items.destroyItem(Items.java:531)
	at com.wurmonline.server.Items.destroyItem(Items.java:526)
	at com.wurmonline.server.items.Item.checkDecay(Item.java:4435)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1812)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1779)
	at com.wurmonline.server.items.Item.poll(Item.java:5331)
	at com.wurmonline.server.zones.VolaTileItems.poll(VolaTileItems.java:368)
	at com.wurmonline.server.zones.VolaTile.poll(VolaTile.java:778)
	at com.wurmonline.server.zones.Zone.poll(Zone.java:335)
	at com.wurmonline.server.zones.Zones.pollNextZones(Zones.java:1583)
	at com.wurmonline.server.Server.run(Server.java:1812)
	at java.util.TimerThread.mainLoop(Unknown Source)
	at java.util.TimerThread.run(Unknown Source)
 
May 26, 2016 5:45:56 PM com.wurmonline.server.items.DbItem setZoneId
WARNING: Failed to set Zone ID to -10 for item 38040895836418
java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)
	at org.sqlite.core.DB.newSQLException(DB.java:890)
	at org.sqlite.core.DB.newSQLException(DB.java:901)
	at org.sqlite.core.DB.execute(DB.java:810)
	at org.sqlite.core.DB.executeUpdate(DB.java:847)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)
	at com.wurmonline.server.items.DbItem.setZoneId(DbItem.java:755)
	at com.wurmonline.server.zones.Zone.removeItem(Zone.java:1339)
	at com.wurmonline.server.zones.Zone.removeItem(Zone.java:1307)
	at com.wurmonline.server.items.Item.removeAndEmpty(Item.java:4258)
	at com.wurmonline.server.Items.destroyItem(Items.java:653)
	at com.wurmonline.server.Items.destroyItem(Items.java:531)
	at com.wurmonline.server.Items.destroyItem(Items.java:526)
	at com.wurmonline.server.items.Item.checkDecay(Item.java:4435)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1812)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1779)
	at com.wurmonline.server.items.Item.poll(Item.java:5331)
	at com.wurmonline.server.zones.VolaTileItems.poll(VolaTileItems.java:368)
	at com.wurmonline.server.zones.VolaTile.poll(VolaTile.java:778)
	at com.wurmonline.server.zones.Zone.poll(Zone.java:335)
	at com.wurmonline.server.zones.Zones.pollNextZones(Zones.java:1583)
	at com.wurmonline.server.Server.run(Server.java:1812)
	at java.util.TimerThread.mainLoop(Unknown Source)
	at java.util.TimerThread.run(Unknown Source)
 
May 26, 2016 5:45:56 PM com.wurmonline.server.items.ItemFactory decay
WARNING: Failed to decay item with id 38040895836418
java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)
	at org.sqlite.core.DB.newSQLException(DB.java:890)
	at org.sqlite.core.DB.newSQLException(DB.java:901)
	at org.sqlite.core.DB.execute(DB.java:810)
	at org.sqlite.core.DB.executeUpdate(DB.java:847)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)
	at com.wurmonline.server.items.ItemFactory.decay(ItemFactory.java:369)
	at com.wurmonline.server.Items.decay(Items.java:519)
	at com.wurmonline.server.Items.destroyItem(Items.java:660)
	at com.wurmonline.server.Items.destroyItem(Items.java:531)
	at com.wurmonline.server.Items.destroyItem(Items.java:526)
	at com.wurmonline.server.items.Item.checkDecay(Item.java:4435)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1812)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1779)
	at com.wurmonline.server.items.Item.poll(Item.java:5331)
	at com.wurmonline.server.zones.VolaTileItems.poll(VolaTileItems.java:368)
	at com.wurmonline.server.zones.VolaTile.poll(VolaTile.java:778)
	at com.wurmonline.server.zones.Zone.poll(Zone.java:335)
	at com.wurmonline.server.zones.Zones.pollNextZones(Zones.java:1583)
	at com.wurmonline.server.Server.run(Server.java:1812)
	at java.util.TimerThread.mainLoop(Unknown Source)
	at java.util.TimerThread.run(Unknown Source)
 
May 26, 2016 5:45:58 PM com.wurmonline.server.items.DbItem savePosition
WARNING: Failed to save item 38041147494658
java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)
	at org.sqlite.core.DB.newSQLException(DB.java:890)
	at org.sqlite.core.DB.newSQLException(DB.java:901)
	at org.sqlite.core.DB.execute(DB.java:810)
	at org.sqlite.core.DB.executeUpdate(DB.java:847)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)
	at com.wurmonline.server.items.DbItem.savePosition(DbItem.java:1751)
	at com.wurmonline.server.Items.stopDragging(Items.java:705)
	at com.wurmonline.server.Items.destroyItem(Items.java:547)
	at com.wurmonline.server.Items.destroyItem(Items.java:531)
	at com.wurmonline.server.Items.destroyItem(Items.java:526)
	at com.wurmonline.server.items.Item.checkDecay(Item.java:4435)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1812)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1779)
	at com.wurmonline.server.items.Item.poll(Item.java:5331)
	at com.wurmonline.server.zones.VolaTileItems.poll(VolaTileItems.java:368)
	at com.wurmonline.server.zones.VolaTile.poll(VolaTile.java:778)
	at com.wurmonline.server.zones.Zone.poll(Zone.java:335)
	at com.wurmonline.server.zones.Zones.pollNextZones(Zones.java:1583)
	at com.wurmonline.server.Server.run(Server.java:1812)
	at java.util.TimerThread.mainLoop(Unknown Source)
	at java.util.TimerThread.run(Unknown Source)
 
May 26, 2016 5:45:58 PM com.wurmonline.server.items.DbItem setZoneId
WARNING: Failed to set Zone ID to -10 for item 38041147494658
java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)
	at org.sqlite.core.DB.newSQLException(DB.java:890)
	at org.sqlite.core.DB.newSQLException(DB.java:901)
	at org.sqlite.core.DB.execute(DB.java:810)
	at org.sqlite.core.DB.executeUpdate(DB.java:847)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)
	at com.wurmonline.server.items.DbItem.setZoneId(DbItem.java:755)
	at com.wurmonline.server.zones.Zone.removeItem(Zone.java:1339)
	at com.wurmonline.server.zones.Zone.removeItem(Zone.java:1307)
	at com.wurmonline.server.items.Item.removeAndEmpty(Item.java:4258)
	at com.wurmonline.server.Items.destroyItem(Items.java:653)
	at com.wurmonline.server.Items.destroyItem(Items.java:531)
	at com.wurmonline.server.Items.destroyItem(Items.java:526)
	at com.wurmonline.server.items.Item.checkDecay(Item.java:4435)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1812)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1779)
	at com.wurmonline.server.items.Item.poll(Item.java:5331)
	at com.wurmonline.server.zones.VolaTileItems.poll(VolaTileItems.java:368)
	at com.wurmonline.server.zones.VolaTile.poll(VolaTile.java:778)
	at com.wurmonline.server.zones.Zone.poll(Zone.java:335)
	at com.wurmonline.server.zones.Zones.pollNextZones(Zones.java:1583)
	at com.wurmonline.server.Server.run(Server.java:1812)
	at java.util.TimerThread.mainLoop(Unknown Source)
	at java.util.TimerThread.run(Unknown Source)
 
May 26, 2016 5:45:58 PM com.wurmonline.server.items.ItemFactory decay
WARNING: Failed to decay item with id 38041147494658
java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)
	at org.sqlite.core.DB.newSQLException(DB.java:890)
	at org.sqlite.core.DB.newSQLException(DB.java:901)
	at org.sqlite.core.DB.execute(DB.java:810)
	at org.sqlite.core.DB.executeUpdate(DB.java:847)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)
	at com.wurmonline.server.items.ItemFactory.decay(ItemFactory.java:369)
	at com.wurmonline.server.Items.decay(Items.java:519)
	at com.wurmonline.server.Items.destroyItem(Items.java:660)
	at com.wurmonline.server.Items.destroyItem(Items.java:531)
	at com.wurmonline.server.Items.destroyItem(Items.java:526)
	at com.wurmonline.server.items.Item.checkDecay(Item.java:4435)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1812)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1779)
	at com.wurmonline.server.items.Item.poll(Item.java:5331)
	at com.wurmonline.server.zones.VolaTileItems.poll(VolaTileItems.java:368)
	at com.wurmonline.server.zones.VolaTile.poll(VolaTile.java:778)
	at com.wurmonline.server.zones.Zone.poll(Zone.java:335)
	at com.wurmonline.server.zones.Zones.pollNextZones(Zones.java:1583)
	at com.wurmonline.server.Server.run(Server.java:1812)
	at java.util.TimerThread.mainLoop(Unknown Source)
	at java.util.TimerThread.run(Unknown Source)
 
May 26, 2016 5:46:12 PM com.wurmonline.server.utils.DatabaseUpdater run
INFO: Error in DatabaseUpdater.run() Item Database Damage Updater for WurmDbUpdatable type: com.wurmonline.server.utils.ItemDamageDatabaseUpdatable
May 26, 2016 5:46:12 PM com.wurmonline.server.utils.DatabaseUpdater run
WARNING: Problem getting WurmLogs connection due to database disk image is malformed
java.sql.SQLException: database disk image is malformed
	at org.sqlite.core.DB.throwex(DB.java:859)
	at org.sqlite.core.DB.executeBatch(DB.java:760)
	at org.sqlite.core.CorePreparedStatement.executeBatch(CorePreparedStatement.java:77)
	at com.wurmonline.server.utils.DatabaseUpdater.run(DatabaseUpdater.java:136)
	at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
	at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
 
May 26, 2016 5:46:30 PM com.wurmonline.server.items.DbItem savePosition
WARNING: Failed to save item 39882111406338
java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)
	at org.sqlite.core.DB.newSQLException(DB.java:890)
	at org.sqlite.core.DB.newSQLException(DB.java:901)
	at org.sqlite.core.DB.execute(DB.java:810)
	at org.sqlite.core.DB.executeUpdate(DB.java:847)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)
	at com.wurmonline.server.items.DbItem.savePosition(DbItem.java:1751)
	at com.wurmonline.server.Items.stopDragging(Items.java:705)
	at com.wurmonline.server.Items.destroyItem(Items.java:547)
	at com.wurmonline.server.Items.destroyItem(Items.java:531)
	at com.wurmonline.server.Items.destroyItem(Items.java:526)
	at com.wurmonline.server.items.Item.checkDecay(Item.java:4435)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1812)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1779)
	at com.wurmonline.server.items.Item.poll(Item.java:5101)
	at com.wurmonline.server.zones.VolaTileItems.poll(VolaTileItems.java:368)
	at com.wurmonline.server.zones.VolaTile.poll(VolaTile.java:778)
	at com.wurmonline.server.zones.Zone.poll(Zone.java:335)
	at com.wurmonline.server.zones.Zones.pollNextZones(Zones.java:1583)
	at com.wurmonline.server.Server.run(Server.java:1812)
	at java.util.TimerThread.mainLoop(Unknown Source)
	at java.util.TimerThread.run(Unknown Source)
 
May 26, 2016 5:46:30 PM com.wurmonline.server.items.DbItem setZoneId
WARNING: Failed to set Zone ID to -10 for item 39882111406338
java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)
	at org.sqlite.core.DB.newSQLException(DB.java:890)
	at org.sqlite.core.DB.newSQLException(DB.java:901)
	at org.sqlite.core.DB.execute(DB.java:810)
	at org.sqlite.core.DB.executeUpdate(DB.java:847)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)
	at com.wurmonline.server.items.DbItem.setZoneId(DbItem.java:755)
	at com.wurmonline.server.zones.Zone.removeItem(Zone.java:1339)
	at com.wurmonline.server.zones.Zone.removeItem(Zone.java:1307)
	at com.wurmonline.server.items.Item.removeAndEmpty(Item.java:4258)
	at com.wurmonline.server.Items.destroyItem(Items.java:653)
	at com.wurmonline.server.Items.destroyItem(Items.java:531)
	at com.wurmonline.server.Items.destroyItem(Items.java:526)
	at com.wurmonline.server.items.Item.checkDecay(Item.java:4435)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1812)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1779)
	at com.wurmonline.server.items.Item.poll(Item.java:5101)
	at com.wurmonline.server.zones.VolaTileItems.poll(VolaTileItems.java:368)
	at com.wurmonline.server.zones.VolaTile.poll(VolaTile.java:778)
	at com.wurmonline.server.zones.Zone.poll(Zone.java:335)
	at com.wurmonline.server.zones.Zones.pollNextZones(Zones.java:1583)
	at com.wurmonline.server.Server.run(Server.java:1812)
	at java.util.TimerThread.mainLoop(Unknown Source)
	at java.util.TimerThread.run(Unknown Source)
 
May 26, 2016 5:46:30 PM com.wurmonline.server.items.ItemFactory decay
WARNING: Failed to decay item with id 39882111406338
java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)
	at org.sqlite.core.DB.newSQLException(DB.java:890)
	at org.sqlite.core.DB.newSQLException(DB.java:901)
	at org.sqlite.core.DB.execute(DB.java:810)
	at org.sqlite.core.DB.executeUpdate(DB.java:847)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)
	at com.wurmonline.server.items.ItemFactory.decay(ItemFactory.java:369)
	at com.wurmonline.server.Items.decay(Items.java:519)
	at com.wurmonline.server.Items.destroyItem(Items.java:660)
	at com.wurmonline.server.Items.destroyItem(Items.java:531)
	at com.wurmonline.server.Items.destroyItem(Items.java:526)
	at com.wurmonline.server.items.Item.checkDecay(Item.java:4435)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1812)
	at com.wurmonline.server.items.DbItem.setDamage(DbItem.java:1779)
	at com.wurmonline.server.items.Item.poll(Item.java:5101)
	at com.wurmonline.server.zones.VolaTileItems.poll(VolaTileItems.java:368)
	at com.wurmonline.server.zones.VolaTile.poll(VolaTile.java:778)
	at com.wurmonline.server.zones.Zone.poll(Zone.java:335)
	at com.wurmonline.server.zones.Zones.pollNextZones(Zones.java:1583)
	at com.wurmonline.server.Server.run(Server.java:1812)
	at java.util.TimerThread.mainLoop(Unknown Source)
	at java.util.TimerThread.run(Unknown Source)
 

This is prime example this never was on my server till after this patch.

Edited by Arkonick

Share this post


Link to post
Share on other sites

Just to add more information, the server crashes atleast once a day, sometimes over 10 times. The only message is that the database is malformed and then it starts the cycle of stopping then starting.

 

Here's the error log:

Quote

[05:32:56 PM] INFOS com.wurmonline.server.Server: current mem in use: 4168M free mem: 2479M Max mem: 4168M

player count: 5

bytes in: 185321 bytes out: 1152448 total in: 2625462 total out: 21129491

Server uptime: 4200 seconds. Unanswered questions:0

[05:34:58 PM] INFOS com.wurmonline.server.items.Item: large cart(618279217154) had lock (618295994370) that was unlocked. So was auto-locked as should not have been in that state.

[05:34:58 PM] AVERTISSEMENT com.wurmonline.server.items.DbItem: Failed to save item 618295994370

java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)

	at org.sqlite.core.DB.newSQLException(DB.java:890)

	at org.sqlite.core.DB.newSQLException(DB.java:901)

	at org.sqlite.core.DB.execute(DB.java:810)

	at org.sqlite.core.DB.executeUpdate(DB.java:847)

	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)

	at com.wurmonline.server.items.DbItem.setLocked(DbItem.java:1954)

	at com.wurmonline.server.items.Item.isLocked(Item.java:9962)

	at com.wurmonline.server.behaviours.VehicleBehaviour.hasPermission(VehicleBehaviour.java:1691)

	at com.wurmonline.server.behaviours.VehicleBehaviour.getVehicleBehaviours(VehicleBehaviour.java:119)

	at com.wurmonline.server.behaviours.VehicleBehaviour.getBehavioursFor(VehicleBehaviour.java:285)

	at com.wurmonline.server.behaviours.WrappedBehaviourProvider.getBehavioursFor(WrappedBehaviourProvider.java:116)

	at org.gotti.wurmunlimited.modsupport.actions.ChainedBehaviourProvider.getBehavioursFor(ChainedBehaviourProvider.java:203)

	at com.wurmonline.server.behaviours.BehaviourDispatcher.requestActionForItemsBodyIdsCoinIds(BehaviourDispatcher.java:426)

	at com.wurmonline.server.behaviours.BehaviourDispatcher.requestActions(BehaviourDispatcher.java:248)

	at com.wurmonline.server.creatures.Communicator.reallyHandle_CMD_REQUEST_ACTIONS(Communicator.java:7009)

	at com.wurmonline.server.creatures.Communicator.reallyHandle(Communicator.java:2368)

	at com.wurmonline.communication.SocketConnection.tick(SocketConnection.java:615)

	at com.wurmonline.communication.SocketServer.tick(SocketServer.java:172)

	at com.wurmonline.server.Server.run(Server.java:2422)

	at java.util.TimerThread.mainLoop(Unknown Source)

	at java.util.TimerThread.run(Unknown Source)


 

[05:35:11 PM] AVERTISSEMENT com.wurmonline.server.items.DbItem: Failed to create/update item with id 3779006048258

java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)

	at org.sqlite.core.DB.newSQLException(DB.java:890)

	at org.sqlite.core.DB.newSQLException(DB.java:901)

	at org.sqlite.core.DB.execute(DB.java:810)

	at org.sqlite.core.DB.executeUpdate(DB.java:847)

	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)

	at com.wurmonline.server.items.DbItem.clear(DbItem.java:3115)

	at com.wurmonline.server.items.ItemFactory.createItem(ItemFactory.java:144)

	at com.wurmonline.server.items.ItemFactory.createItem(ItemFactory.java:88)

	at com.wurmonline.server.items.ItemFactory.createItem(ItemFactory.java:193)

	at com.wurmonline.server.behaviours.Flattening.getDirt(Flattening.java:1263)

	at com.wurmonline.server.behaviours.Flattening.checkUseDirt(Flattening.java:1179)

	at com.wurmonline.server.behaviours.Flattening.flatten(Flattening.java:499)

	at com.wurmonline.server.behaviours.Flattening.flatten(Flattening.java:181)

	at com.wurmonline.server.behaviours.TileBehaviour.action(TileBehaviour.java:1994)

	at com.wurmonline.server.behaviours.TileDirtBehaviour.action(TileDirtBehaviour.java:269)

	at com.wurmonline.server.behaviours.Action.poll(Action.java:2854)

	at com.wurmonline.server.behaviours.ActionStack.poll(ActionStack.java:237)

	at com.wurmonline.server.players.Player.pollActions(Player.java:9270)

	at com.wurmonline.server.Players.pollPlayers(Players.java:4353)

	at com.wurmonline.server.Server.run(Server.java:1817)

	at java.util.TimerThread.mainLoop(Unknown Source)

	at java.util.TimerThread.run(Unknown Source)


 

[05:35:11 PM] AVERTISSEMENT com.wurmonline.server.items.DbItem: Failed to set last ownerId to 1359927574528 for item 3779006048258

java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)

	at org.sqlite.core.DB.newSQLException(DB.java:890)

	at org.sqlite.core.DB.newSQLException(DB.java:901)

	at org.sqlite.core.DB.execute(DB.java:810)

	at org.sqlite.core.DB.executeUpdate(DB.java:847)

	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)

	at com.wurmonline.server.items.DbItem.setLastOwnerId(DbItem.java:1383)

	at com.wurmonline.server.behaviours.Flattening.getDirt(Flattening.java:1265)

	at com.wurmonline.server.behaviours.Flattening.checkUseDirt(Flattening.java:1179)

	at com.wurmonline.server.behaviours.Flattening.flatten(Flattening.java:499)

	at com.wurmonline.server.behaviours.Flattening.flatten(Flattening.java:181)

	at com.wurmonline.server.behaviours.TileBehaviour.action(TileBehaviour.java:1994)

	at com.wurmonline.server.behaviours.TileDirtBehaviour.action(TileDirtBehaviour.java:269)

	at com.wurmonline.server.behaviours.Action.poll(Action.java:2854)

	at com.wurmonline.server.behaviours.ActionStack.poll(ActionStack.java:237)

	at com.wurmonline.server.players.Player.pollActions(Player.java:9270)

	at com.wurmonline.server.Players.pollPlayers(Players.java:4353)

	at com.wurmonline.server.Server.run(Server.java:1817)

	at java.util.TimerThread.mainLoop(Unknown Source)

	at java.util.TimerThread.run(Unknown Source)


 

[05:35:11 PM] INFOS com.wurmonline.server.MessageServer: Broadcasting Serverwide Alert: The server is shutting down in 5 seconds. Reason: The server lost connection to the database. Shutting down 

[05:35:11 PM] AVERTISSEMENT com.wurmonline.server.items.DbItem: Failed to save item 3779006048258

java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)

	at org.sqlite.core.DB.newSQLException(DB.java:890)

	at org.sqlite.core.DB.newSQLException(DB.java:901)

	at org.sqlite.core.DB.execute(DB.java:810)

	at org.sqlite.core.DB.executeUpdate(DB.java:847)

	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)

	at com.wurmonline.server.items.DbItem.setPosXY(DbItem.java:1528)

	at com.wurmonline.server.behaviours.Flattening.getDirt(Flattening.java:1265)

	at com.wurmonline.server.behaviours.Flattening.checkUseDirt(Flattening.java:1179)

	at com.wurmonline.server.behaviours.Flattening.flatten(Flattening.java:499)

	at com.wurmonline.server.behaviours.Flattening.flatten(Flattening.java:181)

	at com.wurmonline.server.behaviours.TileBehaviour.action(TileBehaviour.java:1994)

	at com.wurmonline.server.behaviours.TileDirtBehaviour.action(TileDirtBehaviour.java:269)

	at com.wurmonline.server.behaviours.Action.poll(Action.java:2854)

	at com.wurmonline.server.behaviours.ActionStack.poll(ActionStack.java:237)

	at com.wurmonline.server.players.Player.pollActions(Player.java:9270)

	at com.wurmonline.server.Players.pollPlayers(Players.java:4353)

	at com.wurmonline.server.Server.run(Server.java:1817)

	at java.util.TimerThread.mainLoop(Unknown Source)

	at java.util.TimerThread.run(Unknown Source)


 

[05:35:11 PM] AVERTISSEMENT com.wurmonline.server.items.DbItem: Failed to set Zone ID to 3503 for item 3779006048258

java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)

	at org.sqlite.core.DB.newSQLException(DB.java:890)

	at org.sqlite.core.DB.newSQLException(DB.java:901)

	at org.sqlite.core.DB.execute(DB.java:810)

	at org.sqlite.core.DB.executeUpdate(DB.java:847)

	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)

	at com.wurmonline.server.items.DbItem.setZoneId(DbItem.java:757)

	at com.wurmonline.server.zones.VolaTile.addItem(VolaTile.java:1869)

	at com.wurmonline.server.zones.VolaTile.addItem(VolaTile.java:1767)

	at com.wurmonline.server.zones.Zone.addItem(Zone.java:1885)

	at com.wurmonline.server.zones.Zone.addItem(Zone.java:1833)

	at com.wurmonline.server.behaviours.Flattening.getDirt(Flattening.java:1265)

	at com.wurmonline.server.behaviours.Flattening.checkUseDirt(Flattening.java:1179)

	at com.wurmonline.server.behaviours.Flattening.flatten(Flattening.java:499)

	at com.wurmonline.server.behaviours.Flattening.flatten(Flattening.java:181)

	at com.wurmonline.server.behaviours.TileBehaviour.action(TileBehaviour.java:1994)

	at com.wurmonline.server.behaviours.TileDirtBehaviour.action(TileDirtBehaviour.java:269)

	at com.wurmonline.server.behaviours.Action.poll(Action.java:2854)

	at com.wurmonline.server.behaviours.ActionStack.poll(ActionStack.java:237)

	at com.wurmonline.server.players.Player.pollActions(Player.java:9270)

	at com.wurmonline.server.Players.pollPlayers(Players.java:4353)

	at com.wurmonline.server.Server.run(Server.java:1817)

	at java.util.TimerThread.mainLoop(Unknown Source)

	at java.util.TimerThread.run(Unknown Source)


 

[05:35:11 PM] AVERTISSEMENT com.wurmonline.server.items.DbItem: Failed to save item 3779006048258

java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)

	at org.sqlite.core.DB.newSQLException(DB.java:890)

	at org.sqlite.core.DB.newSQLException(DB.java:901)

	at org.sqlite.core.DB.execute(DB.java:810)

	at org.sqlite.core.DB.executeUpdate(DB.java:847)

	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86)

	at com.wurmonline.server.items.DbItem.setPosZ(DbItem.java:1647)

	at com.wurmonline.server.items.Item.updatePosZ(Item.java:5463)

	at com.wurmonline.server.zones.VolaTile.addItem(VolaTile.java:1871)

	at com.wurmonline.server.zones.VolaTile.addItem(VolaTile.java:1767)

	at com.wurmonline.server.zones.Zone.addItem(Zone.java:1885)

	at com.wurmonline.server.zones.Zone.addItem(Zone.java:1833)

	at com.wurmonline.server.behaviours.Flattening.getDirt(Flattening.java:1265)

	at com.wurmonline.server.behaviours.Flattening.checkUseDirt(Flattening.java:1179)

	at com.wurmonline.server.behaviours.Flattening.flatten(Flattening.java:499)

	at com.wurmonline.server.behaviours.Flattening.flatten(Flattening.java:181)

	at com.wurmonline.server.behaviours.TileBehaviour.action(TileBehaviour.java:1994)

	at com.wurmonline.server.behaviours.TileDirtBehaviour.action(TileDirtBehaviour.java:269)

	at com.wurmonline.server.behaviours.Action.poll(Action.java:2854)

	at com.wurmonline.server.behaviours.ActionStack.poll(ActionStack.java:237)

	at com.wurmonline.server.players.Player.pollActions(Player.java:9270)

	at com.wurmonline.server.Players.pollPlayers(Players.java:4353)

	at com.wurmonline.server.Server.run(Server.java:1817)

	at java.util.TimerThread.mainLoop(Unknown Source)

	at java.util.TimerThread.run(Unknown Source)


 

[05:35:12 PM] INFOS com.wurmonline.server.MessageServer: Broadcasting Serverwide Alert: Server shutting down NOW!/%7?o#### NO CARRIER

[05:35:13 PM] INFOS com.wurmonline.server.steam.SteamHandler: Client was  NOT Authenticated

Client was  NOT Authenticated

[05:35:13 PM] INFOS com.wurmonline.server.steam.SteamHandler: Client was  NOT Authenticated

Client was  NOT Authenticated

[05:35:13 PM] INFOS com.wurmonline.server.steam.SteamHandler: Client was  NOT Authenticated

Client was  NOT Authenticated

[05:35:13 PM] INFOS com.wurmonline.server.steam.SteamHandler: Client was  NOT Authenticated

Client was  NOT Authenticated

[05:35:13 PM] INFOS com.wurmonline.server.steam.SteamHandler: Client was  NOT Authenticated

Client was  NOT Authenticated

[05:35:16 PM] INFOS com.wurmonline.server.Server: Shutting down at: 

java.lang.Exception

	at com.wurmonline.server.Server.shutDown(Server.java:3523)

	at com.wurmonline.server.Server.run(Server.java:1826)

	at java.util.TimerThread.mainLoop(Unknown Source)

	at java.util.TimerThread.run(Unknown Source)

 

Edited by Mewter

Share this post


Link to post
Share on other sites

Could it be that its not the wurm server that is breaking the db, but Sqlite not liking something,  i read some where that this can be fixed by using sqlite command line.

Share this post


Link to post
Share on other sites
2 minutes ago, bigsteve said:

Could it be that its not the wurm server that is breaking the db, but Sqlite not liking something,  i read some where that this can be fixed by using sqlite command line.

 

Please explain this a little more :)

Share this post


Link to post
Share on other sites

I am not good at explaining something i read in passing, just google, "[SQLITE_CORRUPT] The database disk image is malformed (database disk image is malformed)". Many site say use the command/shell to fix.

Share this post


Link to post
Share on other sites

i have managed to fix this, i used SQLiteBrowser, i exported the Wurmitems.db into an SQL and then imported it into a clean DB file and i have no more errors in the console and all items are still there.

 

It would seem like the problems were caused by the 1.0.0.6 patch.

Share this post


Link to post
Share on other sites
4 hours ago, Mewter said:

i have managed to fix this, i used SQLiteBrowser, i exported the Wurmitems.db into an SQL and then imported it into a clean DB file and i have no more errors in the console and all items are still there.

 

It would seem like the problems were caused by the 1.0.0.6 patch.

 

I had to do the same thing.

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