OK, it looks as though this problem occurs newly in flask-migrate 4.0.6. It looks as though the changes here:
https://github.com/miguelgrinberg/Flask-Migrate/commit/6f3f889c36030134f87dc1db327c2385d873a4d6 introduce some new behaviour which I guess pgadmin4 does not yet support. Can I gently request that the pgadmin4 team look into this further? I am of course happy to test as needed. Thanks, Shaheed On Sun, 10 Mar 2024 at 10:56, Shaheed Haque <shaheedha...@gmail.com> wrote: > 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=x...@123.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=1...@123.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 >
