Re: uninterruptable loop: concurrent delete in progress within table

From: Sandro Santilli <strk(at)keybit(dot)net>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: uninterruptable loop: concurrent delete in progress within table
Date: 2014-06-05 05:58:56
Message-ID: 20140605055856.GA5221@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Jun 05, 2014 at 01:04:51AM +0200, Andres Freund wrote:
> Hi Sandro,
>
> On 2014-05-30 16:31:50 +0200, Sandro Santilli wrote:
> > The attached script shows a plpgsql function that enters
> > an infinite loop which is not interrupted by statement_timeout.
>
> Pushed a fix. Thanks for the report!

Thanks, will test asap.

BTW, I noticed the commit contained no testcase, would it be safer
to include one ? The smallest test I got to (not requiring PostGIS)
is here: http://strk.keybit.net/tmp/crash.sql

--strk;

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sandro Santilli 2014-06-05 06:16:31 Re: uninterruptable loop: concurrent delete in progress within table
Previous Message Haribabu Kommi 2014-06-05 01:28:29 Re: [HACKERS] BUG #9652: inet types don't support min/max