How to reproduce serialization failure for a read only transaction.

From: AK <alkuzo(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: How to reproduce serialization failure for a read only transaction.
Date: 2014-01-06 19:41:16
Message-ID: 1389037276585-5785569.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

If two transactions both read and write, I can easily reproduce the
following: "could not serialize access due to read/write dependencies among
transactions". However, the 9.3 documentation says that "When relying on
Serializable transactions to prevent anomalies, it is important that any
data read from a permanent user table not be considered valid until the
transaction which read it has successfully committed. This is true even for
read-only transactions".

I cannot have a read-only transaction fail because of serialization
anomalies. Can someone show me a working example please?

--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-reproduce-serialization-failure-for-a-read-only-transaction-tp5785569.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2014-01-06 19:48:42 Re: dynamic shared memory and locks
Previous Message Robert Haas 2014-01-06 19:22:10 Re: ALTER SYSTEM SET command to change postgresql.conf parameters