Hello Alexey,

copying a database that has no accessing instances is the recommended way, i read. Why is it a database corruption? What happened there? FBFirstAid 2.6 said everything`s fine!

Here`s a snippet of it`s LOG:

13.09.2012 13:04:53 INFO: Open database files: A:\ams4database\DB0.FDB

13.09.2012 13:04:53 INFO: Analyzing database low-level structures...
13.09.2012 13:04:53 INFO: Process database file #1 of 1 files.
13.09.2012 18:43:13 INFO: Actual PageCount: 6894935 found in database
13.09.2012 18:43:13 INFO: Found 17371 reserved and/or undefined pages.
13.09.2012 18:43:13 INFO: ====== DATABASE IS READY FOR DIAGNOSING AND REPAIRING. ====
13.09.2012 18:43:13 INFO: ====== Now choose "Diagnose" or "Repair". ====
14.09.2012 09:17:21 INFO: ------------------- Starting diagnose
14.09.2012 09:17:21 INFO: Running procedure: Header page check
14.09.2012 09:17:21 INFO: ODS Major = 11 (32779)
14.09.2012 09:17:21 INFO: ODS Minor = 2
14.09.2012 09:17:21 INFO: Next transaction = 68793348
14.09.2012 09:17:21 INFO: Oldest transaction = 68793346
14.09.2012 09:17:21 INFO: Oldest active = 68793347
14.09.2012 09:17:21 INFO: Oldest snapshot = 68793347
14.09.2012 09:17:21 INFO: PageSize is Ok = 4096
14.09.2012 09:17:21 INFO: Running procedure: Checking of RDB$Pages consistency
14.09.2012 09:18:58 INFO: Checking of RDB$Pages consistency: Ok
14.09.2012 09:18:58 INFO: Running procedure: Low-level check of all relations
14.09.2012 09:18:58 INFO: Relation RDB$PAGES (0) is OK
14.09.2012 09:18:58 INFO: Relation RDB$DATABASE (1) is OK
14.09.2012 09:18:58 INFO: Relation RDB$FIELDS (2) is OK
14.09.2012 09:18:58 INFO: Relation RDB$INDEX_SEGMENTS (3) is OK
14.09.2012 09:18:59 INFO: Relation RDB$INDICES (4) is OK
14.09.2012 09:18:59 INFO: Relation RDB$RELATION_FIELDS (5) is OK
14.09.2012 09:18:59 INFO: Relation RDB$RELATIONS (6) is OK
14.09.2012 09:18:59 INFO: Relation RDB$VIEW_RELATIONS (7) is OK
14.09.2012 09:18:59 INFO: Relation RDB$FORMATS (8) is OK
14.09.2012 09:18:59 INFO: Relation RDB$SECURITY_CLASSES (9) is OK
14.09.2012 09:18:59 INFO: Relation RDB$FILES (10) is OK
14.09.2012 09:18:59 INFO: Relation RDB$TYPES (11) is OK
14.09.2012 09:18:59 INFO: Relation RDB$TRIGGERS (12) is OK
14.09.2012 09:19:00 INFO: Relation RDB$DEPENDENCIES (13) is OK
14.09.2012 09:19:00 INFO: Relation RDB$FUNCTIONS (14) is OK
14.09.2012 09:19:00 INFO: Relation RDB$FUNCTION_ARGUMENTS (15) is OK
14.09.2012 09:19:00 INFO: Relation RDB$FILTERS (16) is OK
14.09.2012 09:19:00 INFO: Relation RDB$TRIGGER_MESSAGES (17) is OK
14.09.2012 09:19:00 INFO: Relation RDB$USER_PRIVILEGES (18) is OK
14.09.2012 09:19:00 INFO: Relation RDB$TRANSACTIONS (19) is OK
14.09.2012 09:19:00 INFO: Relation RDB$GENERATORS (20) is OK
14.09.2012 09:19:00 INFO: Relation RDB$FIELD_DIMENSIONS (21) is OK
14.09.2012 09:19:00 INFO: Relation RDB$RELATION_CONSTRAINTS (22) is OK
14.09.2012 09:19:00 INFO: Relation RDB$REF_CONSTRAINTS (23) is OK
14.09.2012 09:19:00 INFO: Relation RDB$CHECK_CONSTRAINTS (24) is OK
14.09.2012 09:19:00 INFO: Relation RDB$LOG_FILES (25) is OK
14.09.2012 09:19:00 INFO: Relation RDB$PROCEDURES (26) is OK
14.09.2012 09:19:00 INFO: Relation RDB$PROCEDURE_PARAMETERS (27) is OK
14.09.2012 09:19:00 INFO: Relation RDB$CHARACTER_SETS (28) is OK
14.09.2012 09:19:00 INFO: Relation RDB$COLLATIONS (29) is OK
14.09.2012 09:19:00 INFO: Relation RDB$EXCEPTIONS (30) is OK
14.09.2012 09:19:00 INFO: Relation RDB$ROLES (31) is OK
14.09.2012 09:19:00 INFO: Relation RDB$BACKUP_HISTORY (32) is OK
.................
.................
.................
.................
14.09.2012 09:42:05 INFO: Low-level check of all relations: Ok
14.09.2012 09:42:05 INFO: ------------------- Finished diagnose--------

regards
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]




To: ak@...
firebird-support@yahoogroups.com


[Non-text portions of this message have been removed]