[PROBLEM] Server make players DC

jimmy1995pl · 07/16/2014, 17:59

Hello, sometimes people on my server getting DC after a few hours of play. DC does rollback of charcter items, locations and the other things that they had. I tried to change ps_DBAgent.exe, for the one who gave LPH. My file serves from TeddyBear. If anyone knows how to fix it I would ask a help.

logs:

PS_DBAGENT__systemlog

PHP Code:


			
2014-07-15 19:48:17 PS_DBAGENT__system log start (DBAgent01)

2014-07-15 19:49:37 connect game, Name=



2014-07-15 19:49:37 connect game, Name=



2014-07-16 17:36:37 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 69) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:37 ::SaveCharacter 319 Fellice ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(319,70,0,195,8,9,631,14,85,8,-15801,15972,8410,46,99,3850000,321237213,'923.505127','63.822704','81.928986', 0,200,0,0,0, 825,17,0,0, 0,0)}

2014-07-16 17:36:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 70) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:42 ::SaveCharacter 364 miss ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(364,31,0,0,12,9,0,10,10,10,2837,371,326,43,131,320150,0,'242.783508','16.626488','61.686134', 0,200,0,0,0, 0,0,0,0, 0,0)}

2014-07-16 17:36:44 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 67) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:44 ::SaveCharacter 370 Hiszpann ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(370,70,0,195,588,9,83,10,10,55,9628,6049,7838,43,313,3850000,644890110,'272.637177','16.897100','77.466049', 0,200,0,0,0, 0,0,0,0, 0,0)}

2014-07-16 17:36:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 70) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:45 ::SaveCharacter 364 miss ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(364,31,0,0,12,9,0,10,10,10,2837,371,326,43,131,320150,0,'242.783508','16.626488','61.686134', 0,200,0,0,0, 0,0,0,0, 0,0)}

2014-07-16 17:36:46 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:46 ::SaveCharacter 159 [GS]DARKSTARR ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(159,70,0,195,7,9,9,716,14,9,-23491,18025,5000,46,168,3850000,102939329,'926.791016','64.277657','82.564011', 0,200,0,0,0, 6825,102,1,1, 3,0)}

2014-07-16 17:36:46 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:46 ::SaveCharacter 159 [GS]DARKSTARR ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(159,70,0,195,7,9,9,716,14,9,-23491,18025,5000,46,168,3850000,102939329,'926.791016','64.277657','82.564011', 0,200,0,0,0, 6825,102,1,1, 3,0)}

2014-07-16 17:36:46 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 67) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:46 ::SaveCharacter 370 Hiszpann ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(370,70,0,195,588,9,83,10,10,55,9628,6049,7838,43,313,3850000,644890110,'272.637177','16.897100','77.466049', 0,200,0,0,0, 0,0,0,0, 0,0)}

2014-07-16 17:36:46 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:46 ::SaveCharacter 344 Uzjel1 ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(344,70,0,195,632,14,10,7,10,82,24019,8174,16436,42,139,3850000,14719210,'44.610565','1.880667','44.113014', 0,200,0,0,0, 25,0,0,0, 0,0)}

2014-07-16 17:36:47 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 69) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:47 ::SaveCharacter 3 [ADM-D]Misiaczek ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(3,71,0,195,8,9,10,320,85,324,23795,-24421,24759,42,196,3850001,143269422,'57.891171','1.891644','63.089294', 0,200,0,0,0, 4925,0,5,0, 1,0)}

2014-07-16 17:36:47 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 70) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:47 ::SaveCharacter 267 olum ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(267,70,0,195,363,9,39,10,10,10,29318,2170,12397,70,232,3850000,182895708,'829.126343','29.219992','671.585571', 0,200,0,0,0, 325,20,0,1, 0,0)}

2014-07-16 17:36:47 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 69) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:47 ::SaveCharacter 3 [ADM-D]Misiaczek ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(3,71,0,195,8,9,10,320,85,324,23795,-24421,24759,42,196,3850001,143269422,'57.891171','1.891644','63.089294', 0,200,0,0,0, 4925,0,5,0, 1,0)}

PHP Code:


			
//PS_DBAGENT__charsave log start (DBAgent01)

--<begin>2014-07-16 17:36:45,karolek1,215,miss,364

{?=call usp_Save_Char_Info_E(364,31, 0,0, 12,9,0,10,10,10, 2837,371,326, 43,131, 320150,0, 242.783508,16.626488,61.686134, 0,200,0,0,0, 0,0,0,0)}

EXEC usp_Save_User_StoredMoney_E 1,215,0

{?=call Usp_Save_Char_ApplySkill_Del_E(364,0,0,1)}

EXEC usp_Save_Char_QuickSlot_Del_E 364

--<end>2014-07-16 17:36:45,karolek1,215,miss,364





--<begin>2014-07-16 17:36:46,DARKSTAR12,113,[GS]DARKSTARR,159

