Symptom
- Process in 'latch sleep'.
- Unable to kill the process.
- While running DBCC CHECKSTORAGE, Error 835 is raised which is leaving a latch behind:
Error: 835, Severity: 21, State: 3
Illegal attempt to change contents of buffer: BUF=0xfffffd7f66c346e8, MASS=0xfffffd7f66c34600, Buf#=1, page=0xfffffd7e71890000, dbid=11, Mass vdevno=18, vpage=929848, Buf lpage=2029625, Mass stat=0x4001008, Buf stat=0x1, size=16384, cid=0 ('default data cache'), Pinned xdes=0x0000000000000000, spid=0.
Error: 9970, Severity: 20, State: 1
DBCC cannot update the finish time in dbcc_operation_log table for this operation(opid = '678') of database 'XXXXXXX'. This can be patched by executing sp_dbcc_patch_finishtime.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.5
Product
Keywords
sleeping, CR678184, CR#678184, 678184 , 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.