EP6 server suddently crashes after awhile

[Psycnosis]

Running ep6 server with 5.4 ps_game.exe and files released by JuuF.

Server runs fine sometimes for hours sometimes for minutes then crashes, only the game server that crashes and goes into pause position on the server Config.

I cant seem to find out what the problem is here are the logs.

 Spoiler

2016-04-13 10:46:28 PS_GAME__system log start (Game01) [GERMANY]

2016-04-13 10:46:28 RandomOption Error : ItemID=17217, byServer=4, Wis=0

2016-04-13 10:46:28 RandomOption Error : ItemID=18217, byServer=4, Wis=0

2016-04-13 10:46:28 RandomOption Error : ItemID=20217, byServer=4, Wis=0

2016-04-13 10:46:28 RandomOption Error : ItemID=21195, byServer=4, Wis=0

2016-04-13 10:46:28 RandomOption Error : ItemID=21217, byServer=4, Wis=0

2016-04-13 10:46:28 RandomOption Error : ItemID=35054, byServer=3, Wis=0

2016-04-13 10:46:28 RandomOption Error : ItemID=60229, byServer=3, Wis=0

2016-04-13 10:46:28 RandomOption Error : ItemID=120020, byServer=3, Wis=0

2016-04-13 10:46:33 <Console input> /nprotectoff

2016-04-13 10:46:33 <Console output> cmd NProtect off ok

2016-04-13 10:47:29 connect mgr 1292

2016-04-13 10:47:29 Server Version : 0

2016-04-13 10:47:29 connect dbagent 1296

2016-04-13 10:47:29 connect gamelog 1308

2016-04-13 10:47:35 Market End -----------------------

2016-04-13 10:47:36 Start CWorldSendThread=5064

Module list:

C:\ShaiyaServer\SERVER\PSM_Client\Bin\ps_game.exe, loaded at 0x00400000 - 11/09/14 17:10:08

2016-04-13 11:05:47 1 1 SWorker::Run():m_iocp.GetStatus() 121 (2736)

2016-04-13 11:05:47 discon client: ( 5, 121) T=000:05:00:000, RC=69,RCS=0, RB=1074,RBS=3, SC=481,SCS=1, SB=63362,SBS=190

2016-04-13 11:10:21 1 1 SWorker::Run():m_iocp.GetStatus() 121 (2708)

2016-04-13 11:10:21 discon client: ( 5, 121) T=000:11:00:000, RC=532,RCS=0, RB=8521,RBS=12, SC=3495,SCS=5, SB=138196,SBS=209

2016-04-13 11:12:22 ## CheckRecv 104, 415824, 4, 80

2016-04-13 11:12:22 discon client: ( 16, 1236) T=000:02:00:000, RC=116,RCS=0, RB=1566,RBS=10, SC=539,SCS=3, SB=62608,SBS=437

2016-04-13 11:18:11 1 1 SWorker::Run():m_iocp.GetStatus() 121 (2592)

2016-04-13 11:18:11 discon client: ( 5, 121) T=000:24:00:000, RC=777,RCS=0, RB=10465,RBS=7, SC=8442,SCS=5, SB=226397,SBS=154

2016-04-13 11:18:12 1 1 SWorker::Run():m_iocp.GetStatus() 121 (2776)

2016-04-13 11:18:12 discon client: ( 5, 121) T=000:12:00:000, RC=368,RCS=0, RB=3779,RBS=4, SC=1276,SCS=1, SB=151945,SBS=197

2016-04-13 11:37:26 1 1 SWorker::Run():m_iocp.GetStatus() 121 (2768)

2016-04-13 11:37:26 discon client: ( 5, 121) T=000:07:00:000, RC=127,RCS=0, RB=1880,RBS=4, SC=2026,SCS=4, SB=108076,SBS=234

2016-04-13 11:37:58 1 1 SWorker::Run():m_iocp.GetStatus() 121 (2844)

2016-04-13 11:37:58 discon client: ( 5, 121) T=000:06:00:000, RC=99,RCS=0, RB=1283,RBS=3, SC=1385,SCS=3, SB=86289,SBS=235

2016-04-13 11:47:02 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3040)

2016-04-13 11:47:02 discon client: ( 5, 121) T=000:04:00:000, RC=207,RCS=0, RB=2971,RBS=10, SC=2202,SCS=7, SB=112923,SBS=388

2016-04-13 11:50:08 1 1 SWorker::Run():m_iocp.GetStatus() 121 (2952)

2016-04-13 11:50:08 discon client: ( 5, 121) T=000:06:00:000, RC=349,RCS=0, RB=3396,RBS=8, SC=3097,SCS=7, SB=123350,SBS=307

2016-04-13 11:50:19 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3080)

2016-04-13 11:50:19 discon client: ( 5, 121) T=000:05:00:000, RC=193,RCS=0, RB=2746,RBS=8, SC=2761,SCS=8, SB=120462,SBS=352

2016-04-13 12:00:08 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3040)