{?=call usp_Save_Char_Info_E(159,70, 0,195, 7,9,9,716,14,9, 42045,18025,5000, 46,168, 3850000,102939329, 926.791016,64.277657,82.564011, 0,200,0,0,0, 6825,102,1,1)}

EXEC usp_Save_User_StoredMoney_E 1,113,0

{?=call Usp_Save_Char_Item_Mod_E(159,4169561316178067456, 0,1, 1200, 185,21,20,19,254,253,'00004040400040000065',1)}

{?=call Usp_Save_Char_Item_Mod_E(159,4169561646890745856, 0,5, 1200, 183,66,21,14,20,13,'00050038140000000015',1)}

{?=call Usp_Save_Char_Item_Mod_E(159,4169575326361387008, 1,0, 0, 0,0,0,0,0,0,'',188)}

{?=call Usp_Save_Char_Item_Mod_E(159,4169561646890680320, 1,8, 1200, 181,66,21,14,20,13,'00200034320000000015',1)}

{?=call Usp_Save_Char_Item_Mod_E(159,4170171626735861760, 1,15, 0, 0,0,0,0,0,0,'',222)}

{?=call Usp_Save_Char_Item_Mod_E(159,4169934321202954240, 3,0, 0, 0,0,0,0,0,0,'',1)}

{?=call Usp_Save_Char_Item_Mod_E(159,4170536973833994240, 3,8, 0, 0,0,0,0,0,0,'',219)}

{?=call Usp_Save_Char_Item_Mod_E(159,4169560946810880000, 5,1, 1200, 187,21,20,254,253,252,'00004040400040000065',1)}

{?=call Usp_Save_Char_Item_Del_E(159,'4170638274932572160',0)}

{?=call Usp_Save_Char_Item_Add_E(159,4170638274932572160, 5,3, 100031,100,31, 0, 0,0,0,0,0,0,'', 1, '2014-07-16 17:21:42', 'S')}

{?=call Usp_Save_Char_Item_Mod_E(159,4170102567956709376, 5,11, 1200, 0,0,0,0,0,0,'',1)}

{?=call Usp_Save_Char_Item_Mod_E(159,4169567217463132160, 5,12, 0, 0,0,0,0,0,0,'',59)}

{?=call Usp_Save_Char_Skill_Mod_E(159,2,7,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,3,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,4,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,5,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,7,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,9,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,303,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,32,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,15,2,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,19,2,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,59,7,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,31,5,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,30,5,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,105,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,138,1,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,304,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,130,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,131,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,41,8,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,119,7,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,62,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,76,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,78,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,306,1,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,139,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,346,5,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,90,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,25,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,111,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,343,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,192,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,159,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,160,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,171,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,89,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,307,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,98,5,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,175,2,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,181,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,75,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,158,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,308,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,305,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,344,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,88,5,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,147,8,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,14,7,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,365,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,320,1,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,6,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,29,9,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,132,7,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,34,9,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,35,9,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,36,9,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,47,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,48,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,50,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,52,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,143,5,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,70,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,69,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,321,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,356,5,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,323,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,322,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,164,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,165,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,166,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,117,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,191,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,109,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,28,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,74,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,84,5,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,95,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,96,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,178,3,229)}

{?=call Usp_Save_Char_Skill_Mod_E(159,184,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,358,1,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,82,5,0)}

{?=call Usp_Save_Char_Skill_Mod_E(159,83,5,0)}

{?=call Usp_Save_Char_ApplySkill_Del_E(159,0,0,1)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(159,225,1,2043788)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(159,227,1,2043790)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(159,233,1,2043787)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(159,286,3,2043785)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(159,132,7,900)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(159,47,4,900)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(159,117,6,900)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(159,123,6,900)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(159,116,6,1800)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(159,104,100,180)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(159,30,100,180)}

EXEC usp_Save_Char_QuickSlot_Del_E 159

EXEC usp_Save_Char_QuickSlot_Add_E 159,0,0,100,29

EXEC usp_Save_Char_QuickSlot_Add_E 159,0,1,100,36

EXEC usp_Save_Char_QuickSlot_Add_E 159,0,2,100,70

EXEC usp_Save_Char_QuickSlot_Add_E 159,0,3,100,356

EXEC usp_Save_Char_QuickSlot_Add_E 159,0,4,100,84

EXEC usp_Save_Char_QuickSlot_Add_E 159,0,5,100,35

EXEC usp_Save_Char_QuickSlot_Add_E 159,0,6,100,166

EXEC usp_Save_Char_QuickSlot_Add_E 159,0,7,100,164

EXEC usp_Save_Char_QuickSlot_Add_E 159,0,8,100,69

EXEC usp_Save_Char_QuickSlot_Add_E 159,0,9,100,109

EXEC usp_Save_Char_QuickSlot_Add_E 159,1,0,100,184

EXEC usp_Save_Char_QuickSlot_Add_E 159,1,1,100,74

