Server Network Error & login Delay

[Vinute]

Hello, I was running my server(1.5.1-Mr.Kller's Release) fine for few days but in a certain time login started to delay and after that it started saying (Server Network Error)


My table.xml is fairly fine my problem is with (Delivery) and that's because when I start the server everything goes fine except this.

=== [ START ] Delivery ===
Warning: table_charset should be set to UCS2
TRACE : RewardManager:: begin timme 2011 12 15 9
TRACE : RewardManager:: end timme 2012 1 16 1
TRACE : points[2900]->bonus[300]
TRACE : points[9900]->bonus[1200]
TRACE : points[19900]->bonus[2800]
TRACE : points[29900]->bonus[4500]
TRACE : RewardManager:: reward interval 86400 times 1
District id is 0info :
TcpManager OnAddSession
TRACE : gdeliveryd::Max player allowed is 6000
TRACE : OnAddSession sid=8
TRACE : Timer update: (0) Thu Jul 17 01:46:54 2014

gauthd: 17 Jul 2014 01:46:54,214  INFO GAuthServer:? - GAuthServer::OnAddSession com.goldhuman.IO.Protocol.Session@3479501a
TRACE : sysauction initialize: auction max=4, total sell item=48
TRACE : AutoTeamMan Init Successfully!!
TRACE : Server without connected to any central server
info : GameDBServer::OnAddSession, sid=8.
TRACE : CountryBattle Init Successfully!!
err : BillingAgent, duplicate item,id=16166,amount=500,timeout=0
err : BillingAgent, duplicate menuid,id=000000082000000002910000000001
err : BillingAgent, duplicate item,id=16024,amount=6000,timeout=0
err : BillingAgent, duplicate menuid,id=000000082000000002940000000001
err : BillingAgent, duplicate item,id=16019,amount=6000,timeout=0
err : BillingAgent, duplicate menuid,id=000000082000000002950000000001
TRACE : billing: menu loaded, menuids size=314, itemids size=314
TRACE : gdelivery::connect gfactionserver successfully.
TRACE : BattleManager: Sync battle faction to gfactiond.
info : logclienttcp: OnAddSession
info : logclient: OnAddSession
TRACE : ganticheatclient:: connect gacd successfully!
TRACE : gdelivery::connect to gauthd successfully.
TRACE : gfactionserver:: add link(or Delivery) 0 to map.
TRACE : Receive zoneid=1 from delivery
info : OnAddSession
info : OnAddSession
TRACE : DBAuctionList, size=0, handle=0
TRACE : DBFactionFortressLoad, size=0, handle=0
TRACE : DBStockLoad, size=0, handle=0
TRACE : DBForceLoad, count=0 update_time=1405544400.
TRACE : DBLoadGlobalControl, cme_open=0 cme_rate=0.
TRACE : info : OnAddSession
TRACE : TRACE : DBUniqueDataLoad, size=7, handle=0
DBPShopLoad, size=0, handle=0
DBRoleNameList, handle=-1
TRACE : DBBattleLoad, count=51.
TRACE : DBRoleNameList, size=0, handle=-1 total=0
TRACE : dbauctionlist: received. res->items.size()=0,res->handle.size()=0 retcode=0
TRACE : dbfactionfortressload: received. res->list.size()=0,res->handle.size()=0 retcode=0
TRACE : FactionFortressMan: Sync faction id to gfactiond.
TRACE : DBStockLoad: retcode=0, size=0, handle=0
TRACE : dbforceload: rpc return. retcode=0
TRACE : dbloadglobalcontrol: rpc return. retcode=0
TRACE : DBUniqueDataLoad: Rpc return. res->values.size()=7,res->handle.size()=0, retcode=0
TRACE : DBPShopLoad: Rpc return. res->shops.size()=0,res->handle.size()=0, retcode=0
TRACE : DBRoleNameList size=0 handle=-1 finish=1
TRACE : BattleManager: Sync map notice to GS.
TRACE : BattleManager: Sync battle faction to gfactiond.
TRACE : GetFactionDetail, fid=124.
TRACE : GetFactionDetail, rpc return. fid=124, retcode=0
gauthd: 17 Jul 2014 01:46:54,718  INFO GAuthServer:? - AnnounceZoneid3, clear all online records on zone 1
gauthd: 17 Jul 2014 01:46:54,806  INFO GAuthServer:? - AnnounceZoneid3, aid=1,zoneid=1,ip1=0.0.0.0,ip2=0.0.0.0,ip3=0.0.0.0
TRACE : StockStatus:: uptime=0,trade_price=0,order_volume=0,trade_volume=0,trade_amount=0,idpool=2
=== [ OK ] ===

Note the error and the first line that says Warning: table_charset should be set to UCS2....

I don't know what does that mean. If anyone can explain I will be very glad

Results after the error-Server Network Error- shows is (matrix passwd cache missing)

I did read alot of threads about this but none of them helped me.

Please post any suggestions it might do alot even if its silly.

I need to fix it as soon as possible.

Thanks for reading.


----------------------

Edit:-

It now no longer says Warning: table_charset should be set to UCS2 after I changed it in the game sys but it still sayserr : BillingAgent, duplicate item,id=16166,amount=500,timeout=0
err : BillingAgent, duplicate menuid,id=000000082000000002910000000001
err : BillingAgent, duplicate item,id=16024,amount=6000,timeout=0
err : BillingAgent, duplicate menuid,id=000000082000000002940000000001
err : BillingAgent, duplicate item,id=16019,amount=6000,timeout=0
err : BillingAgent, duplicate menuid,id=000000082000000002950000000001


After deleting those ids and menuids from the menuid file it now never says somthing wrong while running but the error still show.

And I guess this is where the problem is.

 

[Vinute]

When I restart the server. It works for minutes but then when the error shows this show first

gauthd: 17 Jul 2014 08:27:17,598 INFO GAuthServer:? - UseCashTimerTask: status=1,userid=2288,zoneid=1,sn=0,session=com.goldhuman.IO.Protocol.Session@26e2a66a
gauthd: 17 Jul 2014 08:27:17,600 INFO GAuthServer:? - GetAddCashSN Client: retcode=0,userid=2288,zoneid=1,sn=32
gauthd: 17 Jul 2014 08:27:17,602 INFO GAuthServer:? - UseCashTimerTask: status=3,userid=2288,zoneid=1,sn=31,session=com.goldhuman.IO.Protocol.Session@26e2a66a
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Result consisted of more than one row
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:534)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1021)
at com.mysql.jdbc.CallableStatement.execute(CallableStatement.java:878)
at application.procedure.handler.execute(handler.java:190)
at com.goldhuman.account.storage.useCash(Unknown Source)
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.Session$1.run(Unknown Source)
at java.lang.Thread.run(Thread.java:701)
gauthd: 17 Jul 2014 08:27:17,610 INFO GAuthServer:? - SendUseCash_Re: retcode=-1,userid=2288,zoneid=1
gauthd: 17 Jul 2014 08:27:17,611 INFO GAuthServer:? - AddCash_Re: retcode=0,userid=2288,zoneid=1,sn=31

 

[Caosfox]

i never had that error, and maybe what i say is totally wrong.. but i saw many time user id 2288, maybe something is wrong with that char?

 

[Vinute]

I don't think this is the problem. I will re-install ubuntu, I hope it never shows again though. Wiping the server alot will kill players.