Symptom
- A connection that is inserting TEXT or IMAGE data is hanging.
- DBCC STACKTRACE run on the spid shows a stack with smp_bufpredirty() as the top function.
- Error 834 is reported in the ASE errorlog:
Error: 834, Severity: 20, State: 3
Illegal attempt to clean buffer: BUF=0x0x0000000317d97e80, MASS=0x0x0000000317d97e80, Buf#=0, page=0x0x00000002e1168000, dbid=4, Mass vdevno=66, vpage=25998016, Buf lpage=183473752, Mass stat=0x5010001, Buf stat=0x2, size=131072, cid=0 ('default data cache'), Pinned xdes=0x0x000000020925f600, spid=185.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7
Product
SAP Adaptive Server Enterprise 15.7
Keywords
Sybase, ASEServer, SAPASE, dataserver, blocking, zombie, inserttext , 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.
SAP Knowledge Base Article - Preview