Menu

#3241 Server Nested Exception: data base related?

closed-fixed
None
5
2007-07-20
2007-07-19
No

I don't know what this means but it happened not long after a restart. There's loads of it and i don't know what's right to paste:
** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2555)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at marauroa.server.game.JDBCPlayerDatabase.createConnection(JDBCPlayerDatabase.java:1043)
at marauroa.server.game.JDBCPlayerDatabase.getTransaction(JDBCPlayerDatabase.java:1022)
at games.stendhal.server.StendhalRPRuleProcessor.addGameEvent(StendhalRPRuleProcessor.java:167)
at games.stendhal.server.entity.RPEntity.onDamaged(RPEntity.java:699)
at games.stendhal.server.StendhalRPAction.attack(StendhalRPAction.java:343)
at games.stendhal.server.entity.player.Player.logic(Player.java:1693)
at games.stendhal.server.StendhalRPRuleProcessor.beginTurn(StendhalRPRuleProcessor.java:467)
at marauroa.server.game.RPServerManager.run(RPServerManager.java:514)

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.
at marauroa.server.game.JDBCPlayerDatabase.createConnection(JDBCPlayerDatabase.java:1052)
at marauroa.server.game.JDBCPlayerDatabase.getTransaction(JDBCPlayerDatabase.java:1022)
at games.stendhal.server.StendhalRPRuleProcessor.addGameEvent(StendhalRPRuleProcessor.java:167)
at games.stendhal.server.entity.RPEntity.onDamaged(RPEntity.java:699)
at games.stendhal.server.StendhalRPAction.attack(StendhalRPAction.java:343)
at games.stendhal.server.entity.player.Player.logic(Player.java:1693)
at games.stendhal.server.StendhalRPRuleProcessor.beginTurn(StendhalRPRuleProcessor.java:467)
at marauroa.server.game.RPServerManager.run(RPServerManager.java:514)
Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2555)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at marauroa.server.game.JDBCPlayerDatabase.createConnection(JDBCPlayerDatabase.java:1043)
at marauroa.server.game.JDBCPlayerDatabase.getTransaction(JDBCPlayerDatabase.java:1022)
at games.stendhal.server.StendhalRPRuleProcessor.addGameEvent(StendhalRPRuleProcessor.java:167)
at games.stendhal.server.entity.RPEntity.onDamaged(RPEntity.java:699)
at games.stendhal.server.StendhalRPAction.attack(StendhalRPAction.java:343)
at games.stendhal.server.entity.player.Player.logic(Player.java:1693)
at games.stendhal.server.StendhalRPRuleProcessor.beginTurn(StendhalRPRuleProcessor.java:467)
at marauroa.server.game.RPServerManager.run(RPServerManager.java:514)

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2621)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at marauroa.server.game.JDBCPlayerDatabase.createConnection(JDBCPlayerDatabase.java:1043)
... 7 more
2007-07-19 22:08:18 ERROR [verManager] JDBCTransaction (100 ) - connection invalid, already closed.

** BEGIN NESTED EXCEPTION **

com.mysql.jdbc.CommunicationsException
MESSAGE: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:824)
at marauroa.server.game.JDBCTransaction.isValid(JDBCTransaction.java:95)
at marauroa.server.game.JDBCPlayerDatabase.getTransaction(JDBCPlayerDatabase.java:1020)
at games.stendhal.server.StendhalRPRuleProcessor.addGameEvent(StendhalRPRuleProcessor.java:167)
at games.stendhal.server.entity.RPEntity.onDamaged(RPEntity.java:699)
at games.stendhal.server.StendhalRPAction.attack(StendhalRPAction.java:343)
at games.stendhal.server.entity.creature.impl.CreatureLogic.logicDoAttack(CreatureLogic.java:475)
at games.stendhal.server.entity.creature.impl.CreatureLogic.logic(CreatureLogic.java:527)
at games.stendhal.server.entity.creature.Creature.logic(Creature.java:649)
at games.stendhal.server.entity.spawner.CreatureRespawnPoint.logic(CreatureRespawnPoint.java:189)
at games.stendhal.server.StendhalRPRuleProcessor.endTurn(StendhalRPRuleProcessor.java:504)
at marauroa.server.game.RPServerManager.run(RPServerManager.java:493)

** END NESTED EXCEPTION **

Last packet sent to the server was 2 ms ago.

STACKTRACE:

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:824)
at marauroa.server.game.JDBCTransaction.isValid(JDBCTransaction.java:95)
at marauroa.server.game.JDBCPlayerDatabase.getTransaction(JDBCPlayerDatabase.java:1020)
at games.stendhal.server.StendhalRPRuleProcessor.addGameEvent(StendhalRPRuleProcessor.java:167)
at games.stendhal.server.entity.RPEntity.onDamaged(RPEntity.java:699)
at games.stendhal.server.StendhalRPAction.attack(StendhalRPAction.java:343)
at games.stendhal.server.entity.creature.impl.CreatureLogic.logicDoAttack(CreatureLogic.java:475)
at games.stendhal.server.entity.creature.impl.CreatureLogic.logic(CreatureLogic.java:527)
at games.stendhal.server.entity.creature.Creature.logic(Creature.java:649)
at games.stendhal.server.entity.spawner.CreatureRespawnPoint.logic(CreatureRespawnPoint.java:189)
at games.stendhal.server.StendhalRPRuleProcessor.endTurn(StendhalRPRuleProcessor.java:504)
at marauroa.server.game.RPServerManager.run(RPServerManager.java:493)

** END NESTED EXCEPTION **

Last packet sent to the server was 2 ms ago.
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2563)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:824)
at marauroa.server.game.JDBCTransaction.isValid(JDBCTransaction.java:95)
at marauroa.server.game.JDBCPlayerDatabase.getTransaction(JDBCPlayerDatabase.java:1020)
at games.stendhal.server.StendhalRPRuleProcessor.addGameEvent(StendhalRPRuleProcessor.java:167)
at games.stendhal.server.entity.RPEntity.onDamaged(RPEntity.java:699)
at games.stendhal.server.StendhalRPAction.attack(StendhalRPAction.java:343)
at games.stendhal.server.entity.creature.impl.CreatureLogic.logicDoAttack(CreatureLogic.java:475)
at games.stendhal.server.entity.creature.impl.CreatureLogic.logic(CreatureLogic.java:527)
at games.stendhal.server.entity.creature.Creature.logic(Creature.java:649)
at games.stendhal.server.entity.spawner.CreatureRespawnPoint.logic(CreatureRespawnPoint.java:189)
at games.stendhal.server.StendhalRPRuleProcessor.endTurn(StendhalRPRuleProcessor.java:504)
at marauroa.server.game.RPServerManager.run(RPServerManager.java:493)

** END NESTED EXCEPTION **

at com.mysql.jdbc.Connection.checkClosed(Connection.java:1842)
at com.mysql.jdbc.Connection.createStatement(Connection.java:2840)
at com.mysql.jdbc.Connection.createStatement(Connection.java:2822)
at marauroa.server.game.JDBCPlayerDatabase.verifyAccount(JDBCPlayerDatabase.java:495)
... 3 more

Discussion

  • Miguel Angel Blanch Lardin

    Logged In: YES
    user_id=3949
    Originator: NO

    This is caused because MySQL went down.
    Nothing that we can fix at Stendhal, if there is no database, there is no database :)

     
  • Miguel Angel Blanch Lardin

    • assigned_to: nobody --> arianne_rpg
    • status: open --> closed-fixed
     

Anonymous
Anonymous

Add attachments
Cancel