Subject Re: [firebird-support] unsuccessful metadata update
Author Jason Dodson
I believe that is due to a violation in a foreign key constraint.

Jason

Bill Meaney wrote:
> We got this error on a restore of a database.
>
> gbak: cannot commit index RDB$FOREIGN14
> gbak: ERROR: unsuccessful metadata update
> gbak: ERROR: object CPTMOD is in use
> gbak: ERROR: action cancelled by trigger (3) to preserve data integrity
>
> This restore is part of our rebuild process in which we:
> - verify that there are no connections
> - shut down the database
> - shut down the db engine
> - start guardian
> - backup the database
> - save the original database
> - restore the database (ERROR)
> - confirm successful restore
> - bring the database back online
>
> If the database is offline, why would we get "object CPTMOD is in use"?
>
>
> Bill Meaney
> wameaney@...
> TPMS, Inc.
> http://www.tpms.com
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>