Hello Alexey, as if i tried different things i found an unusal way to solve that problem. Now i wanted to ask you (and the whole group) what side-effects can (or will) be caused by this procedure.
- i dropped the idexes (INDEX_20 & INDEX_26) - i modified the RDB$RELATIONS table to remove the SYSTEMFLAG off of the RDB$COLLATIONS - after that i was abled to drop that corrupt RDB$COLLATIONS table - i disconnected the database - i reconnected the database and received an error (missing table / some relations) - i executed a script to rebuild the RDB$COLLATIONS table ant its indexes - i modified the RDB$COLLATIONS table to add the SYSTEMFLAGS for that table and its indexes - then i re-inserted the 148 datasets that were originally in the COLLATIONS-table Now, backup/restore/everything else is working fine. Or it seems so. All of that has been done in an testing-environment! Now 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" (13-Sep-2012 17:46) From: Alexey Kovyazin <a...@ib-aid.com> To: firebird-support@yahoogroups.com Hello Maik, >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. This is a database corruption, but our IBFirstAID will not help in this case, since it's a system index problem. You can contact support at ib-aid.com to get professional recovery support through remote desktop. Regards, Alexey Kovyazin IBSurgeon (www.ib-aid.com) > > > 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 > <mailto:ts%40iblogmanager.com>> > To: firebird-support@yahoogroups.com > <mailto:firebird-support%40yahoogroups.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 > <mailto:ts%40iblogmanager.com>> > > To: firebird-support@yahoogroups.com > <mailto:firebird-support%40yahoogroups.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 > <mailto:ts%40iblogmanager.com>> > >> To: firebird-support@yahoogroups.com > <mailto:firebird-support%40yahoogroups.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] > > [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]