Re: Assertion failure in REL9_5_STABLE - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: Assertion failure in REL9_5_STABLE
Date
Msg-id f0a23bc3-2e72-ef71-6d38-5796c7528458@joh.to
Whole thread Raw
In response to Re: Assertion failure in REL9_5_STABLE  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: Assertion failure in REL9_5_STABLE  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
On 2016-08-10 11:01 PM, Alvaro Herrera wrote:
> Oh, I see ... so there's an update chain, and you're updating a earlier
> tuple.  But the later tuple has a multixact and one of the members is
> the current transaction.
>
> I wonder how can you lock a tuple that's not the latest, where that
> update chain was produced by your own transaction.  I suppose this is
> because of plpgsql use of cursors.

There's a rolled back subtransaction that also did some magic on the 
rows AFAICT.  I can try and spend some time producing a smaller test 
case over the weekend.  No hurry since this missed the today's point 
release anyway.


.m



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: No longer possible to query catalogs for index capabilities?
Next
From: Marko Tiikkaja
Date:
Subject: Re: Assertion failure in REL9_5_STABLE