Re: Vacuum Failed - backend closed the channel unexpectedly

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Vacuum Failed - backend closed the channel unexpectedly
Дата
Msg-id 22880.990213810@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Vacuum Failed - backend closed the channel unexpectedly  (Dave Smith <dave@candata.com>)
Список pgsql-general
Dave Smith <dave@candata.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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Brent R. Matzelle"
Дата:
Сообщение: Re: NEED Postgresql ODBC driver.
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Postgres problem when compiling C++ in Red Hat 6.2