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