Symptom
- Error 820 state 6 during concurrent drop table in tempdb.
- Error 820 state 6 in saptempdb database (or tempdb database) is raised in ASE log file:
Error: 820, Severity: 21, State: 6
Attempt to dirty non-log buffer BUF=0x0x00000002ba1296d8, MASS=0x0x00000002ba1296d8, Buf#=0, page=0x0x000000025a36c000, dbid=6, Mass vdevno=12, vpage=1472, Buf lpage=184, Mass stat=0x5111008, Buf stat=0x1, size=16384, cid=0 ('default data cache'), Pinned xdes=0x0x000000019e6b5580, spid=xx which is in I/O.
WARNING: 1 buffer was found in a predirty state during the termination of spid 251 (Pss: 0x0x00000001d136a658).
kernel ************************************
kernel SQL causing error : insert into saptempdb..DUMP_MONITORCONFIG(Name, Config_val, System_val, Total_val, Num_free, Num_active, Pct_act, Max_Used, Reuse_cnt, Date, Instance_
kernel Current Procedure: sp_monitorconfig
kernel Current statement number: 180 Current line number: 1011
kernel ************************************
server SQL Text: insert into saptempdb..DUMP_MONITORCONFIG(Name, Config_val, System_val, Total_val, Num_free, Num_active, Pct_act, Max_Used, Reuse_cnt, Date, Instance_Name) values('compression info pool size',32768,0,32768,25924,6844, ' 20.89',7009, 0, 'Oct 26 2022 10:00PM' ,'')
pcstkwalk
ucstkgentrace
ucbacktrace
terminate_process
hdl_default
exc__raise
exc_raise
bufpindirty
xls_bufpindirty_single
bufdirty
dol_deldrow
dol_row_delete
dol_delete
row_delete
... ... - The full database dump of saptempdb (or tempdb) is being taken at same time.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition
Keywords
Sybase, ASEServer, SAPASE, dataserver, CR821937, CR#821937, 821937 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.