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

オープン
#10,767 コメント 1 件 リアクション 0 件 担当者 1 名 GitHub で見る

メンテナーはふだん 2 日以内に返信

@CoderKing2705 がすでに取り組んでいます。

2026年11月18日 から。

評価

難易度
4/5
見積もり時間
3〜5日
初心者へのやさしさ
35/100
issue の種類
バグ
明瞭さ
おおむね明確
活発さ
活発
技術スタック
postgresql, python
領域
databases, desktop

調査の方向性

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.

索引モデルが issue の本文から書いたものです。

説明

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
主要言語
Python
スター
3.9k
フォーク
922
平均マージ
2日 3時間
マージ済み PR(30日)
33

環境構築

はじめの一歩

  1. issue を最後まで読み、次にプロジェクトのコントリビューションガイドを読みます。
  2. 着手することを issue にコメントします — 二人が同じ作業をするのを防げます。
  3. リポジトリをフォークし、ブランチを切って変更します。
  4. issue 番号を参照したプルリクエストを送ります。

pgadmin-org/pgadmin4 のほかの issue

pgadmin-org/pgadmin4 の issue をすべて見る

似ている issue

Python の issue をもっと見る

新しい issue をメールで受け取る

初心者向けの GitHub issue を短くまとめたダイジェスト。