Re: Serialization errors in Postgres 9.4.0

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: BRUSSER Michael <Michael(dot)BRUSSER(at)3ds(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Serialization errors in Postgres 9.4.0
Date: 2015-06-25 16:57:33
Message-ID: 5166.1435251453@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

BRUSSER Michael <Michael(dot)BRUSSER(at)3ds(dot)com> writes:
> Some time ago we upgraded from v. 8.4.4 to 9.4.0 and we are seeing errors in some regression tests.
> LOCATION: exec_simple_query, postgres.c:887
> ERROR: 40001: could not serialize access due to read/write dependencies among transactions

9.1 substantially tightened Postgres' ideas of what "serializable" means.
If you want to go back to the behavior you had in 8.4, use REPEATABLE READ
isolation level instead of SERIALIZABLE.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2015-06-25 17:06:10 Re: Should we back-patch SSL renegotiation fixes?
Previous Message David Fetter 2015-06-25 16:54:39 Re: Serialization errors in Postgres 9.4.0