Subject | Re: 2 identical record inserts not stopped by UNIQUE constraint |
---|---|
Author | Stan |
Post date | 2006-10-24T21:47:23Z |
--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@...> wrote:
So I dont think that I will be able to reproduce it.
When this happened, no records were being deleted or updated.
Only insertions and selects using this procedure are occuring
from up to 200 concurrent transactions.
How
<aharrison@...> wrote:
>This is the first time this happened in about a year of testing.
> Stan wrote:
> >
> > I open a new isql session and I see the 2 records.
>
> Then it's a different problem. Can you cause it to
> happen using just that procedure - meaning that no one
> is deleting or updating records concurrently?
So I dont think that I will be able to reproduce it.
When this happened, no records were being deleted or updated.
Only insertions and selects using this procedure are occuring
from up to 200 concurrent transactions.
How
> big is the database?The DB is ~1GB.
>
>
> Regards,
>
>
> Ann
>