Symptom
- Running REORG REBUILD may cause self-deadlock on the index
- The ASE errorlog shows a deadlock message including 'REORG' command:
Deadlock Id 22 detected. 1 deadlock chain(s) involved.
Deadlock Id 22: Process (Familyid 0, Spid 29, Suid 5895) was executing a REORG command at line 1.
Deadlock Id 22: Process 29 was involved in application 'isql'.
Deadlock Id 22: Process 29 was involved on host name 'hostname'.
Deadlock Id 22: Process 29 was involved in transaction '$rebldidx'.
SQL Text: reorg rebuild dbo.t1 t1_ncdx1
Deadlock Id 22: Process (Familyid 0, Spid 29, Suid 5895) was executing a REORG command at line 1.
Deadlock Id 22: Process 29 was involved in application 'isql'.
Deadlock Id 22: Process 29 was involved on host name 'hostname'.
Deadlock Id 22: Process 29 was involved in transaction '$rebldidx'.
SQL Text: reorg rebuild dbo.t1 t1_ncdx1
Deadlock Id 22: Process (Familyid 0, Spid 29) was waiting for a 'shared address' lock at 0x0x2ab04634f730 but process (Familyid 0, Spid 29) already held a 'exclusive address' lock.
Deadlock Id 22: Process (Familyid 0, Spid 29) was waiting for a 'shared address' lock at 0x0x2ab04634f730 but process (Familyid 0, Spid 29) already held a 'shared address' lock.
Deadlock Id 22: Process (Familyid 0, Spid 29) was chosen as the victim.
Victim process host = `hostname', user = `user1' program name = `isql' host processes = `10461' .
End of deadlock information.
- ASE errorlog may report error 12311:
- these can be seen with or without deadlock error
Error: 12311, Severity: 20, State: 7
Internal error: address lock request on page nnnnn of index id 2 of table 'my_table' (id = %d) in database 'my_db' failed with status -2. No need to drop the index.
- When running DBCC CHECKINDEX, it may report the following errors:
- these can be seen with or without the deadlock or 12311 errors
Msg 15066, Level 18, State 1
No leaf row found for data page %d row 7 in leaf page nnnnn of indexid 2, table %d. ….
Msg 7928, Level 18, State 1
Index idx1 is not consistent; found %d leaf rows but %d data rows.
Drop and recreate the index. ...
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
- SAP Adaptive Server Enterprise (ASE) 16.0
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.