{"action":"created","issue":{"url":"https://api.github.com/repos/gitlabhq/gitlabhq/issues/9766","labels_url":"https://api.github.com/repos/gitlabhq/gitlabhq/issues/9766/labels{/name}","comments_url":"https://api.github.com/repos/gitlabhq/gitlabhq/issues/9766/comments","events_url":"https://api.github.com/repos/gitlabhq/gitlabhq/issues/9766/events","html_url":"https://github.com/gitlabhq/gitlabhq/issues/9766","id":113088536,"number":9766,"title":"Omnibus upgrade fails to connect to Postgres","user":{"login":"shampine","id":1027737,"avatar_url":"https://avatars.githubusercontent.com/u/1027737?v=3","gravatar_id":"","url":"https://api.github.com/users/shampine","html_url":"https://github.com/shampine","followers_url":"https://api.github.com/users/shampine/followers","following_url":"https://api.github.com/users/shampine/following{/other_user}","gists_url":"https://api.github.com/users/shampine/gists{/gist_id}","starred_url":"https://api.github.com/users/shampine/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shampine/subscriptions","organizations_url":"https://api.github.com/users/shampine/orgs","repos_url":"https://api.github.com/users/shampine/repos","events_url":"https://api.github.com/users/shampine/events{/privacy}","received_events_url":"https://api.github.com/users/shampine/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-10-23T19:53:55Z","updated_at":"2015-10-23T20:04:09Z","closed_at":null,"body":"Using version 8.0.1 and running the Omnibus upgrade to either 8.0.5 or 8.1 both fail stating postgres cannot connect.\r\n\r\nSpecs:\r\nUbuntu 14.04, only application on the server is Gitlab\r\n\r\nSteps:\r\n```\r\napt-get update\r\napt-get upgrade\r\n```\r\n\r\nError:\r\n```\r\nPG::Error: could not connect to server: No such file or directory\r\n        Is the server running locally and accepting\r\n        connections on Unix domain socket \"/tmp/.s.PGSQL.5342\"?\r\n```\r\n\r\nAfter the error is returned it leaves Gitlab in a broken non-working state, running reconfigure or any other tools just spike the gitlab process to 100% cpu. Currently stuck on version 8.0.1.\r\n\r\nSimilar issue: https://gitlab.com/gitlab-org/omnibus-gitlab/issues/474\r\n\r\n\r\nGoing to spin up a new VPS right now with an image and dump the entire error log out for the issue."},"comment":{"url":"https://api.github.com/repos/gitlabhq/gitlabhq/issues/comments/150676545","html_url":"https://github.com/gitlabhq/gitlabhq/issues/9766#issuecomment-150676545","issue_url":"https://api.github.com/repos/gitlabhq/gitlabhq/issues/9766","id":150676545,"user":{"login":"shampine","id":1027737,"avatar_url":"https://avatars.githubusercontent.com/u/1027737?v=3","gravatar_id":"","url":"https://api.github.com/users/shampine","html_url":"https://github.com/shampine","followers_url":"https://api.github.com/users/shampine/followers","following_url":"https://api.github.com/users/shampine/following{/other_user}","gists_url":"https://api.github.com/users/shampine/gists{/gist_id}","starred_url":"https://api.github.com/users/shampine/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shampine/subscriptions","organizations_url":"https://api.github.com/users/shampine/orgs","repos_url":"https://api.github.com/users/shampine/repos","events_url":"https://api.github.com/users/shampine/events{/privacy}","received_events_url":"https://api.github.com/users/shampine/received_events","type":"User","site_admin":false},"created_at":"2015-10-23T20:04:09Z","updated_at":"2015-10-23T20:04:09Z","body":"Full error output:\r\n\r\n```\r\nPreparing to unpack .../gitlab-ce_8.1.0-ce.1_amd64.deb ...\r\ngitlab preinstall: Backing up GitLab SQL database (excluding Git repositories, uploads)\r\nDumping database ... \r\nDumping PostgreSQL database gitlabhq_production ... pg_dump: [archiver (db)] connection to database \"gitlabhq_production\" failed: could not connect to server: No such file or directory\r\n\tIs the server running locally and accepting\r\n\tconnections on Unix domain socket \"/var/opt/gitlab/postgresql/.s.PGSQL.5432\"?\r\n[FAILED]\r\nBackup failed\r\ngitlab preinstall: \r\ngitlab preinstall: Backup failed! If you want to skip this backup, run the following command and\r\ngitlab preinstall: try again:\r\ngitlab preinstall: \r\ngitlab preinstall:   sudo touch /etc/gitlab/skip-auto-migrations\r\ngitlab preinstall: \r\ndpkg: error processing archive /var/cache/apt/archives/gitlab-ce_8.1.0-ce.1_amd64.deb (--unpack):\r\n subprocess new pre-installation script returned error exit status 1\r\ngitlab: Thank you for installing GitLab!\r\ngitlab: To configure and start GitLab, RUN THE FOLLOWING COMMAND:\r\n\r\nsudo gitlab-ctl reconfigure\r\n\r\ngitlab: GitLab should be reachable at http://git.gunnjerkens.com\r\ngitlab: Otherwise configure GitLab for your system by editing /etc/gitlab/gitlab.rb file\r\ngitlab: And running reconfigure again.\r\ngitlab: \r\ngitlab: For a comprehensive list of configuration options please see the Omnibus GitLab readme\r\ngitlab: https://gitlab.com/gitlab-org/omnibus-gitlab/blob/master/README.md\r\ngitlab: \r\nProcessing triggers for man-db (2.6.7.1-1ubuntu1) ...\r\nProcessing triggers for ureadahead (0.100.0-16) ...\r\nProcessing triggers for shared-mime-info (1.2-0ubuntu3) ...\r\nErrors were encountered while processing:\r\n /var/cache/apt/archives/gitlab-ce_8.1.0-ce.1_amd64.deb\r\nE: Sub-process /usr/bin/dpkg returned an error code (1)\r\n```"}}