Subject | Re: Firebird 2.1.1 Gbak Issues |
---|---|
Author | Matt Nielsen |
Post date | 2009-03-13T17:15:20Z |
This error is during a restore of the noon backup not during a backup.
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 10:44 AM 13/03/2009, you wrote:
> >here is another error that I get sometimes on a restore of the noon backup. Again, I have never had this problem with the backup when there is noone on the system.
> >
> >gbak: ERROR:attempt to store duplicate value (visible to active transactions) in unique index "RDB$INDEX_11"
> >gbak:Exiting before completion due to errors
>
> This during a **backup** ?? gbak -b ??? That smells like a batch script or scheduler entry that has the wrong switch. Eeeew! Check 'im!
>
> RDB$INDEX_11 is the unique index on the generator name in RDB$GENERATORS. Now, a *restore* would be pumping data into that table so it's slightly feasible that this error could occur during a *restore*...though it would suggest that someone has been meddling with that system table unless at some point a partially restored database was put into production use.
>
> gbak -b doesn't write to the database at all. However (unless flagged otherwise with the -g switch) its select * queries on all tables triggers garbage collection, which writes to disk at a much lower level than DDL and certainly doesn't create, alter or drop records in the system tables.
>
> ./heLen
>