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
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.