Milan Babuskov wrote:

>
> The same backup file restores with FB 1.0.3 without problems.
> The problematic version is FB ClassicServer 1.5.2-4371.
>
> Here's the tail of restore:
> gbak: cannot commit index RDB$PRIMARY16
> gbak: ERROR: I/O error for file ""
> gbak: ERROR: Error while trying to open file
> gbak: ERROR: Permission denied
> gbak: ERROR: sort error
> gbak: ERROR: action cancelled by trigger (3) to preserve data integrity
> gbak: ERROR: Cannot deactivate primary index
> gbak: Exiting before completion due to errors
>
> I checked the RDB$PRIMARY16 index. It is a primary key that composes of two
> columns varchar(20) + integer. I did a select that show that there aren't
> duplicates:

The error indicates that the sort necessary to create the index failed
because Firebird couldn't open a temp file, apparently because the
process didn't have access to the default temp directory. Firebird 1.5
is fussier about where it opens files than Firebird 1.0 was - check the
release notes and be sure that you've got an appropriate (and large)
temp directory.

Regards,


Ann