EXEC usp_Save_Char_QuickSlot_Add_E 159,1,2,100,178

EXEC usp_Save_Char_QuickSlot_Add_E 159,1,3,1,0

EXEC usp_Save_Char_QuickSlot_Add_E 159,1,4,3,0

EXEC usp_Save_Char_QuickSlot_Add_E 159,1,5,100,96

EXEC usp_Save_Char_QuickSlot_Add_E 159,1,6,5,1

EXEC usp_Save_Char_QuickSlot_Add_E 159,1,7,1,7

EXEC usp_Save_Char_QuickSlot_Add_E 159,1,8,1,8

EXEC usp_Save_Char_QuickSlot_Add_E 159,1,9,1,9

EXEC usp_Save_Char_QuickSlot_Add_E 159,2,0,100,132

EXEC usp_Save_Char_QuickSlot_Add_E 159,2,1,100,47

EXEC usp_Save_Char_QuickSlot_Add_E 159,2,2,100,117

EXEC usp_Save_Char_QuickSlot_Add_E 159,2,3,100,191

EXEC usp_Save_Char_QuickSlot_Add_E 159,2,4,100,178

EXEC usp_Save_Char_QuickSlot_Add_E 159,10,0,100,323

EXEC usp_Save_Char_QuickSlot_Add_E 159,10,1,100,321

EXEC usp_Save_Char_QuickSlot_Add_E 159,10,2,100,322

EXEC usp_Save_Char_QuickSlot_Add_E 159,10,3,100,50

EXEC usp_Save_Char_QuickSlot_Add_E 159,10,4,100,52

EXEC usp_Save_Char_QuickSlot_Add_E 159,10,5,100,48

EXEC usp_Save_Char_QuickSlot_Add_E 159,100,0,1,15

EXEC usp_Save_Char_QuickSlot_Add_E 159,100,1,3,8

--<end>2014-07-16 17:36:46,DARKSTAR12,113,[GS]DARKSTARR,159





--<begin>2014-07-16 17:36:46,lagerr,45,Hiszpann,370

{?=call usp_Save_Char_Info_E(370,70, 0,195, 588,9,83,10,10,55, 9628,6049,7838, 43,313, 3850000,644890110, 272.637177,16.897100,77.466049, 0,200,0,0,0, 0,0,0,0)}

EXEC usp_Save_User_StoredMoney_E 1,45,0

