Вход

ShadowPK · 03-01-2013, 11:07 PM

В общем сборка L2jdev - на овере исходе.
Постоянно вылетают такие ошибки

PHP код:
<?php 

[01.03.13 22:43:50:628] ERROR dao.ItemsDAO: Error while updating item : 5575 Ancient Adena (95000)[268692382]

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 44-683-624 milliseconds ago.  The last packet sent successfully to the server was 44-683-624 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

    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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3352)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1971)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.mmocore.gameserver.dao.ItemsDAO.update0(ItemsDAO.java:245)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:343)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:361)

    at org.mmocore.gameserver.model.items.PcInventory.store(PcInventory.java:433)

    at org.mmocore.gameserver.model.Player.prepareToLogout(Player.java:852)

    at org.mmocore.gameserver.model.Player.access$800(Player.java:124)

    at org.mmocore.gameserver.model.Player$1.runImpl(Player.java:3486)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

    at java.util.concurrent.FutureTask.run(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$Worker.runTask(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.net.SocketException: Software caused connection abort: socket write error

    at java.net.SocketOutputStream.socketWrite0(Native Method)

    at java.net.SocketOutputStream.socketWrite(Unknown Source)

    at java.net.SocketOutputStream.write(Unknown Source)

    at java.io.BufferedOutputStream.flushBuffer(Unknown Source)

    at java.io.BufferedOutputStream.flush(Unknown Source)

    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3333)

    ... 23 more

[01.03.13 22:43:50:630] ERROR dao.ItemsDAO: Error while updating item : 10518 Red Talisman - Life Force (1)[268555775]

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 44-683-628 milliseconds ago.  The last packet sent successfully to the server was 44-683-628 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

    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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3352)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1971)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.mmocore.gameserver.dao.ItemsDAO.update0(ItemsDAO.java:245)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:343)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:361)

    at org.mmocore.gameserver.model.items.PcInventory.store(PcInventory.java:433)

    at org.mmocore.gameserver.model.Player.prepareToLogout(Player.java:852)

    at org.mmocore.gameserver.model.Player.access$800(Player.java:124)

    at org.mmocore.gameserver.model.Player$1.runImpl(Player.java:3486)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

    at java.util.concurrent.FutureTask.run(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$Worker.runTask(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.net.SocketException: Software caused connection abort: socket write error

    at java.net.SocketOutputStream.socketWrite0(Native Method)

    at java.net.SocketOutputStream.socketWrite(Unknown Source)

    at java.net.SocketOutputStream.write(Unknown Source)

    at java.io.BufferedOutputStream.flushBuffer(Unknown Source)

    at java.io.BufferedOutputStream.flush(Unknown Source)

    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3333)

    ... 23 more

[01.03.13 22:43:50:632] ERROR dao.ItemsDAO: Error while updating item : 10417 Blue Talisman - Magic Explosion (1)[268756268]

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 44-683-629 milliseconds ago.  The last packet sent successfully to the server was 44-683-630 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

    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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3352)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1971)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.mmocore.gameserver.dao.ItemsDAO.update0(ItemsDAO.java:245)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:343)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:361)

    at org.mmocore.gameserver.model.items.PcInventory.store(PcInventory.java:433)

    at org.mmocore.gameserver.model.Player.prepareToLogout(Player.java:852)

    at org.mmocore.gameserver.model.Player.access$800(Player.java:124)

    at org.mmocore.gameserver.model.Player$1.runImpl(Player.java:3486)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

    at java.util.concurrent.FutureTask.run(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$Worker.runTask(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.net.SocketException: Software caused connection abort: socket write error

    at java.net.SocketOutputStream.socketWrite0(Native Method)

    at java.net.SocketOutputStream.socketWrite(Unknown Source)

    at java.net.SocketOutputStream.write(Unknown Source)

    at java.io.BufferedOutputStream.flushBuffer(Unknown Source)

    at java.io.BufferedOutputStream.flush(Unknown Source)

    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3333)

    ... 23 more

[01.03.13 22:43:52:605] ERROR model.Player: Could not store char data: Lestat[269214240]!

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 23-000 milliseconds ago.  The last packet sent successfully to the server was 18-899 milliseconds 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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415)

    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333)

    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)

    at org.mmocore.gameserver.model.Player.store(Player.java:4340)

    at org.mmocore.gameserver.taskmanager.AutoSaveManager$2.runImpl(AutoSaveManager.java:55)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at org.mmocore.commons.threading.SteppingRunnableQueueManager$SteppingScheduledFuture.run(SteppingRunnableQueueManager.java:61)

    at org.mmocore.commons.threading.SteppingRunnableQueueManager.run(SteppingRunnableQueueManager.java:185)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)

    at java.util.concurrent.FutureTask.runAndReset(Unknown Source)

    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(Unknown Source)

    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(Unknown Source)

    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

    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.net.SocketTimeoutException: Read timed out

    at java.net.SocketInputStream.socketRead0(Native Method)

    at java.net.SocketInputStream.read(Unknown Source)

    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)

    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)

    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)

    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2537)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)

    ... 25 more

