Fatal Error when starting PgAdmin

From: easoftware(at)gmail(dot)com
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Fatal Error when starting PgAdmin
Date: 2023-05-29 18:16:52
Message-ID: CAF3V8JOPB9udmFx4SD_ihNjamOnv2azxA2Zz2_cJfs6rUBP7xA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I am on Windows 10. I have had PgAdmin working. It works, then I stop for
the day. After a system reboot, I get a fatal error.

I have tried uninstalling/reinstalling. I have also tried uninstalling,
delete the pgadmin folder in C:\Users\myname\AppData\Roaming.

Here is the error message:

The pgAdmin4 server could not be contacted:

pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Program Files\PostgreSQL\15\pgAdmin 4\python\python.exe"
Runtime Config File:
"C:\Users\myname\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Program Files\PostgreSQL\15\pgAdmin
4\web\config.py"
Webapp Path: "C:\Program Files\PostgreSQL\15\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Program Files\PostgreSQL\15\pgAdmin
4\python\python.exe -s C:\Program Files\PostgreSQL\15\pgAdmin
4\web\pgAdmin4.py"
Environment:
- ALLUSERSPROFILE: C:\ProgramData
- APPDATA: C:\Users\myname\AppData\Roaming
- ChocolateyInstall: C:\ProgramData\chocolatey
- ChocolateyLastPathUpdate: 132845423331295845
- CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_1180_IKBMLRWCONLBHYQA
- CHROME_RESTART: NW.js|Whoa! NW.js has crashed. Relaunch
now?|LEFT_TO_RIGHT
- CommonProgramFiles: C:\Program Files\Common Files
- CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
- CommonProgramW6432: C:\Program Files\Common Files
- COMPUTERNAME: DESKTOP-9IMNGNF
- ComSpec: C:\WINDOWS\system32\cmd.exe
- DriverData: C:\Windows\System32\Drivers\DriverData
- HOMEDRIVE: C:
- HOMEPATH: \Users\myname
- LOCALAPPDATA: C:\Users\myname\AppData\Local
- LOGONSERVER: \\DESKTOP-9IMNGNF
- MYSQLCONNECTOR_ASSEMBLIESPATH: C:\Program Files (x86)\MySQL\Connector
NET 8.0\Assemblies\v4.5.2
- NUMBER_OF_PROCESSORS: 12
- OneDrive: C:\Users\myname\OneDrive
- OneDriveConsumer: C:\Users\myname\OneDrive
- OS: Windows_NT
- Path: C:\Program Files (x86)\Common
Files\Oracle\Java\javapath;C:\Python310\Scripts\;C:\Python310\;c:\program
files (x86)\intel\intel(r) management engine components\icls\;c:\program
files\intel\intel(r) management engine
components\icls\;c:\windows\system32;c:\windows;c:\windows\system32\wbem;c:\windows\system32\windowspowershell\v1.0\;c:\windows\system32\openssh\;c:\program
files (x86)\intel\intel(r) management engine components\dal;c:\program
files\intel\intel(r) management engine components\dal;c:\program files
(x86)\intel\intel(r) management engine components\ipt;c:\program
files\intel\intel(r) management engine components\ipt;c:\program
files\microsoft sql server\130\tools\binn\;c:\program files\nvidia
corporation\nvidia
nvdlisr;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32\wbem;C:\WINDOWS\system32\windowspowershell\v1.0\;C:\WINDOWS\system32\openssh\;C:\Program
Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program
Files\PowerShell\6\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\ProgramData\chocolatey\bin;C:\Program
Files\nodejs\;C:\Program Files\dotnet\;C:\Program Files\Git\cmd;C:\Program
Files\PostgreSQL\15\bin;C:\Program Files\MySQL\MySQL Shell
8.0\bin\;C:\Users\myname\AppData\Local\Programs\Python\Python37\Scripts\;C:\Users\myname\AppData\Local\Programs\Python\Python37\;C:\Users\myname\AppData\Local\Microsoft\WindowsApps;C:\Users\myname\AppData\Local\Programs\Microsoft
VS
Code\bin;C:\Users\myname\AppData\Local\Microsoft\WindowsApps;C:\Users\myname\AppData\Roaming\Python\Python37\Scripts;C:\Program
Files\mingw-w64\x86_64-8.1.0-posix-seh-rt_v6-rev0\mingw64\bin;C:\Users\myname\AppData\Roaming\npm;C:\Program
Files\PostgreSQL\15\bin;C:\Program
Files\PostgreSQL\15\lib;C:\Users\myname\.dotnet\tools
- PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC;.PY;.PYW
- PGADMIN_INT_KEY: 54171450-f7ac-4ca4-aa60-17b4f7c19802
- PGADMIN_INT_PORT: 63201
- PGADMIN_SERVER_MODE: OFF
- PROCESSOR_ARCHITECTURE: AMD64
- PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 158 Stepping 10,
GenuineIntel
- PROCESSOR_LEVEL: 6
- PROCESSOR_REVISION: 9e0a
- ProgramData: C:\ProgramData
- ProgramFiles: C:\Program Files
- ProgramFiles(x86): C:\Program Files (x86)
- ProgramW6432: C:\Program Files
- PSModulePath: C:\Program
Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules
- PUBLIC: C:\Users\Public
- SESSIONNAME: Console
- SystemDrive: C:
- SystemRoot: C:\WINDOWS
- TEMP: C:\Users\myname\AppData\Local\Temp
- TMP: C:\Users\myname\AppData\Local\Temp
- USERDOMAIN: DESKTOP-9IMNGNF
- USERDOMAIN_ROAMINGPROFILE: DESKTOP-9IMNGNF
- USERNAME: Eric
- USERPROFILE: C:\Users\myname
- VS150COMCOMNTOOLS: C:\Program Files (x86)\Microsoft Visual
Studio\2017\Community\Common7\Tools\
- VS160COMCOMNTOOLS: C:\Program Files (x86)\Microsoft Visual
Studio\2019\Community\Common7\Tools\
- windir: C:\WINDOWS
- WIX: C:\Program Files (x86)\WiX Toolset v3.11\
--------------------------------------------------------

