Skip site navigation (1) Skip section navigation (2)

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

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: [cstdenis@ctgameinfo.com: Re: BUG #3179: crash when canceling avacuum]
Date: 2007-03-21 17:52:11
Message-ID: 20070321175211.GD11351@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-bugs
----- 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)

In response to

Responses

pgsql-bugs by date

Next:From: msmbarabino@virgilio.itDate: 2007-03-21 18:00:27
Subject: Very slow bytea extraction
Previous:From: Alvaro HerreraDate: 2007-03-21 17:30:08
Subject: Re: BUG #3179: crash when canceling avacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group