Posted May 20, 2016 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
Posted May 20, 2016 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
Posted May 21, 2016 Mewter which server mods are you running? Share this post Link to post Share on other sites
Posted May 22, 2016 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
Posted May 22, 2016 Are they all the same database and table? Share this post Link to post Share on other sites
Posted May 22, 2016 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) 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
Posted May 22, 2016 (edited) 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 May 22, 2016 by Xyp Share this post Link to post Share on other sites
Posted May 22, 2016 [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
Posted May 22, 2016 (edited) 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 May 22, 2016 by Mewter 1 Share this post Link to post Share on other sites
Posted May 22, 2016 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. 1 Share this post Link to post Share on other sites
Posted May 26, 2016 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
Posted May 27, 2016 (edited) 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 May 27, 2016 by Arkonick Share this post Link to post Share on other sites
Posted May 27, 2016 (edited) 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 May 27, 2016 by Mewter Share this post Link to post Share on other sites
Posted May 27, 2016 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
Posted May 27, 2016 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
Posted May 27, 2016 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
Posted May 28, 2016 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
Posted May 28, 2016 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