SAP Knowledge Base Article - Preview

2943512 - Error 12311, dbcc errors or self-deadlock on REORG reported on indexes - SAP ASE

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

Product

SAP Adaptive Server Enterprise all versions

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.