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

[Avi Raboah]

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>