Re: Cannot Open pgAdmin

Yes, I can. Below are the logs.

pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\python.exe"
Runtime Config File: "C:\Users\iamsp\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\web\config.py"
Webapp Path: "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\python.exe -s C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py"
Environment:
  - ALLUSERSPROFILE: C:\ProgramData
  - APPDATA: C:\Users\iamsp\AppData\Roaming
  - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_2892_TAPPIXMXWUACYTWL
  - 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: ORANGJAHAT
  - ComSpec: C:\WINDOWS\system32\cmd.exe
  - DriverData: C:\Windows\System32\Drivers\DriverData
  - EFC_12400: 1
  - FPS_BROWSER_APP_PROFILE_STRING: Internet Explorer
  - FPS_BROWSER_USER_PROFILE_STRING: Default
  - HOMEDRIVE: C:
  - HOMEPATH: \Users\iamsp
  - LOCALAPPDATA: C:\Users\iamsp\AppData\Local
  - LOGONSERVER: \\ORANGJAHAT
  - NUMBER_OF_PROCESSORS: 8
  - NVM_HOME: C:\Users\iamsp\AppData\Roaming\nvm
  - NVM_SYMLINK: C:\Program Files\nodejs
  - OneDrive: C:\Users\iamsp\OneDrive
  - OS: Windows_NT
  - Path: C:\Users\iamsp\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;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\Git\cmd;C:\Users\iamsp\AppData\Roaming\nvm;C:\Program Files\nodejs;C:\Users\iamsp\AppData\Local\Programs\Python\Python310\Scripts\;C:\Users\iamsp\AppData\Local\Programs\Python\Python310\;C:\Users\iamsp\AppData\Local\Microsoft\WindowsApps;C:\Users\iamsp\AppData\Local\Box\Box Edit\;C:\Users\iamsp\AppData\Local\Programs\Microsoft VS Code\bin;C:\Users\iamsp\AppData\Local\GitHubDesktop\bin;C:\Users\iamsp\AppData\Roaming\nvm;C:\Program Files\nodejs
  - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
  - PGADMIN_INT_KEY: 16e2a988-da18-4577-99c4-a0df35373aa8
  - PGADMIN_INT_PORT: 5050
  - PGADMIN_SERVER_MODE: OFF
  - PROCESSOR_ARCHITECTURE: AMD64
  - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 142 Stepping 11, GenuineIntel
  - PROCESSOR_LEVEL: 6
  - PROCESSOR_REVISION: 8e0b
  - 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\iamsp\AppData\Local\Temp
  - TMP: C:\Users\iamsp\AppData\Local\Temp
  - USERDOMAIN: ORANGJAHAT
  - USERDOMAIN_ROAMINGPROFILE: ORANGJAHAT
  - USERNAME: iamsp
  - USERPROFILE: C:\Users\iamsp
  - windir: C:\WINDOWS
  - ZES_ENABLE_SYSMAN: 1
--------------------------------------------------------

Total spawn time to start the pgAdmin4 server: 0.022 Sec
2024-05-06 21:08:53,568: ERROR pgadmin: Database migration failed

