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 <t...@iblogmanager.com> 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 <t...@iblogmanager.com> > 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 <t...@iblogmanager.com> >> 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]