Request a Demo
Home   >   mailing lists

pgAdmin Server fails to start (solved, but...) - Mailing list pgadmin-support

From Fernando Hevia
Subject pgAdmin Server fails to start (solved, but...)
Date
Msg-id CAGYT1XQ6HvCxRVyqDR-nAQPr73-QnC6tSMRaeNz4ja9SKJ+qwg@mail.gmail.com
Whole thread Raw
List pgadmin-support
Tree view
I recently upgraded to pgAdmin4 9.9 and got stuck with the server failing to start.

From the log output (below) I identified this issue as being the root cause for the startup failure:

sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: user_preferences.pid, user_preferences.uid
[SQL: UPDATE user_preferences SET pid=? WHERE user_preferences.pid = ?]
[parameters: (318, 191)]

I used DB Browser for SQL Lite, identified and deleted record with {pid, uid, value} = {191, 1, 2} in user_preferences.

This apparently solved the issue and pgAdmin Server starts now correctly. 
After startup I verified the table contents and the deleted record is still gone and a new one appeared with values {318, 1, 2}

pgAdmin seems to be working correctly but I wonder what the deleted record significance is and if I should re-insert it.

Thanks,
Fernando.



--- LOG OUTPUT ---
pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\python.exe"
Runtime Config File: "C:\Users\Fernando\AppData\Roaming\pgadmin4\config.json"
Webapp Path: "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\python.exe -s C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py"
Environment:
  - ALLUSERSPROFILE: C:\ProgramData
  - APPDATA: C:\Users\Fernando\AppData\Roaming
  - CommonProgramFiles: C:\Program Files\Common Files
  - CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
  - CommonProgramW6432: C:\Program Files\Common Files
  - COMPUTERNAME: DESKTOP-CUBOFH
  - ComSpec: C:\WINDOWS\system32\cmd.exe
  - DriverData: C:\Windows\System32\Drivers\DriverData
  - ELECTRON_ENABLE_SECURITY_WARNINGS: false
  - HOMEDRIVE: C:
  - HOMEPATH: \Users\Fernando
  - LOCALAPPDATA: C:\Users\Fernando\AppData\Local
  - LOGONSERVER: \\DESKTOP-CUBOFH
  - Name: VRSNTemp
  - NUMBER_OF_PROCESSORS: 4
  - OneDrive: C:\Users\Fernando\OneDrive - TECLAB
  - OneDriveCommercial: C:\Users\Fernando\OneDrive - TECLAB
  - OneDriveConsumer: C:\Users\Fernando\OneDrive
  - OPENSSL_CONF: C:\Program Files\OpenSSL\bin\openssl.cfg
  - ORIGINAL_XDG_CURRENT_DESKTOP: undefined
  - OS: Windows_NT
  - Path: C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\runtime;C:\Program Files (x86)\Common Files\Oracle\Java\java8path;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS\System32\Wbem;C:\WINDOWS;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\WINDOWS\system32;C:\WINDOWS\System32\Wbem;C:\WINDOWS;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\wbin;C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\Common Files\NetSarang;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files\Amazon\AWSCLI\bin\;C:\Program Files\OpenVPN\bin;C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\OpenSSL\bin;C:\Program Files\PuTTY\;C:\Program Files\dotnet\;C:\Program Files\Git\cmd;C:\Program Files\Nacional Sistema\mysql\bin;C;C:\Program Files\WireGuard\;C:\Program Files\NVIDIA Corporation\NVIDIA app\NvDLISR;C:\Program Files\PowerShell\7\;C:\Users\Fernando\AppData\Local\CertiSur\Alison-Desktop\;C:\Program Files\Yubico\Yubico PIV Tool\bin\;C:\Users\Fernando\AppData\Local\Google\Cloud SDK\google-cloud-sdk\bin;H:\Program Files (x86)\Microsoft VS Code\bin
  - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
  - PGADMIN_INT_KEY: e54c58dd-f9c5-4805-be03-01f05aa49cc1
  - PGADMIN_INT_PORT: 53774
  - PGADMIN_SERVER_MODE: OFF
  - POWERSHELL_DISTRIBUTION_CHANNEL: MSI:Windows 10 Pro
  - PROCESSOR_ARCHITECTURE: AMD64
  - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 94 Stepping 3, GenuineIntel
  - PROCESSOR_LEVEL: 6
  - PROCESSOR_REVISION: 5e03
  - ProgramData: C:\ProgramData
  - ProgramFiles: C:\Program Files
  - ProgramFiles(x86): C:\Program Files (x86)
  - ProgramW6432: C:\Program Files
  - PSModulePath: C:\Users\Fernando\Documents\WindowsPowerShell\Modules;C:\Users\Fernando\AppData\Local\Google\Cloud SDK\google-cloud-sdk\platform\PowerShell
  - PUBLIC: C:\Users\Public
  - SESSIONNAME: Console
  - SystemDrive: C:
  - SystemRoot: C:\WINDOWS
  - TEMP: C:\Users\Fernando\AppData\Local\Temp
  - TMP: C:\Users\Fernando\AppData\Local\Temp
  - USERDOMAIN: DESKTOP-CUBOFH
  - USERDOMAIN_ROAMINGPROFILE: DESKTOP-CUBOFH
  - USERNAME: Fernando
  - USERPROFILE: C:\Users\Fernando
  - VBOX_MSI_INSTALL_PATH: C:\Program Files\Oracle\VirtualBox\
  - windir: C:\WINDOWS
  - __COMPAT_LAYER: DetectorsAppHealth
