Skip site navigation (1) Skip section navigation (2)

Re: segfault of autovacuum process during restore - coredumps included

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)nl>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: segfault of autovacuum process during restore - coredumps included
Date: 2005-11-28 17:24:05
Message-ID: 20051128172405.GD18576@surnet.cl (view raw or flat)
Thread:
Lists: pgsql-bugs
Tom Lane wrote:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> > The attached patch should correct the problem, but I'd like to make sure
> > it does ...
> 
> Rather than that, I'd suggest just setting ActiveSnapshot
> unconditionally after each of the StartTransactionCommand calls in
> autovacuum.c, ie make the code look just like vacuum.c:
> 
> 	/* Begin a transaction for vacuuming this relation */
> 	StartTransactionCommand();
> 	/* functions in indexes may want a snapshot set */
> 	ActiveSnapshot = CopySnapshot(GetTransactionSnapshot());

Done.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

pgsql-bugs by date

Next:From: Frank van VugtDate: 2005-11-28 20:17:39
Subject: Re: segfault of autovacuum process during restore - coredumps included
Previous:From: Tom LaneDate: 2005-11-28 17:19:58
Subject: Re: Bug on CHARACTER(n) ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group