SAP Knowledge Base Article - Preview

3496547 - Error 820 happened during drop table in tempdb - SAP ASE

Symptom

  • Error 820 state 6 in tempdb database(or saptempdb) is raised in ASE log file

    Error: 820, Severity: 21, State: 6
    Attempt to dirty non-log buffer BUF=0x0x0000000448ea5d30, MASS=0x0x0000000448ea5d30, Buf#=0, page=0x0x0000000409e20000, dbid=2, Mass vdevno=0, vpage=66180, Buf lpage=80, Mass stat=0x5111008, Buf stat=0x1, size=16384, cid=0 ('default data cache'), Pinned xdes=0x(nil), spid=0 which is in I/O.
    WARNING: 1 buffer was found in a predirty state during the termination of spid 99 (Pss: 0x0x00000002d71001b8).
    ************************************
    SQL causing error : SELECT [Parameter_Name]=convert(varchar(29), [Parameter_Name]), [Default_Value]=convert(varchar(13), [Default_Value]), [Config_Value]=convert(varchar(
    Current statement number: 177 Current line number: 613
    ************************************
    SQL Text: DROP TABLE
    curdb = 2 tempdb = 2 pstat = 0x10000 p2stat = 0x40101000
  • The stacktrace has the following functions. 
    bufdirty -> xls_bufpindirty_single -> bufpindirty ->exc_raise ->exc__raise->ptn_handler->hdl_default

  • After Error 820 happened, other sessions which tried to access tempdb were in latch sleep.

    1328 latch sleep DR_admin     DR_admin     NULL                 0 tempdb         tempdb     AWAITING COMMAND
    1329 latch sleep DR_admin     DR_admin     NULL                 0 tempdb         tempdb     AWAITING COMMAND
    1330 latch sleep DR_admin     DR_admin     NULL                 0 tempdb         tempdb     AWAITING COMMAND
    1331 latch sleep DR_admin     DR_admin     NULL                 0 tempdb         tempdb     AWAITING COMMAND

  • The full database dump of tempdb (or saptempdb ) is being taken at same time.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP04 PL05
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR829615, 829615, CR#829615 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.