Subject | Re: [firebird-support] Restore problem |
---|---|
Author | Aldo Caruso |
Post date | 2011-12-19T13:05:44Z |
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 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ó:
>[Non-text portions of this message have been removed]
>
> > 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/
>
>