{"action":"created","issue":{"url":"https://api.github.com/repos/docker/docker-registry/issues/870","labels_url":"https://api.github.com/repos/docker/docker-registry/issues/870/labels{/name}","comments_url":"https://api.github.com/repos/docker/docker-registry/issues/870/comments","events_url":"https://api.github.com/repos/docker/docker-registry/issues/870/events","html_url":"https://github.com/docker/docker-registry/issues/870","id":52803394,"number":870,"title":"DB disconnected error","user":{"login":"pyotr777","id":485462,"avatar_url":"https://avatars.githubusercontent.com/u/485462?v=3","gravatar_id":"","url":"https://api.github.com/users/pyotr777","html_url":"https://github.com/pyotr777","followers_url":"https://api.github.com/users/pyotr777/followers","following_url":"https://api.github.com/users/pyotr777/following{/other_user}","gists_url":"https://api.github.com/users/pyotr777/gists{/gist_id}","starred_url":"https://api.github.com/users/pyotr777/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pyotr777/subscriptions","organizations_url":"https://api.github.com/users/pyotr777/orgs","repos_url":"https://api.github.com/users/pyotr777/repos","events_url":"https://api.github.com/users/pyotr777/events{/privacy}","received_events_url":"https://api.github.com/users/pyotr777/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":17,"created_at":"2014-12-24T08:07:46Z","updated_at":"2015-01-09T18:51:39Z","closed_at":"2015-01-09T18:51:39Z","body":"I keep getting \"DB is disconnected\" error on every request to the registry. It was working fine before, but seems to broke after computer restart.\r\n\r\nFor example, v1/search request causes registry to print the following:\r\n```\r\n24/Dec/2014:17:00:12 +0900 WARNING: DB is disconnected. Reconnect to it.\r\n2014-12-24 17:00:12,885 ERROR: Exception on /v1/search [GET]\r\nTraceback (most recent call last):\r\n  File \"/Library/Python/2.7/site-packages/Flask-0.10.1-py2.7.egg/flask/app.py\", line 1817, in wsgi_app\r\n    response = self.full_dispatch_request()\r\n  File \"/Library/Python/2.7/site-packages/Flask-0.10.1-py2.7.egg/flask/app.py\", line 1477, in full_dispatch_request\r\n    rv = self.handle_user_exception(e)\r\n  File \"/Library/Python/2.7/site-packages/Flask-0.10.1-py2.7.egg/flask/app.py\", line 1381, in handle_user_exception\r\n    reraise(exc_type, exc_value, tb)\r\n  File \"/Library/Python/2.7/site-packages/Flask-0.10.1-py2.7.egg/flask/app.py\", line 1475, in full_dispatch_request\r\n    rv = self.dispatch_request()\r\n  File \"/Library/Python/2.7/site-packages/Flask-0.10.1-py2.7.egg/flask/app.py\", line 1461, in dispatch_request\r\n    return self.view_functions[rule.endpoint](**req.view_args)\r\n  File \"/Library/Python/2.7/site-packages/docker_registry/lib/mirroring.py\", line 145, in wrapper\r\n    resp = f(*args, **kwargs)\r\n  File \"/Library/Python/2.7/site-packages/docker_registry/search.py\", line 21, in get_search\r\n    results = INDEX.results(search_term=search_term)\r\n  File \"/Library/Python/2.7/site-packages/docker_registry/lib/index/db.py\", line 64, in _retry\r\n    raise e\r\nOperationalError: (OperationalError) no such table: repository u'SELECT repository.id AS repository_id, repository.name AS repository_name, repository.description AS repository_description \\nFROM repository' ()\r\n24/Dec/2014:17:00:12 +0900 ERROR: Exception on /v1/search [GET]\r\nTraceback (most recent call last):\r\n  File \"/Library/Python/2.7/site-packages/Flask-0.10.1-py2.7.egg/flask/app.py\", line 1817, in wsgi_app\r\n    response = self.full_dispatch_request()\r\n  File \"/Library/Python/2.7/site-packages/Flask-0.10.1-py2.7.egg/flask/app.py\", line 1477, in full_dispatch_request\r\n    rv = self.handle_user_exception(e)\r\n  File \"/Library/Python/2.7/site-packages/Flask-0.10.1-py2.7.egg/flask/app.py\", line 1381, in handle_user_exception\r\n    reraise(exc_type, exc_value, tb)\r\n  File \"/Library/Python/2.7/site-packages/Flask-0.10.1-py2.7.egg/flask/app.py\", line 1475, in full_dispatch_request\r\n    rv = self.dispatch_request()\r\n  File \"/Library/Python/2.7/site-packages/Flask-0.10.1-py2.7.egg/flask/app.py\", line 1461, in dispatch_request\r\n    return self.view_functions[rule.endpoint](**req.view_args)\r\n  File \"/Library/Python/2.7/site-packages/docker_registry/lib/mirroring.py\", line 145, in wrapper\r\n    resp = f(*args, **kwargs)\r\n  File \"/Library/Python/2.7/site-packages/docker_registry/search.py\", line 21, in get_search\r\n    results = INDEX.results(search_term=search_term)\r\n  File \"/Library/Python/2.7/site-packages/docker_registry/lib/index/db.py\", line 64, in _retry\r\n    raise e\r\nOperationalError: (OperationalError) no such table: repository u'SELECT repository.id AS repository_id, repository.name AS repository_name, repository.description AS repository_description \\nFROM repository' ()\r\n172.19.7.74 - - [24/Dec/2014:17:00:12 +0900] \"GET /v1/search HTTP/1.1\" 500 291 \"-\" \"curl/7.37.1\"\r\n```\r\n\r\nI work on Mac OS with boot2docker."},"comment":{"url":"https://api.github.com/repos/docker/docker-registry/issues/comments/69379873","html_url":"https://github.com/docker/docker-registry/issues/870#issuecomment-69379873","issue_url":"https://api.github.com/repos/docker/docker-registry/issues/870","id":69379873,"user":{"login":"dmp42","id":332946,"avatar_url":"https://avatars.githubusercontent.com/u/332946?v=3","gravatar_id":"","url":"https://api.github.com/users/dmp42","html_url":"https://github.com/dmp42","followers_url":"https://api.github.com/users/dmp42/followers","following_url":"https://api.github.com/users/dmp42/following{/other_user}","gists_url":"https://api.github.com/users/dmp42/gists{/gist_id}","starred_url":"https://api.github.com/users/dmp42/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dmp42/subscriptions","organizations_url":"https://api.github.com/users/dmp42/orgs","repos_url":"https://api.github.com/users/dmp42/repos","events_url":"https://api.github.com/users/dmp42/events{/privacy}","received_events_url":"https://api.github.com/users/dmp42/received_events","type":"User","site_admin":false},"created_at":"2015-01-09T18:51:39Z","updated_at":"2015-01-09T18:51:39Z","body":"Happy we got this working!\r\nKeep me posted on your progress."}}