Re: URGENT! I/O error on index
From: NDSTURNERBUND@t-online.de (Dirk Emmermacher)
>
>Good idea - but I got Error 16094 on all tables...
A very nice trend you have bucked
at fixing data that is mucked
it seems clear to me
when this note I see
that your data's royally ......
>Obnoxio The Clown wrote:
> >
> > cd database.dbs
> >
> > for i in *.idx
> > do
> > becheck -y $i
> > done
> >
> > From: NDSTURNERBUND@t-online.de (Dirk Emmermacher)
> > >
> > >My old database version 4.00.UH2 (SE) on a HP-UX 10.01 produce errors
> > >for 2 days.
> > >On Wednesday I had recovered one table from backup.
> > >Error 246
> > >Error 5
> > >
> > >Today my main table got the same errors. I unloaded the table and make
> > >dbschema run on this table. After that the table was recreated and
> > >filled with the data. One hour later the error is there again.
> > > Here is a part of messages of a check table:
> > >
> > >Error in reading index
> > >file
> > >
> > >SYSTEM ERROR 5: read(index): I/O
> > >error
> > >Error in reading index
> > >file
> > >
> > >SYSTEM ERROR 5: read(index): I/O
> > >error
> > > 399 index node(s) used -- 3 index b-tree level(s)
> > >used
> > >
> > >ERROR: 2818 missing data record
> > >pointer(s)
> > >Delete index ?
> > >no
> > >
> > >Index 13 = duplicates
> > >(246,10,0)
> > > 555 index node(s) used -- 3 index b-tree level(s)
> > >used
> > >Index 14 = duplicates
> > >(256,10,0)
> > > 247 index node(s) used -- 3 index b-tree level(s)
> > >used
> > >Checking data record and index node free
> > >lists.
> > >
> > >ERROR: 68 missing index node
> > >pointer(s)
> > >Fix index node free list ?
> > >no
> > >
> > >5625 index node(s) used, 83 free -- 15676 data record(s) used, 1
> > >free.
> > >
> > >
> > >What can I do???
> > >
> > >Thanxs in advance.
> > >
> > >Best regards.
> > >
> > >Dirk Emmermacher
> > >Lowersaxony gymnastics federation
> >
> > ________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com