Re: psycopg2 hang with multithread frequent queries

From: Federico Di Gregorio <fog(at)dndg(dot)it>
To: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
Cc: David Roid <dataroid(at)gmail(dot)com>, psycopg(at)postgresql(dot)org
Subject: Re: psycopg2 hang with multithread frequent queries
Date: 2012-09-17 08:28:11
Message-ID: 5056DF1B.7000203@dndg.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

On 17/09/2012 10:21, Daniele Varrazzo wrote:
> On Fri, Sep 14, 2012 at 6:15 PM, David Roid <dataroid(at)gmail(dot)com> wrote:
>
>> > No long-running trac, commit is done fair often. I also tried "one conn for
>> > all threads" vs "one conn for one thread", and "one cursor all the way" vs
>> > "use and throw away cursor", issue remains.
> David has provided me further information about his setup and a gcc
> traceback, from which it was obvious that he was performing database
> queries from a signal handler. It seems he is not experiencing any
> more problems since he got rid of this unsafe practice.

Nice to know.

federico

--
Federico Di Gregorio federico(dot)digregorio(at)dndg(dot)it
Studio Associato Di Nunzio e Di Gregorio http://dndg.it
I did appreciate the irony that I was whining about encoding issues on
a mailing list that was unable to show those chars, too.
-- Antti S. Lankila to mono-devel-list@

In response to

Responses

Browse psycopg by date

  From Date Subject
Next Message David Roid 2012-09-17 23:24:08 Re: psycopg2 hang with multithread frequent queries
Previous Message Daniele Varrazzo 2012-09-17 08:21:57 Re: psycopg2 hang with multithread frequent queries