----- Forwarded message from Cstdenis <[EMAIL PROTECTED]> ----- From: Cstdenis <[EMAIL PROTECTED]> To: Alvaro Herrera <[EMAIL PROTECTED]> 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
> [EMAIL PROTECTED] wrote: >> >> The following bug has been logged online: >> >> Bug reference: 3179 >> Logged by: >> Email address: [EMAIL PROTECTED] >> 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) ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
