Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: autovacuum process (PID ...) was terminated by signal 11
Date
Msg-id 3526.1136394260@sss.pgh.pa.us
Whole thread Raw
In response to autovacuum process (PID ...) was terminated by signal 11  (Brian Hirt <bhirt@mobygames.com>)
Responses Re: autovacuum process (PID ...) was terminated by signal 11
List pgsql-bugs
Tree view 
Brian Hirt <bhirt@mobygames.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

pgsql-bugs by date:

Previous
From: Brian Hirt
Date:
Subject: autovacuum process (PID ...) was terminated by signal 11
Next
From: Brian Hirt
Date:
Subject: Re: autovacuum process (PID ...) was terminated by signal 11