Re: [HACKERS] How to reproduce serialization failure for a read only transaction.

2014-01-08 Thread Kevin Grittner
Florian Pflug wrote: > On Jan7, 2014, at 20:11 , Kevin Grittner wrote: >> Yeah, neither of the provided examples rolled back the read only >> transaction itself; > > Actually, the fixed version [1] of my example does. > > [1] > http://www.postgresql.org/message-id/8721aad3-7a3a-4576-b10e-f2cbd1

Re: [HACKERS] How to reproduce serialization failure for a read only transaction.

2014-01-08 Thread Florian Pflug
On Jan7, 2014, at 20:11 , Kevin Grittner wrote: > Yeah, neither of the provided examples rolled back the read only > transaction itself; Actually, the fixed version [1] of my example does. [1] http://www.postgresql.org/message-id/8721aad3-7a3a-4576-b10e-f2cbd1e53...@phlo.org best regards, Flor

Re: [HACKERS] How to reproduce serialization failure for a read only transaction.

2014-01-07 Thread Florian Pflug
On Jan7, 2014, at 00:38 , Jim Nasby wrote: > This email and the previous one are an awesome bit of information, > can we add it to the docs somehow? Even if it's just dumping the > emails into a wiki page and referencing it? Most of what I wrote there can be found in README-SSE, I think, under "A

Re: [HACKERS] How to reproduce serialization failure for a read only transaction.

2014-01-07 Thread Kevin Grittner
AK wrote: > I cannot have a read-only transaction fail because of > serialization anomalies. Can someone show me a working example > please? A common case is a read-only transaction reading a closed batch without seeing all of its entries. http://wiki.postgresql.org/wiki/SSI#Read_Only_Transacti

Re: [HACKERS] How to reproduce serialization failure for a read only transaction.

2014-01-06 Thread Florian Pflug
On Jan6, 2014, at 20:41 , AK wrote: > 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