Crash after VACUUM FULL cancel

From: "Hardwick, Joe" <Joe(dot)Hardwick(at)fnis(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Crash after VACUUM FULL cancel
Date: 2008-04-09 13:52:03
Message-ID: 1D134C5F69F974449CCE35EFBA14205B020F4004@CMBFISLTC01.FNFIS.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I realize this is very little info to go on but our server had some
trouble this morning..

Postgres 8.2.4
Linux unicron.marketingsolutionsinc.com 2.6.15-1.2054_FC5smp #1 SMP Tue
Mar 14 16:05:46 EST 2006 i686 i686 i386 GNU/Linux

PID: 15980 - 2008-04-09 07:49:20 CDT - USER: postgres - DB: maverick -
CMD: VACUUM - ERROR: canceling statement due to user request
PID: 15980 - 2008-04-09 07:49:20 CDT - USER: postgres - DB: maverick -
CMD: VACUUM - STATEMENT: VACUUM FULL ANALYZE bsg_pike.accounts
PID: 15980 - 2008-04-09 07:49:20 CDT - USER: postgres - DB: maverick -
CMD: VACUUM - PANIC: cannot abort transaction 116388108, it was already
committed
PID: 4363 - 2008-04-09 07:49:20 CDT - USER: - DB: - CMD: - LOG:
server process (PID 15980) was terminated by signal 6
PID: 4363 - 2008-04-09 07:49:20 CDT - USER: - DB: - CMD: - LOG:
terminating any other active server processes
PID: 28867 - 2008-04-09 07:49:20 CDT - USER: skatz - DB: maverick -
CMD: idle - WARNING: terminating connection because of crash of another
server process
PID: 28867 - 2008-04-09 07:49:20 CDT - USER: skatz - DB: maverick -
CMD: idle - 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.
PID: 28867 - 2008-04-09 07:49:20 CDT - USER: skatz - DB: maverick -
CMD: idle - HINT: In a moment you should be able to reconnect to the
database and repeat your command.
PID: 27424 - 2008-04-09 07:49:20 CDT - USER: bsg_pike - DB: maverick -
CMD: SELECT waiting - WARNING: terminating connection because of crash
of another server process
PID: 27424 - 2008-04-09 07:49:20 CDT - USER: bsg_pike - DB: maverick -
CMD: SELECT waiting - 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.

We have a cronjob that runs nightly to do the VACUUM FULL ANALYZE on a
few tables in each schema and occasionally we'll cancel one if they take
longer than usual to run and block our morning loads.. This is the first
time Postgres has had any trouble with it. Is cancelling a full vacuum
a bad idea?

I know I'm not going to find any solution to why it happened, I'm just
looking for anyone's take on it..

Thanks,
Joe

______________

The information contained in this message is proprietary and/or confidential. If you are not the
intended recipient, please: (i) delete the message and all copies; (ii) do not disclose,
distribute or use the message in any manner; and (iii) notify the sender immediately. In addition,
please be aware that any message addressed to our domain is subject to archiving and review by
persons other than the intended recipient. Thank you.
_____________

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-04-09 14:01:52 Re: tsvector_update_trigger throws error "column is not of tsvector type"
Previous Message Hardwick, Joe 2008-04-09 13:42:08 Re: Trouble getting effective_cache_size parameter to take