SAP Knowledge Base Article - Preview

3140775 - Error 820 state 6 during concurrent drop table in tempdb - SAP ASE

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.