pgadmin4:1.2 Apache HTTPD/uWsgi issue

From: jlundberg <jlundberg(at)adconion(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgadmin4:1.2 Apache HTTPD/uWsgi issue
Date: 2017-02-23 17:10:16
Message-ID: 1487869816612-5945957.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

We have uwsgi/pgadmin running in a Docker container. Apache HTTPD runs on
the host machine and proxies requests to uwsgi. For small queries with
small return data sets, everything works great. However, on larger queries
with large return data sets we have issues:

httpd-2.4.6-45
uWSGI==2.0.14

We had to max out buffer size due to the large query strings users are
submitting.

pertinent uwsgi options:
--processes=1
--buffer-size=65535

uWsgi ERROR (not clear if this is on data return or not):
Thu Feb 23 16:43:30 2017 - SIGPIPE: writing to a closed pipe/socket/fd
(probably the client disconnected) on request /sqleditor/poll/4682126 (ip
104.34.239.40) !!!
Thu Feb 23 16:43:30 2017 - uwsgi_response_write_body_do(): Broken pipe
[core/writer.c line 331] during GET /sqleditor/poll/4682126 (104.34.239.40)
IOError: write error

Generic HTTPD Error:
<!DOCTYPE HTML PUBLIC &quot;-//IETF//DTD HTML 2.0//EN&quot;>
<html><head>
<title>500 Internal Server Error</title>
</head><body>
Internal Server Error

<p>The server encountered an internal error or
misconfiguration and was unable to complete
your request.</p>
<p>Please contact the server administrator at
root(at)localhost to inform them of the time this error occurred,
and the actions you performed just before this error.</p>
<p>More information about this error may be available
in the server error log.</p>
<hr>
<address>Apache Server at server.domain.com Port 443</address>
</body></html>

--
View this message in context: http://www.postgresql-archive.org/pgadmin4-1-2-Apache-HTTPD-uWsgi-issue-tp5945957.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

Browse pgadmin-support by date

  From Date Subject
Next Message Shirley Wang 2017-02-24 18:36:52 Call for feedback on pgAdmin4 features
Previous Message Eric Hirst 2017-02-22 18:14:44 pgAdmin 4 latency issues on Remote Desktop