Communications link failure

[XavierElf]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number: 3300
L2JDP Revision Number: 6417

Hi guys! I've faced a problem with saving data in database. There're a lot of error messages in stdout.log. Look at this plz.

Code: Select all

Olympiad System: Failed to save olympiad data to database: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Last packet sent to the server was 13 ms ago.        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3009)        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2895)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3438)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1021)        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)        at net.sf.l2j.gameserver.model.olympiad.Olympiad.saveOlympiadStatus(Olympiad.java:1141)        at net.sf.l2j.gameserver.taskmanager.tasks.TaskOlympiadSave.onTimeElapsed(TaskOlympiadSave.java:54)        at net.sf.l2j.gameserver.taskmanager.TaskManager$ExecutedTask.run(TaskManager.java:85)        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)        at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:181)        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205)        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)        at java.lang.Thread.run(Thread.java:619)Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2455)        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2906)... 20 moreProblem with checked-in Statement, discarding.com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.Util.getInstance(Util.java:381)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)        at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:381)        at com.mysql.jdbc.PreparedStatement.clearParameters(PreparedStatement.java:800)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.refreshStatement(GooGooStatementCache.java:604)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:236)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:288)        at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)        at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)        at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)        at net.sf.l2j.gameserver.model.olympiad.Olympiad.saveOlympiadStatus(Olympiad.java:1152)        at net.sf.l2j.gameserver.taskmanager.tasks.TaskOlympiadSave.onTimeElapsed(TaskOlympiadSave.java:54)        at net.sf.l2j.gameserver.taskmanager.TaskManager$ExecutedTask.run(TaskManager.java:85)        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)        at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:181)        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205)        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)        at java.lang.Thread.run(Thread.java:619) java.sql.SQLException: An SQLException was provoked by the following failure: java.util.ConcurrentModificationException        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:62)        at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1271)        at net.sf.l2j.gameserver.model.olympiad.Olympiad.saveOlympiadStatus(Olympiad.java:1152)        at net.sf.l2j.gameserver.taskmanager.tasks.TaskOlympiadSave.onTimeElapsed(TaskOlympiadSave.java:54)        at net.sf.l2j.gameserver.taskmanager.TaskManager$ExecutedTask.run(TaskManager.java:85)        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)        at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:181)        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205)        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)        at java.lang.Thread.run(Thread.java:619)Caused by: java.util.ConcurrentModificationException        at java.util.HashMap$HashIterator.nextEntry(HashMap.java:793)        at java.util.HashMap$KeyIterator.next(HashMap.java:828)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:286)        at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)        at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)        at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)        ... 12 moreOlympiad System: Data updated.cannot updated the Global Task 1: Communications link failure Last packet sent to the server was 0 ms ago.Problem with checked-in Statement, discarding.com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.Util.getInstance(Util.java:381)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)        at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:381)        at com.mysql.jdbc.PreparedStatement.clearParameters(PreparedStatement.java:800)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.refreshStatement(GooGooStatementCache.java:604)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:236)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:288)        at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)        at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)        at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)        at net.sf.l2j.gameserver.taskmanager.TaskManager$ExecutedTask.run(TaskManager.java:107)        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)        at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:181)        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205)        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)        at java.lang.Thread.run(Thread.java:619) Manor System: Under maintenance mode startedManor System: New Schedule for manor refresh @ Sat Jul 18 20:00:42 MSD 2009^MManor System: Next period startedError adding seed production data for castle Gludio: Communications link failure Last packet sent to the server was 1 ms ago.Problem with checked-in Statement, discarding.com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.Util.getInstance(Util.java:381)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)        at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:381)        at com.mysql.jdbc.PreparedStatement.clearParameters(PreparedStatement.java:800)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.refreshStatement(GooGooStatementCache.java:604)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:236)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:288)        at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)        at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)        at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)        at net.sf.l2j.gameserver.model.entity.Castle.saveSeedData(Castle.java:1281)        at net.sf.l2j.gameserver.instancemanager.CastleManorManager.save(CastleManorManager.java:590)        at net.sf.l2j.gameserver.instancemanager.CastleManorManager$1$1.run(CastleManorManager.java:319)        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)        at java.util.concurrent.FutureTask.run(FutureTask.java:138)        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98)        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:207)        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)        at java.lang.Thread.run(Thread.java:619) Error adding crop data for castle Gludio: Communications link failure..... 

