On Wed, Sep 27, 2006 at 06:46:42PM +0200, Kai Hessing wrote:
>
> Deadlock means it hangs up and doesn't terminate through timeout.
No, it doesn't. Deadlock means, for the two deadlocked queries, both
cannot possibly finish because each waits on a lock that the other
one holds.
You can cause such deadlocks in your application, too, of course, but
they're not database deadlocks.
Also. . .
> There is no output. It just takes forever.
. . .define "forever". Is it doing any work? Do you see i/o? Is it
in SELECT WAITING state?
A
--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
--Dennis Ritchie