Re: [OSSTEST PATCH 0/1] PostgreSQL db: Retry on constraint violation

Kevin Grittner <kgrittn@gmail.com>

From: Kevin Grittner <kgrittn@gmail.com>

To: Ian Jackson <ian.jackson@eu.citrix.com>

Cc: xen-devel@lists.xenproject.org, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Date: 2016-12-12T19:06:23Z

Lists: pgsql-hackers

On Mon, Dec 12, 2016 at 12:32 PM, Kevin Grittner <kgrittn@gmail.com> wrote:

> As you can see, this generated a serialization failure.

That was on 9.6.  On earlier versions it does indeed allow the
transaction on connection 2 to commit, yielding a non-serializable
result.  This makes a pretty strong case for back-patching this
commit:

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=fcff8a575198478023ada8a48e13b50f70054766

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Commits

Back-patch fcff8a575198478023ada8a48e13b50f70054766 as a bug fix.
- bed2a0b06ba5 9.5.6 landed
- 60314e28eb02 9.2.20 landed
- 5d80171adace 9.3.16 landed
- 4b9d466c1408 9.4.11 landed
Detect SSI conflicts before reporting constraint violations
- fcff8a575198 9.6.0 cited
Initial MVCC code.
- 3f7fbf85dc5b 7.1.1 cited