And when i try to shutdown server i receive:

Code: Select all

IP: 127.0.0.1 issued shutdown command. SIGTERM in 0 seconds!^MGM shutdown countdown is over. shutting down NOW!^MAll ThreadPools are now stoped^MGM shutdown received. Shutting down NOW!^MRaidBossSpawnManager: Couldnt update raidboss_spawnlist table^MProblem with checked-in Statement, discarding.^Mcom.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.        at sun.reflect.GeneratedConstructorAccessor57.newInstance(Unknown Source)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.Util.getInstance(Util.java:381)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)        at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:381)        at com.mysql.jdbc.PreparedStatement.clearParameters(PreparedStatement.java:800)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.refreshStatement(GooGooStatementCache.java:604)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:236)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:288)        at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)        at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)        at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)        at net.sf.l2j.gameserver.instancemanager.RaidBossSpawnManager.updateDb(RaidBossSpawnManager.java:405)        at net.sf.l2j.gameserver.instancemanager.RaidBossSpawnManager.cleanUp(RaidBossSpawnManager.java:520)        at net.sf.l2j.gameserver.Shutdown.saveData(Shutdown.java:494)        at net.sf.l2j.gameserver.Shutdown.run(Shutdown.java:227)^Mjava.sql.SQLException: An SQLException was provoked by the following failure: java.util.ConcurrentModificationException        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:62)        at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1271)        at net.sf.l2j.gameserver.instancemanager.RaidBossSpawnManager.updateDb(RaidBossSpawnManager.java:405)        at net.sf.l2j.gameserver.instancemanager.RaidBossSpawnManager.cleanUp(RaidBossSpawnManager.java:520)        at net.sf.l2j.gameserver.Shutdown.saveData(Shutdown.java:494)        at net.sf.l2j.gameserver.Shutdown.run(Shutdown.java:227)Caused by: java.util.ConcurrentModificationException        at java.util.HashMap$HashIterator.nextEntry(HashMap.java:793)        at java.util.HashMap$KeyIterator.next(HashMap.java:828)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:286)        at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)        at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)        at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)        ... 4 moreRaidBossSpawnManager: Couldnt update raidboss_spawnlist table^MProblem with checked-in Statement, discarding.^Mcom.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.at sun.reflect.GeneratedConstructorAccessor57.newInstance(Unknown Source)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.Util.getInstance(Util.java:381)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)        at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:381)        at com.mysql.jdbc.PreparedStatement.clearParameters(PreparedStatement.java:800)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.refreshStatement(GooGooStatementCache.java:604)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:236)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:288)        at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)        at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)        at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)        at net.sf.l2j.gameserver.instancemanager.RaidBossSpawnManager.updateDb(RaidBossSpawnManager.java:405)        at net.sf.l2j.gameserver.instancemanager.RaidBossSpawnManager.cleanUp(RaidBossSpawnManager.java:520)        at net.sf.l2j.gameserver.Shutdown.saveData(Shutdown.java:494)        at net.sf.l2j.gameserver.Shutdown.run(Shutdown.java:227)^Mjava.sql.SQLException: An SQLException was provoked by the following failure: java.util.ConcurrentModificationException        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:62)        at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1271)        at net.sf.l2j.gameserver.instancemanager.RaidBossSpawnManager.updateDb(RaidBossSpawnManager.java:405)        at net.sf.l2j.gameserver.instancemanager.RaidBossSpawnManager.cleanUp(RaidBossSpawnManager.java:520)        at net.sf.l2j.gameserver.Shutdown.saveData(Shutdown.java:494)        at net.sf.l2j.gameserver.Shutdown.run(Shutdown.java:227)Caused by: java.util.ConcurrentModificationException        at java.util.HashMap$HashIterator.nextEntry(HashMap.java:793)        at java.util.HashMap$KeyIterator.next(HashMap.java:828)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:286)        at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)        at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)        at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)        ... 4 moreRaidBossSpawnManager: Couldnt update raidboss_spawnlist table^MProblem with checked-in Statement, discarding.^Mcom.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.        at sun.reflect.GeneratedConstructorAccessor57.newInstance(Unknown Source)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.Util.getInstance(Util.java:381)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)        at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:381)        at com.mysql.jdbc.PreparedStatement.clearParameters(PreparedStatement.java:800)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.refreshStatement(GooGooStatementCache.java:604)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:236)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:288)        at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)        at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)        at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)        at net.sf.l2j.gameserver.instancemanager.RaidBossSpawnManager.updateDb(RaidBossSpawnManager.java:405)        at net.sf.l2j.gameserver.instancemanager.RaidBossSpawnManager.cleanUp(RaidBossSpawnManager.java:520)        at net.sf.l2j.gameserver.Shutdown.saveData(Shutdown.java:494)        at net.sf.l2j.gameserver.Shutdown.run(Shutdown.java:227)^MRaidBossSpawnManager: Couldnt update raidboss_spawnlist table^MProblem with checked-in Statement, discarding.^Mcom.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.        at sun.reflect.GeneratedConstructorAccessor57.newInstance(Unknown Source)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.Util.getInstance(Util.java:381)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)        at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:381)        at com.mysql.jdbc.PreparedStatement.clearParameters(PreparedStatement.java:800)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.refreshStatement(GooGooStatementCache.java:604)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:236)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:288)        at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)        at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)        at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)        at net.sf.l2j.gameserver.instancemanager.RaidBossSpawnManager.updateDb(RaidBossSpawnManager.java:405)        at net.sf.l2j.gameserver.instancemanager.RaidBossSpawnManager.cleanUp(RaidBossSpawnManager.java:520)        at net.sf.l2j.gameserver.Shutdown.saveData(Shutdown.java:494)        at net.sf.l2j.gameserver.Shutdown.run(Shutdown.java:227)RaidBossSpawnManager: Couldnt update raidboss_spawnlist table^MProblem with checked-in Statement, discarding.^Mcom.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.        at sun.reflect.GeneratedConstructorAccessor57.newInstance(Unknown Source)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.Util.getInstance(Util.java:381)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)        at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:381)        at com.mysql.jdbc.PreparedStatement.clearParameters(PreparedStatement.java:800)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.refreshStatement(GooGooStatementCache.java:604)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:236)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:288)        at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)        at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)        at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)        at net.sf.l2j.gameserver.instancemanager.RaidBossSpawnManager.updateDb(RaidBossSpawnManager.java:405)        at net.sf.l2j.gameserver.instancemanager.RaidBossSpawnManager.cleanUp(RaidBossSpawnManager.java:520)        at net.sf.l2j.gameserver.Shutdown.saveData(Shutdown.java:494)        at net.sf.l2j.gameserver.Shutdown.run(Shutdown.java:227)^Mjava.sql.SQLException: An SQLException was provoked by the following failure: java.util.ConcurrentModificationException        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:62)        at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1271)        at net.sf.l2j.gameserver.instancemanager.RaidBossSpawnManager.updateDb(RaidBossSpawnManager.java:405)        at net.sf.l2j.gameserver.instancemanager.RaidBossSpawnManager.cleanUp(RaidBossSpawnManager.java:520)        at net.sf.l2j.gameserver.Shutdown.saveData(Shutdown.java:494)        at net.sf.l2j.gameserver.Shutdown.run(Shutdown.java:227)Caused by: java.util.ConcurrentModificationException        at java.util.HashMap$HashIterator.nextEntry(HashMap.java:793)        at java.util.HashMap$KeyIterator.next(HashMap.java:828)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:286)        at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)        at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)        at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)        ... 4 moreRaidBossSpawnManager: All raidboss info saved!!^MGrandBossManager: All Grand Boss info saved!!^MTradeController: All count Item Saved^MOlympiad System: Data saved!!^MData saved. All players disconnected, shutting down. 

