search

ahmedsuffian / aionxemu

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

Bug log gameserver #151

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: r201

Bug description:

The error appears in the log server and gameserver, but access to the game 
continues normally, what motive?

Please copy/paste errors below:

[WARN 2011-03-21 16:08:35] com.aionemu.commons.database.DB:189 - Error 
executing select query com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: 
The last packet successfully received from the server was 50,900,654 
milliseconds ago.  The last packet sent successfully to the server was 
50,900,677 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.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet 
successfully received from the server was 50,900,654 milliseconds ago.  The 
last packet sent successfully to the server was 50,900,677 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:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    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 com.aionemu.commons.database.DB.select(DB.java:184)
    at com.aionemu.commons.database.DB.select(DB.java:163)
    at mysql5.MySQL5MailDAO.loadMailboxItems(MySQL5MailDAO.java from JavaSourceFromFile:99)
    at mysql5.MySQL5MailDAO.access$000(MySQL5MailDAO.java from JavaSourceFromFile:47)
    at mysql5.MySQL5MailDAO$1.handleRead(MySQL5MailDAO.java from JavaSourceFromFile:63)
    at com.aionemu.commons.database.DB.select(DB.java:185)
    at com.aionemu.commons.database.DB.select(DB.java:163)
    at mysql5.MySQL5MailDAO.loadPlayerMailbox(MySQL5MailDAO.java from JavaSourceFromFile:55)
    at gameserver.services.MailService$MailLoadTask.run(MailService.java:487)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:54)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrapper.java:39)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
    at java.util.concurrent.FutureTask.run(FutureTask.java:138)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:206)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    at java.lang.Thread.run(Thread.java:662)
Caused by: java.net.SocketException: Broken pipe
    at java.net.SocketOutputStream.socketWrite0(Native Method)
    at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
    at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
    at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
    at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3302)
    ... 26 more

[WARN 2011-03-21 16:08:35] com.aionemu.commons.database.DB:202 - Failed to 
close DB connection java.sql.SQLException: Already closed.
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.select(DB.java:197)
    at com.aionemu.commons.database.DB.select(DB.java:163)
    at mysql5.MySQL5MailDAO.loadMailboxItems(MySQL5MailDAO.java from JavaSourceFromFile:99)
    at mysql5.MySQL5MailDAO.access$000(MySQL5MailDAO.java from JavaSourceFromFile:47)
    at mysql5.MySQL5MailDAO$1.handleRead(MySQL5MailDAO.java from JavaSourceFromFile:63)
    at com.aionemu.commons.database.DB.select(DB.java:185)
    at com.aionemu.commons.database.DB.select(DB.java:163)
    at mysql5.MySQL5MailDAO.loadPlayerMailbox(MySQL5MailDAO.java from JavaSourceFromFile:55)
    at gameserver.services.MailService$MailLoadTask.run(MailService.java:487)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:54)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrapper.java:39)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
    at java.util.concurrent.FutureTask.run(FutureTask.java:138)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:206)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    at java.lang.Thread.run(Thread.java:662)

Original issue reported on code.google.com by lotuspw....@gmail.com on 22 Mar 2011 at 12:42

GoogleCodeExporter commented 9 years ago 
In default.config use:
database.url = 
jdbc:mysql://localhost:3306/aionx_gs?useUnicode=true&characterEncoding=UTF-8&aut
oReconnect=true

Original comment by ZeroSign...@gmail.com on 22 Mar 2011 at 2:29

GoogleCodeExporter commented 9 years ago 
Very thx

Original comment by aionlo...@gmail.com on 22 Mar 2011 at 3:28

GoogleCodeExporter commented 9 years ago 
Issue 256 has been merged into this issue.

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

GoogleCodeExporter commented 9 years ago 
Issue 253 has been merged into this issue.

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

GoogleCodeExporter commented 9 years ago 
You must append "&autoReconnect=true" to the database.url string for both the 
LoginServer and the GameServer is your having an issue with both.

We can't tell you why the connection is dropping as it's your systems 
configuration that is the issue, all we know is that it's not a part of 
expected behaviour.

Original comment by ZeroSign...@gmail.com on 12 Apr 2011 at 3:59

GoogleCodeExporter commented 9 years ago 
Committed Revision 259.

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