2542925 - Error 697, Severity21, State 20 - SAP ASE

• ASE errorlog reports an error 697:
  Error: 697, Severity: 21, State: 20
  An attempt was made to fetch logical page '836777' for database 'tempdb' (2), object 'sysobjects' (1), index 'ncsysobjects' (2), partition '<Unknown>' (5) from cache 'tempdbcache'. Wrong logical page '3416902' was found in cache.
• Followed by various diagnostics outputs which may include a stacktrace:
• Output has been truncated for clarity:
  server  Starting diagnostics for read failure:
  Device Information:
        Device number = 100
        Phyname = /dev/ro00
  server  Buffer Information:
        Buf addr = 0x20e4e2dc10, Mass addr = 0x20e4e2dc10
        Buf pageno = 836777, Mass pageno = 836777, dbid = 2
  server  Page Information from first read attempt: Page read from cache ppageno = 3416902, pptnid = 50331710, pindid = 2 pnextpg = -1006632960, pprevpg = 33554432 plevel = 0 ...
  lasterror = 3602, preverror = 0, pattention = 0       --  error 3602 Indicates a transaction rollback, but other or no error can be reported
  
  
• stack trace may include some or all these functions:
  wrongpage__print_diagnostic
  wrongpage
  getpage_with_validation
  xact_rollback

SAP Adaptive Server Enterprise (ASE) All Versions.

Memory, cache, soft error, rollback, corruption, stack trace , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To