Re: URGENT! I/O error on index
Posted in 2000
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