Re: psycopg2 hang with multithread frequent queries - Mailing list psycopg

From David Roid
Subject Re: psycopg2 hang with multithread frequent queries
Date
Msg-id CAKN1bq7zxMHy52zffxiM=dtQMLkzDXBOxbuF2pWiFLkkwEK84w@mail.gmail.com
Whole thread Raw
In response to Re: psycopg2 hang with multithread frequent queries  (Federico Di Gregorio <fog@dndg.it>)
Responses Re: psycopg2 hang with multithread frequent queries
List psycopg
Hi Daniele, Federico,

Just want to know, if I keep signal handler but switch from thread to subprocess, i.e. put the signal handler code with database queries into another process, is that safe?

Regards
-David

2012/9/17 Federico Di Gregorio <fog@dndg.it>
On 17/09/2012 10:21, Daniele Varrazzo wrote:
> On Fri, Sep 14, 2012 at 6:15 PM, David Roid <dataroid@gmail.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.digregorio@dndg.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@

psycopg by date:

Previous
From: Federico Di Gregorio
Date:
Subject: Re: psycopg2 hang with multithread frequent queries
Next
From: "P. Christeas"
Date:
Subject: Re: psycopg2 hang with multithread frequent queries