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@xxxxxxxxxxxxxxx This work was visionary and imaginative, and goes to show that visionary and imaginative work need not end up well. --Dennis Ritchie
