how fix DC / rollback

[Dogo]

hi all,
anyone know how fix the deadlock problem?

here one of the error i meet on PS_DBAGENT_Sytem log

err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 109) 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-08-23 11:57:37 ::SaveCharacter 1421 CharName ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(1421,31, 0,18, 11,14,10,7,10,253, 2741,675,1028, 19,315, 7074031,217044, 781.740906,8.335684,1629.112549, 0,200,0,0,0, 0,0,0,0, 0,0)}

I hope someone can help me, thanks in advance

 

[Twilight]

hi all,
anyone know how fix the deadlock problem?

here one of the error i meet on PS_DBAGENT_Sytem log

err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 109) 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-08-23 11:57:37 ::SaveCharacter 1421 CharName ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(1421,31, 0,18, 11,14,10,7,10,253, 2741,675,1028, 19,315, 7074031,217044, 781.740906,8.335684,1629.112549, 0,200,0,0,0, 0,0,0,0, 0,0)}

I hope someone can help me, thanks in advance

In the beginning it is necessary to define the second process caused blocking - both access
Example

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

After definition of blocking function to add an option
with (UPDLOCK)
Example
Select *From DeadLoack with (UPDLOCK)

This function will not be blocked. Another will expect end.

 

[Dogo]

In the beginning it is necessary to define the second process caused blocking - both access
Example

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

After definition of blocking function to add an option
with (UPDLOCK)
Example
Select *From DeadLoack with (UPDLOCK)

This function will not be blocked. Another will expect end.

WB Twi
i think its fixed now I have edited one stored procedure, i will be sure tomorrow after 1 day without dc/rollback

 

[jeannb]

WB Twi
i think its fixed now I have edited one stored procedure, i will be sure tomorrow after 1 day without dc/rollback

@Dogo can u show me how to do that?

 

[Dogo]

@Dogo can u show me how to do that?

if you show me wich error you have meet about deadlock sure, at 90% I think is for usp_save_char_info , post here the log with deadlock error and I tell you wich code insert for remove it definitely

 

[jeannb]

if you show me wich error you have meet about deadlock sure, at 90% I think is for usp_save_char_info , post here the log with deadlock error and I tell you wich code insert for remove it definitely

yep that's right.
in PS_DBAGENT__system.log:
2009-08-26 09:04:32 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-08-26 09:04:32 ::SaveCharacter 456 charname ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(456,60, 0,49, 200,50,10,7,10,378, 11371,4995,7898, 0,170, -1,-129364582, 1820.316162,20.212667,644.271973, 0,200,0,0,0, ****54,1,1, 0,0)}
I'm looking forward to your answer, DOGO

 

[Dogo]

Jeann look your PM

 

[jeannb]

@Dogo
thanks so much Dogo, you're very nice!
one more thing i need your help (if possible )
sometimes i get this error in PS_LOGIN__system.log:
2009-08-26 10:31:28 err=-1, [Microsoft][ODBC SQL Server Driver]Invalid cursor state, SQL STATE: 24000, NATIVE ERROR: 0 (0x0)

2009-08-26 10:31:28 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'jason','p[hamminhhien', 2753009835564859393,'5.0.142.164', [Microsoft][ODBC Driver Manager] Invalid cursor state, SQL STATE: 24000, NATIVE ERROR: 0 (0x0)
is something wrong with usp_Try_GameLogin_Taiwan?
thanks for your regard Dogo

 

[Dogo]

@Dogo
thanks so much Dogo, you're very nice!
one more thing i need your help (if possible )
sometimes i get this error in PS_LOGIN__system.log:
2009-08-26 10:31:28 err=-1, [Microsoft][ODBC SQL Server Driver]Invalid cursor state, SQL STATE: 24000, NATIVE ERROR: 0 (0x0)

2009-08-26 10:31:28 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'jason','p[hamminhhien', 2753009835564859393,'5.0.142.164', [Microsoft][ODBC Driver Manager] Invalid cursor state, SQL STATE: 24000, NATIVE ERROR: 0 (0x0)
is something wrong with usp_Try_GameLogin_Taiwan?
thanks for your regard Dogo

if I dont wrong is when user wrong the password so nothing to do with your server but maybe Twilight can confirm it

 

[Twilight]

if I dont wrong is when user wrong the password so nothing to do with your server but maybe Twilight can confirm it

Problems can be different:
1.
* In SQL Server Enterprise Manager, you may receive the "Invalid cursor state" error message when Microsoft