> I'm using firebird 2.0 super server on Linux Debian 5.0
> My server HD crashed, but I had a mirror disk, where I had all the
> OS mirrored and copies of the files *.fbk in order to restore the databases.
> When I try to restore a database it goes well, restoring several
> tables and their contents, but ends with the following lines
>
> gbak:creating indexes
> gbak: activating and creating deferred index PK_SELECTIONS
> gbak: activating and creating deferred index PK_PAGE_RANKS_1
> gbak:cannot commit index PK_PAGE_RANKS_1
> 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 index used by a PRIMARY/UNIQUE constraint
> gbak:Exiting before completion due to errors
>
> This happens to me with any other databases, ending with the lines
>
> gbak: ERROR:I/O error for file ""
> gbak: ERROR: Error while trying to open file
> gbak: ERROR: Permission denied
>
> Thanks in advance for any help

Perhaps a temp directory issue? Firebird might write temp files into the
file system when creating indices etc. Possibly:

- There is no temp directory
- There is not enough space on the disk with the temp directory
- You (firebird) doesn't have proper privileges to write into the temp
directory


Just a thought.


--
With regards,
Thomas Steinmaurer

* Upscene Productions - Database Tools for Developers
http://www.upscene.com/

* My Blog
http://blog.upscene.com/thomas/index.php

* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/