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.
SAP Knowledge Base Article - Preview