Hello Thomas,

the querys are executed in a copy of that db. On tuesday, i recognized the issue (that came without any reason). After a gbak, i stopped programs that were using the database, stopped the default instance and made a copy to a different volume, so i have a database i can Analyse. Currently, i made another copy, that i use to Analyse it with IBFirstAid 2.6.

I think this is a very 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: Thomas Steinmaurer <ts@...>
To: firebird-support@yahoogroups.com

> The Result is:
>
> RDB$RELATION_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
>
>
>
> 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]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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]