pgAdmin Server fails to start (solved, but...)

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'