December 22, 2004 at 1:42 pm
Hi all, here is my error message;
2004/12/22 13:54:42.64 spid107 Retrying row fetch: rowoffset entry 0 out of range (pg 0x120c9e1, obj 0x6be4cfe8, db 6, stat 1004/0)
2004/12/22 13:54:42.64 spid107
spid 107, Getrow: rowoffset entry 14(0) out of range (pg 0x120c9e1, obj 0x6be4cfe8, db 6, stat 100c/0)
2004/12/22 13:54:42.64 spid107 Error : 625, Severity: 20, State: 1
2004/12/22 13:54:42.64 spid107 Could not retrieve row from logical page 18926049 via RID because the entry in the offset table (= 0) for that RID (= 14) is less than or equal to 0.
Here is the output from DBCC Page;
PAGE:
Page not found in cache - read from disk.
BUFFER:
Buffer header for buffer 0x599df2a4
page=0x10270000 bdnew=0x0 bdold=0x0 bhash=0x0 bnew=0x0
bold=0x0 bvirtpg=89778768 bdbid=6 bpinproc=0 bkeep=0 bspid=0
bstat=0x0000 bpageno=0
PAGE HEADER:
Page header for page 0x10270000
pageno=19204688 nextpg=19204730 prevpg=18926049 objid=1810157544
timestamp=0005 534fe10c
nextrno=19 level=0 indid=0 freeoff=1938 minlen=48
page status bits: 0x100,0x8,0x4,0x1
DATA:
Offset 32 -
10270020: 11000c0b 747b073e db575e01 43520040 ....t{.>.W^.CR.@
10270030: b75d81ec 53c8c500 00000553 4fdc637b .]..S......SO.c{
10270040: 14ae47e1 7af03f59 01000000 01000000 ..G.z.?Y........
10270050: 6f00c595 ae0114ae 47e17a14 f03f7b14 o.......G.z..?{.
10270060: ae47e17a f03f312e 30303520 2d20312e .G.z.?1.005 - 1.
10270070: 30333031 2e303330 dd55b603 125c5858 0301.030.U...\XX
10270080: 58585858 5853463e 36363636 363632 XXXXXSF>6666662
Offset 143 -
1027008f: 11010c0b 747b073f db575e01 43520041 ....t{.?.W^.CR.A
1027009f: b75d81ed 53c8c500 00000553 4fdc9900 .]..S......SO...
102700af: 00000000 00000059 01000000 01000000 .......Y........
102700bf: 5d00c595 ae014e65 67617469 76654e45 ].....NegativeNE
102700cf: 47415449 5645dd55 b603124a 46464646 GATIVE.U...JFFFF
102700df: 46463e3e 36363636 36363636 32 FF>>666666662
Offset 236 -
102700ec: 11020c0b 747b0740 db575e01 43520042 ....t{.@.W^.CR.B
102700fc: b75d81ee 53c8c500 00000553 4fdccc00 .]..S......SO...
1027010c: 00000000 00144059 01000000 01000000 ......@Y........
1027011c: 6900c595 ae010000 00000000 14400000 i............@..
1027012c: 00000000 2040352e 30202d20 382e3035 .... @5.0 - 8.05
1027013c: 2e30dd55 b6031256 52525252 5252524f .0.U...VRRRRRRRO
1027014c: 463e3636 36363636 32 F>6666662
Offset 341 -
10270155: 11030c0b 747b0742 db575e01 43520044 ....t{.B.W^.CR.D
10270165: b75d81f0 53c8c500 00000553 4fdcff00 .]..S......SO...
10270175: 00000000 00000059 01000000 01000000 .......Y........
10270185: 5d00c595 ae014e65 67617469 76654e45 ].....NegativeNE
10270195: 47415449 5645dd55 b603124a 46464646 GATIVE.U...JFFFF
102701a5: 46463e3e 36363636 36363636 32 FF>>666666662
Offset 434 -
102701b2: 11040c0b 747b0743 db575e01 43520045 ....t{.C.W^.CR.E
102701c2: b75d81f1 53c8c500 00000553 4fdd3200 .]..S......SO.2.
102701d2: 00000000 00000059 01000000 01000000 .......Y........
102701e2: 5d00c595 ae014e65 67617469 76654e45 ].....NegativeNE
102701f2: 47415449 5645dd55 b603124a 46464646 GATIVE.U...JFFFF
10270202: 46463e3e 36363636 36363636 32 FF>>666666662
Offset 527 -
1027020f: 11050c0b 747b0744 db575e01 43520046 ....t{.D.W^.CR.F
1027021f: b75d81f2 53c8c500 00000553 4fddc700 .]..S......SO...
1027022f: 00000000 c05b4059 01000000 1d000000 .....[@Y........
1027023f: 7200c595 ae010000 00000080 4b400000 r...........K@..
1027024f: 00000000 00000000 00000000 00004e65 ..............Ne
1027025f: 67617469 76653e3d 313131dd 55b60312 gative>=111.U...
1027026f: 5f5b5b5b 5b5b5856 564e463e 36363636 _[[[[[XVVNF>6666
1027027f: 3632 62
Offset 641 -
10270281: 11060c0b 747b0745 db575e01 43520047 ....t{.E.W^.CR.G
10270291: b75d81f3 53c8c500 00000553 4fddfa00 .]..S......SO...
102702a1: 00000000 00e03f59 01000000 1d000000 ......?Y........
102702b1: 7000c595 ae019a99 99999999 1f400000 p............@..
102702c1: 00000000 00000000 00000000 00004e65 ..............Ne
102702d1: 67617469 7665302e 35dd55b6 03125d59 gative0.5.U...]Y
102702e1: 59595959 5959564e 463e3636 36363632 YYYYYYVNF>666662
Offset 753 -
102702f1: 11070c0b 747b0746 db575e01 43520048 ....t{.F.W^.CR.H
10270301: b75d81f4 53c8c500 00000553 4fde2d00 .]..S......SO.-.
10270311: 00000000 00000059 01000000 0b000000 .......Y........
10270321: 7500c595 ae010000 00000000 33400000 u...........3@..
10270331: 00000000 00000000 00000000 00004e65 ..............Ne
10270341: 67617469 76654e45 47415449 5645dd55 gativeNEGATIVE.U
10270351: b6031262 5e5e5e5e 5e5e5656 4e463e36 ...b^^^^^^VVNF>6
10270361: 36363636 32 66662
Offset 870 -
10270366: 11080c0b 747b0747 db575e01 43520049 ....t{.G.W^.CR.I
10270376: b75d81f5 53c8c500 00000553 4fde5f00 .]..S......SO._.
10270386: 00000000 00000059 01000000 04000000 .......Y........
10270396: 5500c595 ae014e6f 6e654e4f 4e45dd55 U.....NoneNONE.U
102703a6: b6031242 3e3e3e3e 3e3e3a3a 36363636 ...B>>>>>>::6666
102703b6: 36363636 32 66662
Offset 955 -
102703bb: 11090c0b 747b0748 db575e01 4352004a ....t{.H.W^.CR.J
102703cb: b75d81f6 53c8c500 00000553 4fdeef00 .]..S......SO...
102703db: 00000000 00000059 01000000 03000000 .......Y........
102703eb: 5400c595 ae014e6f 6e654645 57dd55b6 T.....NoneFEW.U.
102703fb: 0312413d 3d3d3d3d 3d3a3a36 36363636 ..A======::66666
1027040b: 36363632 6662
Offset 1039 -
1027040f: 110a0c0b 747b0749 db575e01 4352004b ....t{.I.W^.CR.K
1027041f: b75d81f7 53c8c500 00000553 4fdf2200 .]..S......SO.".
1027042f: 00000000 00000059 01000000 03000000 .......Y........
1027043f: 5500c595 ae014e6f 6e654d41 4e59dd55 U.....NoneMANY.U
1027044f: b6031242 3e3e3e3e 3e3e3a3a 36363636 ...B>>>>>>::6666
1027045f: 36363636 32 66662
Offset 1124 -
10270464: 110b0c0b 747b074a db575e01 4352004c ....t{.J.W^.CR.L
10270474: b75d81f8 53c8c500 00000553 4fdf5400 .]..S......SO.T.
10270484: 00000000 00000059 01000000 03000000 .......Y........
10270494: 5500c595 ae014e6f 6e654e4f 4e45dd55 U.....NoneNONE.U
102704a4: b6031242 3e3e3e3e 3e3e3a3a 36363636 ...B>>>>>>::6666
102704b4: 36363636 32 66662
Offset 1209 -
102704b9: 110c0c0b 747b074b db575e01 4352004d ....t{.K.W^.CR.M
102704c9: b75d81f9 53c8c500 00000553 4fdf8700 .]..S......SO...
102704d9: 00000000 00004059 01000000 03000000 ......@Y........
102704e9: 6500c595 ae010000 00000000 00000000 e...............
102704f9: 00000000 00403020 2d203230 2d32dd55 .....@0 - 20-2.U
10270509: b6031252 4e4e4e4e 4e4d4c4b 463e3636 ...RNNNNNMLKF>66
10270519: 36363636 32 66662
Offset 1310 -
1027051e: 110d0c0b 747b074c db575e01 4352004e ....t{.L.W^.CR.N
1027052e: b75d81fa 53c8c500 00000553 4fdfbe00 .]..S......SO...
1027053e: 00000000 00144059 01000000 03000000 ......@Y........
1027054e: 6500c595 ae010000 00000000 00000000 e...............
1027055e: 00000000 14403020 2d203530 2d35dd55 .....@0 - 50-5.U
1027056e: b6031252 4e4e4e4e 4e4d4c4b 463e3636 ...RNNNNNMLKF>66
1027057e: 36363636 32 66662
Offset 1411 -
10270583: 110e0c0b 747b074d db575e01 4352004f ....t{.M.W^.CR.O
10270593: b75d81fb 53c8c500 00000553 4fdff100 .]..S......SO...
102705a3: 00000000 00144059 01000000 03000000 ......@Y........
102705b3: 6500c595 ae010000 00000000 00000000 e...............
102705c3: 00000000 14403020 2d203530 2d35dd55 .....@0 - 50-5.U
102705d3: b6031252 4e4e4e4e 4e4d4c4b 463e3636 ...RNNNNNMLKF>66
102705e3: 36363636 32 66662
Offset 1512 -
102705e8: 110f10f5 737b073e db575e01 43520070 ....s{.>.W^.CR.p
102705f8: b75d811c 54c8c500 00000553 4fe0307b .]..T......SO.0{
10270608: 14ae47e1 7af03f59 01000000 01000000 ..G.z.?Y........
10270618: 6f00c595 ae0114ae 47e17a14 f03f7b14 o.......G.z..?{.
10270628: ae47e17a f03f312e 30303520 2d20312e .G.z.?1.005 - 1.
10270638: 30333031 2e303330 dd55b603 125c5858 0301.030.U...\XX
10270648: 58585858 5853463e 36363636 363632 XXXXXSF>6666662
Offset 1623 -
10270657: 111010f5 737b073f db575e01 43520071 ....s{.?.W^.CR.q
10270667: b75d811d 54c8c500 00000553 4fe06700 .]..T......SO.g.
10270677: 00000000 00000059 01000000 01000000 .......Y........
10270687: 5d00c595 ae014e65 67617469 76654e45 ].....NegativeNE
10270697: 47415449 5645dd55 b603124a 46464646 GATIVE.U...JFFFF
102706a7: 46463e3e 36363636 36363636 32 FF>>666666662
Offset 1716 -
102706b4: 111110f5 737b0740 db575e01 43520072 ....s{.@.W^.CR.r
102706c4: b75d811e 54c8c500 00000553 4fe09e00 .]..T......SO...
102706d4: 00000000 00144059 01000000 01000000 ......@Y........
102706e4: 6900c595 ae010000 00000000 14400000 i............@..
102706f4: 00000000 2040352e 30202d20 382e3035 .... @5.0 - 8.05
10270704: 2e30dd55 b6031256 52525252 5252524f .0.U...VRRRRRRRO
10270714: 463e3636 36363636 32 F>6666662
Offset 1821 -
1027071d: 111210f5 737b0744 db575e01 43520073 ....s{.D.W^.CR.s
1027072d: b75d811f 54c8c500 00000553 4fe0d100 .]..T......SO...
1027073d: 00000000 00000059 01000000 1d000000 .......Y........
1027074d: 7500c595 ae010000 00000080 4b400000 u...........K@..
1027075d: 00000000 00000000 00000000 00004e65 ..............Ne
1027076d: 67617469 76654e45 47415449 5645dd55 gativeNEGATIVE.U
1027077d: b6031262 5e5e5e5e 5e5e5656 4e463e36 ...b^^^^^^VVNF>6
1027078d: 36363636 32 66662
OFFSET TABLE:
Row - Offset
18 (0x12) - 1821 (0x71d), 17 (0x11) - 1716 (0x6b4),
16 (0x10) - 1623 (0x657), 15 (0xf) - 1512 (0x5e8),
14 (0xe) - 1411 (0x583), 13 (0xd) - 1310 (0x51e),
12 (0xc) - 1209 (0x4b9), 11 (0xb) - 1124 (0x464),
10 (0xa) - 1039 (0x40f), 9 (0x9) - 955 (0x3bb),
8 (0x8) - 870 (0x366), 7 (0x7) - 753 (0x2f1),
6 (0x6) - 641 (0x281), 5 (0x5) - 527 (0x20f),
4 (0x4) - 434 (0x1b2), 3 (0x3) - 341 (0x155),
2 (0x2) - 236 (0xec), 1 (0x1) - 143 (0x8f),
0 (0x0) - 32 (0x20),
DBCC execution completed. If DBCC printed error messages, see your System Administrator.
December 22, 2004 at 2:55 pm
Sounds like you've got a corrupted data file. You should consider restoring your most recent backup to rectify the problem.
December 22, 2004 at 3:05 pm
Thanks, that is the last resort. Backup is 5 hours old, too much data loss.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply