headers
Richard Lewis | 1 Oct 2010 02:47
Picon

[U2] UV index with duplicate nodes

We've just uncovered a rather unusual and unsettling situation.  We have a
file with a single index that has somehow gotten nodes with duplicate keys.
A simple example would be having an index on ZIPCODE in a address database,
and finding that there are _two_ nodes (records) in the index for ZIPCODE
12345, for example.  The source records referred to in the nodes are not
duplicated, but since most operations find the 'first' node, any source
records referred to in the duplicate node appear to not exist in the index.

>LIST.INDEX fname ALL
Alternate Key Index Summary for file fname
File........... fname
Indices........ 1 (1 A-type, 0 C-type, 0 D-type, 0 I-type, 0 SQL, 0 S-type)
Index Updates.. Enabled, No updates pending

Index name      Type  Build    Nulls  In DICT  S/M  Just Unique Field
num/I-type
fieldname        A    Not Reqd  Yes    Yes      M    L     N    2

The file contains 6,539,233 records, with 574,547 unique values in fieldname
(which is actually a single-valued field, and has been verified that each
record's fieldname contains one and only one value).  We found that 9 source
records appear to have not been included in the index, but upon further
research found the nodes with duplicate keys.  We created an F-pointer to
the index file itself (not normally recommended, but useful), then got the
results like the following:

LIST indexfile WITH  <at> ID = "12345]" F1 F2

fname..... F1........ F2........
12345      987654     876543
(Continue reading)

Permalink | Reply | 7 comments |
headers
ANANT KUMAR PANDEY | 1 Oct 2010 03:22
Picon

Re: [U2] where did everyone go ?

Same here :-)

Anant

On Tue, Sep 28, 2010 at 12:58 PM, <bparker <at> nemianlife.lu> wrote:

> I'm lurking as usual, nothing to add, lots to learn. 8-)
>
> Brian
>
>
>
> From:   "u2ug" <simpson-u2ug <at> gerzio.ca>
> To:     <u2-users <at> listserver.u2ug.org>
> Date:   27/09/2010 18:07
> Subject:        [U2]  where did everyone go ?
> Sent by:        u2-users-bounces <at> listserver.u2ug.org
>
>
>
> The number of postings has drastically dropped over the past few weeks
> down to virtually zero
> Has the list been relegated the dust bin and I missed the notice ?
>
>
>
> _______________________________________________
> U2-Users mailing list
> U2-Users <at> listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
(Continue reading)

Permalink | Reply | 4 comments |
headers
Chris Austin | 1 Oct 2010 03:59
Picon
Favicon

Re: [U2] where did everyone go ?


I'm still here :) I noticed the same thing though. Wonder if some people dropped off the mailing list..

-Chris

 
> Date: Fri, 1 Oct 2010 06:52:26 +0530
> From: anantkumarp <at> gmail.com
> To: u2-users <at> listserver.u2ug.org
> Subject: Re: [U2] where did everyone go ?
> 
> Same here :-)
> 
> Anant
> 
> On Tue, Sep 28, 2010 at 12:58 PM, <bparker <at> nemianlife.lu> wrote:
> 
> > I'm lurking as usual, nothing to add, lots to learn. 8-)
> >
> > Brian
> >
> >
> >
> > From: "u2ug" <simpson-u2ug <at> gerzio.ca>
> > To: <u2-users <at> listserver.u2ug.org>
> > Date: 27/09/2010 18:07
> > Subject: [U2] where did everyone go ?
> > Sent by: u2-users-bounces <at> listserver.u2ug.org
> >
> >
(Continue reading)

Permalink | Reply | 0 comments |
headers
Chris Austin | 1 Oct 2010 04:01
Picon
Favicon

Re: [U2] where did everyone go ?


I just replied to this thread, and noticed something very odd. I got this message:

MVarghese <at> silverlinewindow.com - no such user here.

There is no user by that name at this server.
: Message contains [1] file attachments

-----------------------------------------------------------------------

Maybe this has something to do with it??

