[cstdenis@ctgameinfo.com: Re: BUG #3179: crash when canceling avacuum]

----- Forwarded message from Cstdenis <cstdenis(at)ctgameinfo(dot)com> -----

From: Cstdenis <cstdenis(at)ctgameinfo(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Date: Wed, 21 Mar 2007 10:44:49 -0700 (PDT)
Subject: Re: [BUGS] BUG #3179: crash when canceling avacuum
X-Bogosity: Ham, tests=bogofilter, spamicity=0.000000, version=1.1.3

> cstdenis(at)ctgameinfo(dot)com wrote:
>>
>> The following bug has been logged online:
>>
>> Bug reference: 3179
>> Logged by:
>> Email address: cstdenis(at)ctgameinfo(dot)com
>> PostgreSQL version: 8.2.0
>> Operating system: FreeBSD 6.2
>> Description: crash when canceling avacuum
>> Details:
>>
>> I started a vacuumdb -a -v -z then changed my mind to cancled it under
>> pgadminIII. First try didn't seem to work to I clicked the button a few
>> more
>> times. Whole server crashed.
>
> What was the error message in the server log?
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>

Mar 20 22:29:39 ayu postgres[58424]: [1-1] WARNING: PID 60260 is not a
PostgreSQL server process
Mar 20 22:29:48 ayu postgres[60274]: [1-1] ERROR: canceling statement due
to user request
Mar 20 22:29:48 ayu postgres[60274]: [1-2] STATEMENT: VACUUM FULL VERBOSE
ANALYZE;
Mar 20 22:29:48 ayu postgres[60274]: [1-3]
Mar 20 22:29:48 ayu postgres[60274]: [2-1] PANIC: cannot abort
transaction 293233494, it was already committed
Mar 20 22:30:06 ayu kernel: pid 60274 (postgres), uid 70: exited on signal
6 (core dumped)
Mar 20 22:30:06 ayu postgres[60295]: [1-1] WARNING: terminating
connection because of crash of another server process
Mar 20 22:30:06 ayu postgres[60295]: [1-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and
exit, because another server
Mar 20 22:30:06 ayu postgres[60295]: [1-3] process exited abnormally and
possibly corrupted shared memory.
Mar 20 22:30:06 ayu postgres[60295]: [1-4] HINT: In a moment you should
be able to reconnect to the database and repeat your command.

----- End forwarded message -----

--
Alvaro Herrera http://www.flickr.com/photos/alvherre/
"Oh, great altar of passive entertainment, bestow upon me thy discordant images
at such speed as to render linear thought impossible" (Calvin a la TV)