From: | "Stock, Stuart" <Stuart(dot)Stock(at)DrKW(dot)com> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Getting "cannot remove lock from HTAB" during VACUUM FULL |
Date: | 2005-11-28 21:34:37 |
Message-ID: | 6F47643287F3A34B8EE40B91602974DBF935BA@ibnycce153.us.ad.drkw.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
All,
During our weekly VACUUM FULL we get a "ERROR: cannot remove lock from HTAB"
message and then the database appears to hang completely. Other processes
can connect to the database, but all queries hang. We must stop the database
and restart it to recover. The two times this has occurred, the hang did not
happen in the same place during the VACUUM.
This behavior has only started recently; the database has been running
smoothly for over a year prior to this. We're using Postgresql 7.4.5 on an
Intel box running Red Hat AS 2.1.
Has anyone seen this before or can anyone shed some light into what might be
causing this?
Thanks,
Stuart
If you have received this e-mail in error or wish to read our e-mail disclaimer statement and monitoring policy, please refer to http://www.drkw.com/disc/email/ or contact the sender.
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 2005-11-28 21:35:04 | Re: intarray index |
Previous Message | Jim C. Nasby | 2005-11-28 21:05:51 | Re: Slow pgdump |