Re: BUG #1917: autovaccuum crashes - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #1917: autovaccuum crashes
Date
Msg-id 20050928132442.GB5788@surnet.cl
Whole thread Raw
In response to BUG #1917: autovaccuum crashes  ("Theo Schlossnagle" <jesus@omniti.com>)
Responses Re: BUG #1917: autovaccuum crashes  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-bugs
On Wed, Sep 28, 2005 at 04:21:16AM +0100, Theo Schlossnagle wrote:

> Doing large data loads via the COPY command into a set of schema-identical
> tables table1, table2, table3 all of which inherrit table. (simulating
> Oracle's partitioning).  Periodically, we get:
>
>
> LOG:  autovacuum process (PID 9685) was terminated by signal 11
> LOG:  terminating any other active server processes
> LOG:  all server processes terminated; reinitializing
> LOG:  database system was interrupted at 2005-09-27 09:12:49 PDT

> The process doesn't seem to dump core.

Please run "ulimit -c unlimited" and restart the postmaster, to try to
get a core dump.  (It should be in the data/ directory, not in the
data/base/<oid>/ directory as it used to be in previous versions.)

If it doesn't work, please provide more details on your schema.  I'm
going to try to reproduce your problem here.

--
Alvaro Herrera                  http://www.amazon.com/gp/registry/5ZYLFMCVHXC
Tulio: oh, para qué servirá este boton, Juan Carlos?
Policarpo: No, aléjense, no toquen la consola!
Juan Carlos: Lo apretaré una y otra vez.

pgsql-bugs by date:

Previous
From: "Kelvin Lau"
Date:
Subject: Postgresql problem in AIX 5.3
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #1917: autovaccuum crashes