[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| Title: | Oracle Rdb - Still a strategic database for DEC on Alpha AXP! |
| Notice: | RDB_60 is archived, please use RDB_70 .. |
| Moderator: | NOVA::SMITHI SON |
|
| Created: | Fri Mar 18 1994 |
| Last Modified: | Fri May 30 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 5118 |
| Total number of notes: | 28246 |
4958.0. "RMU problems with fragmented SYSTEM record" by NLVMS3::MWILLEMS (Das ganze Leben ist ein Quiz) Fri Jan 24 1997 05:13
I have a problem from a customer that does a RMU/VERIFY of his database.
This gives an ACCVIO. When he does an RMU/DUMP of the area the dump from
page 507 dumps after the page, parts of the rootfile, rdbmessage files and
other strange things. On the page there is a fragmented system record and if
you display this SYSTEM record in RMU/ALTER the same thing happens.
The dump of the page in RMU/ALTER looks like:
002F 000001FB 0000 page 507, physical area 47
8D777F08 0006 checksum = 8D777F08
009AE683 C4F0F072 000A time stamp = 15-JAN-1997 15:46:43.26
0000 00E2 0012 226 free bytes, 0 locked
000A 0016 10 lines
000C 03E2 0018 line 0: offset 03E2, 12 bytes
0041 0316 001C line 1: offset 0316, 65 bytes
0089 0358 0020 line 2: offset 0358, 137 bytes
0041 02D4 0024 line 3: offset 02D4, 65 bytes
0055 027E 0028 line 4: offset 027E, 85 bytes
002C 0252 002C line 5: offset 0252, 44 bytes
0041 0210 0030 line 6: offset 0210, 65 bytes
0041 01CE 0034 line 7: offset 01CE, 65 bytes
0041 018C 0038 line 8: offset 018C, 65 bytes
0041 014A 003C line 9: offset 014A, 65 bytes
00011920 0040 line 0: TSN 71968
.
.
A001 03E2 line 0 (47:507:0) SYSTEM record
00000404 0005 03E4 primary fragment, next is 47:1028:5
001C 03EA total record length is 28 bytes
820018 03EC control '...'
^^
First byte page tail offset 3EE, length of record
12 bytes as in header (offset 3E2 - 3EC)
000000000000000000000191F0000005 03EF data '...�............'
00000100000400009E89A0009E818000 03FF data '................'
00000000000000000000000000000000 040F data '................'
Then follows the junk, which I did not include here. The page is 2 blocks
so the last byte should have offset 03FF.
If we assume that the page tail on page 507 begins at offset 3EE this page
tail can be formatted as:
00000582 03EE snap page pointer 2751
000191F0 03F2 snap pointer TSN 99989
0000 03F6 MBZ '..'
00000000 03F8 page sequence number 0
00000000 03FC MBZ '....'
If we suppose that then the primary fragment looks like:
A001 03E2 line 0 (47:507:0) SYSTEM record
00000404 0005 03E4 primary fragment, next is 47:1028:5
001C 03EA total record length is 28 bytes
0018 03EC 24 bytes in ? sets/dynamic items
The last segment of the system record looks like:
6001 03B6 line 5 (47:1028:5) SYSTEM record
000001FB 0000 03B8 final fragment, primary is 47:507:0
00CB2094970101090008128800B70703 03BE data '..�.......... �.'
^ ^ ^ ^ ^ ^ ^
0008E360003E0700 03CE data '..>.`�..'
^ ^ ^
then the SYSTEM record can be constructed like (assume begins at "offset"
0):
2001 0000 line 0 (47:507:0) SYSTEM record
0018 0002 24 bytes in
03 0004 3 sets/dynamic items
00B7 07 0005 7 bytes, storage set type 183
00081288 0009 compressed dbkeys next/owner
0101 09 000C 9 bytes, storage set type 257
0000CB209497 000F compressed dbkeys next/owner
003E 07 0015 7 bytes, storage set type 62
0008E360 0019 compressed dbkeys next/owner
Which gives a record length of 28, as expected.
Could it be that the customer discovered a bug in the way fragmented SYSTEM
records are handled by RMU/VERIFY, RMU/DUMP and RMU/ALTER or do I somethinh
wrong when constructing this SYSTEM record? I suppose that
this is a very rare situation.
Accessing the records on the page via the hashed index works without
problems.
Should I bug it?
Marcel Willems, Oracle Rdb Support, Holland
| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 4958.1 | | M5::LWILCOX | Chocolate in January!! | Fri Jan 24 1997 08:27 | 5 |
| Darn it all, you left out the best part, I wanted to see the junk on the page!
What version of Rdb? Does a VMS dump look "reasonable"?
Liz
|
| 4958.2 | Pages are physically ok, VMS dump also | NLVMS3::MWILLEMS | Das ganze Leben ist ein Quiz | Fri Jan 24 1997 09:49 | 9 |
| Liz,
There is no junk on the page, because page 508 and so on can be
normally used. Also a VMS dump of the page looks reasonable, the block
on which page 508 begins is completely different from the junk output,
which I'll include below. So it is really the way RMU handles these
bytes of the fragmented system record.
Marcel
|
| 4958.3 | junk output from rmu/alter display * | NLVMS3::MWILLEMS | Das ganze Leben ist ein Quiz | Fri Jan 24 1997 09:55 | 252 |
| Junk output (first part, it goes on endlessly)
A001 03E2 line 0 (47:507:0) SYSTEM record
00000404 0005 03E4 primary fragment, next is 47:1028:5
001C 03EA total record length is 28 bytes
820018 03EC control '...'
000000000000000000000191F0000005 03EF data '...�............'
00000100000400009E89A0009E818000 03FF data '................'
00000000000000000000000000000000 040F data '................'
:::: (63 duplicate lines)
00000100000400009E8DB0009E859000 080F data '.....�..........'
00000000000000000000000000000000 081F data '................'
:::: (63 duplicate lines)
00000100000400009E91C0009E89A000 0C1F data '.....�..........'
00000000000000000000000000000000 0C2F data '................'
:::: (63 duplicate lines)
00000100000400009E95D0009E8DB000 102F data '.�...�..........'
00000000000000000000000000000000 103F data '................'
:::: (63 duplicate lines)
00000100000400009E99E0009E91C000 143F data '.�...�..........'
00000000000000000000000000000000 144F data '................'
:::: (63 duplicate lines)
00000100000400009EA000009E95D000 184F data '.�..............'
00000000000000000000000000000000 185F data '................'
:::: (63 duplicate lines)
00000000000200000036E8FFFF813800 1C5F data '.8...�6.........'
00000000000000000000000000000000 1C6F data '................'
:::: (31 duplicate lines)
00000100000400009EA410009E99E000 1E6F data '.�....�.........'
00000000000000000000000000000000 1E7F data '................'
:::: (63 duplicate lines)
00000100000400009EA820009EA00000 227F data '..... �.........'
00000000000000000000000000000000 228F data '................'
:::: (63 duplicate lines)
00000100000400009EAC30009EA41000 268F data '..�..0�.........'
00000000000000000000000000000000 269F data '................'
:::: (63 duplicate lines)
00000100000400009EB040009EA82000 2A9F data '. �..@�.........'
00000000000000000000000000000000 2AAF data '................'
:::: (63 duplicate lines)
00000100000400009EB450009EAC3000 2EAF data '.0�..P�.........'
00000000000000000000000000000000 2EBF data '................'
:::: (63 duplicate lines)
00000100000400009EB860009EB04000 32BF data '.@�..`�.........'
00000000000000000000000000000000 32CF data '................'
:::: (63 duplicate lines)
00000100000400009EBC70009EB45000 36CF data '.P�..p�.........'
00000000000000000000000000000000 36DF data '................'
:::: (63 duplicate lines)
00000100000400009EC080009EB86000 3ADF data '.`�...�.........'
00000000000000000000000000000000 3AEF data '................'
:::: (63 duplicate lines)
00000100000400009EC490009EBC7000 3EEF data '.p�...�.........'
00000000000000000000000000000000 3EFF data '................'
:::: (63 duplicate lines)
00000100000008009EC4A8009EC08000 42FF data '..�..��.........'
9EC4C0009EC490000000000000000000 430F data '..........�..��.'
00000000000000000000010000000800 431F data '................'
00000100000008009EC4D8009EC4A800 432F data '.��..��.........'
9EC4F0009EC4C0000000000000000000 433F data '.........��..��.'
00000000000000000000010000000800 434F data '................'
00000100000008009EC508009EC4D800 435F data '.��...�.........'
9EC520009EC4F0000000000000000000 436F data '.........��.. �.'
00000000000000000000010000000800 437F data '................'
00000100000008009EC538009EC50800 438F data '..�..8�.........'
9EC550009EC520000000000000000000 439F data '......... �..P�.'
00000000000000000000010000000800 43AF data '................'
00000100000008009EC568009EC53800 43BF data '.8�..h�.........'
9EC580009EC550000000000000000000 43CF data '.........P�...�.'
00000000000000000000010000000800 43DF data '................'
00000100000008009EC598009EC56800 43EF data '.h�...�.........'
9EC5B0009EC580000000000000000000 43FF data '..........�..��.'
00000000000000000000010000000800 440F data '................'
00000100000008009EC5C8009EC59800 441F data '..�..��.........'
9EC5E0009EC5B0000000000000000000 442F data '.........��..��.'
00000000000000000000010000000800 443F data '................'
00000100000008009EC5F8009EC5C800 444F data '.��..��.........'
9EC610009EC5E0000000000000000000 445F data '.........��...�.'
00000000000000000000010000000800 446F data '................'
00000100000008009EC628009EC5F800 447F data '.��..(�.........'
9EC640009EC610000000000000000000 448F data '..........�..@�.'
00000000000000000000010000000800 449F data '................'
00000100000008009EC658009EC62800 44AF data '.(�..X�.........'
9EC670009EC640000000000000000000 44BF data '.........@�..p�.'
00000000000000000000010000000800 44CF data '................'
00000100000008009EC688009EC65800 44DF data '.X�...�.........'
9EC6A0009EC670000000000000000000 44EF data '.........p�...�.'
00000000000000000000010000000800 44FF data '................'
00000100000008009EC6B8009EC68800 450F data '..�..��.........'
9EC6D0009EC6A0000000000000000000 451F data '..........�..��.'
00000000000000000000010000000800 452F data '................'
00000100000008009EC6E8009EC6B800 453F data '.��..��.........'
9EC700009EC6D0000000000000000000 454F data '.........��...�.'
00000000000000000000010000000800 455F data '................'
00000100000008009EC718009EC6E800 456F data '.��...�.........'
9EC730009EC700000000000000000000 457F data '..........�..0�.'
00000000000000000000010000000800 458F data '................'
00000100000008009EC748009EC71800 459F data '..�..H�.........'
9EC760009EC730000000000000000000 45AF data '.........0�..`�.'
00000000000000000000010000000800 45BF data '................'
00000100000008009EC778009EC74800 45CF data '.H�..x�.........'
9EC790009EC760000000000000000000 45DF data '.........`�...�.'
00000000000000000000010000000800 45EF data '................'
00000100000008009EC7A8009EC77800 45FF data '.x�..��.........'
9EC7C0009EC790000000000000000000 460F data '..........�..��.'
00000000000000000000010000000800 461F data '................'
00000100000008009EC7D8009EC7A800 462F data '.��..��.........'
9EC7F0009EC7C0000000000000000000 463F data '.........��..��.'
00000000000000000000010000000800 464F data '................'
00000100000008009EC808009EC7D800 465F data '.��...�.........'
9EC820009EC7F0000000000000000000 466F data '.........��.. �.'
00000000000000000000010000000800 467F data '................'
00000100000008009EC838009EC80800 468F data '..�..8�.........'
9EC850009EC820000000000000000000 469F data '......... �..P�.'
00000000000000000000010000000800 46AF data '................'
00000100000008009EC868009EC83800 46BF data '.8�..h�.........'
9EC880009EC850000000000000000000 46CF data '.........P�...�.'
00000000000000000000010000000800 46DF data '................'
00000100000008009EC898009EC86800 46EF data '.h�...�.........'
9EC8B0009EC880000000000000000000 46FF data '..........�..��.'
00000000000000000000010000000800 470F data '................'
00000100000008009EC8C8009EC89800 471F data '..�..��.........'
9EC8E0009EC8B0000000000000000000 472F data '.........��..��.'
00000000000000000000010000000800 473F data '................'
00000100000008009EC8F8009EC8C800 474F data '.��..��.........'
9EC910009EC8E0000000000000000000 475F data '.........��...�.'
00000000000000000000010000000800 476F data '................'
00000100000008009EC928009EC8F800 477F data '.��..(�.........'
9EC940009EC910000000000000000000 478F data '..........�..@�.'
00000000000000000000010000000800 479F data '................'
00000100000008009EC958009EC92800 47AF data '.(�..X�.........'
9EC970009EC940000000000000000000 47BF data '.........@�..p�.'
00000000000000000000010000000800 47CF data '................'
00000100000008009EC988009EC95800 47DF data '.X�...�.........'
9EC9A0009EC970000000000000000000 47EF data '.........p�...�.'
00000000000000000000010000000800 47FF data '................'
00000100000008009EC9B8009EC98800 480F data '..�..��.........'
9EC9D0009EC9A0000000000000000000 481F data '..........�..��.'
00000000000000000000010000000800 482F data '................'
00000100000008009EC9E8009EC9B800 483F data '.��..��.........'
9ECA00009EC9D0000000000000000000 484F data '.........��...�.'
00000000000000000000010000000800 485F data '................'
00000100000008009ECA18009EC9E800 486F data '.��...�.........'
9ECA30009ECA00000000000000000000 487F data '..........�..0�.'
00000000000000000000010000000800 488F data '................'
00000100000008009ECA48009ECA1800 489F data '..�..H�.........'
9ECA60009ECA30000000000000000000 48AF data '.........0�..`�.'
00000000000000000000010000000800 48BF data '................'
00000100000008009ECA78009ECA4800 48CF data '.H�..x�.........'
9ECA90009ECA60000000000000000000 48DF data '.........`�...�.'
00000000000000000000010000000800 48EF data '................'
00000100000008009ECAA8009ECA7800 48FF data '.x�..��.........'
9ECAC0009ECA90000000000000000000 490F data '..........�..��.'
00000000000000000000010000000800 491F data '................'
00000100000008009ECAD8009ECAA800 492F data '.��..��.........'
9ECAF0009ECAC0000000000000000000 493F data '.........��..��.'
00000000000000000000010000000800 494F data '................'
00000100000008009ECB08009ECAD800 495F data '.��...�.........'
9ECB20009ECAF0000000000000000000 496F data '.........��.. �.'
00000000000000000000010000000800 497F data '................'
00000100000008009ECB38009ECB0800 498F data '..�..8�.........'
9ECB50009ECB20000000000000000000 499F data '......... �..P�.'
00000000000000000000010000000800 49AF data '................'
00000100000008009ECB68009ECB3800 49BF data '.8�..h�.........'
9ECB80009ECB50000000000000000000 49CF data '.........P�...�.'
00000000000000000000010000000800 49DF data '................'
00000100000008009F2000009ECB6800 49EF data '.h�... .........'
00000000000000000000000000000000 49FF data '................'
0A1140000A1140000000010000072000 4A0F data '. .......@...@..'
97986000000000000000000003010100 4A1F data '.............`..'
20202A2059414C505349440000000900 4A2F data '.....DISPLAY * '
20202020202020202020202020202020 4A3F data ' '
:::: (62 duplicate lines)
005455504E4924535953092020202020 4E2F data ' .SYS$INPUT.'
00000000000000000000000000000000 4E3F data '................'
:::: (30 duplicate lines)
3A5455504E49245359530C0000000000 502F data '......SYS$INPUT:'
20202020202020202020202020203B2E 503F data '.; '
20202020202020202020202020202020 504F data ' '
:::: (13 duplicate lines)
00000000000000000000002020202020 512F data ' ...........'
00000000000000000000010000002000 513F data '. ..............'
000000009ED3D8000000000000000000 514F data '.........��.....'
6B46F0FF6B46F0000000000133023000 515F data '.0.3.....�Fk.�Fk'
000000000050030000000100000050FF 516F data '.P........P.....'
01000000000000000000000001000100 517F data '................'
00000000000000020000000000000002 518F data '................'
00003300000000009F4ED1009ED36800 519F data '.h�..�N......3..'
4D40081C4D4008000000000000000000 51AF data '..........@M..@M'
6B46A0FF6B46A000000000000000001C 51BF data '..........Fk..Fk'
9ED3D833FF60020000000100000060FF 51CF data '.`........`.3��.'
245F0A00000000009ED3D833FF000000 51DF data '....3��......._$'
02001B0000000000303033414B442432 51EF data '2$DKA300........'
4000C7000001C900000001000F000000 51FF data '.........�...�.@'
9ED3D8009ED3D8000002041313070000 520F data '.........��..��.'
9ED409009ED405009ED3F2009ED3DF00 521F data '.��..��...�...�.'
00000000000000000000000000000000 522F data '................'
3A303033414B44000000010000010000 523F data '.........DKA300:'
42462E5443452E534D454C4C49574D5B 524F data '[MWILLEMS.ECT.FB'
444E495F4445485341485F41535D3331 525F data '13]SA_HASHED_IND'
00000000313B4144522E375F53455845 526F data 'EXES_7.RDA;1....'
00000000000000000000000000000000 527F data '................'
:::: (11 duplicate lines)
6B4E28FFFFC918000000000000000000 533F data '..........�..(Nk'
000000000000000000000000004B18FF 534F data '..K.............'
00000000000000000000000000000000 535F data '................'
:::: (1200 duplicate lines)
00000100011650000BBF78009ECB8000 9E6F data '..�..x�..P......'
303033414B442D0000008A0000011200 9E7F data '.........-DKA300'
462E5443452E534D454C4C49574D5B3A 9E8F data ':[MWILLEMS.ECT.F'
4D5F5245504F5F41544956455D333142 9E9F data 'B13]EVITA_OPER_M'
000000000000000000313B4144522E46 9EAF data 'F.RDA;1.........'
00000000000000000000000000000000 9EBF data '................'
:::: (11 duplicate lines)
4B44340000008B000000000000000000 9F7F data '.............4DK'
452E534D454C4C49574D5B3A30303341 9F8F data 'A300:[MWILLEMS.E'
45495443415F41535D333142462E5443 9F9F data 'CT.FB13]SA_ACTIE'
4144522E544C55414645445F45505954 9FAF data 'TYPE_DEFAULT.RDA'
0000000000000000000000000000313B 9FBF data ';1..............'
00000000000000000000000000000000 9FCF data '................'
:::: (10 duplicate lines)
00008C00000000000000000000000000 A07F data '................'
454C4C49574D5B3A303033414B442800 A08F data '.(DKA300:[MWILLE'
415F41535D333142462E5443452E534D A09F data 'MS.ECT.FB13]SA_A'
000000000000313B4144522E4C4D415F A0AF data '_AML.RDA;1......'
00000000000000000000000000000000 A0BF data '................'
:::: (12 duplicate lines)
574D5B3A303033414B44280000008D00 A18F data '.....(DKA300:[MW'
5D333142462E5443452E534D454C4C49 A19F data 'ILLEMS.ECT.FB13]'
0000313B4144522E4343415F415F4153 A1AF data 'SA_A_ACC.RDA;1..'
00000000000000000000000000000000 A1BF data '................'
:::: (12 duplicate lines)
303033414B44280000008E0000000000 A28F data '.........(DKA300'
462E5443452E534D454C4C49574D5B3A A29F data ':[MWILLEMS.ECT.F'
4144522E4752425F415F41535D333142 A2AF data 'B13]SA_A_BRG.RDA'
0000000000000000000000000000313B A2BF data ';1..............'
00000000000000000000000000000000 A2CF data '................'
:::: (11 duplicate lines)
4B44280000008F000000000000000000 A38F data '.............(DK'
452E534D454C4C49574D5B3A30303341 A39F data 'A300:[MWILLEMS.E'
4C52445F415F41535D333142462E5443 A3AF data 'CT.FB13]SA_A_DRL'
00000000000000000000313B4144522E A3BF data '.RDA;1..........'
00000000000000000000000000000000 A3CF data '................'
:::: (11 duplicate lines)
00009000000000000000000000000000 A48F data '................'
454C4C49574D5B3A303033414B442800 A49F data '.(DKA300:[MWILLE'
415F41535D333142462E5443452E534D A4AF data 'MS.ECT.FB13]SA_A'
000000000000313B4144522E4E4C485F A4BF data '_HLN.RDA;1......'
00000000000000000000000000000000 A4CF data '................'
and so on
|
| 4958.4 | | HOTRDB::PMEAD | Paul, [email protected], 719-577-8032 | Fri Jan 24 1997 12:24 | 6 |
| I fixed the problems with displaying a fragmented system record a few
months ago for V6.1 and later. Fix should be in the next ECOs for 6.1
and 7.0.
Don't know what to tell you about the RMU/VERIFY problem. You might
want to bug that if you can provide a reproducible case.
|
| 4958.5 | ACCVIO not reproducible anymore | NLVMS3::MWILLEMS | Das ganze Leben ist ein Quiz | Mon Jan 27 1997 03:26 | 13 |
| Paul,
Although I'm sure I've seen this ACCVIO with RMU/VERIFY, I can't
reproduce it anymore. Even with restoring the original backup I got
from the customer it was not reproducible anymore. So we can leave it
as it is.
I will tell the customer to wait for the next eco for the problem with
the fragmented system record.
Thanks,
Marcel
|