Hello there,
i have a problem with my 27Gb FB2.5 Database. Doing a backup is workíng fine.
Doing a restore is failing due to the following error:
gbak: ERROR:attempt to store duplicate value (visible to active transactions) in
unique index "RDB$INDEX_20"
gbak:Exiting before completion due to er
> i have a problem with my 27Gb FB2.5 Database. Doing a backup is workíng fine.
> Doing a restore is failing due to the following error:
>
> gbak: ERROR:attempt to store duplicate value (visible to active transactions)
> in
> unique index "RDB$INDEX_20"
> gbak:Exiting before completion due to e
d by David.fx
Subject: Re: [firebird-support] Restore fails due to "duplicate Value in unique
Index" (13-Sep-2012 14:03)
From:Thomas Steinmaurer
To: firebird-support@yahoogroups.com
> i have a problem with my 27Gb FB2.5 Database. Doing a backup is workíng fine.
> D
The Result is:
RDB$RELATION_NAMERDB$FIELD_NAME
RDB$COLLATIONSRDB$COLLATION_NAME
Regards
Maik Sommer
IT-Systemadministrator
processed by David.fx
Subject: Re: Re-2: [firebird-support] Restore fails due to "duplicate Value in
unique Index" (13-Sep-2012 14:13)
From:
ueries in the
database the faulty backup is based on?
Regards,
Thomas
> Regards
> Maik Sommer
> IT-Systemadministrator
>
>
>
> processed by David.fx
> Subject: Re: Re-2: [firebird-support] Restore fails due to "duplicate Value
> in unique Index" (13-Se
NAMERDB$FIELD_NAME
>> RDB$COLLATIONSRDB$COLLATION_NAME
>
> Thought so and that's weird. And you have executed both queries in the
> database the faulty backup is based on?
>
> Regards,
> Thomas
>
>> Regards
>> Maik Sommer
>> IT-Systemadministrator
>>
Subject: Re: Re-8: [firebird-support] Restore fails due to "duplicate Value in
unique Index" (13-Sep-2012 15:55)
From:Thomas Steinmaurer
To: firebird-support@yahoogroups.com
> the Result is
>
> Question: An index-reorg should fix this, right? Because i`ve done
2 09:42:05 INFO: Low-level check of all relations: Ok
14.09.2012 09:42:05 INFO: --- Finished diagnose
regards
Maik Sommer
IT-Systemadministrator
processed by David.fx
Subject: Re: Re-6: [firebird-support] Restore fails due to "duplicate Value in
unique
weird issue
>
> Mit freundlichen Grüßen aus der Lutherstadt
> Maik Sommer
> IT-Systemadministrator
>
> processed by David.fx
> Subject: Re: Re-4: [firebird-support] Restore fails due to "duplicate
> Value in unique Index" (13-Sep-2012 14:29)
> From: T
ow i need to know if there is anything that i should be worried about. If so:
where`s my mistake?
Greetings from Germany!
Maik Sommer
IT-Systemadministrator
processed by David.fx
Subject: Re: Re-6: [firebird-support] Restore fails due to "duplicate Value in
unique Index" (
r
>
>
>
> processed by David.fx
> Subject: Re: [firebird-support] Restore fails due to "duplicate Value in
> unique Index" (13-Sep-2012 14:03)
> From:Thomas Steinmaurer
> To: firebird-support@yahoogroups.com
>
>
>
>> i ha
>
>
>
> processed by David.fx
> Subject: Re: Re-2: [firebird-support] Restore fails due to "duplicate Value
> in unique Index" (13-Sep-2012 14:13)
> From:Thomas Steinmaurer
> To: firebird-support@yahoogroups.com
>
>
>
>> Thanks for
collation_name || ''
having
count(*) > 1
Regards,
Thomas
> Mit freundlichen Grüßen aus der Lutherstadt
> Maik Sommer
> IT-Systemadministrator
>
>
>
> processed by David.fx
> Subject: Re: Re-4: [firebird-support] Restore fails due to "duplicate Val
> the Result is
>
> Question: An index-reorg should fix this, right? Because i`ve done so tuesday
> night...
How did you do that?
Regards,
Thomas
the result of:
> >
> > select
> > i.rdb$relation_name
> > , s.rdb$field_name
> > from
> > rdb$indices i join rdb$index_segments s on (i.rdb$index_name =
> > s.rdb$index_name)
> > where
> > i.rdb$index_name = 'RDB$INDEX_20'
> >
e worried
> about. If so: where`s my mistake?
>
> Greetings from Germany!
> Maik Sommer
> IT-Systemadministrator
>
> processed by David.fx
> Subject: Re: Re-6: [firebird-support] Restore fails due to "duplicate
> Value in unique Index" (13-Sep-2012 17:46)
>
16 matches
Mail list logo