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

Sensitivity: C2 Internal
From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Sent: Montag, 8. Juli 2024 11:22
To: Bonafé, Giacomo <giacomo.bonafe@six-group.com>
Cc: pgadmin-support@lists.postgresql.org
Subject: [External Sender] Re: Re: Re: upgrade from version 4.28 to 8.8

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

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.toshniwal@enterprisedb.com>
Sent: Montag, 8. Juli 2024 07:38
To: Bonafé, Giacomo <giacomo.bonafe@six-group.com>
Cc: pgadmin-support@lists.postgresql.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.bonafe@six-group.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.toshniwal@enterprisedb.com>
Sent: Donnerstag, 4. Juli 2024 14:06
To: Bonafé, Giacomo <giacomo.bonafe@six-group.com>
Cc: pgadmin-support@lists.postgresql.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.bonafe@six-group.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

"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

"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.