- A read failure error was reported in the ASE errorlog:
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
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:
- 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).
SAP Adaptive Server Enterprise (ASE). Not version specific.
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 pageThis 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.