Reputation: 1
[enter image description here][1]I'm reading the paper Making Snapshot Isolation Serializable,it provide an example 2.1 in Section 2.1: SI history H1
It'a an transaction history under SI,and explains it was The H1 transactions are serializable in order: T1T2T3
;as far as i known:
T1T2T3
, there should not be R3(Y1)
,must be R3(Y2)
T1T3T2
, there should not be R2(X1)
, must be R2(X3)
Where did I go wrong in my understanding?
I have search on google and asked on poe,it didn't worked for me.
I have test it on PostgreSQL12, with SERIALIZABLE,it return:
ERROR: could not serialize access due to read/write dependencies among transactions
DETAIL: Reason code: Canceled on conflict out to pivot 316211150, during read.
HINT: The transaction might succeed if retried.
Upvotes: 0
Views: 39