Exception trying to install pgadmin4 version 8.4

Hi,

I have a scripted install for pgadmin4 which worked as expected for
pgadmin7.7 when last used. I'm now trying to install 8.4 in a new VM, and
it fails like this:

$ sudo -i -u ubuntu PGADMIN_SETUP_EMAIL=xxx(at)123(dot)com
PGADMIN_SETUP_PASSWORD=abcd python3
/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/setup.py setup-db
2024-03-10 03:13:21,163: ERROR pgadmin: Database migration failed
2024-03-10 03:13:21,164: ERROR pgadmin: Traceback (most recent call
last):
File
"/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/pgadmin/__init__.py",
line 386, in upgrade_db
db_upgrade(app)
File
"/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/pgadmin/setup/db_upgrade.py",
line 22, in db_upgrade
flask_migrate.upgrade(migration_folder)
File
"/home/ubuntu/venv/lib/python3.10/site-packages/flask_migrate/__init__.py",
line 111, in wrapped
f(*args, **kwargs)
File
"/home/ubuntu/venv/lib/python3.10/site-packages/flask_migrate/__init__.py",
line 198, in upgrade
config = current_app.extensions['migrate'].migrate.get_config(directory,
File
"/home/ubuntu/venv/lib/python3.10/site-packages/flask_migrate/__init__.py",
line 96, in get_config
for x in g.x_arg:
File "/home/ubuntu/venv/lib/python3.10/site-packages/flask/ctx.py", line
54, in __getattr__
raise AttributeError(name) from None
AttributeError: x_arg
...
ascii art traceback
...
AttributeError: x_arg

During handling of the above exception, another exception occurred:
...
ascii art traceback
...
FileNotFoundError: [Errno 2] No such file or directory:
'/var/lib/pgadmin/pgadmin4.db' ->
'/var/lib/pgadmin/pgadmin4.db.20240310031321'

Note: the argument "setup-db" was not previously used, but seems required
now. I've enclosed the output of "pip freeze" below. I have verified that
the directory "/var/lib/pgadmin" exists, and is writeable by the user
"ubuntu". In the same directory as setup.py is the following file:

$ cat
/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/config_local.py
LOG_FILE = '/var/log/pgadmin/pgadmin4.log'
SQLITE_PATH = '/var/lib/pgadmin/pgadmin4.db'
SESSION_DB_PATH = '/var/lib/pgadmin/sessions'
STORAGE_DIR = '/var/lib/pgadmin/storage'
AZURE_CREDENTIAL_CACHE_DIR = '/var/lib/pgadmin/azurecredentialcache'
<<< new entry
KERBEROS_CCACHE_DIR = '/var/lib/pgadmin/kerberoscache'
<<< new entry
SERVER_MODE = True

Note: I have highlighted a couple of entries which I added after reading
the current installation documentation. I also tried launching the VM with
the previously working pgadmin4 7.7

$ sudo -i -u ubuntu PGADMIN_SETUP_EMAIL=123(at)123(dot)com
PGADMIN_SETUP_PASSWORD=abcdedg python3
/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/setup.py setup-db
2024-03-10 10:04:24,371: ERROR pgadmin: Database migration failed
2024-03-10 10:04:24,372: ERROR pgadmin: Traceback (most recent call
last):
File
"/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/pgadmin/__init__.py",
line 390, in upgrade_db
db_upgrade(app)
File
"/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/pgadmin/setup/db_upgrade.py",
line 25, in db_upgrade
flask_migrate.upgrade(migration_folder)
File
"/home/ubuntu/venv/lib/python3.10/site-packages/flask_migrate/__init__.py",
line 111, in wrapped
f(*args, **kwargs)
File
"/home/ubuntu/venv/lib/python3.10/site-packages/flask_migrate/__init__.py",
line 198, in upgrade
config = current_app.extensions['migrate'].migrate.get_config(directory,
File
"/home/ubuntu/venv/lib/python3.10/site-packages/flask_migrate/__init__.py",
line 96, in get_config
for x in g.x_arg:
File "/home/ubuntu/venv/lib/python3.10/site-packages/flask/ctx.py", line
52, in __getattr__
raise AttributeError(name) from None
AttributeError: x_arg
Traceback (most recent call last):
File
"/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/pgadmin/__init__.py",
line 390, in upgrade_db
db_upgrade(app)
File
"/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/pgadmin/setup/db_upgrade.py",
line 25, in db_upgrade
flask_migrate.upgrade(migration_folder)
File
"/home/ubuntu/venv/lib/python3.10/site-packages/flask_migrate/__init__.py",
line 111, in wrapped
f(*args, **kwargs)
File
"/home/ubuntu/venv/lib/python3.10/site-packages/flask_migrate/__init__.py",
line 198, in upgrade
config = current_app.extensions['migrate'].migrate.get_config(directory,
File
"/home/ubuntu/venv/lib/python3.10/site-packages/flask_migrate/__init__.py",
line 96, in get_config
for x in g.x_arg:
File "/home/ubuntu/venv/lib/python3.10/site-packages/flask/ctx.py", line
52, in __getattr__
raise AttributeError(name) from None
AttributeError: x_arg
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/setup.py",
line 220, in <module>
app = create_app()
File
"/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/pgadmin/__init__.py",
line 477, in create_app
run_migration_for_sqlite()
File
"/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/pgadmin/__init__.py",
line 414, in run_migration_for_sqlite
upgrade_db()
File
"/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/pgadmin/__init__.py",
line 395, in upgrade_db
backup_db_file()
File
"/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/pgadmin/__init__.py",
line 372, in backup_db_file
os.rename(SQLITE_PATH, backup_file_name)
FileNotFoundError: [Errno 2] No such file or directory:
'/var/lib/pgadmin/pgadmin4.db' ->
'/var/lib/pgadmin/pgadmin4.db.20240310100424'

Note that 7.7 fails in the same way with or without the newly added
"setup-db" argument. Given this pattern, my guess is that flask-migrate or
flask is possibly the issue, rather than pgadmin4, but I have not been able
to debug/confirm that.

Any advice appreciated.

Thanks, Shaheed

Ecls: pip freeze output...

(venv) srhaque-paiyroll-28edd545c2 pip freeze
...
Flask==2.3.3
flask-babel==4.0.0
Flask-Compress==1.14
Flask-Gravatar==0.5.0
Flask-Login==0.6.3
Flask-Mail==0.9.1
Flask-Migrate==4.0.6
Flask-Paranoid==0.3.0
Flask-Principal==0.4.0
Flask-Security-Too==5.3.3
Flask-SocketIO==5.3.6
Flask-SQLAlchemy==3.1.1
Flask-WTF==1.2.1
...
pgadmin4==8.4