Re: [GENERAL] Stuck in a vacuum.

From: Thomas Good <tomg(at)admin(dot)nrnet(dot)org>
To: Vadim Mikheev <vadim(at)krs(dot)ru>
Cc: "PostgreSQL::General List" <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] Stuck in a vacuum.
Date: 1999-07-07 17:23:03
Message-ID: Pine.LNX.3.96.990707132152.10609A-100000@admin.nrnet.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 6 Jul 1999, Vadim Mikheev wrote:

Vadim - thanks very much for the reply! Sorry to take up your time on
this...

Dobri vecher,
Tom

> > 1) what causes bufmgr.c to barf and kill vacuum when something is returned
> > as `-2', ie `PINNED'?
>
> Buffer was pinned by someone, but shouldn't be. This could be caused
> by buffer leak problem. It's known that FATAL may cause buffer leak.
> Did you see FATALs before vacuum?
>
> >
> > 2) how alarmed should I be?
>
> Shouldn't. No damage is expected in this case.
>
> >
> > 3) is there a recommended fix (and/or a deprecated fix? ;-) How can I avoid
>
> Stop postmaster. Sure that there is no backend running.
> Start postmaster. vacuum.

------- North Richmond Community Mental Health Center -------

Thomas Good MIS Coordinator
Vital Signs: tomg@ { admin | q8 } .nrnet.org
Phone: 718-354-5528
Fax: 718-354-5056

/* Member: Computer Professionals For Social Responsibility */

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kaare Rasmussen 1999-07-07 19:51:54 Re: [GENERAL] July 1999 issue of Sys Admin
Previous Message Joost Kraaijeveld 1999-07-07 16:54:51 RE: [GENERAL] How to compile PosttgreSQL on NT]