Re: autovacuum process (PID ...) was terminated by signal 11 - Mailing list pgsql-bugs

From Brian Hirt
Subject Re: autovacuum process (PID ...) was terminated by signal 11
Date
Msg-id DC535E5C-14CE-431A-88E1-8E1E68CA82EA@mobygames.com
Whole thread Raw
In response to Re: autovacuum process (PID ...) was terminated by signal 11  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Jan 4, 2006, at 11:47 AM, Tom Lane wrote:

> Brian Hirt <bhirt@mobygames.com> writes:
>> I was just writing to let you know I created an easily reproducible
>> test case too, but I guess you don't need that now.
>
> Does your test case agree with my description of the problem?
> (If you're not sure, crank up log_min_messages and watch the log
> to see what autovacuum does before it crashes.)
>

Yes, I see the same exact same thing you describe.

>
> Definitely a big risk of that :-(.  It'll be a one-liner patch in any
> case, we just have to decide where ...
>

I applied your patch and I no longer see the problem with my test case.


Thanks for the quick responses and help!

--brian

--------------------------------------------
MobyGames
http://www.mobygames.com
The world's largest and most comprehensive
gaming database project

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: autovacuum process (PID ...) was terminated by signal 11
Next
From: Frank van Vugt
Date:
Subject: Re: autovacuum process (PID ...) was terminated by signal 11