11-10-2010, 09:35 PM
Установил AE последнюю сборку, все запускается без ошибок что логин сервер что гейм сервер. Пользователи входят нормально, спустя некоторое время (почти сутки) при логине возникает такая ошибка:
Логин сервер:
При входе клиент пишет - неверный логин или пароли, в логи пишутся ошибки, при повтороном вводе тех же самых данных все отлично логинется, ошибок потом больше нет. Учетная запись с таким именем есть.
Кто сталкивался - подскажите как решить
Логин сервер:
Ошибка логин сервера
[ERROR 2010-11-10 19:07:28] mysql5.MySQL5AccountDAO:69 - Can't select account with name: vitlav
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 70,019,918 milliseconds ago. The last packet sent successfully to the server was 70,019,918 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(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1118)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3321)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1940)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2275)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at mysql5.MySQL5AccountDAO.getAccount(MySQL5AccountDAO.java]:51)
at com.aionengine.loginserver.B.C.A(Unknown Source)
at com.aionengine.loginserver.B.C.A(Unknown Source)
at com.aionengine.loginserver.C.A.B.B.runImpl(Unknown Source)
at com.aionengine.loginserver.C.A.B.run(Unknown Source)
at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:210)
at java.lang.Thread.run(Thread.java:636)
Caused by: java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3302)
... 14 more
[ERROR 2010-11-10 19:07:28] com.aionemu.commons.database.DB:462 - Error while closing PreparedStatement
java.sql.SQLException: Already closed.
at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:114)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:191)
at com.aionemu.commons.database.DB.close(DB.java:459)
at mysql5.MySQL5AccountDAO.getAccount(MySQL5AccountDAO.java]:72)
at com.aionengine.loginserver.B.C.A(Unknown Source)
at com.aionengine.loginserver.B.C.A(Unknown Source)
at com.aionengine.loginserver.C.A.B.B.runImpl(Unknown Source)
at com.aionengine.loginserver.C.A.B.run(Unknown Source)
at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:210)
at java.lang.Thread.run(Thread.java:636)
[ERROR 2010-11-10 19:07:28] mysql5.MySQL5AccountDAO:151 - Can't inser account
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'vitlav' for key 'name'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2409)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2327)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2312)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at mysql5.MySQL5AccountDAO.insertAccount(MySQL5AccountDAO.java]:148)
at com.aionengine.loginserver.B.C.A(Unknown Source)
at com.aionengine.loginserver.B.C.A(Unknown Source)
at com.aionengine.loginserver.C.A.B.B.runImpl(Unknown Source)
at com.aionengine.loginserver.C.A.B.run(Unknown Source)
at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:210)
at java.lang.Thread.run(Thread.java:636)
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 70,019,918 milliseconds ago. The last packet sent successfully to the server was 70,019,918 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(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1118)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3321)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1940)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2275)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at mysql5.MySQL5AccountDAO.getAccount(MySQL5AccountDAO.java]:51)
at com.aionengine.loginserver.B.C.A(Unknown Source)
at com.aionengine.loginserver.B.C.A(Unknown Source)
at com.aionengine.loginserver.C.A.B.B.runImpl(Unknown Source)
at com.aionengine.loginserver.C.A.B.run(Unknown Source)
at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:210)
at java.lang.Thread.run(Thread.java:636)
Caused by: java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3302)
... 14 more
[ERROR 2010-11-10 19:07:28] com.aionemu.commons.database.DB:462 - Error while closing PreparedStatement
java.sql.SQLException: Already closed.
at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:114)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:191)
at com.aionemu.commons.database.DB.close(DB.java:459)
at mysql5.MySQL5AccountDAO.getAccount(MySQL5AccountDAO.java]:72)
at com.aionengine.loginserver.B.C.A(Unknown Source)
at com.aionengine.loginserver.B.C.A(Unknown Source)
at com.aionengine.loginserver.C.A.B.B.runImpl(Unknown Source)
at com.aionengine.loginserver.C.A.B.run(Unknown Source)
at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:210)
at java.lang.Thread.run(Thread.java:636)
[ERROR 2010-11-10 19:07:28] mysql5.MySQL5AccountDAO:151 - Can't inser account
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'vitlav' for key 'name'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2409)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2327)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2312)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at mysql5.MySQL5AccountDAO.insertAccount(MySQL5AccountDAO.java]:148)
at com.aionengine.loginserver.B.C.A(Unknown Source)
at com.aionengine.loginserver.B.C.A(Unknown Source)
at com.aionengine.loginserver.C.A.B.B.runImpl(Unknown Source)
at com.aionengine.loginserver.C.A.B.run(Unknown Source)
at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:210)
at java.lang.Thread.run(Thread.java:636)
При входе клиент пишет - неверный логин или пароли, в логи пишутся ошибки, при повтороном вводе тех же самых данных все отлично логинется, ошибок потом больше нет. Учетная запись с таким именем есть.
Кто сталкивался - подскажите как решить
