1961125 - How to fix a table with 605 errors - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1961125 - How to fix a table with 605 errors - SAP ASE

Symptom

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

SAP Adaptive Server Enterprise all versions

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.