The pgAdmin 4 server could not be contacted #7447

deja94 · 2024-05-03T20:07:56Z

Hi,

I have tried all of the available versions of the pgAdmin, and still get the following error when trying to start it (as administrator):

pgAdmin Runtime Environment

Python Path: "C:\Program Files\pgAdmin 4\python\python.exe"
Runtime Config File: "C:\Users\USERNAME\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Program Files\pgAdmin 4\web\config.py"
Webapp Path: "C:\Program Files\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Program Files\pgAdmin 4\python\python.exe -s C:\Program Files\pgAdmin 4\web\pgAdmin4.py"
Environment:

ADSK_3DSMAX_x64_2017: C:\Program Files\Autodesk\3ds Max 2017\
ALLUSERSPROFILE: C:\ProgramData
APPDATA: C:\Users\USERNAME\AppData\Roaming
CHROME_CRASHPAD_PIPE_NAME: \.\pipe\crashpad_18948_RXNSRJPXRNJIXZIY
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: xxx
ComSpec: C:\WINDOWS\system32\cmd.exe
DriverData: C:\Windows\System32\Drivers\DriverData
HOMEDRIVE: C:
HOMEPATH: \Users\USERNAME
LOCALAPPDATA: C:\Users\USERNAME\AppData\Local
LOGONSERVER: \DESKTOP-RVTE6BS
NUMBER_OF_PROCESSORS: 6
OneDrive: C:\Users\USERNAME\OneDrive
OS: Windows_NT
Path: C:\Program Files\pgAdmin 4\runtime;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\NVIDIA Corporation\NVIDIA NvDLISR;C:\Program Files\Common Files\Autodesk Shared;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0;C:\WINDOWS\System32\OpenSSH;C:\Users\Dejan Rankovic\AppData\Local\Microsoft\WindowsApps;C:\Program Files\PostgreSQL\9.6\bin
PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PGADMIN_INT_KEY: 3fad8108-0347-424e-8310-89bf4160cffb
PGADMIN_INT_PORT: 5050
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
SystemDrive: C:
SystemRoot: C:\WINDOWS
TEMP: C:\Users\DEJANR~1\AppData\Local\Temp
TMP: C:\Users\DEJANR~1\AppData\Local\Temp
USERDOMAIN: DESKTOP-RVTE6BS
USERDOMAIN_ROAMINGPROFILE: DESKTOP-RVTE6BS
USERNAME: USERNAME
USERPROFILE: C:\Users\USERNAME
windir: C:\WINDOWS
__COMPAT_LAYER: Installer

Total spawn time to start the pgAdmin4 server: 0.009 Sec
Traceback (most recent call last):
File "C:\Program Files\pgAdmin 4\web\pgAdmin4.py", line 48, in

import config

File "C:\Program Files\pgAdmin 4\web\config.py", line 33, in
from pgadmin.utils import env, IS_WIN, fs_short_path
File "C:\Program Files\pgAdmin 4\web\pgadmin_init_.py", line 25, in
from flask_socketio import SocketIO
File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\flask_socketio_init_.py", line 9, in
from socketio import socketio_manage # noqa: F401
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\socketio_init_.py", line 1, in
from .client import Client
File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\socketio\client.py", line 3, in
import engineio
File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\engineio_init_.py", line 1, in

from .client import Client

File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\engineio\client.py", line 11, in
import requests
File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\requests_init_.py", line 147, in

from . import packages, utils

File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\requests\utils.py", line 24, in
from . import certs
File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\requests\certs.py", line 14, in
from certifi import where
File "", line 1360, in _find_and_load
File "", line 1331, in _find_and_load_unlocked
File "", line 935, in _load_unlocked
File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\wrapt\importer.py", line 185, in _self_exec_module

notify_module_loaded(module)

File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\wrapt\importer.py", line 118, in notify_module_loaded
hook(module)
File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\certifi_win32\wrapt_certifi.py", line 27, in apply_patches
generate_pem()
File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\certifi_win32\wincerts.py", line 121, in generate_pem

for pem in get_pems():
           ^^^^^^^^^^

File "C:\Program Files\pgAdmin 4\python\Lib\site-packages\certifi_win32\wincerts.py", line 41, in get_pems
ssl_context = ssl.create_default_context()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "ssl.py", line 713, in create_default_context

File "ssl.py", line 534, in load_default_certs
File "ssl.py", line 526, in _load_windows_store_certs

