ahmedsuffian / aionxemu

Automatically exported from code.google.com/p/aionxemu
0 stars 0 forks source link

[BUG] Still getting Loginserver Window Errors rev 243M #253

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
YOU MUST BE USING AION X EMU FILES ONLY!! IF ANY MODIFICATIONS WERE DONE TO
THE FILES THAT WERE NOT INCLUDED WITH THE SVN, WE WILL NOT SUPPORT THOSE
ISSUES HERE!!

Core revision: Rev 243M

Bug description: Errors in Loginserver Window

What steps will reproduce the problem?: Run 243M I guess

What is the expected output?:

Please copy/paste errors below:

[WARN] 2011-04-06 12:42:07 - Failed to execute IU query com.mysql.jdbc.exception
s.jdbc4.CommunicationsException: The last packet successfully received from the
server was 37,436,803 milliseconds ago.  The last packet sent successfully to th
e server was 37,436,834 milliseconds ago. is longer than the server configured v
alue of 'wait_timeout'. You should consider either expiring and/or testing conne
ction validity before use in your application, increasing the server configured
values for client timeouts, or using the Connector/J connection property 'autoRe
connect=true' to avoid this problem.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet success
fully received from the server was 37,436,803 milliseconds ago.  The last packet
 sent successfully to the server was 37,436,834 milliseconds ago. is longer than
 the server configured value of 'wait_timeout'. You should consider either expir
ing and/or testing connection validity before use in your application, increasin
g the server configured values for client timeouts, or using the Connector/J con
nection 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 Sou
rce)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1
118)
        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.ja
va:2113)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)

        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(Delegatin
gPreparedStatement.java:172)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(Delegatin
gPreparedStatement.java:172)
        at mysql5.MySQL5AccountTimeDAO$1.handleInsertUpdate(MySQL5AccountTimeDAO
.java from JavaSourceFromFile:58)
        at com.aionemu.commons.database.DB.insertUpdate(DB.java:314)
        at com.aionemu.commons.database.DB.insertUpdate(DB.java:293)
        at mysql5.MySQL5AccountTimeDAO.updateAccountTime(MySQL5AccountTimeDAO.ja
va from JavaSourceFromFile:45)
        at loginserver.controller.AccountTimeController.updateOnLogout(AccountTi
meController.java:92)
        at loginserver.network.gameserver.clientpackets.CM_ACCOUNT_DISCONNECTED.
runImpl(CM_ACCOUNT_DISCONNECTED.java:68)
        at loginserver.network.gameserver.GsClientPacket.run(GsClientPacket.java
:54)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1081)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:574)
        at java.lang.Thread.run(Unknown Source)
Caused by: java.net.SocketException: Software caused connection abort: socket wr
ite 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:3302)
        ... 17 more
[WARN] 2011-04-06 12:42:07 - Failed to close DB connection java.sql.SQLException
: Already closed.
java.sql.SQLException: Already closed.
        at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.j
ava:114)
        at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.
close(PoolingDataSource.java:191)
        at com.aionemu.commons.database.DB.insertUpdate(DB.java:330)
        at com.aionemu.commons.database.DB.insertUpdate(DB.java:293)
        at mysql5.MySQL5AccountTimeDAO.updateAccountTime(MySQL5AccountTimeDAO.ja
va from JavaSourceFromFile:45)
        at loginserver.controller.AccountTimeController.updateOnLogout(AccountTi
meController.java:92)
        at loginserver.network.gameserver.clientpackets.CM_ACCOUNT_DISCONNECTED.
runImpl(CM_ACCOUNT_DISCONNECTED.java:68)
        at loginserver.network.gameserver.GsClientPacket.run(GsClientPacket.java
:54)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1081)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:574)
        at java.lang.Thread.run(Unknown Source)

Original issue reported on code.google.com by brentd67 on 6 Apr 2011 at 5:52

GoogleCodeExporter commented 9 years ago

Original comment by ZeroSign...@gmail.com on 7 Apr 2011 at 8:22