Symptom
- Loaded a database dump taken on ASE 15.0.3 ESD#1 to a target ASE 15.5 server.
- The target ASE 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
Keywords
corruption, dbcc, sysdatabases, dbrepair, dropdb, Error: 804, Error: 834 , 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.
SAP Knowledge Base Article - Preview