2545989 - logshipping failing with stacktrace - SAP ASE for BS | SAP Knowledge Base Article

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 , SAP Business Suite on Sybase ASE Database Platform , How To

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.