SAP Knowledge Base Article - Preview

2542925 - Error: 697, Severity: 21, State: 1

Symptom

  • ASE stacktraced while an object was being dropped in a user defined tempdb
     
  • A rollback was triggered during the drop
     
  • The error and stacktrace occurred when it tried to get the wrong page from cache   
     
  • server  Error: 697, Severity: 21, State: 1
    An attempt was made to fetch logical page '836777' for database 'tempdb02' (13), object 'sysobjects' (1), index 'ncsysobjects' (2), partition '<Unknown>' (5) from cache 'tempdbcache'. Wrong logical page '3416902' was found in cache.
    server  Starting diagnostics for read failure:
    Device Information:
          Device number = 103
          Phyname = /dev/ro03
    server  Buffer Information:
          Buf addr = 0x20e4e2dc10, Mass addr = 0x20e4e2dc10
          Buf pageno = 836777, Mass pageno = 836777, dbid = 13
    server
          Buf virtpg = 836777, Mass virtpg = 836779
          Buf stat = 0x1, Mass stat = 0x4011008
          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=2, type=32;  latch result = 1;  number of times searched = 0.
    server  Page Information from first read attempt: Page read from cache ppageno = 3416902, pptnid = 50331710, pindid = 2 pnextpg = -1006632960, pprevpg = 33554432 plevel = 0, pstat = 0x802 pts_hi = 2, pts_lo = 675089255, tail ts = 2919
    server  Page Information from second read attempt: Page read from disk ppageno = 836777, pptnid = 5, pindid = 2 pnextpg = 484123, pprevpg = 484214 plevel = 0, pstat = 0x802 pts_hi = 2, pts_lo = 351618511, tail ts = 17871
    server  SDES Information:
          dbid = 13, objid = 5, sptnid = 5 scur.pageid = 836777
          sstat = 0x0, sstat2 = 0x0
          suid = 1, cacheid = 5
    server  PSS Information:
          pstat = 0x58002, pcurdb = 6, pspid = 5653
          p2stat = 0x1000, p3stat = 0x10800
          plasterror = 3602, preverror = 0, pattention = 0        <<< Indicates a transaction rollback
    server  End diagnostics for read failure:
    kernel  pc: 0x0000000100026c54 pcstkwalk+0x654()
    kernel  pc: 0x0000000100025dc8 ucstkgentrace+0x178()
    kernel  pc: 0x00000001000251f8 ucbacktrace+0xa8()
    kernel  pc: 0x0000000100366f4c wrongpage__print_diagnostic+0x26c()
    kernel  pc: 0x0000000100364050 wrongpage+0x328()
    kernel  pc: 0x00000001003612d4 getpage_with_validation.fdpr.chunk
    kernel  pc: 0x0000000100663c78 bt__getchildlatched+0x2b4()
    kernel  pc: 0x00000001006636f0 bt__traverse+0x3b8()
    kernel  pc: 0x00000001006cb86c bt__undo_leafinsdel+0x230()
    kernel  pc: 0x00000001006cede0 undo_bt_insdel+0x74()
    kernel  [Handler pc: 0x000000010185a074 getdoerr installed by the following function:-]
    kernel  pc: 0x00000001006cf138 rec_undo_session.fdpr.chunk.3+0x2bc()
    kernel  pc: 0x00000001006d2824 abort__all@AF6_2+0x58()
    kernel  pc: 0x00000001006d24c8 xact__rollbackxact+0x334()
    kernel  pc: 0x00000001006d20ec xact__rollback_local+0x40()
    kernel  pc: 0x00000001006d2018 IPRA.$xact_rollback+0x214()
    kernel  pc: 0x00000001006d1dbc xact_rollback+0x60()
    kernel  [Handler pc: 0x00000001007994f0 droperr installed by the following function:-]
    kernel  pc: 0x0000000100bb4e48 dropo.fdpr.chunk.15+0x5c()
    kernel  pc: 0x00000001007b3490 dropobject+0x104()
    kernel  [Handler pc: 0x0000000100799e3c hdl_backout installed by the following function:-]
    kernel  pc: 0x00000001007b333c s_execute.fdpr.chunk.74+0xc()
    kernel  [Handler pc: 0x0000000100799f24 hdl_stack installed by the following function:-]
    kernel  [Handler pc: 0x00000001007e175c s_handle installed by the following function:-]
    kernel  pc: 0x00000001006221e0 sequencer+0x480()
    kernel  pc: 0x0000000100695950 execproc+0x450()
    kernel  pc: 0x00000001006e4f6c s_execute.fdpr.chunk.48+0xcc()
    kernel  [Handler pc: 0x0000000100799f24 hdl_stack installed by the following function:-]
    kernel  [Handler pc: 0x00000001007e175c s_handle installed by the following function:-]
    kernel  pc: 0x00000001006221e0 sequencer+0x480()
    kernel  pc: 0x00000001007213ac tdsrecv_language+0x258()
    kernel  [Handler pc: 0x00000001007dc978 ut_handle installed by the following function:-]
    kernel  pc: 0x0000000100720fa8 conn_hdlr.fdpr.chunk.12+0xc4()
    kernel  end of stack trace, spid 5653, kpid 1781861251, suid 61

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 SP136

Product

SAP Adaptive Server Enterprise 15.7

Keywords

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

Search for additional results

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