Horton

General Bug Report: Memory leak in backend on failed inserts

Unprivileged user <nobody>

View thread
From: Unprivileged user <nobody>
To: pgsql-bugs@postgresql.org
Date: 1999-01-14T19:10:27Z
Lists: pgsql-bugs 
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name		: Thomas Reinke
Your email address	: reinke@e-softinc.com

Category		: runtime: back-end
Severity		: serious

Summary: Memory leak in backend on failed inserts

System Configuration
--------------------
  Operating System   : Linux 2.0.30 RedHat

  PostgreSQL version : 6.3

  Compiler used      : gcc 2.7.2.1

Hardware:
---------
Linux www4 2.0.30 #1 Tue Apr 22 10:49:45 EDT 1997 i686 unknown
Pentium MMX 128 Meg

Versions of other tools:
------------------------


--------------------------------------------------------------------------

Problem Description:
--------------------
The postgres backend leaks memory in a serious fashion
on failed inserts. With batch programs doing many inserts,
a system with 212 Meg virtual memory runs out of memory
after approximately 20,000 failed inserts.

Workaround: repeatedly reset the database connection
to close the old backend down and start a new one.

--------------------------------------------------------------------------

Test Case:
----------
Any failed insert, repeatedly done, will demonstrate
this leak.

--------------------------------------------------------------------------

Solution:
---------


--------------------------------------------------------------------------