Subject RE: [firebird-support] Re: duplicates in a table with PK
Author Puigsegur, Jordi
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

C:\ >gfix -validate -user sysdba -password masterkey

C:\ >gfix -validate -full -user sysdba -password masterkey



[] On Behalf Of Adam
Sent: Friday, June 01, 2007 1:32 AM
Subject: [firebird-support] Re: duplicates in a table with PK

--- In
<> , "Puigsegur, Jordi"
<jordi.puigsegur@...> wrote:
> We have a very strange situation with a FireBird database: a table
> 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.


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