ssl.SSLError: [ASN1] nested asn1 error (_ssl.c:4028)

Could you please help me in any way? Thanks in advance

The text was updated successfully, but these errors were encountered:

khushboovashi · 2024-05-17T11:02:08Z

Hi @deja94, from where did you install pgAdmin 4? The official site is https://www.pgadmin.org/download/ .

appreciated · 2024-05-23T09:19:40Z

@khushboovashi I am hitting the same issue, with a fresh download/install from the official page.

khushboovashi · 2024-05-23T09:30:41Z

@khushboovashi I am hitting the same issue, with a fresh download/install from the official page.

Provide your log please.

appreciated · 2024-05-23T09:38:11Z

Here is the log:

pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\python.exe"
Runtime Config File: "C:\Users\USER\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\web\config.py"
Webapp Path: "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\python.exe -s C:\Users\USER\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py"
Environment: 
  - ALLUSERSPROFILE: C:\ProgramData
  - APPDATA: C:\Users\USER\AppData\Roaming
  - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_7684_FYAGKTEFIQTJMJRL
  - CHROME_RESTART: NW.js|NW.js ist abgestürzt. Jetzt neu starten?|LEFT_TO_RIGHT
  - CommonProgramFiles: C:\Program Files\Common Files
  - CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
  - CommonProgramW6432: C:\Program Files\Common Files
  - COMPUTERNAME: SERVERFIL2
  - ComSpec: C:\WINDOWS\system32\cmd.exe
  - DriverData: C:\Windows\System32\Drivers\DriverData
  - EFC_1336: 1
  - HOMEDRIVE: C:
  - HOMEPATH: \Users\USER
  - LOCALAPPDATA: C:\Users\USER\AppData\Local
  - LOGONSERVER: \\SERVERFIL2
  - NUMBER_OF_PROCESSORS: 6
  - OneDrive: C:\Users\USER\OneDrive
  - OS: Windows_NT
  - Path: C:\Users\USER\AppData\Local\Programs\pgAdmin 4\runtime;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\Git\cmd;C:\Users\USER\AppData\Local\Microsoft\WindowsApps;
  - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
  - PGADMIN_INT_KEY: 89384c35-c5b9-46d1-af0f-d8d9cd561bdd
  - PGADMIN_INT_PORT: 55051
  - PGADMIN_SERVER_MODE: OFF
  - PROCESSOR_ARCHITECTURE: AMD64
  - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 158 Stepping 10, GenuineIntel
  - PROCESSOR_LEVEL: 6
  - PROCESSOR_REVISION: 9e0a
  - PROG27B48B2C054: 1
  - 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\USER\AppData\Local\Temp
  - TMP: C:\Users\USER\AppData\Local\Temp
  - USERDOMAIN: SERVERFIL2
  - USERDOMAIN_ROAMINGPROFILE: SERVERFIL2
  - USERNAME: USER
  - USERPROFILE: C:\Users\USER
  - windir: C:\WINDOWS
--------------------------------------------------------

Total spawn time to start the pgAdmin4 server: 0.007 Sec
2024-05-23 11:30:27,623: ERROR	pgadmin:	Database migration failed

