We use FireBird 2.0.0 superserver with forced writes enabled. Hardware
is a HP Server with RAID 1 disks running Windows Server 2003. We acces
the database using the .NET Firebird driver.



Verifying the database (am I doing it correctly?) doesn't show any
problem:



C:\ >gfix -validate -user sysdba -password masterkey
localhost:d:\firebird\corrupt.fdb



C:\ >gfix -validate -full -user sysdba -password masterkey
localhost:d:\firebird\corrupt.fdb



Jordi.



________________________________

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Adam
Sent: Friday, June 01, 2007 1:32 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: duplicates in a table with PK



--- In firebird-support@yahoogroups.com
<mailto:firebird-support%40yahoogroups.com> , "Puigsegur, Jordi"
<jordi.puigsegur@...> wrote:

>
> We have a very strange situation with a FireBird database: a table

with

> a PrimaryKey has duplicate values.

That should never happen unless you have corruption in the index
supporting the primary key constraint (which should never happen with
forced (synchronised) writes enabled).

I can't offer any more hints as to how it happenned, but you will need
to repair it manually. You can use RDB$DB_KEY to distinguish between
the records during the repair.

Adam





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