Anybody knows what's the problem?

PS. Sorry for bad english...

[itskidd]

i'm not sure on what problem you're having is, but you could always try to use a different Rev to see if you get the same error.. It might help you beable to narrow down the reason. Unless you are using one of the few revs that wont load.

[_DS_]

Problem with SQL server...

[toxocara77]

Lots of similar errors in logs. Please help.

Code: Select all

 Could not restore augmentation and elemental data for item 268508992 from DB: Communications link failure Last packet sent to the server was 0 ms ago.com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago.        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)        at java.lang.reflect.Constructor.newInstance(Unknown Source)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3009)        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2895)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3438)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912)        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)        at net.sf.l2j.gameserver.model.L2ItemInstance.restoreAttributes(L2ItemInstance.java:884)        at net.sf.l2j.gameserver.model.L2ItemInstance.restoreFromDb(L2ItemInstance.java:1372)        at net.sf.l2j.gameserver.model.itemcontainer.Inventory.restore(Inventory.java:1554)        at net.sf.l2j.gameserver.model.itemcontainer.PcInventory.restore(PcInventory.java:560)        at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.<init>(L2PcInstance.java:1111)        at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.restore(L2PcInstance.java:7031)        at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.load(L2PcInstance.java:1063)        at net.sf.l2j.gameserver.network.L2GameClient.loadCharFromDisk(L2GameClient.java:473)        at net.sf.l2j.gameserver.network.clientpackets.CharacterSelect.runImpl(CharacterSelect.java:87)        at net.sf.l2j.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:76)        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)        at java.lang.Thread.run(Unknown Source)Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2455)        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2906)        ... 21 more Problem with checked-in Statement, discarding.com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)        at java.lang.reflect.Constructor.newInstance(Unknown Source)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.Util.getInstance(Util.java:381)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)        at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:381)        at com.mysql.jdbc.PreparedStatement.clearParameters(PreparedStatement.java:800)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.refreshStatement(GooGooStatementCache.java:604)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:236)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:288)        at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)        at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)        at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)        at net.sf.l2j.gameserver.model.L2ItemInstance.restoreAttributes(L2ItemInstance.java:909)        at net.sf.l2j.gameserver.model.L2ItemInstance.restoreFromDb(L2ItemInstance.java:1372)        at net.sf.l2j.gameserver.model.itemcontainer.Inventory.restore(Inventory.java:1554)        at net.sf.l2j.gameserver.model.itemcontainer.PcInventory.restore(PcInventory.java:560)        at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.<init>(L2PcInstance.java:1111)        at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.restore(L2PcInstance.java:7031)        at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.load(L2PcInstance.java:1063)        at net.sf.l2j.gameserver.network.L2GameClient.loadCharFromDisk(L2GameClient.java:473)        at net.sf.l2j.gameserver.network.clientpackets.CharacterSelect.runImpl(CharacterSelect.java:87)        at net.sf.l2j.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:76)        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)        at java.lang.Thread.run(Unknown Source) Could not restore augmentation and elemental data for item 268587939 from DB: Communications link failure Last packet sent to the server was 1 ms ago.com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

