| From: | Vadim Mikheev <vadim(at)krs(dot)ru> |
|---|---|
| To: | Thomas Good <tomg(at)admin(dot)nrnet(dot)org> |
| Cc: | Stuart Rison <stuart(at)ludwig(dot)ucl(dot)ac(dot)uk>, pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] Stuck in a vacuum. |
| Date: | 1999-07-06 13:15:37 |
| Message-ID: | 37820179.AA6C043E@krs.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thomas Good wrote:
>
> Vadim - any chance I can get my question answered? It is slightly more
> than academic to me as we now have several Pg production databases running
> here in my shop...I know you're busy but I am *not* a C programmer and altho
> I've read your listing I am still in the dark.
Sorry. Well.
> 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.
Vadim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan davis | 1999-07-06 14:34:05 | another problem |
| Previous Message | Thomas Good | 1999-07-06 13:04:28 | Re: [GENERAL] Stuck in a vacuum. |