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 "-//IETF//DTD HTML 2.0//EN"> <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@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. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
