Subject Error 'reached end of file' during restore
Author Bob Murdoch
During our nightly backup and restore, the restore failed with the
following messages:

gbak: cannot commit index FK_INV_TRUCK_TO_INV_TRUCK
gbak: ERROR: I/O error for file "E:\DB\BACKUP\RESTORE_THU\ABC.FDB"
gbak: ERROR: Error while trying to read from file
gbak: ERROR: Reached the end of the file.
gbak: ERROR: action cancelled by trigger (3) to preserve data
integrity
gbak: ERROR: Cannot deactivate primary index
gbak: Exiting before completion due to errors


This is FB 1.5 running on W2k3 server. I am doing the restore with
the embedded version of FB into a compressed folder. The DB file
(after the error) was 37.1GB (16.2GB size on disk). The day prior,
the restore was successful. The resulting DB was 37.2GB (16.3GB size
on disk), so it looks like the restore was very nearly finished when
it came upon this error.

I'm curious what could have caused this problem? It looks to me like
an out of space error, but that wasn't the case.

Bob M..