Hello there,

the problem persists. WTF is this?

- doing a GBAK backup shows NO ERRORS!
- GFIX shows NO ERRORS!
- FBFirstAid shows NO ERRORS!
- validating the Database via IBExpert shows NO ERRORS!
- the Database is working fine!
- there are NO duplicated Values in that RDB$COLLATIONS Table (i took an old Backup, restored it, and there were 148 entrys in that table, just like now)
- Backup/Restore via nbackup is working fine!

This problem is really getting very anoying!

btw: Doing a restore in IBExpert shows a bit more information:
IBE: Creating log file R:\RESTORE_VERBOSE.txt
IBE: Starting restore. Current time: 12:59:34
IBE: Invalid insert or update value(s): object columns are constrained - no 2 table rows can have duplicate column values.
attempt to store duplicate value (visible to active transactions) in unique index "RDB$INDEX_20".
IBE: Restore completed. Current time: 12:59:36. Elapsed time: 00:00:02

Is there any helpful information?

btw2: dropping that RDB$INDEX_20 didn`t help anything.


Mit freundlichen Grüßen aus der Lutherstadt
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]