Свернуть ↑
at com.mysql.jdbc.util.ReadAheadInputStream.readFromU nderlyingStreamIfNe
cessary(ReadAheadInputStream.java:143) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.util.ReadAheadInputStream.read(Read AheadInputStream.ja
va:173) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2911 ) ~[mysql-connector
-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:3337) ~[mysql-
connector-java-5.1.33.jar:5.1.33]
... 24 common frames omitted
20:03:52.083 INFO [pool-4-thread-1]: - Sending account disconnected 2
20:06:49.951 INFO [pool-2-thread-18]: - Sending current game time to all players
20:06:49.951 INFO [pool-2-thread-18]: - Game time saved...
20:06:49.956 ERROR[pool-2-thread-18]: - Error storing server time
java.sql.SQLException: Could not retrieve transation read-only status server
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:996) ~[mysql
-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:935) ~[mysql
-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:924) ~[mysql
-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:870) ~[mysql
-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:902) ~[mysql
-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:892) ~[mysql
-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ConnectionImpl.isReadOnly(Connectio nImpl.java:3603) ~[
mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ConnectionImpl.isReadOnly(Connectio nImpl.java:3572) ~[
mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java
:2107) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java
:2077) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java
:2062) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.jolbox.bonecp.PreparedStatementHandle.executeU pdate(PreparedState
mentHandle.java:203) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
at mysql5.MySQL5ServerVariablesDAO.store(MySQL5Server VariablesDAO.java]:
67) ~[na:na]
at com.aionemu.gameserver.utils.gametime.GameTimeMana ger.saveTime(Unknow
n Source) [AL-Game.jar:na]
at com.aionemu.gameserver.services.GameTimeService$1. run(Unknown Source)
[AL-Game.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrappe r.execute(ExecuteWr
apper.java:48) [al-commons.jar:na]
at com.aionemu.commons.utils.concurrent.RunnableWrapp er.run(RunnableWrap
per.java:40) [al-commons.jar:na]
at java.util.concurrent.Executors$RunnableAdapter.cal l(Executors.java:47
1) [na:1.7.0_80]
at java.util.concurrent.FutureTask.runAndReset(Future Task.java:304) [na:
1.7.0_80]
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
access$301(ScheduledThreadPoolExecutor.java:178) [na:1.7.0_80]
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
run(ScheduledThreadPoolExecutor.java:293) [na:1.7.0_80]
at java.util.concurrent.ThreadPoolExecutor.runWorker( ThreadPoolExecutor.
java:1145) [na:1.7.0_80]
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor
.java:615) [na:1.7.0_80]
at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80]
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsExce ption: Communicatio
ns link failure
The last packet successfully received from the server was 177а871 milliseconds a
go. The last packet sent successfully to the server was 0 milliseconds ago.
at sun.reflect.GeneratedConstructorAccessor449.newIns tance(Unknown Sourc
e) ~[na:na]
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingC
onstructorAccessorImpl.java:45) ~[na:1.7.0_80]
at java.lang.reflect.Constructor.newInstance(Construc tor.java:526) ~[na:
1.7.0_80]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:37 7) ~[mysql-connecto
r-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createCommunicationsExcept ion(SQLError.java:1
036) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:3427) ~[mysql-
connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:3327) ~[mysql-
connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3814) ~[mysql-co
nnector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:24 35) ~[mysql-connect
or-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2582) ~[mysql-conn
ector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2526) ~[mys
ql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2484) ~[mys
ql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.StatementImpl.executeQuery(Statemen tImpl.java:1446) ~[
mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ConnectionImpl.isReadOnly(Connectio nImpl.java:3597) ~[
mysql-connector-java-5.1.33.jar:5.1.33]
... 17 common frames omitted
Caused by: java.net.SocketException: Software caused connection abort: recv fail
ed
at java.net.SocketInputStream.socketRead0(Native Method) ~[na:1.7.0_80]
at java.net.SocketInputStream.read(SocketInputStream. java:152) ~[na:1.7.
0_80]
at java.net.SocketInputStream.read(SocketInputStream. java:122) ~[na:1.7.
0_80]
at com.mysql.jdbc.util.ReadAheadInputStream.fill(Read AheadInputStream.ja
va:100) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.util.ReadAheadInputStream.readFromU nderlyingStreamIfNe
cessary(ReadAheadInputStream.java:143) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.util.ReadAheadInputStream.read(Read AheadInputStream.ja
va:173) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2911 ) ~[mysql-connector
-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:3337) ~[mysql-
connector-java-5.1.33.jar:5.1.33]
... 25 common frames omitted
20:08:44.022 INFO [pool-2-thread-5]: - [SurveyController] update task start.
20:08:44.024 ERROR[pool-2-thread-5]: - Database access problem. Killing off all
remaining connections in the connection pool. SQL State = 08S01
20:08:44.033 WARN [pool-2-thread-5]: - getAllNew() from DB: The last packet succ
essfully received from the server was 353а612 milliseconds ago. The last packet
sent successfully to the server was 353а613 milliseconds ago. is longer than th
e server configured value of 'wait_timeout'. You should consider either expiring
and/or testing connection validity before use in your application, increasing t
he server configured values for client timeouts, or using the Connector/J connec
tion property 'autoReconnect=true' to avoid this problem.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsExce ption: The last packet success
fully received from the server was 353а612 milliseconds ago. The last packet se
nt successfully to the server was 353а613 milliseconds ago. is longer than the s
erver configured value of 'wait_timeout'. You should consider either expiring an
d/or testing connection validity before use in your application, increasing the
server configured values for client timeouts, or using the Connector/J connectio
n property 'autoReconnect=true' to avoid this problem.
at sun.reflect.GeneratedConstructorAccessor449.newIns tance(Unknown Sourc
e) ~[na:na]
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingC
onstructorAccessorImpl.java:45) ~[na:1.7.0_80]
at java.lang.reflect.Constructor.newInstance(Construc tor.java:526) ~[na:
1.7.0_80]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:37 7) ~[mysql-connecto
r-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createCommunicationsExcept ion(SQLError.java:1
036) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3661) ~[mysql-connector-java
-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:24 17) ~[mysql-connect
or-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2582) ~[mysql-conn
ector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2530) ~[mys
ql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.ja
va:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeQuery(Prep aredStatement.java:
2030) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.jolbox.bonecp.PreparedStatementHandle.executeQ uery(PreparedStatem
entHandle.java:172) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
at mysql5.MySQL5SurveyControllerDAO.getAllNew(MySQL5S urveyControllerDAO.
java]:55) ~[na:na]
at com.aionemu.gameserver.services.SurveyService.task Update(Unknown Sour
ce) [AL-Game.jar:na]
at com.aionemu.gameserver.services.SurveyService$Task Update.run(Unknown
Source) [AL-Game.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrappe r.execute(ExecuteWr
apper.java:48) [al-commons.jar:na]
at com.aionemu.commons.utils.concurrent.RunnableWrapp er.run(RunnableWrap
per.java:40) [al-commons.jar:na]
at java.util.concurrent.Executors$RunnableAdapter.cal l(Executors.java:47
1) [na:1.7.0_80]
at java.util.concurrent.FutureTask.runAndReset(Future Task.java:304) [na:
1.7.0_80]
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
access$301(ScheduledThreadPoolExecutor.java:178) [na:1.7.0_80]
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
run(ScheduledThreadPoolExecutor.java:293) [na:1.7.0_80]
at java.util.concurrent.ThreadPoolExecutor.runWorker( ThreadPoolExecutor.
java:1145) [na:1.7.0_80]
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor
.java:615) [na:1.7.0_80]
at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80]
Caused by: java.net.SocketException: Software caused connection abort: socket wr
ite error
at java.net.SocketOutputStream.socketWrite0(Native Method) ~[na:1.7.0_80
]
at java.net.SocketOutputStream.socketWrite(SocketOutp utStream.java:113)
~[na:1.7.0_80]
at java.net.SocketOutputStream.write(SocketOutputStre am.java:159) ~[na:1
.7.0_80]
at java.io.BufferedOutputStream.flushBuffer(BufferedO utputStream.java:82
) ~[na:1.7.0_80]
at java.io.BufferedOutputStream.flush(BufferedOutputS tream.java:140) ~[n
a:1.7.0_80]
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3643) ~[mysql-connector-java
-5.1.33.jar:5.1.33]
... 18 common frames omitted
20:09:49.956 INFO [pool-2-thread-7]: - Sending current game time to all players
20:09:49.956 INFO [pool-2-thread-7]: - Game time saved...
20:09:49.997 ERROR[pool-2-thread-7]: - Error storing server time
java.sql.SQLException: Could not retrieve transation read-only status server
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:996) ~[mysql
-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:935) ~[mysql
-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:924) ~[mysql
-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:870) ~[mysql
-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:902) ~[mysql
-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:892) ~[mysql
-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ConnectionImpl.isReadOnly(Connectio nImpl.java:3603) ~[
mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ConnectionImpl.isReadOnly(Connectio nImpl.java:3572) ~[
mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java
:2107) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java
:2077) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java
:2062) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.jolbox.bonecp.PreparedStatementHandle.executeU pdate(PreparedState
mentHandle.java:203) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
at mysql5.MySQL5ServerVariablesDAO.store(MySQL5Server VariablesDAO.java]:
67) ~[na:na]
at com.aionemu.gameserver.utils.gametime.GameTimeMana ger.saveTime(Unknow
n Source) [AL-Game.jar:na]
at com.aionemu.gameserver.services.GameTimeService$1. run(Unknown Source)
[AL-Game.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrappe r.execute(ExecuteWr
apper.java:48) [al-commons.jar:na]
at com.aionemu.commons.utils.concurrent.RunnableWrapp er.run(RunnableWrap
per.java:40) [al-commons.jar:na]
at java.util.concurrent.Executors$RunnableAdapter.cal l(Executors.java:47
1) [na:1.7.0_80]
at java.util.concurrent.FutureTask.runAndReset(Future Task.java:304) [na:
1.7.0_80]
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
access$301(ScheduledThreadPoolExecutor.java:178) [na:1.7.0_80]
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
run(ScheduledThreadPoolExecutor.java:293) [na:1.7.0_80]
at java.util.concurrent.ThreadPoolExecutor.runWorker( ThreadPoolExecutor.
java:1145) [na:1.7.0_80]
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor
.java:615) [na:1.7.0_80]
at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80]
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsExce ption: Communicatio
ns link failure
The last packet successfully received from the server was 65а788 milliseconds ag
o. The last packet sent successfully to the server was 1 milliseconds ago.
at sun.reflect.GeneratedConstructorAccessor449.newIns tance(Unknown Sourc
e) ~[na:na]
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingC
onstructorAccessorImpl.java:45) ~[na:1.7.0_80]
at java.lang.reflect.Constructor.newInstance(Construc tor.java:526) ~[na:
1.7.0_80]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:37 7) ~[mysql-connecto
r-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createCommunicationsExcept ion(SQLError.java:1
036) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:3427) ~[mysql-
connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:3327) ~[mysql-
connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3814) ~[mysql-co
nnector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:24 35) ~[mysql-connect
or-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2582) ~[mysql-conn
ector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2526) ~[mys
ql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2484) ~[mys
ql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.StatementImpl.executeQuery(Statemen tImpl.java:1446) ~[
mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ConnectionImpl.isReadOnly(Connectio nImpl.java:3597) ~[
mysql-connector-java-5.1.33.jar:5.1.33]
... 17 common frames omitted
Caused by: java.net.SocketException: Software caused connection abort: recv fail
ed
at java.net.SocketInputStream.socketRead0(Native Method) ~[na:1.7.0_80]
at java.net.SocketInputStream.read(SocketInputStream. java:152) ~[na:1.7.
0_80]
at java.net.SocketInputStream.read(SocketInputStream. java:122) ~[na:1.7.
0_80]
at com.mysql.jdbc.util.ReadAheadInputStream.fill(Read AheadInputStream.ja
va:100) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.util.ReadAheadInputStream.readFromU nderlyingStreamIfNe
cessary(ReadAheadInputStream.java:143) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.util.ReadAheadInputStream.read(Read AheadInputStream.ja
va:173) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2911 ) ~[mysql-connector
-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:3337) ~[mysql-
connector-java-5.1.33.jar:5.1.33]
... 25 common frames omitted