Обсуждение: BUG #2257: Can' stop server while autovacuum is running

The following bug has been logged online:

Bug reference:      2257
Logged by:          Evgeny Gridasov
Email address:      eugrid@fpm.kubsu.ru
PostgreSQL version: 8.1.2 CVS
Operating system:   Linux Debian
Description:        Can' stop server while autovacuum is running
Details:

I needed to shutdown my server urgently, but I was unable to stop server by
pg_ctl -m fast.
Examining process list I found out that an autovacuum process is still
active.

autovacuum process (when active) did not respond to kill (TERM). Only kill
-9 helped to stop autovacuum process.

"Evgeny Gridasov" <eugrid@fpm.kubsu.ru> writes:
> autovacuum process (when active) did not respond to kill (TERM). Only kill
> -9 helped to stop autovacuum process.

autovacuum does respond to shutdown requests, but in poking at this I
found that btree index vacuuming may fail to notice a pending interrupt
for long periods, if you've got large indexes.  I've committed a fix
for that.

            regards, tom lane

Tom Lane wrote:
> "Evgeny Gridasov" <eugrid@fpm.kubsu.ru> writes:
> > autovacuum process (when active) did not respond to kill (TERM). Only kill
> > -9 helped to stop autovacuum process.
>
> autovacuum does respond to shutdown requests, but in poking at this I
> found that btree index vacuuming may fail to notice a pending interrupt
> for long periods, if you've got large indexes.  I've committed a fix
> for that.

Good catch.  I have heard index creation doesn't cancel easily, but
never investigated.

--
  Bruce Momjian   http://candle.pha.pa.us
  SRA OSS, Inc.   http://www.sraoss.com

  + If your life is a hard drive, Christ can be your backup. +