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 for Me (Login required).

Search for additional results

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