[01.03.13 22:43:58:484] ERROR taskmanager.DelayedItemsManager: 

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 34-774 milliseconds ago.  The last packet sent successfully to the server was 18-891 milliseconds 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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

    at org.mmocore.gameserver.taskmanager.DelayedItemsManager.get_last_payment_id(DelayedItemsManager.java:67)

    at org.mmocore.gameserver.taskmanager.DelayedItemsManager.runImpl(DelayedItemsManager.java:93)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

    at java.util.concurrent.FutureTask.run(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$Worker.runTask(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.net.SocketTimeoutException: Read timed out

    at java.net.SocketInputStream.socketRead0(Native Method)

    at java.net.SocketInputStream.read(Unknown Source)

    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)

    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)

    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)

    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2537)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)

    ... 20 more

[01.03.13 22:44:07:324] ERROR dao.ItemsDAO: Error while updating item : 492 +25 Tattoo of Soul (1)[268638770]

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 44-604 milliseconds ago.  The last packet sent successfully to the server was 18-898 milliseconds 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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.mmocore.gameserver.dao.ItemsDAO.update0(ItemsDAO.java:245)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:343)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:361)

    at org.mmocore.gameserver.model.items.PcInventory.store(PcInventory.java:433)

    at org.mmocore.gameserver.model.Player.prepareToLogout(Player.java:852)

    at org.mmocore.gameserver.model.Player.access$800(Player.java:124)

    at org.mmocore.gameserver.model.Player$1.runImpl(Player.java:3486)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

    at java.util.concurrent.FutureTask.run(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$Worker.runTask(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.net.SocketTimeoutException: Read timed out

    at java.net.SocketInputStream.socketRead0(Native Method)

    at java.net.SocketInputStream.read(Unknown Source)

    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)

    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)

    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)

    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2537)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)

    ... 25 more

[01.03.13 22:44:07:334] ERROR dao.ItemsDAO: Error while updating item : 6658 +25 Ring of Baium (1)[268488504]

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 1-451-042 milliseconds ago.  The last packet sent successfully to the server was 18-899 milliseconds 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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.mmocore.gameserver.dao.ItemsDAO.update0(ItemsDAO.java:245)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:343)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:361)

    at org.mmocore.gameserver.model.items.PcInventory.store(PcInventory.java:433)

    at org.mmocore.gameserver.model.Player.prepareToLogout(Player.java:852)

    at org.mmocore.gameserver.model.Player.access$800(Player.java:124)

    at org.mmocore.gameserver.model.Player$1.runImpl(Player.java:3486)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

    at java.util.concurrent.FutureTask.run(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$Worker.runTask(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.net.SocketTimeoutException: Read timed out

    at java.net.SocketInputStream.socketRead0(Native Method)

    at java.net.SocketInputStream.read(Unknown Source)

    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)

    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)

    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)

    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2537)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)

    ... 25 more

[01.03.13 22:44:07:475] ERROR dao.ItemsDAO: Error while updating item : 21583 Festival's Cloak - True Black (1)[268715241]

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 26-082-474 milliseconds ago.  The last packet sent successfully to the server was 18-898 milliseconds 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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.mmocore.gameserver.dao.ItemsDAO.update0(ItemsDAO.java:245)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:343)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:361)

    at org.mmocore.gameserver.model.items.PcInventory.store(PcInventory.java:433)

    at org.mmocore.gameserver.model.Player.prepareToLogout(Player.java:852)

    at org.mmocore.gameserver.model.Player.access$800(Player.java:124)

    at org.mmocore.gameserver.model.Player$1.runImpl(Player.java:3486)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

    at java.util.concurrent.FutureTask.run(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$Worker.runTask(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.net.SocketTimeoutException: Read timed out

    at java.net.SocketInputStream.socketRead0(Native Method)

    at java.net.SocketInputStream.read(Unknown Source)

    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)

    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)

    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)

    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2537)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)

    ... 25 more

