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
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
Hello there,
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
Hello there!
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
Greetings from Lutherstadt Wittenberg :-)
Maik Sommer
IT-Systemadministrator
processed by
The Result is:
RDB$RELATION_NAMERDB$FIELD_NAME
RDB$COLLATIONSRDB$COLLATION_NAME
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
Hi,
the Result is NULL
Question: An index-reorg should fix this, right? Because i`ve done so tuesday
night...
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
We`ve got a CRM-System here, therefore is the database. Within this software,
you`re abled to do a check of the database structure, optional with
reorganisation of the indexes.
Mit freundlichen Grüßen aus der Lutherstadt
Maik Sommer
IT-Systemadministrator
processed by David.fx