Thanks Ann,

It'd be great to know how this happened.

Ivan:

Could you please explain how the Forced Write flag not been set can cause
this to happen? If there were two transactions writing the same PK in and
Forced Writes are disabled wouldn't the data be lost if a power cycle
occurred as Michal suggested?

Cheers,

-Ryan

Ryan Thomas
TransActive Systems

P: (02) 4322 3302
F: (02) 4325 1141
E: ryan@...
W: http://www.transactive.com.au/

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
> Sent: Wednesday, 13 July 2005 1:39 AM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Duplicate Primary Keys
>
> Ryan Thomas wrote:
> >
> > The database supplied has not been backed up (I tried so
> that I could
> > reduce the size, but to no luck with the restoration). I can't find
> > any trailing blanks on the keys, somehow there is a key in there
> > violating the PK constraint!
>
> That should not be, and probably indicates a bug somewhere.
> Firebird uses the same rules (i.e. truncate trailing blanks)
> for comparing unique keys as it does for other comparisons,
> so the loss of trailing blanks wouldn't make any difference.
>
> At the moment, due to bad planning, all version of Firebird
> and Vulcan on my system are broken. As soon as I get a
> working debuggable version, I'll have a look and see if
> there's anything interesting about that database. Primary
> key and unique indexes can hold duplicate values as long as
> no single transaction can see more than one record with a
> particular value, so the id's and history of the transactions
> that created the duplicates may be interesting.
> >
>
> Regards,
>
>
> Ann
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net 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
>
>
>
>
>
>
>