Re: [GENERAL] vacuum is failing

2005-01-04 Thread Lonni J Friedman
On Tue, 04 Jan 2005 18:30:43 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: > Lonni J Friedman <[EMAIL PROTECTED]> writes: > > ERROR: No one parent tuple was found > > > Anyone have any suggestions on how to correct this? > > Shut down whatever long-running transaction is hanging around in the > bac

Re: [GENERAL] vacuum is failing

2005-01-04 Thread Tom Lane
Lonni J Friedman <[EMAIL PROTECTED]> writes: > ERROR: No one parent tuple was found > Anyone have any suggestions on how to correct this? Shut down whatever long-running transaction is hanging around in the background. You wouldn't be getting this error if vacuum weren't trying to move a chain

[GENERAL] vacuum is failing

2005-01-04 Thread Lonni J Friedman
I've got a server running PostgreSQL-7.2.3 on RHAS-2.1. The version of Postgresql is *not* my choice, I would have gone with something much more current, but i digress. Running 'vacuumdb -a -z -v -f' has started failing: NOTICE: Index pg_toast_218644531_idx: Pages 1; Tuples 0. CPU 0.00s