--------------------------------------------------------

Total spawn time to start the pgAdmin4 server: 0.043 Sec
2025-10-27 20:33:10,768: ERROR pgadmin: Database migration failed

2025-10-27 20:33:10,782: ERROR pgadmin: Traceback (most recent call last):
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1967, in _exec_single_context
    self.dialect.do_execute(
    ~~~~~~~~~~~~~~~~~~~~~~~^
        cursor, str_statement, effective_parameters, context
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
    ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
sqlite3.IntegrityError: UNIQUE constraint failed: user_preferences.pid, user_preferences.uid

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 390, in upgrade_db
    db_upgrade(app)
    ~~~~~~~~~~^^^^^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
    flask_migrate.upgrade(migration_folder)
    ~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped
    f(*args, **kwargs)
    ~^^^^^^^^^^^^^^^^^
  File "C:\Users\Fernando\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\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\command.py", line 483, in upgrade
    script.run_env()
    ~~~~~~~~~~~~~~^^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\script\base.py", line 549, in run_env
    util.load_python_file(self.dir, "env.py")
    ~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\util\pyfiles.py", line 116, in load_python_file
    module = load_module_py(module_id, path)
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\util\pyfiles.py", line 136, in load_module_py
    spec.loader.exec_module(module)  # type: ignore
    ~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^
  File "<frozen importlib._bootstrap_external>", line 1026, in exec_module
  File "<frozen importlib._bootstrap>", line 488, in _call_with_frames_removed
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\..\..\migrations\env.py", line 95, in <module>
    run_migrations_online()
    ~~~~~~~~~~~~~~~~~~~~~^^
  File "C:\Users\Fernando\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\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\runtime\environment.py", line 946, in run_migrations
    self.get_context().run_migrations(**kw)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^
  File "C:\Users\Fernando\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\Fernando\AppData\Local\Programs\pgAdmin 4\web\migrations\versions\e6ed5dac37c2_.py", line 142, in upgrade
    op.execute(
    ~~~~~~~~~~^
        user_pref_table.update().where(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
            user_pref_table.c.pid == key).values(pid=val)
            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "<string>", line 8, in execute
  File "<string>", line 3, in execute
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\operations\ops.py", line 2591, in execute
    return operations.invoke(op)
           ~~~~~~~~~~~~~~~~~^^^^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\operations\base.py", line 441, in invoke
    return fn(self, operation)
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\operations\toimpl.py", line 240, in execute_sql
    operations.migration_context.impl.execute(
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
        operation.sqltext, execution_options=operation.execution_options
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\ddl\impl.py", line 253, in execute
    self._exec(sql, execution_options)
    ~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\ddl\impl.py", line 246, in _exec
    return conn.execute(construct, params)
           ~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1419, in execute
    return meth(
        self,
        distilled_parameters,
        execution_options or NO_OPTIONS,
    )
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\elements.py", line 526, in _execute_on_connection
    return connection._execute_clauseelement(
           ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
        self, distilled_params, execution_options
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1641, in _execute_clauseelement
    ret = self._execute_context(
        dialect,
    ...<8 lines>...
        cache_hit=cache_hit,
    )
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1846, in _execute_context
    return self._exec_single_context(
           ~~~~~~~~~~~~~~~~~~~~~~~~~^
        dialect, context, statement, parameters
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1986, in _exec_single_context
    self._handle_dbapi_exception(
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
        e, str_statement, effective_parameters, cursor, context
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 2355, in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1967, in _exec_single_context
    self.dialect.do_execute(
    ~~~~~~~~~~~~~~~~~~~~~~~^
        cursor, str_statement, effective_parameters, context
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
    ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: user_preferences.pid, user_preferences.uid
[SQL: UPDATE user_preferences SET pid=? WHERE user_preferences.pid = ?]
[parameters: (318, 191)]
(Background on this error at: https://sqlalche.me/e/20/gkpj)


Traceback (most recent call last):
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1967, in _exec_single_context
    self.dialect.do_execute(
    ~~~~~~~~~~~~~~~~~~~~~~~^
        cursor, str_statement, effective_parameters, context
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
    ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
sqlite3.IntegrityError: UNIQUE constraint failed: user_preferences.pid, user_preferences.uid

The above exception was the direct cause of the following exception:

Traceback (most recent call last):

  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 390, in upgrade_db
    db_upgrade(app)
    ~~~~~~~~~~^^^^^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
    flask_migrate.upgrade(migration_folder)
    ~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped
    f(*args, **kwargs)
    ~^^^^^^^^^^^^^^^^^
  File "C:\Users\Fernando\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\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\command.py", line 483, in upgrade
    script.run_env()
    ~~~~~~~~~~~~~~^^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\script\base.py", line 549, in run_env
    util.load_python_file(self.dir, "env.py")
    ~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\util\pyfiles.py", line 116, in load_python_file
    module = load_module_py(module_id, path)
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\util\pyfiles.py", line 136, in load_module_py
    spec.loader.exec_module(module)  # type: ignore
    ~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^
  File "<frozen importlib._bootstrap_external>", line 1026, in exec_module
  File "<frozen importlib._bootstrap>", line 488, in _call_with_frames_removed
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\..\..\migrations\env.py", line 95, in <module>
    run_migrations_online()
    ~~~~~~~~~~~~~~~~~~~~~^^
  File "C:\Users\Fernando\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\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\runtime\environment.py", line 946, in run_migrations
    self.get_context().run_migrations(**kw)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^
  File "C:\Users\Fernando\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\Fernando\AppData\Local\Programs\pgAdmin 4\web\migrations\versions\e6ed5dac37c2_.py", line 142, in upgrade
    op.execute(
    ~~~~~~~~~~^
        user_pref_table.update().where(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
            user_pref_table.c.pid == key).values(pid=val)
            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "<string>", line 8, in execute
  File "<string>", line 3, in execute
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\operations\ops.py", line 2591, in execute
    return operations.invoke(op)
           ~~~~~~~~~~~~~~~~~^^^^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\operations\base.py", line 441, in invoke
    return fn(self, operation)
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\operations\toimpl.py", line 240, in execute_sql
    operations.migration_context.impl.execute(
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
        operation.sqltext, execution_options=operation.execution_options
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\ddl\impl.py", line 253, in execute
    self._exec(sql, execution_options)
    ~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\ddl\impl.py", line 246, in _exec
    return conn.execute(construct, params)
           ~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1419, in execute
    return meth(
        self,
        distilled_parameters,
        execution_options or NO_OPTIONS,
    )
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\elements.py", line 526, in _execute_on_connection
    return connection._execute_clauseelement(
           ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
        self, distilled_params, execution_options
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1641, in _execute_clauseelement
    ret = self._execute_context(
        dialect,
    ...<8 lines>...
        cache_hit=cache_hit,
    )
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1846, in _execute_context
    return self._exec_single_context(
           ~~~~~~~~~~~~~~~~~~~~~~~~~^
        dialect, context, statement, parameters
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1986, in _exec_single_context
    self._handle_dbapi_exception(
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
        e, str_statement, effective_parameters, cursor, context
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 2355, in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1967, in _exec_single_context
    self.dialect.do_execute(
    ~~~~~~~~~~~~~~~~~~~~~~~^
        cursor, str_statement, effective_parameters, context
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
    ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: user_preferences.pid, user_preferences.uid
[SQL: UPDATE user_preferences SET pid=? WHERE user_preferences.pid = ?]
[parameters: (318, 191)]
(Background on this error at: https://sqlalche.me/e/20/gkpj)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py", line 93, in <module>
    app = create_app()
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 478, in create_app
    run_migration_for_sqlite()
    ~~~~~~~~~~~~~~~~~~~~~~~~^^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 435, in run_migration_for_sqlite
    upgrade_db()
    ~~~~~~~~~~^^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 395, in upgrade_db
    backup_db_file()
    ~~~~~~~~~~~~~~^^
  File "C:\Users\Fernando\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 372, in backup_db_file
    os.rename(SQLITE_PATH, backup_file_name)
    ~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PermissionError: [WinError 32] El proceso no tiene acceso al archivo porque est� siendo utilizado por otro proceso: 'C:\\Users\\Fernando\\AppData\\Roaming\\pgAdmin\\pgadmin4.db' -> 'C:\\Users\\Fernando\\AppData\\Roaming\\pgAdmin\\pgadmin4.db.20251027203310'




pgadmin-support by date:

Previous
From: Aditya Toshniwal
Date:
Subject: Re: New installation woes
Next
From: Aditya Toshniwal
Date:
Subject: Re: New installation woes