Thanks for your answer. I reinstalled firebird from scratch, and now the final error message is
gbak:creating indexes gbak: activating and creating deferred index PK_STATS_ABONOS gbak: activating and creating deferred index PK_PAGOS_ANONIMOS gbak: activating and creating deferred index PK_TOPES gbak: activating and creating deferred index PK_REGISTROS 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 El 19/12/11 03:38, Thomas Steinmaurer escribió: > > > > 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/ > > [Non-text portions of this message have been removed]
