Skip site navigation (1) Skip section navigation (2)

Re: Deadlock

From: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
To: psycopg(at)postgresql(dot)org
Subject: Re: Deadlock
Date: 2011-06-04 01:01:14
Message-ID: BANLkTiknm+2_pRvkzw9xbVmnC8MxOa5syg@mail.gmail.com (view raw or flat)
Thread:
Lists: psycopg
On Sat, May 28, 2011 at 1:12 AM, Daniele Varrazzo
<daniele(dot)varrazzo(at)gmail(dot)com> wrote:
> The script in ticket #55
> (http://psycopg.lighthouseapp.com/projects/62710-psycopg/tickets/55)
> sometimes triggers a deadlock. More rarely I've got a segfault or a
> loss of sync with the server.

The problem should be fixed. We were processing notifies after
releasing the connection lock, together with the result process. But,
while the result is in a read-only structure, processing notifies
implies parsing the connection, possibly disrupting the communication
for other threads.

-- Daniele

In response to

  • Deadlock at 2011-05-28 00:12:59 from Daniele Varrazzo

psycopg by date

Next:From: Jason EricksonDate: 2011-06-04 15:19:31
Subject: Re: Installing via pip under Win7 + virtualenv + VC++2008
Previous:From: Daniele VarrazzoDate: 2011-06-03 18:18:49
Subject: Re: Installing via pip under Win7 + virtualenv + VC++2008

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group