Irexistus

Members
  • Content Count

    5
  • Joined

  • Last visited

Community Reputation

1 Neutral

About Irexistus

  • Rank
    Settler

Recent Profile Visitors

573 profile views
  1. My dedicated server keeps shutting itself down every couple of days after running into the following error: Nov 24, 2015 1:14:30 PM com.wurmonline.server.Server run INFO: Polling shop demands Nov 24, 2015 1:14:30 PM com.wurmonline.server.economy.LocalSupplyDemand increaseAllDemands WARNING: Failed to increase all demands due to [SQLITE_ERROR] SQL error or missing database (no such function: GREATEST) java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such function: GREATEST) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:40) at org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:29) at org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:18) at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:47) at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:254) at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:226) at com.wurmonline.server.economy.LocalSupplyDemand.increaseAllDemands(LocalSupplyDemand.java:326) at com.wurmonline.server.Server.pollShopDemands(Server.java:2497) at com.wurmonline.server.Server.run(Server.java:2210) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Nov 24, 2015 1:14:35 PM com.wurmonline.server.zones.TilePoller calcRest INFO: Current polltile=0, rest=0 pollmodifier=29053, pollround=33 Nov 24, 2015 1:14:35 PM com.wurmonline.server.zones.TilePoller calcRest INFO: tiles=4194304, mask=4194303 ticksperday=3456000, Nthick=1, rest=738304, manypertick=true Nov 24, 2015 1:14:35 PM com.wurmonline.server.zones.TilePoller checkPolltile INFO: New pollModifier: 42527 eruptions=false Nov 24, 2015 1:14:39 PM com.wurmonline.server.statistics.Statistics run INFO: current mem in use: 1241M free mem: 673M Max mem: 2010M player count: 1 bytes in: 0 bytes out: 0 total in: 6129238 total out: 27261720 Server uptime: 86400 seconds. Unanswered questions:0 Nov 24, 2015 1:14:40 PM com.wurmonline.server.skills.SkillStat$1 run WARNING: Polling 145 skills for stats v2 took 1 ms. Nov 24, 2015 1:14:42 PM com.wurmonline.server.Items countEggs INFO: Current number of eggs is 52 (max eggs is 1000) That took 37.75788 ms. Nov 24, 2015 1:14:47 PM com.wurmonline.server.epic.EpicServerStatus pollExpiredMissions INFO: Deleting last mission for deity 1 since it could not be found Nov 24, 2015 1:14:47 PM com.wurmonline.server.epic.EpicServerStatus pollExpiredMissions INFO: Deleting last mission for deity 2 since it could not be found Nov 24, 2015 1:14:47 PM com.wurmonline.server.epic.EpicServerStatus pollExpiredMissions INFO: Deleting last mission for deity 4 since it could not be found Nov 24, 2015 1:14:58 PM com.wurmonline.server.Server run SEVERE: null java.lang.NullPointerException at com.wurmonline.mesh.GrassData.encodeGrassTileData(GrassData.java:572) at com.wurmonline.server.zones.TilePoller.checkForGrassGrowth(TilePoller.java:763) at com.wurmonline.server.zones.TilePoller.checkEffects(TilePoller.java:404) at com.wurmonline.server.zones.TilePoller.pollNextTile(TilePoller.java:235) at com.wurmonline.server.zones.TilePoller.pollNext(TilePoller.java:165) at com.wurmonline.server.Server.run(Server.java:1709) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Nov 24, 2015 1:14:58 PM com.wurmonline.server.Server run SEVERE: Server is shutting down but there is no information in the Exception so creating a new one java.lang.Exception at com.wurmonline.server.Server.run(Server.java:2471) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Nov 24, 2015 1:14:58 PM com.wurmonline.server.Server shutDown INFO: Shutting down at: java.lang.Exception at com.wurmonline.server.Server.shutDown(Server.java:3278) at com.wurmonline.server.Server.run(Server.java:2473) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Nov 24, 2015 1:14:58 PM com.wurmonline.server.Server shutDown Seems the issue is that the server is trying to use the 'GREATEST' SQL function which Sqlite doesn't support (though you could simply use MAX in it's place to a degree). Any ideas if it's something I can fix on my end (I'd like to keep using sqlite) or if it needs to be patched by the devs?
  2. Typing shutdown into the headless Wurm Unlimited server console will do it.
  3. Yeah, seeing the same thing, non-stop 30+MB/s writing to disk for hours and hours on end. Not ideal. This kind of needs a priority fix.
  4. WurmServerLauncher seems to require a GUI (errors out on failed graphics initialization). Is there a way to launch the server in headless mode for those of us trying to see if it'll run on our dedicated Linux servers/VPSs?