[pgpool-general: 8343] Stale data in simultaneously transactions
Avi Raboah
avi.raboah at gmail.com
Sun Jul 17 23:54:49 JST 2022
Hi,
I found an issue in simultaneously transactions.
Do the following -
Transaction A:
Select * from city where city_id = 1;
Transaction B:
Update city set city_name=‘City’ where city_id=1;
Transaction B: commit;
Transaction A: commit;
Select * from city where city_id = 1; -> will return from cache with stale
data.
Thanks,
Avi.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20220717/3eb0dd7e/attachment.htm>
More information about the pgpool-general
mailing list