[toastgodsupreme]

Despite popular claims, the community here is not psychic. We don't know what your server configuration is. We don't know if you're running your database on the same server or a separate one. We don't know your startup params for the game server, we don't know what OS, version of SQL, or anything for that matter.

We don't know your hardware setup, your sql settings, etc.

This does NOT mean for you to copy every single setting you have. Use some common sense, filter out the useful bits and let us know what you're running and what your setup is. From there someone might be able to help you.

[toxocara77]

Well, sry for being noob, just forgot to post the stuff

System specs
Intel(R) Core(TM)2 Quad CPU Q8300 @ 2.50GHz, 4GB RAM

OS
Fedora Core 8 x64
Linux pl766 2.6.23.1-42.fc8 #1 SMP Tue Oct 30 13:18:33 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux

Java
java version "1.6.0_14"
Java(TM) SE Runtime Environment (build 1.6.0_14-b08)
Java HotSpot(TM) 64-Bit Server VM (build 14.0-b16, mixed mode)

Disk usage
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/isw_ddifhebaib_raid-1p1
198G 2.6G 185G 2% /
/dev/mapper/isw_ddifhebaib_raid-1p2
30G 2.5G 26G 9% /var
tmpfs 2.0G 0 2.0G 0% /dev/shm


Mysql
mysql-5.0.45-4.fc8

