{"action":"created","issue":{"url":"https://api.github.com/repos/jupyter/nbgrader/issues/560","repository_url":"https://api.github.com/repos/jupyter/nbgrader","labels_url":"https://api.github.com/repos/jupyter/nbgrader/issues/560/labels{/name}","comments_url":"https://api.github.com/repos/jupyter/nbgrader/issues/560/comments","events_url":"https://api.github.com/repos/jupyter/nbgrader/issues/560/events","html_url":"https://github.com/jupyter/nbgrader/issues/560","id":178500216,"number":560,"title":"sqlalchemy error when invoking autograder","user":{"login":"ddbourgin","id":4887372,"avatar_url":"https://avatars.githubusercontent.com/u/4887372?v=3","gravatar_id":"","url":"https://api.github.com/users/ddbourgin","html_url":"https://github.com/ddbourgin","followers_url":"https://api.github.com/users/ddbourgin/followers","following_url":"https://api.github.com/users/ddbourgin/following{/other_user}","gists_url":"https://api.github.com/users/ddbourgin/gists{/gist_id}","starred_url":"https://api.github.com/users/ddbourgin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ddbourgin/subscriptions","organizations_url":"https://api.github.com/users/ddbourgin/orgs","repos_url":"https://api.github.com/users/ddbourgin/repos","events_url":"https://api.github.com/users/ddbourgin/events{/privacy}","received_events_url":"https://api.github.com/users/ddbourgin/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/jupyter/nbgrader/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/jupyter/nbgrader/milestones/10","html_url":"https://github.com/jupyter/nbgrader/milestones/0.3.1","labels_url":"https://api.github.com/repos/jupyter/nbgrader/milestones/10/labels","id":2022915,"number":10,"title":"0.3.1","description":"","creator":{"login":"jhamrick","id":83444,"avatar_url":"https://avatars.githubusercontent.com/u/83444?v=3","gravatar_id":"","url":"https://api.github.com/users/jhamrick","html_url":"https://github.com/jhamrick","followers_url":"https://api.github.com/users/jhamrick/followers","following_url":"https://api.github.com/users/jhamrick/following{/other_user}","gists_url":"https://api.github.com/users/jhamrick/gists{/gist_id}","starred_url":"https://api.github.com/users/jhamrick/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jhamrick/subscriptions","organizations_url":"https://api.github.com/users/jhamrick/orgs","repos_url":"https://api.github.com/users/jhamrick/repos","events_url":"https://api.github.com/users/jhamrick/events{/privacy}","received_events_url":"https://api.github.com/users/jhamrick/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":12,"state":"closed","created_at":"2016-09-22T19:54:40Z","updated_at":"2016-10-04T22:03:54Z","due_on":null,"closed_at":"2016-09-22T22:01:31Z"},"comments":2,"created_at":"2016-09-22T01:28:35Z","updated_at":"2016-10-04T22:03:54Z","closed_at":null,"body":"When running the autograder over a large collection of student submissions, it errors out midway through with a message from sqlalchemy about having too many clients. A condensed traceback:\r\n\r\n```\r\n[AutogradeApp | ERROR] There was an error processing assignment: <assignment>                                                                                        \r\n[AutogradeApp | ERROR] Traceback (most recent call last):                                                                           \r\n      File \"/opt/conda/lib/python3.5/site-packages/sqlalchemy/pool.py\", line 1044, in _d                                            \r\no_get                                                                                                                               \r\n        return self._pool.get(wait, self._timeout)                                                                                  \r\n      File \"/opt/conda/lib/python3.5/site-packages/sqlalchemy/util/queue.py\", line 145,                                             \r\nin get                                                                                                                              \r\n        raise Empty                                                                                                                 \r\n    sqlalchemy.util.queue.Empty                                                                                                     \r\n                                                                                                                                    \r\n    During handling of the above exception, another exception occurred:                                                             \r\n                                                                                                                                    \r\n    Traceback (most recent call last):                                                                                              \r\n      File \"/opt/conda/lib/python3.5/site-packages/sqlalchemy/engine/base.py\", line 2074                                            \r\n, in _wrap_pool_connect      \r\n                                                                                                       \r\n...                                                                                                               \r\n      File \"/opt/conda/lib/python3.5/site-packages/sqlalchemy/pool.py\", line 607, in __c                                            \r\nonnect                                                                                                                              \r\n        connection = self.__pool._invoke_creator(self)                                                                              \r\n      File \"/opt/conda/lib/python3.5/site-packages/sqlalchemy/engine/strategies.py\", lin                                            \r\ne 97, in connect                                                                                                                    \r\n        return dialect.connect(*cargs, **cparams)                                                                                   \r\n      File \"/opt/conda/lib/python3.5/site-packages/sqlalchemy/engine/default.py\", line 3                                            \r\n85, in connect                                                                                                                      \r\n        return self.dbapi.connect(*cargs, **cparams)                                                                                \r\n      File \"/opt/conda/lib/python3.5/site-packages/psycopg2/__init__.py\", line 164, in c                                            \r\nonnect                                                                                                                              \r\n        conn = _connect(dsn, connection_factory=connection_factory, async=async)                                                    \r\n    sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) FATAL:  sorry, too many                                            \r\n clients already      \r\n```"},"comment":{"url":"https://api.github.com/repos/jupyter/nbgrader/issues/comments/251527240","html_url":"https://github.com/jupyter/nbgrader/issues/560#issuecomment-251527240","issue_url":"https://api.github.com/repos/jupyter/nbgrader/issues/560","id":251527240,"user":{"login":"jhamrick","id":83444,"avatar_url":"https://avatars.githubusercontent.com/u/83444?v=3","gravatar_id":"","url":"https://api.github.com/users/jhamrick","html_url":"https://github.com/jhamrick","followers_url":"https://api.github.com/users/jhamrick/followers","following_url":"https://api.github.com/users/jhamrick/following{/other_user}","gists_url":"https://api.github.com/users/jhamrick/gists{/gist_id}","starred_url":"https://api.github.com/users/jhamrick/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jhamrick/subscriptions","organizations_url":"https://api.github.com/users/jhamrick/orgs","repos_url":"https://api.github.com/users/jhamrick/repos","events_url":"https://api.github.com/users/jhamrick/events{/privacy}","received_events_url":"https://api.github.com/users/jhamrick/received_events","type":"User","site_admin":false},"created_at":"2016-10-04T22:03:54Z","updated_at":"2016-10-04T22:03:54Z","body":"It seems as though this error is still occurring for @ddbourgin :("}}
{"actor":{"display_login":"jhamrick"}}