[01.03.13 22:44:07:954] ERROR dao.ItemsDAO: Error while updating item : 8142 Spell Breaker \Magic Mental Shield\ (1)[268744257]

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 26-082-954 milliseconds ago.  The last packet sent successfully to the server was 18-897 milliseconds ago.

    at sun.reflect.GeneratedConstructorAccessor249.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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.mmocore.gameserver.dao.ItemsDAO.update0(ItemsDAO.java:245)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:343)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:361)

    at org.mmocore.gameserver.model.items.PcInventory.store(PcInventory.java:433)

    at org.mmocore.gameserver.model.Player.prepareToLogout(Player.java:852)

    at org.mmocore.gameserver.model.Player.access$800(Player.java:124)

    at org.mmocore.gameserver.model.Player$1.runImpl(Player.java:3486)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

    at java.util.concurrent.FutureTask.run(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$Worker.runTask(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.net.SocketTimeoutException: Read timed out

    at java.net.SocketInputStream.socketRead0(Native Method)

    at java.net.SocketInputStream.read(Unknown Source)

    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)

    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)

    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)

    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2537)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)

    ... 25 more

[01.03.13 22:44:08:765] ERROR dao.ItemsDAO: Error while updating item : 493 +10 Tattoo of Avadon (1)[268554302]

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 26-083-765 milliseconds ago.  The last packet sent successfully to the server was 18-898 milliseconds ago.

    at sun.reflect.GeneratedConstructorAccessor249.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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.mmocore.gameserver.dao.ItemsDAO.update0(ItemsDAO.java:245)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:343)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:361)

    at org.mmocore.gameserver.model.items.PcInventory.store(PcInventory.java:433)

    at org.mmocore.gameserver.model.Player.prepareToLogout(Player.java:852)

    at org.mmocore.gameserver.model.Player.access$800(Player.java:124)

    at org.mmocore.gameserver.model.Player$1.runImpl(Player.java:3486)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

    at java.util.concurrent.FutureTask.run(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$Worker.runTask(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.net.SocketTimeoutException: Read timed out

    at java.net.SocketInputStream.socketRead0(Native Method)

    at java.net.SocketInputStream.read(Unknown Source)

    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)

    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)

    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)

    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2537)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)

    ... 25 more

[01.03.13 22:44:08:954] ERROR dao.ItemsDAO: Error while updating item : 492 +25 Tattoo of Soul (1)[268842955]

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 26-083-954 milliseconds ago.  The last packet sent successfully to the server was 18-899 milliseconds ago.

    at sun.reflect.GeneratedConstructorAccessor249.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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.mmocore.gameserver.dao.ItemsDAO.update0(ItemsDAO.java:245)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:343)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:361)

    at org.mmocore.gameserver.model.items.PcInventory.store(PcInventory.java:433)

    at org.mmocore.gameserver.model.Player.prepareToLogout(Player.java:852)

    at org.mmocore.gameserver.model.Player.access$800(Player.java:124)

    at org.mmocore.gameserver.model.Player$1.runImpl(Player.java:3486)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

    at java.util.concurrent.FutureTask.run(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$Worker.runTask(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.net.SocketTimeoutException: Read timed out

    at java.net.SocketInputStream.socketRead0(Native Method)

    at java.net.SocketInputStream.read(Unknown Source)

    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)

    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)

    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)

    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2537)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)

    ... 25 more

Russ1aStar · 03-02-2013, 12:32 AM

Ошибка с итемами, причем разными, вот 1 из примеров.
Конкретно сказать больше не могу, 1 раз вижу такое.

Цитата: ERROR dao.ItemsDAO: Error while updating item : 21583 Festival's Cloak - True Black (1)[268715241]

darkevil · 03-02-2013, 12:46 AM

ShadowPK Написал:В общем сборка L2jdev - на овере исходе.
Постоянно вылетают такие ошибки

PHP код:
<?php 

