[pgpool-general: 8343] Stale data in simultaneously transactions

Avi Raboah avi.raboah at gmail.com
Sun Jul 17 23:54:49 JST 2022


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


-------------- 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