sqlalchemy freezing during results retrieval #8671
Description
There is a query select count(*) from "perfomance/olap/tests_results" limit 1 (actually query may be any, it does not matter)
Running query from python by psycopg2, all works fine.
Try to run the same query over sqlalchemy, python retrieves results and freezes.
Captured several tcpdump files, while python was executing another query but with the same freeze.
pg.pcap.gz
pg_good.pcap.gz
pg.pcap contains session with python that freezes, pg_good.pcap contains the same query but then python works well
As far as I see the difference in ROLLBACK command. I tried to execute ROLLBACK command after successfull query execution but command was completed successfully and python did not freeze.