I am currently using Sybase database ver. 11 (adaptive server). Whenever a transaction is made, I get prompts like "Process id#", "This transaction has been chosen as a deadlock victim." The system takes a lot of time to finish a transaction. Really need help here pls.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
sybase database hang-ups & deadlocks
- Thread starter realfpj23
- Start date
What is the version 11.9.2 , 11.9.3 ?
The message means that process A was holding a lock on page (or row) R1 and waiting to update page (or row) R2. Meanwhile, there was another process B, holding a lock on page R2 and waiting to update R1 which was held by process A.
What I suggest is that you look into the application code's access path to resolve the problem.
abhay
The message means that process A was holding a lock on page (or row) R1 and waiting to update page (or row) R2. Meanwhile, there was another process B, holding a lock on page R2 and waiting to update R1 which was held by process A.
What I suggest is that you look into the application code's access path to resolve the problem.
abhay
- Status
Similar threads
- Locked
- Question
- Locked
- Question