Symptom
- ASE error 806 during recovery or process rollback:
server Error: 806, Severity: 21, State: 1
server Could not find virtual page for logical page 4166563343 in database 'mydb'. - Error 806 followed by stack trace
- Database marked suspect on recovery
- Page signing (new feature introduced in ASE 15.7 SP130) is enabled
- Other errors such as 6103 may be reported along with the 806 error and stack trace:
server Error: 21, Severity: 21, State: 1
server WARNING - Fatal Error 806 occurred at Oct 29 2014 12:42PM. Please note the error and time, and contact a user with System Administrator (SA) authorization.
server Error: 806, Severity: 21, State: 1
server Could not find virtual page for logical page 4166563343 in database 'mydb'.
server Error while undoing log row in database 'mydb'. Rid pageid = 0x0; row num = 0x0.
server WARNING: Pss 0x0x000000017a9b7cf0 found with open sdes. pspid 212, psuid 6, pcurdb 4, range entry 0, sdesp 0x0x0000000170d13d30, objid 1700000460.
server Error: 6103, Severity: 17, State: 1
server Unable to do cleanup for the killed process; received Msg 3300.
server WARNING: spid 212 with suid 6 and curdbid 4 has an active transaction in dbid 4 with xactid (23095870, 81). - 806 error can occurs during normal rollback processing
- ASE continues processing
- Subsequent database recovery fails with error 806 again
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 SP130
- SAP Adaptive Server Enterprise (ASE) 15.7 SP131
Product
SAP Adaptive Server Enterprise 15.7
Keywords
KBA , page corruption , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
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.