John, reload your database. This will create a completely new set of
files, including the indexes, with all the information in it. Any errors
found will be in the .log file.
DISCONNECT
COPY db.rb? backup.rb?
SET MULTI OFF
OUTPUT backup.log WITH SCREEN
CONNECT backup
RELOAD db
OUTPUT SCREEN
John Docherty wrote:
I have a database which keeps on generating the following error when I
try to insert a row into a table
<WARNING> Problems updating index file. Index file may have been
corrupted. (2860)
-ERROR- I/O problems - Check for a full disk. (2009)
There is certainly no lack of space on the disk. Does anyone have any
suggestions as to what may be causing this, and how to fix this.
(RScope doesn’t find any errors, neither does autochk)
Any suggestions would be much appreciated. Thank you.
Regards,
John Docherty
