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.