2096784 - REORG REBUILD causes self-deadlocks followed by Error 12311 - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2096784 - REORG REBUILD causes self-deadlocks followed by Error 12311 - SAP ASE

Symptom

  •  A REORG REBUILD command generates a self-deadlock, for example:

Beginning REORG REBUILD of index `i_6786` on table `mytable_partno`.
Deadlock Id 9 detected
Deadlock Id 9 detected. 1 deadlock chain(s) involved.
Deadlock Id 9: Process (Familyid 0, Spid 323, Suid 1) was executing a REORG command in the procedure `objid 10922` at line 1 at nested level 2.
...
Deadlock Id 9: Process (Familyid 0, Spid 323) was waiting for a `shared address` lock at 0x0x2aad854e6fd8 but process (Familyid 0, Spid 323) already held a `exclusive address` lock.
Deadlock Id 9: Process (Familyid 0, Spid 323) was waiting for a `shared address` lock at 0x0x2aad854e6fd8 but process (Familyid 0, Spid 323) already held a `shared address` lock.

Deadlock Id 9: Process (Familyid 0, Spid 323) was chosen as the victim.
Victim process host = `MyHost.xxx.domain`, user = `sa` program name = `MyAPP` host processes = `123` .
End of deadlock information

  • It is followed by Error 12311:

Error: 12311, Severity: 20, State: 7
Internal error: address lock request on page 103637567 of index id 3 of table `mytable_partno` (id = 2021579209) in database `test1` failed with status -2. No need to drop the index.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise all versions

Keywords

634454, CR634454, corrupt, corruption, DBCC, CHECKTABLE, CHECKINDEX, SDES, non-leaf page, bt__traverse(), bt__rebldpgate_findcurpg() , 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.