Re: psycopg2 hang with multithread frequent queries

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

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.

-- Daniele

In response to

Responses

Browse psycopg by date

  From Date Subject
Next Message Federico Di Gregorio 2012-09-17 08:28:11 Re: psycopg2 hang with multithread frequent queries
Previous Message Federico Di Gregorio 2012-09-15 12:56:14 Re: commercial license availability