Have you tried the steps that I have asked in my previous email?
On Tue, May 7, 2024 at 9:57 PM Meow <iamspecia...@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 Wong
>
>
> On Tue, May 7, 2024 at 8:13 PM Akshay Joshi <akshay.jo...@enterprisedb.com>
> wrote:
>
>> 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?
>>
>> On Mon, May 6, 2024 at 6:46 PM Meow <iamspecia...@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 Wong
>>>
>>>
>>> On Mon, May 6, 2024 at 1:56 PM Akshay Joshi <
>>> akshay.jo...@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 <iamspecia...@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
>>>>>
>>>>