The database is on the same server
Mysql port 3306 covered by firewall
SSH tunneling to administer server DB

MySQL variables

| auto_increment_increment 1
| auto_increment_offset 1
| automatic_sp_privileges ON
| back_log 50
| basedir /usr/
| bdb_cache_size 8388600
| bdb_home /var/lib/mysql/
| bdb_log_buffer_size 32768
| bdb_logdir
| bdb_max_lock 10000
| bdb_shared_data OFF
| bdb_tmpdir /tmp/
| binlog_cache_size 32768
| bulk_insert_buffer_size 8388608
| character_set_client latin1
| character_set_connection latin1
| character_set_database latin1
| character_set_filesystem binary
| character_set_results latin1
| character_set_server latin1
| character_set_system utf8
| character_sets_dir /usr/share/mysql/charsets/
| collation_connection latin1_swedish_ci
| collation_database latin1_swedish_ci
| collation_server latin1_swedish_ci
| completion_type 0
| concurrent_insert 1
| connect_timeout 5
| datadir /var/lib/mysql/
| date_format %Y-%m-%d
| datetime_format %Y-%m-%d %H:%i:%s
| default_week_format 0
| delay_key_write ON
| delayed_insert_limit 100
| delayed_insert_timeout 300
| delayed_queue_size 1000
| div_precision_increment 4
| engine_condition_pushdown OFF
| expire_logs_days 0
| flush OFF
| flush_time 0
| ft_boolean_syntax + -><()~*:""&|
| ft_max_word_len 84
| ft_min_word_len 4
| ft_query_expansion_limit 20
| ft_stopword_file (built-in)
| group_concat_max_len 1024
| have_archive NO
| have_bdb YES
| have_blackhole_engine NO
| have_compress YES
| have_crypt YES
| have_csv NO
| have_dynamic_loading YES
| have_example_engine NO
| have_federated_engine NO
| have_geometry YES
| have_innodb YES
| have_isam NO
| have_merge_engine YES
| have_ndbcluster NO
| have_openssl DISABLED
| have_ssl DISABLED
| have_query_cache YES
| have_raid NO
| have_rtree_keys YES
| have_symlink YES
| hostname pl766
| init_connect
| init_file
| init_slave
| innodb_additional_mem_pool_size 1048576
| innodb_autoextend_increment 8
| innodb_buffer_pool_awe_mem_mb 0
| innodb_buffer_pool_size 8388608
| innodb_checksums ON
| innodb_commit_concurrency 0
| innodb_concurrency_tickets 500
| innodb_data_file_path ibdata1:10M:autoextend
| innodb_data_home_dir
| innodb_doublewrite ON
| innodb_fast_shutdown 1
| innodb_file_io_threads 4
| innodb_file_per_table OFF
| innodb_flush_log_at_trx_commit 1
| innodb_flush_method
| innodb_force_recovery 0
| innodb_lock_wait_timeout 50
| innodb_locks_unsafe_for_binlog OFF
| innodb_log_arch_dir
| innodb_log_archive OFF
| innodb_log_buffer_size 1048576
| innodb_log_file_size 5242880
| innodb_log_files_in_group 2
| innodb_log_group_home_dir ./
| innodb_max_dirty_pages_pct 90
| innodb_max_purge_lag 0
| innodb_mirrored_log_groups 1
| innodb_open_files 300
| innodb_rollback_on_timeout OFF
| innodb_support_xa ON
| innodb_sync_spin_loops 20
| innodb_table_locks ON
| innodb_thread_concurrency 8
| innodb_thread_sleep_delay 10000
| interactive_timeout 28800
| join_buffer_size 131072
| key_buffer_size 8388600
| key_cache_age_threshold 300
| key_cache_block_size 1024
| key_cache_division_limit 100
| language /usr/share/mysql/english/
| large_files_support ON
| large_page_size 0
| large_pages OFF
| lc_time_names en_US
| license GPL
| local_infile ON
| locked_in_memory OFF
| log OFF
| log_bin OFF
| log_bin_trust_function_creators OFF
| log_error
| log_queries_not_using_indexes OFF
| log_slave_updates OFF
| log_slow_queries OFF
| log_warnings 1
| long_query_time 10
| low_priority_updates OFF
| lower_case_file_system OFF
| lower_case_table_names 0
| max_allowed_packet 1048576
| max_binlog_cache_size 18446744073709551615
| max_binlog_size 1073741824
| max_connect_errors 10
| max_connections 500
| max_delayed_threads 20
| max_error_count 64
| max_heap_table_size 16777216
| max_insert_delayed_threads 20
| max_join_size 18446744073709551615
| max_length_for_sort_data 1024
| max_prepared_stmt_count 16382
| max_relay_log_size 0
| max_seeks_for_key 18446744073709551615
| max_sort_length 1024
| max_sp_recursion_depth 0
| max_tmp_tables 32
| max_user_connections 0
| max_write_lock_count 18446744073709551615
| multi_range_count 256
| myisam_data_pointer_size 6
| myisam_max_sort_file_size 9223372036854775807
| myisam_recover_options OFF
| myisam_repair_threads 1
| myisam_sort_buffer_size 8388608
| myisam_stats_method nulls_unequal
| net_buffer_length 16384
| net_read_timeout 30
| net_retry_count 10
| net_write_timeout 60
| new OFF
| old_passwords ON
| open_files_limit 2500
| optimizer_prune_level 1
| optimizer_search_depth 62
| pid_file /var/run/mysqld/mysqld.pid
| port 3306
| preload_buffer_size 32768
| profiling OFF
| profiling_history_size 15
| protocol_version 10
| query_alloc_block_size 8192
| query_cache_limit 1048576
| query_cache_min_res_unit 4096
| query_cache_size 0
| query_cache_type ON
| query_cache_wlock_invalidate OFF
| query_prealloc_size 8192
| range_alloc_block_size 2048
| read_buffer_size 131072
| read_only OFF
| read_rnd_buffer_size 262144
| relay_log_purge ON
| relay_log_space_limit 0
| rpl_recovery_rank 0
| secure_auth OFF
| secure_file_priv
| server_id 0
| skip_external_locking ON
| skip_networking OFF
| skip_show_database OFF
| slave_compressed_protocol OFF
| slave_load_tmpdir /tmp/
| slave_net_timeout 3600
| slave_skip_errors OFF
| slave_transaction_retries 10
| slow_launch_time 2
| socket /var/lib/mysql/mysql.sock
| sort_buffer_size 2097144
| sql_big_selects ON
| sql_mode
| sql_notes ON
| sql_warnings OFF
| ssl_ca
| ssl_capath
| ssl_cert
| ssl_cipher
| ssl_key
| storage_engine MyISAM
| sync_binlog 0
| sync_frm ON
| system_time_zone NOVST
| table_cache 64
| table_lock_wait_timeout 50
| table_type MyISAM
| thread_cache_size 0
| thread_stack 262144
| time_format %H:%i:%s
| time_zone SYSTEM
| timed_mutexes OFF
| tmp_table_size 33554432
| tmpdir /tmp/
| transaction_alloc_block_size 8192
| transaction_prealloc_size 4096
| tx_isolation REPEATABLE-READ
| updatable_views_with_limit YES
| version 5.0.45
| version_bdb Sleepycat Software: Berkeley DB 4.1.24: (July 4, 2007)
| version_comment Source distribution
| version_compile_machine x86_64
| version_compile_os redhat-linux-gnu
| wait_timeout 28800

