2618026 - Error 820 Attempt to dirty non-log buffer BUF and stacktrace reported - SAP ASE

• 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

SAP Adaptive Server Enterprise (ASE) 15.7

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