2146883 - Database recovery fails with stacktrace followed by Error 804 and 834 after loading 15.0.3 dump - SAP ASE 15.5 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2146883 - Database recovery fails with stacktrace followed by Error 804 and 834 after loading 15.0.3 dump - SAP ASE 15.5

Symptom

  • Loaded a database dump taken on ASE 15.0.3 ESD#1 to a target ASE 15.5 server.
  • The target SE server is not able to recover all the databases.
  • A repeated stacktrace on spid 1 is reported to the ASE error log:

Invalid DOL data row pointer: row 0 with status 0x1 must be the forwarded row location instead of the home row location.
[..]
des_fillobjcache
des__fillcache
des__instantiate_sysdes
des__init_base_tables
des__bootsystables
des_sysbuild
db_fill
dbt(float, int, long, long)
dbt_get
dbt_get_with_statuscheck
dbcontext_change
usedb
ra_online_rep_agents
dsinit

  • Errors 804 and 834 is reported in the ASE error log

Error: 804, Severity: 20, State: 1
Unable to find buffer '0x1139456288' from cache 'default data cache' holding logical page '169' in sdes '0x1de1f2eb0' kept buffer pool for object ''.

Error: 834, Severity: 20, State: 4
Illegal attempt to clean buffer: BUF=0x0x00000012011f6cc8, MASS=0x0x00000012011f6cc8, Buf#=0, page=0x0x0000000b675c6000, dbid=7,
Mass vdevno=47, vpage=1515637, Buf lpage=1515637, Mass stat=0x1008, Buf stat=0x1, size=2048, cid=0 ('default data cache'), Pinned xdes=0x(nil), spid=0.

  • ASE configuration "enable rep agent threads = 1" is set.
  • The spid 1 that caused the stacktrace might also be holding a lock:
1> sp_lock 
2> go
The class column will display the cursor name for locks associated with
a cursor for the current user and the cursor id for other users.
 fid    spid   loid        locktype                     table_id    page  row    dbname class
 ------ ------ ----------- ---------------------------- ----------- ----- ------ ------ ---------------
      0      1           2 Sh_intent                             30     0      0 master Non Cursor Lock
      0      1           2 Sh_row                                30   169     10 master Non Cursor Lock

(2 rows affected, return status = 0)

Read more...

Environment

SAP/Sybase Adaptive Server Enterprise (ASE) 15.5 ESD #3

Product

Sybase Adaptive Server Enterprise 15.5

Keywords

corruption, dbcc, sysdatabases, dbrepair, dropdb , KBA , database corruption , 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.