{?=call Usp_Save_Char_Item_Mod_E(370,4169211856164028416, 0,0, 400, 227,113,111,228,115,229,'00002900081825000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(370,4169493807882174464, 0,5, 1200, 183,6,7,34,0,0,'10002400001100000015',1)}

{?=call Usp_Save_Char_Item_Mod_E(370,4169508123008106496, 0,6, 1200, 7,13,6,12,5,0,'15000000220328000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(370,4167210654807162880, 1,7, 0, 0,0,0,0,0,0,'',1)}

{?=call Usp_Save_Char_Item_Mod_E(370,4169054102015246336, 1,19, 1200, 182,7,34,6,0,0,'21113500000000000015',1)}

{?=call Usp_Save_Char_Item_Mod_E(370,4170610769962270720, 5,0, 0, 0,0,0,0,0,0,'',1)}

{?=call Usp_Save_Char_Skill_Mod_E(370,2,7,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,3,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,4,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,5,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,7,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,9,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,303,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,32,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,15,2,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,19,2,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,17,2,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,59,7,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,31,5,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,30,5,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,130,2,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,192,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,304,5,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,41,8,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,119,7,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,76,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,62,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,78,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,139,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,90,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,346,5,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,25,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,75,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,111,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,159,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,158,1,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,160,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,171,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,307,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,175,2,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,181,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,99,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(370,98,5,0)}

{?=call Usp_Save_Char_ApplySkill_Del_E(370,0,0,1)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(370,233,1,2592000)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(370,225,1,2592000)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(370,227,1,2592000)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(370,286,3,2592000)}

{?=call Usp_Save_Char_Quest_Mod_E(370,3,0,0,0,0)}

EXEC usp_Save_Char_QuickSlot_Del_E 370

--<end>2014-07-16 17:36:46,lagerr,45,Hiszpann,370





--<begin>2014-07-16 17:36:47,Misiaczek,3,[ADM-D]Misiaczek,3

{?=call usp_Save_Char_Info_E(3,71, 0,195, 8,9,10,320,85,324, 23795,41115,24759, 42,196, 3850001,143269422, 57.891171,1.891644,63.089294, 0,200,0,0,0, 4925,0,5,0)}

EXEC usp_Save_User_StoredMoney_E 1,3,808464688

{?=call Usp_Save_Char_Skill_Mod_E(3,365,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,320,1,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,32,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,4,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,14,7,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,29,9,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,192,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,132,7,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,103,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,364,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,102,8,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,144,8,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,148,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,85,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,72,5,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,53,5,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,187,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,123,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,191,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,126,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,116,6,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,127,1,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,28,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,186,5,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,324,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,167,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,326,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,185,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,3,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,363,4,0)}

{?=call Usp_Save_Char_Skill_Mod_E(3,54,3,0)}

{?=call Usp_Save_Char_ApplySkill_Del_E(3,0,0,1)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(3,225,1,2256293)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(3,227,1,2256291)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(3,233,1,2256297)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(3,286,3,2256295)}

EXEC usp_Save_Char_QuickSlot_Del_E 3

EXEC usp_Save_Char_QuickSlot_Add_E 3,0,0,100,29

EXEC usp_Save_Char_QuickSlot_Add_E 3,0,1,100,324

EXEC usp_Save_Char_QuickSlot_Add_E 3,0,2,100,85

EXEC usp_Save_Char_QuickSlot_Add_E 3,0,3,100,53

EXEC usp_Save_Char_QuickSlot_Add_E 3,0,4,100,363

EXEC usp_Save_Char_QuickSlot_Add_E 3,0,5,100,167

EXEC usp_Save_Char_QuickSlot_Add_E 3,0,6,100,187

EXEC usp_Save_Char_QuickSlot_Add_E 3,0,7,100,186

EXEC usp_Save_Char_QuickSlot_Add_E 3,0,8,100,326

EXEC usp_Save_Char_QuickSlot_Add_E 3,0,9,100,103

EXEC usp_Save_Char_QuickSlot_Add_E 3,1,0,100,185

EXEC usp_Save_Char_QuickSlot_Add_E 3,1,1,100,148

EXEC usp_Save_Char_QuickSlot_Add_E 3,1,2,100,102

EXEC usp_Save_Char_QuickSlot_Add_E 3,1,3,100,144

EXEC usp_Save_Char_QuickSlot_Add_E 3,1,4,100,116

EXEC usp_Save_Char_QuickSlot_Add_E 3,1,5,100,127

EXEC usp_Save_Char_QuickSlot_Add_E 3,1,6,101,3

EXEC usp_Save_Char_QuickSlot_Add_E 3,1,7,101,4

EXEC usp_Save_Char_QuickSlot_Add_E 3,1,8,100,126

EXEC usp_Save_Char_QuickSlot_Add_E 3,1,9,100,192

EXEC usp_Save_Char_QuickSlot_Add_E 3,10,0,100,123

EXEC usp_Save_Char_QuickSlot_Add_E 3,10,1,100,132

EXEC usp_Save_Char_QuickSlot_Add_E 3,10,2,100,364

EXEC usp_Save_Char_QuickSlot_Add_E 3,10,3,100,191

EXEC usp_Save_Char_QuickSlot_Add_E 3,21,1,255,0

--<end>2014-07-16 17:36:47,Misiaczek,3,[ADM-D]Misiaczek,3

PHP Code:


			
USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Save_Char_Info_E]    Script Date: 07/14/2014 00:21:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER Proc [dbo].[usp_Save_Char_Info_E] 

@CharID int, 
@Level int, 
@StatPoint smallint, 
@SkillPoint smallint, 
@Str smallint, 
@Dex smallint, 
@Rec smallint, 
@Int smallint, 
@Wis smallint, 
@Luc smallint, 
@Hp smallint, 
@Mp smallint, 
@Sp smallint, 
@Map smallint, 
@Dir smallint, 
@Exp int, 
@Money int, 
@Posx varchar(50), 
@Posy varchar(50), 
@Posz varchar(50), 
@Hg int, 
@Vg int, 
@Cg int, 
@Og int, 
@Ig int, 
@K1 int = null, 
@K2 int = null, 
@K3 int = null, 
@K4 int = null, 
@KillLevel tinyint, 
@DeadLevel tinyint 

AS 

SET NOCOUNT ON 

DECLARE @ServerID int, 
    @Grow int, 
    @tempExp bigint, 
    @PosxR real, 
    @PosyR real, 
    @PoszR real 

SET @ServerID = 1 

IF (ISNumeric(@Posx) = 1 and ISNumeric(@Posy) = 1 and ISNumeric(@Posz) = 1) 
BEGIN 
    SET @PosxR = CAST(@Posx as real) 
    SET @PosyR = CAST(@Posy as real) 
    SET @PoszR = CAST(@Posz as real) 
END 
ELSE 
BEGIN 

    SET @Map = 42 
    SET @PosxR = 66.5 
    SET    @PosYR = 2.0 
    SET @PosZR = 52.6 
END 

UPDATE Chars 
    SET [Level] = @Level, StatPoint = @StatPoint, SkillPoint = @SkillPoint, 
    [Str] = @Str, dex = @Dex, Rec = @Rec, [int] = @Int, Wis = @Wis, Luc = @Luc, 
    HP = @Hp, Mp = @Mp, Sp = @Sp, 
    Map = @Map, dir = @Dir, [exp] = @Exp, [money] = @Money, 
    PosX = @PosxR, PosY = @PosYR, PosZ = @PosZR, hg = @Hg, vg = @Vg, cg = @Cg, og = @Og, ig = @Ig,  
    KillLevel=@KillLevel, DeadLevel=@DeadLevel,LeaveDate=GETDATE() 
WHERE CharID = @CharID 

IF( (@K1 IS NOT NULL) AND (@K2 IS NOT NULL) AND (@K3 IS NOT NULL) AND (@K4 IS NOT NULL)) 
BEGIN 
    UPDATE Chars SET K1=@K1, K2=@K2, K3=@K3, K4=@K4 WHERE CharID=@CharID 
END 

IF(@@ERROR = 0 AND @@ROWCOUNT = 1) 
BEGIN 
    RETURN 1 
END 
ELSE 
BEGIN 
    RETURN -1 
END 

SET NOCOUNT OFF

Big_ · 07/17/2014, 00:09

dose the servises become paused after this happens ?

jimmy1995pl · 07/17/2014, 00:51

No, server still working just players getting DC (but not all which are online in game). Btw server using Microsoft SQL Server 2008 R2 on Windows Server 2008 R2 no idea if it's important.

Boul27 · 07/17/2014, 08:05

A deadlock occurs when 2 processes try to hit the same data at the same time.

How many ram did you have ?

jimmy1995pl · 07/17/2014, 11:34

Server have 2GB of RAM but when is run using like 900 - 1000 MB. I have no idea. Does the apache with script that showing players online or any procedure in database can doing that? Other logs looks good just in ps agent they are.

Hoever thanks for reply. If anyone know what i can change please for answer.

Boul27 · 07/17/2014, 12:06

There is mine

Spoiler

Make a backup of yours, test mine, and tell me what happend

jimmy1995pl · 07/17/2014, 12:38

Thanks. I executed that. As I said the problem is somtimes, last DCs was yesterday at 20:06 - 20:07, 20:22 and as the log show players get dc on the same time but not all time. Currently the server is enabled since before yesterday(without restart I mean). BTW does the sql 2008 R2 32 bit on windows server 2008 R2 64 bit can cause these problems?

Spoiler

Edit:
Already Fixed. I found help on microsoft site. The problem probably was in procedure Save Char Info E that had two update(2nd was for kills/deaths) and it causes deadlocks. Also added to the update "UPDATE Chars WITH(XLOCK)" All procedure is here:

PHP Code:


			
USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Save_Char_Info_E]    Script Date: 07/18/2014 15:10:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER Proc [dbo].[usp_Save_Char_Info_E]

@CharID int,
@Level int,
@StatPoint smallint,
@SkillPoint smallint,
@Str smallint,
@Dex smallint,
@Rec smallint,
@Int smallint,
@Wis smallint,
@Luc smallint,
@Hp smallint,
@Mp smallint,
@Sp smallint,
@Map smallint,
@Dir smallint,
@Exp int,
@Money int,
@Posx varchar(50),
@Posy varchar(50),
@Posz varchar(50),
@Hg int,
@Vg int,
@Cg int,
@Og int,
@Ig int,
@K1 int = null,
@K2 int = null,
@K3 int = null,
@K4 int = null,
@KillLevel tinyint,
@DeadLevel tinyint

AS

SET NOCOUNT ON

DECLARE @ServerID int,
@Grow int,
@tempExp bigint,
@PosxR real,
@PosyR real,
@PoszR real

SET @ServerID = 1

IF (ISNumeric(@Posx) = 1 and ISNumeric(@Posy) = 1 and ISNumeric(@Posz) = 1)
BEGIN
SET @PosxR = CAST(@Posx as real)
SET @PosyR = CAST(@Posy as real)
SET @PoszR = CAST(@Posz as real)
END
ELSE
BEGIN

SET @Map = 42
SET @PosxR = 66.5
SET @PosYR = 2.0
SET @PosZR = 52.6
END

UPDATE Chars WITH(XLOCK)
SET [Level] = @Level, StatPoint = @StatPoint, SkillPoint = @SkillPoint,
[Str] = @Str, dex = @Dex, Rec = @Rec, [int] = @Int, Wis = @Wis, Luc = @Luc,
HP = @Hp, Mp = @Mp, Sp = @Sp,
Map = @Map, dir = @Dir, [exp] = @Exp, [money] = @Money,
PosX = @Posx, PosY = @PosY, PosZ = @PosZ, hg = @Hg, vg = @Vg, cg = @Cg, og = @Og, ig = @Ig,
KillLevel=@KillLevel, DeadLevel=@DeadLevel,LeaveDate=GETDATE(),
K1 = CASE WHEN @K1 IS NOT NULL THEN @K1 ELSE K1 END,
K2 = CASE WHEN @K2 IS NOT NULL THEN @K2 ELSE K2 END,
K3 = CASE WHEN @K3 IS NOT NULL THEN @K3 ELSE K3 END,
K4 = CASE WHEN @K4 IS NOT NULL THEN @K4 ELSE K4 END
WHERE CharID = @CharID

IF(@@ERROR = 0 AND @@ROWCOUNT = 1)
BEGIN
RETURN 1
END
ELSE
BEGIN
RETURN -1
END

SET NOCOUNT OFF

balongskie123 · 03/25/2017, 06:42

Quote:

Originally Posted by jimmy1995pl

Thanks. I executed that. As I said the problem is somtimes, last DCs was yesterday at 20:06 - 20:07, 20:22 and as the log show players get dc on the same time but not all time. Currently the server is enabled since before yesterday(without restart I mean). BTW does the sql 2008 R2 32 bit on windows server 2008 R2 64 bit can cause these problems?

Spoiler

2014-07-15 19:48:17 PS_DBAGENT__system log start (DBAgent01)

2014-07-15 19:49:37 connect game, Name=

2014-07-15 19:49:37 connect game, Name=

2014-07-16 17:36:37 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 69) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:37 ::SaveCharacter 319 Fellice ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(319,70,0,195,8,9,631,14,85,8,-15801,15972,8410,46,99,3850000,321237213,'923.5051 27','63.822704','81.928986', 0,200,0,0,0, 825,17,0,0, 0,0)}

2014-07-16 17:36:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 70) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:42 ::SaveCharacter 364 miss ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(364,31,0,0,12,9,0,10,10,10,28 37,371,326,43,131,320150,0,'242.783508','16.626488 ','61.686134', 0,200,0,0,0, 0,0,0,0, 0,0)}

