Symptom
- A user database is corrupted with 823 and 694 errors.
- Dropping this corrupted database can lead to timeslice errors and result in corruption of the master database.
- Upon rebooting, the master database is severely corrupted and must be restored from backup.
- A read error message raises in ASE errorlog file when starting ASE server:
Opening Master Database ...
server I/O did not occur, buffer contents are unchanged. Previous page in buffer = 0 Previous ptnid = -1.
server Starting diagnostics for read failure:
server Device Information:
Device number = 0
Phyname = /dev/master.dat
Buffer Information:
Buf addr = 0x6c6e1f630, Mass addr = 0x6c6e1f630
Buf pageno = 0, Mass pageno = 0, dbid = 1
server Buf virtpg = 0, Mass virtpg = 4 Buf stat = 0x1, Mass stat = 0x1008 Mass keep = 1, Mass awaited = 0
server PAGE DEBUG ELEMENT: buffer state = 1d; prior to io ptnid = -1, page number =0; page timestamp lo=0 hi=0; latch requested mode=1, type=32; latch result = 1; number of times searched = 0.
server Page Information from first read attempt: Page read from disk ppageno = 0, pptnid = -1, pindid = 0 pnextpg = 3, pprevpg = 396558336 plevel = 0, pstat = 0x300 pts_hi = 0, pts_lo = 0
server Page Information from second read attempt: Page read from disk ppageno = 0, pptnid = -1, pindid = 0 pnextpg = 3, pprevpg = 396558336 plevel = 0, pstat = 0x300 pts_hi = 0, pts_lo = 0
Read more...
Environment
Adaptive Server Enterprise (ASE)
Product
Keywords
Adaptive Server Enterprise (ASE), CR800733, I/O did not occur, master, buffer contents are unchanged, ppageno = 0, pnextpg = 3, dropping database, dbcc dbrepair , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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