Ann W. Harrison 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.

I was logged in as user "firebird". Of course, TMP env. variable points to
/root/tmp to which only the "root" has access. :(

This solves the problem. Thanx for the quick reply.

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org