- 论坛徽章:
- 0
|
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. |
|