Connection stays idle in transaction after window is closed

From: Ronja Knabe <ronja(dot)knabe(at)clickware(dot)de>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Connection stays idle in transaction after window is closed
Date: 2019-07-04 14:25:56
Message-ID: 51961315-86ad-f097-3182-eaa8368759bd@clickware.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Browse pgadmin-support by date

  From Date Subject
Next Message toni incog 2019-07-05 10:41:52 rpm stuck at v4.8
Previous Message Akshay Joshi 2019-07-04 12:33:16 pgAdmin 4 v4.10 released