SAP Knowledge Base Article - Preview

2083011 - Tempdb recovery fails with sddone, 823, user db fails with 921, 6103 errors and stacktrace - SAP ASE

Symptom

During the ASE boot sequence, tempdb fails to recover with sddone errors, user database recovery fails with errors 921 and 6103 and is accompanied by stacktraces:

  • The  ASE log contains the following error messages:

    • Clearing temp db
      Processed 1045 allocation unit(s) out of 10448 units (allocation page 267264). 10% completed.
      Processed 2090 allocation unit(s) out of 10448 units (allocation page 534784). 20% completed

      sddone: write error on virtual disk 12 block 36096:
      sddone: No such device or address

      Error: 823, Severity: 24, State: 2
      I/O error detected during wait for BUF=0x000001006874a270, MASS=0x000001006874a270, Buf#=0, page=0x0000010061532000, dbid=2, Mass vdevno=12, vpage=36096, Buf lpage=0, Mass stat=0x80908, Buf stat=0x1, size=2048, cid=0 ('default data cache'), Pinned xdes=0x0000000000000000, spid=0.

    • Error: 921, Severity: 14, State: 1
      Database 'XXXX' has not been recovered yet - please wait and try again.

    • WARNING: Pss 0x000001001207f2c8 found with open sdes. pspid 1, psuid 0, pcurdb 1, system table entry 0, sdesp 0x0000010010ac1790, objid 1.

    • Error: 6103, Severity: 17, State: 1
      Unable to do cleanup for the killed process; received Msg 823.
      Current process (0x2d60116) infected with signal 11 (SIGSEGV)
      Address 0x0000000080b9a62c (alloc_dirtychains+0x28), siginfo (code, address) = (1, 0x0000000000004458)

  • KEY FUNCTIONS REFERENCED IN THE STACKTRACE:


alloc_dirtychain
des*LeWkTbl::CreateNewDES(proc_hdr*,LeDataRow*,short,int,short,int,LeSortKey*)
LeWkTbl::crtWkTbl(const int,const short,const int)
LeHashContext::acquire(ExeCtxt&)
LeRetnCode LeHashOp::_LeOpAcquire(ExeCtxt&)
LeRetnCode LeNLJOp::_LeOpAcquire(ExeCtxt&)
LeRetnCode LeSortOp::_LeOpAcquire(ExeCtxt&
LeRetnCode LeSQFilterOp::_LeOpAcquire(ExeCtxt&)
LeRetnCode LeRestrictOp::_LeOpAcquire(ExeCtxt&)


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

infected fake sysprocesses online , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , 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.