From: | Anj Adu <fotographs(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | server process crash |
Date: | 2009-10-20 14:04:27 |
Message-ID: | f2fd819a0910200704n1951edbex69da24d9088e4fb0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I ocassionally get this error when a large insert is made to a very
large table (Postgres 8.1.9)
Hardware is 8 core Dell 2950 with 6x300G Raid 10 Disk setup.
LOG: server process (PID 25002) exited with exit code 1
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.
When I vacuum the table and retry the process..it works. The vacuum
output has this warning which indicates that the crash left the table
in an invalid state.
WARNING: relation "test_dimpart_dimension" page 159809 is
uninitialized --- fixing
WARNING: relation "test_dimpart_dimension" page 159810 is
uninitialized --- fixing
Why does the crash occur (there were no prior crashes) and can we get
more diagnostics on the actual cause of the error.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-10-20 14:25:20 | Re: WAL file compatibility |
Previous Message | Scott Mead | 2009-10-20 13:48:55 | Re: How to troubleshoot a halted postgres 8.3 ? |