Subject Re: [firebird-support] Lost Transactions
Author Ann W. Harrison
rekkod wrote:
> I had a Lock-Conflict a few days ago where two users updated the same
> record. The applications were re-started, but after the Lock Conflict
> every time that that record is accessed (by any one user), it gives a
> Lock Conflict.

Were you using a replication tool when the error occurred? The thought
that occurs to me is that your application might have two databases
open, and thus using two-phased commits which could (possibly) have left
something in limbo. gfix -l <database> will tell you.

Regards,


Ann