From: | Thomas Good <tomg(at)admin(dot)nrnet(dot)org> |
---|---|
To: | Vadim Mikheev <vadim(at)krs(dot)ru> |
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:04:28 |
Message-ID: | Pine.LNX.3.96.990706085453.14504A-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:
> Stuart Rison wrote:
> >
> > Since I thought that probably left the table a bit messed up, I started a:
> >
> > VACUUM blast_hits;
> >
> > It's using 95% of the cpu and seems to be going nowhere (at least not in
> > the 30 minutes it has been running so far).
> >
> > QUESTION 2: What do I do now? Is there any way I can kill the VACUUM or
> > will they be the final nail in the table's coffin?
>
> VACUUM uses transactions so there shouldn't be problems with
> its stopping.
> After that try to drop all indices over blash_hits and re-vacuum
> (in verbose mode).
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.
To recap, one of tables caused vacuum to abort with a fatal bit of stderr.
This generated a stale lock which I manually removed. I iterated thru this
ps a few times until I realized that I had to drop table and re-create.
A simple delete from and copy did not resolve the issue. (Pg ver 6.3.2.)
This is a puzzle to me as this table was small...it is now growing daily.
Can you tell me:
1) what causes bufmgr.c to barf and kill vacuum when something is returned
as `-2', ie `PINNED'?
2) how alarmed should I be?
3) is there a recommended fix (and/or a deprecated fix? ;-) How can I avoid
TIA,
Tom
Here is the stderr I mentioned:
NOTICE: BlowawayRelationBuffers(tx_plan, 4): block 4 is referenced (private 0, last 0, global 1)
FATAL 1: VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2
NOTICE: BlowawayRelationBuffers(tx_plan, 4): block 4 is referenced (private 0, last 0, global 1)
FATAL 1: VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2
NOTICE: BlowawayRelationBuffers(tx_plan, 4): block 4 is referenced (private 0, last 0, global 1)
FATAL 1: VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2
NOTICE: BlowawayRelationBuffers(tx_plan, 0): block 4 is referenced (private 0, last 0, global 1)
FATAL 1: VACUUM (vc_vacheap): BlowawayRelationBuffers returned -2
------- 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 | Vadim Mikheev | 1999-07-06 13:15:37 | Re: [GENERAL] Stuck in a vacuum. |
Previous Message | Stuart Rison | 1999-07-06 12:52:12 | Re: [GENERAL] Stuck in a vacuum. |