Re: Re: Re: upgrade from version 4.28 to 8.8

Hi Giacomo,

Then probably you need to remove the
C:\\Users\\Giacomo\\AppData\\Roaming\\pgAdmin
directory. Server configurations will be lost unfortunately.

On Mon, Jul 8, 2024 at 2:01 PM Bonafé, Giacomo <giacomo(dot)bonafe(at)six-group(dot)com>
wrote:

> Hi,
>
>
>
> i dont think so.
>
> I did try to start pgadmin4 8.8 after reboot or after killing any pgadmin
> processes, the log is always the same
>
>
>
> pgAdmin Runtime Environment
>
> --------------------------------------------------------
>
> Python Path: "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\python.exe"
>
> Runtime Config File:
> "C:\Users\Giacomo\AppData\Roaming\pgadmin\runtime_config.json"
>
> pgAdmin Config File: "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\web\config.py"
>
> Webapp Path: "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\web\pgAdmin4.py"
>
> pgAdmin Command: "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\python.exe -s C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\web\pgAdmin4.py"
>
> Environment:
>
> - ALLUSERSPROFILE: C:\ProgramData
>
> - APPDATA: C:\Users\Giacomo\AppData\Roaming
>
> - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_7124_BMZRIYHKKPKHZLQK
>
> - 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: DESKTOP-V5R1KTH
>
> - ComSpec: C:\WINDOWS\system32\cmd.exe
>
> - DriverData: C:\Windows\System32\Drivers\DriverData
>
> - FPS_BROWSER_APP_PROFILE_STRING: Internet Explorer
>
> - FPS_BROWSER_USER_PROFILE_STRING: Default
>
> - HOMEDRIVE: C:
>
> - HOMEPATH: \Users\Giacomo
>
> - LOCALAPPDATA: C:\Users\Giacomo\AppData\Local
>
> - LOGONSERVER: \\DESKTOP-V5R1KTH
>
> - NUMBER_OF_PROCESSORS: 16
>
> - OneDrive: C:\Users\Giacomo\OneDrive
>
> - OS: Windows_NT
>
> - Path: C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\runtime;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Users\Giacomo\AppData\Local\Microsoft\WindowsApps;
>
> - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
>
> - PGADMIN_INT_KEY: fcb10fa9-7b3c-46a6-ae06-4818e72a1f9e
>
> - PGADMIN_INT_PORT: 49859
>
> - PGADMIN_SERVER_MODE: OFF
>
> - PROCESSOR_ARCHITECTURE: AMD64
>
> - PROCESSOR_IDENTIFIER: AMD64 Family 23 Model 8 Stepping 2, AuthenticAMD
>
> - PROCESSOR_LEVEL: 23
>
> - PROCESSOR_REVISION: 0802
>
> - 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;C:\Program
> Files\Intel\Wired Networking\
>
> - PUBLIC: C:\Users\Public
>
> - SESSIONNAME: Console
>
> - SystemDrive: C:
>
> - SystemRoot: C:\WINDOWS
>
> - TEMP: C:\Users\Giacomo\AppData\Local\Temp
>
> - TMP: C:\Users\Giacomo\AppData\Local\Temp
>
> - USERDOMAIN: DESKTOP-V5R1KTH
>
> - USERDOMAIN_ROAMINGPROFILE: DESKTOP-V5R1KTH
>
> - USERNAME: Giacomo
>
> - USERPROFILE: C:\Users\Giacomo
>
> - VBOX_MSI_INSTALL_PATH: C:\Program Files\Oracle\VirtualBox\
>
> - windir: C:\WINDOWS
>
> --------------------------------------------------------
>
>
>
> Total spawn time to start the pgAdmin4 server: 0.007 Sec
>
> 2024-07-08 10:25:23,426: ERROR pgadmin: Database migration failed
>
>
>
> 2024-07-08 10:25:23,436: ERROR pgadmin: Traceback (most recent call last):
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\web\pgadmin\__init__.py", line 386, in upgrade_db
>
> db_upgrade(app)
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
>
> flask_migrate.upgrade(migration_folder)
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped
>
> f(*args, **kwargs)
>
> File "C:\Users\Giacomo\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\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\alembic\command.py", line 403, in upgrade
>
> script.run_env()
>
> File "C:\Users\Giacomo\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\Giacomo\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\Giacomo\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\Giacomo\AppData\Local\Programs\pgAdmin
> 4\web\pgadmin\setup\..\..\migrations\env.py", line 95, in <module>
>
> run_migrations_online()
>
> File "C:\Users\Giacomo\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\Giacomo\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\Giacomo\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\Giacomo\AppData\Local\Programs\pgAdmin
> 4\web\migrations\versions\a39bd015b644_.py", line 26, in upgrade
>
> with op.batch_alter_table("sharedserver") as batch_op:
>
> File "contextlib.py", line 144, in __exit__
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\alembic\operations\base.py", line 398, in
> batch_alter_table
>
> impl.flush()
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\alembic\operations\batch.py", line 142, in flush
>
> existing_table = Table(
>
> ^^^^^^
>
> File "<string>", line 2, in __new__
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\util\deprecations.py", line 281, in
> warned
>
> return fn(*args, **kwargs) # type: ignore[no-any-return]
>
> ^^^^^^^^^^^^^^^^^^^
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 431, in __new__
>
> return cls._new(*args, **kw)
>
> ^^^^^^^^^^^^^^^^^^^^^
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new
>
> with util.safe_reraise():
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in
> __exit__
>
> raise exc_value.with_traceback(exc_tb)
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 481, in _new
>
> table.__init__(name, metadata, *args, _no_init=False, **kw)
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__
>
> self._autoload(
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload
>
> conn_insp.reflect_table(
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1570, in
> reflect_table
>
> self._reflect_fk(
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1768, in
> _reflect_fk
>
> sa_schema.Table(
>
> File "<string>", line 2, in __new__
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\util\deprecations.py", line 281, in
> warned
>
> return fn(*args, **kwargs) # type: ignore[no-any-return]
>
> ^^^^^^^^^^^^^^^^^^^
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 431, in __new__
>
> return cls._new(*args, **kw)
>
> ^^^^^^^^^^^^^^^^^^^^^
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new
>
> with util.safe_reraise():
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in
> __exit__
>
> raise exc_value.with_traceback(exc_tb)
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 481, in _new
>
> table.__init__(name, metadata, *args, _no_init=False, **kw)
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__
>
> self._autoload(
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload
>
> conn_insp.reflect_table(
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1570, in
> reflect_table
>
> self._reflect_fk(
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1768, in
> _reflect_fk
>
> sa_schema.Table(
>
> File "<string>", line 2, in __new__
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\util\deprecations.py", line 281, in
> warned
>
> return fn(*args, **kwargs) # type: ignore[no-any-return]
>
> ^^^^^^^^^^^^^^^^^^^
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 431, in __new__
>
> return cls._new(*args, **kw)
>
> ^^^^^^^^^^^^^^^^^^^^^
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new
>
> with util.safe_reraise():
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in
> __exit__
>
> raise exc_value.with_traceback(exc_tb)
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 481, in _new
>
> table.__init__(name, metadata, *args, _no_init=False, **kw)
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__
>
> self._autoload(
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload
>
> conn_insp.reflect_table(
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1538, in
> reflect_table
>
> raise exc.NoSuchTableError(table_name)
>
> sqlalchemy.exc.NoSuchTableError: user_old
>
>
>
>
>
> Traceback (most recent call last):
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\web\pgadmin\__init__.py", line 386, in upgrade_db
>
> db_upgrade(app)
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
>
> flask_migrate.upgrade(migration_folder)
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped
>
> f(*args, **kwargs)
>
> File "C:\Users\Giacomo\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\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\alembic\command.py", line 403, in upgrade
>
> script.run_env()
>
> File "C:\Users\Giacomo\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\Giacomo\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\Giacomo\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\Giacomo\AppData\Local\Programs\pgAdmin
> 4\web\pgadmin\setup\..\..\migrations\env.py", line 95, in <module>
>
> run_migrations_online()
>
> File "C:\Users\Giacomo\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\Giacomo\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\Giacomo\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\Giacomo\AppData\Local\Programs\pgAdmin
> 4\web\migrations\versions\a39bd015b644_.py", line 26, in upgrade
>
> with op.batch_alter_table("sharedserver") as batch_op:
>
> File "contextlib.py", line 144, in __exit__
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\alembic\operations\base.py", line 398, in
> batch_alter_table
>
> impl.flush()
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\alembic\operations\batch.py", line 142, in flush
>
> existing_table = Table(
>
> ^^^^^^
>
> File "<string>", line 2, in __new__
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\util\deprecations.py", line 281, in
> warned
>
> return fn(*args, **kwargs) # type: ignore[no-any-return]
>
> ^^^^^^^^^^^^^^^^^^^
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 431, in __new__
>
> return cls._new(*args, **kw)
>
> ^^^^^^^^^^^^^^^^^^^^^
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new
>
> with util.safe_reraise():
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in
> __exit__
>
> raise exc_value.with_traceback(exc_tb)
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 481, in _new
>
> table.__init__(name, metadata, *args, _no_init=False, **kw)
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__
>
> self._autoload(
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload
>
> conn_insp.reflect_table(
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1570, in
> reflect_table
>
> self._reflect_fk(
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1768, in
> _reflect_fk
>
> sa_schema.Table(
>
> File "<string>", line 2, in __new__
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\util\deprecations.py", line 281, in
> warned
>
> return fn(*args, **kwargs) # type: ignore[no-any-return]
>
> ^^^^^^^^^^^^^^^^^^^
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 431, in __new__
>
> return cls._new(*args, **kw)
>
> ^^^^^^^^^^^^^^^^^^^^^
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new
>
> with util.safe_reraise():
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in
> __exit__
>
> raise exc_value.with_traceback(exc_tb)
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 481, in _new
>
> table.__init__(name, metadata, *args, _no_init=False, **kw)
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__
>
> self._autoload(
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload
>
> conn_insp.reflect_table(
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1570, in
> reflect_table
>
> self._reflect_fk(
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1768, in
> _reflect_fk
>
> sa_schema.Table(
>
> File "<string>", line 2, in __new__
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\util\deprecations.py", line 281, in
> warned
>
> return fn(*args, **kwargs) # type: ignore[no-any-return]
>
> ^^^^^^^^^^^^^^^^^^^
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 431, in __new__
>
> return cls._new(*args, **kw)
>
> ^^^^^^^^^^^^^^^^^^^^^
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new
>
> with util.safe_reraise():
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in
> __exit__
>
> raise exc_value.with_traceback(exc_tb)
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 481, in _new
>
> table.__init__(name, metadata, *args, _no_init=False, **kw)
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__
>
> self._autoload(
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload
>
> conn_insp.reflect_table(
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1538, in
> reflect_table
>
> raise exc.NoSuchTableError(table_name)
>
> sqlalchemy.exc.NoSuchTableError: user_old
>
>
>
> During handling of the above exception, another exception occurred:
>
>
>
> Traceback (most recent call last):
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\web\pgAdmin4.py", line 103, in <module>
>
> app = create_app()
>
> ^^^^^^^^^^^^
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\web\pgadmin\__init__.py", line 473, in create_app
>
> run_migration_for_sqlite()
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\web\pgadmin\__init__.py", line 432, in run_migration_for_sqlite
>
> upgrade_db()
>
> File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin
> 4\web\pgadmin\__init__.py", line 391, in upgrade_db
>
> backup_db_file()
>
> File "C:\Users\Giacomo\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\\Giacomo\\AppData\\Roaming\\pgAdmin\\pgadmin4.db' ->
> 'C:\\Users\\Giacomo\\AppData\\Roaming\\pgAdmin\\pgadmin4.db.20240708102523'
>
>
>
>
> Sensitivity: C2 Internal
> From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
> *Sent:* Montag, 8. Juli 2024 07:38
> *To:* Bonafé, Giacomo <giacomo(dot)bonafe(at)six-group(dot)com>
> *Cc:* pgadmin-support(at)lists(dot)postgresql(dot)org
> *Subject:* [External Sender] Re: Re: upgrade from version 4.28 to 8.8
>
>
>
> Hi Giacomo,
>
>
>
> Is the db file open in any external SQLLite DB viewer? Or any other
> pgAdmin instance is running? You need stop the usage first.
>
>
>
> On Fri, Jul 5, 2024 at 12:32 PM Bonafé, Giacomo <
> giacomo(dot)bonafe(at)six-group(dot)com> wrote:
>
> Ok i have kept pgadmin.db and the replaced in the directory of my user
>
>
>
> From The error log:
>
>
>
> 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\\<user>
> \\AppData\\Roaming\\pgadmin\\pgadmin4.db' -> 'C:\\Users\\<user>
> \\AppData\\Roaming\\pgadmin\\pgadmin4.db.20240704155404'
>
>
>
> In the pgadmin directory above the pgadmin4.db is saved by the tool with
> name
>
>
>
> pgadmin4.db.prev.bak
>
>
>
> and a new file pgadmin4 is created
>
>
>
>
>
> Sensitivity: C2 Internal
>
> From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
> *Sent:* Donnerstag, 4. Juli 2024 14:06
> *To:* Bonafé, Giacomo <giacomo(dot)bonafe(at)six-group(dot)com>
> *Cc:* pgadmin-support(at)lists(dot)postgresql(dot)org
> *Subject:* [External Sender] Re: upgrade from version 4.28 to 8.8
>
>
>
> Hi Giacomo,
>
>
>
> Keep the backup of the pgadmin.db file and directly upgrade pgAdmin. It
> should work.
>
> If you're facing any issues, share the error details.
>
>
>
> On Thu, Jul 4, 2024 at 4:42 PM Bonafé, Giacomo <
> giacomo(dot)bonafe(at)six-group(dot)com> wrote:
>
> Hello,
>
>
>
> is there a way to upgrade from version 4.28 to version 8.8 ?
>
> I have attempted saving the pgadmin.db file before deleting 4.28 and
> installed 8.8 and then copied the saved pgadmin.db but this does not work
>
>
>
> Is there a solution to this problem ?
>
>
>
> Thanks and regards
>
> Giacomo Bonafe
>
>
>
>
>
> Sensitivity: C2 Internal
>
> The content of this e-mail is intended only for the confidential use of
> the person addressed.
> If you are not the intended recipient, please notify the sender and delete
> this e-mail immediately.
> Thank you.
>
>
>
>
> --
>
> Thanks,
>
> Aditya Toshniwal
>
> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
> <https://www.enterprisedb.com/>
>
> "Don't Complain about Heat, Plant a TREE"
>
> The content of this e-mail is intended only for the confidential use of
> the person addressed.
> If you are not the intended recipient, please notify the sender and delete
> this e-mail immediately.
> Thank you.
>
>
>
>
> --
>
> Thanks,
>
> Aditya Toshniwal
>
> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
> <https://www.enterprisedb.com/>
>
> "Don't Complain about Heat, Plant a TREE"
>
> The content of this e-mail is intended only for the confidential use of
> the person addressed.
> If you are not the intended recipient, please notify the sender and delete
> this e-mail immediately.
> Thank you.
>

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
<https://www.enterprisedb.com/>
"Don't Complain about Heat, Plant a TREE"