pgadmin-org
When idle, connection is lost and cannot be regained. Restart necessary
Describe the bug
If I leave pgAdmin open for a while (e.g. 1 hour), the connection the database seems to be lost. If I try to view any information about the database (e.g. expand the Schemas object in the Object Explorer), pgAdmin just hangs for eternity. It seems to be waiting for a re-connection that never completes.
I just have to close pgAdmin and re-start it so that it re-connects properly.
To Reproduce
Steps to reproduce the behavior:
- Connect to a server
- Browse the database in any way (for instance, expand the "Tables" object to view the tables of the db)
- Leave pgAdmin open but use other software on your computer, for about 30 min.
- Go back to pgAdmin and expand a table to view its columns.
- Observe how pgAdmin now just shows spinning wheels as if it is doing some kind of connection or processing.
- Wait for 10 minutes, get frustrated, close and re-open pgAdmin.
Expected behavior
pgAdmin should be able to restore (or re-create) the connection to the server.
Desktop (please complete the following information):
- OS: Pop Os (Ubunutu 22.04)
- Version: 7.1
- Mode: Desktop
- Package type: DEB
Why does pgadmin even ask about reconnect? Why not just reconnect automatically after losing connection? Does anyone like to click a hundred times a day - "yes, please reconnect, I don't need it without connection!
Me and my colleagues had another problem, if the database doesn't respond because for example is busy, then pgAdmin also hangs for eternity. Closing and reopening the program does not guarantee a success because this can happen many times until DB start responding quickly.
My problem is the version Web. PgAdmin stay open for minutes and when idle they stop responding.
Web (please complete the following information):
- OS: EKS with Amazon Linux 2
- Version: 8.5
- Mode: Web
- Package type: Helm Chart
Helm Chart info: repoURL: https://helm.runix.net Version: 1.24.0
Ingress controller: Nginx.
