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.