BUG #1917: autovaccuum crashes

From: "Theo Schlossnagle" <jesus(at)omniti(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1917: autovaccuum crashes
Date: 2005-09-28 03:21:16
Message-ID: 20050928032116.7D274F0BDD@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1917
Logged by: Theo Schlossnagle
Email address: jesus(at)omniti(dot)com
PostgreSQL version: 8.1devel
Operating system: CentOS 4.1 (Linux 2.6.12.3)
Description: autovaccuum crashes
Details:

We're running an otherwise idle instance.

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
...
LOG: autovacuum process (PID 10116) 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 10:39:19 PDT
...
LOG: autovacuum process (PID 10626) was terminated by signal 11
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.

The process doesn't seem to dump core.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-09-28 04:34:37 Re: BUG #1916: selection criteria from one outer join on clause applied to other joins
Previous Message Kelvin Lau 2005-09-28 02:14:59 Postgresql problem in AIX 5.3