Re: Connection to the server has been lost

Please also remember to add pgAdmin-hackers email list for every email in
that case, Development team can respond quickly.

Dave/Ashesh,

Please find below the output shared by Ralph.

Kind Regards,

On Tue, Oct 4, 2016 at 12:24 PM, Ralph Ryl <ralph(dot)ryl(at)thuenen(dot)de> wrote:

> Hi Fahar,
>
> here are the steps I do:
>
> - System: Ubuntu 14.04
>
> - I create an new server in a servergroup wich is not local
>
> - I enter correct logindata
>
> - if i directly try to connect an error with "bytea_output" appear
>
> - if i save the connection without directly connect it save the connection
>
> - if i doubleclick on the new connection pgadmin ask for the password(no
> matter if i save it) and show an message like "Connection to the server has
> been lost."
>
>
> here the last 50 lines from the logfile:
>
> 2016-10-04 09:20:37,847: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:20:37] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:20:42,858: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:20:42] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:20:47,869: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:20:47] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:20:52,879: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:20:52] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:20:57,891: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:20:57] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:21:02,902: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:21:02] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:21:07,912: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:21:07] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:21:12,924: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:21:12] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:21:16,626: INFO pgadmin: Connection Request for server#4
>
> 2016-10-04 09:21:16,629: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:21:16] "POST /browser/server/connect/2/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:21:17,935: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:21:17] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:21:18,188: INFO pgadmin: Connection Request for server#4
>
> 2016-10-04 09:21:18,211: SQL pgadmin: Execute (scalar) for server #4 - DB:postgres (Query-id: 8568684):
>
> SET DateStyle=ISO;
>
> SET client_min_messages=notice;
>
> SET bytea_output=escape;
>
> SET client_encoding='UNICODE';
>
> 2016-10-04 09:21:18,214: ERROR pgadmin: Failed to execute query (execute_scalar) for the server #4 - DB:postgres (Query-id: 8568684):
>
> Error Message:FEHLER: unbekannter Konfigurationsparameter »bytea_output«
>
> 2016-10-04 09:21:22,946: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:21:22] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:21:27,959: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:21:27] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:21:31,139: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:21:31] "POST /misc/ping HTTP/1.1" 200 -
>
> 2016-10-04 09:21:32,973: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:21:32] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:21:37,986: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:21:37] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:21:43,001: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:21:43] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:21:48,022: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:21:48] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:21:53,034: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:21:53] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:21:58,046: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:21:58] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:22:03,058: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:22:03] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:22:08,068: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:22:08] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:22:13,080: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:22:13] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:22:18,092: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:22:18] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:22:23,105: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:22:23] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:22:28,116: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:22:28] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:22:33,130: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:22:33] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:22:38,142: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:22:38] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:22:43,154: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:22:43] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:22:48,165: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:22:48] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:22:53,176: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:22:53] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:22:58,186: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:22:58] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:23:03,196: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:23:03] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:23:08,210: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:23:08] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:23:13,226: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:23:13] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:23:18,236: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:23:18] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:23:23,247: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:23:23] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:23:28,257: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:23:28] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:23:33,267: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:23:33] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
> 2016-10-04 09:23:38,278: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016 09:23:38] "GET /dashboard/activity/4 HTTP/1.1" 428 -
>
>
>
> And here the output from the running server in the bash:
>
> 2016-10-04 09:21:18,214: ERROR pgadmin: Failed to execute query (execute_scalar) for the server #4 - DB:postgres (Query-id: 8568684):
> Error Message:FEHLER: unbekannter Konfigurationsparameter »bytea_output«
>
> Exception in thread Thread-346:
> Traceback (most recent call last):
> File "/usr/lib/python2.7/threading.py", line 810, in __bootstrap_inner
> self.run()
> File "/usr/lib/python2.7/threading.py", line 763, in run
> self.__target(*self.__args, **self.__kwargs)
> File "/usr/lib/python2.7/SocketServer.py", line 596, in process_request_thread
> self.handle_error(request, client_address)
> File "/usr/lib/python2.7/SocketServer.py", line 593, in process_request_thread
> self.finish_request(request, client_address)
> File "/usr/lib/python2.7/SocketServer.py", line 334, in finish_request
> self.RequestHandlerClass(request, client_address, self)
> File "/usr/lib/python2.7/SocketServer.py", line 649, in __init__
> self.handle()
> File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.py", line 200, in handle
> rv = BaseHTTPRequestHandler.handle(self)
> File "/usr/lib/python2.7/BaseHTTPServer.py", line 340, in handle
> self.handle_one_request()
> File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.py", line 235, in handle_one_request
> return self.run_wsgi()
> File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.py", line 177, in run_wsgi
> execute(self.server.app)
> File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.py", line 165, in execute
> application_iter = app(environ, start_response)
> File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 2000, in __call__
> return self.wsgi_app(environ, start_response)
> File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1991, in wsgi_app
> response = self.make_response(self.handle_exception(e))
> File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1567, in handle_exception
> reraise(exc_type, exc_value, tb)
> File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1988, in wsgi_app
> response = self.full_dispatch_request()
> File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1641, in full_dispatch_request
> rv = self.handle_user_exception(e)
> File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1544, in handle_user_exception
> reraise(exc_type, exc_value, tb)
> File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1639, in full_dispatch_request
> rv = self.dispatch_request()
> File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1625, in dispatch_request
> return self.view_functions[rule.endpoint](**req.view_args)
> File "/usr/local/lib/python2.7/dist-packages/flask/views.py", line 84, in view
> return self.dispatch_request(*args, **kwargs)
> File "/usr/local/lib/python2.7/dist-packages/pgadmin4/pgadmin/browser/utils.py", line 235, in dispatch_request
> return method(*args, **kwargs)
> File "/usr/local/lib/python2.7/dist-packages/pgadmin4/pgadmin/browser/server_groups/servers/__init__.py", line 829, in connect
> server.id, server.name, errmsg
> UnicodeEncodeError: 'ascii' codec can't encode character u'\xbb' in position 45: ordinal not in range(128)
>
>
> I hope you can follow me an find my mistake.
>
> Many thanks in advance,
>
> Ralph Ryl
>
>
>
> Am 03.10.2016 um 06:47 schrieb Fahar Abbas:
>
> Hi Ralph,
>
> This issue is not reproducible with remote server.
>
> Can you please share the exact steps and *pgAdmin4.log* file location
> under /home/fahar for Linux and in Windows %AppData% with the team so they
> can investigate the actual problem?
>
> Regards,
>
>
> On Thu, Sep 29, 2016 at 10:42 AM, Ralph Ryl <ralph(dot)ryl(at)thuenen(dot)de> wrote:
>
>> Dear pgadmin4 Developers,
>> on trying to connect remote postgresql-server, the connection lost. I
>> think the problem is the timeout for the connection. PGAdminIII works
>> for the same server without problems.
>> Maybe you can make an option in settings for the timout.
>>
>> kind regards,
>>
>> Ralph
>>
>> --
>> Achtung: Das Thünen-Institut hat die Domain gewechselt.
>> Bitte ändern Sie meine Mailadresse in Ihrem Adressbuch!
>>
>> Ralph Ryl
>> Thünen-Institut für Waldökosysteme / Thünen Institute of Forest Ecosystems
>> A.-Möller-Str. 1, Haus 41/42
>> D-16225 Eberswalde (Germany)
>>
>> Tel: +49 3334 3820-347 <%2B49%203334%203820-347>
>> Fax: +49 3334 3820-354 <%2B49%203334%203820-354>
>> Mail: ralph(dot)ryl(at)thuenen(dot)de
>> Web: www.thuenen.de
>>
>>
>>
>>
>> --
>> Sent via pgadmin-hackers mailing list (pgadmin-hackers(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgadmin-hackers
>>
>
>
>
> --
> Syed Fahar Abbas
> Quality Management Group
>
> EnterpriseDB Corporation
> Phone Office: +92-51-835-8874
> Phone Direct: +92-51-8466803
> Mobile: +92-333-5409707
> Skype ID: syed.fahar.abbas
> Website: www.enterprisedb.com
>
>
> --
> Achtung: Das Thünen-Institut hat die Domain gewechselt.
> Bitte ändern Sie meine Mailadresse in Ihrem Adressbuch!
>
> Ralph Ryl
> Thünen-Institut für Waldökosysteme / Thünen Institute of Forest Ecosystems
> A.-Möller-Str. 1, Haus 41/42
> D-16225 Eberswalde (Germany)
>
> Tel: +49 3334 3820-347
> Fax: +49 3334 3820-354
> Mail: ralph(dot)ryl(at)thuenen(dot)de
> Web: www.thuenen.de
>
>

--
Syed Fahar Abbas
Quality Management Group

EnterpriseDB Corporation
Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: syed.fahar.abbas
Website: www.enterprisedb.com