Getting "cannot remove lock from HTAB" during VACUUM FULL

Started by Stock, Stuartover 20 years ago2 messagesgeneral
Jump to latest
#1Stock, Stuart
Stuart.Stock@DrKW.com

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.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Stock, Stuart (#1)
Re: Getting "cannot remove lock from HTAB" during VACUUM FULL

"Stock, Stuart" <Stuart.Stock@DrKW.com> writes:

During our weekly VACUUM FULL we get a "ERROR: cannot remove lock from HTAB"
message and then the database appears to hang completely.

Try updating --- I see a 7.4.8 fix that might be relevant.

regards, tom lane