Deadlock victim

[LightRitual]

This is my PS_DBAGENT__system.log

2009-07-03 20:17:34 PS_DBAGENT__system log start (DBAgent01)

2009-07-03 20:17:34 UpdateGuildPointRankDB Result=0

2009-07-03 20:17:38 connect game



2009-07-03 20:36:55 err=-1, [Microsoft][ODBC SQL Server Driver]Timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)

2009-07-03 20:36:55 SaveBuyPointItem 244 JuneFury qerr=-1, {?=call usp_Save_User_BuyPointItems_PayLetterT(40,244,0,'B2_Mysbg2001','2009-07-03 20:36:40',1)}

2009-07-03 21:13:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 80) 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)

2009-07-03 21:13:20 ::SaveCharacter 193 ChienBinhUSA ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(193,60, 0,22, 350,182,9,8,7,*** 5051,929,2442, 19,357, 556550,3293539, 858.969971,58.900002,1867.349976, 0,200,0,0,0, 28,18,1,5, 0,0)}

2009-07-03 21:13:25 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 76) 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)

2009-07-03 21:13:25 ::SaveCharacter 179 MiSa ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(179,60, 0,2, 12,9,604,10,10,10, 14850,1128,1433, 0,240, 556550,98074490, 1873.940552,14.778601,374.218475, 0,200,0,0,0, 40,5,2,3, 0,0)}

2009-07-03 21:13:26 err=-1, [Microsoft][ODBC SQL Server Driver]Timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)

2009-07-03 21:13:26 ::SaveCharacter 177 SonGoKu ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(177,60, 0,5, 446,106,11,8,7,77, 10466,609,4400, 0,346, 556550,548218710, 1875.668213,14.787436,374.179871, 0,200,0,0,0, 43,4,30,37, 0,0)}

2009-07-03 21:13:28 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 82) 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)

2009-07-03 21:13:28 ::SaveCharacter 203 ChickenDoo ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(203,60, 0,80, 468,150,11,8,7,11, 11330,600,3384, 0,170, 556550,77281156, 1877.793701,14.674870,380.180908, 0,200,0,0,0, 0,0,1,4, 0,0)}

2009-07-03 21:13:28 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 79) 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)

2009-07-03 21:13:28 ::SaveCharacter 210 REALies ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(210,60, 0,36, 50,****12,7,10,476, 86***1839,3880, 0,149, 556550,36161413, 1862.968750,14.679998,348.297241, 0,200,0,0,0, 0,0,0,3, 0,0)}

2009-07-03 21:13:28 err=-1, [Microsoft][ODBC SQL Server Driver]Timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)

2009-07-03 21:13:28 ::SaveCharacter 251 KudoShinichi ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(251,60, 0,9710, 415,****9,8,7,150, 10923,1959,4915, 0,280, 556550,85632616, 232.622650,26.535692,1826.365601, 0,200,0,0,0, 0,0,0,1, 0,0)}

2009-07-03 21:13:30 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 79) 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)

2009-07-03 21:13:30 ::SaveCharacter 210 REALies ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(210,60, 0,36, 50,****12,7,10,476, 86***1839,3880, 0,149, 556550,36161413, 1862.968750,14.679998,348.297241, 0,200,0,0,0, 0,0,0,3, 0,0)}

2009-07-03 21:13:32 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 81) 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)

2009-07-03 21:13:32 ::SaveCharacter 251 KudoShinichi ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(251,60, 0,9710, 415,****9,8,7,150, 10923,1959,4915, 0,280, 556550,85632616, 232.622650,26.535692,1826.365601, 0,200,0,0,0, 0,0,0,1, 0,0)}

2009-07-03 21:13:32 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 78) 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)

2009-07-03 21:13:32 ::SaveCharacter 177 SonGoKu ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(177,60, 0,5, 446,106,11,8,7,77, 10466,609,4400, 0,346, 556550,548218710, 1875.668213,14.787436,374.179871, 0,200,0,0,0, 43,4,30,37, 0,0)}

2009-07-03 21:13:33 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 82) 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)

2009-07-03 21:13:33 ::SaveCharacter 203 ChickenDoo ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(203,60, 0,80, 468,150,11,8,7,11, 11330,600,3384, 0,170, 556550,77281156, 1877.793701,14.674870,380.180908, 0,200,0,0,0, 0,0,1,4, 0,0)}

2009-07-03 21:13:33 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 81) 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)

2009-07-03 21:13:33 ::SaveCharacter 251 KudoShinichi ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(251,60, 0,9710, 415,****9,8,7,150, 10923,1959,4915, 0,280, 556550,85632616, 232.622650,26.535692,1826.365601, 0,200,0,0,0, 0,0,0,1, 0,0)}

2009-07-03 22:40:39 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 81) 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)