-Chris

 
> Date: Fri, 1 Oct 2010 06:52:26 +0530
> From: anantkumarp <at> gmail.com
> To: u2-users <at> listserver.u2ug.org
> Subject: Re: [U2] where did everyone go ?
> 
> Same here :-)
> 
> Anant
> 
> On Tue, Sep 28, 2010 at 12:58 PM, <bparker <at> nemianlife.lu> wrote:
> 
> > I'm lurking as usual, nothing to add, lots to learn. 8-)
> >
> > Brian
> >
(Continue reading)

Permalink | Reply | 1 comment |
headers
Chris Austin | 1 Oct 2010 04:02
Picon
Favicon

Re: [U2] where did everyone go ?


I just replied to this thread, and noticed something very odd. I got this message:

MVarghese <at> silverlinewindow.com - no such user here.

There is no user by that name at this server.
: Message contains [1] file attachments

-----------------------------------------------------------------------

Maybe this has something to do with it??

-Chris

 
> Date: Fri, 1 Oct 2010 06:52:26 +0530
> From: anantkumarp <at> gmail.com
> To: u2-users <at> listserver.u2ug.org
> Subject: Re: [U2] where did everyone go ?
> 
> Same here :-)
> 
> Anant
> 
> On Tue, Sep 28, 2010 at 12:58 PM, <bparker <at> nemianlife.lu> wrote:
> 
> > I'm lurking as usual, nothing to add, lots to learn. 8-)
> >
> > Brian
> >
(Continue reading)

Permalink | Reply | 0 comments |
headers
Israel, John R. | 1 Oct 2010 04:03

Re: [U2] where did everyone go ?

I have received several of those mystery E-mails as well, plus that attachment.  The attachment has always
had the same name but been variable in size, and I have not opened it.

John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH  45342
937-866-0711 x44380
-----Original Message-----
From: u2-users-bounces <at> listserver.u2ug.org [mailto:u2-users-bounces <at> listserver.u2ug.org] On
Behalf Of Chris Austin
Sent: Thursday, September 30, 2010 10:01 PM
To: u2-users <at> listserver.u2ug.org
Subject: Re: [U2] where did everyone go ?

I just replied to this thread, and noticed something very odd. I got this message:

MVarghese <at> silverlinewindow.com - no such user here.

There is no user by that name at this server.
: Message contains [1] file attachments

-----------------------------------------------------------------------

Maybe this has something to do with it??

-Chris
(Continue reading)

Permalink | Reply | 0 comments |
headers
jpb-u2ug | 1 Oct 2010 04:19
Picon
Favicon

Re: [U2] UV index with duplicate nodes

Does the correlative have any special coding in it? I would suggest deleting
the index for this field recreate the field as a D type then add the field
to the index again. Some correlatives don't give you what you would expect.

Jerry Banker

-----Original Message-----
From: u2-users-bounces <at> listserver.u2ug.org
[mailto:u2-users-bounces <at> listserver.u2ug.org] On Behalf Of Richard Lewis
Sent: Thursday, September 30, 2010 7:47 PM
To: U2-Users <at> listserver.u2ug.org
Subject: [U2] UV index with duplicate nodes

We've just uncovered a rather unusual and unsettling situation.  We have a
file with a single index that has somehow gotten nodes with duplicate keys.
A simple example would be having an index on ZIPCODE in a address database,
and finding that there are _two_ nodes (records) in the index for ZIPCODE
12345, for example.  The source records referred to in the nodes are not
duplicated, but since most operations find the 'first' node, any source
records referred to in the duplicate node appear to not exist in the index.

>LIST.INDEX fname ALL
Alternate Key Index Summary for file fname
File........... fname
Indices........ 1 (1 A-type, 0 C-type, 0 D-type, 0 I-type, 0 SQL, 0 S-type)
Index Updates.. Enabled, No updates pending

Index name      Type  Build    Nulls  In DICT  S/M  Just Unique Field
num/I-type
fieldname        A    Not Reqd  Yes    Yes      M    L     N    2
(Continue reading)