2024-05-23 11:30:27,631: ERROR	pgadmin:	Traceback (most recent call last):
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 386, in upgrade_db
    db_upgrade(app)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
    flask_migrate.upgrade(migration_folder)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped
    f(*args, **kwargs)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\flask_migrate\__init__.py", line 200, in upgrade
    command.upgrade(config, revision, sql=sql, tag=tag)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\command.py", line 403, in upgrade
    script.run_env()
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\script\base.py", line 583, in run_env
    util.load_python_file(self.dir, "env.py")
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\util\pyfiles.py", line 95, in load_python_file
    module = load_module_py(module_id, path)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\util\pyfiles.py", line 113, in load_module_py
    spec.loader.exec_module(module)  # type: ignore
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<frozen importlib._bootstrap_external>", line 995, in exec_module
  File "<frozen importlib._bootstrap>", line 488, in _call_with_frames_removed
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\..\..\migrations\env.py", line 95, in <module>
    run_migrations_online()
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\..\..\migrations\env.py", line 87, in run_migrations_online
    context.run_migrations()
  File "<string>", line 8, in run_migrations
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\runtime\environment.py", line 948, in run_migrations
    self.get_context().run_migrations(**kw)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\runtime\migration.py", line 627, in run_migrations
    step.migration_fn(**kw)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\web\migrations\versions\a39bd015b644_.py", line 26, in upgrade
    with op.batch_alter_table("sharedserver") as batch_op:
  File "contextlib.py", line 144, in __exit__
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\operations\base.py", line 398, in batch_alter_table
    impl.flush()
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\operations\batch.py", line 142, in flush
    existing_table = Table(
                     ^^^^^^
  File "<string>", line 2, in __new__
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\util\deprecations.py", line 281, in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
           ^^^^^^^^^^^^^^^^^^^
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 431, in __new__
    return cls._new(*args, **kw)
           ^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new
    with util.safe_reraise():
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in __exit__
    raise exc_value.with_traceback(exc_tb)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 481, in _new
    table.__init__(name, metadata, *args, _no_init=False, **kw)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__
    self._autoload(
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload
    conn_insp.reflect_table(
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1570, in reflect_table
    self._reflect_fk(
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1768, in _reflect_fk
    sa_schema.Table(
  File "<string>", line 2, in __new__
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\util\deprecations.py", line 281, in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
           ^^^^^^^^^^^^^^^^^^^
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 431, in __new__
    return cls._new(*args, **kw)
           ^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new
    with util.safe_reraise():
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in __exit__
    raise exc_value.with_traceback(exc_tb)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 481, in _new
    table.__init__(name, metadata, *args, _no_init=False, **kw)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__
    self._autoload(
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload
    conn_insp.reflect_table(
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1570, in reflect_table
    self._reflect_fk(
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1768, in _reflect_fk
    sa_schema.Table(
  File "<string>", line 2, in __new__
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\util\deprecations.py", line 281, in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
           ^^^^^^^^^^^^^^^^^^^
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 431, in __new__
    return cls._new(*args, **kw)
           ^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new
    with util.safe_reraise():
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in __exit__
    raise exc_value.with_traceback(exc_tb)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 481, in _new
    table.__init__(name, metadata, *args, _no_init=False, **kw)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__
    self._autoload(
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload
    conn_insp.reflect_table(
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1538, in reflect_table
    raise exc.NoSuchTableError(table_name)
sqlalchemy.exc.NoSuchTableError: user_old


Traceback (most recent call last):
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 386, in upgrade_db
    db_upgrade(app)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
    flask_migrate.upgrade(migration_folder)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped
    f(*args, **kwargs)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\flask_migrate\__init__.py", line 200, in upgrade
    command.upgrade(config, revision, sql=sql, tag=tag)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\command.py", line 403, in upgrade
    script.run_env()
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\script\base.py", line 583, in run_env
    util.load_python_file(self.dir, "env.py")
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\util\pyfiles.py", line 95, in load_python_file

    module = load_module_py(module_id, path)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\util\pyfiles.py", line 113, in load_module_py
    spec.loader.exec_module(module)  # type: ignore
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<frozen importlib._bootstrap_external>", line 995, in exec_module
  File "<frozen importlib._bootstrap>", line 488, in _call_with_frames_removed
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\..\..\migrations\env.py", line 95, in <module>
    run_migrations_online()
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\..\..\migrations\env.py", line 87, in run_migrations_online
    context.run_migrations()
  File "<string>", line 8, in run_migrations
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\runtime\environment.py", line 948, in run_migrations
    self.get_context().run_migrations(**kw)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\runtime\migration.py", line 627, in run_migrations
    step.migration_fn(**kw)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\web\migrations\versions\a39bd015b644_.py", line 26, in upgrade
    with op.batch_alter_table("sharedserver") as batch_op:
  File "contextlib.py", line 144, in __exit__
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\operations\base.py", line 398, in batch_alter_table
    impl.flush()
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\operations\batch.py", line 142, in flush
    existing_table = Table(
                     ^^^^^^
  File "<string>", line 2, in __new__
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\util\deprecations.py", line 281, in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
           ^^^^^^^^^^^^^^^^^^^
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 431, in __new__
    return cls._new(*args, **kw)
           ^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new
    with util.safe_reraise():
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in __exit__
    raise exc_value.with_traceback(exc_tb)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 481, in _new
    table.__init__(name, metadata, *args, _no_init=False, **kw)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__
    self._autoload(
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload
    conn_insp.reflect_table(
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1570, in reflect_table
    self._reflect_fk(
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1768, in _reflect_fk
    sa_schema.Table(
  File "<string>", line 2, in __new__
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\util\deprecations.py", line 281, in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
           ^^^^^^^^^^^^^^^^^^^
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 431, in __new__
    return cls._new(*args, **kw)
           ^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new
    with util.safe_reraise():
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in __exit__
    raise exc_value.with_traceback(exc_tb)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 481, in _new
    table.__init__(name, metadata, *args, _no_init=False, **kw)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__
    self._autoload(
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload
    conn_insp.reflect_table(
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1570, in reflect_table
    self._reflect_fk(
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1768, in _reflect_fk
    sa_schema.Table(
  File "<string>", line 2, in __new__
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\util\deprecations.py", line 281, in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
           ^^^^^^^^^^^^^^^^^^^
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 431, in __new__
    return cls._new(*args, **kw)
           ^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new
    with util.safe_reraise():
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in __exit__
    raise exc_value.with_traceback(exc_tb)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 481, in _new
    table.__init__(name, metadata, *args, _no_init=False, **kw)
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__
    self._autoload(
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload
    conn_insp.reflect_table(
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1538, in reflect_table
    raise exc.NoSuchTableError(table_name)
sqlalchemy.exc.NoSuchTableError: user_old

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py", line 103, in <module>
    app = create_app()
          ^^^^^^^^^^^^
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 473, in create_app
    run_migration_for_sqlite()
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 432, in run_migration_for_sqlite
    upgrade_db()
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 391, in upgrade_db
    backup_db_file()
  File "C:\Users\USER\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 368, in backup_db_file
    os.rename(SQLITE_PATH, backup_file_name)
PermissionError: [WinError 32] Der Prozess kann nicht auf die Datei zugreifen, da sie von einem anderen Prozess verwendet wird: 'C:\\Users\\User\\AppData\\Roaming\\pgAdmin\\pgadmin4.db' -> 'C:\\Users\\User\\AppData\\Roaming\\pgAdmin\\pgadmin4.db.20240523113027'

appreciated · 2024-05-23T09:49:27Z

@khushboovashi I managed to "solve" the issue by deleting the "C:\Users\User\AppData\Roaming\pgAdmin" directory. Since I have only one connection configured, this was acceptable in my case. But I would appreciate if you could still look into this issue. Since other (Windows?) users may also experience the same problem.

khushboovashi · 2024-05-23T09:52:10Z

@khushboovashi I managed to "solve" the issue by deleting the "C:\Users\User\AppData\Roaming\pgAdmin" directory. Since I have only one connection configured, this was acceptable in my case. But I would appreciate if you could still look into this issue. Since other (Windows?) users may also experience the same problem.

Do you have other pgAdmin installations side by side?

appreciated · 2024-05-23T10:04:59Z

@khushboovashi Yes we had an old version installed (but not running), I removed it, reinstalled the new version still did not start. Only after deleting the folder it worked.
I also checked with procmon.exe if the mentioned files C:\\Users\\<User>\\AppData\\Roaming\\pgAdmin\\pgadmin4.db was being used by another process, it found no match. I also disabled anti-virus.
It seems to me that the current version of pgadmin4 seems to deadlock itself, if a specific configuration is being used.

appreciated · 2024-05-23T10:07:14Z

Note I have access to a second windows machine that does not suffer this issue.

Uju-Chinedum · 2024-05-23T18:30:11Z

I've tried everything but i still get the error and i'm on pgAdmin v8:

pgAdmin Runtime Environment

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

ALLUSERSPROFILE: C:\ProgramData
APPDATA: C:\Users\USER\AppData\Roaming
ChocolateyInstall: C:\ProgramData\chocolatey
ChocolateyLastPathUpdate: 132931242397821814
CHROME_CRASHPAD_PIPE_NAME: \.\pipe\crashpad_10872_VWDMCCDVNWXXMKRD
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: SAVADOW
ComSpec: C:\WINDOWS\system32\cmd.exe
DERBY_HOME: C:\derby
docgen: C:\Users\USER\Downloads\docgen.exe
DriverData: C:\Windows\System32\Drivers\DriverData
GIT_LFS_PATH: C:\Program Files\Git LFS
HADOOP_HOME: C:\hadoop
HADOOP_USER_CLASSPATH_FIRST: true
HIVE_BIN: C:\hive\bin
HIVE_HOME: C:\hive
HIVE_LIB: C:\hive\lib
HOMEDRIVE: C:
HOMEPATH: \Users\USER
JAVA_HOME: C:\Java\jdk1.8.0_202
LOCALAPPDATA: C:\Users\USER\AppData\Local
LOGONSERVER: \SAVADOW
NUMBER_OF_PROCESSORS: 2
OneDrive: C:\Users\USER\OneDrive
OneDriveConsumer: C:\Users\USER\OneDrive
OS: Windows_NT
Path: C:\Users\USER\AppData\Local\Programs\pgAdmin 4\runtime;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0;C:\WINDOWS\System32\OpenSSH;C:\ProgramData\chocolatey\bin;C:\Java\jdk1.8.0_202\bin;C:\hadoop\bin;C:\hadoop\sbin;C:\hive\bin;C:\deby\bin;C:\spark\bin;C:\Program Files\Git LFS;C:\Program Files\Git\cmd;C:\Program Files\Notepad++;C:\Program Files\Perforce;C:\Program Files\nodejs;C:\Users\USER\Downloads\docgen.exe;C:\Program Files\PostgreSQL\16\bin;C:\Users\USER\AppData\Local\Programs\pgAdmin 4\runtime;C:\Program Files\MySQL\MySQL Shell 8.0\bin;C:\Users\USER\AppData\Local\Programs\Python\Python311\Scripts;C:\Users\USER\AppData\Local\Programs\Python\Python311;C:\Users\USER\AppData\Local\Programs\Python\Python310\Scripts;C:\Users\USER\AppData\Local\Programs\Python\Python310;C:\Users\USER\AppData\Local\Programs\Python\Python310;C:\Users\USER\AppData\Local\Programs\Microsoft VS Code\bin;C:\Program Files\heroku\bin;C:\Users\USER\AppData\Local\Pandoc;C:\Users\USER\AppData\Local\Programs\MiKTeX\miktex\bin\x64;C:\Users\USER\AppData\Roaming\npm;C:\Program Files\PostgreSQL\16\bin;
PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PGADMIN_INT_KEY: 795a3a27-2517-48c6-8c8a-65e12fb70db6
PGADMIN_INT_PORT: 57095
PGADMIN_SERVER_MODE: OFF
POSTMAN_DISABLE_GPU: true
PROCESSOR_ARCHITECTURE: AMD64
PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 69 Stepping 1, GenuineIntel
PROCESSOR_LEVEL: 6
PROCESSOR_REVISION: 4501
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
PYSPARK_DRIVER_PYTHON: jupyter
PYSPARK_DRIVER_PYTHON_OPTS: notebook
SESSIONNAME: Console
SPARK_HOME: C:\spark
SystemDrive: C:
SystemRoot: C:\WINDOWS
TEMP: C:\Users\USER\AppData\Local\Temp
TMP: C:\Users\USER\AppData\Local\Temp
USERDOMAIN: SAVADOW
USERDOMAIN_ROAMINGPROFILE: SAVADOW
USERNAME: USER
USERPROFILE: C:\Users\USER
windir: C:\WINDOWS

Total spawn time to start the pgAdmin4 server: 3.224 Sec

akshay-joshi assigned deja94 May 17, 2024

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

The pgAdmin 4 server could not be contacted #7447

The pgAdmin 4 server could not be contacted #7447

deja94 commented May 3, 2024 •

edited

khushboovashi commented May 17, 2024

appreciated commented May 23, 2024

khushboovashi commented May 23, 2024

appreciated commented May 23, 2024

appreciated commented May 23, 2024

khushboovashi commented May 23, 2024

appreciated commented May 23, 2024

appreciated commented May 23, 2024 •

edited

Uju-Chinedum commented May 23, 2024

The pgAdmin 4 server could not be contacted #7447

The pgAdmin 4 server could not be contacted #7447

Comments

deja94 commented May 3, 2024 • edited

pgAdmin Runtime Environment

khushboovashi commented May 17, 2024

appreciated commented May 23, 2024

khushboovashi commented May 23, 2024

appreciated commented May 23, 2024

appreciated commented May 23, 2024

khushboovashi commented May 23, 2024

appreciated commented May 23, 2024

appreciated commented May 23, 2024 • edited

Uju-Chinedum commented May 23, 2024

pgAdmin Runtime Environment

deja94 commented May 3, 2024 •

edited

appreciated commented May 23, 2024 •

edited