Thunderstone Support Forums

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.

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.