search

ahmedsuffian / aionxemu

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

Loginserver window #192

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 222

Bug description: Since upgrading to 222 I am getting the following errors in my 
Loginserver window

[WARN] 2011-03-27 12:53:21 - Failed to execute IU query com.mysql.jdbc.exception
s.jdbc4.CommunicationsException: The last packet successfully received from the
server was 46,463,031 milliseconds ago.  The last packet sent successfully to th
e server was 46,463,093 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 46,463,031 milliseconds ago.  The last packet
 sent successfully to the server was 46,463,093 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-03-27 12:53:21 - 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)
[INFO] 2011-03-27 12:53:21 - recived packet: [C] 0x03 CM_ACCOUNT_DISCONNECTED

What steps will reproduce the problem?: Should see them in your Loginserver 
window if your running rev 222

What is the expected output?:

Please copy/paste errors below:

Original issue reported on code.google.com by brentd67 on 27 Mar 2011 at 11:31

GoogleCodeExporter commented 9 years ago 
Plz update your server to rev226 without any changes.

Original comment by pziko...@gmail.com on 28 Mar 2011 at 12:49

GoogleCodeExporter commented 9 years ago 
The MySQL Connection also dropped.

In default.config add the autoReconnect parameter to the DB URL connection 
string:
# JDBC database URL
database.url = 
jdbc:mysql://localhost:3306/aionx_gs?useUnicode=true&characterEncoding=UTF-8&aut
oReconnect=true

Original comment by ZeroSign...@gmail.com on 28 Mar 2011 at 1:29

GoogleCodeExporter commented 9 years ago 
Updated to rev 226 and still getting the following errors in my windows when I 
login a character:

Loginserver Window:

[ERROR] 2011-03-28 22:08:25 - Can't select account with name: necromentia
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet success
fully received from the server was 35,106,440 milliseconds ago.  The last packet
 sent successfully to the server was 35,106,440 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.executeQuery(PreparedStatement.java:
2275)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:96)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:96)
        at mysql5.MySQL5AccountDAO.getAccount(MySQL5AccountDAO.java from JavaSou
rceFromFile:51)
        at loginserver.controller.AccountController.loadAccount(AccountControlle
r.java:259)
        at loginserver.controller.AccountController.login(AccountController.java
:159)
        at loginserver.network.aion.clientpackets.CM_LOGIN.runImpl(CM_LOGIN.java
:97)
        at loginserver.network.aion.AionClientPacket.run(AionClientPacket.java:5
4)
        at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(P
acketProcessor.java:210)
        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)
        ... 14 more
[ERROR] 2011-03-28 22:08:25 - Error while closing PreparedStatement
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.close(DB.java:459)
        at mysql5.MySQL5AccountDAO.getAccount(MySQL5AccountDAO.java from JavaSou
rceFromFile:72)
        at loginserver.controller.AccountController.loadAccount(AccountControlle
r.java:259)
        at loginserver.controller.AccountController.login(AccountController.java
:159)
        at loginserver.network.aion.clientpackets.CM_LOGIN.runImpl(CM_LOGIN.java
:97)
        at loginserver.network.aion.AionClientPacket.run(AionClientPacket.java:5
4)
        at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(P
acketProcessor.java:210)
        at java.lang.Thread.run(Unknown Source)
[ERROR] 2011-03-28 22:08:26 - Can't inser account
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Dupl
icate entry 'necromentia' for key 'name'
        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.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.ja
va: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(Del
egatingPreparedStatement.java:105)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Del
egatingPreparedStatement.java:105)
        at mysql5.MySQL5AccountDAO.insertAccount(MySQL5AccountDAO.java from Java
SourceFromFile:148)
        at loginserver.controller.AccountController.createAccount(AccountControl
ler.java:283)
        at loginserver.controller.AccountController.login(AccountController.java
:163)
        at loginserver.network.aion.clientpackets.CM_LOGIN.runImpl(CM_LOGIN.java
:97)
        at loginserver.network.aion.AionClientPacket.run(AionClientPacket.java:5
4)
        at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(P
acketProcessor.java:210)
        at java.lang.Thread.run(Unknown Source)
