Re: URGENT! I/O error on index
Hello Obnoxio!
Good idea - but I got Error 16094 on all tables...
Best regards!
Dirk Emmermacher
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