Den 2011-06-03 07:09 skrev Maya Opperman såhär:

> I did manage to discover that it happened when one person added a
> comment from one PC, and was fine with them adding further comments,
> until a SECOND person added a comment on another PC. That was when
> everything would hang.
>
> The comment is a record, with a time, ID, and a blob for the memo.
>
> In my main system, which has no problems, I also have records with blobs
> for memos, and can happily add new records via different PC with no hanging.

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?

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64