search

pgadmin-org / pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
https://www.pgadmin.org
Other
2.43k stars 638 forks source link

pgAdmin 4, Mac. The application server could not be contacted (RM #3411) #1888

Closed dpage closed 2 years ago

dpage commented 6 years ago

Issue migrated from Redmine: https://redmine.postgresql.org/issues/3411 Originally created by Jérémy Lamie at 2018-06-11 09:14:25 UTC.

Hello,

I have an issue with launching pgAdmin4 on my Mac (MacOS 10.13.4) since I reboot my computer. I get : The Application server could not be contacted.

If I delete the folder ".pgadmin", pgAdmin will launch. But I cannot do that each time I reboot, due to the loss of pgAdmin configuration.

I see in this folder a file named pgamin.log which contains this line of error. Could you provide me a definitive fix ? Thanks a lot

Jeremy

2018-06-11 10:55:32,485: ERROR werkzeug: Error on request: Traceback (most recent call last): File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/werkzeug/serving.py", line 270, in run_wsgi execute(self.server.app) File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/werkzeug/serving.py", line 258, in execute application_iter = app(environ, start_response) File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1997, in call return self.wsgi_app(environ, start_response) File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1985, in wsgi_app response = self.handle_exception(e) File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1540, in handle_exception reraise(exc_type, exc_value, tb) File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1982, in wsgi_app response = self.full_dispatch_request() File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1607, in full_dispatch_request self.try_trigger_before_first_request_functions() File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1654, in try_trigger_before_first_request_functions func() File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/utils/init.py", line 46, in create_module_preference self.register_preferences() File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/tools/sqleditor/init.py", line 114, in register_preferences RegisterQueryToolPreferences(self) File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/tools/sqleditor/utils/query_tool_preferences.py", line 84, in RegisterQueryToolPreferences 'The font size to use for the SQL text boxes and editors. ' File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask_babelex/init.py", line 623, in gettext return get_domain().gettext(*args, **kwargs) File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask_babelex/init.py", line 534, in gettext return t.ugettext(string) % variables TypeError: %d format: a number is required, not dict

dpage commented 6 years ago

Attachment migrated from Redmine: https://redmine.postgresql.org/attachments/download/3077 Originally created by Jérémy Lamie at 2018-06-11 09:27:27 UTC.

https://pgadmin-archive.postgresql.org/redmine/3411/3077-pgadmin4.db

Description: file in error

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3411#note-2 Originally created by Jérémy Lamie at 2018-06-11 09:27:42 UTC.

Looks like the pgadmin4.db file is in cause. Please see it attached Thanks

Redmine ticket header update:

Name Old Value New Value
Attachment added pgadmin4.db
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3411#note-3 Originally created by Khushboo Vashi at 2018-06-11 09:58:47 UTC.

Which pgAdmin 4 version are you using? How you have installed pgAdmin 4?

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3411#note-4 Originally created by Jérémy Lamie at 2018-06-11 10:24:33 UTC.

Khushboo Vashi wrote:

Which pgAdmin 4 version are you using? How you have installed pgAdmin 4?

Thanks for your reply. I'm using pgAdmin 4 version 3.0 Python version is : 2.7.10 Flask version is : 0.12.2

How I installed pgadmin ? I downloaded the file postgresql-10.4-1-osx.dmg Then Remember I installed options "pgAdmin 4" and "Command Line Tools" Not 'PostGreSQL Server" (installed on the server of course), neither "Stack Builder"

Looking forward to reading you again. jeremy

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3411#note-5 Originally created by Jérémy Lamie at 2018-06-13 12:50:26 UTC.

Khushboo Vashi wrote:

Which pgAdmin 4 version are you using? How you have installed pgAdmin 4?

Hello.

I replied two days ago and I don't received help from. Help will be appreciated.

Thanks. Jeremy

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3411#note-6 Originally created by Khushboo Vashi at 2018-06-14 05:10:30 UTC.

Hi Jeremy,

Can you please provide the output of below command?

pip freeze

Thanks, Khushboo

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3411#note-7 Originally created by Khushboo Vashi at 2018-06-14 05:47:17 UTC.

Hi Jeremy,

As per your database file, you are using French language and the issue is detected with the translation. The fix has been submitted. https://www.postgresql.org/message-id/CAFOhELezaRVS+JbX0Xtsms8jWND9H1h8HW_WeB3rKVLT8kJ=Fg@mail.gmail.com

Thanks, Khushboo

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3411#note-8 Originally created by Akshay Joshi at 2018-06-15 10:22:05 UTC.

Test cases are still pending.

Redmine ticket header update:

Name Old Value New Value
Sprint changed Ready
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3411#note-9 Originally created by Akshay Joshi at 2018-06-20 09:43:23 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed Ready EDB Sprint 17
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3411#note-10 Originally created by Dave Page at 2018-06-27 10:41:22 UTC.

Redmine ticket header update:

Name Old Value New Value
Fixed Version changed 3.1
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3411#note-11 Originally created by Khushboo Vashi at 2018-06-27 10:42:27 UTC.

Applied in changeset commit:8136b7236402d08b1309c502a3d4bfdb4c6e92e7.

Redmine ticket header update:

Name Old Value New Value
Status changed New In Testing
Done Ratio changed 0 90
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3411#note-12 Originally created by Fahar Abbas at 2018-06-28 07:27:08 UTC.

This is already resolved in updated runtime.

Redmine ticket header update:

Name Old Value New Value
Status changed In Testing Resolved
Done Ratio changed 90 100
dpage commented 2 years ago

Issue closed on Redmine.