[GENERAL] locked up backends

2001-04-05 Thread Maurice Balick
Hello, We are running Postgres 7.0.2 on Linux RH 6.2 Dell servers. When traffic gets heavy we often get one of the backend locked up in an UPDATE, INSERT or COMMIT request. Eventually all the other backends end up locking too as they try to access a row locked by the original backend. The out

Re: [GENERAL] Deadlock detected

2001-04-09 Thread Maurice Balick
Brian J. France wrote: > > BTW, on a different table I get this warning ever time I vacuum the database. It doesn't seem to cause a problem, but didn't know how to get rid of it. > > NOTICE: Index : NUMBER OF INDEX' TUPLES (214) IS NOT THE SAME AS HEAP' (215). > Recreate the index

Re: [GENERAL] Deadlock detected

2001-04-13 Thread Maurice Balick
Hi Tom, [EMAIL PROTECTED]">"Brian J. France" <[EMAIL PROTECTED]> writes: I am getting a few of these errors in my web logs and didn't know what I could do to stop it. NOTICE: Deadlock detected -- See the lock(l) manual page for a possible cause. Error in query "UPDATE SET = WHER