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
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.