RE: PgAdmin 4 v.30 on WIN10

From: Igor Neyman <ineyman(at)perceptron(dot)com>
To: Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com>
Cc: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: RE: PgAdmin 4 v.30 on WIN10
Date: 2018-06-07 17:17:11
Message-ID: DM5PR17MB1532C5860CC23C1D67E69045DA640@DM5PR17MB1532.namprd17.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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(dot)zabuawala(at)enterprisedb(dot)com]
Sent: Wednesday, June 06, 2018 1:15 PM
To: Igor Neyman <ineyman(at)perceptron(dot)com>
Cc: pgadmin-support(at)lists(dot)postgresql(dot)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<http://www.enterprisedb.com/>
The Enterprise PostgreSQL Company
[https://drive.google.com/a/enterprisedb.com/uc?id=0B6jGeB3BfKRMV0t4MEp0YnZCTTA&export=download]

On Wed, Jun 6, 2018 at 9:48 PM, Igor Neyman <ineyman(at)perceptron(dot)com<mailto:ineyman(at)perceptron(dot)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

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Pierre Ochsenbein 2018-06-07 17:59:13 pgpool-II
Previous Message Igor Neyman 2018-06-06 17:26:00 RE: PgAdmin 4 v.30 on WIN10