2014-07-16 17:36:44 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 67) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:44 ::SaveCharacter 370 Hiszpann ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(370,70,0,195,588,9,83,10,10,5 5,9628,6049,7838,43,313,3850000,644890110,'272.637 177','16.897100','77.466049', 0,200,0,0,0, 0,0,0,0, 0,0)}

2014-07-16 17:36:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 70) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:45 ::SaveCharacter 364 miss ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(364,31,0,0,12,9,0,10,10,10,28 37,371,326,43,131,320150,0,'242.783508','16.626488 ','61.686134', 0,200,0,0,0, 0,0,0,0, 0,0)}

2014-07-16 17:36:46 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:46 ::SaveCharacter 159 [GS]DARKSTARR ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(159,70,0,195,7,9,9,716,14,9,-23491,18025,5000,46,168,3850000,102939329,'926.791 016','64.277657','82.564011', 0,200,0,0,0, 6825,102,1,1, 3,0)}

2014-07-16 17:36:46 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:46 ::SaveCharacter 159 [GS]DARKSTARR ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(159,70,0,195,7,9,9,716,14,9,-23491,18025,5000,46,168,3850000,102939329,'926.791 016','64.277657','82.564011', 0,200,0,0,0, 6825,102,1,1, 3,0)}

2014-07-16 17:36:46 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 67) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:46 ::SaveCharacter 370 Hiszpann ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(370,70,0,195,588,9,83,10,10,5 5,9628,6049,7838,43,313,3850000,644890110,'272.637 177','16.897100','77.466049', 0,200,0,0,0, 0,0,0,0, 0,0)}