[INFO] 2011-03-28 22:08:26 - sending packet: [S] 0x01 SM_LOGIN_FAIL and closing
connection after that.
[INFO] 2011-03-28 22:08:30 - connection from: 208.xx.xxx.xxx
[INFO] 2011-03-28 22:08:30 - recived packet: [C] 0x07 CM_AUTH_GG
[INFO] 2011-03-28 22:08:30 - recived packet: [C] 0x0B CM_LOGIN
[INFO] 2011-03-28 22:08:30 - recived packet: [C] 0x05 CM_SERVER_LIST
[INFO] 2011-03-28 22:08:30 - sending packet: [S] 0x06 SM_GS_REQUEST_CHARACTER_CO
UNT
[INFO] 2011-03-28 22:08:30 - recived packet: [C] 0x07 CM_GS_CHARACTER_COUNT
[INFO] 2011-03-28 22:08:31 - recived packet: [C] 0x02 CM_PLAY
[INFO] 2011-03-28 22:08:32 - recived packet: [C] 0x01 CM_ACCOUNT_AUTH
[INFO] 2011-03-28 22:08:32 - sending packet: [S] 0x01 SM_ACCOUNT_AUTH_RESPONSE

Gameserver Window:

[INFO] 2011-03-28 22:08:32 - Account authed: 1 = necromentia
[WARN] 2011-03-28 22:08:32 - Error executing select query com.mysql.jdbc.excepti
ons.jdbc4.CommunicationsException: The last packet successfully received from th
e server was 35,038,393 milliseconds ago.  The last packet sent successfully to
the server was 35,038,393 milliseconds ago. is longer than the server configured
 value of 'wait_timeout'. You should consider either expiring and/or testing con
nection validity before use in your application, increasing the server configure
d values for client timeouts, or using the Connector/J connection property 'auto
Reconnect=true' to avoid this problem.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet success
fully received from the server was 35,038,393 milliseconds ago.  The last packet
 sent successfully to the server was 35,038,393 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.executeQuery(PreparedStatement.java:
2275)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:96)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:96)
        at com.aionemu.commons.database.DB.select(DB.java:184)
        at com.aionemu.commons.database.DB.select(DB.java:163)
        at mysql5.MySQL5LegionDAO.loadLegion(MySQL5LegionDAO.java from JavaSourc
eFromFile:194)
        at gameserver.services.LegionService.getLegion(LegionService.java:307)
        at mysql5.MySQL5LegionMemberDAO$3.handleRead(MySQL5LegionMemberDAO.java
from JavaSourceFromFile:144)
        at com.aionemu.commons.database.DB.select(DB.java:185)
        at com.aionemu.commons.database.DB.select(DB.java:163)
        at mysql5.MySQL5LegionMemberDAO.loadLegionMember(MySQL5LegionMemberDAO.j
ava from JavaSourceFromFile:129)
        at gameserver.services.AccountService.loadAccount(AccountService.java:12
9)
        at gameserver.services.AccountService.getAccount(AccountService.java:68)

        at gameserver.network.loginserver.LoginServer.accountAuthenticationRespo
nse(LoginServer.java:217)
        at gameserver.network.loginserver.clientpackets.CM_ACOUNT_AUTH_RESPONSE.
runImpl(CM_ACOUNT_AUTH_RESPONSE.java:89)
        at gameserver.network.loginserver.LsClientPacket.run(LsClientPacket.java
:46)
        at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWr
apper.java:54)
        at com.aionemu.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrappe
r.java:39)
        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 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)
        ... 25 more
[INFO] 2011-03-28 22:08:38 - Player logged in: Necromentia Account: necromentia
[INFO] 2011-03-28 22:08:38 - Write 0 ip: 208.xx.xxx.xxx

Original comment by brentd67 on 29 Mar 2011 at 2:14

GoogleCodeExporter commented 9 years ago 
I have updated to 231, ran both patches offered for fixes and I am now getting 
something in both the LS and GS windows, here it is:

Loginserver Window:

