{"action":"created","issue":{"url":"https://api.github.com/repos/chef/chef-server/issues/125","labels_url":"https://api.github.com/repos/chef/chef-server/issues/125/labels{/name}","comments_url":"https://api.github.com/repos/chef/chef-server/issues/125/comments","events_url":"https://api.github.com/repos/chef/chef-server/issues/125/events","html_url":"https://github.com/chef/chef-server/issues/125","id":60884308,"number":125,"title":"ERROR:  relation \"keys_by_name\" does not exist","user":{"login":"yves-vogl","id":21128,"avatar_url":"https://avatars.githubusercontent.com/u/21128?v=3","gravatar_id":"","url":"https://api.github.com/users/yves-vogl","html_url":"https://github.com/yves-vogl","followers_url":"https://api.github.com/users/yves-vogl/followers","following_url":"https://api.github.com/users/yves-vogl/following{/other_user}","gists_url":"https://api.github.com/users/yves-vogl/gists{/gist_id}","starred_url":"https://api.github.com/users/yves-vogl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yves-vogl/subscriptions","organizations_url":"https://api.github.com/users/yves-vogl/orgs","repos_url":"https://api.github.com/users/yves-vogl/repos","events_url":"https://api.github.com/users/yves-vogl/events{/privacy}","received_events_url":"https://api.github.com/users/yves-vogl/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-03-12T19:30:55Z","updated_at":"2015-03-12T20:45:28Z","closed_at":null,"body":"Hi,\r\n\r\nfrom one day to the other I was not able to log into the chef server.\r\nIt's the latest available version.\r\n\r\nThe postgres log complains about a missing relation. Could you please help?\r\n\r\n```\r\n==> /var/log/opscode/opscode-erchef/requests.log.5 <==\r\n2015-03-12T19:30:12Z erchef@127.0.0.1 method=POST; path=/authenticate_user; status=401; req_id=g3IAA2QAEGVyY2hlZkAxMjcuMC4wLjECAAAhiAAAAAAAAAAA; msg={error_finding_user_or_client,{syntax,{<<\"relation \\\"keys_by_name\\\" does not exi\"...>>,[{position,<<\"87\">>}]}}}; policies=false; couchdb_groups=false; couchdb_organizations=false; couchdb_containers=false; couchdb_acls=false; 503_mode=false; couchdb_associations=false; couchdb_association_requests=false; req_time=56; rdbms_time=0; rdbms_count=1; user=pivotal; \r\n\r\n==> /var/log/opscode/postgresql/9.2/current <==\r\n2015-03-12_19:30:33.26987 ERROR:  relation \"keys_by_name\" does not exist at character 87\r\n2015-03-12_19:30:33.26990 STATEMENT:  SELECT id, org_id, name, authz_id, type, key_name, public_key, key_version\r\n2015-03-12_19:30:33.26990 \t      FROM keys_by_name\r\n2015-03-12_19:30:33.26990 \t     WHERE (org_id = $1 OR org_id = 'global')\r\n2015-03-12_19:30:33.26990 \t       AND name = $2\r\n2015-03-12_19:30:33.26991 \t       AND expires_at > CURRENT_TIMESTAMP at time zone 'utc'\r\n2015-03-12_19:30:33.26991 \t     ORDER BY type DESC\r\n\r\n==> /var/log/opscode/nginx/access.log <==\r\n127.0.0.1 - - [12/Mar/2015:20:30:33 +0100]  \"GET /users HTTP/1.1\" 401 \"0.006\" 88 \"-\" \"Chef Knife/12.0.3 (ruby-2.1.4-p265; ohai-8.1.1; x86_64-linux; +http://opscode.com)\" \"127.0.0.1:8000\" \"401\" \"0.005\" \"12.0.3\" \"algorithm=sha1;version=1.0;\" \"pivotal\" \"2015-03-12T19:30:33Z\" \"2jmj7l5rSw0yVb/vlWAYkK/YBwk=\" 973\r\n\r\n==> /var/log/opscode/opscode-erchef/crash.log <==\r\n2015-03-12 20:30:33 =ERROR REPORT====\r\n{<<\"method=GET; path=/users; status=401; \">>,\"Unauthorized\"}\r\n==> /var/log/opscode/opscode-erchef/erchef.log <==\r\n2015-03-12 20:30:33.270 [error] {<<\"method=GET; path=/users; status=401; \">>,\"Unauthorized\"}\r\n```"},"comment":{"url":"https://api.github.com/repos/chef/chef-server/issues/comments/78608763","html_url":"https://github.com/chef/chef-server/issues/125#issuecomment-78608763","issue_url":"https://api.github.com/repos/chef/chef-server/issues/125","id":78608763,"user":{"login":"yves-vogl","id":21128,"avatar_url":"https://avatars.githubusercontent.com/u/21128?v=3","gravatar_id":"","url":"https://api.github.com/users/yves-vogl","html_url":"https://github.com/yves-vogl","followers_url":"https://api.github.com/users/yves-vogl/followers","following_url":"https://api.github.com/users/yves-vogl/following{/other_user}","gists_url":"https://api.github.com/users/yves-vogl/gists{/gist_id}","starred_url":"https://api.github.com/users/yves-vogl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yves-vogl/subscriptions","organizations_url":"https://api.github.com/users/yves-vogl/orgs","repos_url":"https://api.github.com/users/yves-vogl/repos","events_url":"https://api.github.com/users/yves-vogl/events{/privacy}","received_events_url":"https://api.github.com/users/yves-vogl/received_events","type":"User","site_admin":false},"created_at":"2015-03-12T20:45:28Z","updated_at":"2015-03-12T20:45:28Z","body":"It was originally chef-11 server and successfully upgraded."}}