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

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.