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: Thomas Steinmaurer <ts@...>
To: firebird-support@yahoogroups.com

> Thanks for your quick response.
> The query
> "select
> rdb$collation_name
> from
> rdb$collations
> group by
> rdb$collation_name
> having
> count(*) > 1"
>
> results in:
>
> RDB$COLLATION_NAME
> <NULL>

And what's 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'

Regards,
Thomas

> Greetings from Lutherstadt Wittenberg :-)
> Maik Sommer
> IT-Systemadministrator
>
>
>
> 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 <ts@...>
> To: firebird-support@yahoogroups.com
>
>
>
>> 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 errors
>>
>> Here`s the clue: The database is working fine. There are no duplicated roles, no duplicated datasets, index-reorg is working fine, gfix could`t find ANY errors.
>>
>> I tried to find out, which relation "RDB$INDEX_20" has. It refers to a table named "Abrechnung", Column named "RUECKBUCHUNG". But there are no duplicated values. In fact, Column "RUECKBUCHUNG" is always empty (IS NULL).
>>
>> Any Ideas?
>
> IMHO, RDB$INDEX_20 is an index on the RDB$COLLATIONS system table. This
> can be proved by:
>
> 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'
>
> So, basically this means, there are duplicate values in
> RDB$COLLATIONS.RDB$COLLATION_NAME. What do you get by executing the
> following query?
>
> select
> rdb$collation_name
> from
> rdb$collations
> group by
> rdb$collation_name
> having
> count(*) > 1
>
> Greetings from Austria (lost 1:2 unlucky). ;-)
>
> Regards,
> Thomas
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org 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
>
>
>

[Non-text portions of this message have been removed]