Re: error during vacuum full

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Barry Lind <barry@xythos.com>
Cc: PostgreSQL Hacker <pgsql-hackers@postgresql.org>
Date: 2002-07-10T04:14:29Z
Lists: pgsql-hackers
Barry Lind <barry@xythos.com> writes:
> It was not compiled with debug.  I will do that now and see if this 
> happens again in the future.  If and when it happens again what would 
> you like me to do?  I am willing provide you access if you need it.

Well, first off, please confirm that killing off open client
transactions (you shouldn't even need to do a full postmaster restart)
makes the problem go away.

Beyond that, I have no advice except to be prepared to apply a debugger
next time.  I believe we could fix the problem if we could examine the
situation VACUUM is seeing --- but it's so far not been possible to
do that, because the triggering conditions are so transient.

			regards, tom lane