Search the Community
Showing results for tags 'sql'.
Found 4 results
Hey all, I've migrated my server from one provider to another but on migration I had issues loading the SQL Databases. I've fixed most of the issues but the only issue remaining is for existing players whereby their skills do not load. If they login and start building their skills any progression is also lost which is really frustrating for them. The error which appears is: [11:03:39 AM] WARNING com.wurmonline.server.creatures.Creature: Failed to load and create skills for creature with name Dummy:null java.lang.NullPointerException at com.wurmonline.server.skills.SkillSystem.getTypeFor(SkillSystem.java:453) at com.wurmonline.server.skills.Skill.<init>(Skill.java:181) at com.wurmonline.server.skills.DbSkill.<init>(DbSkill.java:66) at com.wurmonline.server.skills.DbSkills.load(DbSkills.java:122) at com.wurmonline.server.creatures.Creature.loadSkills(Creature.java:12289) at com.wurmonline.server.LoginHandler.handleLogin(LoginHandler.java:1690) at com.wurmonline.server.LoginHandler.login(LoginHandler.java:446) at com.wurmonline.server.LoginHandler.reallyHandle(LoginHandler.java:313) 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:2462) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Any thoughts how to fix this? Many Thanks R
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?