Symptom
- After applying new patch to the ASE, Repagent failed to start
- The following stacktrace is reported in the error log:
Starting diagnostics for read failure:
Device Information: Device number = 213 Phyname = /dev/lvdev1
Buffer Information: Buf addr = 0x1eef19dcd8, Mass addr = 0x1eef19dbf0 Buf pageno = 965295071, Mass pageno = 965295070, dbid = 7
Buf virtpg = 965295071, Mass virtpg = 8187872 Buf stat = 0x1, Mass stat = 0x44201008 Mass keep = 1, Mass awaited = 0
PAGE DEBUG ELEMENT: buffer state = 3; prior to io ptnid = 0, pagenumber =0; page timestamp lo=0 hi=0; latch requested mode=4, type=0;latch result = 0; number of times searched = 0.
Page Information from first read attempt: Page read from cache ppageno = 965295071,pptnid = -1, pindid = 0 pnextpg = 0, pprevpg = 0 plevel = 0, pstat = 0x0 pts_hi = 67, pts_lo = 12956934
Page Information from second read attempt: Page read from disk ppageno = 965295071,pptnid = -1, pindid = 0 pnextpg = 0, pprevpg = 0 plevel = 0, pstat = 0x0 pts_hi = 67, pts_lo = 12956934
SDES Information: dbid = 7, objid = 8, sptnid = 8 scur.pageid = 965295071 sstat = 0x1, sstat2 = 0x4000000 suid = 1, cacheid = 1
PSS Information: pstat = 0x10000, pcurdb = 7, pspid = 38 p2stat = 0x0, p3stat = 0x800 plasterror = 0, preverror = 0, pattention = 0
End diagnostics for read failure:
pcstkwalk+0x7c()
ucstkgentrace+0x34c()
ucbacktrace+0x184()
wrongpage__print_diagnostic+0x31c()
wrongpage+0xa88()
getpage_with_validation.fdpr.chunk.28+0x794()
apl_getnext.fdpr.chunk.8+0x294()
xsc__syslogs_getnext+0x74()
xls_getnext+0x9c()
rep_agent_thread+0xbe0()
kernel end of stack trace, spid 38, kpid 14090348, suid 0
Run the DBCC command 'dbcc tablealloc' for both the objects, object id = 8, partition id = -1.
- Error 605 is reported in the ASE error log:
Error: 605,Severity: 21, State: 1
An attempt was made to fetch logical page '965295071' from cache 'log_cache'. Page belongs to database 'db1' (7), object '<Unknown>' (0), index '<Unknown>' (0), partition '<Unknown>' (-1) and not to database 'db1' (7), object 'syslogs' (8), index 'syslogs' (0), partition 'syslogs_8' (8).
Rep Agent Thread for database 'db1' (dbid = 7) terminated abnormally with error. (major 0, minor 5)
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 12.5.4
- SAP Adaptive Server Enterprise (ASE) 15.7
- SAP Adaptive Server Enterprise (ASE) 16.0
- SAP Replication Server (RS) 15.7
Product
Keywords
settrunc, wrongpage , KBA , corruption , page corruption , database corruption , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.