PgAdmin Error on startup

Hello,

When we start it, a timeout error appears after 90s.

It is a new installation of pgAdmin v7.6 on Windows 10 Pro 64bit. We tested with versions pgAdmin 4 v7.4, v7.5, v7.6

When we start it, a timeout error appears after 90s.

The browser version of pgAdmin was previously installed on this computer.

Error:

The pgAdmin 4 server could not be contacted:

pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Program Files\pgAdmin 4\v7\python\python.exe"
Runtime Config File: "C:\Users\lunuk\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Program Files\pgAdmin 4\v7\web\config.py"
Webapp Path: "C:\Program Files\pgAdmin 4\v7\web\pgAdmin4.py"
pgAdmin Command: "C:\Program Files\pgAdmin 4\v7\python\python.exe -s C:\Program Files\pgAdmin 4\v7\web\pgAdmin4.py"
Environment:
- ALLUSERSPROFILE: C:\ProgramData
- APPDATA: C:\Users\lunuk\AppData\Roaming
- CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_185060_CGIQDVDYVIMXGIIW
- CHROME_RESTART: NW.js|Opa! NW.js se je zrušil. Ga želite znova zagnati?|LEFT_TO_RIGHT
- CommonProgramFiles: C:\Program Files\Common Files
- CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
- CommonProgramW6432: C:\Program Files\Common Files
- COMPUTERNAME: LUNUK1-PC
- ComSpec: C:\WINDOWS\system32\cmd.exe
- DriverData: C:\Windows\System32\Drivers\DriverData
- HOMEDRIVE: P:
- HOMEPATH: \
- HOMESHARE: \\mom-nas\home\LUNUK
- LOCALAPPDATA: C:\Users\lunuk\AppData\Local
- LOGONSERVER: \\MOM-DC02
- MOZ_PLUGIN_PATH: C:\Program Files\Tracker Software\PDF Viewer\Win32\
- NUMBER_OF_PROCESSORS: 8
- OneDrive: C:\Users\lunuk\OneDrive - Mestna občina Maribor
- OneDriveCommercial: C:\Users\lunuk\OneDrive - Mestna občina Maribor
- OS: Windows_NT
- Path: C:\Program Files\pgAdmin 4\v7\runtime;C:\Oracle\product\11.2.0\client_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Mastersoft\MPX\;;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\NVIDIA Corporation\NVIDIA NGX;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\dotnet\;C:\Users\lunuk\AppData\Local\Microsoft\WindowsApps;
- PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
- PGADMIN_INT_KEY: 428572fb-2863-4870-be74-8f3a432aaa17
- PGADMIN_INT_PORT: 5050
- PGADMIN_SERVER_MODE: OFF
- PROCESSOR_ARCHITECTURE: AMD64
- PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 158 Stepping 13, GenuineIntel
- PROCESSOR_LEVEL: 6
- PROCESSOR_REVISION: 9e0d
- 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\lunuk\AppData\Local\Temp
- TMP: C:\Users\lunuk\AppData\Local\Temp
- UATDATA: C:\Windows\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77
- USERDNSDOMAIN: MOM.INT
- USERDOMAIN: MOM_DOMAIN
- USERDOMAIN_ROAMINGPROFILE: MOM_DOMAIN
- USERNAME: LUNUK
- USERPROFILE: C:\Users\lunuk
- windir: C:\WINDOWS
--------------------------------------------------------

Total spawn time to start the pgAdmin4 server: 0.033 Sec
2023-08-25 09:18:58,485: ERROR pgadmin: Database migration failed