2014-07-16 17:36:46 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:46 ::SaveCharacter 344 Uzjel1 ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(344,70,0,195,632,14,10,7,10,8 2,24019,8174,16436,42,139,3850000,14719210,'44.610 565','1.880667','44.113014', 0,200,0,0,0, 25,0,0,0, 0,0)}

2014-07-16 17:36:47 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 69) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:47 ::SaveCharacter 3 [ADM-D]Misiaczek ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(3,71,0,195,8,9,10,320,85,324, 23795,-24421,24759,42,196,3850001,143269422,'57.891171',' 1.891644','63.089294', 0,200,0,0,0, 4925,0,5,0, 1,0)}

2014-07-16 17:36:47 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 70) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:47 ::SaveCharacter 267 olum ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(267,70,0,195,363,9,39,10,10,1 0,29318,2170,12397,70,232,3850000,182895708,'829.1 26343','29.219992','671.585571', 0,200,0,0,0, 325,20,0,1, 0,0)}

2014-07-16 17:36:47 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 69) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 17:36:47 ::SaveCharacter 3 [ADM-D]Misiaczek ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(3,71,0,195,8,9,10,320,85,324, 23795,-24421,24759,42,196,3850001,143269422,'57.891171',' 1.891644','63.089294', 0,200,0,0,0, 4925,0,5,0, 1,0)}

2014-07-16 20:06:33 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 20:06:33 ::SaveCharacter 206 Lillith ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(206,70,0,552,8,9,631,14,85,8,-7947,21565,6301,46,12,3850000,400620695,'777.02679 4','34.923439','207.536240', 0,200,0,0,0, 14550,5,0,0, 0,0)}

