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 <ak@... <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 <ts@...
> <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 <ts@...
> <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 <ts@...
> <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]