{"action":"closed","issue":{"url":"https://api.github.com/repos/sameersbn/docker-gitlab/issues/982","repository_url":"https://api.github.com/repos/sameersbn/docker-gitlab","labels_url":"https://api.github.com/repos/sameersbn/docker-gitlab/issues/982/labels{/name}","comments_url":"https://api.github.com/repos/sameersbn/docker-gitlab/issues/982/comments","events_url":"https://api.github.com/repos/sameersbn/docker-gitlab/issues/982/events","html_url":"https://github.com/sameersbn/docker-gitlab/issues/982","id":191738919,"number":982,"title":"Issue after upgrading sameersbn/docker-gitlab from 8.3.1 to 8.13.6 (and sameersbn/docker-postgressql from 9.1-2 to 9.5-3)","user":{"login":"ThomBogers","id":6039807,"avatar_url":"https://avatars.githubusercontent.com/u/6039807?v=3","gravatar_id":"","url":"https://api.github.com/users/ThomBogers","html_url":"https://github.com/ThomBogers","followers_url":"https://api.github.com/users/ThomBogers/followers","following_url":"https://api.github.com/users/ThomBogers/following{/other_user}","gists_url":"https://api.github.com/users/ThomBogers/gists{/gist_id}","starred_url":"https://api.github.com/users/ThomBogers/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ThomBogers/subscriptions","organizations_url":"https://api.github.com/users/ThomBogers/orgs","repos_url":"https://api.github.com/users/ThomBogers/repos","events_url":"https://api.github.com/users/ThomBogers/events{/privacy}","received_events_url":"https://api.github.com/users/ThomBogers/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-11-25T16:47:02Z","updated_at":"2016-11-28T09:52:10Z","closed_at":"2016-11-28T09:52:10Z","body":"After following the upgrade guide I get a 500 error on my gitlab. \r\nWith postgres outputting the following log, and the last error repeating for all projects:\r\n\r\n```\r\nInitializing datadir...\r\nInitializing certdir...\r\nInitializing logdir...\r\nInitializing rundir...\r\nSetting resolv.conf ACLs...\r\nInitializing database...\r\n‣ Migrating PostgreSQL 9.4 data to 9.5...\r\n‣ Installing PostgreSQL 9.4...\r\nBuilding PostgreSQL dictionaries from installed myspell/hunspell packages...\r\nRemoving obsolete dictionary files:\r\nCreating new cluster 9.4/main ...\r\n  config /etc/postgresql/9.4/main\r\n  data   /var/lib/postgresql/9.4/main\r\n  locale C.UTF-8\r\n  socket /var/run/postgresql\r\n  port   5432\r\ninvoke-rc.d: policy-rc.d denied execution of start.\r\n‣ Migration in progress. Please be patient...\r\nConfiguring hot standby...\r\n‣ Setting postgresql.conf parameter: wal_level = 'hot_standby'\r\n‣ Setting postgresql.conf parameter: max_wal_senders = '16'\r\n‣ Setting postgresql.conf parameter: checkpoint_segments = '8'\r\n‣ Setting postgresql.conf parameter: wal_keep_segments = '32'\r\n‣ Setting postgresql.conf parameter: hot_standby = 'on'\r\n‣ Setting postgresql.conf parameter: data_directory = '/var/lib/postgresql/9.5/main'\r\n‣ Setting postgresql.conf parameter: log_directory = '/var/log/postgresql'\r\n‣ Setting postgresql.conf parameter: log_filename = 'postgresql-9.5-main.log'\r\n‣ Setting postgresql.conf parameter: ssl = 'off'\r\nCreating database user: gitlab_user\r\nCreating database: gitlab_db...\r\n‣ Loading pg_trgm extension...\r\n‣ Granting access to gitlab_user user...\r\nStarting PostgreSQL 9.5...\r\nLOG:  database system was shut down at 2016-11-25 13:48:31 UTC\r\nLOG:  MultiXact member wraparound protections are now enabled\r\nLOG:  database system is ready to accept connections\r\nLOG:  autovacuum launcher started\r\nERROR:  column namespaces.deleted_at does not exist at character 115\r\nSTATEMENT:  SELECT  \"projects\".* FROM \"projects\" INNER JOIN \"namespaces\" ON \"namespaces\".\"id\" = \"projects\".\"namespace_id\" AND \"namespaces\".\"deleted_at\" IS NULL WHERE \"projects\".\"pending_delete\" = 'f' AND ((\r\n\t            (namespaces.path = 'company'\r\n\t          AND projects.path = 'project')\r\n\t            OR (\r\n\t              LOWER(namespaces.path) = LOWER('company')\r\n\t              AND LOWER(projects.path) = LOWER('project')\r\n\t            )\r\n\t          ))  ORDER BY (CASE WHEN  namespaces.path = 'company' AND  projects.path = 'project' THEN 0 ELSE 1 END) LIMIT 1\r\n```\r\n\r\nI have tried restoring a backup to the new postgres server, but this gives the error: \r\n```\r\n\r\nERROR:  must be owner of extension plpgsql\r\nERROR:  must be owner of schema public\r\nERROR:  schema \"public\" already exists\r\nALTER SCHEMA\r\nERROR:  must be owner of schema public\r\nCREATE EXTENSION\r\nERROR:  must be owner of extension plpgsql\r\n```\r\n \r\nAfter Increasing the permissions for the gitlab_user this gives this error:\r\n```\r\nERROR:  cannot drop schema public because other objects depend on it\r\nDETAIL:  extension pg_trgm depends on schema public\r\nHINT:  Use DROP ... CASCADE to drop the dependent objects too.\r\nERROR:  schema \"public\" already exists\r\n```\r\n\r\nHow do I fix this?"}}
{"actor":{"display_login":"ThomBogers"}}