2014-07-16 20:06:38 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 69) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 20:06:38 ::SaveCharacter 179 Ino ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(179,70,0,195,8,9,631,14,85,8,-27986,13110,7306,42,299,3850000,191690882,'56.6638 72','1.891644','45.865238', 0,200,0,0,0, 9075,23,0,0, 0,1)}

2014-07-16 20:06:41 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 67) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 20:06:41 ::SaveCharacter 319 Fellice ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(319,70,0,195,8,9,631,14,85,8,-15801,15972,8410,46,99,3850000,361831376,'923.5051 27','63.822704','81.928986', 0,200,0,0,0, 2125,26,0,0, 0,0)}

2014-07-16 20:06:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 69) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 20:06:42 ::SaveCharacter 179 Ino ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(179,70,0,195,8,9,631,14,85,8,-27986,13110,7306,42,299,3850000,191690882,'56.6638 72','1.891644','45.865238', 0,200,0,0,0, 9075,23,0,0, 0,1)}

2014-07-16 20:06:43 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 20:06:43 ::SaveCharacter 90 [GS]gwiazdka ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(90,70,0,195,8,9,647,12,83,12,-25595,15331,9206,42,281,3850000,127485921,'81.9901 28','3.523900','66.099197', 0,200,0,0,0, 13750,19,0,2, 4,0)}

2014-07-16 20:06:43 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 69) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 20:06:43 ::SaveCharacter 168 Diil ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(168,70,0,195,518,200,11,8,7,1 1,-15230,5970,18132,47,333,3850000,216461369,'513.495 789','18.101721','388.437073', 0,200,0,0,0, 8350,106,1,2, 0,1)}

2014-07-16 20:06:43 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 69) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 20:06:43 ::SaveCharacter 168 Diil ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(168,70,0,195,518,200,11,8,7,1 1,-15230,5970,18132,47,333,3850000,216461369,'513.495 789','18.101721','388.437073', 0,200,0,0,0, 8350,106,1,2, 0,1)}

2014-07-16 20:06:43 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 20:06:47 ::SaveCharacter 90 [GS]gwiazdka ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(90,70,0,195,8,9,647,12,83,12,-25595,15331,9206,42,281,3850000,127485921,'81.9901 28','3.523900','66.099197', 0,200,0,0,0, 13750,19,0,2, 4,0)}

2014-07-16 20:06:50 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 70) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 20:06:50 ::SaveCharacter 258 Antychryst ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(258,70,0,195,297,86,12,7,10,3 9,-29727,6000,17132,42,299,3850000,471162790,'23.3899 99','15.360000','106.400002', 0,200,0,0,0, 8075,79,0,0, 3,1)}

2014-07-16 20:06:55 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 20:06:55 ::SaveCharacter 1 [ADM-L]Rev ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(1,71,630,355,10,89,9,7,8,12,2 9725,21039,30427,42,80,3850001,74812230,'65.875214 ','1.859301','58.392693', 0,200,0,0,0, 25,0,0,0, 0,0)}

2014-07-16 20:06:57 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 70) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 20:06:59 ::SaveCharacter 258 Antychryst ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(258,70,0,195,297,86,12,7,10,3 9,-29727,6000,17132,42,299,3850000,471162790,'23.3899 99','15.360000','106.400002', 0,200,0,0,0, 8075,79,0,0, 3,1)}

2014-07-16 20:06:59 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 20:06:59 ::SaveCharacter 1 [ADM-L]Rev ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(1,71,630,355,10,89,9,7,8,12,2 9725,21039,30427,42,80,3850001,74812230,'65.875214 ','1.859301','58.392693', 0,200,0,0,0, 25,0,0,0, 0,0)}

2014-07-16 20:06:59 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 69) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 20:06:59 ::SaveCharacter 54 Kubus ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(54,70,0,552,647,88,9,7,8,12,-488,6892,13742,42,356,3850000,472233690,'44.520527 ','1.891644','42.103363', 0,200,0,0,0, 23525,56,22,9, 4,1)}

2014-07-16 20:07:03 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 67) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 20:07:03 ::SaveCharacter 120 Myszka ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(120,70,0,195,7,13,9,714,12,9,-20035,13651,5971,42,289,3850000,285271733,'57.5435 41','1.866570','63.026566', 0,200,0,0,0, 15275,84,1,1, 3,1)}

2014-07-16 20:07:03 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 67) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 20:07:03 ::SaveCharacter 120 Myszka ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(120,70,0,195,7,13,9,714,12,9,-20035,13651,5971,42,289,3850000,285271733,'57.5435 41','1.866570','63.026566', 0,200,0,0,0, 15275,84,1,1, 3,1)}

2014-07-16 20:07:06 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 69) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 20:07:06 ::SaveCharacter 54 Kubus ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(54,70,0,552,647,88,9,7,8,12,-488,6892,13742,42,356,3850000,472233690,'44.520527 ','1.891644','42.103363', 0,200,0,0,0, 23525,56,22,9, 4,1)}

