SAP Knowledge Base Article - Preview

2545989 - logshipping failing with stacktrace - SAP ASE for BS

Symptom

  • load transaction <SID> on DR fails with:

     server  Log contains all committed transactions until YYYY/MM/DD HH:MM:SS.SS for database SID.
     server  Starting diagnostics for read failure:
     server  Device Information:
             Device number = 0
             Phyname = /sybase/SID/sybsystem/master.dat
     server  Buffer Information:
             Buf addr = 0x0x5bb323da0, Mass addr = 0x0x5bb323da0
             Buf pageno = 73, Mass pageno = 73, dbid = 1
     server
             Buf virtpg = 73, Mass virtpg = 588
             Buf stat = 0x1, Mass stat = 0x4001408
             Mass keep = 1, Mass awaited = 0
     server PAGE DEBUG ELEMENT: buffer state = 3;  prior to io ptnid = 0, page number =0;  page timestamp lo=0 hi=0;  latch requested mode=1, type=32;  latch result = 1;  number of times searched = 0.
     server  Page Information from first read attempt: Page read from cache ppageno = 4718692, pptnid = 0, pindid = 0 pnextpg = 339935276, pprevpg = 73 plevel = 0, pstat = 0xa pts_hi = 35391, pts_lo = 0
     server  Page Information from second read attempt: Page read from disk ppageno = 73, pptnid = 30, pindid = 0 pnextpg = 0, pprevpg = 0 plevel = 0, pstat = 0x801 pts_hi = 0, pts_lo = 231999
     server  SDES Information:
             dbid = 1, objid = 30, sptnid = 30 scur.pageid = 73
             sstat = 0x200, sstat2 = 0x20000
             suid = 1, cacheid = 0
     server  SDES Information: scur = (73, 5) physical RID
             sstat3 = 0x2000080, sstat4 = 0x4013000, sstat5 = 0x1000400, sstat6 = 0x0, sstat7 = 0x0
     server  DES Information: name = 'sysdatabases' type = 'S '
             objuserstat = 0x0, objsysstat = 0x61, objsysstat2 = 0x38000, objsysstat3 = 0x0, objsysstat4 = 0x0, objsysstat5 = 0x0
     server  DES properties: ( O_SYSTEM, O_NONCLUST, O2_LOCK_DATAROWS, O2_PLACEMENT )
     server  PSS Information:
             pstat = 0x400200, pcurdb = 31515, pspid = 10
             p2stat = 0x100, p3stat = 0x400800
             plasterror = 0, preverror = 0, pattention = 0
     server  PSS Information:
             p4stat = 0x0, p5stat = 0x0, p6stat = 0x400, p7stat = 0x0, p8stat = 0x8000000
             pcurcmd = 235 ('DUMP TRANSACTION'), pcmderrs = 0x0
     server  End diagnostics for read failure:

  • function calls on top of the stack:
    • wrongpage__print_diagnostic
    • wrongpage
    • getpage_with_validation
    • dol_bt_getnext
    • getnext
    • sdes_scan_setup
    • ckpt_chores


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP NetWeaver (NW) - All versions 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions

Keywords

sybase, log shipping, dmpx_truncatemain, ckpt_process_dbs, release_compiler_scratch_space , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To

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.