Subject Re: [ib-support] Re: Error 335544349
Author Carsten Schäfer
my problem is that i attempted to restore over the original db
(without knowing that there was a bug).
Now i only have the .gbk-file.
Is there any chance to restore the data ?

gruse
Carsten

----- Original Message -----
From: "alex_vnru" <ded@...>
To: <ib-support@yahoogroups.com>
Sent: Friday, January 18, 2002 8:46 PM
Subject: [ib-support] Re: Error 335544349


--- In ib-support@y..., Carsten Schäfer <ca_schaefer@g...> wrote:
> Hi,
> i have an serious error with restoring a db (a production db at a
customer!).
>
> I have done a backup and than i upgraded to Firebird RC2 (Windows
2000 Server SP2),
> after that i want to restore the database and get the following
error:
> Error 335544349
> Attempt to store duplicate value (visble to active transactions) in
unique index "RDB$Index_11".
>
> The same error was reported on 7.1. in this newsgroup without any
response.

Carsten, I answered this question at least 3 times in this least an
7.1. too. There was some tech problem this day if I recall correctly.
So, I repeat

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 !!!)

Can't say what you can do if you have gbk only. But change RC1 for
RC2 don't require b/r. If you have previous instance of database, you
can access it with RC2, make what I said and backup it once more.

Best regards, Alexander V.Nevsky.