标题: 我的sybase数据库每天报同样的错，请教各位大侠怎么解决？ [打印本页] 作者: neo_lin 时间: 2005-03-15 16:06 标题: 我的sybase数据库每天报同样的错，请教各位大侠怎么解决？ 00:00000:00042:2005/03/12 03:10:03.68 server Checking space allocation for database 1
00:00000:00042:2005/03/12 03:10:03.68 server DBCC TRACEON 3605, SPID 42
00:00000:00042:2005/03/12 03:10:05.94 server DBCC TRACEOFF 3605, SPID 42
00:00000:00042:2005/03/12 03:10:24.69 server Starting diagnostics for read failure:
00:00000:00042:2005/03/12 03:10:24.69 server Device Information:
Device number = 2
Phyname = /data/news.dat
00:00000:00042:2005/03/12 03:10:24.69 server Buffer Information:
Buf addr = 0xfd6b0dc8, Mass addr = 0xfd6b0dc8
Buf pageno = 126781, Mass pageno = 126781, dbid = 4
00:00000:00042:2005/03/12 03:10:24.69 server
Buf virtpg = 33681213, Mass virtpg = 33681213
Buf stat = 0x1, Mass stat = 0x1008
Mass keep = 1, Mass awaited = 0
00:00000:00042:2005/03/12 03:10:24.69 server Page Information from first read attempt:
Page read from disk
ppageno = 126953, pobjid = 624005254, pindid = 255
pnextpg = 128739, pprevpg = 0
plevel = 251, pstat = 0x4030
pts_hi = 1, pts_lo = 42209598
00:00000:00042:2005/03/12 03:10:24.69 server Page Information from second read attempt:
Page read from disk
ppageno = 126953, pobjid = 624005254, pindid = 255
pnextpg = 128739, pprevpg = 0
plevel = 251, pstat = 0x4030
pts_hi = 1, pts_lo = 42209598
00:00000:00042:2005/03/12 03:10:24.69 server SDES Information:
dbid = 4, objid = 624005254, scur.pageid = 126781
sstat = 0x0, sstat2 = 0x800
suid = 1, cacheid = 0
00:00000:00042:2005/03/12 03:10:24.69 server PSS Information:
pstat = 0x10000, pcurdb = 4, pspid = 42
p2stat = 0x1000, p3stat = 0x81a
plasterror = 0, preverror = 0, pattention = 0
00:00000:00042:2005/03/12 03:10:24.69 server End diagnostics for read failure:
00:00000:00042:2005/03/12 03:10:25.21 server Bufunhash: Buffer 0xfd6b0dc8 from database id 4 has page number 126953
in the page header and page number 126781 in the buffer header. Buffer will be unhashed,
no action is necessary. Printing headers for diagnostics:
00:00000:00042:2005/03/12 03:10:25.21 server Mass: 0xfd6b0dc8 Buffer: 0xfd6b0dc8 Mass pageno: 126781
-Mass virtpg: 33681213 dbid: 4 Mass stat: 0x1010
-Buffer pageno: 126781 Buffer virtpg: 33681213 Buf stat: 0x1 keep: 0 awaited: 0 tripsleft: 0
-bpage: 0xfc319800 flushseq: 0 dirty seq: 0 filthyseq: 0 linked: ( lru)
00:00000:00042:2005/03/12 03:10:25.21 server Page: 0xfc319800 pageno: 126953 objid: 624005254 indid: 255
- nextpg: 128739 prevpg: 0 pstat: 0x4030 ts: (1, 4220959 nextrno: 32
- freeoff: 1832 minlen: 0 level: 251
00:00000:00042:2005/03/12 03:10:37.96 server Checking space allocation for database 4
00:00000:00042:2005/03/12 03:10:37.96 server DBCC TRACEON 3605, SPID 42
00:00000:00042:2005/03/12 03:13:35.36 server DBCC TRACEOFF 3605, SPID 42
00:00000:00021:2005/03/12 05:34:03.22 server Starting diagnostics for read failure:
00:00000:00021:2005/03/12 05:34:03.23 server Device Information:
Device number = 2
Phyname = /data/news.dat
00:00000:00021:2005/03/12 05:34:03.23 server Buffer Information:
Buf addr = 0xfd2ded80, Mass addr = 0xfd2ded80
Buf pageno = 126782, Mass pageno = 126782, dbid = 4
00:00000:00021:2005/03/12 05:34:03.23 server
Buf virtpg = 33681214, Mass virtpg = 33681214
Buf stat = 0x1, Mass stat = 0x44001008
Mass keep = 1, Mass awaited = 0
00:00000:00021:2005/03/12 05:34:03.23 server Page Information from first read attempt:
Page read from cache
ppageno = 126954, pobjid = 624005254, pindid = 255
pnextpg = 0, pprevpg = 0
plevel = 250, pstat = 0x4030
pts_hi = 1, pts_lo = 42238425
00:00000:00021:2005/03/12 05:34:03.23 server Page Information from second read attempt:
Page read from disk
ppageno = 126954, pobjid = 624005254, pindid = 255
pnextpg = 0, pprevpg = 0
plevel = 250, pstat = 0x4030
pts_hi = 1, pts_lo = 42238425
00:00000:00021:2005/03/12 05:34:03.23 server SDES Information:
dbid = 4, objid = 624005254, scur.pageid = 126782
sstat = 0x20000c0, sstat2 = 0x240020
suid = 1, cacheid = 0
00:00000:00021:2005/03/12 05:34:03.23 server PSS Information:
pstat = 0x10100, pcurdb = 4, pspid = 21
p2stat = 0x1001000, p3stat = 0x81a
plasterror = 0, preverror = 0, pattention = 0
00:00000:00021:2005/03/12 05:34:03.23 server End diagnostics for read failure:
00:00000:00021:2005/03/12 05:34:03.23 server Error: 697, Severity: 21, State: 1
00:00000:00021:2005/03/12 05:34:03.23 server An attempt was made to fetch logical page '126782' for object '624005254' in database '4' from cache 'default data cache'. Wrong logical page '126954' was found in cache.作者: 赛北之狼 时间: 2005-03-15 16:18 标题: 我的sybase数据库每天报同样的错，请教各位大侠怎么解决？ dbcc checkalloc 数据库id＝4 一把后再试试作者: hobbylu 时间: 2005-03-15 16:49 标题: 我的sybase数据库每天报同样的错，请教各位大侠怎么解决？ 你的硬件可能有问题,需要警惕了作者: ZealeS 时间: 2005-03-15 22:59 标题: 我的sybase数据库每天报同样的错，请教各位大侠怎么解决？ Wrong logical page '%ld' was found in cache.
This error occurs when Adaptive Server tries to access an object in cache but arrives at an invalid page. The page number is correct on disk, but it does not match the page number of the page in memory.
Error 697 results in a stack trace and breaks your connection to Adaptive Server.作者: jtyhyl 时间: 2005-03-16 16:44 标题: 我的sybase数据库每天报同样的错，请教各位大侠怎么解决？ [quote]原帖由 "hobbylu"]你的硬件可能有问题,需要警惕了[/quote 发表：
nextrno: 32