Re: issues with cloned server, centos 9, pgadmin4 8.9

[please do not remove pgadmin-support from CC]

Hi Petros,

It is because it is running under apache. Check the permissions of
/var/lib/pgadmin
directory. It should be in sync as well.

On Wed, Jul 10, 2024 at 6:24 PM Petros Mylonopoulos | DigiState <
petros(at)digistate(dot)nl> wrote:

> 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(at)digistate(dot)nl | www.digistate.nl
>
>
>
> *From:* Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
> *Sent:* 10 July 2024 14:45
> *To:* Petros Mylonopoulos | DigiState <petros(at)digistate(dot)nl>
> *Cc:* pgAdmin Support <pgadmin-support(at)postgresql(dot)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(at)digistate(dot)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(at)digistate(dot)nl | www.digistate.nl
>
>
>
> *From:* Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
> *Sent:* 10 July 2024 14:07
> *To:* Petros Mylonopoulos | DigiState <petros(at)digistate(dot)nl>
> *Cc:* pgAdmin Support <pgadmin-support(at)postgresql(dot)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(at)digistate(dot)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(at)digistate(dot)nl | www.digistate.nl
>
>
>
> *From:* Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
> *Sent:* 10 July 2024 13:48
> *To:* Petros Mylonopoulos | DigiState <petros(at)digistate(dot)nl>
> *Cc:* pgadmin-support(at)lists(dot)postgresql(dot)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(at)digistate(dot)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(at)digistate(dot)nl | www.digistate.nl
>
>
>
>
>
>
> --
>
> Thanks,
>
> Aditya Toshniwal
>
> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
> <https://www.enterprisedb.com/>
>
> "Don't Complain about Heat, Plant a TREE"
>
>
>
>
> --
>
> Thanks,
>
> Aditya Toshniwal
>
> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
> <https://www.enterprisedb.com/>
>
> "Don't Complain about Heat, Plant a TREE"
>
>
>
>
> --
>
> Thanks,
>
> Aditya Toshniwal
>
> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
> <https://www.enterprisedb.com/>
>
> "Don't Complain about Heat, Plant a TREE"
>

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