Mysql config file
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

GS Startup parameters
#!/bin/bash

# exit codes of GameServer:
# 0 normal shutdown
# 2 reboot attempt

while :; do
[ -f log/java0.log.0 ] && mv log/java0.log.0 "log/`date +%Y-%m-%d_%H-%M-%S`_java.log"
[ -f log/stdout.log ] && mv log/stdout.log "log/`date +%Y-%m-%d_%H-%M-%S`_stdout.log"
java -Xms2048m -Xmx2048m -cp ./../libs/*:l2jserver.jar net.sf.l2j.gameserver.GameServer > log/stdout.log 2>&1
[ $? -ne 2 ] && break
# /etc/init.d/mysql restart
sleep 10

GS Revision - 3288
DP Revision - 6410

Average online - 100-150 ppl


GS starts without problem. Lots of errors appear after some time while server is up. Sometimes after 10-15 hours server start lagging and freezes. Average CPU load - 5-10%. Average java memory usage - 50%
The errors are of this type

Code: Select all

Could not update item 268646064 in DB: Reason: Communications link failure Last packet sent to the server was 0 ms ago.com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago.        at sun.reflect.GeneratedConstructorAccessor58.newInstance(Unknown Source)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)        at java.lang.reflect.Constructor.newInstance(Unknown Source)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3009)        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2895)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3438)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2046)        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1964)        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1949)        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)        at net.sf.l2j.gameserver.model.L2ItemInstance.updateInDb(L2ItemInstance.java:1480)        at net.sf.l2j.gameserver.model.L2ItemInstance.updateDatabase(L2ItemInstance.java:1295)        at net.sf.l2j.gameserver.model.L2ItemInstance.updateDatabase(L2ItemInstance.java:1272)        at net.sf.l2j.gameserver.model.itemcontainer.Inventory.setPaperdollItem(Inventory.java:1028)        at net.sf.l2j.gameserver.model.itemcontainer.Inventory.equipItem(Inventory.java:1283)        at net.sf.l2j.gameserver.model.itemcontainer.Inventory.addItem(Inventory.java:814)        at net.sf.l2j.gameserver.model.itemcontainer.Inventory.restore(Inventory.java:1576)        at net.sf.l2j.gameserver.model.itemcontainer.PcInventory.restore(PcInventory.java:560)        at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.<init>(L2PcInstance.java:1111)        at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.restore(L2PcInstance.java:7031)        at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.load(L2PcInstance.java:1063)        at net.sf.l2j.gameserver.network.L2GameClient.loadCharFromDisk(L2GameClient.java:473)        at net.sf.l2j.gameserver.network.clientpackets.CharacterSelect.runImpl(CharacterSelect.java:87)        at net.sf.l2j.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:76)        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)        at java.lang.Thread.run(Unknown Source)Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexectedly lost.        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2455)        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2906)        ... 27 more Problem with checked-in Statement, discarding.com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.        at sun.reflect.GeneratedConstructorAccessor59.newInstance(Unknown Source)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)        at java.lang.reflect.Constructor.newInstance(Unknown Source)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.Util.getInstance(Util.java:381)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)        at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:381)        at com.mysql.jdbc.PreparedStatement.clearParameters(PreparedStatement.java:800)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.refreshStatement(GooGooStatementCache.java:604)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:236)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:288)        at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)        at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)        at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)        at net.sf.l2j.gameserver.model.L2ItemInstance.updateInDb(L2ItemInstance.java:1491)        at net.sf.l2j.gameserver.model.L2ItemInstance.updateDatabase(L2ItemInstance.java:1295)        at net.sf.l2j.gameserver.model.L2ItemInstance.updateDatabase(L2ItemInstance.java:1272)        at net.sf.l2j.gameserver.model.itemcontainer.Inventory.setPaperdollItem(Inventory.java:1028)        at net.sf.l2j.gameserver.model.itemcontainer.Inventory.equipItem(Inventory.java:1283)        at net.sf.l2j.gameserver.model.itemcontainer.Inventory.addItem(Inventory.java:814)        at net.sf.l2j.gameserver.model.itemcontainer.Inventory.restore(Inventory.java:1576)        at net.sf.l2j.gameserver.model.itemcontainer.PcInventory.restore(PcInventory.java:560)        at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.<init>(L2PcInstance.java:1111)        at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.restore(L2PcInstance.java:7031)        at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.load(L2PcInstance.java:1063)        at net.sf.l2j.gameserver.network.L2GameClient.loadCharFromDisk(L2GameClient.java:473)        at net.sf.l2j.gameserver.network.clientpackets.CharacterSelect.runImpl(CharacterSelect.java:87)        at net.sf.l2j.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:76)        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)        at java.lang.Thread.run(Unknown Source)

[toxocara77]

Solved. SELinux problem.