- 论坛徽章:
- 0
|
数据库经常报下面这个错误,是什么原因?
每次都是把表DROP掉之后,重新建表,风险实在太大。
求高人解答!!!
00:00000:00040:2015/04/27 20:25:03.43 server WARNING: ***************************
00:00000:00069:2015/04/28 15:48:35.45 server Starting diagnostics for read failure:
00:00000:00069:2015/04/28 15:48:35.45 server Device Information:
Device number = 7
Phyname = /home/sybase/data/opdbdev1.dat
00:00000:00069:2015/04/28 15:48:35.45 server Buffer Information:
Buf addr = 0x0xb6eb6b50, Mass addr = 0x0xb6eb6b50
Buf pageno = 185358, Mass pageno = 185358, dbid = 6
00:00000:00069:2015/04/28 15:48:35.47 server
Buf virtpg = 118181944, Mass virtpg = 118181944
Buf stat = 0x1, Mass stat = 0x1008
Mass keep = 1, Mass awaited = 0
00:00000:00069:2015/04/28 15:48:35.47 server Page Information from first read attempt: Page read from cache ppageno = 960648, pobjid = 219144795, pindid = 2 pnextpg = 960696, pprevpg = 957326 plevel = 0, pstat = 0x82 pts_hi = 0, pts_lo = 129649782
00:00000:00069:2015/04/28 15:48:35.47 server Page Information from second read attempt: Page read from disk ppageno = 960648, pobjid = 219144795, pindid = 2 pnextpg = 960696, pprevpg = 957326 plevel = 0, pstat = 0x82 pts_hi = 0, pts_lo = 129649782
00:00000:00069:2015/04/28 15:48:35.47 server SDES Information:
dbid = 6, objid = 2091151464, scur.pageid = 185358
sstat = 0x2002040, sstat2 = 0x20020
suid = 3, cacheid = 0
00:00000:00069:2015/04/28 15:48:35.47 server PSS Information:
pstat = 0x10000, pcurdb = 6, pspid = 69
p2stat = 0x1000, p3stat = 0x81a
plasterror = 0, preverror = 0, pattention = 0
00:00000:00069:2015/04/28 15:48:35.49 server End diagnostics for read failure:
00:00000:00069:2015/04/28 15:48:35.49 server Error: 697, Severity: 21, State: 7
00:00000:00069:2015/04/28 15:48:35.49 server An attempt was made to fetch logical page '185358' for object '2091151464' in database '6' from cache 'default data cache'. Wrong logical page '960648' was found in cache. |
|