Getting "cannot remove lock from HTAB" during VACUUM FULL

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.

Responses

Browse pgsql-general by date

  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