Re: autovacuum process (PID ...) was terminated by signal 11

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brian Hirt <bhirt(at)mobygames(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: autovacuum process (PID ...) was terminated by signal 11
Date: 2006-01-04 17:04:20
Message-ID: 3526.1136394260@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Brian Hirt <bhirt(at)mobygames(dot)com> writes:
> When I'm doing a database load of a 5gb database, autovacuum always
> segfaults shortly after the load finishes.

This sure looks like the same bug already fixed in 8.1.1:

2005-11-28 08:35 alvherre

* src/backend/postmaster/autovacuum.c: Set a snapshot before
running analyze on a single table, to avoid a crash when analyzing
tables with expressional indexes.

Per report from Frank van Vugt.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Brian Hirt 2006-01-04 17:11:22 Re: autovacuum process (PID ...) was terminated by signal 11
Previous Message Brian Hirt 2006-01-04 16:48:02 autovacuum process (PID ...) was terminated by signal 11