Thread: Cannot Open pgAdmin
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
Attachment
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
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'
--------------------------------------------------------
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 MeowCan 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
Hi Meow
Have you upgraded pgAdmin 4? After reviewing the logs, it appears that pgAdmin 4 encounters migration failures.
Could you please take a backup of your 'pgadmin4.db' file and relaunch pgAdmin?
Could you please take a backup of your 'pgadmin4.db' file and relaunch pgAdmin?
On Mon, May 6, 2024 at 6:46 PM Meow <iamspecial19@gmail.com> wrote:
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 WongOn Mon, May 6, 2024 at 1:56 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:Hi MeowCan 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
Hi, I'm unable to open pgAdmin 4 and need guidance on upgrading. Could you kindly provide a list of troubleshooting steps so I can attempt each one to resolve the issue? Thank you.
Regards,
Nikita Wong
On Tue, May 7, 2024 at 8:13 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Hi MeowHave you upgraded pgAdmin 4? After reviewing the logs, it appears that pgAdmin 4 encounters migration failures.
Could you please take a backup of your 'pgadmin4.db' file and relaunch pgAdmin?On Mon, May 6, 2024 at 6:46 PM Meow <iamspecial19@gmail.com> wrote: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 WongOn Mon, May 6, 2024 at 1:56 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:Hi MeowCan 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
On Tue, May 7, 2024 at 9:57 PM Meow <iamspecial19@gmail.com> wrote:
Hi, I'm unable to open pgAdmin 4 and need guidance on upgrading. Could you kindly provide a list of troubleshooting steps so I can attempt each one to resolve the issue? Thank you.Regards,Nikita WongOn Tue, May 7, 2024 at 8:13 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:Hi MeowHave you upgraded pgAdmin 4? After reviewing the logs, it appears that pgAdmin 4 encounters migration failures.
Could you please take a backup of your 'pgadmin4.db' file and relaunch pgAdmin?On Mon, May 6, 2024 at 6:46 PM Meow <iamspecial19@gmail.com> wrote: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 WongOn Mon, May 6, 2024 at 1:56 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:Hi MeowCan 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