Re: BUG #13681: Serialization failures caused by new multixact code of 9.3 (back-patch request) - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #13681: Serialization failures caused by new multixact code of 9.3 (back-patch request)
Date
Msg-id 20160705220031.GA602524@alvherre.pgsql
Whole thread Raw
In response to Re: BUG #13681: Serialization failures caused by new multixact code of 9.3 (back-patch request)  (Olivier Dony <odo+pgbugs@odoo.com>)
Responses Re: BUG #13681: Serialization failures caused by new multixact code of 9.3 (back-patch request)
List pgsql-bugs
I'm looking at this open bug again.  I attach two commits; the first one
adds two test cases illustrating the current (broken) behavior, and the
second one adds the fix and changes the test cases to match the new
behavior.  I spent a lot of time trying to find (a) any other
HeapTupleSatisfiesUpdate caller that needed to be changed, and (b)
additional test cases that showed misbehavior, and so far I haven't been
able to come up with any.

No other test case is affected AFAICS.

I intend to push this and backpatch to 9.3.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment

pgsql-bugs by date:

Previous
From: andrew@tao11.riddles.org.uk
Date:
Subject: BUG #14228: replication slot catalog_xmin not cleared on slot reuse
Next
From: Peter Geoghegan
Date:
Subject: Re: Too slow "Analyze" for the table with data in Thai language