Re: issues with cloned server, centos 9, pgadmin4 8.9 - Mailing list pgadmin-support
From | Aditya Toshniwal |
---|---|
Subject | Re: issues with cloned server, centos 9, pgadmin4 8.9 |
Date | |
Msg-id | CAM9w-_nbiEX2ZvME5xWSEPvWvNyXkPAw+YkkUxSNssH-_FrWvA@mail.gmail.com Whole thread Raw |
In response to | issues with cloned server, centos 9, pgadmin4 8.9 (Petros Mylonopoulos | DigiState <petros@digistate.nl>) |
List | pgadmin-support |
Hi Aditya ,
It does. Mounted the original disk on /mnt and then did “cp /mnt/var/lib/pgadmin/pgadmin4.db /var/lib/pgadmin/pgadmin4.db” which does make the app work now.
Only left with
[Wed Jul 10 14:50:10.029031 2024] [wsgi:error] [pid 57112:tid 57161] [remote xxx. xx.xxx.xxx] werkzeug.exceptions.InternalServerError: 500 Internal Server Error: The user does not have permission to read and write to the specified storage directory.
I know not of the location of the “specified storage directory”.
Met vriendelijke groet,
Petros Mylonopoulos
Betuwehaven 16, 3433PV Nieuwegein
T: +31 (0)30-2074400 |E: petros@digistate.nl | www.digistate.nl
From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Sent: 10 July 2024 14:45
To: Petros Mylonopoulos | DigiState <petros@digistate.nl>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
Subject: Re: issues with cloned server, centos 9, pgadmin4 8.9
Hi Petros,
Like I said, if your original is working fine then you need to copy the pgadmin4.db file also to the destination.
On Wed, Jul 10, 2024 at 5:42 PM Petros Mylonopoulos | DigiState <petros@digistate.nl> wrote:
Hi Aditya ,
It is an exact clone. Or rather, copy in this case, as the cloned version was overwritten about 47 times today by pgadmin’s attempt to migratie something. Still not sure what it’s trying to migrate.
What I’m trying to achieve is to get on the pgadmin website.
Met vriendelijke groet,
Petros Mylonopoulos
Betuwehaven 16, 3433PV Nieuwegein
T: +31 (0)30-2074400 |E: petros@digistate.nl | www.digistate.nl
From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Sent: 10 July 2024 14:07
To: Petros Mylonopoulos | DigiState <petros@digistate.nl>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
Subject: Re: issues with cloned server, centos 9, pgadmin4 8.9
Hi Petros,
The DB file is a newly created one. It asked for an Email address input which means it is not correctly set up before starting.
What are you trying to achieve? If want an exact clone then you'll have to copy the db file to appropriate directory before starting.
On Wed, Jul 10, 2024 at 5:31 PM Petros Mylonopoulos | DigiState <petros@digistate.nl> wrote:
Hi Aditya,
Not only is /var/lib/pgadmin4.db present, there’s also multiple backup copies…
-rw------- 1 apache apache 184320 Jul 10 13:51 /var/lib/pgadmin/pgadmin4.db
-rw-r--r-- 1 apache apache 12288 Jul 10 10:05 /var/lib/pgadmin/pgadmin4.db.20240710100557
-rw-r--r-- 1 apache apache 12288 Jul 10 10:21 /var/lib/pgadmin/pgadmin4.db.20240710102112
-rw-r--r-- 1 apache apache 12288 Jul 10 10:21 /var/lib/pgadmin/pgadmin4.db.20240710102140
-rw-r--r-- 1 apache apache 12288 Jul 10 10:21 /var/lib/pgadmin/pgadmin4.db.20240710104221
-rw-r--r-- 1 apache apache 12288 Jul 10 10:52 /var/lib/pgadmin/pgadmin4.db.20240710105215
-rw-r--r-- 1 apache apache 12288 Jul 10 10:58 /var/lib/pgadmin/pgadmin4.db.20240710105848
-rw-r--r-- 1 apache apache 12288 Jul 10 11:11 /var/lib/pgadmin/pgadmin4.db.20240710111119
-rw-r--r-- 1 apache apache 12288 Jul 10 11:16 /var/lib/pgadmin/pgadmin4.db.20240710111618
-rw-r--r-- 1 apache apache 12288 Jul 10 11:22 /var/lib/pgadmin/pgadmin4.db.20240710112222
-rw-r--r-- 1 apache apache 12288 Jul 10 11:38 /var/lib/pgadmin/pgadmin4.db.20240710113805
-rw-r--r-- 1 apache apache 12288 Jul 10 11:38 /var/lib/pgadmin/pgadmin4.db.20240710114111
-rw-r--r-- 1 apache apache 12288 Jul 10 11:41 /var/lib/pgadmin/pgadmin4.db.20240710114112
-rw-r--r-- 1 apache apache 12288 Jul 10 11:49 /var/lib/pgadmin/pgadmin4.db.20240710114931
-rw-r--r-- 1 apache apache 12288 Jul 10 11:49 /var/lib/pgadmin/pgadmin4.db.20240710125720
-rw-r--r-- 1 apache apache 184320 Jul 10 13:51 /var/lib/pgadmin/pgadmin4.db.prev.bak
Met vriendelijke groet,
Petros Mylonopoulos
Betuwehaven 16, 3433PV Nieuwegein
T: +31 (0)30-2074400 |E: petros@digistate.nl | www.digistate.nl
From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Sent: 10 July 2024 13:48
To: Petros Mylonopoulos | DigiState <petros@digistate.nl>
Cc: pgadmin-support@lists.postgresql.org
Subject: Re: issues with cloned server, centos 9, pgadmin4 8.9
Hi Petros,
Your pgadmin4.db config file is missing. You'll need to clone that as well.
For fresh installation, you will be asked for an initial email id and password and it will create the config db file.
On Wed, Jul 10, 2024 at 4:25 PM Petros Mylonopoulos | DigiState <petros@digistate.nl> wrote:
Hi all,
I recently cloned a server where pgadmin4 8.9 works fine. However, the clone does not. When connecting to the site it takes a few seconds and then it throws an HTTP 500 and a nice white screen.
The website's config is a copy from the original server, which works fine (replaced url with pgadmin.fake.url):
<VirtualHost *:443>
ServerName pgadmin.fake.url
DocumentRoot /usr/pgadmin4/web/
ErrorLog /var/log/httpd/pgadmin-error_log
CustomLog /var/log/httpd/pgadmin-access_log common
LoadModule wsgi_module modules/mod_wsgi.so
WSGIDaemonProcess pgadmin processes=1 threads=25 python-home=/usr/pgadmin4/venv
WSGIScriptAlias / /usr/pgadmin4/web/pgAdmin4.wsgi
<Directory /usr/pgadmin4/web/>
WSGIProcessGroup pgadmin
WSGIApplicationGroup %{GLOBAL}
<IfModule mod_authz_core.c>
<RequireAny>
Require ip w.x.y.z
</RequireAny>
</IfModule>
</Directory>
Include /etc/letsencrypt/options-ssl-apache.conf
SSLCertificateFile /etc/letsencrypt/live/pgadmin.fake.url/fullchain.pem
SSLCertificateKeyFile /etc/letsencrypt/live/pgadmin.fake.url/privkey.pem
</VirtualHost>
The error log is as follows (1 visit only, edited for IP):
[Wed Jul 10 11:41:11.979906 2024] [wsgi:error] [pid 23737:tid 23773] NOTE: Configuring authentication for SERVER mode.
[Wed Jul 10 11:41:11.979977 2024] [wsgi:error] [pid 23737:tid 23773]
[Wed Jul 10 11:41:11.980002 2024] [wsgi:error] [pid 23737:tid 23773] Enter the email address and password to use for the initial pgAdmin user account:
[Wed Jul 10 11:41:11.980008 2024] [wsgi:error] [pid 23737:tid 23773]
[Wed Jul 10 11:41:11.980023 2024] [wsgi:error] [pid 23737:tid 23773] Email address:
[Wed Jul 10 11:41:11.980605 2024] [wsgi:error] [pid 23737:tid 23773] 2024-07-10 11:41:11,980: ERROR\tpgadmin:\tDatabase migration failed
[Wed Jul 10 11:41:11.982641 2024] [wsgi:error] [pid 23737:tid 23773] 2024-07-10 11:41:11,982: ERROR\tpgadmin:\tTraceback (most recent call last):
[Wed Jul 10 11:41:11.982663 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/web/pgadmin/__init__.py", line 386, in upgrade_db
[Wed Jul 10 11:41:11.982669 2024] [wsgi:error] [pid 23737:tid 23773] db_upgrade(app)
[Wed Jul 10 11:41:11.982673 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/web/pgadmin/setup/db_upgrade.py", line 25, in db_upgrade
[Wed Jul 10 11:41:11.982678 2024] [wsgi:error] [pid 23737:tid 23773] flask_migrate.upgrade(migration_folder)
[Wed Jul 10 11:41:11.982684 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/flask_migrate/__init__.py", line 111, in wrapped
[Wed Jul 10 11:41:11.982689 2024] [wsgi:error] [pid 23737:tid 23773] f(*args, **kwargs)
[Wed Jul 10 11:41:11.982694 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/flask_migrate/__init__.py", line 200, in upgrade
[Wed Jul 10 11:41:11.982705 2024] [wsgi:error] [pid 23737:tid 23773] command.upgrade(config, revision, sql=sql, tag=tag)
[Wed Jul 10 11:41:11.982710 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/command.py", line 403, in upgrade
[Wed Jul 10 11:41:11.982715 2024] [wsgi:error] [pid 23737:tid 23773] script.run_env()
[Wed Jul 10 11:41:11.982722 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/script/base.py", line 583, in run_env
[Wed Jul 10 11:41:11.982730 2024] [wsgi:error] [pid 23737:tid 23773] util.load_python_file(self.dir, "env.py")
[Wed Jul 10 11:41:11.982737 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py", line 95, in load_python_file
[Wed Jul 10 11:41:11.982745 2024] [wsgi:error] [pid 23737:tid 23773] module = load_module_py(module_id, path)
[Wed Jul 10 11:41:11.982751 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py", line 113, in load_module_py
[Wed Jul 10 11:41:11.982759 2024] [wsgi:error] [pid 23737:tid 23773] spec.loader.exec_module(module) # type: ignore
[Wed Jul 10 11:41:11.982766 2024] [wsgi:error] [pid 23737:tid 23773] File "", line 850, in exec_module
[Wed Jul 10 11:41:11.982774 2024] [wsgi:error] [pid 23737:tid 23773] File "", line 228, in _call_with_frames_removed
[Wed Jul 10 11:41:11.982781 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 95, in
[Wed Jul 10 11:41:11.982788 2024] [wsgi:error] [pid 23737:tid 23773] run_migrations_online()
[Wed Jul 10 11:41:11.982795 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 87, in run_migrations_online
[Wed Jul 10 11:41:11.982803 2024] [wsgi:error] [pid 23737:tid 23773] context.run_migrations()
[Wed Jul 10 11:41:11.982810 2024] [wsgi:error] [pid 23737:tid 23773] File "", line 8, in run_migrations
[Wed Jul 10 11:41:11.982817 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/runtime/environment.py", line 948, in run_migrations
[Wed Jul 10 11:41:11.982825 2024] [wsgi:error] [pid 23737:tid 23773] self.get_context().run_migrations(**kw)
[Wed Jul 10 11:41:11.982844 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/runtime/migration.py", line 627, in run_migrations
[Wed Jul 10 11:41:11.982855 2024] [wsgi:error] [pid 23737:tid 23773] step.migration_fn(**kw)
[Wed Jul 10 11:41:11.982861 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/web/migrations/versions/fdc58d9bd449_.py", line 38, in upgrade
[Wed Jul 10 11:41:11.982869 2024] [wsgi:error] [pid 23737:tid 23773] email, password = user_info()
[Wed Jul 10 11:41:11.982875 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 75, in user_info
[Wed Jul 10 11:41:11.982883 2024] [wsgi:error] [pid 23737:tid 23773] email, p1 = user_info_server()
[Wed Jul 10 11:41:11.982890 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 52, in user_info_server
[Wed Jul 10 11:41:11.982897 2024] [wsgi:error] [pid 23737:tid 23773] email = input(ENTER_EMAIL_ADDRESS)
[Wed Jul 10 11:41:11.982905 2024] [wsgi:error] [pid 23737:tid 23773] EOFError: EOF when reading a line
[Wed Jul 10 11:41:11.982912 2024] [wsgi:error] [pid 23737:tid 23773]
[Wed Jul 10 11:41:11.983114 2024] [wsgi:error] [pid 23737:tid 23773] 2024-07-10 11:41:11,983: ERROR\tpgadmin:\tException in database migration.
[Wed Jul 10 11:41:12.091699 2024] [wsgi:error] [pid 23737:tid 23773] NOTE: Configuring authentication for SERVER mode.
[Wed Jul 10 11:41:12.091763 2024] [wsgi:error] [pid 23737:tid 23773]
[Wed Jul 10 11:41:12.091787 2024] [wsgi:error] [pid 23737:tid 23773] Enter the email address and password to use for the initial pgAdmin user account:
[Wed Jul 10 11:41:12.091794 2024] [wsgi:error] [pid 23737:tid 23773]
[Wed Jul 10 11:41:12.091810 2024] [wsgi:error] [pid 23737:tid 23773] Email address:
[Wed Jul 10 11:41:12.092775 2024] [wsgi:error] [pid 23737:tid 23773] 2024-07-10 11:41:12,092: ERROR\tpgadmin:\tDatabase migration failed
[Wed Jul 10 11:41:12.093646 2024] [wsgi:error] [pid 23737:tid 23773] 2024-07-10 11:41:12,093: ERROR\tpgadmin:\tTraceback (most recent call last):
[Wed Jul 10 11:41:12.093666 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/web/pgadmin/__init__.py", line 386, in upgrade_db
[Wed Jul 10 11:41:12.093672 2024] [wsgi:error] [pid 23737:tid 23773] db_upgrade(app)
[Wed Jul 10 11:41:12.093677 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/web/pgadmin/setup/db_upgrade.py", line 25, in db_upgrade
[Wed Jul 10 11:41:12.093682 2024] [wsgi:error] [pid 23737:tid 23773] flask_migrate.upgrade(migration_folder)
[Wed Jul 10 11:41:12.093687 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/flask_migrate/__init__.py", line 111, in wrapped
[Wed Jul 10 11:41:12.093692 2024] [wsgi:error] [pid 23737:tid 23773] f(*args, **kwargs)
[Wed Jul 10 11:41:12.093697 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/flask_migrate/__init__.py", line 200, in upgrade
[Wed Jul 10 11:41:12.093702 2024] [wsgi:error] [pid 23737:tid 23773] command.upgrade(config, revision, sql=sql, tag=tag)
[Wed Jul 10 11:41:12.093707 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/command.py", line 403, in upgrade
[Wed Jul 10 11:41:12.093722 2024] [wsgi:error] [pid 23737:tid 23773] script.run_env()
[Wed Jul 10 11:41:12.093726 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/script/base.py", line 583, in run_env
[Wed Jul 10 11:41:12.093731 2024] [wsgi:error] [pid 23737:tid 23773] util.load_python_file(self.dir, "env.py")
[Wed Jul 10 11:41:12.093737 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py", line 95, in load_python_file
[Wed Jul 10 11:41:12.093744 2024] [wsgi:error] [pid 23737:tid 23773] module = load_module_py(module_id, path)
[Wed Jul 10 11:41:12.093757 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py", line 113, in load_module_py
[Wed Jul 10 11:41:12.093764 2024] [wsgi:error] [pid 23737:tid 23773] spec.loader.exec_module(module) # type: ignore
[Wed Jul 10 11:41:12.093771 2024] [wsgi:error] [pid 23737:tid 23773] File "", line 850, in exec_module
[Wed Jul 10 11:41:12.093781 2024] [wsgi:error] [pid 23737:tid 23773] File "", line 228, in _call_with_frames_removed
[Wed Jul 10 11:41:12.093789 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 95, in
[Wed Jul 10 11:41:12.093796 2024] [wsgi:error] [pid 23737:tid 23773] run_migrations_online()
[Wed Jul 10 11:41:12.093803 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 87, in run_migrations_online
[Wed Jul 10 11:41:12.093810 2024] [wsgi:error] [pid 23737:tid 23773] context.run_migrations()
[Wed Jul 10 11:41:12.093817 2024] [wsgi:error] [pid 23737:tid 23773] File "", line 8, in run_migrations
[Wed Jul 10 11:41:12.093824 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/runtime/environment.py", line 948, in run_migrations
[Wed Jul 10 11:41:12.093832 2024] [wsgi:error] [pid 23737:tid 23773] self.get_context().run_migrations(**kw)
[Wed Jul 10 11:41:12.093841 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/runtime/migration.py", line 627, in run_migrations
[Wed Jul 10 11:41:12.093848 2024] [wsgi:error] [pid 23737:tid 23773] step.migration_fn(**kw)
[Wed Jul 10 11:41:12.093855 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/web/migrations/versions/fdc58d9bd449_.py", line 38, in upgrade
[Wed Jul 10 11:41:12.093863 2024] [wsgi:error] [pid 23737:tid 23773] email, password = user_info()
[Wed Jul 10 11:41:12.093870 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 75, in user_info
[Wed Jul 10 11:41:12.093877 2024] [wsgi:error] [pid 23737:tid 23773] email, p1 = user_info_server()
[Wed Jul 10 11:41:12.093885 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 52, in user_info_server
[Wed Jul 10 11:41:12.093892 2024] [wsgi:error] [pid 23737:tid 23773] email = input(ENTER_EMAIL_ADDRESS)
[Wed Jul 10 11:41:12.093901 2024] [wsgi:error] [pid 23737:tid 23773] EOFError: EOF when reading a line
[Wed Jul 10 11:41:12.093909 2024] [wsgi:error] [pid 23737:tid 23773]
[Wed Jul 10 11:41:12.093916 2024] [wsgi:error] [pid 23737:tid 23773] During handling of the above exception, another exception occurred:
[Wed Jul 10 11:41:12.093924 2024] [wsgi:error] [pid 23737:tid 23773]
[Wed Jul 10 11:41:12.093932 2024] [wsgi:error] [pid 23737:tid 23773] Traceback (most recent call last):
[Wed Jul 10 11:41:12.093940 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/web/pgadmin/__init__.py", line 372, in backup_db_file
[Wed Jul 10 11:41:12.093948 2024] [wsgi:error] [pid 23737:tid 23773] db_upgrade(app)
[Wed Jul 10 11:41:12.093955 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/web/pgadmin/setup/db_upgrade.py", line 25, in db_upgrade
[Wed Jul 10 11:41:12.093963 2024] [wsgi:error] [pid 23737:tid 23773] flask_migrate.upgrade(migration_folder)
[Wed Jul 10 11:41:12.093971 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/flask_migrate/__init__.py", line 111, in wrapped
[Wed Jul 10 11:41:12.093978 2024] [wsgi:error] [pid 23737:tid 23773] f(*args, **kwargs)
[Wed Jul 10 11:41:12.093986 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/flask_migrate/__init__.py", line 200, in upgrade
[Wed Jul 10 11:41:12.093993 2024] [wsgi:error] [pid 23737:tid 23773] command.upgrade(config, revision, sql=sql, tag=tag)
[Wed Jul 10 11:41:12.094008 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/command.py", line 403, in upgrade
[Wed Jul 10 11:41:12.094019 2024] [wsgi:error] [pid 23737:tid 23773] script.run_env()
[Wed Jul 10 11:41:12.094024 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/script/base.py", line 583, in run_env
[Wed Jul 10 11:41:12.094029 2024] [wsgi:error] [pid 23737:tid 23773] util.load_python_file(self.dir, "env.py")
[Wed Jul 10 11:41:12.094036 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py", line 95, in load_python_file
[Wed Jul 10 11:41:12.094044 2024] [wsgi:error] [pid 23737:tid 23773] module = load_module_py(module_id, path)
[Wed Jul 10 11:41:12.094052 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py", line 113, in load_module_py
[Wed Jul 10 11:41:12.094059 2024] [wsgi:error] [pid 23737:tid 23773] spec.loader.exec_module(module) # type: ignore
[Wed Jul 10 11:41:12.094066 2024] [wsgi:error] [pid 23737:tid 23773] File "", line 850, in exec_module
[Wed Jul 10 11:41:12.094073 2024] [wsgi:error] [pid 23737:tid 23773] File "", line 228, in _call_with_frames_removed
[Wed Jul 10 11:41:12.094079 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 95, in
[Wed Jul 10 11:41:12.094086 2024] [wsgi:error] [pid 23737:tid 23773] run_migrations_online()
[Wed Jul 10 11:41:12.094093 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 87, in run_migrations_online
[Wed Jul 10 11:41:12.094100 2024] [wsgi:error] [pid 23737:tid 23773] context.run_migrations()
[Wed Jul 10 11:41:12.094106 2024] [wsgi:error] [pid 23737:tid 23773] File "", line 8, in run_migrations
[Wed Jul 10 11:41:12.094113 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/runtime/environment.py", line 948, in run_migrations
[Wed Jul 10 11:41:12.094121 2024] [wsgi:error] [pid 23737:tid 23773] self.get_context().run_migrations(**kw)
[Wed Jul 10 11:41:12.094129 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/runtime/migration.py", line 627, in run_migrations
[Wed Jul 10 11:41:12.094138 2024] [wsgi:error] [pid 23737:tid 23773] step.migration_fn(**kw)
[Wed Jul 10 11:41:12.094144 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/web/migrations/versions/fdc58d9bd449_.py", line 38, in upgrade
[Wed Jul 10 11:41:12.094180 2024] [wsgi:error] [pid 23737:tid 23773] email, password = user_info()
[Wed Jul 10 11:41:12.094186 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 75, in user_info
[Wed Jul 10 11:41:12.094209 2024] [wsgi:error] [pid 23737:tid 23773] email, p1 = user_info_server()
[Wed Jul 10 11:41:12.094224 2024] [wsgi:error] [pid 23737:tid 23773] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 52, in user_info_server
[Wed Jul 10 11:41:12.094231 2024] [wsgi:error] [pid 23737:tid 23773] email = input(ENTER_EMAIL_ADDRESS)
[Wed Jul 10 11:41:12.094238 2024] [wsgi:error] [pid 23737:tid 23773] EOFError: EOF when reading a line
[Wed Jul 10 11:41:12.094245 2024] [wsgi:error] [pid 23737:tid 23773]
[Wed Jul 10 11:41:12.094417 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] mod_wsgi (pid=23737): Failed to exec Python script file '/usr/pgadmin4/web/pgAdmin4.wsgi'.
[Wed Jul 10 11:41:12.094454 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] mod_wsgi (pid=23737): Exception occurred processing WSGI script '/usr/pgadmin4/web/pgAdmin4.wsgi'.
[Wed Jul 10 11:41:12.095019 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] Traceback (most recent call last):
[Wed Jul 10 11:41:12.095100 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/web/pgadmin/__init__.py", line 386, in upgrade_db
[Wed Jul 10 11:41:12.095114 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] db_upgrade(app)
[Wed Jul 10 11:41:12.095127 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/web/pgadmin/setup/db_upgrade.py", line 25, in db_upgrade
[Wed Jul 10 11:41:12.095135 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] flask_migrate.upgrade(migration_folder)
[Wed Jul 10 11:41:12.095144 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/flask_migrate/__init__.py", line 111, in wrapped
[Wed Jul 10 11:41:12.095181 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] f(*args, **kwargs)
[Wed Jul 10 11:41:12.095203 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/flask_migrate/__init__.py", line 200, in upgrade
[Wed Jul 10 11:41:12.095216 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] command.upgrade(config, revision, sql=sql, tag=tag)
[Wed Jul 10 11:41:12.095228 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/command.py", line 403, in upgrade
[Wed Jul 10 11:41:12.095242 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] script.run_env()
[Wed Jul 10 11:41:12.095255 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/script/base.py", line 583, in run_env
[Wed Jul 10 11:41:12.095263 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] util.load_python_file(self.dir, "env.py")
[Wed Jul 10 11:41:12.095274 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py", line 95, in load_python_file
[Wed Jul 10 11:41:12.095282 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] module = load_module_py(module_id, path)
[Wed Jul 10 11:41:12.095293 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py", line 113, in load_module_py
[Wed Jul 10 11:41:12.095302 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] spec.loader.exec_module(module) # type: ignore
[Wed Jul 10 11:41:12.095314 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "", line 850, in exec_module
[Wed Jul 10 11:41:12.095327 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "", line 228, in _call_with_frames_removed
[Wed Jul 10 11:41:12.095338 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 95, in
[Wed Jul 10 11:41:12.095347 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] run_migrations_online()
[Wed Jul 10 11:41:12.095359 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 87, in run_migrations_online
[Wed Jul 10 11:41:12.095369 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] context.run_migrations()
[Wed Jul 10 11:41:12.095380 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "", line 8, in run_migrations
[Wed Jul 10 11:41:12.095391 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/runtime/environment.py", line 948, in run_migrations
[Wed Jul 10 11:41:12.095406 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] self.get_context().run_migrations(**kw)
[Wed Jul 10 11:41:12.095416 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/runtime/migration.py", line 627, in run_migrations
[Wed Jul 10 11:41:12.095424 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] step.migration_fn(**kw)
[Wed Jul 10 11:41:12.095434 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/web/migrations/versions/fdc58d9bd449_.py", line 38, in upgrade
[Wed Jul 10 11:41:12.095442 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] email, password = user_info()
[Wed Jul 10 11:41:12.095453 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 75, in user_info
[Wed Jul 10 11:41:12.095461 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] email, p1 = user_info_server()
[Wed Jul 10 11:41:12.095472 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 52, in user_info_server
[Wed Jul 10 11:41:12.095482 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] email = input(ENTER_EMAIL_ADDRESS)
[Wed Jul 10 11:41:12.095503 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] EOFError: EOF when reading a line
[Wed Jul 10 11:41:12.095517 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025]
[Wed Jul 10 11:41:12.095526 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] During handling of the above exception, another exception occurred:
[Wed Jul 10 11:41:12.095534 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025]
[Wed Jul 10 11:41:12.095547 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] Traceback (most recent call last):
[Wed Jul 10 11:41:12.095627 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/web/pgadmin/__init__.py", line 372, in backup_db_file
[Wed Jul 10 11:41:12.095635 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] db_upgrade(app)
[Wed Jul 10 11:41:12.095642 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/web/pgadmin/setup/db_upgrade.py", line 25, in db_upgrade
[Wed Jul 10 11:41:12.095647 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] flask_migrate.upgrade(migration_folder)
[Wed Jul 10 11:41:12.095653 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/flask_migrate/__init__.py", line 111, in wrapped
[Wed Jul 10 11:41:12.095659 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] f(*args, **kwargs)
[Wed Jul 10 11:41:12.095697 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/flask_migrate/__init__.py", line 200, in upgrade
[Wed Jul 10 11:41:12.095708 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] command.upgrade(config, revision, sql=sql, tag=tag)
[Wed Jul 10 11:41:12.095717 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/command.py", line 403, in upgrade
[Wed Jul 10 11:41:12.095731 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] script.run_env()
[Wed Jul 10 11:41:12.095767 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/script/base.py", line 583, in run_env
[Wed Jul 10 11:41:12.095775 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] util.load_python_file(self.dir, "env.py")
[Wed Jul 10 11:41:12.095787 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py", line 95, in load_python_file
[Wed Jul 10 11:41:12.095802 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] module = load_module_py(module_id, path)
[Wed Jul 10 11:41:12.095813 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py", line 113, in load_module_py
[Wed Jul 10 11:41:12.095823 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] spec.loader.exec_module(module) # type: ignore
[Wed Jul 10 11:41:12.095833 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "", line 850, in exec_module
[Wed Jul 10 11:41:12.095844 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "", line 228, in _call_with_frames_removed
[Wed Jul 10 11:41:12.095856 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 95, in
[Wed Jul 10 11:41:12.095865 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] run_migrations_online()
[Wed Jul 10 11:41:12.095876 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 87, in run_migrations_online
[Wed Jul 10 11:41:12.095885 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] context.run_migrations()
[Wed Jul 10 11:41:12.095896 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "", line 8, in run_migrations
[Wed Jul 10 11:41:12.095907 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/runtime/environment.py", line 948, in run_migrations
[Wed Jul 10 11:41:12.095916 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] self.get_context().run_migrations(**kw)
[Wed Jul 10 11:41:12.095928 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/runtime/migration.py", line 627, in run_migrations
[Wed Jul 10 11:41:12.095937 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] step.migration_fn(**kw)
[Wed Jul 10 11:41:12.095949 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/web/migrations/versions/fdc58d9bd449_.py", line 38, in upgrade
[Wed Jul 10 11:41:12.095956 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] email, password = user_info()
[Wed Jul 10 11:41:12.095967 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 75, in user_info
[Wed Jul 10 11:41:12.095975 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] email, p1 = user_info_server()
[Wed Jul 10 11:41:12.096075 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 52, in user_info_server
[Wed Jul 10 11:41:12.096082 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] email = input(ENTER_EMAIL_ADDRESS)
[Wed Jul 10 11:41:12.096096 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] EOFError: EOF when reading a line
[Wed Jul 10 11:41:12.096103 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025]
[Wed Jul 10 11:41:12.096110 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] During handling of the above exception, another exception occurred:
[Wed Jul 10 11:41:12.096117 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025]
[Wed Jul 10 11:41:12.096128 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] Traceback (most recent call last):
[Wed Jul 10 11:41:12.096221 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/web/pgAdmin4.wsgi", line 36, in
[Wed Jul 10 11:41:12.096236 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] from pgAdmin4 import app as application
[Wed Jul 10 11:41:12.096248 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/web/pgAdmin4.py", line 103, in
[Wed Jul 10 11:41:12.096257 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] app = create_app()
[Wed Jul 10 11:41:12.096269 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/web/pgadmin/__init__.py", line 473, in create_app
[Wed Jul 10 11:41:12.096278 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] run_migration_for_sqlite()
[Wed Jul 10 11:41:12.096289 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/web/pgadmin/__init__.py", line 410, in run_migration_for_sqlite
[Wed Jul 10 11:41:12.096297 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] upgrade_db()
[Wed Jul 10 11:41:12.096308 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/web/pgadmin/__init__.py", line 391, in upgrade_db
[Wed Jul 10 11:41:12.096316 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] backup_db_file()
[Wed Jul 10 11:41:12.096326 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] File "/usr/pgadmin4/web/pgadmin/__init__.py", line 379, in backup_db_file
[Wed Jul 10 11:41:12.096334 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] raise RuntimeError('Migration failed')
[Wed Jul 10 11:41:12.096352 2024] [wsgi:error] [pid 23737:tid 23773] [remote xxx.xxx.xx.xxx:58025] RuntimeError: Migration failed
[Wed Jul 10 11:41:12.209849 2024] [wsgi:error] [pid 23737:tid 23786] NOTE: Configuring authentication for SERVER mode.
[Wed Jul 10 11:41:12.209897 2024] [wsgi:error] [pid 23737:tid 23786]
[Wed Jul 10 11:41:12.209920 2024] [wsgi:error] [pid 23737:tid 23786] Enter the email address and password to use for the initial pgAdmin user account:
[Wed Jul 10 11:41:12.209927 2024] [wsgi:error] [pid 23737:tid 23786]
[Wed Jul 10 11:41:12.209939 2024] [wsgi:error] [pid 23737:tid 23786] Email address:
[Wed Jul 10 11:41:12.210492 2024] [wsgi:error] [pid 23737:tid 23786] 2024-07-10 11:41:12,210: ERROR\tpgadmin:\tDatabase migration failed
[Wed Jul 10 11:41:12.210906 2024] [wsgi:error] [pid 23737:tid 23786] 2024-07-10 11:41:12,210: ERROR\tpgadmin:\tTraceback (most recent call last):
[Wed Jul 10 11:41:12.210920 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/web/pgadmin/__init__.py", line 386, in upgrade_db
[Wed Jul 10 11:41:12.210926 2024] [wsgi:error] [pid 23737:tid 23786] db_upgrade(app)
[Wed Jul 10 11:41:12.210931 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/web/pgadmin/setup/db_upgrade.py", line 25, in db_upgrade
[Wed Jul 10 11:41:12.210936 2024] [wsgi:error] [pid 23737:tid 23786] flask_migrate.upgrade(migration_folder)
[Wed Jul 10 11:41:12.210941 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/flask_migrate/__init__.py", line 111, in wrapped
[Wed Jul 10 11:41:12.210946 2024] [wsgi:error] [pid 23737:tid 23786] f(*args, **kwargs)
[Wed Jul 10 11:41:12.210952 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/flask_migrate/__init__.py", line 200, in upgrade
[Wed Jul 10 11:41:12.210957 2024] [wsgi:error] [pid 23737:tid 23786] command.upgrade(config, revision, sql=sql, tag=tag)
[Wed Jul 10 11:41:12.210967 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/command.py", line 403, in upgrade
[Wed Jul 10 11:41:12.210974 2024] [wsgi:error] [pid 23737:tid 23786] script.run_env()
[Wed Jul 10 11:41:12.210981 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/script/base.py", line 583, in run_env
[Wed Jul 10 11:41:12.211003 2024] [wsgi:error] [pid 23737:tid 23786] util.load_python_file(self.dir, "env.py")
[Wed Jul 10 11:41:12.211020 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py", line 95, in load_python_file
[Wed Jul 10 11:41:12.211030 2024] [wsgi:error] [pid 23737:tid 23786] module = load_module_py(module_id, path)
[Wed Jul 10 11:41:12.211038 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py", line 113, in load_module_py
[Wed Jul 10 11:41:12.211047 2024] [wsgi:error] [pid 23737:tid 23786] spec.loader.exec_module(module) # type: ignore
[Wed Jul 10 11:41:12.211054 2024] [wsgi:error] [pid 23737:tid 23786] File "", line 850, in exec_module
[Wed Jul 10 11:41:12.211062 2024] [wsgi:error] [pid 23737:tid 23786] File "", line 228, in _call_with_frames_removed
[Wed Jul 10 11:41:12.211069 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 95, in
[Wed Jul 10 11:41:12.211091 2024] [wsgi:error] [pid 23737:tid 23786] run_migrations_online()
[Wed Jul 10 11:41:12.211105 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 87, in run_migrations_online
[Wed Jul 10 11:41:12.211112 2024] [wsgi:error] [pid 23737:tid 23786] context.run_migrations()
[Wed Jul 10 11:41:12.211119 2024] [wsgi:error] [pid 23737:tid 23786] File "", line 8, in run_migrations
[Wed Jul 10 11:41:12.211177 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/runtime/environment.py", line 948, in run_migrations
[Wed Jul 10 11:41:12.211185 2024] [wsgi:error] [pid 23737:tid 23786] self.get_context().run_migrations(**kw)
[Wed Jul 10 11:41:12.211202 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/runtime/migration.py", line 627, in run_migrations
[Wed Jul 10 11:41:12.211214 2024] [wsgi:error] [pid 23737:tid 23786] step.migration_fn(**kw)
[Wed Jul 10 11:41:12.211221 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/web/migrations/versions/fdc58d9bd449_.py", line 38, in upgrade
[Wed Jul 10 11:41:12.211228 2024] [wsgi:error] [pid 23737:tid 23786] email, password = user_info()
[Wed Jul 10 11:41:12.211235 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 75, in user_info
[Wed Jul 10 11:41:12.211247 2024] [wsgi:error] [pid 23737:tid 23786] email, p1 = user_info_server()
[Wed Jul 10 11:41:12.211254 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 52, in user_info_server
[Wed Jul 10 11:41:12.211262 2024] [wsgi:error] [pid 23737:tid 23786] email = input(ENTER_EMAIL_ADDRESS)
[Wed Jul 10 11:41:12.211268 2024] [wsgi:error] [pid 23737:tid 23786] EOFError: EOF when reading a line
[Wed Jul 10 11:41:12.211275 2024] [wsgi:error] [pid 23737:tid 23786]
[Wed Jul 10 11:41:12.211614 2024] [wsgi:error] [pid 23737:tid 23786] 2024-07-10 11:41:12,211: ERROR\tpgadmin:\tException in database migration.
[Wed Jul 10 11:41:12.245788 2024] [wsgi:error] [pid 23737:tid 23786] NOTE: Configuring authentication for SERVER mode.
[Wed Jul 10 11:41:12.245840 2024] [wsgi:error] [pid 23737:tid 23786]
[Wed Jul 10 11:41:12.245872 2024] [wsgi:error] [pid 23737:tid 23786] Enter the email address and password to use for the initial pgAdmin user account:
[Wed Jul 10 11:41:12.245884 2024] [wsgi:error] [pid 23737:tid 23786]
[Wed Jul 10 11:41:12.245905 2024] [wsgi:error] [pid 23737:tid 23786] Email address:
[Wed Jul 10 11:41:12.246431 2024] [wsgi:error] [pid 23737:tid 23786] 2024-07-10 11:41:12,246: ERROR\tpgadmin:\tDatabase migration failed
[Wed Jul 10 11:41:12.247067 2024] [wsgi:error] [pid 23737:tid 23786] 2024-07-10 11:41:12,246: ERROR\tpgadmin:\tTraceback (most recent call last):
[Wed Jul 10 11:41:12.247087 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/web/pgadmin/__init__.py", line 386, in upgrade_db
[Wed Jul 10 11:41:12.247096 2024] [wsgi:error] [pid 23737:tid 23786] db_upgrade(app)
[Wed Jul 10 11:41:12.247102 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/web/pgadmin/setup/db_upgrade.py", line 25, in db_upgrade
[Wed Jul 10 11:41:12.247110 2024] [wsgi:error] [pid 23737:tid 23786] flask_migrate.upgrade(migration_folder)
[Wed Jul 10 11:41:12.247118 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/flask_migrate/__init__.py", line 111, in wrapped
[Wed Jul 10 11:41:12.247126 2024] [wsgi:error] [pid 23737:tid 23786] f(*args, **kwargs)
[Wed Jul 10 11:41:12.247133 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/flask_migrate/__init__.py", line 200, in upgrade
[Wed Jul 10 11:41:12.247171 2024] [wsgi:error] [pid 23737:tid 23786] command.upgrade(config, revision, sql=sql, tag=tag)
[Wed Jul 10 11:41:12.247182 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/command.py", line 403, in upgrade
[Wed Jul 10 11:41:12.247210 2024] [wsgi:error] [pid 23737:tid 23786] script.run_env()
[Wed Jul 10 11:41:12.247225 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/script/base.py", line 583, in run_env
[Wed Jul 10 11:41:12.247234 2024] [wsgi:error] [pid 23737:tid 23786] util.load_python_file(self.dir, "env.py")
[Wed Jul 10 11:41:12.247242 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py", line 95, in load_python_file
[Wed Jul 10 11:41:12.247250 2024] [wsgi:error] [pid 23737:tid 23786] module = load_module_py(module_id, path)
[Wed Jul 10 11:41:12.247266 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py", line 113, in load_module_py
[Wed Jul 10 11:41:12.247284 2024] [wsgi:error] [pid 23737:tid 23786] spec.loader.exec_module(module) # type: ignore
[Wed Jul 10 11:41:12.247289 2024] [wsgi:error] [pid 23737:tid 23786] File "", line 850, in exec_module
[Wed Jul 10 11:41:12.247294 2024] [wsgi:error] [pid 23737:tid 23786] File "", line 228, in _call_with_frames_removed
[Wed Jul 10 11:41:12.247299 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 95, in
[Wed Jul 10 11:41:12.247305 2024] [wsgi:error] [pid 23737:tid 23786] run_migrations_online()
[Wed Jul 10 11:41:12.247313 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 87, in run_migrations_online
[Wed Jul 10 11:41:12.247320 2024] [wsgi:error] [pid 23737:tid 23786] context.run_migrations()
[Wed Jul 10 11:41:12.247327 2024] [wsgi:error] [pid 23737:tid 23786] File "", line 8, in run_migrations
[Wed Jul 10 11:41:12.247334 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/runtime/environment.py", line 948, in run_migrations
[Wed Jul 10 11:41:12.247342 2024] [wsgi:error] [pid 23737:tid 23786] self.get_context().run_migrations(**kw)
[Wed Jul 10 11:41:12.247358 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/runtime/migration.py", line 627, in run_migrations
[Wed Jul 10 11:41:12.247366 2024] [wsgi:error] [pid 23737:tid 23786] step.migration_fn(**kw)
[Wed Jul 10 11:41:12.247373 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/web/migrations/versions/fdc58d9bd449_.py", line 38, in upgrade
[Wed Jul 10 11:41:12.247381 2024] [wsgi:error] [pid 23737:tid 23786] email, password = user_info()
[Wed Jul 10 11:41:12.247388 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 75, in user_info
[Wed Jul 10 11:41:12.247405 2024] [wsgi:error] [pid 23737:tid 23786] email, p1 = user_info_server()
[Wed Jul 10 11:41:12.247417 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 52, in user_info_server
[Wed Jul 10 11:41:12.247424 2024] [wsgi:error] [pid 23737:tid 23786] email = input(ENTER_EMAIL_ADDRESS)
[Wed Jul 10 11:41:12.247432 2024] [wsgi:error] [pid 23737:tid 23786] EOFError: EOF when reading a line
[Wed Jul 10 11:41:12.247439 2024] [wsgi:error] [pid 23737:tid 23786]
[Wed Jul 10 11:41:12.247447 2024] [wsgi:error] [pid 23737:tid 23786] During handling of the above exception, another exception occurred:
[Wed Jul 10 11:41:12.247454 2024] [wsgi:error] [pid 23737:tid 23786]
[Wed Jul 10 11:41:12.247462 2024] [wsgi:error] [pid 23737:tid 23786] Traceback (most recent call last):
[Wed Jul 10 11:41:12.247470 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/web/pgadmin/__init__.py", line 372, in backup_db_file
[Wed Jul 10 11:41:12.247477 2024] [wsgi:error] [pid 23737:tid 23786] db_upgrade(app)
[Wed Jul 10 11:41:12.247485 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/web/pgadmin/setup/db_upgrade.py", line 25, in db_upgrade
[Wed Jul 10 11:41:12.247492 2024] [wsgi:error] [pid 23737:tid 23786] flask_migrate.upgrade(migration_folder)
[Wed Jul 10 11:41:12.247500 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/flask_migrate/__init__.py", line 111, in wrapped
[Wed Jul 10 11:41:12.247508 2024] [wsgi:error] [pid 23737:tid 23786] f(*args, **kwargs)
[Wed Jul 10 11:41:12.247515 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/flask_migrate/__init__.py", line 200, in upgrade
[Wed Jul 10 11:41:12.247523 2024] [wsgi:error] [pid 23737:tid 23786] command.upgrade(config, revision, sql=sql, tag=tag)
[Wed Jul 10 11:41:12.247532 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/command.py", line 403, in upgrade
[Wed Jul 10 11:41:12.247539 2024] [wsgi:error] [pid 23737:tid 23786] script.run_env()
[Wed Jul 10 11:41:12.247547 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/script/base.py", line 583, in run_env
[Wed Jul 10 11:41:12.247557 2024] [wsgi:error] [pid 23737:tid 23786] util.load_python_file(self.dir, "env.py")
[Wed Jul 10 11:41:12.247565 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py", line 95, in load_python_file
[Wed Jul 10 11:41:12.247573 2024] [wsgi:error] [pid 23737:tid 23786] module = load_module_py(module_id, path)
[Wed Jul 10 11:41:12.247581 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py", line 113, in load_module_py
[Wed Jul 10 11:41:12.247589 2024] [wsgi:error] [pid 23737:tid 23786] spec.loader.exec_module(module) # type: ignore
[Wed Jul 10 11:41:12.247596 2024] [wsgi:error] [pid 23737:tid 23786] File "", line 850, in exec_module
[Wed Jul 10 11:41:12.247604 2024] [wsgi:error] [pid 23737:tid 23786] File "", line 228, in _call_with_frames_removed
[Wed Jul 10 11:41:12.247612 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 95, in
[Wed Jul 10 11:41:12.247619 2024] [wsgi:error] [pid 23737:tid 23786] run_migrations_online()
[Wed Jul 10 11:41:12.247627 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 87, in run_migrations_online
[Wed Jul 10 11:41:12.247634 2024] [wsgi:error] [pid 23737:tid 23786] context.run_migrations()
[Wed Jul 10 11:41:12.247642 2024] [wsgi:error] [pid 23737:tid 23786] File "", line 8, in run_migrations
[Wed Jul 10 11:41:12.247650 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/runtime/environment.py", line 948, in run_migrations
[Wed Jul 10 11:41:12.247664 2024] [wsgi:error] [pid 23737:tid 23786] self.get_context().run_migrations(**kw)
[Wed Jul 10 11:41:12.247675 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/runtime/migration.py", line 627, in run_migrations
[Wed Jul 10 11:41:12.247683 2024] [wsgi:error] [pid 23737:tid 23786] step.migration_fn(**kw)
[Wed Jul 10 11:41:12.247691 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/web/migrations/versions/fdc58d9bd449_.py", line 38, in upgrade
[Wed Jul 10 11:41:12.247698 2024] [wsgi:error] [pid 23737:tid 23786] email, password = user_info()
[Wed Jul 10 11:41:12.247709 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 75, in user_info
[Wed Jul 10 11:41:12.247720 2024] [wsgi:error] [pid 23737:tid 23786] email, p1 = user_info_server()
[Wed Jul 10 11:41:12.247728 2024] [wsgi:error] [pid 23737:tid 23786] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 52, in user_info_server
[Wed Jul 10 11:41:12.247735 2024] [wsgi:error] [pid 23737:tid 23786] email = input(ENTER_EMAIL_ADDRESS)
[Wed Jul 10 11:41:12.247743 2024] [wsgi:error] [pid 23737:tid 23786] EOFError: EOF when reading a line
[Wed Jul 10 11:41:12.247750 2024] [wsgi:error] [pid 23737:tid 23786]
[Wed Jul 10 11:41:12.247906 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] mod_wsgi (pid=23737): Failed to exec Python script file '/usr/pgadmin4/web/pgAdmin4.wsgi'.
[Wed Jul 10 11:41:12.247949 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] mod_wsgi (pid=23737): Exception occurred processing WSGI script '/usr/pgadmin4/web/pgAdmin4.wsgi'.
[Wed Jul 10 11:41:12.248370 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] Traceback (most recent call last):
[Wed Jul 10 11:41:12.248455 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/web/pgadmin/__init__.py", line 386, in upgrade_db
[Wed Jul 10 11:41:12.248466 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] db_upgrade(app)
[Wed Jul 10 11:41:12.248479 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/web/pgadmin/setup/db_upgrade.py", line 25, in db_upgrade
[Wed Jul 10 11:41:12.248487 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] flask_migrate.upgrade(migration_folder)
[Wed Jul 10 11:41:12.248500 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/flask_migrate/__init__.py", line 111, in wrapped
[Wed Jul 10 11:41:12.248508 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] f(*args, **kwargs)
[Wed Jul 10 11:41:12.248519 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/flask_migrate/__init__.py", line 200, in upgrade
[Wed Jul 10 11:41:12.248529 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] command.upgrade(config, revision, sql=sql, tag=tag)
[Wed Jul 10 11:41:12.248541 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/command.py", line 403, in upgrade
[Wed Jul 10 11:41:12.248551 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] script.run_env()
[Wed Jul 10 11:41:12.248563 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/script/base.py", line 583, in run_env
[Wed Jul 10 11:41:12.248572 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] util.load_python_file(self.dir, "env.py")
[Wed Jul 10 11:41:12.248586 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py", line 95, in load_python_file
[Wed Jul 10 11:41:12.248606 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] module = load_module_py(module_id, path)
[Wed Jul 10 11:41:12.248679 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py", line 113, in load_module_py
[Wed Jul 10 11:41:12.248689 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] spec.loader.exec_module(module) # type: ignore
[Wed Jul 10 11:41:12.248702 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "", line 850, in exec_module
[Wed Jul 10 11:41:12.248713 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "", line 228, in _call_with_frames_removed
[Wed Jul 10 11:41:12.248727 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 95, in
[Wed Jul 10 11:41:12.248736 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] run_migrations_online()
[Wed Jul 10 11:41:12.248749 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 87, in run_migrations_online
[Wed Jul 10 11:41:12.248758 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] context.run_migrations()
[Wed Jul 10 11:41:12.248771 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "", line 8, in run_migrations
[Wed Jul 10 11:41:12.248783 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/runtime/environment.py", line 948, in run_migrations
[Wed Jul 10 11:41:12.248793 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] self.get_context().run_migrations(**kw)
[Wed Jul 10 11:41:12.248805 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/runtime/migration.py", line 627, in run_migrations
[Wed Jul 10 11:41:12.248815 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] step.migration_fn(**kw)
[Wed Jul 10 11:41:12.248826 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/web/migrations/versions/fdc58d9bd449_.py", line 38, in upgrade
[Wed Jul 10 11:41:12.248835 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] email, password = user_info()
[Wed Jul 10 11:41:12.248846 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 75, in user_info
[Wed Jul 10 11:41:12.248856 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] email, p1 = user_info_server()
[Wed Jul 10 11:41:12.248867 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 52, in user_info_server
[Wed Jul 10 11:41:12.248876 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] email = input(ENTER_EMAIL_ADDRESS)
[Wed Jul 10 11:41:12.248901 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] EOFError: EOF when reading a line
[Wed Jul 10 11:41:12.248918 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035]
[Wed Jul 10 11:41:12.248927 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] During handling of the above exception, another exception occurred:
[Wed Jul 10 11:41:12.248935 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035]
[Wed Jul 10 11:41:12.248947 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] Traceback (most recent call last):
[Wed Jul 10 11:41:12.249052 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/web/pgadmin/__init__.py", line 372, in backup_db_file
[Wed Jul 10 11:41:12.249067 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] db_upgrade(app)
[Wed Jul 10 11:41:12.249079 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/web/pgadmin/setup/db_upgrade.py", line 25, in db_upgrade
[Wed Jul 10 11:41:12.249088 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] flask_migrate.upgrade(migration_folder)
[Wed Jul 10 11:41:12.249100 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/flask_migrate/__init__.py", line 111, in wrapped
[Wed Jul 10 11:41:12.249109 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] f(*args, **kwargs)
[Wed Jul 10 11:41:12.249121 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/flask_migrate/__init__.py", line 200, in upgrade
[Wed Jul 10 11:41:12.249130 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] command.upgrade(config, revision, sql=sql, tag=tag)
[Wed Jul 10 11:41:12.249175 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/command.py", line 403, in upgrade
[Wed Jul 10 11:41:12.249188 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] script.run_env()
[Wed Jul 10 11:41:12.249219 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/script/base.py", line 583, in run_env
[Wed Jul 10 11:41:12.249228 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] util.load_python_file(self.dir, "env.py")
[Wed Jul 10 11:41:12.249239 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py", line 95, in load_python_file
[Wed Jul 10 11:41:12.249250 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] module = load_module_py(module_id, path)
[Wed Jul 10 11:41:12.249262 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py", line 113, in load_module_py
[Wed Jul 10 11:41:12.249270 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] spec.loader.exec_module(module) # type: ignore
[Wed Jul 10 11:41:12.249281 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "", line 850, in exec_module
[Wed Jul 10 11:41:12.249292 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "", line 228, in _call_with_frames_removed
[Wed Jul 10 11:41:12.249303 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 95, in
[Wed Jul 10 11:41:12.249312 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] run_migrations_online()
[Wed Jul 10 11:41:12.249326 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 87, in run_migrations_online
[Wed Jul 10 11:41:12.249335 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] context.run_migrations()
[Wed Jul 10 11:41:12.249346 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "", line 8, in run_migrations
[Wed Jul 10 11:41:12.249357 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/runtime/environment.py", line 948, in run_migrations
[Wed Jul 10 11:41:12.249366 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] self.get_context().run_migrations(**kw)
[Wed Jul 10 11:41:12.249388 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/venv/lib64/python3.9/site-packages/alembic/runtime/migration.py", line 627, in run_migrations
[Wed Jul 10 11:41:12.249396 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] step.migration_fn(**kw)
[Wed Jul 10 11:41:12.249408 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/web/migrations/versions/fdc58d9bd449_.py", line 38, in upgrade
[Wed Jul 10 11:41:12.249419 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] email, password = user_info()
[Wed Jul 10 11:41:12.249434 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 75, in user_info
[Wed Jul 10 11:41:12.249443 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] email, p1 = user_info_server()
[Wed Jul 10 11:41:12.249454 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 52, in user_info_server
[Wed Jul 10 11:41:12.249463 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] email = input(ENTER_EMAIL_ADDRESS)
[Wed Jul 10 11:41:12.249489 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] EOFError: EOF when reading a line
[Wed Jul 10 11:41:12.249503 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035]
[Wed Jul 10 11:41:12.249512 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] During handling of the above exception, another exception occurred:
[Wed Jul 10 11:41:12.249520 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035]
[Wed Jul 10 11:41:12.249532 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] Traceback (most recent call last):
[Wed Jul 10 11:41:12.249583 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/web/pgAdmin4.wsgi", line 36, in
[Wed Jul 10 11:41:12.249594 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] from pgAdmin4 import app as application
[Wed Jul 10 11:41:12.249606 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/web/pgAdmin4.py", line 103, in
[Wed Jul 10 11:41:12.249614 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] app = create_app()
[Wed Jul 10 11:41:12.249629 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/web/pgadmin/__init__.py", line 473, in create_app
[Wed Jul 10 11:41:12.249638 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] run_migration_for_sqlite()
[Wed Jul 10 11:41:12.249649 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/web/pgadmin/__init__.py", line 410, in run_migration_for_sqlite
[Wed Jul 10 11:41:12.249659 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] upgrade_db()
[Wed Jul 10 11:41:12.249670 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/web/pgadmin/__init__.py", line 391, in upgrade_db
[Wed Jul 10 11:41:12.249681 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] backup_db_file()
[Wed Jul 10 11:41:12.249692 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] File "/usr/pgadmin4/web/pgadmin/__init__.py", line 379, in backup_db_file
[Wed Jul 10 11:41:12.249702 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] raise RuntimeError('Migration failed')
[Wed Jul 10 11:41:12.249721 2024] [wsgi:error] [pid 23737:tid 23786] [remote xxx.xxx.xx.xxx:58035] RuntimeError: Migration failed
I have no idea what is going on here. What migration is it talking about? The original site is available within a second.
CentOS Stream release 9. Problem occurs both with the source code distribution as with the rpm. Plenty of disk space available.
Met vriendelijke groet,
Petros Mylonopoulos
Betuwehaven 16, 3433PV Nieuwegein
T: +31 (0)30-2074400 |E: petros@digistate.nl | www.digistate.nl
--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | enterprisedb.com
"Don't Complain about Heat, Plant a TREE"
--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | enterprisedb.com
"Don't Complain about Heat, Plant a TREE"
--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | enterprisedb.com
"Don't Complain about Heat, Plant a TREE"
Attachment
pgadmin-support by date: