Multi Threading Problem with Python + Django + PostgreSQL.
Nikita the Spider
NikitaTheSpider at gmail.com
Mon Mar 31 17:08:09 CEST 2008
<553b16a7-a89e-4892-b92b-c0f88e00e096 at e23g2000prf.googlegroups.com>,
Pradip <pradipbhosale at gmail.com> wrote:
> Hello every body. I am new to this forum and also in Python.
> Read many things about multi threading in python. But still having
> I am using Django Framework with Python having PostgreSQL as backend
> database with Linux OS. My applications are long running. I am using
> The problem I am facing is that the connections that are being created
> for database(postgres) update are not getting closed even though my
> threads had returned and updated database successfully. It is not like
> that the connections are not being reused. They r being reused but
> after sometime new one is created. Like this it creates too many
> connections and hence exceeding MAX_CONNECTION limit of postgres conf.
> ** I am using psycopg2 as adaptor for python to postgres connection.
> which itself handles the connections(open/close)
A common problem that new users of Python encounter is that they expect
database statements to COMMIT automatically. Psycopg2 follows the Python
DB-API specification and does not autocommit transactions unless you ask
it to do so. Perhaps your connections are not closing because they have
To enable autocommit, call this on your connection object:
> Now the problem is with Django / Python / psycopg2 or any thing else??
Are you asking if there are bugs in this code that are responsible for
your persistent connections? If so, then I'd say the answer is almost
certainly no. Of course it's possible, but Django/Psycopg/Postgres is a
pretty popular stack. The odds that there's a major bug in this popular
code examined by many eyes versus a bug in your code are pretty low, I
think. Don't take it personally, the same applies to my me and my code.
Whole-site HTML validation, link checking and more
More information about the Python-list