2083011 - Recovery fails with sddone, 921, 6103 errors - ASE 15.0.3 ESD#4 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2083011 - Recovery fails with sddone, 921, 6103 errors - ASE 15.0.3 ESD#4

Symptom

On ASE 15.0.3 ESD#4, tempdb fails to recover with sddone errors, user databases recovery fails with errors 921 and 6103 and is accompanied by stacktraces:

  • During the ASE boot sequence, the following problems occur: The tempdb database is not recovered, the user databases are not recovered and the server 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 STHE TACKTRACE:


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 15.0.3 EBF 17769 ESD#4

Product

SAP Adaptive Server Enterprise 15.7

Keywords

tempdb
temporary database
recovery
online

, KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.