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.
SAP Knowledge Base Article - Preview