[01.03.13 22:43:50:628] ERROR dao.ItemsDAO: Error while updating item : 5575 Ancient Adena (95000)[268692382]

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 44-683-624 milliseconds ago.  The last packet sent successfully to the server was 44-683-624 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

    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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3352)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1971)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.mmocore.gameserver.dao.ItemsDAO.update0(ItemsDAO.java:245)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:343)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:361)

    at org.mmocore.gameserver.model.items.PcInventory.store(PcInventory.java:433)

    at org.mmocore.gameserver.model.Player.prepareToLogout(Player.java:852)

    at org.mmocore.gameserver.model.Player.access$800(Player.java:124)

    at org.mmocore.gameserver.model.Player$1.runImpl(Player.java:3486)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

    at java.util.concurrent.FutureTask.run(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$Worker.runTask(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.net.SocketException: Software caused connection abort: socket write error

    at java.net.SocketOutputStream.socketWrite0(Native Method)

    at java.net.SocketOutputStream.socketWrite(Unknown Source)

    at java.net.SocketOutputStream.write(Unknown Source)

    at java.io.BufferedOutputStream.flushBuffer(Unknown Source)

    at java.io.BufferedOutputStream.flush(Unknown Source)

    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3333)

    ... 23 more

[01.03.13 22:43:50:630] ERROR dao.ItemsDAO: Error while updating item : 10518 Red Talisman - Life Force (1)[268555775]

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 44-683-628 milliseconds ago.  The last packet sent successfully to the server was 44-683-628 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

    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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3352)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1971)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.mmocore.gameserver.dao.ItemsDAO.update0(ItemsDAO.java:245)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:343)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:361)

    at org.mmocore.gameserver.model.items.PcInventory.store(PcInventory.java:433)

    at org.mmocore.gameserver.model.Player.prepareToLogout(Player.java:852)

    at org.mmocore.gameserver.model.Player.access$800(Player.java:124)

    at org.mmocore.gameserver.model.Player$1.runImpl(Player.java:3486)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

    at java.util.concurrent.FutureTask.run(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$Worker.runTask(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.net.SocketException: Software caused connection abort: socket write error

    at java.net.SocketOutputStream.socketWrite0(Native Method)

    at java.net.SocketOutputStream.socketWrite(Unknown Source)

    at java.net.SocketOutputStream.write(Unknown Source)

    at java.io.BufferedOutputStream.flushBuffer(Unknown Source)

    at java.io.BufferedOutputStream.flush(Unknown Source)

    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3333)

    ... 23 more

[01.03.13 22:43:50:632] ERROR dao.ItemsDAO: Error while updating item : 10417 Blue Talisman - Magic Explosion (1)[268756268]

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 44-683-629 milliseconds ago.  The last packet sent successfully to the server was 44-683-630 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

    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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3352)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1971)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.mmocore.gameserver.dao.ItemsDAO.update0(ItemsDAO.java:245)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:343)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:361)

    at org.mmocore.gameserver.model.items.PcInventory.store(PcInventory.java:433)

    at org.mmocore.gameserver.model.Player.prepareToLogout(Player.java:852)

    at org.mmocore.gameserver.model.Player.access$800(Player.java:124)

    at org.mmocore.gameserver.model.Player$1.runImpl(Player.java:3486)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

    at java.util.concurrent.FutureTask.run(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$Worker.runTask(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.net.SocketException: Software caused connection abort: socket write error

    at java.net.SocketOutputStream.socketWrite0(Native Method)

    at java.net.SocketOutputStream.socketWrite(Unknown Source)

    at java.net.SocketOutputStream.write(Unknown Source)

    at java.io.BufferedOutputStream.flushBuffer(Unknown Source)

    at java.io.BufferedOutputStream.flush(Unknown Source)

    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3333)

    ... 23 more

[01.03.13 22:43:52:605] ERROR model.Player: Could not store char data: Lestat[269214240]!

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 23-000 milliseconds ago.  The last packet sent successfully to the server was 18-899 milliseconds 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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415)

    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333)

    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)

    at org.mmocore.gameserver.model.Player.store(Player.java:4340)

    at org.mmocore.gameserver.taskmanager.AutoSaveManager$2.runImpl(AutoSaveManager.java:55)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at org.mmocore.commons.threading.SteppingRunnableQueueManager$SteppingScheduledFuture.run(SteppingRunnableQueueManager.java:61)

    at org.mmocore.commons.threading.SteppingRunnableQueueManager.run(SteppingRunnableQueueManager.java:185)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)

    at java.util.concurrent.FutureTask.runAndReset(Unknown Source)

    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(Unknown Source)

    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(Unknown Source)

    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

    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.net.SocketTimeoutException: Read timed out

    at java.net.SocketInputStream.socketRead0(Native Method)

    at java.net.SocketInputStream.read(Unknown Source)

    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)

    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)

    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)

    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2537)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)

    ... 25 more

