> 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/
