{"action":"opened","issue":{"url":"https://api.github.com/repos/geopython/pywps/issues/346","repository_url":"https://api.github.com/repos/geopython/pywps","labels_url":"https://api.github.com/repos/geopython/pywps/issues/346/labels{/name}","comments_url":"https://api.github.com/repos/geopython/pywps/issues/346/comments","events_url":"https://api.github.com/repos/geopython/pywps/issues/346/events","html_url":"https://github.com/geopython/pywps/issues/346","id":333061596,"node_id":"MDU6SXNzdWUzMzMwNjE1OTY=","number":346,"title":"load testing with concurrency crashes server","user":{"login":"tomkralidis","id":910430,"node_id":"MDQ6VXNlcjkxMDQzMA==","avatar_url":"https://avatars3.githubusercontent.com/u/910430?v=4","gravatar_id":"","url":"https://api.github.com/users/tomkralidis","html_url":"https://github.com/tomkralidis","followers_url":"https://api.github.com/users/tomkralidis/followers","following_url":"https://api.github.com/users/tomkralidis/following{/other_user}","gists_url":"https://api.github.com/users/tomkralidis/gists{/gist_id}","starred_url":"https://api.github.com/users/tomkralidis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tomkralidis/subscriptions","organizations_url":"https://api.github.com/users/tomkralidis/orgs","repos_url":"https://api.github.com/users/tomkralidis/repos","events_url":"https://api.github.com/users/tomkralidis/events{/privacy}","received_events_url":"https://api.github.com/users/tomkralidis/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-06-17T13:09:08Z","updated_at":"2018-06-17T13:09:08Z","closed_at":null,"author_association":"MEMBER","body":"# Description\r\nRunning load testing with concurrency results in PyWPS crashing and not recovering.\r\n\r\n# Environment\r\n\r\n- operating system: Ubuntu 16.04.3\r\n- Python version: 2.7.12\r\n- PyWPS version: master\r\n- source/distribution\r\n - [x] git clone\r\n - [ ] Debian\r\n - [ ] PyPI\r\n - [ ] zip/tar.gz\r\n - [ ] other (please specify): \r\n- web server\r\n - [ ] Apache/mod_wsgi\r\n - [ ] CGI\r\n - [ ] other (please specify): \r\n\r\n# Steps to Reproduce\r\n- install PyWPS from master\r\n- install PyWPS-flask from master\r\n- install ApacheBench (ab)\r\n- start `python demo.py`\r\n- run `ab -c 10 -n 200 \"http://localhost:9001/wps?service=wps&version=1.0.0&request=describeprocess&identifier=all\"`, (`-c 10` means run 10 concurrent requests at a time) runs as expected and displays test results\r\n\r\n`ab` will stop (Connection refused). In the server running window:\r\n\r\n```\r\n/home/ubuntu/pywps/local/lib/python2.7/site-packages/SQLAlchemy-1.2.8-py2.7-linux-x86_64.egg/sqlalchemy/util/langhelpers.py:74: SAWarning: An exception has occurred during handling of a previous exception.  The previous exception is:\r\n <class 'sqlalchemy.exc.ResourceClosedError'> This transaction is closed\r\n```\r\n\r\n# Additional Information\r\n"}}
{"actor":{"display_login":"tomkralidis"}}