Thread: PgAdmin 4 v.30 on WIN10
Hello,
After installing PgAdmin 4 v.30 on Windows 10 when Trying to start it, I’m getting “Fatal Error” message box:
“The application server could not be contacted”.
Here is the what’s in PgAdmin log file:
Traceback (most recent call last):
File "D:/Postgres/10/v3/web/pgAdmin4.py", line 70, in <module>
app = create_app()
File "D:\Postgres\10\v3\web\pgadmin\__init__.py", line 315, in create_app
db_upgrade(app)
File "D:\Postgres\10\v3\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
flask_migrate.upgrade(migration_folder)
File "D:/Postgres/10/v3/venv/Lib/site-packages\flask_migrate\__init__.py", line 259, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\command.py", line 254, in upgrade
script.run_env()
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 427, in run_env
util.load_python_file(self.dir, 'env.py')
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\util\pyfiles.py", line 81, in load_python_file
module = load_module_py(module_id, path)
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\util\compat.py", line 141, in load_module_py
mod = imp.load_source(module_id, path, fp)
File "D:\Postgres\10\v3\web\pgadmin\setup\..\..\migrations\env.py", line 94, in <module>
run_migrations_online()
File "D:\Postgres\10\v3\web\pgadmin\setup\..\..\migrations\env.py", line 87, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\runtime\environment.py", line 836, in run_migrations
self.get_context().run_migrations(**kw)
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\runtime\migration.py", line 321, in run_migrations
for step in self._migrations_fn(heads, self):
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\command.py", line 243, in upgrade
return script._upgrade_revs(revision, rev)
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 340, in _upgrade_revs
for script in reversed(list(revs))
File "D:/Postgres/10/v3/venv\lib\contextlib.py", line 35, in __exit__
self.gen.throw(type, value, traceback)
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 176, in _catch_revision_errors
compat.raise_from_cause(util.CommandError(err.args[0]))
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\util\compat.py", line 205, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 143, in _catch_revision_errors
yield
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 336, in _upgrade_revs
revs = list(revs)
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\revision.py", line 698, in _iterate_revisions
select_for_downgrade and requested_lowers
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\revision.py", line 694, in <genexpr>
rev.revision for rev
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\revision.py", line 631, in _iterate_related_revisions
", ".join(r.revision for r in overlaps)
alembic.util.exc.CommandError: Requested revision fdc58d9bd449 overlaps with other requested revisions 02b9dccdcfcb
Exception KeyError: KeyError(8304,) in <module 'threading' from 'D:/Postgres/10/v3/venv\lib\threading.py'> ignored
Regards,
Igor Neyman
Hello,
After installing PgAdmin 4 v.30 on Windows 10 when Trying to start it, I’m getting “Fatal Error” message box:
“The application server could not be contacted”.
Here is the what’s in PgAdmin log file:
Traceback (most recent call last):
File "D:/Postgres/10/v3/web/
pgAdmin4.py", line 70, in <module> app = create_app()
File "D:\Postgres\10\v3\web\
pgadmin\__init__.py", line 315, in create_app db_upgrade(app)
File "D:\Postgres\10\v3\web\
pgadmin\setup\db_upgrade.py", line 25, in db_upgrade flask_migrate.upgrade(
migration_folder) File "D:/Postgres/10/v3/venv/Lib/
site-packages\flask_migrate\__ init__.py", line 259, in upgrade command.upgrade(config, revision, sql=sql, tag=tag)
File "D:/Postgres/10/v3/venv/Lib/
site-packages\alembic\command. py", line 254, in upgrade script.run_env()
File "D:/Postgres/10/v3/venv/Lib/
site-packages\alembic\script\ base.py", line 427, in run_env util.load_python_file(self.
dir, 'env.py') File "D:/Postgres/10/v3/venv/Lib/
site-packages\alembic\util\ pyfiles.py", line 81, in load_python_file module = load_module_py(module_id, path)
File "D:/Postgres/10/v3/venv/Lib/
site-packages\alembic\util\ compat.py", line 141, in load_module_py mod = imp.load_source(module_id, path, fp)
File "D:\Postgres\10\v3\web\
pgadmin\setup\..\..\ migrations\env.py", line 94, in <module> run_migrations_online()
File "D:\Postgres\10\v3\web\
pgadmin\setup\..\..\ migrations\env.py", line 87, in run_migrations_online context.run_migrations()
File "<string>", line 8, in run_migrations
File "D:/Postgres/10/v3/venv/Lib/
site-packages\alembic\runtime\ environment.py", line 836, in run_migrations self.get_context().run_
migrations(**kw) File "D:/Postgres/10/v3/venv/Lib/
site-packages\alembic\runtime\ migration.py", line 321, in run_migrations for step in self._migrations_fn(heads, self):
File "D:/Postgres/10/v3/venv/Lib/
site-packages\alembic\command. py", line 243, in upgrade return script._upgrade_revs(revision, rev)
File "D:/Postgres/10/v3/venv/Lib/
site-packages\alembic\script\ base.py", line 340, in _upgrade_revs for script in reversed(list(revs))
File "D:/Postgres/10/v3/venv\lib\
contextlib.py", line 35, in __exit__ self.gen.throw(type, value, traceback)
File "D:/Postgres/10/v3/venv/Lib/
site-packages\alembic\script\ base.py", line 176, in _catch_revision_errors compat.raise_from_cause(util.
CommandError(err.args[0])) File "D:/Postgres/10/v3/venv/Lib/
site-packages\alembic\util\ compat.py", line 205, in raise_from_cause reraise(type(exception), exception, tb=exc_tb)
File "D:/Postgres/10/v3/venv/Lib/
site-packages\alembic\script\ base.py", line 143, in _catch_revision_errors yield
File "D:/Postgres/10/v3/venv/Lib/
site-packages\alembic\script\ base.py", line 336, in _upgrade_revs revs = list(revs)
File "D:/Postgres/10/v3/venv/Lib/
site-packages\alembic\script\ revision.py", line 698, in _iterate_revisions select_for_downgrade and requested_lowers
File "D:/Postgres/10/v3/venv/Lib/
site-packages\alembic\script\ revision.py", line 694, in <genexpr> rev.revision for rev
File "D:/Postgres/10/v3/venv/Lib/
site-packages\alembic\script\ revision.py", line 631, in _iterate_related_revisions ", ".join(r.revision for r in overlaps)
alembic.util.exc.CommandError: Requested revision fdc58d9bd449 overlaps with other requested revisions 02b9dccdcfcb
Exception KeyError: KeyError(8304,) in <module 'threading' from 'D:/Postgres/10/v3/venv\lib\
threading.py'> ignored
Regards,
Igor Neyman
From: Murtuza Zabuawala [mailto:murtuza.zabuawala@enterprisedb.com]
Sent: Wednesday, June 06, 2018 1:15 PM
To: Igor Neyman <ineyman@perceptron.com>
Cc: pgadmin-support@lists.postgresql.org
Subject: Re: PgAdmin 4 v.30 on WIN10
Hi,
Can you try renaming existing pgAdmin4.db to pgAdmin4.db_OLD which is located at C:\Users\<YourUsername>\AppData\Roaming\pgAdmin\
And try to start pgAdmin4 again.
--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
On Wed, Jun 6, 2018 at 9:48 PM, Igor Neyman <ineyman@perceptron.com> wrote:
Hello,
After installing PgAdmin 4 v.30 on Windows 10 when Trying to start it, I’m getting “Fatal Error” message box:
“The application server could not be contacted”.
Here is the what’s in PgAdmin log file:
Traceback (most recent call last):
File "D:/Postgres/10/v3/web/pgAdmin4.py", line 70, in <module>
app = create_app()
File "D:\Postgres\10\v3\web\pgadmin\__init__.py", line 315, in create_app
db_upgrade(app)
File "D:\Postgres\10\v3\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
flask_migrate.upgrade(migration_folder)
File "D:/Postgres/10/v3/venv/Lib/site-packages\flask_migrate\__init__.py", line 259, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\command.py", line 254, in upgrade
script.run_env()
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 427, in run_env
util.load_python_file(self.dir, 'env.py')
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\util\pyfiles.py", line 81, in load_python_file
module = load_module_py(module_id, path)
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\util\compat.py", line 141, in load_module_py
mod = imp.load_source(module_id, path, fp)
File "D:\Postgres\10\v3\web\pgadmin\setup\..\..\migrations\env.py", line 94, in <module>
run_migrations_online()
File "D:\Postgres\10\v3\web\pgadmin\setup\..\..\migrations\env.py", line 87, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\runtime\environment.py", line 836, in run_migrations
self.get_context().run_migrations(**kw)
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\runtime\migration.py", line 321, in run_migrations
for step in self._migrations_fn(heads, self):
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\command.py", line 243, in upgrade
return script._upgrade_revs(revision, rev)
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 340, in _upgrade_revs
for script in reversed(list(revs))
File "D:/Postgres/10/v3/venv\lib\contextlib.py", line 35, in __exit__
self.gen.throw(type, value, traceback)
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 176, in _catch_revision_errors
compat.raise_from_cause(util.CommandError(err.args[0]))
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\util\compat.py", line 205, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 143, in _catch_revision_errors
yield
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 336, in _upgrade_revs
revs = list(revs)
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\revision.py", line 698, in _iterate_revisions
select_for_downgrade and requested_lowers
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\revision.py", line 694, in <genexpr>
rev.revision for rev
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\revision.py", line 631, in _iterate_related_revisions
", ".join(r.revision for r in overlaps)
alembic.util.exc.CommandError: Requested revision fdc58d9bd449 overlaps with other requested revisions 02b9dccdcfcb
Exception KeyError: KeyError(8304,) in <module 'threading' from 'D:/Postgres/10/v3/venv\lib\threading.py'> ignored
Regards,
Igor Neyman
Thank you, that fixed it.
Regards,
Igor Neyman
I’m getting the same error message when using PgAdmin4 v2.1 both: on Windows 7 and Windows 10.
I tried the fix you suggested for PgAdmin4 v.3.0, but it didn’t help.
Is there a fix for v2.1, if upgrading to 3.0 is not an option?
Regards,
Igor Neyman
From: Murtuza Zabuawala [mailto:murtuza.zabuawala@enterprisedb.com]
Sent: Wednesday, June 06, 2018 1:15 PM
To: Igor Neyman <ineyman@perceptron.com>
Cc: pgadmin-support@lists.postgresql.org
Subject: Re: PgAdmin 4 v.30 on WIN10
Hi,
Can you try renaming existing pgAdmin4.db to pgAdmin4.db_OLD which is located at C:\Users\<YourUsername>\AppData\Roaming\pgAdmin\
And try to start pgAdmin4 again.
--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
On Wed, Jun 6, 2018 at 9:48 PM, Igor Neyman <ineyman@perceptron.com> wrote:
Hello,
After installing PgAdmin 4 v.30 on Windows 10 when Trying to start it, I’m getting “Fatal Error” message box:
“The application server could not be contacted”.
Here is the what’s in PgAdmin log file:
Traceback (most recent call last):
File "D:/Postgres/10/v3/web/pgAdmin4.py", line 70, in <module>
app = create_app()
File "D:\Postgres\10\v3\web\pgadmin\__init__.py", line 315, in create_app
db_upgrade(app)
File "D:\Postgres\10\v3\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
flask_migrate.upgrade(migration_folder)
File "D:/Postgres/10/v3/venv/Lib/site-packages\flask_migrate\__init__.py", line 259, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\command.py", line 254, in upgrade
script.run_env()
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 427, in run_env
util.load_python_file(self.dir, 'env.py')
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\util\pyfiles.py", line 81, in load_python_file
module = load_module_py(module_id, path)
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\util\compat.py", line 141, in load_module_py
mod = imp.load_source(module_id, path, fp)
File "D:\Postgres\10\v3\web\pgadmin\setup\..\..\migrations\env.py", line 94, in <module>
run_migrations_online()
File "D:\Postgres\10\v3\web\pgadmin\setup\..\..\migrations\env.py", line 87, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\runtime\environment.py", line 836, in run_migrations
self.get_context().run_migrations(**kw)
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\runtime\migration.py", line 321, in run_migrations
for step in self._migrations_fn(heads, self):
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\command.py", line 243, in upgrade
return script._upgrade_revs(revision, rev)
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 340, in _upgrade_revs
for script in reversed(list(revs))
File "D:/Postgres/10/v3/venv\lib\contextlib.py", line 35, in __exit__
self.gen.throw(type, value, traceback)
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 176, in _catch_revision_errors
compat.raise_from_cause(util.CommandError(err.args[0]))
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\util\compat.py", line 205, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 143, in _catch_revision_errors
yield
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\base.py", line 336, in _upgrade_revs
revs = list(revs)
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\revision.py", line 698, in _iterate_revisions
select_for_downgrade and requested_lowers
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\revision.py", line 694, in <genexpr>
rev.revision for rev
File "D:/Postgres/10/v3/venv/Lib/site-packages\alembic\script\revision.py", line 631, in _iterate_related_revisions
", ".join(r.revision for r in overlaps)
alembic.util.exc.CommandError: Requested revision fdc58d9bd449 overlaps with other requested revisions 02b9dccdcfcb
Exception KeyError: KeyError(8304,) in <module 'threading' from 'D:/Postgres/10/v3/venv\lib\threading.py'> ignored
Regards,
Igor Neyman