2014-07-16 20:07:08 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 70) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 20:07:08 ::SaveCharacter 262 Lucyfer ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(262,70,0,195,7,9,9,391,14,9,-27432,20922,6072,35,200,3850000,167957575,'591.603 516','26.939993','303.021973', 0,200,0,0,0, 1350,27,0,0, 1,1)}

2014-07-16 20:07:08 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 20:07:09 ::SaveCharacter 248 BungaBunga ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(248,70,0,195,589,55,12,7,10,8 2,-26892,6524,19370,46,126,3850000,499476070,'926.791 016','64.277657','82.564003', 0,200,0,0,0, 2175,46,0,0, 0,0)}

2014-07-16 20:22:00 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 20:22:00 ::SaveCharacter 90 [GS]gwiazdka ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(90,70,0,195,8,9,647,12,83,12,-25595,15331,9206,42,281,3850000,127485921,'81.9901 28','3.523900','66.099197', 0,200,0,0,0, 13750,20,0,2, 4,0)}

2014-07-16 20:22:05 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 20:22:05 ::SaveCharacter 90 [GS]gwiazdka ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(90,70,0,195,8,9,647,12,83,12,-25595,15331,9206,42,281,3850000,127485921,'81.9901 28','3.523900','66.099197', 0,200,0,0,0, 13750,20,0,2, 4,0)}

2014-07-16 20:22:08 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 70) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2014-07-16 20:22:08 ::SaveCharacter 248 BungaBunga ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(248,70,0,195,589,55,12,7,10,8 2,-26892,6524,19370,46,126,3850000,499476072,'926.791 016','64.277657','82.564003', 0,200,0,0,0, 2175,46,0,0, 0,0)}

Edit:
Already Fixed. I found help on microsoft site. The problem probably was in procedure Save Char Info E that had two update(2nd was for kills/deaths) and it causes deadlocks. Also added to the update "UPDATE Chars WITH(XLOCK)" All procedure is here:

PHP Code:

USE [PS_GameData] GO /****** Object: StoredProcedure [dbo].[usp_Save_Char_Info_E] Script Date: 07/18/2014 15:10:40 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER Proc [dbo].[usp_Save_Char_Info_E] @CharID int, @Level int, @StatPoint smallint, @SkillPoint smallint, @Str smallint, @Dex smallint, @Rec smallint, @Int smallint, @Wis smallint, @Luc smallint, @Hp smallint, @Mp smallint, @Sp smallint, @Map smallint, @Dir smallint, @Exp int, @Money int, @Posx varchar(50), @Posy varchar(50), @Posz varchar(50), @Hg int, @Vg int, @Cg int, @Og int, @Ig int, @K1 int = null, @K2 int = null, @K3 int = null, @K4 int = null, @KillLevel tinyint, @DeadLevel tinyint AS SET NOCOUNT ON DECLARE @ServerID int, @Grow int, @tempExp bigint, @PosxR real, @PosyR real, @PoszR real SET @ServerID = 1 IF (ISNumeric(@Posx) = 1 and ISNumeric(@Posy) = 1 and ISNumeric(@Posz) = 1) BEGIN SET @PosxR = CAST(@Posx as real) SET @PosyR = CAST(@Posy as real) SET @PoszR = CAST(@Posz as real) END ELSE BEGIN SET @Map = 42 SET @PosxR = 66.5 SET @PosYR = 2.0 SET @PosZR = 52.6 END UPDATE Chars WITH(XLOCK) SET [Level] = @Level, StatPoint = @StatPoint, SkillPoint = @SkillPoint, [Str] = @Str, dex = @Dex, Rec = @Rec, [int] = @Int, Wis = @Wis, Luc = @Luc, HP = @Hp, Mp = @Mp, Sp = @Sp, Map = @Map, dir = @Dir, [exp] = @Exp, [money] = @Money, PosX = @Posx, PosY = @PosY, PosZ = @PosZ, hg = @Hg, vg = @Vg, cg = @Cg, og = @Og, ig = @Ig, KillLevel=@KillLevel, DeadLevel=@DeadLevel,LeaveDate=GETDATE(), K1 = CASE WHEN @K1 IS NOT NULL THEN @K1 ELSE K1 END, K2 = CASE WHEN @K2 IS NOT NULL THEN @K2 ELSE K2 END, K3 = CASE WHEN @K3 IS NOT NULL THEN @K3 ELSE K3 END, K4 = CASE WHEN @K4 IS NOT NULL THEN @K4 ELSE K4 END WHERE CharID = @CharID IF(@@ERROR = 0 AND @@ROWCOUNT = 1) BEGIN RETURN 1 END ELSE BEGIN RETURN -1 END SET NOCOUNT OFF

This is not working for me

~~lucasalan16~~ · 02/11/2018, 01:51

you need to renistall your SQL and it working perfectly