Hello Maik, I think this is Ok to use such workaround, since everything is Ok.
Regards, Alexey Kovyazin IBSurgeon (www.ib-aid.com) > 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 <mailto:ak%40ib-aid.com>> > To: firebird-support@yahoogroups.com > <mailto:firebird-support%40yahoogroups.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> > > <mailto:ts%40iblogmanager.com>> > > To: firebird-support@yahoogroups.com > <mailto:firebird-support%40yahoogroups.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> > > <mailto:ts%40iblogmanager.com>> > > > To: firebird-support@yahoogroups.com > <mailto:firebird-support%40yahoogroups.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> > > <mailto:ts%40iblogmanager.com>> > > >> To: firebird-support@yahoogroups.com > <mailto:firebird-support%40yahoogroups.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] > > [Non-text portions of this message have been removed]
