Symptom
- On SAP ASE systems running custom (non-SAP) applications, a read failure error was reported in the ASE errorlog.
NOTE: For systems running SAP applications see SAP KBA 2243660 - How to fix repair and rebuild a corrupt table - SAP ASE for Business Suite
server Starting diagnostics for read failure:
server Device Information:
Device number = 7
Phyname = /dev/datadev_02
server Buffer Information:
Buf addr = 0x10054d16778, Mass addr = 0x10054d16778
Buf pageno = 1994188, Mass pageno = 1994188, dbid = 4
server
Buf virtpg = 1994188, Mass virtpg = 945612
Buf stat = 0x1, Mass stat = 0x1008
Mass keep = 1, Mass awaited = 0
server Page Information from first read attempt: Page read from disk ppageno = 1994188, pptnid = 245572882, pindid = 0 pnextpg = 1994175, pprevpg = 1994055 plevel = 0, pstat = 0x11 pts_hi = 1, pts_lo = 488777306
server Page Information from second read attempt: Page read from disk ppageno = 1994188, pptnid = 245572882, pindid = 0 pnextpg = 1994175, pprevpg = 1994055 plevel = 0, pstat = 0x11 pts_hi = 1, pts_lo = 488777306
server SDES Information:
dbid = 4, objid = 1008003591, sptnid = 1008003591 scur.pageid = 1994188
sstat = 0x0, sstat2 = 0x20
suid = 1, cacheid = 0
server PSS Information:
pstat = 0x10100, pcurdb = 4, pspid = 21
p2stat = 0x1000, p3stat = 0x800
plasterror = 0, preverror = 0, pattention = 0
server End diagnostics for read failure:
- It was followed by a stacktrace that inluded functions:
wrongpage__print_diagnostic
wrongpage
_$o1cexoH0.getpage_with_validation
ncinsert
_$o1cexzK0.ins_insert
- And resulted in Error 605:
server Run the DBCC command 'dbcc tablealloc' for both the objects, object id = 1008003591, partition id = 245572882.server
Error: 605, Severity: 21, State: 1
server An attempt was made to fetch logical page '1994188' from cache 'default data cache'. Page belongs to database 'xxxxx' (4), object 'xxxxx' (245572882), index '<Unknown>' (0), partition 'xxxxx_245572882' (245572882) and not to database 'xxxxx' (4), object 'xxxxx' (1008003591), index 'xxxxx' (0), partition 'xxxxx_1008003591' (1008003591).
Read more...
Environment
SAP Adaptive Server Enterprise (ASE). Not version specific.
Product
Keywords
corruption, syspartitions, object_name, checktable, checkdb, checkalloc, tablealloc, transient, hardware, severe error, different sort order, system error, restore, crash, object, full extent, configuration block, sort order , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.