Permalink | Reply | 1 comment |
headers
Chris Austin | 1 Oct 2010 05:23
Picon
Favicon

Re: [U2] UV index with duplicate nodes


I assume you have tried rebuilding the indices? 

That usually fixes almost all of our issues with index problems. Otherwise I would delete the index and
build it back again. If you need any code that we use just ask me and I can email it to you. 

-Chris

 
> From: jpb-u2ug <at> hotmail.com
> To: u2-users <at> listserver.u2ug.org
> Date: Thu, 30 Sep 2010 21:19:22 -0500
> Subject: Re: [U2] UV index with duplicate nodes
> 
> Does the correlative have any special coding in it? I would suggest deleting
> the index for this field recreate the field as a D type then add the field
> to the index again. Some correlatives don't give you what you would expect.
> 
> Jerry Banker
> 
> 
> -----Original Message-----
> From: u2-users-bounces <at> listserver.u2ug.org
> [mailto:u2-users-bounces <at> listserver.u2ug.org] On Behalf Of Richard Lewis
> Sent: Thursday, September 30, 2010 7:47 PM
> To: U2-Users <at> listserver.u2ug.org
> Subject: [U2] UV index with duplicate nodes
> 
> We've just uncovered a rather unusual and unsettling situation. We have a
> file with a single index that has somehow gotten nodes with duplicate keys.
(Continue reading)

Permalink | Reply | 0 comments |
headers
Richard Brown | 1 Oct 2010 13:02
Picon

Re: [U2] UV index with duplicate nodes

Look for a space or non printing character in the data.  That would make it 
look the same but actually be unique.

----- Original Message ----- 
From: "Richard Lewis" <rbl000 <at> gmail.com>
To: <U2-Users <at> listserver.u2ug.org>
Sent: Thursday, September 30, 2010 8:47 PM
Subject: [U2] UV index with duplicate nodes

> We've just uncovered a rather unusual and unsettling situation.  We have a
> file with a single index that has somehow gotten nodes with duplicate 
> keys.
> A simple example would be having an index on ZIPCODE in a address 
> database,
> and finding that there are _two_ nodes (records) in the index for ZIPCODE
> 12345, for example.  The source records referred to in the nodes are not
> duplicated, but since most operations find the 'first' node, any source
> records referred to in the duplicate node appear to not exist in the 
> index.
>
>>LIST.INDEX fname ALL
> Alternate Key Index Summary for file fname
> File........... fname
> Indices........ 1 (1 A-type, 0 C-type, 0 D-type, 0 I-type, 0 SQL, 0 
> S-type)
> Index Updates.. Enabled, No updates pending
>
> Index name      Type  Build    Nulls  In DICT  S/M  Just Unique Field
> num/I-type
> fieldname        A    Not Reqd  Yes    Yes      M    L     N    2
(Continue reading)

Permalink | Reply | 4 comments |
headers
u2ug | 1 Oct 2010 14:52
Picon

Re: [U2] where did everyone go ?

I guess everyone is just happy happy so no reason post ?  Or has the
list just become irrelevant ?

-----Original Message-----
From: u2-users-bounces <at> listserver.u2ug.org
[mailto:u2-users-bounces <at> listserver.u2ug.org] On Behalf Of Chris Austin
Sent: September 30, 2010 10:00 PM
To: u2-users <at> listserver.u2ug.org
Subject: Re: [U2] where did everyone go ?

I'm still here :) I noticed the same thing though. Wonder if some people
dropped off the mailing list..

-Chris

 
> Date: Fri, 1 Oct 2010 06:52:26 +0530
> From: anantkumarp <at> gmail.com
> To: u2-users <at> listserver.u2ug.org
> Subject: Re: [U2] where did everyone go ?
> 
> Same here :-)
> 
> Anant
> 
> On Tue, Sep 28, 2010 at 12:58 PM, <bparker <at> nemianlife.lu> wrote:
> 
> > I'm lurking as usual, nothing to add, lots to learn. 8-)
> >
> > Brian
(Continue reading)

Permalink | Reply | 0 comments |

Gmane