[ERROR] 2011-03-31 20:02:28 - Can't select account with name: necromentia
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet success
fully received from the server was 30,123,057 milliseconds ago.  The last packet
 sent successfully to the server was 30,123,057 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.executeQuery(PreparedStatement.java:
2275)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:96)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:96)
        at mysql5.MySQL5AccountDAO.getAccount(MySQL5AccountDAO.java from JavaSou
rceFromFile:51)
        at loginserver.controller.AccountController.loadAccount(AccountControlle
r.java:259)
        at loginserver.controller.AccountController.login(AccountController.java
:159)
        at loginserver.network.aion.clientpackets.CM_LOGIN.runImpl(CM_LOGIN.java
:97)
        at loginserver.network.aion.AionClientPacket.run(AionClientPacket.java:5
4)
        at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(P
acketProcessor.java:210)
        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)
        ... 14 more
[ERROR] 2011-03-31 20:02:28 - Error while closing PreparedStatement
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.close(DB.java:459)
        at mysql5.MySQL5AccountDAO.getAccount(MySQL5AccountDAO.java from JavaSou
rceFromFile:72)
        at loginserver.controller.AccountController.loadAccount(AccountControlle
r.java:259)
        at loginserver.controller.AccountController.login(AccountController.java
:159)
        at loginserver.network.aion.clientpackets.CM_LOGIN.runImpl(CM_LOGIN.java
:97)
        at loginserver.network.aion.AionClientPacket.run(AionClientPacket.java:5
4)
        at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(P
acketProcessor.java:210)
        at java.lang.Thread.run(Unknown Source)
[ERROR] 2011-03-31 20:02:28 - Can't inser account
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Dupl
icate entry 'necromentia' for key 'name'
        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.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.ja
va: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(Del
egatingPreparedStatement.java:105)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Del
egatingPreparedStatement.java:105)
        at mysql5.MySQL5AccountDAO.insertAccount(MySQL5AccountDAO.java from Java
SourceFromFile:148)
        at loginserver.controller.AccountController.createAccount(AccountControl
ler.java:283)
        at loginserver.controller.AccountController.login(AccountController.java
:163)
        at loginserver.network.aion.clientpackets.CM_LOGIN.runImpl(CM_LOGIN.java
:97)
        at loginserver.network.aion.AionClientPacket.run(AionClientPacket.java:5
4)
        at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(P
acketProcessor.java:210)
        at java.lang.Thread.run(Unknown Source)
[INFO] 2011-03-31 20:02:28 - sending packet: [S] 0x01 SM_LOGIN_FAIL and closing
connection after that.
[INFO] 2011-03-31 20:02:33 - connection from: 208.xx.xxx.xxx
[INFO] 2011-03-31 20:02:33 - recived packet: [C] 0x07 CM_AUTH_GG
[INFO] 2011-03-31 20:02:33 - recived packet: [C] 0x0B CM_LOGIN
[INFO] 2011-03-31 20:02:33 - recived packet: [C] 0x05 CM_SERVER_LIST
[INFO] 2011-03-31 20:02:33 - sending packet: [S] 0x06 SM_GS_REQUEST_CHARACTER_CO
UNT
[INFO] 2011-03-31 20:02:33 - recived packet: [C] 0x07 CM_GS_CHARACTER_COUNT
[INFO] 2011-03-31 20:02:34 - recived packet: [C] 0x02 CM_PLAY
[INFO] 2011-03-31 20:02:34 - recived packet: [C] 0x01 CM_ACCOUNT_AUTH
[INFO] 2011-03-31 20:02:34 - sending packet: [S] 0x01 SM_ACCOUNT_AUTH_RESPONSE

Gamserver Window:

[INFO] 2011-03-31 20:02:33 - recived packet: [C] 0x06 CM_LS_REQUEST_CHARACTER_CO
UNT
[INFO] 2011-03-31 20:02:33 - sending packet: [S] 0x07 SM_LS_CHARACTER_COUNT
[INFO] 2011-03-31 20:02:34 - sending packet: [S] 0x01 SM_ACCOUNT_AUTH
[INFO] 2011-03-31 20:02:34 - recived packet: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE
[INFO] 2011-03-31 20:02:34 - Account authed: 1 = necromentia
[WARN] 2011-03-31 20:02:34 - Error executing select query com.mysql.jdbc.excepti
ons.jdbc4.CommunicationsException: The last packet successfully received from th
e server was 30,056,174 milliseconds ago.  The last packet sent successfully to
the server was 30,056,174 milliseconds ago. is longer than the server configured
 value of 'wait_timeout'. You should consider either expiring and/or testing con