2024-05-06 21:08:53,768: ERROR pgadmin: Traceback (most recent call last):
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1971, in _exec_single_context
    self.dialect.do_execute(
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\default.py", line 919, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: duplicate column name: shared

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

Traceback (most recent call last):
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 386, in upgrade_db
    db_upgrade(app)
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
    flask_migrate.upgrade(migration_folder)
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped
    f(*args, **kwargs)
  File "C:\Users\iamsp\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\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\command.py", line 403, in upgrade
    script.run_env()
  File "C:\Users\iamsp\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\iamsp\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\iamsp\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\iamsp\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\..\..\migrations\env.py", line 95, in <module>
    run_migrations_online()
  File "C:\Users\iamsp\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\iamsp\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\iamsp\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\iamsp\AppData\Local\Programs\pgAdmin 4\web\migrations\versions\a091c9611d20_.py", line 27, in upgrade
    op.add_column('server', sa.Column('shared', sa.Boolean()))
  File "<string>", line 8, in add_column
  File "<string>", line 3, in add_column
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\operations\ops.py", line 2142, in add_column
    return operations.invoke(op)
           ^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\operations\base.py", line 445, in invoke
    return fn(self, operation)
           ^^^^^^^^^^^^^^^^^^^
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\operations\toimpl.py", line 171, in add_column
    operations.impl.add_column(table_name, column, schema=schema, **kw)
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\ddl\impl.py", line 334, in add_column
    self._exec(base.AddColumn(table_name, column, schema=schema))
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\ddl\impl.py", line 207, in _exec
    return conn.execute(construct, multiparams)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1422, in execute
    return meth(
           ^^^^^
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\ddl.py", line 180, in _execute_on_connection
    return connection._execute_ddl(
           ^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1533, in _execute_ddl
    ret = self._execute_context(
          ^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1850, in _execute_context
    return self._exec_single_context(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1990, in _exec_single_context
    self._handle_dbapi_exception(
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 2357, in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1971, in _exec_single_context
    self.dialect.do_execute(
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\default.py", line 919, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) duplicate column name: shared
[SQL: ALTER TABLE server ADD COLUMN shared BOOLEAN]
(Background on this error at: https://sqlalche.me/e/20/e3q8)


Traceback (most recent call last):
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1971, in _exec_single_context

    self.dialect.do_execute(
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\default.py", line 919, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: duplicate column name: shared

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

Traceback (most recent call last):
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 386, in upgrade_db
    db_upgrade(app)
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
    flask_migrate.upgrade(migration_folder)
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped
    f(*args, **kwargs)
  File "C:\Users\iamsp\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\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\command.py", line 403, in upgrade
    script.run_env()
  File "C:\Users\iamsp\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\iamsp\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\iamsp\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\iamsp\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\..\..\migrations\env.py", line 95, in <module>
    run_migrations_online()
  File "C:\Users\iamsp\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\iamsp\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\iamsp\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\iamsp\AppData\Local\Programs\pgAdmin 4\web\migrations\versions\a091c9611d20_.py", line 27, in upgrade
    op.add_column('server', sa.Column('shared', sa.Boolean()))
  File "<string>", line 8, in add_column
  File "<string>", line 3, in add_column
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\operations\ops.py", line 2142, in add_column
    return operations.invoke(op)
           ^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\operations\base.py", line 445, in invoke
    return fn(self, operation)
           ^^^^^^^^^^^^^^^^^^^
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\operations\toimpl.py", line 171, in add_column
    operations.impl.add_column(table_name, column, schema=schema, **kw)
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\ddl\impl.py", line 334, in add_column
    self._exec(base.AddColumn(table_name, column, schema=schema))
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\ddl\impl.py", line 207, in _exec
    return conn.execute(construct, multiparams)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1422, in execute
    return meth(
           ^^^^^
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\ddl.py", line 180, in _execute_on_connection
    return connection._execute_ddl(
           ^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1533, in _execute_ddl
    ret = self._execute_context(
          ^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1850, in _execute_context
    return self._exec_single_context(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1990, in _exec_single_context
    self._handle_dbapi_exception(
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 2357, in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\base.py", line 1971, in _exec_single_context
    self.dialect.do_execute(
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\default.py", line 919, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) duplicate column name: shared
[SQL: ALTER TABLE server ADD COLUMN shared BOOLEAN]
(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:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py", line 103, in <module>
    app = create_app()
          ^^^^^^^^^^^^
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 473, in create_app
    run_migration_for_sqlite()
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 432, in run_migration_for_sqlite
    upgrade_db()
  File "C:\Users\iamsp\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 391, in upgrade_db
    backup_db_file()
  File "C:\Users\iamsp\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] The process cannot access the file because it is being used by another process: 'C:\\Users\\iamsp\\AppData\\Roaming\\pgAdmin\\pgadmin4.db' -> 'C:\\Users\\iamsp\\AppData\\Roaming\\pgAdmin\\pgadmin4.db.20240506210853'

Regards,

Nikita Wong

On Mon, May 6, 2024 at 1:56 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:

Hi Meow

Can you please scroll down to the "Fatal Error" window and provide the logs? 

On Sun, May 5, 2024 at 1:44 AM Meow <iamspecial19@gmail.com> wrote:

Hi,

After installing pgAdmin 4 v8.6 (released May 2, 2024), upon attempting to open it from my computer, I encountered a fatal error. Kindly refer to the attached video recording for your reference. Could you please help?

Regards,

Nikita Wong