You were also reporting the hangs, right? Were you in the web interface at that time?
Maybe the deadlock is in the web side, not the db side.
Interesting. You also said you were running a dual-cpu box, right? If it’s a deadlock problem, that might make it show up quicker.
I have a g4 dual — I’ll set that up as a test box and pound it over the weekend and see if I can see where it’s coming from.
— Ron