2009-07-03 22:40:39 ::SaveCharacter 304 Heineken ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(304,25, 18,23, 160,9,38,10,60,10, 904,408,179, 2,0, 15817,99254440, 1838.930054,129.330002,443.429993, 0,200,0,0,0, 0,0,0,0, 0,0)}

2009-07-03 22:40:44 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 76) 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)

2009-07-03 22:40:44 ::SaveCharacter 177 SonGoKu ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(177,60, 0,5, 446,106,11,8,7,77, 10466,609,4400, 0,346, 556550,548228953, 1875.668213,14.787436,374.179871, 0,200,0,0,0, 43,4,35,43, 0,0)}

2009-07-03 22:55:29 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 81) 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)

2009-07-03 22:55:29 ::SaveCharacter 247 NEMO ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(247,52, 0,77, 7,9,90,233,14,222, 3729,719,390, 34,87, 365001,103726721, 207.119644,7.514691,80.402016, 0,200,0,0,0, 0,0,0,0, 0,0)}

2009-07-03 22:55:34 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 78) 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)

2009-07-03 22:55:34 ::SaveCharacter 307 PhaLe ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(307,20, 45,45, 12,9,159,10,10,10, 3549,339,2001, 2,0, 12233,102992902, 1838.930054,129.330002,443.429993, 0,200,0,0,0, 0,0,0,0, 0,0)}

2009-07-03 22:55:37 err=-1, [Microsoft][ODBC SQL Server Driver]Timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)

2009-07-03 22:55:37 ::SaveCharacter 216 Hunterxxx ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(216,52, 0,67, 113,83,271,7,37,64, 5349,1427,3400, 16,175, 363489,97275833, 266.272919,21.545748,51.198540, 0,200,0,0,0, 0,0,0,0, 0,0)}

2009-07-03 22:55:37 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 76) 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)

2009-07-03 22:55:37 ::SaveCharacter 216 Hunterxxx ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(216,52, 0,67, 113,83,271,7,37,64, 5349,1427,3400, 16,175, 363489,97275833, 266.272919,21.545748,51.198540, 0,200,0,0,0, 0,0,0,0, 0,0)}

2009-07-03 22:55:38 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 79) 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)

2009-07-03 22:55:38 ::SaveCharacter 240 Nupxxxx ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(240,60, 0,0, 276,150,12,7,10,200, 8183,3307,5437, 17,118, 556550,22372906, 146.608368,3.314998,559.3594*** 0,200,0,0,0, 0,0,2,11, 0,0)}

2009-07-03 22:55:39 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 83) 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)

2009-07-03 22:55:39 ::SaveCharacter 304 Heineken ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(304,30, 0,24, 200,9,43,10,70,23, 2598,503,483, 2,0, 245***99069349, 1838.930054,129.330002,443.429993, 0,200,0,0,0, 0,0,0,0, 0,0)}

2009-07-03 22:55:39 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 81) 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)

2009-07-03 22:55:39 ::SaveCharacter 247 NEMO ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(247,52, 0,77, 7,9,90,233,14,222, 3729,719,390, 34,87, 365001,103726721, 207.119644,7.514691,80.402016, 0,200,0,0,0, 0,0,0,0, 0,0)}

2009-07-03 22:55:39 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 79) 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)

2009-07-03 22:55:39 ::SaveCharacter 240 Nupxxxx ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(240,60, 0,0, 276,150,12,7,10,200, 8183,3307,5437, 17,118, 556550,22372906, 146.608368,3.314998,559.3594*** 0,200,0,0,0, 0,0,2,11, 0,0)}

2009-07-03 22:55:39 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 83) 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)

2009-07-03 22:55:39 ::SaveCharacter 304 Heineken ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(304,30, 0,24, 200,9,43,10,70,23, 2598,503,483, 2,0, 24975,99069349, 1838.930054,129.330002,443.429993, 0,200,0,0,0, 0,0,0,0, 0,0)}

2009-07-03 22:55:39 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 78) 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)

2009-07-03 22:55:39 ::SaveCharacter 307 PhaLe ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(307,20, 45,45, 12,9,159,10,10,10, 3549,339,2001, 2,0, 12233,102992902, 1838.930054,129.330002,443.429993, 0,200,0,0,0, 0,0,0,0, 0,0)}

How to fix the these errors ?

I also have a weird error, godbless on my server work fine until i edit some values in the WolrdInfo table.
I managed to fix it by changed Godbless Light and Godbless Dark to 0 then restart my server.
But now, everytime i destroy a relic, the godbless bar increase only a little, not much as same as usual. Anybody know how to fix this ?

 

[Twilight]

This is my PS_DBAGENT__system.log


How to fix the these errors ?

To view the content, you need to sign in or register