| From: | Brian Hirt <bhirt(at)mobygames(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-bugs(at)postgresql(dot)org, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| Subject: | Re: autovacuum process (PID ...) was terminated by signal 11 |
| Date: | 2006-01-04 20:39:43 |
| Message-ID: | DC535E5C-14CE-431A-88E1-8E1E68CA82EA@mobygames.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Jan 4, 2006, at 11:47 AM, Tom Lane wrote:
> Brian Hirt <bhirt(at)mobygames(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frank van Vugt | 2006-01-04 20:43:14 | Re: autovacuum process (PID ...) was terminated by signal 11 |
| Previous Message | Tom Lane | 2006-01-04 19:18:03 | Re: autovacuum process (PID ...) was terminated by signal 11 |