[01.03.13 22:43:58:484] ERROR taskmanager.DelayedItemsManager: 

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 34-774 milliseconds ago.  The last packet sent successfully to the server was 18-891 milliseconds 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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

    at org.mmocore.gameserver.taskmanager.DelayedItemsManager.get_last_payment_id(DelayedItemsManager.java:67)

    at org.mmocore.gameserver.taskmanager.DelayedItemsManager.runImpl(DelayedItemsManager.java:93)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

    at java.util.concurrent.FutureTask.run(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$Worker.runTask(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.net.SocketTimeoutException: Read timed out

    at java.net.SocketInputStream.socketRead0(Native Method)

    at java.net.SocketInputStream.read(Unknown Source)

    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)

    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)

    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)

    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2537)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)

    ... 20 more

[01.03.13 22:44:07:324] ERROR dao.ItemsDAO: Error while updating item : 492 +25 Tattoo of Soul (1)[268638770]

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 44-604 milliseconds ago.  The last packet sent successfully to the server was 18-898 milliseconds 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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.mmocore.gameserver.dao.ItemsDAO.update0(ItemsDAO.java:245)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:343)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:361)

    at org.mmocore.gameserver.model.items.PcInventory.store(PcInventory.java:433)

    at org.mmocore.gameserver.model.Player.prepareToLogout(Player.java:852)

    at org.mmocore.gameserver.model.Player.access$800(Player.java:124)

    at org.mmocore.gameserver.model.Player$1.runImpl(Player.java:3486)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

    at java.util.concurrent.FutureTask.run(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$Worker.runTask(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.net.SocketTimeoutException: Read timed out

    at java.net.SocketInputStream.socketRead0(Native Method)

    at java.net.SocketInputStream.read(Unknown Source)

    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)

    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)

    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)

    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2537)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)

    ... 25 more

[01.03.13 22:44:07:334] ERROR dao.ItemsDAO: Error while updating item : 6658 +25 Ring of Baium (1)[268488504]

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 1-451-042 milliseconds ago.  The last packet sent successfully to the server was 18-899 milliseconds 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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.mmocore.gameserver.dao.ItemsDAO.update0(ItemsDAO.java:245)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:343)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:361)

    at org.mmocore.gameserver.model.items.PcInventory.store(PcInventory.java:433)

    at org.mmocore.gameserver.model.Player.prepareToLogout(Player.java:852)

    at org.mmocore.gameserver.model.Player.access$800(Player.java:124)

    at org.mmocore.gameserver.model.Player$1.runImpl(Player.java:3486)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

    at java.util.concurrent.FutureTask.run(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$Worker.runTask(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.net.SocketTimeoutException: Read timed out

    at java.net.SocketInputStream.socketRead0(Native Method)

    at java.net.SocketInputStream.read(Unknown Source)

    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)

    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)

    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)

    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2537)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)

    ... 25 more

[01.03.13 22:44:07:475] ERROR dao.ItemsDAO: Error while updating item : 21583 Festival's Cloak - True Black (1)[268715241]

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 26-082-474 milliseconds ago.  The last packet sent successfully to the server was 18-898 milliseconds 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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.mmocore.gameserver.dao.ItemsDAO.update0(ItemsDAO.java:245)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:343)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:361)

    at org.mmocore.gameserver.model.items.PcInventory.store(PcInventory.java:433)

    at org.mmocore.gameserver.model.Player.prepareToLogout(Player.java:852)

    at org.mmocore.gameserver.model.Player.access$800(Player.java:124)

    at org.mmocore.gameserver.model.Player$1.runImpl(Player.java:3486)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

    at java.util.concurrent.FutureTask.run(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$Worker.runTask(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.net.SocketTimeoutException: Read timed out

    at java.net.SocketInputStream.socketRead0(Native Method)

    at java.net.SocketInputStream.read(Unknown Source)

    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)

    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)

    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)

    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2537)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)

    ... 25 more