Total spawn time to start the pgAdmin4 server: 0.008 Sec
NOTE: Configuring authentication for DESKTOP mode.

Traceback (most recent call last):
File "C:\Program Files\PostgreSQL\15\pgAdmin 4\web\pgAdmin4.py", line
102, in <module>
app = create_app()
File "C:\Program Files\PostgreSQL\15\pgAdmin 4\web\pgadmin\__init__.py",
line 759, in create_app
app.register_blueprint(module)
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\python\lib\site-packages\flask\scaffold.py", line 50, in wrapper_func
return f(self, *args, **kwargs)
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\python\lib\site-packages\flask\app.py", line 1299, in register_blueprint
blueprint.register(self, options)
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\web\pgadmin\browser\__init__.py", line 162, in register
super().register(app, options)
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\web\pgadmin\utils\__init__.py", line 79, in register

app.register_blueprint(module)
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\python\lib\site-packages\flask\scaffold.py", line 50, in wrapper_func
return f(self, *args, **kwargs)
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\python\lib\site-packages\flask\app.py", line 1299, in register_blueprint
blueprint.register(self, options)
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\web\pgadmin\browser\server_groups\__init__.py", line 132, in register
super().register(app, options)
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\web\pgadmin\utils\__init__.py", line 79, in register
app.register_blueprint(module)
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\python\lib\site-packages\flask\scaffold.py", line 50, in wrapper_func
return f(self, *args, **kwargs)
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\python\lib\site-packages\flask\app.py", line 1299, in register_blueprint
blueprint.register(self, options)
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\web\pgadmin\browser\server_groups\servers\__init__.py", line 325, in
register
super().register(app, options)
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\web\pgadmin\utils\__init__.py", line 79, in register
app.register_blueprint(module)
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\python\lib\site-packages\flask\scaffold.py", line 50, in wrapper_func
return f(self, *args, **kwargs)
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\python\lib\site-packages\flask\app.py", line 1299, in register_blueprint
blueprint.register(self, options)
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\web\pgadmin\browser\server_groups\servers\databases\__init__.py", line
130, in register
super().register(app, options)
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\web\pgadmin\utils\__init__.py", line 79, in register
app.register_blueprint(module)
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\python\lib\site-packages\flask\scaffold.py", line 50, in wrapper_func
return f(self, *args, **kwargs)
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\python\lib\site-packages\flask\app.py", line 1299, in register_blueprint
blueprint.register(self, options)
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\web\pgadmin\browser\server_groups\servers\databases\schemas\__init__.py",
line 165, in register
from .views import view_blueprint as module
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\web\pgadmin\browser\server_groups\servers\databases\schemas\views\__init__.py",
line 34, in <module>
from pgadmin.misc.bgprocess.processes import BatchProcess, IProcessDesc
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\web\pgadmin\misc\bgprocess\__init__.py", line 20, in <module>
from .processes import BatchProcess
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\web\pgadmin\misc\bgprocess\processes.py", line 17, in <module>
import psutil
File "C:\Program Files\PostgreSQL\15\pgAdmin
4\python\lib\site-packages\psutil\__init__.py", line 241, in <module>
raise ImportError(msg)
ImportError: version conflict: 'C:\\Program Files\\PostgreSQL\\15\\pgAdmin
4\\python\\lib\\site-packages\\psutil\\_psutil_windows.cp310-win_amd64.pyd'
C extension module was built for another version of psutil (5.9.3 instead
of 5.9.5); you may try to 'pip uninstall psutil', manually remove
C:\Program Files\PostgreSQL\15\pgAdmin
4\python\lib\site-packages\psutil\_psutil_windows.cp310-win_amd64.pyd or
clean the virtual env somehow, then reinstall

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2023-05-29 19:49:03 Re: Fatal Error when starting PgAdmin
Previous Message Ravi GH 2023-05-29 11:58:34 Re: PG Database Encryption