Symptom
- Application generates an insert using dynamic sql:
SQL Text: insert into <table> (<col1>, <col2>, <col3>, <col4>, <col4>, <col6>, <col6>, <col7>, <uncompressedXml_file>, <compressedXml_file>, <col8>, <col9>, <col10>, <col11>, <col12>, <col13>) values (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15)?
00:0012:00000:00549:2018/03/05 11:20:15.34 server SQL Text: insert into msInstance (<col1>, <col2>, <col3>, <col4>, <col5>, <col6>, <col7>, >col8>, <uncompressedXml_file>, <compressedXml_file>, <col9>, <col10>, <col11>, <col12>, <col13>, <col14>) values (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15)
-
820 error reported in ASE error log:
Error: 820, Severity: 21, State: 6
Attempt to dirty non-log buffer BUF=0x0x00002abbb96817d0, MASS=0x0x00002abbb9681500, Buf#=3, page=0x0x00002ab730aab000, dbid=7, Mass vdevno=111, vpage=19108040, Buf lpage=554967243, Mass stat=0x5111008, Buf stat=0x1, size=16384, cid=0 ('default data cache'), Pinned xdes=0x(nil), spid=0 which is in I/O.
-
The following stack is reported:
text_handler
exc__raise
exc_raise
bufpindirty
xls_bufpindirty
bufdirty
pg__getpgbuf
pg__allocate_completion
pg__allocate_near_target
pg__allocate
pg_allocate
alloctext
inserttext
instext
insert_all
- Application hangs due to stack trace and 820 error
- No phantom processes or locks reported
- Only way to restart application insert is to restart ASE
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7
Product
Keywords
kisignal, stacktrace, stack, registers, server not accesible, server crash, process in latch_sleep , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.