Thread: Connection stays idle in transaction after window is closed

Connection stays idle in transaction after window is closed

From
Ronja Knabe
Date:
Hello everybody,

we just discovered a bug in pgAdmin 4. When closing the Tab in Firefox, 
a started transaction stays opened. It can only be killed via a 
pg_cancel_backend. We would expect the transaction to be rolled back 
instead.


Steps to reproduce:

1. Open a transaction in the query tool

2. close Browser Tab

3. Use pg_stat_activity to verify that process is idle in transaction


Versions:

Windows 10 1803

Firefox 67.0.4 (64-Bit)

pgAdmin 4.10

PostgreSQL server 9.5.4