pgAdmin 4 v9.19 - Application freezes when interacting with the UI

Aperta
#10,767 1 commento 0 reazioni 1 assegnatario Vedi su GitHub

I maintainer di solito rispondono entro 2 giorni

@CoderKing2705 ci sta già lavorando.

Dal 18/11/2026.

Valutazione

Difficoltà
4/5
Tempo stimato
3-5 giorni
Idoneità per principianti
35/100
Tipo di issue
Bug
Chiarezza
Abbastanza chiara
Stato di attività
Attiva
Stack tecnologico
postgresql, python
Ambito
databases, desktop

Direzione di ricerca

Start with the reported pgAdmin 4 v9.19 Windows hang when expanding Servers, then inspect the supplied pgadmin4.log error and Windows AppHangB1 diagnostics. The issue names no source files or tests, so first determine whether the hang is reproducible and collect the requested diagnostic logs. Done means identifying the cause and restoring responsive UI interaction.

Scritto dal modello di indicizzazione a partire dal testo della issue.

Descrizione

Issue Summary

I am experiencing a persistent application freezing issue with pgAdmin 4 version 9.19 on Windows.

pgAdmin launches and sometimes displays its interface successfully. However, when I attempt to interact with the application, such as expanding the Servers section or clicking other UI elements, the application becomes unresponsive.

The issue persists even after reinstalling pgAdmin and attempting to launch it using a temporary profile.

Environment Details

Component Details
Application pgAdmin 4
Version 9.19
Operating System Windows
Database PostgreSQL 18.6
PostgreSQL Service postgresql-x64-18
PostgreSQL Host localhost / 127.0.0.1
PostgreSQL Port 5432
PostgreSQL Client psql 18.6

Steps to Reproduce

  1. Launch pgAdmin 4.

  2. Wait for the application interface to load.

  3. Navigate to the Servers section.

  4. Attempt to expand the registered PostgreSQL server or interact with another UI element.

  5. The application freezes and becomes unresponsive.

  6. Windows eventually reports that the application is Not Responding.

Note: During some troubleshooting attempts, pgAdmin failed to display its interface at all.

Expected Behavior

  • pgAdmin should launch successfully.

  • The interface should remain responsive.

  • Users should be able to expand registered servers.

  • Database connections and management operations should work normally.

Actual Behavior

  • pgAdmin sometimes launches and displays its interface.

  • The application freezes during UI interaction.

  • The Servers section cannot be used reliably.

  • The application may become completely unresponsive.

  • Restarting or reinstalling pgAdmin does not resolve the issue.

  • Launching with a temporary profile also did not resolve the issue.

Troubleshooting Already Performed

1. Reinstalled pgAdmin 4

Uninstalled and reinstalled pgAdmin 4.

Result: The issue persists.

2. Verified PostgreSQL Service

Executed the following PowerShell command:

Get-Service *postgres*

Result:

Status   Name                 DisplayName
Running  postgresql-x64-18    postgresql-x64-18

Result: PostgreSQL service is running.

3. Verified PostgreSQL Port Connectivity

Executed:

Test-NetConnection localhost -Port 5432

Result:

TcpTestSucceeded : True

Result: PostgreSQL is accessible on port 5432.

4. Verified PostgreSQL Using psql

Successfully connected to PostgreSQL using the command-line client:

psql -U postgres -h localhost -p 5432

PostgreSQL client version:

psql (18.6)

Result: PostgreSQL connectivity works independently of pgAdmin.

5. Checked pgAdmin Logs

Located the pgAdmin application log:

%APPDATA%\pgAdmin\pgadmin4.log

Observed the following error:

connection failed: connection to server at "127.0.0.1",
port 5432 failed: fe_sendauth: no password supplied

This indicates a database authentication attempt without a supplied password.

However, I am unsure whether this error is directly related to the application freezing.

6. Checked pgAdmin Configuration Database

Verified that the following file exists:

%APPDATA%\pgAdmin\pgadmin4.db

File size:

2252800 bytes

I have not confirmed whether the configuration database is contributing to the issue.

7. Checked Windows Event Viewer

Windows Event Viewer recorded an application hang.

Event Type: Application Hang
Problem Event Name: AppHangB1
Application: pgAdmin4.exe

Windows also generated Windows Error Reporting (WER) diagnostic files associated with the hang.

8. Verified pgAdmin Runtime Version

The installed pgAdmin runtime reports:

ProductVersion: 9.19
FileVersion: 44.7.0
9. Attempted Temporary Profile Launch

Attempted to launch pgAdmin using a temporary profile to investigate whether the existing user configuration was responsible.

Result: The pgAdmin interface did not appear during this attempt.

Impact

This issue prevents me from using pgAdmin for PostgreSQL database administration.

Although PostgreSQL itself is working correctly through psql, I cannot reliably access databases, schemas, tables, or query tools through the pgAdmin graphical interface.

Questions for the pgAdmin Development Team

  1. Are there any known application freezing issues in pgAdmin 4 v9.19 on Windows?

  2. Could this issue be related to the pgAdmin runtime, embedded browser, or internal Python processes?

  3. Could the pgAdmin configuration database cause this type of application hang?

  4. What additional diagnostic logs should I collect to identify the root cause?

  5. Is there a recommended troubleshooting procedure that preserves existing pgAdmin server registrations and settings?

Additional Information

  • PostgreSQL service is running successfully.

  • PostgreSQL connectivity works using psql.

  • TCP connectivity to port 5432 is successful.

  • The application freeze persists after reinstalling pgAdmin.

  • Windows Event Viewer reports an AppHangB1 event.

  • A temporary-profile launch did not resolve the problem.

I can provide sanitized pgAdmin logs, screenshots, and Windows Event Viewer diagnostic details if required.

Any assistance or recommendations from the pgAdmin development team would be greatly appreciated.

Thank you.

image
Lingua principale
Python
Stelle
3.9k
Fork
922
Merge medio
2g 3h
PR unite (30g)
33

Preparare l'ambiente

Come iniziare

  1. Leggi tutta la issue e poi la guida ai contributi del progetto.
  2. Commenta sulla issue per dire che te ne occupi tu — evita che due persone facciano lo stesso lavoro.
  3. Fai un fork del repository e lavora su un branch.
  4. Apri una pull request che faccia riferimento al numero della issue.

Altre issue di pgadmin-org/pgadmin4

Tutte le issue di pgadmin-org/pgadmin4

Issue simili

Altre issue su Python

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.