pgsql: Fix snapshot leak if lo_open called on non-existent object. - Mailing list pgsql-committers

From Heikki Linnakangas
Subject pgsql: Fix snapshot leak if lo_open called on non-existent object.
Date
Msg-id E1VQaMX-00023q-5q@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix snapshot leak if lo_open called on non-existent object.

lo_open registers the currently active snapshot, and checks if the
large object exists after that. Normally, snapshots registered by lo_open
are unregistered at end of transaction when the lo descriptor is closed, but
if we error out before the lo descriptor is added to the list of open
descriptors, it is leaked. Fix by moving the snapshot registration to after
checking if the large object exists.

Reported by Pavel Stehule. Backpatch to 8.4. The snapshot registration
system was introduced in 8.4, so prior versions are not affected (and not
supported, anyway).

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/357f7521384df34c697b3544115622520a6a0e9f

Modified Files
--------------
src/backend/storage/large_object/inv_api.c |   44 ++++++++++++++++------------
1 file changed, 26 insertions(+), 18 deletions(-)


pgsql-committers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: pgsql: Fix snapshot leak if lo_open called on non-existent object.
Next
From: Heikki Linnakangas
Date:
Subject: pgsql: In bms_add_member(), use repalloc() if the bms needs to be enlar