[01.03.13 22:44:07:954] ERROR dao.ItemsDAO: Error while updating item : 8142 Spell Breaker \Magic Mental Shield\ (1)[268744257]

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 26-082-954 milliseconds ago.  The last packet sent successfully to the server was 18-897 milliseconds ago.

    at sun.reflect.GeneratedConstructorAccessor249.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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.mmocore.gameserver.dao.ItemsDAO.update0(ItemsDAO.java:245)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:343)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:361)

    at org.mmocore.gameserver.model.items.PcInventory.store(PcInventory.java:433)

    at org.mmocore.gameserver.model.Player.prepareToLogout(Player.java:852)

    at org.mmocore.gameserver.model.Player.access$800(Player.java:124)

    at org.mmocore.gameserver.model.Player$1.runImpl(Player.java:3486)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

    at java.util.concurrent.FutureTask.run(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$Worker.runTask(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.net.SocketTimeoutException: Read timed out

    at java.net.SocketInputStream.socketRead0(Native Method)

    at java.net.SocketInputStream.read(Unknown Source)

    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)

    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)

    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)

    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2537)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)

    ... 25 more

[01.03.13 22:44:08:765] ERROR dao.ItemsDAO: Error while updating item : 493 +10 Tattoo of Avadon (1)[268554302]

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 26-083-765 milliseconds ago.  The last packet sent successfully to the server was 18-898 milliseconds ago.

    at sun.reflect.GeneratedConstructorAccessor249.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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.mmocore.gameserver.dao.ItemsDAO.update0(ItemsDAO.java:245)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:343)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:361)

    at org.mmocore.gameserver.model.items.PcInventory.store(PcInventory.java:433)

    at org.mmocore.gameserver.model.Player.prepareToLogout(Player.java:852)

    at org.mmocore.gameserver.model.Player.access$800(Player.java:124)

    at org.mmocore.gameserver.model.Player$1.runImpl(Player.java:3486)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

    at java.util.concurrent.FutureTask.run(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$Worker.runTask(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.net.SocketTimeoutException: Read timed out

    at java.net.SocketInputStream.socketRead0(Native Method)

    at java.net.SocketInputStream.read(Unknown Source)

    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)

    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)

    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)

    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2537)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)

    ... 25 more

[01.03.13 22:44:08:954] ERROR dao.ItemsDAO: Error while updating item : 492 +25 Tattoo of Soul (1)[268842955]

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 26-083-954 milliseconds ago.  The last packet sent successfully to the server was 18-899 milliseconds ago.

    at sun.reflect.GeneratedConstructorAccessor249.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:411)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

    at org.mmocore.gameserver.dao.ItemsDAO.update0(ItemsDAO.java:245)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:343)

    at org.mmocore.gameserver.dao.ItemsDAO.update(ItemsDAO.java:361)

    at org.mmocore.gameserver.model.items.PcInventory.store(PcInventory.java:433)

    at org.mmocore.gameserver.model.Player.prepareToLogout(Player.java:852)

    at org.mmocore.gameserver.model.Player.access$800(Player.java:124)

    at org.mmocore.gameserver.model.Player$1.runImpl(Player.java:3486)

    at org.mmocore.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

    at java.util.concurrent.FutureTask.run(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$Worker.runTask(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.net.SocketTimeoutException: Read timed out

    at java.net.SocketInputStream.socketRead0(Native Method)

    at java.net.SocketInputStream.read(Unknown Source)

    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)

    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)

    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)

    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2537)

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)

    ... 25 more

KilRoy · 03-02-2013, 01:10 AM

И походу падает от пропускной способности, ибо инклудится все из логАута перса из мира. Обрезайте очередь, либо убивайте свой недоканал.

ShadowPK · 03-02-2013, 09:05 PM

Проблема в том что бд и сервер стоит на 1 тачке.
Онлайн на сервере не больше 100.
Хотя сервер не из слабых.
Коре ай7.
12 гигов.
База на Ssd

Krasavella · 03-02-2013, 09:18 PM

ShadowPK Написал:База на Ssd

MySql на SSD? Это же быстрый износ [Изображение: 20.gif]

На SSD ставят OS. У вас конфигурация мускула какая?

innodb_buffer_pool_size=?
innodb_additional_mem_pool_size=?
innodb_log_file_size=?
innodb_log_buffer_size=?
innodb_thread_concurrency=?
innodb_flush_log_at_trx_commit=?

ShadowPK · 03-02-2013, 09:22 PM

Krasavella Написал:MySql на SSD? Это же быстрый износ На SSD ставят OS. У вас конфигурация мускула какая?

