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