--- In firebird-support@yahoogroups.com, "Alexander V.Nevsky" <ded@h..
.> wrote:

> --- In firebird-support@yahoogroups.com, "agarzotto" <garzotto@a...>
> 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.
>
> 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,
> Alexander.

Taht's it! /tmp did not have write permission for user firebird. It
worked with interbase as it did run as root.

Wow, this list should not be free as the advice is worth a million :-)

Andreas Garzotto