innodb_buffer_pool_size=?
innodb_additional_mem_pool_size=?
innodb_log_file_size=?
innodb_log_buffer_size=?
innodb_thread_concurrency=?
innodb_flush_log_at_trx_commit=?

Да не столь важен износ SSD поставить новый труда не составит.
А износ на 50-100 онлайна не думаю что очень большой будет.

innodb_buffer_pool_size=525M
innodb_additional_mem_pool_size=11M
innodb_log_file_size=105M
innodb_log_buffer_size=6M
innodb_thread_concurrency=18
innodb_flush_log_at_trx_commit=10

Krasavella · 03-02-2013, 09:33 PM

ShadowPK Написал:innodb_buffer_pool_size=525M
innodb_additional_mem_pool_size=11M
innodb_log_file_size=105M
innodb_log_buffer_size=6M
innodb_thread_concurrency=18
innodb_flush_log_at_trx_commit=10

Зачем innodb_flush_log_at_trx_commit=10 ? Вы описание данной функции читали? "Если допустима потеря нескольких последних транзакций, установите flush_log_в_trx_commit в 0"

default-storage-engine=INNODB установлено?

#skip-innodb закомментировали?

Делайте бекап базы данных, удаляйте ib_logfile0, ib_logfile1, ibdata1, ставьте новые конфиги и заливайте бекап заного

С такой конфигурацией никаких проблем не будет, расчитано на 16 GB RAM и 8 ядерный CPU, для 4 ядерного измените innodb_thread_concurrency на 8:

innodb_buffer_pool_size=4G
innodb_additional_mem_pool_size=128M
innodb_log_file_size=512M
innodb_log_buffer_size=32M
innodb_thread_concurrency=16
innodb_flush_log_at_trx_commit=1

ShadowPK · 03-02-2013, 09:41 PM

Krasavella Написал:Зачем innodb_flush_log_at_trx_commit=10 ? Вы описание данной функции читали? "Если допустима потеря нескольких последних транзакций, установите flush_log_в_trx_commit в 0"

default-storage-engine=INNODB установлено?

#skip-innodb закомментировали?

Делайте бекап базы данных, удаляйте ib_logfile0, ib_logfile1, ibdata1, ставьте новые конфиги и заливайте бекап заного

С такой конфигурацией никаких проблем не будет, расчитано на 16 GB RAM и 8 ядерный CPU, для 4 ядерного измените innodb_thread_concurrency на 8:

innodb_buffer_pool_size=4G
innodb_additional_mem_pool_size=128M
innodb_log_file_size=512M
innodb_log_buffer_size=32M
innodb_thread_concurrency=16
innodb_flush_log_at_trx_commit=1

хорошо попробую настроить как вы отписали чуть позже.
#skip-innodb было закоментировано.
Единственное что сервер на 12 гигов.

linliss · 03-02-2013, 10:02 PM

при 100 онлайна, все должно быть хорошо и на дефолтных настройках...

Вход
Имя пользователя:
Пароль:	Забыли пароль?
	Запомнить меня

Возможно похожие темы ...
Тема		Автор	Ответы	Просмотры	Последний пост
	Lineage][ C3 Сборки серверов + Клиент	Verket	23	10,943	07-17-2024, 04:54 PM Последний пост: AlexBayev
	Что за ошибка?	serg5777	22	9,173	07-11-2023, 09:49 PM Последний пост: ntking
	Ошибка Cannot read field "race"	valdemart123	0	1,074	12-04-2021, 04:44 AM Последний пост: valdemart123
	Шара: исходники сборки l2gw (HF)	rage	326	135,399	04-18-2021, 06:26 PM Последний пост: kpNemo
	При запуске game server на сайте (sw13) ошибка mysql 0	AndreDeiu	1	1,359	09-27-2020, 11:32 PM Последний пост: Lord_Gothic
	А где сборки?	carasique	7	3,614	09-19-2018, 10:37 AM Последний пост: varted
	Защита для сборки l2j-frozen	Mor9k400	4	1,862	09-19-2018, 04:29 AM Последний пост: Psycho
	Java координаты, различия PTS и Java, какие сборки хороши (iL)	varted	5	2,487	09-12-2018, 08:29 AM Последний пост: varted
	Ошибка геймсервера	zane	9	2,591	04-27-2018, 12:28 PM Последний пост: DmnC
	Ошибка загрузки гейм сервера	zane	5	2,051	04-17-2018, 08:03 PM Последний пост: zane