Please Help me

[dotta]

I have a problem with my server.
all user can log in 24 hours without any problem, but after 24 hours the login server goes down everytime! i dont know where is the problem! maybe someone can help me!

sry for my bad english

Server info

im use pwi server 1.4.5 v 69

MFG Dotta

Here is my error log I think its a problem with Java

6 INFO GAuthServer:? - UseCashTimerTask: status=1,userid=112,zoneid=1,sn=0,session=com.goldhuman.IO.Protocol.Session@44050988
gauthd: 03 Sep 2013 13:55:53,386 INFO GAuthServer:? - UseCashTimerTask: status=1,userid=528,zoneid=1,sn=0,session=com.goldhuman.IO.Protocol.Session@44050988
gauthd: 03 Sep 2013 13:55:53,386 INFO GAuthServer:? - UseCashTimerTask: status=1,userid=944,zoneid=1,sn=0,session=com.goldhuman.IO.Protocol.Session@44050988
gauthd: 03 Sep 2013 13:55:53,387 INFO GAuthServer:? - UseCashTimerTask: status=1,userid=992,zoneid=1,sn=0,session=com.goldhuman.IO.Protocol.Session@44050988
gauthd: 03 Sep 2013 13:55:53,388 INFO GAuthServer:? - GetAddCashSN Client: retcode=0,userid=112,zoneid=1,sn=20
Prepare procedure call:{call usecash(?,?,?,?,?,?,?,?)}
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Result consisted of more than one row
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:882)
at com.mysql.jdbc.CallableStatement.execute(CallableStatement.java:759)
at application.procedure.handler.execute(handler.java:197)
at com.goldhuman.account.storage.useCash(storage.java:963)
at protocol.GetAddCashSN.Client(Unknown Source)
at com.goldhuman.IO.Protocol.Rpc.Process(Unknown Source)
at com.goldhuman.IO.Protocol.Task.run(Unknown Source)
at com.goldhuman.IO.Protocol.Task.Dispatch(Unknown Source)
at com.goldhuman.IO.Protocol.Session.OnRecv(Unknown Source)
at com.goldhuman.IO.NetIO.StreamIO.UpdateEvent(Unknown Source)
at com.goldhuman.IO.PollIO.Poll(Unknown Source)
at com.goldhuman.IO.Task.run(Unknown Source)
at com.goldhuman.Common.ThreadPool.run(Unknown Source)
at java.lang.Thread.run(Thread.java:679)
gauthd: 03 Sep 2013 13:55:53,400 INFO GAuthServer:? - SendUseCash_Re: retcode=-1,userid=112,zoneid=1
gauthd: 03 Sep 2013 13:55:53,401 INFO GAuthServer:? - GetAddCashSN Client: retcode=0,userid=528,zoneid=1,sn=17
Prepare procedure call:{call usecash(?,?,?,?,?,?,?,?)}
gauthd: 03 Sep 2013 13:55:53,401 INFO GAuthServer:? - UseCashTimerTask: status=3,userid=112,zoneid=1,sn=20,session=com.goldhuman.IO.Protocol.Session@44050988
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after statement closed.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888)
at com.mysql.jdbc.Statement.checkClosed(Statement.java:385)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1107)
at com.mysql.jdbc.DatabaseMetaData.getCallStmtParameterTypes(DatabaseMetaData.java:1607)
at com.mysql.jdbc.DatabaseMetaData.getProcedureColumns(DatabaseMetaData.java:4034)
at com.mysql.jdbc.CallableStatement.determineParameterTypes(CallableStatement.java:709)
at com.mysql.jdbc.CallableStatement.<init>(CallableStatement.java:513)
at com.mysql.jdbc.Connection.parseCallableStatement(Connection.java:4583)
at com.mysql.jdbc.Connection.prepareCall(Connection.java:4657)
at com.mysql.jdbc.Connection.prepareCall(Connection.java:4631)
at application.procedure.handler.execute(handler.java:189)
at com.goldhuman.account.storage.useCash(storage.java:963)
at protocol.GetAddCashSN.Client(Unknown Source)
at com.goldhuman.IO.Protocol.Rpc.Process(Unknown Source)
at com.goldhuman.IO.Protocol.Task.run(Unknown Source)
at com.goldhuman.IO.Protocol.Task.Dispatch(Unknown Source)
at com.goldhuman.IO.Protocol.Session.OnRecv(Unknown Source)
at com.goldhuman.IO.NetIO.StreamIO.UpdateEvent(Unknown Source)
at com.goldhuman.IO.PollIO.Poll(Unknown Source)
at com.goldhuman.IO.Task.run(Unknown Source)
at com.goldhuman.Common.ThreadPool.run(Unknown Source)
at java.lang.Thread.run(Thread.java:679)
gauthd: 03 Sep 2013 13:55:53,406 INFO GAuthServer:? - SendUseCash_Re: retcode=-1,userid=528,zoneid=1
gauthd: 03 Sep 2013 13:55:53,407 INFO GAuthServer:? - GetAddCashSN Client: retcode=0,userid=944,zoneid=1,sn=6
Prepare procedure call:{call usecash(?,?,?,?,?,?,?,?)}
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after statement closed.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888)
at com.mysql.jdbc.Statement.checkClosed(Statement.java:385)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1107)
at com.mysql.jdbc.DatabaseMetaData.getCallStmtParameterTypes(DatabaseMetaData.java:1607)
at com.mysql.jdbc.DatabaseMetaData.getProcedureColumns(DatabaseMetaData.java:4034)
at com.mysql.jdbc.CallableStatement.determineParameterTypes(CallableStatement.java:709)
at com.mysql.jdbc.CallableStatement.<init>(CallableStatement.java:513)
at com.mysql.jdbc.Connection.parseCallableStatement(Connection.java:4583)
at com.mysql.jdbc.Connection.prepareCall(Connection.java:4657)
at com.mysql.jdbc.Connection.prepareCall(Connection.java:4631)
at application.procedure.handler.execute(handler.java:189)
at com.goldhuman.account.storage.useCash(storage.java:963)
at protocol.GetAddCashSN.Client(Unknown Source)
at com.goldhuman.IO.Protocol.Rpc.Process(Unknown Source)
at com.goldhuman.IO.Protocol.Task.run(Unknown Source)
at com.goldhuman.IO.Protocol.Task.Dispatch(Unknown Source)
at com.goldhuman.IO.Protocol.Session.OnRecv(Unknown Source)
at com.goldhuman.IO.NetIO.StreamIO.UpdateEvent(Unknown Source)
at com.goldhuman.IO.PollIO.Poll(Unknown Source)
at com.goldhuman.IO.Task.run(Unknown Source)
at com.goldhuman.Common.ThreadPool.run(Unknown Source)
at java.lang.Thread.run(Thread.java:679)
gauthd: 03 Sep 2013 13:55:53,409 INFO GAuthServer:? - SendUseCash_Re: retcode=-1,userid=944,zoneid=1
gauthd: 03 Sep 2013 13:55:53,409 INFO GAuthServer:? - GetAddCashSN Client: retcode=0,userid=992,zoneid=1,sn=2

[MentaL]

[Psytrac]

"Prepare procedure call:{call usecash(?,?,?,?,?,?,?,?)}
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after statement closed."

you have a bad java script running

[dotta]

please can yo say me how i can fixed?

[Psytrac]

nope, told you what's wrong, go find it

[dotta]

it may be that java is broken?

Please say me wath is wrong i have java updatet i dont no what its the problem

[rusran]

I think authd protocols have errors. //Prepare procedure call:{call usecash(?,?,?,?,?,?,?,?)}
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException// 'usecash' procedure contains syntax errors. Replace your auth daemon to fix the problem

[dotta]

thank you have fixet