troubleshooting Question

deadlocks problem

Avatar of hmatijaca
hmatijaca asked on
Sybase Database
2 Comments1 Solution1840 ViewsLast Modified:
We have a sybase db on a sunserver which we had a script running midle of night, then I received a error message:
Can someone please help with this one. It looks to me that someone was "maybe" using the db at the same time running the same script?
Thanks
Helena


04:00000:00061:2002/08/27 01:29:10.32 server  Process id 17 killed by Hostname towgp01, Host process id 14804.
04:00000:00061:2002/08/27 01:29:19.10 server  Process id 16 killed by Hostname towgp01, Host process id 14804.
05:00000:00031:2002/08/27 01:29:21.77 server  Deadlock Id 3 detected
Deadlock Id 3: detected. 1 deadlock chain(s) involved.
 
Deadlock Id 3: Process (Familyid 26 26) (suid 19) was executing a SELECT command in the procedure 'ast_ti_check'.
SQL Text: comp_check_database
Deadlock Id 3: Process (Familyid 31 31) (suid 19) was executing a UPDATE command in the procedure 'ti_i_x_msd'.
SQL Text: æ
Deadlock Id 3: Process (Familyid 0, Spid 31) was waiting for a 'exclusive page' lock on page 50377546 of the 'ti_import_export' table in database 4 but process (Familyid 26, Spid 26) already held a 'shared page' lock on it.
Deadlock Id 3: Process (Familyid 0, Spid 26) was waiting for a 'shared page' lock on page 19631351 of the 'ti_import_export' table in database 4 but process (Familyid 31, Spid 31) already held a 'exclusive page' lock on it.
 
Deadlock Id 3: Process (Familyid 0, 26) was chosen as the victim. End of deadlock information.
 
04:00000:00061:2002/08/27 01:29:23.76 server  Process id 12 killed by Hostname towgp01, Host process id 14804.
04:00000:00061:2002/08/27 01:29:34.16 server  Process id 34 killed by Hostname towgp01, Host process id 14804.
04:00000:00061:2002/08/27 01:29:38.86 server  Process id 35 killed by Hostname towgp01, Host process id 14804.
04:00000:00061:2002/08/27 01:29:48.76 server  Process id 67 killed by Hostname towgp01, Host process id 14804.
04:00000:00061:2002/08/27 01:29:53.56 server  Process id 73 killed by Hostname towgp01, Host process id 14804.
04:00000:00061:2002/08/27 01:29:59.16 server  Process id 87 killed by Hostname towgp01, Host process id 14804.
ASKER CERTIFIED SOLUTION
mithiku

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros