pgadmin4 icon indicating copy to clipboard operation
pgadmin4 copied to clipboard

Published 20 hours ago • verified publisher icon pgadmin-org

pgAdmin4 Screen Went Blank except for top menu row

Open CeliaLast opened this issue 3 weeks ago • 8 comments

Image

Hi pgAdmin4 team, My pgAdmin4 screen has gone blank about 3 times recently. Unfortunately I lose my queries and only find a few in 'Query History'.

  1. Steps to reproduce - not sure as it happened so fast, but I clicked something under the Servers panel on the left column, because I wanted to view another Server.
  2. pgAdmin4 version =9.8 (have just upgraded to 9.9)
  3. Operating system =Win 10 home version 10.0.19045 build 19045
  4. After going blank, most menu options could be viewed, but were not accessible. File->reset layout & Object->refresh did nothing, View->toggle development tools split the screen horizontally and had the 'Console' tab open. The message displayed 'Failed to load resources: the server responded with a status of 500 (INTERNAL SERVER ERROR)'. View->Reload - re-opened pgAdmin4, and the query tabs still existed, but each query tab had random select & delete queries.

Hope you can advise if it is my PC. Thank you for a great product. Kind regards, Celia

CeliaLast avatar Nov 05 '25 11:11 CeliaLast

Hi @CeliaLast,

Can you please share the pgAdmin logs after crash? File->View logs.

adityatoshniwal avatar Nov 06 '25 05:11 adityatoshniwal

Hi Aditya,

Thank you for following up on my PGAdmin4 blank screen enquiry.

Please see attached log file.

The screen went blank a while before 12:30 pm on 2025-11-05 (South Africa time).

Hope you can spot the reason in the log file.

Kind regards,

Celia

From: Aditya Toshniwal @.> Sent: 06 November 2025 07:01 AM To: pgadmin-org/pgadmin4 @.> Cc: CeliaLast @.>; Mention @.> Subject: Re: [pgadmin-org/pgadmin4] pgAdmin4 Screen Went Blank except for top menu row (Issue #9322)

adityatoshniwal left a comment (pgadmin-org/pgadmin4#9322) https://github.com/pgadmin-org/pgadmin4/issues/9322#issuecomment-3495073685

Hi @CeliaLast https://github.com/CeliaLast ,

Can you please share the pgAdmin logs after crash? File->View logs.

— Reply to this email directly, view it on GitHub https://github.com/pgadmin-org/pgadmin4/issues/9322#issuecomment-3495073685 , or unsubscribe https://github.com/notifications/unsubscribe-auth/ABSHNTFBVCRRSUQWCP5MAED33LIXLAVCNFSM6AAAAACLGSAXJWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZTIOJVGA3TGNRYGU . You are receiving this because you were mentioned. Message ID: <pgadmin-org/pgadmin4/issues/9322/3495073685 @ github . com>

CeliaLast avatar Nov 06 '25 08:11 CeliaLast

Hi @CeliaLast,

I can't see any attachments.

adityatoshniwal avatar Nov 06 '25 10:11 adityatoshniwal

Hi Aditya,

Sorry! I did send an email with the log attached?

Here it is again – hope you can find it.

Kind regards

Celia

From: Aditya Toshniwal @.> Sent: 06 November 2025 12:28 PM To: pgadmin-org/pgadmin4 @.> Cc: CeliaLast @.>; Mention @.> Subject: Re: [pgadmin-org/pgadmin4] pgAdmin4 Screen Went Blank except for top menu row (Issue #9322)

adityatoshniwal left a comment (pgadmin-org/pgadmin4#9322) https://github.com/pgadmin-org/pgadmin4/issues/9322#issuecomment-3496423938

Hi @CeliaLast https://github.com/CeliaLast ,

I can't see any attachments.

— Reply to this email directly, view it on GitHub https://github.com/pgadmin-org/pgadmin4/issues/9322#issuecomment-3496423938 , or unsubscribe https://github.com/notifications/unsubscribe-auth/ABSHNTE2FE4JJ5YQXHRGIHL33MPDTAVCNFSM6AAAAACLGSAXJWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZTIOJWGQZDGOJTHA . You are receiving this because you were mentioned. Message ID: <pgadmin-org/pgadmin4/issues/9322/3496423938 @ github . com>

Server Log: (C:\Users\Celia\AppData\Roaming\pgadmin4\pgadmin4.1762342678277.log) pgAdmin Runtime Environment

Python Path: "C:\Users\Celia\AppData\Local\Programs\pgAdmin 4\python\python.exe" Runtime Config File: "C:\Users\Celia\AppData\Roaming\pgadmin4\config.json" Webapp Path: "C:\Users\Celia\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py" pgAdmin Command: "C:\Users\Celia\AppData\Local\Programs\pgAdmin 4\python\python.exe -s C:\Users\Celia\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py" Environment:

  • ALLUSERSPROFILE: C:\ProgramData
  • APPDATA: C:\Users\Celia\AppData\Roaming
  • asl.log: Destination=file
  • CommonProgramFiles: C:\Program Files\Common Files
  • CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
  • CommonProgramW6432: C:\Program Files\Common Files
  • COMPUTERNAME: 006-IT-06
  • ComSpec: C:\WINDOWS\system32\cmd.exe
  • CYGWIN: mintty
  • DriverData: C:\Windows\System32\Drivers\DriverData
  • ELECTRON_ENABLE_SECURITY_WARNINGS: false
  • FP_NO_HOST_CHECK: NO
  • HOMEDRIVE: C:
  • HOMEPATH: \Users\Celia
  • JAVA_HOME: C:\Program Files\Java\jdk-15
  • LOCALAPPDATA: C:\Users\Celia\AppData\Local
  • LOGONSERVER: \006-IT-06
  • NUMBER_OF_PROCESSORS: 4
  • OneDrive: C:\Users\Celia\OneDrive - atcorp.co.za
  • OneDriveCommercial: C:\Users\Celia\OneDrive - atcorp.co.za
  • OneDriveConsumer: C:\Users\Celia\OneDrive
  • OPENSSL_CONF: C:\Program Files (x86)\PostgreSQL\psqlODBC\etc\openssl.cnf
  • ORIGINAL_XDG_CURRENT_DESKTOP: undefined
  • OS: Windows_NT
  • Path: C:\Users\Celia\AppData\Local\Programs\pgAdmin 4\runtime;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0;C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn;C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn;C:\Users\Celia.dnx\bin;C:\Program Files\Microsoft DNX\Dnvm;C:\Program Files\Microsoft SQL Server\130\Tools\Binn;C:\Programs\AWS_CLI\bin;C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn;C:\Program Files\Mercurial;C:\Program Files (x86)\PuTTY;C:\Program Files\Java\jdk-15\bin;c:\Program Files\PostgreSQL\12\bin;C:\Program Files\Microsoft VS Code\bin;C:\Program Files\Git\cmd;C:\Program Files\OpenSSH\bin;C:\WINDOWS\System32\OpenSSH;C:\Program Files\dotnet;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn;C:\Program Files\Microsoft SQL Server\120\Tools\Binn;C:\Program Files\Microsoft SQL Server\120\DTS\Binn;C:\WINDOWS\SysWow64;C:\Program Files (x86)\Microsoft SQL Server\160\Tools\Binn;C:\Program Files\Microsoft SQL Server\160\Tools\Binn;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn;C:\Program Files\Microsoft SQL Server\160\DTS\Binn;C:\Users\Celia\AppData\Local\Programs\Python\Python313\Scripts;C:\Users\Celia\AppData\Local\Programs\Python\Python313;C:\Users\Celia\AppData\Local\Programs\Python\Launcher;C:\Users\Celia\AppData\Local\Microsoft\WindowsApps;;C:\Users\Celia\AppData\Local\Programs\Microsoft VS Code\bin
  • PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
  • PGADMIN_INT_KEY: 6a3d1637-002f-4d25-bf91-9e289f2851dd
  • PGADMIN_INT_PORT: 59881
  • PGADMIN_SERVER_MODE: OFF
  • PROCESSOR_ARCHITECTURE: AMD64
  • PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 61 Stepping 4, GenuineIntel
  • PROCESSOR_LEVEL: 6
  • PROCESSOR_REVISION: 3d04
  • ProgramData: C:\ProgramData
  • ProgramFiles: C:\Program Files
  • ProgramFiles(x86): C:\Program Files (x86)
  • ProgramW6432: C:\Program Files
  • PSModulePath: C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\PowerShell\Modules;C:\Program Files (x86)\Microsoft SQL Server\160\Tools\PowerShell\Modules\
  • PUBLIC: C:\Users\Public
  • SESSIONNAME: Console
  • SystemDrive: C:
  • SystemRoot: C:\WINDOWS
  • TEMP: C:\Users\Celia\AppData\Local\Temp
  • TMP: C:\Users\Celia\AppData\Local\Temp
  • topware: 99
  • USERDOMAIN: 006-IT-06
  • USERDOMAIN_ROAMINGPROFILE: 006-IT-06
  • USERNAME: Celia
  • USERPROFILE: C:\Users\Celia
  • VBOX_MSI_INSTALL_PATH: C:\Program Files\Oracle\VirtualBox\
  • VS140COMNTOOLS: C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\Tools\
  • windir: C:\WINDOWS
  • __COMPAT_LAYER: DetectorsAppHealth

Total spawn time to start the pgAdmin4 server: 0.338 Sec 2025-11-05 13:38:23,499: WARNING werkzeug: Werkzeug appears to be used in a production deployment. Consider switching to a production web server instead.

  • Serving Flask app 'pgadmin'
  • Debug mode: off

Total time taken to ping pgAdmin4 server: 24.205 Sec

Total launch time of pgAdmin4: 25.483 Sec

Application Server URL: http://127.0.0.1:59881/?key=6a3d1637-002f-4d25-bf91-9e289f2851dd 2025-11-05 14:10:34,095: ERROR pgadmin: Failed to execute query (execute_async) for the server #128 - CONN:6961981(Query-id: 700438): Error Message:ERROR: relation "sqlmig.Application" does not exist LINE 16: FROM sqlmig."Application" app ^

SQL state: 42P01 Character: 465

C:\Users\Celia\AppData\Local\Programs\pgAdmin 4\web\pgadmin\settings_init_.py:507: SAWarning: DELETE statement on table 'application_state' expected to delete 1 row(s); 0 were matched. Please set confirm_deleted_rows=False within the mapper configuration to prevent this warning. db.session.commit()

2025-11-05 16:20:21,842: WARNING pgadmin: Error encoding query with utf-8

2025-11-05 16:49:06,652: WARNING pgadmin: Error encoding query with utf-8

2025-11-05 19:24:39,790: WARNING pgadmin: Error encoding query with utf-8

2025-11-05 19:52:06,229: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:4658186(Query-id: 5710755): Error Message:ERROR: consuming input failed: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

2025-11-05 19:52:06,230: ERROR pgadmin: Connection (id #4658186) lost for the server (#56) on database (backoffice)

2025-11-06 06:59:22,085: WARNING pgadmin: Connection to database server (#56) for the connection - 'CONN:4658186' has been lost. 2025-11-06 06:59:22,088: ERROR pgadmin: Connection (id #4658186) lost for the server (#56) on database (backoffice)

2025-11-06 07:00:29,848: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 07:17:33,750: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 07:18:09,163: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 07:24:10,242: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 07:34:15,114: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 07:37:04,657: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 08:10:03,369: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 08:13:15,461: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 08:20:18,280: WARNING pgadmin: Error encoding query with utf-8

Logs reloaded successfully Reload

CeliaLast avatar Nov 06 '25 11:11 CeliaLast

Hi @CeliaLast, Please share the logs after crash and screenshot of toggle development tools.

adityatoshniwal avatar Nov 07 '25 06:11 adityatoshniwal

pgadmin_file_menu_log_copy_20251107.txt

Hi again Aditya, Hope this log helps - I have just re-loaded it. Unfortunately I didn't take a screen shot of the toggle of the development tools.

The crash happened on 2025-11-05 around 12:00pm South Africa time. After the crash, I was able to click on View->toggle development tools. A window opened with several tabs and the 'Console' tab was open. Under 'Console' it displayed: 'Failed to load resources: the server responded with a status of 500 (INTERNAL SERVER ERROR)'. I remember finding the other Development Tool tabs were not helpful. Sorry I cannot be of more help. Kind regards Celia PS have also sent this by email.

CeliaLast avatar Nov 07 '25 07:11 CeliaLast

Hi Aditya,

Got your email.

I am not sure if you are receiving my email replies.

I have reloaded the log file which has the same reference number as previously attached.

Please see reply on github.com/pgadmin-org for ticket 9322.

https://github.com/pgadmin-org/pgadmin4/issues/9322#issuecomment-3500981315

I commented:

“

Unfortunately I didn't take a screen shot of the toggle of the development tools.

The crash happened on 2025-11-05 around 12:00pm South Africa time.

After the crash, I was able to click on View->toggle development tools.

A window opened with several tabs and the 'Console' tab was open. Under 'Console' it displayed:

'Failed to load resources: the server responded with a status of 500 (INTERNAL SERVER ERROR)'.

I remember finding the other Development Tool tabs were not helpful.

Sorry I cannot be of more help.

“

Thanks for your efforts.

Kind regards

Celia

From: Aditya Toshniwal @.> Sent: 07 November 2025 08:43 AM To: pgadmin-org/pgadmin4 @.> Cc: CeliaLast @.>; Mention @.> Subject: Re: [pgadmin-org/pgadmin4] pgAdmin4 Screen Went Blank except for top menu row (Issue #9322)

adityatoshniwal left a comment (pgadmin-org/pgadmin4#9322) https://github.com/pgadmin-org/pgadmin4/issues/9322#issuecomment-3500981315

Hi @CeliaLast https://github.com/CeliaLast , Please share the logs after crash and screenshot of toggle development tools.

— Reply to this email directly, view it on GitHub https://github.com/pgadmin-org/pgadmin4/issues/9322#issuecomment-3500981315 , or unsubscribe https://github.com/notifications/unsubscribe-auth/ABSHNTASMOXFPQW77YX73AT33Q5PFAVCNFSM6AAAAACLGSAXJWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZTKMBQHE4DCMZRGU . You are receiving this because you were mentioned. Message ID: <pgadmin-org/pgadmin4/issues/9322/3500981315 @ github . com>

Server Log: (C:\Users\Celia\AppData\Roaming\pgadmin4\pgadmin4.1762342678277.log)

pgAdmin Runtime Environment

Python Path: "C:\Users\Celia\AppData\Local\Programs\pgAdmin 4\python\python.exe" Runtime Config File: "C:\Users\Celia\AppData\Roaming\pgadmin4\config.json" Webapp Path: "C:\Users\Celia\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py" pgAdmin Command: "C:\Users\Celia\AppData\Local\Programs\pgAdmin 4\python\python.exe -s C:\Users\Celia\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py" Environment:

  • ALLUSERSPROFILE: C:\ProgramData
  • APPDATA: C:\Users\Celia\AppData\Roaming
  • asl.log: Destination=file
  • CommonProgramFiles: C:\Program Files\Common Files
  • CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
  • CommonProgramW6432: C:\Program Files\Common Files
  • COMPUTERNAME: 006-IT-06
  • ComSpec: C:\WINDOWS\system32\cmd.exe
  • CYGWIN: mintty
  • DriverData: C:\Windows\System32\Drivers\DriverData
  • ELECTRON_ENABLE_SECURITY_WARNINGS: false
  • FP_NO_HOST_CHECK: NO
  • HOMEDRIVE: C:
  • HOMEPATH: \Users\Celia
  • JAVA_HOME: C:\Program Files\Java\jdk-15
  • LOCALAPPDATA: C:\Users\Celia\AppData\Local
  • LOGONSERVER: \006-IT-06
  • NUMBER_OF_PROCESSORS: 4
  • OneDrive: C:\Users\Celia\OneDrive - atcorp.co.za
  • OneDriveCommercial: C:\Users\Celia\OneDrive - atcorp.co.za
  • OneDriveConsumer: C:\Users\Celia\OneDrive
  • OPENSSL_CONF: C:\Program Files (x86)\PostgreSQL\psqlODBC\etc\openssl.cnf
  • ORIGINAL_XDG_CURRENT_DESKTOP: undefined
  • OS: Windows_NT
  • Path: C:\Users\Celia\AppData\Local\Programs\pgAdmin 4\runtime;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0;C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn;C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn;C:\Users\Celia.dnx\bin;C:\Program Files\Microsoft DNX\Dnvm;C:\Program Files\Microsoft SQL Server\130\Tools\Binn;C:\Programs\AWS_CLI\bin;C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn;C:\Program Files\Mercurial;C:\Program Files (x86)\PuTTY;C:\Program Files\Java\jdk-15\bin;c:\Program Files\PostgreSQL\12\bin;C:\Program Files\Microsoft VS Code\bin;C:\Program Files\Git\cmd;C:\Program Files\OpenSSH\bin;C:\WINDOWS\System32\OpenSSH;C:\Program Files\dotnet;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn;C:\Program Files\Microsoft SQL Server\120\Tools\Binn;C:\Program Files\Microsoft SQL Server\120\DTS\Binn;C:\WINDOWS\SysWow64;C:\Program Files (x86)\Microsoft SQL Server\160\Tools\Binn;C:\Program Files\Microsoft SQL Server\160\Tools\Binn;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn;C:\Program Files\Microsoft SQL Server\160\DTS\Binn;C:\Users\Celia\AppData\Local\Programs\Python\Python313\Scripts;C:\Users\Celia\AppData\Local\Programs\Python\Python313;C:\Users\Celia\AppData\Local\Programs\Python\Launcher;C:\Users\Celia\AppData\Local\Microsoft\WindowsApps;;C:\Users\Celia\AppData\Local\Programs\Microsoft VS Code\bin
  • PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
  • PGADMIN_INT_KEY: 6a3d1637-002f-4d25-bf91-9e289f2851dd
  • PGADMIN_INT_PORT: 59881
  • PGADMIN_SERVER_MODE: OFF
  • PROCESSOR_ARCHITECTURE: AMD64
  • PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 61 Stepping 4, GenuineIntel
  • PROCESSOR_LEVEL: 6
  • PROCESSOR_REVISION: 3d04
  • ProgramData: C:\ProgramData
  • ProgramFiles: C:\Program Files
  • ProgramFiles(x86): C:\Program Files (x86)
  • ProgramW6432: C:\Program Files
  • PSModulePath: C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\PowerShell\Modules;C:\Program Files (x86)\Microsoft SQL Server\160\Tools\PowerShell\Modules\
  • PUBLIC: C:\Users\Public
  • SESSIONNAME: Console
  • SystemDrive: C:
  • SystemRoot: C:\WINDOWS
  • TEMP: C:\Users\Celia\AppData\Local\Temp
  • TMP: C:\Users\Celia\AppData\Local\Temp
  • topware: 99
  • USERDOMAIN: 006-IT-06
  • USERDOMAIN_ROAMINGPROFILE: 006-IT-06
  • USERNAME: Celia
  • USERPROFILE: C:\Users\Celia
  • VBOX_MSI_INSTALL_PATH: C:\Program Files\Oracle\VirtualBox\
  • VS140COMNTOOLS: C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\Tools\
  • windir: C:\WINDOWS
  • __COMPAT_LAYER: DetectorsAppHealth

Total spawn time to start the pgAdmin4 server: 0.338 Sec 2025-11-05 13:38:23,499: WARNING werkzeug: Werkzeug appears to be used in a production deployment. Consider switching to a production web server instead.

  • Serving Flask app 'pgadmin'
  • Debug mode: off

Total time taken to ping pgAdmin4 server: 24.205 Sec

Total launch time of pgAdmin4: 25.483 Sec

Application Server URL: http://127.0.0.1:59881/?key=6a3d1637-002f-4d25-bf91-9e289f2851dd 2025-11-05 14:10:34,095: ERROR pgadmin: Failed to execute query (execute_async) for the server #128 - CONN:6961981(Query-id: 700438): Error Message:ERROR: relation "sqlmig.Application" does not exist LINE 16: FROM sqlmig."Application" app ^

SQL state: 42P01 Character: 465

C:\Users\Celia\AppData\Local\Programs\pgAdmin 4\web\pgadmin\settings_init_.py:507: SAWarning: DELETE statement on table 'application_state' expected to delete 1 row(s); 0 were matched. Please set confirm_deleted_rows=False within the mapper configuration to prevent this warning. db.session.commit()

2025-11-05 16:20:21,842: WARNING pgadmin: Error encoding query with utf-8

2025-11-05 16:49:06,652: WARNING pgadmin: Error encoding query with utf-8

2025-11-05 19:24:39,790: WARNING pgadmin: Error encoding query with utf-8

2025-11-05 19:52:06,229: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:4658186(Query-id: 5710755): Error Message:ERROR: consuming input failed: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

2025-11-05 19:52:06,230: ERROR pgadmin: Connection (id #4658186) lost for the server (#56) on database (backoffice)

2025-11-06 06:59:22,085: WARNING pgadmin: Connection to database server (#56) for the connection - 'CONN:4658186' has been lost. 2025-11-06 06:59:22,088: ERROR pgadmin: Connection (id #4658186) lost for the server (#56) on database (backoffice)

2025-11-06 07:00:29,848: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 07:17:33,750: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 07:18:09,163: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 07:24:10,242: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 07:34:15,114: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 07:37:04,657: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 08:10:03,369: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 08:13:15,461: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 08:20:18,280: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 13:02:21,039: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 13:58:35,299: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 14:35:51,066: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 16:48:43,139: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:7601397(Query-id: 178581): Error Message:ERROR: syntax error at or near "(" LINE 8: ( select 1 from public."LGR_Transaction" LGR ^

SQL state: 42601 Character: 224

2025-11-06 16:49:47,109: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:7601397(Query-id: 3771912): Error Message:ERROR: syntax error at or near "(" LINE 3: ( select 1 from public."LGR_Transaction" LGR ^

SQL state: 42601 Character: 41

2025-11-06 16:51:11,598: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:7601397(Query-id: 4515324): Error Message:ERROR: syntax error at or near "select" LINE 12: select ACC."AccountId", ACC."LoanType", ACC."CreateDate"::Da... ^

SQL state: 42601 Character: 200

2025-11-06 16:51:24,650: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:7601397(Query-id: 6406880): Error Message:ERROR: column lat_lgr.AccountId does not exist LINE 24: and coalesce(lat_lgr."AccountId",0) <> 0 -- LGR transaction... ^

SQL state: 42703 Character: 573

2025-11-06 16:52:09,227: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:7601397(Query-id: 3341920): Error Message:ERROR: column lat_lgr.had_lgr does not exist LINE 5: ...ountId", ACC."LoanType", ACC."CreateDate"::Date , lat_lgr.ha... ^ HINT: Perhaps you meant to reference the column "lat_lgr.has_lgr".

SQL state: 42703 Character: 115

2025-11-06 16:52:31,486: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:7601397(Query-id: 1016664): Error Message:ERROR: missing FROM-clause entry for table "sch" LINE 27: and coalesce(SCH."AccountId",0) = 0 ^

SQL state: 42P01 Character: 691

2025-11-06 16:54:22,867: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:7601397(Query-id: 6424952): Error Message:ERROR: table name "lat_lgr" specified more than once

SQL state: 42712

2025-11-06 16:54:45,310: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:7601397(Query-id: 3187239): Error Message:ERROR: missing FROM-clause entry for table "lat_sched" LINE 28: and coalesce(lat_sched."AccountId",0) = 0 ^

SQL state: 42P01 Character: 748

2025-11-06 16:54:53,760: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:7601397(Query-id: 6914790): Error Message:ERROR: column lat_sch.AccountId does not exist LINE 28: and coalesce(lat_sch."AccountId",0) = 0 ^

SQL state: 42703 Character: 748

2025-11-06 16:58:59,975: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 19:06:55,540: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:1182844(Query-id: 7019557): Error Message:ERROR: column reference "OptimisticLockField" is ambiguous LINE 1: ...ngbalance", "Duedate", "VAP", "Paid_Installment", "Optimisti... ^

SQL state: 42702 Character: 204

2025-11-06 19:07:06,302: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:1182844(Query-id: 6106677): Error Message:ERROR: column reference "GCRecord" is ambiguous LINE 1: ...", "Paid_Installment", SCH."OptimisticLockField", "GCRecord"... ^

SQL state: 42702 Character: 231

2025-11-06 19:07:12,582: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:1182844(Query-id: 1179995): Error Message:ERROR: column reference "PaidDate" is ambiguous LINE 1: ...uneral", "VAP_Tax", "VAP_Other", "PaymentModeId", "PaidDate"... ^

SQL state: 42702 Character: 321

2025-11-06 19:08:08,284: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:1182844(Query-id: 7088632): Error Message:ERROR: syntax error at or near "where" LINE 6: where ACC."LoanType" = 'N' ^

SQL state: 42601 Character: 721

2025-11-06 19:15:51,971: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:1182844(Query-id: 4505992): Error Message:ERROR: syntax error at or near "." LINE 13: SCH."DebitOrderStatus" = CREATED ^

SQL state: 42601 Character: 375

2025-11-06 19:16:01,143: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:1182844(Query-id: 4731357): Error Message:ERROR: syntax error at or near "." LINE 13: SCH."DebitOrderStatus" ' = CREATED ^

SQL state: 42601 Character: 375

2025-11-06 19:16:18,488: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:1182844(Query-id: 9669467): Error Message:ERROR: syntax error at or near "." LINE 13: SCH."DebitOrderStatus" ' = CREATED ^

SQL state: 42601 Character: 375

2025-11-06 19:16:28,802: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:1182844(Query-id: 5709287): Error Message:ERROR: syntax error at or near "." LINE 13: SCH."DebitOrderStatus" --' = CREATED ^

SQL state: 42601 Character: 375

2025-11-06 19:20:54,711: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:1182844(Query-id: 7483245): Error Message:ERROR: column app.ApplicationId does not exist LINE 5: APP."ApplicationId" , ^

SQL state: 42703 Character: 85

2025-11-06 19:39:19,712: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:1182844(Query-id: 901404): Error Message:ERROR: syntax error at or near "round" LINE 30: round( sum( case when LGR."LGR_TransTypeGroupId" = 1 ^

SQL state: 42601 Character: 1030

2025-11-06 19:39:30,189: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:1182844(Query-id: 6586675): Error Message:ERROR: missing FROM-clause entry for table "lgr" LINE 30: round( sum( case when LGR."LGR_TransTypeGroupId" = 1 ^

SQL state: 42P01 Character: 1058

2025-11-06 20:00:38,932: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:7601397(Query-id: 6910014): Error Message:ERROR: missing FROM-clause entry for table "acc" LINE 44: ACC."Period" as Noofdays, -- seems to be incorrect? ^

SQL state: 42P01 Character: 1162

2025-11-06 20:00:52,907: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:7601397(Query-id: 8859655): Error Message:ERROR: column lat_lgr.nuc_disc does not exist LINE 46: case when coalesce(lat_lgr.nuc_disc,0) = 0 ^ HINT: Perhaps you meant to reference the column "lat_lgr.nuc_disb".

SQL state: 42703 Character: 1324

2025-11-06 20:01:18,318: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:7601397(Query-id: 2643712): Error Message:ERROR: column lat_lgr.nuc_disp does not exist LINE 46: case when coalesce(lat_lgr.nuc_disp,0) = 0 ^ HINT: Perhaps you meant to reference the column "lat_lgr.nuc_disb".

SQL state: 42703 Character: 1324

2025-11-06 20:01:37,639: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:7601397(Query-id: 2371300): Error Message:ERROR: column lat_lgr.nuc_disc does not exist LINE 48: else coalesce(lat_lgr.nuc_disc,0) ^ HINT: Perhaps you meant to reference the column "lat_lgr.nuc_disb".

SQL state: 42703 Character: 1410

2025-11-06 20:01:56,793: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:7601397(Query-id: 7854223): Error Message:ERROR: column cte_missing_sched.LoanEndDate does not exist LINE 54: cte_missing_sched."LoanEndDate" as Duedate , ^

SQL state: 42703 Character: 1612

2025-11-06 20:02:19,089: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:7601397(Query-id: 2265732): Error Message:ERROR: missing FROM-clause entry for table "sch" LINE 63: SCH."DebitOrderStatus" --' = CREATED ^

SQL state: 42P01 Character: 1927

2025-11-06 20:02:45,619: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:7601397(Query-id: 3247523): Error Message:ERROR: syntax error at or near "-" LINE 63: 'CREATED' as DebitOrderStatus - **** QUERY ^

SQL state: 42601 Character: 1958

2025-11-06 20:13:10,331: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:7601397(Query-id: 7012682): Error Message:ERROR: missing FROM-clause entry for table "lgr2" LINE 36: case when LGR2."TypeId"=1 then LGR2."Amount"... ^

SQL state: 42P01 Character: 902

2025-11-06 20:14:43,412: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:7601397(Query-id: 4177079): Error Message:ERROR: canceling statement due to user request

SQL state: 57014

2025-11-06 20:42:03,102: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:7601397(Query-id: 4636843): Error Message:ERROR: syntax error at or near "," LINE 52: ,2) as sum_tran , ^

SQL state: 42601 Character: 1419

2025-11-06 20:42:48,195: ERROR pgadmin: Failed to execute query (execute_async) for the server #56 - CONN:7601397(Query-id: 2755050): Error Message:ERROR: syntax error at or near "SELECT" LINE 81: SELECT ^

SQL state: 42601 Character: 2294

2025-11-06 20:43:55,582: WARNING pgadmin: Error encoding query with utf-8

2025-11-06 21:46:47,092: WARNING pgadmin: Error encoding query with utf-8

CeliaLast avatar Nov 07 '25 07:11 CeliaLast

Hi Akshay,

I did reply to Aditya,

Hope this is OK.

Kind regards

Celia

From: Akshay Joshi @.> Sent: 07 November 2025 08:42 AM To: pgadmin-org/pgadmin4 @.> Cc: CeliaLast @.>; Assign @.> Subject: Re: [pgadmin-org/pgadmin4] pgAdmin4 Screen Went Blank except for top menu row (Issue #9322)

Assigned #9322 https://github.com/pgadmin-org/pgadmin4/issues/9322 to @CeliaLast https://github.com/CeliaLast .

— Reply to this email directly, view it on GitHub https://github.com/pgadmin-org/pgadmin4/issues/9322#event-20779214134 , or unsubscribe https://github.com/notifications/unsubscribe-auth/ABSHNTEK57ZBCS222KNZKI333Q5KNAVCNFSM6AAAAACLGSAXJWVHI2DSMVQWIX3LMV45UABCJFZXG5LFIV3GK3TUJZXXI2LGNFRWC5DJN5XDWMRQG43TSMRRGQYTGNA . You are receiving this because you were assigned. Message ID: <pgadmin-org/pgadmin4/issue/9322/issue_event/20779214134 @ github . com>

CeliaLast avatar Nov 07 '25 07:11 CeliaLast