kdbfchk reccomended flags

Post Reply
jkj2001
Posts: 142
Joined: Fri Mar 29, 2002 1:39 pm

kdbfchk reccomended flags

Post by jkj2001 »

Hi,

We have a table that needs some TLC. When we select certain records from it we get swarmed with KDBF errors, like so:

005 Corrupt block header at 0x5170EA in KDBF file /database/rrr/yhg/thetable/documents.tbl in the function read_head

running kdbfchk against the table yielded:

"Bad block summary:
1518 orphaned free blocks found"

I'm not an expert in kdbfchk, but I gamely tried using the "-o" flag to output to a new file. It did so but the errors remained. Can you provide a small sample of kdbf commands, with flags, that might fix the problem above? We're using your Linux flavor of texis, version 4.04.1067366033. Thanks.
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

kdbfchk reccomended flags

Post by mark »

Orphaned free blocks are usually caused by the -q -O option. Orphaned free blocks are never recovered. The only way to get them back is to compact the table by copying it. Use copydbf to copy just the data blocks. You'll need to rebuild all indices for the copied table. Or just ignore the orphans.
Post Reply