2023-08-25 09:18:58,492: ERROR pgadmin: Traceback (most recent call last):
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\engine\base.py", line 1965, in _exec_single_context
self.dialect.do_execute(
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\engine\default.py", line 921, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: duplicate column name: username

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

Traceback (most recent call last):
File "C:\Program Files\pgAdmin 4\v7\web\pgadmin\__init__.py", line 390, in upgrade_db
db_upgrade(app)
File "C:\Program Files\pgAdmin 4\v7\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
flask_migrate.upgrade(migration_folder)
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped
f(*args, **kwargs)
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\flask_migrate\__init__.py", line 200, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\command.py", line 385, in upgrade
script.run_env()
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\script\base.py", line 582, in run_env
util.load_python_file(self.dir, "env.py")
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\util\pyfiles.py", line 94, in load_python_file
module = load_module_py(module_id, path)
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\util\pyfiles.py", line 110, in load_module_py
spec.loader.exec_module(module) # type: ignore
File "<frozen importlib._bootstrap_external>", line 883, in exec_module
File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
File "C:\Program Files\pgAdmin 4\v7\web\pgadmin\setup\..\..\migrations\env.py", line 95, in <module>
run_migrations_online()
File "C:\Program Files\pgAdmin 4\v7\web\pgadmin\setup\..\..\migrations\env.py", line 87, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\runtime\environment.py", line 928, in run_migrations
self.get_context().run_migrations(**kw)
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\runtime\migration.py", line 628, in run_migrations
step.migration_fn(**kw)
File "C:\Program Files\pgAdmin 4\v7\web\migrations\versions\7fedf8531802_.py", line 27, in upgrade
op.add_column('user', sa.Column('username', sa.String(length=256),
File "<string>", line 8, in add_column
File "<string>", line 3, in add_column
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\operations\ops.py", line 2119, in add_column
return operations.invoke(op)
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\operations\base.py", line 395, in invoke
return fn(self, operation)
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\operations\toimpl.py", line 154, in add_column
operations.impl.add_column(table_name, column, schema=schema, **kw)
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\ddl\impl.py", line 322, in add_column
self._exec(base.AddColumn(table_name, column, schema=schema))
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\ddl\impl.py", line 193, in _exec
return conn.execute( # type: ignore[call-overload]
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\engine\base.py", line 1412, in execute
return meth(
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\sql\ddl.py", line 181, in _execute_on_connection
return connection._execute_ddl(
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\engine\base.py", line 1524, in _execute_ddl
ret = self._execute_context(
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\engine\base.py", line 1844, in _execute_context
return self._exec_single_context(
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\engine\base.py", line 1984, in _exec_single_context
self._handle_dbapi_exception(
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\engine\base.py", line 2339, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\engine\base.py", line 1965, in _exec_single_context
self.dialect.do_execute(
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\engine\default.py", line 921, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) duplicate column name: username
[SQL: ALTER TABLE user ADD COLUMN username VARCHAR(256) DEFAULT '' NOT NULL]
(Background on this error at: https://sqlalche.me/e/20/e3q8)


Traceback (most recent call last):
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\engine\base.py", line 1965, in _exec_single_context
self.dialect.do_execute(
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\engine\default.py", line 921, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: duplicate column name: username

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

Traceback (most recent call last):
File "C:\Program Files\pgAdmin 4\v7\web\pgadmin\__init__.py", line 390, in upgrade_db
db_upgrade(app)
File "C:\Program Files\pgAdmin 4\v7\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
flask_migrate.upgrade(migration_folder)
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped
f(*args, **kwargs)
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\flask_migrate\__init__.py", line 200, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\command.py", line 385, in upgrade
script.run_env()
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\script\base.py", line 582, in run_env
util.load_python_file(self.dir, "env.py")
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\util\pyfiles.py", line 94, in load_python_file
module = load_module_py(module_id, path)
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\util\pyfiles.py", line 110, in load_module_py
spec.loader.exec_module(module) # type: ignore
File "<frozen importlib._bootstrap_external>", line 883, in exec_module

File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
File "C:\Program Files\pgAdmin 4\v7\web\pgadmin\setup\..\..\migrations\env.py", line 95, in <module>
run_migrations_online()
File "C:\Program Files\pgAdmin 4\v7\web\pgadmin\setup\..\..\migrations\env.py", line 87, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\runtime\environment.py", line 928, in run_migrations
self.get_context().run_migrations(**kw)
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\runtime\migration.py", line 628, in run_migrations
step.migration_fn(**kw)
File "C:\Program Files\pgAdmin 4\v7\web\migrations\versions\7fedf8531802_.py", line 27, in upgrade
op.add_column('user', sa.Column('username', sa.String(length=256),
File "<string>", line 8, in add_column
File "<string>", line 3, in add_column
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\operations\ops.py", line 2119, in add_column
return operations.invoke(op)
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\operations\base.py", line 395, in invoke

return fn(self, operation)
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\operations\toimpl.py", line 154, in add_column
operations.impl.add_column(table_name, column, schema=schema, **kw)
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\ddl\impl.py", line 322, in add_column
self._exec(base.AddColumn(table_name, column, schema=schema))
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\alembic\ddl\impl.py", line 193, in _exec
return conn.execute( # type: ignore[call-overload]
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\engine\base.py", line 1412, in execute
return meth(
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\sql\ddl.py", line 181, in _execute_on_connection
return connection._execute_ddl(
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\engine\base.py", line 1524, in _execute_ddl
ret = self._execute_context(
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\engine\base.py", line 1844, in _execute_context
return self._exec_single_context(
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\engine\base.py", line 1984, in _exec_single_context

self._handle_dbapi_exception(
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\engine\base.py", line 2339, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\engine\base.py", line 1965, in _exec_single_context
self.dialect.do_execute(
File "C:\Program Files\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\engine\default.py", line 921, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) duplicate column name: username
[SQL: ALTER TABLE user ADD COLUMN username VARCHAR(256) DEFAULT '' NOT NULL]
(Background on this error at: https://sqlalche.me/e/20/e3q8)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "C:\Program Files\pgAdmin 4\v7\web\pgAdmin4.py", line 104, in <module>
app = create_app()
File "C:\Program Files\pgAdmin 4\v7\web\pgadmin\__init__.py", line 477, in create_app
run_migration_for_sqlite()
File "C:\Program Files\pgAdmin 4\v7\web\pgadmin\__init__.py", line 436, in run_migration_for_sqlite
upgrade_db()
File "C:\Program Files\pgAdmin 4\v7\web\pgadmin\__init__.py", line 395, in upgrade_db

backup_db_file()
File "C:\Program Files\pgAdmin 4\v7\web\pgadmin\__init__.py", line 372, in backup_db_file
os.rename(SQLITE_PATH, backup_file_name)
PermissionError: [WinError 32] The process cannot access the file because it is being used by another process: 'C:\\Users\\lunuk\\AppData\\Roaming\\pgAdmin\\pgadmin4.db' -> 'C:\\Users\\lunuk\\AppData\\Roaming\\pgAdmin\\pgadmin4.db.20230825091858'

Best Regards,,

Bojan Bizjak