Re: uninterruptable loop: concurrent delete in progress within table

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

On Fri, May 30, 2014 at 04:59:10PM +0200, Sandro Santilli wrote:
> On Fri, May 30, 2014 at 04:45:35PM +0200, Andres Freund wrote:
> > Hi,
> >
> > 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.
> >
> > There's nothing attached... :)
>
> Oops, sorry.
> I've sent (and will send) on request to interested parties.

Actually, I further reduced it to not rely on PostGIS
and it is attached here.

--strk;

()  ASCII ribbon campaign -- Keep it simple !
/\  http://strk.keybit.net/rants/ascii_mails.txt

Attachment Content-Type Size
crash.sql application/x-sql 3.6 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2014-05-30 15:33:22 Re: uninterruptable loop: concurrent delete in progress within table
Previous Message Andres Freund 2014-05-30 15:13:17 Re: pg_upgrade < 9.3 -> >=9.3 misses a step around multixacts