Re: Vacuum Failed - backend closed the channel unexpectedly

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dave Smith <dave(at)candata(dot)com>
Cc: PostgresSQL mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Vacuum Failed - backend closed the channel unexpectedly
Date: 2001-05-18 19:23:30
Message-ID: 22880.990213810@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dave Smith <dave(at)candata(dot)com> writes:
> Running Linux 2.2.14 postgresql 7.0.3
> I am trying to run a vacuum and I get the following output

> vacuum;
> NOTICE: FlushRelationBuffers(menudt, 6): block 3 is referenced (private
> 0, global 2)
> FATAL 1: VACUUM (vc_vacheap): FlushRelationBuffers returned -2

Is this reproducible from a standing start? I'd expect it to go away
after a postmaster restart.

It would be moderately interesting if you can figure out the sequence
that got you into that state (ie, buffer reference counts > 0).

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michelle Murrain 2001-05-18 19:33:13 Re: Which Front End for Postgresql
Previous Message Brent R. Matzelle 2001-05-18 19:00:39 Re: NEED Postgresql ODBC driver.