- 论坛徽章:
- 0
|
00:05/08/01 08:15:56.04 server Starting diagnostics for read failure:
00:05/08/01 08:15:56.05 server Device Information:
Device number = 6
Phyname = /dev/sybdata3
00:05/08/01 08:15:56.05 server Buffer Information:
Buf addr = 0xb5c64c00, Mass addr = 0xb5c64c00
Buf pageno = 4714, Mass pageno = 4714, dbid = 2
00:05/08/01 08:15:56.05 server
Buf virtpg = 100666986, Mass virtpg = 100666986
Buf stat = 0x1, Mass stat = 0x1008
Mass keep = 1, Mass awaited = 0
00:05/08/01 08:15:56.05 server Page Information from first read attempt:
Page read from disk
ppageno = 4714, pobjid = 1744725268, pindid = 0
pnextpg = 4715, pprevpg = 0
plevel = 0, pstat = 0x111
pts_hi = 1, pts_lo = 28626661
00:05/08/01 08:15:56.05 server Page Information from second read attempt:
Page read from disk
ppageno = 4714, pobjid = 1744725268, pindid = 0
pnextpg = 4715, pprevpg = 0
plevel = 0, pstat = 0x111
pts_hi = 1, pts_lo = 28626661
00:05/08/01 08:15:56.07 server SDES Information:
dbid = 2, objid = 1, scur.pageid = 4714
sstat = 0x1d0, sstat2 = 0x0
suid = 2, cacheid = 0
00:05/08/01 08:15:56.07 server PSS Information:
pstat = 0x10000, pcurdb = 2, pspid = 33
p2stat = 0x1000, p3stat = 0x0
plasterror = 0, preverror = 3701, pattention = 0
00:05/08/01 08:15:56.07 server End diagnostics for read failure:
00:05/08/01 08:15:56.07 server Error: 696, Severity: 21, State: 1
00:05/08/01 08:15:56.07 server An attempt was made to fetch logical page '4714' in tempdb from cache 'default data cache'. Page belongs to object '1744725268' and not to object '1'. Restart of SQL Server will clear the error. Please contact your System Administrator for help.
00:05/08/01 08:15:56.07 kernel ************************************
00:05/08/01 08:15:56.07 kernel SQL causing error : 0, F_JEE u001 default 0, F_SLF u001 default 0, F_JEF u001 default 0, F_SLG u001 default 0, F_JEG u001 default 0, F_SLH u001 default 0, F
00:05/08/01 08:15:56.07 kernel curdb = 2 pstat = 0x10000 lasterror = 696
00:05/08/01 08:15:56.07 kernel preverror = 3701 transtate = 0
00:05/08/01 08:15:56.07 kernel curcmd = 198 program =
00:05/08/01 08:15:56.09 kernel pc: 0x2e4b85 ucbacktrace+0x55(0x0,0x1,0x803de5c0,0x1,0x60)
00:05/08/01 08:15:56.09 kernel pc: 0x27bf terminate_process+0x33f(0x0,0xffffffff,0x803de564,0xf0c93,0x803de5c0)
00:05/08/01 08:15:56.09 kernel pc: 0xf0d60 close_network+0x10(0x803de5c0,0x0,0x803de58c,0xe261f,0x6)
00:05/08/01 08:15:56.09 kernel pc: 0xf0c93 hdl_default+0x23(0x6,0x60,0x15,0x1,0x803de5c0)
00:05/08/01 08:15:56.09 kernel pc: 0xe261f s_handle+0x5af(0x6,0x60,0x15,0x1,0x803de5c0)
00:05/08/01 08:15:56.09 kernel pc: 0xf0b8d ex_raise+0x17d(0x6,0x60,0x15,0x1,0x126a)
00:05/08/01 08:15:56.09 kernel pc: 0x1c9a86 wrongpage___3+0x30a(0x0,0x803de61c,0x803de75c,0x1,0xffa5fff0)
00:05/08/01 08:15:56.09 kernel pc: 0x1c8e20 getpage___1+0x4ac(0x81337008,0x1,0x81337008,0x64,0x803de98c)
00:05/08/01 08:15:56.09 kernel pc: 0x1cda9b cinsert___1+0xff(0x803de9a4,0x1cd478,0x80dda130,0x803de98c,0x1)
00:05/08/01 08:15:56.09 kernel pc: 0x1cd4cb insert+0x14b(0x81337008,0x803dea30,0x64,0x0,0x0)
00:05/08/01 08:15:56.09 kernel [Handler pc: 0x173a30 ut_handle(num=2700, sev=0) installed by the following function]
00:05/08/01 08:15:56.10 kernel pc: 0x15ab29 obj_newrow+0x4a9(0x80dda130,0x803def10,0x5,0x1000,0x0)
00:05/08/01 08:15:56.10 kernel [Handler pc: 0x173a30 ut_handle(num=1700, sev=0) installed by the following function]
00:05/08/01 08:15:56.10 kernel [Handler pc: 0x173a30 ut_handle(num=4500, sev=0) installed by the following function]
00:05/08/01 08:15:56.10 kernel [Handler pc: 0x173a30 ut_handle(num=2100, sev=0) installed by the following function]
00:05/08/01 08:15:56.10 kernel [Handler pc: 0x173a30 ut_handle(num=2000, sev=0) installed by the following function]
00:05/08/01 08:15:56.10 kernel [Handler pc: 0x173a30 ut_handle(num=2700, sev=0) installed by the following function]
00:05/08/01 08:15:56.10 kernel [Handler pc: 0x173a30 ut_handle(num=2812, sev=0) installed by the following function]
00:05/08/01 08:15:56.10 kernel pc: 0x15dcf9 proccreate+0x2679(0x803df36c,0x5,0x0,0x8253c028,0x803df456)
00:05/08/01 08:15:56.10 kernel [Handler pc: 0x173a30 ut_handle(num=2700, sev=0) installed by the following function]
00:05/08/01 08:15:56.10 kernel [Handler pc: 0x173a30 ut_handle(num=1700, sev=0) installed by the following function]
00:05/08/01 08:15:56.10 kernel pc: 0x12dc77 crc_ckconstr+0x2e7(0x80dda130,0x80ef4c70,0x8253c09c,0x82653454,0x10)
00:05/08/01 08:15:56.10 kernel pc: 0x13db6c crt_constr___1+0x160(0x803e0fcc,0x13b4f7,0x81dff0a4,0x1,0x0)
00:05/08/01 08:15:56.10 kernel [Handler pc: 0x173a30 ut_handle(num=2700, sev=0) installed by the following function]
00:05/08/01 08:15:56.10 kernel [Handler pc: 0x173a30 ut_handle(num=8400, sev=0) installed by the following function]
00:05/08/01 08:15:56.10 kernel [Handler pc: 0x173a30 ut_handle(num=8200, sev=0) installed by the following function]
00:05/08/01 08:15:56.10 kernel [Handler pc: 0x173a30 ut_handle(num=1700, sev=0) installed by the following function]
00:05/08/01 08:15:56.10 kernel pc: 0x13b74d crt_main+0x1d6d(0x803e1040,0xd5645,0xffff00ff,0x81336d90,0x1)
00:05/08/01 08:15:56.10 kernel pc: 0xd6e6f s_execute+0x1b4f(0x81336d90,0x81336d90,0x803e1144,0x0,0x825ec800)
00:05/08/01 08:15:56.10 kernel [Handler pc: 0xe2070 s_handle(num=0, sev=0) installed by the following function]
00:05/08/01 08:15:56.10 kernel pc: 0xdfa70 sequencer+0xc70(0x8252a000,0x290c33,0xffffffff,0x4,0x80)
00:05/08/01 08:15:56.10 kernel pc: 0x21ff4f tdsrecv_language+0x31f(0x0,0x1,0x0,0x0,0x0)
00:05/08/01 08:15:56.10 kernel [Handler pc: 0xf0c50 hdl_backout(num=3600, sev=25) installed by the following function]
00:05/08/01 08:15:56.10 kernel [Handler pc: 0x173a30 ut_handle(num=700, sev=0) installed by the following function]
00:05/08/01 08:15:56.10 kernel pc: 0x20b3a6 conn_hdlr+0x16b6(0x1c,0x803e1440,0x6a006a,0x0,0x0)
00:05/08/01 08:15:56.10 kernel pc: 0x2f8e30 kpexit(0x0,0x0,0x5374616b,0x0,0x0)
00:05/08/01 08:15:56.10 kernel pc: 0x6a006a frexp+0x346236(0x5374616b,0x0,0x0,0x0,0x0)
00:05/08/01 08:15:56.10 kernel end of stack trace, spid 33, kpid 1076232290, suid 10
00:05/08/01 08:15:56.10 server Error: 21, Severity: 26, State: 1
00:05/08/01 08:15:56.10 server WARNING - Fatal Error 8201 occurred at Aug 1 2005 8:15AM. Please note the error and time, and contact a user with System Administrator (SA) authorization.
00:05/08/01 08:15:56.11 server Error: 8201, Severity: 26, State: 4
00:05/08/01 08:15:56.11 server Keep count of descriptor was expected to be 1. Instead 2 was found
00:05/08/01 08:15:56.11 server Error while undoing log row in database 'tempdb'. Rid pageid = 0x1cc41; row num = 0x13.
LOG SCAN DEFINTION:
Database id : 2
Forward scan: starting at begining of log
Log records for session id (117824,10)
LOG RECORDS:
BEGINXACT (117824,10)
attcnt=1 rno=10 op=0 padlen=0 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
masterxsid=(empty)
xstat=XBEG_ENDXACT,
spid=33 suid=10 uid=2 masterdbid=0 mastersite=0
name=#CH_CLZDMXCX000000330008635362 time=Aug 1 2005 8:15AM
INSERT (117824,11)
attcnt=1 rno=11 op=4 padlen=1 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=863 status=0x00 cid=0
old ts=0x0001 0x01b3bc1f new ts=0x0001 0x01b533c7
xrow:
b3793410: 010c0000 9d649d04 01082709 ffff0100 00000000 .....d....'.........
b3793424: 00000000 2300465f 434c4e4d 02201a ....#.F_CLNM. ..
INSERT (117824,12)
attcnt=1 rno=12 op=4 padlen=1 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=898 status=0x00 cid=0
old ts=0x0001 0x01b533c7 new ts=0x0001 0x01b533c8
xrow:
b3793464: 010d0000 9d649d04 0208271e feff0200 00000000 .....d....'.........
b3793478: 00000000 2300465f 434c4248 02201a ....#.F_CLBH. .2
INSERT (117824,13)
attcnt=1 rno=13 op=4 padlen=1 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=933 status=0x00 cid=0
old ts=0x0001 0x01b533c8 new ts=0x0001 0x01b533c9
xrow:
b37934b8: 010e0000 9d649d04 0308273c fdff0200 00000000 .....d....'<........
b37934cc: 00000000 2300465f 4b4d4d43 02201a ....#.F_KMMC. .2
INSERT (117824,14)
attcnt=1 rno=14 op=4 padlen=1 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=968 status=0x00 cid=0
old ts=0x0001 0x01b533c9 new ts=0x0001 0x01b533ca
xrow:
b379350c: 010f0000 9d649d04 0408273c fcff0200 00000000 .....d....'<........
b3793520: 00000000 2300465f 42543031 02201a ....#.F_BT01. .2
INSERT (117824,15)
attcnt=1 rno=15 op=4 padlen=1 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=1003 status=0x00 cid=0
old ts=0x0001 0x01b533ca new ts=0x0001 0x01b533cb
xrow:
b3793560: 01100000 9d649d04 0508273c fbff0200 00000000 .....d....'<........
b3793574: 00000000 2300465f 42543032 02201a ....#.F_BT02. .2
INSERT (117824,16)
attcnt=1 rno=16 op=4 padlen=1 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=1038 status=0x00 cid=0
old ts=0x0001 0x01b533cb new ts=0x0001 0x01b533cc
xrow:
b37935b4: 01110000 9d649d04 0608271e faff0200 00000000 .....d....'.........
b37935c8: 00000000 2300465f 42543033 02201a ....#.F_BT03. .2
INSERT (117824,17)
attcnt=1 rno=17 op=4 padlen=1 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=1073 status=0x00 cid=0
old ts=0x0001 0x01b533cc new ts=0x0001 0x01b533cd
xrow:
b3793608: 01120000 9d649d04 07003e08 02006500 00000000 .....d....>;...e.....
b379361c: 00000000 2300465f 5359534c 02201a ....#.F_SYSL. .2
INSERT (117824,1
attcnt=1 rno=18 op=4 padlen=1 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=1108 status=0x00 cid=0
old ts=0x0001 0x01b533cd new ts=0x0001 0x01b533ce
xrow:
b379365c: 01130000 9d649d04 08003e08 0a006500 00000000 .....d....>;...e.....
b3793670: 00000000 2300465f 53594a45 02201a ....#.F_SYJE. .2
INSERT (117824,19)
attcnt=1 rno=19 op=4 padlen=1 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=1143 status=0x00 cid=0
old ts=0x0001 0x01b533ce new ts=0x0001 0x01b533cf
xrow:
b37936b0: 01140000 9d649d04 09003e08 12006500 00000000 .....d....>;...e.....
b37936c4: 00000000 2300465f 4c53534c 02201a ....#.F_LSSL. .2
INSERT (117824,20)
attcnt=1 rno=20 op=4 padlen=1 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=1178 status=0x00 cid=0
old ts=0x0001 0x01b533cf new ts=0x0001 0x01b533d0
xrow:
b3793704: 01150000 9d649d04 0a003e08 1a006500 00000000 .....d....>;...e.....
b3793718: 00000000 2300465f 4c534a45 02201a ....#.F_LSJE. .2
INSERT (117824,21)
attcnt=1 rno=21 op=4 padlen=2 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=1213 status=0x00 cid=0
old ts=0x0001 0x01b533d0 new ts=0x0001 0x01b533d1
xrow:
b3793758: 01160000 9d649d04 0b003e08 22006500 00000000 .....d....>;.".e.....
b379376c: 00000000 2200465f 534c4102 1f1a ....".F_SLA....
INSERT (117824,22)
attcnt=1 rno=22 op=4 padlen=2 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=1247 status=0x00 cid=0
old ts=0x0001 0x01b533d1 new ts=0x0001 0x01b533d2
xrow:
b37937ac: 01170000 9d649d04 0c003e08 2a006500 00000000 .....d....>;.*.e.....
b37937c0: 00000000 2200465f 4a454102 1f1a ....".F_JEA....
INSERT (117825,0)
attcnt=1 rno=0 op=4 padlen=2 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=1281 status=0x00 cid=0
old ts=0x0001 0x01b533d2 new ts=0x0001 0x01b533d3
xrow:
b3793850: 01180000 9d649d04 0d003e08 32006500 00000000 .....d....>;.2.e.....
b3793864: 00000000 2200465f 534c4202 1f1a ....".F_SLB....
INSERT (117825,1)
attcnt=1 rno=1 op=4 padlen=2 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=1315 status=0x00 cid=0
old ts=0x0001 0x01b533d3 new ts=0x0001 0x01b533d5
xrow:
b37938a4: 01190000 9d649d04 0e003e08 3a006500 00000000 .....d....>;.:.e.....
b37938b8: 00000000 2200465f 4a454202 1f1a ....".F_JEB....
INSERT (117825,2)
attcnt=1 rno=2 op=4 padlen=2 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=1349 status=0x00 cid=0
old ts=0x0001 0x01b533d5 new ts=0x0001 0x01b533d6
xrow:
b37938f8: 012b0000 9d649d04 0f003e08 42006500 00000000 .+...d....>;.B.e.....
b379390c: 00000000 2200465f 534c4302 1f1a ....".F_SLC....
INSERT (117825,3)
attcnt=1 rno=3 op=4 padlen=2 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=1383 status=0x00 cid=0
old ts=0x0001 0x01b533d6 new ts=0x0001 0x01b533d7
xrow:
b379394c: 012c0000 9d649d04 10003e08 4a006500 00000000 .,...d....>;.J.e.....
b3793960: 00000000 2200465f 4a454302 1f1a ....".F_JEC....
INSERT (117825,4)
attcnt=1 rno=4 op=4 padlen=2 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=1417 status=0x00 cid=0
old ts=0x0001 0x01b533d7 new ts=0x0001 0x01b533d8
xrow:
b37939a0: 012d0000 9d649d04 11003e08 52006500 00000000 .-...d....>;.R.e.....
b37939b4: 00000000 2200465f 534c4402 1f1a ....".F_SLD....
INSERT (117825,5)
attcnt=1 rno=5 op=4 padlen=2 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=1451 status=0x00 cid=0
old ts=0x0001 0x01b533d8 new ts=0x0001 0x01b533d9
xrow:
b37939f4: 012e0000 9d649d04 12003e08 5a006500 00000000 .....d....>;.Z.e.....
b3793a08: 00000000 2200465f 4a454402 1f1a ....".F_JED....
INSERT (117825,6)
attcnt=1 rno=6 op=4 padlen=2 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=1485 status=0x00 cid=0
old ts=0x0001 0x01b533d9 new ts=0x0001 0x01b533da
xrow:
b3793a48: 012f0000 9d649d04 13003e08 62006500 00000000 ./...d....>;.b.e.....
b3793a5c: 00000000 2200465f 534c4502 1f1a ....".F_SLE....
INSERT (117825,7)
attcnt=1 rno=7 op=4 padlen=2 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=1519 status=0x00 cid=0
old ts=0x0001 0x01b533da new ts=0x0001 0x01b533db
xrow:
b3793a9c: 01300000 9d649d04 14003e08 6a006500 00000000 .0...d....>;.j.e.....
b3793ab0: 00000000 2200465f 4a454502 1f1a ....".F_JEE....
INSERT (117825,
attcnt=1 rno=8 op=4 padlen=2 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=1553 status=0x00 cid=0
old ts=0x0001 0x01b533db new ts=0x0001 0x01b533dc
xrow:
b3793af0: 01310000 9d649d04 15003e08 72006500 00000000 .1...d....>;.r.e.....
b3793b04: 00000000 2200465f 534c4602 1f1a ....".F_SLF....
INSERT (117825,9)
attcnt=1 rno=9 op=4 padlen=2 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=1587 status=0x00 cid=0
old ts=0x0001 0x01b533dc new ts=0x0001 0x01b533dd
xrow:
b3793b44: 01320000 9d649d04 16003e08 7a006500 00000000 .2...d....>;.z.e.....
b3793b58: 00000000 2200465f 4a454602 1f1a ....".F_JEF....
INSERT (117825,10)
attcnt=1 rno=10 op=4 padlen=2 sessionid = (117824,10) len=84
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=51 pageno=1667 offset=1621 status=0x00 cid=0
old ts=0x0001 0x01b533dd new ts=0x0001 0x01b533de
xrow:
b3793b98: 01330000 9d649d04 17003e08 82006500 00000000 .3...d....>;...e.....
b3793bac: 00000000 2200465f 534c4702 1f1a ....".F_SLG.... |
|