Subject Re: Error accessing file ""
Author Alexander V.Nevsky
--- In, "agarzotto" <garzotto@a...>
> 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.

Andreas, looks like FB have not OS level access rights on TMP
directory to sort in tmp-file when creating index or performing
natural order by/group by.

Best regards,