2016-04-13 12:00:08 discon client: ( 5, 121) T=000:05:00:000, RC=203,RCS=0, RB=2723,RBS=8, SC=2925,SCS=9, SB=122183,SBS=375

2016-04-13 12:00:19 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3064)

2016-04-13 12:00:19 discon client: ( 5, 121) T=000:15:00:000, RC=303,RCS=0, RB=4779,RBS=5, SC=4609,SCS=4, SB=159136,SBS=167

2016-04-13 12:00:25 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3032)

2016-04-13 12:00:25 discon client: ( 5, 121) T=000:18:00:000, RC=1126,RCS=1, RB=14014,RBS=12, SC=12071,SCS=10, SB=303967,SBS=272

2016-04-13 12:01:51 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3124)

2016-04-13 12:01:51 discon client: ( 5, 121) T=000:07:00:000, RC=163,RCS=0, RB=2103,RBS=4, SC=1843,SCS=4, SB=95812,SBS=225

2016-04-13 12:02:32 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3132)

2016-04-13 12:02:32 discon client: ( 5, 121) T=000:04:00:000, RC=149,RCS=0, RB=2688,RBS=10, SC=2337,SCS=9, SB=108134,SBS=425

2016-04-13 12:05:34 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3092)

2016-04-13 12:05:34 discon client: ( 5, 121) T=000:10:00:000, RC=286,RCS=0, RB=4921,RBS=7, SC=2700,SCS=4, SB=159113,SBS=251

2016-04-13 12:09:31 1 1 SWorker::Run():m_iocp.GetStatus() 121 (2784)

2016-04-13 12:09:31 discon client: ( 5, 121) T=000:42:00:000, RC=1346,RCS=0, RB=20148,RBS=7, SC=14727,SCS=5, SB=384336,SBS=149

2016-04-13 12:09:45 1 1 SWorker::Run():m_iocp.GetStatus() 121 (-1)

 Spoiler

2016-04-13 12:12:22 1 1 SAgent:isconnect: (4, 64)

2016-04-13 12:12:22 1 1 T=001:24:00:000, RC=21082,RCS=4, RB=390692,RBS=76, SC=6018,SCS=1, SB=3125996,SBS=613

2016-04-13 12:12:22 ### Disconnect[5212] : Game[1][0x01168CB8], Name=Game01, Addr=127.0.0.1, DBJobEnd=0

2016-04-13 12:12:22 ### PostDispatchDB[5212] : DB_DISPATCHER_EXIT Game[1][0x01168CB8]

2016-04-13 12:12:22 ### OnDispatchDB[5056] : => DB_DISPATCHER_EXIT Game[1][0x01168CB8]

2016-04-13 12:12:22 CWorld:BKillCountLoad: err=100, query={?=call usp_Save_GodBless_E(10596,1286)}

2016-04-13 12:12:22 SAVE kill count ERROR

2016-04-13 12:12:22 ### Save[5056] : Game[1][0x01168CB8]

2016-04-13 12:12:22 ### OnDispatchDB[5056] : <= DB_DISPATCHER_EXIT Game[1][0x01168CB8]

 Spoiler

2016-04-13 12:12:22 1 1 SAgent:isconnect: (4, 64)

2016-04-13 12:12:22 1 1 T=001:24:00:000, RC=12822,RCS=2, RB=1622617,RBS=318, SC=16,SCS=0, SB=64,SBS=0

2016-04-13 12:12:22 disconnect game

 Spoiler

2016-04-13 10:47:29 connect game

2016-04-13 12:12:22 1 1 SAgent:isconnect: (4, 64)

2016-04-13 12:12:22 1 1 T=001:24:00:000, RC=1002,RCS=0, RB=27373,RBS=5, SC=221,SCS=0, SB=19427,SBS=3

2016-04-13 12:12:22 disconnect game

 Spoiler

2016-04-13 12:11:47 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'PS_GameLog.dbo.UserLog'., SQL STATE: 42S02, NATIVE ERROR: 208 (0xD0)

2016-04-13 12:11:47 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 88075,4691254311970144257,1,'64'

2016-04-13 12:12:22 1 1 SAgent:isconnect: (4, 64)

2016-04-13 12:12:22 1 1 T=001:24:00:000, RC=151,RCS=0, RB=2962,RBS=0, SC=16,SCS=0, SB=64,SBS=0

2016-04-13 12:12:22 disconnect

any help is appreciated


earlier in the testing we found out that the Item Mall made the server crash and it did not leave any logs about it in the logs. This was caused if the purchase in the item mall included a package that would take more than 24 (I think) slots in the inventory, we reduced that number and it was fixed. I'm afraid if its something similar and it will be hard to find.

[killer2p]

Check your logs read it says userlog

[Psycnosis]

Sorry forgot to write here,
no it wasnt the userlogs. It was appearantly the item mall. Its been fixed and is working all fine now, I gave the answer to my own question meh.

[Arby]

#moved…