pgsql: Fix memory leaks in PL/Python.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix memory leaks in PL/Python.
Date: 2015-11-05 18:52:59
Message-ID: E1ZuPed-0005C5-Mr@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix memory leaks in PL/Python.

Previously, plpython was in the habit of allocating a lot of stuff in
TopMemoryContext, and it was very slipshod about making sure that stuff
got cleaned up; in particular, use of TopMemoryContext as fn_mcxt for
function calls represents an unfixable leak, since we generally don't
know what the called function might have allocated in fn_mcxt. This
results in session-lifespan leakage in certain usage scenarios, as for
example in a case reported by Ed Behn back in July.

To fix, get rid of all the retail allocations in TopMemoryContext.
All long-lived allocations are now made in sub-contexts that are
associated with specific objects (either pl/python procedures, or
Python-visible objects such as cursors and plans). We can clean these
up when the associated object is deleted.

I went so far as to get rid of PLy_malloc completely. There were a
couple of places where it could still have been used safely, but on
the whole it was just an invitation to bad coding.

Haribabu Kommi, based on a draft patch by Heikki Linnakangas;
some further work by me

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/8c75ad436f75fc629b61f601ba884c8f9313c9af

Modified Files
--------------
src/pl/plpython/plpy_cursorobject.c | 30 +++++---
src/pl/plpython/plpy_cursorobject.h | 1 +
src/pl/plpython/plpy_exec.c | 2 +-
src/pl/plpython/plpy_main.c | 39 +++++++---
src/pl/plpython/plpy_main.h | 3 +
src/pl/plpython/plpy_planobject.c | 19 ++---
src/pl/plpython/plpy_planobject.h | 1 +
src/pl/plpython/plpy_procedure.c | 118 +++++++++++++----------------
src/pl/plpython/plpy_procedure.h | 2 +
src/pl/plpython/plpy_spi.c | 30 ++++++--
src/pl/plpython/plpy_subxactobject.c | 15 +++-
src/pl/plpython/plpy_typeio.c | 137 ++++++++++++++++------------------
src/pl/plpython/plpy_typeio.h | 6 +-
src/pl/plpython/plpy_util.c | 36 ---------
src/pl/plpython/plpy_util.h | 5 --
15 files changed, 221 insertions(+), 223 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2015-11-05 23:16:01 pgsql: Fix erroneous hash calculations in gin_extract_jsonb_path().
Previous Message Robert Haas 2015-11-05 17:21:26 pgsql: Pass extra data to bgworkers, and use this to fix parallel conte