On 03/06/2011 08:03, Maya Opperman wrote:

> Hi Kjell,
>
>>> Sounds like a "traditional" deadlock to me, but I don't know why it
> would happen on insert... Any triggers that could be writing the same
> record somewhere? Or anything else lika that, that gets triggered as a
> side effect of the inserts?
>
> Ah, good thought! My initial thought was, no, I don't, but I wet to go look and I see there is this on after insert of new tasks:
>
> post_event 'new_task';
>
> I'd forgotten I'd been experimenting with events at once stage!
>
> And this on insertion of new support incidents:
>
> IF (NEW.ID IS NULL) THEN
> NEW.ID = GEN_ID(GEN_CUSTOMERINCIDENTS_ID,0);

Shouldn't that be:

NEW.ID = GEN_ID(GEN_CUSTOMERINCIDENTS_ID,1);


http://www.firebirdsql.org/refdocs/langrefupd20-genid.html

Werner