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 */
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] |