Subject Re: [firebird-support] Error accessing file ""
Author Helen Borrie
At 12:12 PM 23/03/2004 +0000, you wrote:
>We are trying to migrate from Interbase 6.0.1 to Firebird 1.5 on SuSE
>linux 8.1.
>
>When trying to restore the backup (about 4.5 GB), we get the following
>error:
>
>...
>gbak: restoring privilege for user *****
>gbak: creating indexes
>gbak: restoring index RDB$PRIMARY77
>gbak: restoring index RDB$PRIMARY73
>gbak: restoring index RDB$PRIMARY65
>gbak: restoring index RDB$72
>gbak: restoring index RDB$PRIMARY62
>gbak: cannot commit index RDB$PRIMARY61
>gbak: ERROR: I/O error for file ""
>gbak: ERROR: Error while trying to open file
>gbak: ERROR: Permission denied
>gbak: ERROR: action cancelled by trigger (3) to preserve data
>integrity
>gbak: ERROR: Cannot deactivate primary index
>gbak: Exiting before completion due to errors
>
>It seems that a file with name "" is being accessed (which of course
>does not exist). The problem is reproducable and always happens at the
>same spot during backup. Strange thing: restoring on a different
>system with the same environment (or so it seems) does work! We did
>the restore on that other system and then moved the DB. It works, but
>while using the DB, we occasionally also get the above error during
>queries.

Is this an index on an external table?
/hb