[css]

Провела эксперимент, чтобы точно зафиксировать суть происходящего. Запустила серверы, запустила клиент, добавила ГМ командами заклы (последовательно назначала уровень чара, проходя через уровни, на которых даются новые заклы или апаются старые, так оказалось действенней, чем добавлять заклы по одному). Довела чара до 16го уровня. Распределила заклинания на панелях. Вышла в окно выбора персонажа, подождала 15 секунд, закрыла игру. Серверы не выключала и не перезагружала. Включила игру заново. Итог: персонаж 16го уровня, все заклинания распределены на панелях так, как я их и оставила, но половина заклинаний неактивна, ибо оказались невыученными, в моём случае забытыми. В окне консоли сервера, к счастью, есть что-то про ошибки.

Многотекста:

Свернуть ↑ 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

Свернуть ↑Развернуть ↓

Судя по всему, суть ошибки: Could not retrieve transation read-only status server.
Или вот:

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsExce ption: The last pac
ket successfully received from the server was 539а851 milliseconds ago. The las
t packet sent successfully to the server was 539а852 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, incr
easing the server configured values for client timeouts, or using the Connector/
J connection property 'autoReconnect=true' to avoid this problem.

Буду пробовать искать решения, но и от советов не откажусь!

UPD Не нашла ничего путного по теме, к сожалению. Я даже не понимаю, в чём, собственно, проблема: в только для чтения или в таймауте. В любом случае, к обеим ситуациям решения не нашла. Есть что-то близкое по теме здесь, но я не уверена.

В общем, очень рассчитываю на вашу помощь!