- Deadlocks on a table containing a text column.
- Pages involved in these deadlocks have indid=0 and indid=255
Deadlock Id 237: Process (Familyid 0, Spid 48) was waiting for a 'exclusive page' lock on page 135264049 of the 'mytable' table in database 'mydb' but process (Familyid 0, Spid 301) already held a 'shared page' lock on it.
Deadlock Id 237: Process (Familyid 0, Spid 301) was waiting for a 'shared page' lock on page 135341920 of the 'mytable' table in database 'mydb' but process (Familyid 0, Spid 48) already held a 'exclusive page' lock on it.
- Do pages with indid=255 belong to an internal index to support the text column?
- Will converting the table from all-page-locking (APL) to datapage (DOL) locking eliminate deadlocks on the indid=255 pages?
SAP Adaptive Server Enterprise (ASE) 15.x
blocking, image, In-Row, LOB , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
About this pageThis 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.