Subject Re: Unique index "RDB$INDEX_11" error
Author alex_vnru
--- In ib-support@y..., "tmuetze.rm" <tmuetze@i...> wrote:
> Hello,
> I often got this error when I try to restore a backed-up gdb:
> "Attempt to store duplicate value (visible to active transactions)
in
> unique index "RDB$INDEX_11""
> When I look at RDB$INDICES I can see that RDB$INDEX_11 is an unique
> key for the field RDB$GENERATOR_NAME in RDB$GENERATORS. When I look
> at the values in RDB$GENERATORS.RDB$GENERATOR_NAME I cannot find a
> double entry.
> Any ideas?

Tilo, it's inherited from bug in RC1 gbak. Before backup databases
which were restored with it, make

Delete From RDB$GENERATORS where RDB$GENERATOR_NAME='RDB$SECURITY'

(not RDB$SECURITY_CLASS !!!)

Best regards, Alexander V.Nevsky.