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.
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 |