Fix autovacuum work item error handling

Alvaro Herrera <alvherre@alvh.no-ip.org>

Commit: be72b9c378bfe99a3d175c98d36dc150229f4faf
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2017-10-30T14:52:02Z
Releases: 11.0
Fix autovacuum work item error handling

In autovacuum's "work item" processing, a few strings were allocated in
the current transaction's memory context, which goes away during error
handling; if an error happened during execution of the work item, the
pfree() calls to clean up afterwards would try to release already-released
memory, possibly leading to a crash.  In branch master, this was already
fixed by commit 335f3d04e4c8, so backpatch that to REL_10_STABLE to fix
the problem there too.

As a secondary problem, verify that the autovacuum worker is connected
to the right database for each work item; otherwise some items would be
discarded by workers in other databases.

Reported-by: Justin Pryzby
Discussion: https://postgr.es/m/20171014035732.GB31726@telsasoft.com

Files

PathChange+/−
src/backend/postmaster/autovacuum.c modified +3 −3

Discussion