PgAdmin Error on startup - Mailing list pgadmin-support

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'