Fix autovacuum work item error handling

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

Commit: 52ca7572c3642ccbb46a619c03efe1928811ceae
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2017-10-30T14:52:13Z
Releases: 10.1
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 +20 −8

Discussion