| From: DEC:.REO.REOVTX::HUDSON "[email protected] - UK Software
Partner Engineering 830-4121" 18-MAR-1997 16:45:16.93
To: nm%vbormc::"[email protected]"
CC: HUDSON
Subj: RE: 23191 , missing records in rms files
Hello Mats Nilsson
Thank-you for your ASAP question regarding records missing from an RMS file.
I checked out the databases and the only thing I found reference to which
bears a slight resemblance to what you describe is in the release notes for a
kit which contains a collection of RMS patches.
The kit in question is ALPRMS04_061. Below is an extract from the README file.
Note the lines highlighted with ">>"
================================================================================
o If the data bucket pointed to by the level 1 "high key" index
value for a duplicate key (primary or secondary) has one or more
continuation buckets chained to it and the last bucket is full,
under rare conditions a race condition may occur when two
processes are concurrently adding (putting) records to a
duplicate key, each with a key value higher than the highest key
value currently stored in the file.
The user-visible symptoms are as follows:
* If the index is compressed, an infinite loop will occur due
to an attempt to add a duplicate entry to the level 1 index
bucket.
* If the index is not compressed, a duplicate entry will
successfully be added to the level 1 index bucket.
NOTE: An index bucket should never have a duplicate entry
for any index value.
In either case this can result in:
* Records in the level 0 data chain being out of sorted order.
>> * Records being hidden from a keyed lookup (though visible
>> with a sequential scan).
Workaround:
The file should be converted.
This problem is fixed in OpenVMS Alpha V6.2.
================================================================================
However, as you see, this problem should be fixed by the time you get to V7.0
which is what you say you're using.
There is a set of patches for 7.0 (ALPRMS01_070), so I suppose you could try
installing that, but I didn't see anything in the list of fixed problems that
sounds like yours.
I found this info on the WWW, and you can get there by going to:
http://www.service.digital.com/html/patch_public.html
From that page, select "Search and Download Utility"
From the next page, highlight "OpenVMS_Readmes", and enter "alprms" in the
search box. You get a list of patches.
Other than that, I guess to pursue this I would need a reproduceable case,
which I appreciate is not easy for you to provide. But failing that, more
information about what exactly your program is doing would help (e.g. is it an
indexed file? how many keys? duplicates? what kind of "updates" are you doing,
etc., etc.)
Regards
Nick Hudson
Digital Software Partner Engineering
|
| From: DEC:.REO.REOVTX::HUDSON "[email protected] - UK Software
Partner Engineering 830-4121" 7-APR-1997 14:45:03.99
To: nm%vbormc::"[email protected]"
CC: HUDSON
Subj: RE: 23191 , missing records in rms files
Hi Mats Nilsson
Is this one still causing you a problem (records missing from an RMS file,
asap call #23191)?
If so, could you provide me with some more information about the nature of the
problem so I can investigate further
Regards
Nick Hudson
Digital Software Partner Engineering
|
| From: VBORMC::"[email protected]" "Mats Nilsson" 7-APR-1997 15:59:30.12
To: "[email protected] - UK Software Partner Engineering 830-4121
07-Apr-1997 1445 +0100" <[email protected]>
CC:
Subj: RE: 23191 , missing records in rms files
Reply to the message of Monday April 7, 1997 16:38 +0100
-----------------------------------------------------------------
Hi Nick
No this was only a problem with a very slow customer maschine runing
OpenVms 7.0 and Oracle 7.3, when they stopped Oracle there was no problem=
.
So dont ask me what it was. We are now running OpenVMS 7.1 and it is much
faster, so close this report.
Mats
+----------------------------------------------+
! !
! oooooo ooooo Nectar Systems AB !
! ooooooo ooooo Mats Nilsson !
! oooooo ooo Development Manager !
! ooooooo ooo [email protected] !
! ooo oooo ooo Box 124 !
! ooo ooooooo S-281 22 H=E4ssleholm !
! ooooo oooooooo Tel. +46 (0)451 893 00 !
! ooooo ooooooo Fax. +46 (0)451 817 30 !
! !
! -For excellence in 4GL- !
! !
+----------------------- http://www.nectar.se -+
% ====== Internet headers and postmarks (see DECWRL::GATEWAY.DOC) ======
% Received: from mail13.digital.com (mail13.digital.com [192.208.46.30]) by
vbormc.vbo.dec.com (8.7.3/8.7) with ESMTP id QAA01928 for
<[email protected]>; Mon, 7 Apr 1997 16:52:42 +0200
% Received: from nectar by mail13.digital.com (8.7.5/UNX 1.5/1.0/WV) id
KAA02181; Mon, 7 Apr 1997 10:45:53 -0400 (EDT
% Received: (from gmail@localhost) by nectar (8.6.12/8.6.12) id QAA17178 for
[email protected]; Mon, 7 Apr 1997 16:42:13 +0200
% Received: by gmail.nectar.se with Gmail (ginets/4.0.1) id 334907b1; Mon, 7 Apr
97 16:42:13 +010
% Date: Mon, 7 Apr 97 16:38:49 +0100
% Message-Id: <[email protected]>
% In-Reply-To: <[email protected]>
% From: Mats Nilsson <[email protected]>
% To: "[email protected] - UK Software Partner Engineering 830-4121
07-Apr-1997 1445 +0100" <[email protected]>
% Subject: RE: 23191 , missing records in rms files
% Mime-Version: 1.0
% Content-Type: text/plain; charset=ISO-8859-1
% Content-Transfer-Encoding: quoted-printable
|