nection validity before use in your application, increasing the server configure
d values for client timeouts, or using the Connector/J connection property 'auto
Reconnect=true' to avoid this problem.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet success
fully received from the server was 30,056,174 milliseconds ago.  The last packet
 sent successfully to the server was 30,056,174 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.executeQuery(PreparedStatement.java:
2275)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:96)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:96)
        at com.aionemu.commons.database.DB.select(DB.java:184)
        at com.aionemu.commons.database.DB.select(DB.java:163)
        at mysql5.MySQL5LegionDAO.loadLegion(MySQL5LegionDAO.java from JavaSourc
eFromFile:194)
        at gameserver.services.LegionService.getLegion(LegionService.java:307)
        at mysql5.MySQL5LegionMemberDAO$3.handleRead(MySQL5LegionMemberDAO.java
from JavaSourceFromFile:144)
        at com.aionemu.commons.database.DB.select(DB.java:185)
        at com.aionemu.commons.database.DB.select(DB.java:163)
        at mysql5.MySQL5LegionMemberDAO.loadLegionMember(MySQL5LegionMemberDAO.j
ava from JavaSourceFromFile:129)
        at gameserver.services.AccountService.loadAccount(AccountService.java:12
9)
        at gameserver.services.AccountService.getAccount(AccountService.java:68)

        at gameserver.network.loginserver.LoginServer.accountAuthenticationRespo
nse(LoginServer.java:217)
        at gameserver.network.loginserver.clientpackets.CM_ACOUNT_AUTH_RESPONSE.
runImpl(CM_ACOUNT_AUTH_RESPONSE.java:89)
        at gameserver.network.loginserver.LsClientPacket.run(LsClientPacket.java
:46)
        at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWr
apper.java:54)
        at com.aionemu.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrappe
r.java:39)
        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 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)
        ... 25 more
[INFO] 2011-03-31 20:02:38 - Player logged in: Necromentia Account: necromentia
[INFO] 2011-03-31 20:11:06 - Starting analysis of world players at 1301616666567

Original comment by brentd67 on 1 Apr 2011 at 12:19

GoogleCodeExporter commented 9 years ago 
This has been a an issue for awhile now, any updates on this one?

Original comment by brentd67 on 6 Apr 2011 at 5:57

GoogleCodeExporter commented 9 years ago 
For Login Server:

In default.config add the autoReconnect parameter to the DB URL connection 
string:
# JDBC database URL
database.url = 
jdbc:mysql://localhost:3306/aionx_ls?useUnicode=true&characterEncoding=UTF-8&aut
oReconnect=true

Original comment by ZeroSign...@gmail.com on 18 Apr 2011 at 12:05

GoogleCodeExporter commented 9 years ago

Original comment by ZeroSign...@gmail.com on 18 Apr 2011 at 12:05

GoogleCodeExporter commented 9 years ago 
I have added the auto reconnect to all configs every time I update, that is not 
helping to fix this issue. By the way what does Won't Fix mean?

Original comment by brentd67 on 18 Apr 2011 at 4:27

GoogleCodeExporter commented 9 years ago 
Hello,

The autoReconnect parameter was added to both configs in Revision 259. I 
suggest you take a look at your Database Logs to find out what is causing the 
exact error as it's quite rare that users experience this issue and we believe 
its more of a system configuration issue, than a software one.
If the MySQL Database Logs have some error like a deadlock detection or 
something it may give us more info to work on it if there is in fact an issue 
with the software.

I took a further look at the issue, and it seems the errors have occurred due 
to the database connection dropout. Granted the Login Server and Game Server 
may need to more gracefully exit out when this occurs, however even if that is 
fixed it still wont help your issue of the dropout in the first place, and I 
suggest checking the MySQL Logs for a clue as to why the connection is dropping.

Original comment by ZeroSign...@gmail.com on 19 Apr 2011 at 9:41

GoogleCodeExporter commented 9 years ago 
I am attaching the mysql_error.log from C:\xampp\mysql\data, see attachment. 
Nothing I can see that jumps out at me.

Original comment by brentd67 on 20 Apr 2011 at 4:17

Attachments: