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 08:37:24
Message-ID: 20140605083724.GD11147@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Jun 05, 2014 at 10:35:01AM +0200, Andres Freund wrote:
> On 2014-06-05 07:58:56 +0200, Sandro Santilli wrote:
> > 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 ?
>
> I have a separate commit with a testcase prepared. We're currently
> discussing about some infrastructure that would make it more precise...

Great, thanks again to everyone involved in this fix!

--strk;

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message ua2fgb 2014-06-05 08:52:31 BUG #10528: MAC OS X was renamed
Previous Message Andres Freund 2014-06-05 08:35:01 Re: uninterruptable loop: concurrent delete in progress within table