Skip to content

GitLab

  • Menu
Projects Groups Snippets
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
  • G gitlabhq1
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 21
    • Issues 21
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 12
    • Merge requests 12
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Monitor
    • Monitor
    • Incidents
  • Packages & Registries
    • Packages & Registries
    • Package Registry
    • Infrastructure Registry
  • Analytics
    • Analytics
    • CI/CD
    • Repository
    • Value stream
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • gpt
  • large_projects
  • gitlabhq1
  • Issues
  • #6067

Closed
Open
Created Jan 15, 2014 by Administrator@rootOwner

[6.4.3] Backup restore failure using Postgres

Created by: d1

I'm loving all the new features in 6.4, but the need for reliable backups is keeping me from rolling it into production.

When restoring a test backup made from a 6.4.3 instance to a freshly created 6.4.3 instance, the backup restore consistently fails with the following:

$ cd /home/git/gitlab
$ sudo -u git -H cp /vagrant/<timestamp>_gitlab_backup.tar tmp/backups
$ sudo -u git -H bundle exec rake gitlab:backup:restore RAILS_ENV=production force=yes
Unpacking backup ... done
Restoring database ...
SET
SET
SET
SET
SET
CREATE EXTENSION
psql:/home/git/gitlab/tmp/backups/db/database.sql:22: ERROR:  must be owner of extension plpgsql
SET
SET
SET
psql:/home/git/gitlab/tmp/backups/db/database.sql:43: ERROR:  relation "broadcast_messages" already exists
ALTER TABLE
psql:/home/git/gitlab/tmp/backups/db/database.sql:57: ERROR:  relation "broadcast_messages_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
psql:/home/git/gitlab/tmp/backups/db/database.sql:79: ERROR:  relation "deploy_keys_projects" already exists
ALTER TABLE
psql:/home/git/gitlab/tmp/backups/db/database.sql:93: ERROR:  relation "deploy_keys_projects_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
psql:/home/git/gitlab/tmp/backups/db/database.sql:120: ERROR:  relation "events" already exists
ALTER TABLE
psql:/home/git/gitlab/tmp/backups/db/database.sql:134: ERROR:  relation "events_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
psql:/home/git/gitlab/tmp/backups/db/database.sql:156: ERROR:  relation "forked_project_links" already exists
ALTER TABLE
psql:/home/git/gitlab/tmp/backups/db/database.sql:170: ERROR:  relation "forked_project_links_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
psql:/home/git/gitlab/tmp/backups/db/database.sql:200: ERROR:  relation "issues" already exists
ALTER TABLE
psql:/home/git/gitlab/tmp/backups/db/database.sql:214: ERROR:  relation "issues_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
psql:/home/git/gitlab/tmp/backups/db/database.sql:239: ERROR:  relation "keys" already exists
ALTER TABLE
psql:/home/git/gitlab/tmp/backups/db/database.sql:253: ERROR:  relation "keys_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
psql:/home/git/gitlab/tmp/backups/db/database.sql:287: ERROR:  relation "merge_requests" already exists
ALTER TABLE
psql:/home/git/gitlab/tmp/backups/db/database.sql:301: ERROR:  relation "merge_requests_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
psql:/home/git/gitlab/tmp/backups/db/database.sql:327: ERROR:  relation "milestones" already exists
ALTER TABLE
psql:/home/git/gitlab/tmp/backups/db/database.sql:341: ERROR:  relation "milestones_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
psql:/home/git/gitlab/tmp/backups/db/database.sql:366: ERROR:  relation "namespaces" already exists
ALTER TABLE
psql:/home/git/gitlab/tmp/backups/db/database.sql:380: ERROR:  relation "namespaces_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
psql:/home/git/gitlab/tmp/backups/db/database.sql:410: ERROR:  relation "notes" already exists
ALTER TABLE
psql:/home/git/gitlab/tmp/backups/db/database.sql:424: ERROR:  relation "notes_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
psql:/home/git/gitlab/tmp/backups/db/database.sql:461: ERROR:  relation "projects" already exists
ALTER TABLE
psql:/home/git/gitlab/tmp/backups/db/database.sql:475: ERROR:  relation "projects_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
psql:/home/git/gitlab/tmp/backups/db/database.sql:497: ERROR:  relation "protected_branches" already exists
ALTER TABLE
psql:/home/git/gitlab/tmp/backups/db/database.sql:511: ERROR:  relation "protected_branches_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
psql:/home/git/gitlab/tmp/backups/db/database.sql:529: ERROR:  relation "schema_migrations" already exists
ALTER TABLE
psql:/home/git/gitlab/tmp/backups/db/database.sql:551: ERROR:  relation "services" already exists
ALTER TABLE
psql:/home/git/gitlab/tmp/backups/db/database.sql:565: ERROR:  relation "services_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
psql:/home/git/gitlab/tmp/backups/db/database.sql:593: ERROR:  relation "snippets" already exists
ALTER TABLE
psql:/home/git/gitlab/tmp/backups/db/database.sql:607: ERROR:  relation "snippets_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
psql:/home/git/gitlab/tmp/backups/db/database.sql:632: ERROR:  relation "taggings" already exists
ALTER TABLE
psql:/home/git/gitlab/tmp/backups/db/database.sql:646: ERROR:  relation "taggings_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
psql:/home/git/gitlab/tmp/backups/db/database.sql:665: ERROR:  relation "tags" already exists
ALTER TABLE
psql:/home/git/gitlab/tmp/backups/db/database.sql:679: ERROR:  relation "tags_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
psql:/home/git/gitlab/tmp/backups/db/database.sql:736: ERROR:  relation "users" already exists
ALTER TABLE
psql:/home/git/gitlab/tmp/backups/db/database.sql:753: ERROR:  relation "users_groups" already exists
ALTER TABLE
psql:/home/git/gitlab/tmp/backups/db/database.sql:767: ERROR:  relation "users_groups_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
psql:/home/git/gitlab/tmp/backups/db/database.sql:788: ERROR:  relation "users_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
psql:/home/git/gitlab/tmp/backups/db/database.sql:812: ERROR:  relation "users_projects" already exists
ALTER TABLE
psql:/home/git/gitlab/tmp/backups/db/database.sql:826: ERROR:  relation "users_projects_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
psql:/home/git/gitlab/tmp/backups/db/database.sql:853: ERROR:  relation "web_hooks" already exists
ALTER TABLE
psql:/home/git/gitlab/tmp/backups/db/database.sql:867: ERROR:  relation "web_hooks_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
     52
(1 row)

 setval
--------
      2
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      2
(1 row)

 setval
--------
      2
(1 row)

 setval
--------
      1
(1 row)

psql:/home/git/gitlab/tmp/backups/db/database.sql:1189: ERROR:  duplicate key value violates unique constraint "namespaces_pkey"
DETAIL:  Key (id)=(1) already exists.
CONTEXT:  COPY namespaces, line 1: "1   root    root    1   2013-12-20 19:59:09.477788  2013-12-20 19:59:09.477788  \N  "
 setval
--------
      5
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      9
(1 row)

 setval
--------
      1
(1 row)

psql:/home/git/gitlab/tmp/backups/db/database.sql:1416: ERROR:  duplicate key value violates unique constraint "unique_schema_migrations"
DETAIL:  Key (version)=(20131217102743) already exists.
CONTEXT:  COPY schema_migrations, line 1: "20131217102743"
 setval
--------
     14
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

psql:/home/git/gitlab/tmp/backups/db/database.sql:1502: ERROR:  duplicate key value violates unique constraint "users_pkey"
DETAIL:  Key (id)=(1) already exists.
CONTEXT:  COPY users, line 1: "1    [email protected]    [FILTERED]  \N  \N  \N  0   \N  \N  \N  ..."
 setval
--------
      3
(1 row)

 setval
--------
      4
(1 row)

 setval
--------
     14
(1 row)

 setval
--------
      1
(1 row)

psql:/home/git/gitlab/tmp/backups/db/database.sql:1575: ERROR:  multiple primary keys for table "broadcast_messages" are not allowed
psql:/home/git/gitlab/tmp/backups/db/database.sql:1583: ERROR:  multiple primary keys for table "deploy_keys_projects" are not allowed
psql:/home/git/gitlab/tmp/backups/db/database.sql:1591: ERROR:  multiple primary keys for table "events" are not allowed
psql:/home/git/gitlab/tmp/backups/db/database.sql:1599: ERROR:  multiple primary keys for table "forked_project_links" are not allowed
psql:/home/git/gitlab/tmp/backups/db/database.sql:1607: ERROR:  multiple primary keys for table "issues" are not allowed
psql:/home/git/gitlab/tmp/backups/db/database.sql:1615: ERROR:  multiple primary keys for table "keys" are not allowed
psql:/home/git/gitlab/tmp/backups/db/database.sql:1623: ERROR:  multiple primary keys for table "merge_requests" are not allowed
psql:/home/git/gitlab/tmp/backups/db/database.sql:1631: ERROR:  multiple primary keys for table "milestones" are not allowed
psql:/home/git/gitlab/tmp/backups/db/database.sql:1639: ERROR:  multiple primary keys for table "namespaces" are not allowed
psql:/home/git/gitlab/tmp/backups/db/database.sql:1647: ERROR:  multiple primary keys for table "notes" are not allowed
psql:/home/git/gitlab/tmp/backups/db/database.sql:1655: ERROR:  multiple primary keys for table "projects" are not allowed
psql:/home/git/gitlab/tmp/backups/db/database.sql:1663: ERROR:  multiple primary keys for table "protected_branches" are not allowed
psql:/home/git/gitlab/tmp/backups/db/database.sql:1671: ERROR:  multiple primary keys for table "services" are not allowed
psql:/home/git/gitlab/tmp/backups/db/database.sql:1679: ERROR:  multiple primary keys for table "snippets" are not allowed
psql:/home/git/gitlab/tmp/backups/db/database.sql:1687: ERROR:  multiple primary keys for table "taggings" are not allowed
psql:/home/git/gitlab/tmp/backups/db/database.sql:1695: ERROR:  multiple primary keys for table "tags" are not allowed
psql:/home/git/gitlab/tmp/backups/db/database.sql:1703: ERROR:  multiple primary keys for table "users_groups" are not allowed
psql:/home/git/gitlab/tmp/backups/db/database.sql:1711: ERROR:  multiple primary keys for table "users" are not allowed
psql:/home/git/gitlab/tmp/backups/db/database.sql:1719: ERROR:  multiple primary keys for table "users_projects" are not allowed
psql:/home/git/gitlab/tmp/backups/db/database.sql:1727: ERROR:  multiple primary keys for table "web_hooks" are not allowed
psql:/home/git/gitlab/tmp/backups/db/database.sql:1734: ERROR:  relation "index_deploy_keys_projects_on_project_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1741: ERROR:  relation "index_events_on_action" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1748: ERROR:  relation "index_events_on_author_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1755: ERROR:  relation "index_events_on_created_at" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1762: ERROR:  relation "index_events_on_project_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1769: ERROR:  relation "index_events_on_target_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1776: ERROR:  relation "index_events_on_target_type" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1783: ERROR:  relation "index_forked_project_links_on_forked_to_project_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1790: ERROR:  relation "index_issues_on_assignee_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1797: ERROR:  relation "index_issues_on_author_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1804: ERROR:  relation "index_issues_on_created_at" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1811: ERROR:  relation "index_issues_on_milestone_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1818: ERROR:  relation "index_issues_on_project_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1825: ERROR:  relation "index_issues_on_title" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1832: ERROR:  relation "index_keys_on_user_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1839: ERROR:  relation "index_merge_requests_on_assignee_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1846: ERROR:  relation "index_merge_requests_on_author_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1853: ERROR:  relation "index_merge_requests_on_created_at" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1860: ERROR:  relation "index_merge_requests_on_milestone_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1867: ERROR:  relation "index_merge_requests_on_project_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1874: ERROR:  relation "index_merge_requests_on_source_branch" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1881: ERROR:  relation "index_merge_requests_on_target_branch" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1888: ERROR:  relation "index_merge_requests_on_title" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1895: ERROR:  relation "index_milestones_on_due_date" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1902: ERROR:  relation "index_milestones_on_project_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1909: ERROR:  relation "index_namespaces_on_name" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1916: ERROR:  relation "index_namespaces_on_owner_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1923: ERROR:  relation "index_namespaces_on_path" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1930: ERROR:  relation "index_namespaces_on_type" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1937: ERROR:  relation "index_notes_on_author_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1944: ERROR:  relation "index_notes_on_commit_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1951: ERROR:  relation "index_notes_on_created_at" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1958: ERROR:  relation "index_notes_on_noteable_id_and_noteable_type" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1965: ERROR:  relation "index_notes_on_noteable_type" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1972: ERROR:  relation "index_notes_on_project_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1979: ERROR:  relation "index_notes_on_project_id_and_noteable_type" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1986: ERROR:  relation "index_projects_on_last_activity_at" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:1993: ERROR:  relation "index_projects_on_namespace_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2000: ERROR:  relation "index_projects_on_owner_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2007: ERROR:  relation "index_protected_branches_on_project_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2014: ERROR:  relation "index_services_on_project_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2021: ERROR:  relation "index_snippets_on_author_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2028: ERROR:  relation "index_snippets_on_created_at" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2035: ERROR:  relation "index_snippets_on_expires_at" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2042: ERROR:  relation "index_snippets_on_project_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2049: ERROR:  relation "index_taggings_on_tag_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2056: ERROR:  relation "index_taggings_on_taggable_id_and_taggable_type_and_context" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2063: ERROR:  relation "index_users_groups_on_user_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2070: ERROR:  relation "index_users_on_admin" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2077: ERROR:  relation "index_users_on_authentication_token" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2084: ERROR:  relation "index_users_on_confirmation_token" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2091: ERROR:  relation "index_users_on_email" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2098: ERROR:  relation "index_users_on_extern_uid_and_provider" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2105: ERROR:  relation "index_users_on_name" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2112: ERROR:  relation "index_users_on_reset_password_token" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2119: ERROR:  relation "index_users_on_username" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2126: ERROR:  relation "index_users_projects_on_project_access" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2133: ERROR:  relation "index_users_projects_on_project_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2140: ERROR:  relation "index_users_projects_on_user_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2147: ERROR:  relation "index_web_hooks_on_project_id" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2154: ERROR:  relation "unique_schema_migrations" already exists
psql:/home/git/gitlab/tmp/backups/db/database.sql:2161: WARNING:  no privileges could be revoked for "public"
REVOKE
psql:/home/git/gitlab/tmp/backups/db/database.sql:2162: WARNING:  no privileges could be revoked for "public"
REVOKE
psql:/home/git/gitlab/tmp/backups/db/database.sql:2163: WARNING:  no privileges were granted for "public"
GRANT
psql:/home/git/gitlab/tmp/backups/db/database.sql:2164: WARNING:  no privileges were granted for "public"
GRANT
done
Restoring repositories ...
repo_one ... [FAILED]
repo_two ... [FAILED]
repo_three ... [FAILED]
repo_four ... [FAILED]
Put GitLab hooks in repositories dirs [DONE]
done
Restoring uploads ...
done
..Deleting tmp directories ... done

Before running the above, the gitlab:check task will pass all checks:

$ sudo -u git -H bundle exec rake gitlab:check RAILS_ENV=production
Checking Environment ...

Git configured for git user? ... yes
Has python2? ... yes
python2 is supported version? ... yes

Checking Environment ... Finished

Checking GitLab Shell ...

GitLab Shell version >= 1.7.9 ? ... OK (1.8.0)
Repo base directory exists? ... yes
Repo base directory is a symlink? ... no
Repo base owned by git:git? ... yes
Repo base access is drwxrws---? ... yes
update hook up-to-date? ... yes
update hooks in repos are links: ... can't check, you have no projects
Running /home/git/gitlab-shell/bin/check
Check GitLab API access: OK
Check directories and files:
        /home/git/repositories: OK
        /home/git/.ssh/authorized_keys: OK
Test redis-cli executable: redis-cli 2.2.12
Send ping to redis server: PONG
gitlab-shell self-check successful

Checking GitLab Shell ... Finished

Checking Sidekiq ...

Running? ... yes
Number of Sidekiq processes ... 1

Checking Sidekiq ... Finished

Checking LDAP ...

LDAP users with access to your GitLab server (limit: 100):
[FILTERED]

Checking LDAP ... Finished

Checking GitLab ...

Database config exists? ... yes
Database is SQLite ... no
All migrations up? ... yes
GitLab config exists? ... yes
GitLab config outdated? ... no
Log directory writable? ... yes
Tmp directory writable? ... yes
Init script exists? ... yes
Init script up-to-date? ... yes
projects have namespace: ... can't check, you have no projects
Projects have satellites? ... can't check, you have no projects
Redis version >= 2.0.0? ... yes
Your git bin path is "/usr/local/bin/git"
Git version >= 1.7.10 ? ... yes (1.8.5)

Checking GitLab ... Finished

Afterwards, many failures:

$ sudo -u git -H bundle exec rake gitlab:check RAILS_ENV=production
Checking Environment ...

Git configured for git user? ... yes
Has python2? ... yes
python2 is supported version? ... yes

Checking Environment ... Finished

Checking GitLab Shell ...

GitLab Shell version >= 1.7.9 ? ... OK (1.8.0)
Repo base directory exists? ... yes
Repo base directory is a symlink? ... no
Repo base owned by git:git? ... yes
Repo base access is drwxrws---? ... no
  Try fixing it:
  sudo chmod -R ug+rwX,o-rwx /home/git/repositories/
  sudo chmod -R ug-s /home/git/repositories/
  find /home/git/repositories/ -type d -print0 | sudo xargs -0 chmod g+s
  For more information see:
  doc/install/installation.md in section "GitLab Shell"
  Please fix the error above and rerun the checks.
update hook up-to-date? ... yes
update hooks in repos are links: ...
repo_one ... repository is empty
repo_two ... repository is empty
repo_three ... repository is empty
repo_four ... repository is empty
Running /home/git/gitlab-shell/bin/check
Check GitLab API access: OK
Check directories and files:
    /home/git/repositories: OK
    /home/git/.ssh/authorized_keys: OK
Test redis-cli executable: redis-cli 2.2.12
Send ping to redis server: PONG
gitlab-shell self-check successful

Checking GitLab Shell ... Finished

Checking Sidekiq ...

Running? ... yes
Number of Sidekiq processes ... 1

Checking Sidekiq ... Finished

Checking LDAP ...

LDAP users with access to your GitLab server (limit: 100):
[FILTERED]

Checking LDAP ... Finished

Checking GitLab ...

Database config exists? ... yes
Database is SQLite ... no
All migrations up? ... yes
GitLab config exists? ... yes
GitLab config outdated? ... no
Log directory writable? ... yes
Tmp directory writable? ... yes
Init script exists? ... yes
Init script up-to-date? ... yes
projects have namespace: ...
repo_one ... no
  Try fixing it:
  Migrate global projects
  For more information see:
  doc/update/5.4-to-6.0.md in section "#global-projects"
  Please fix the error above and rerun the checks.
repo_two ... no
  Try fixing it:
  Migrate global projects
  For more information see:
  doc/update/5.4-to-6.0.md in section "#global-projects"
  Please fix the error above and rerun the checks.
repo_three ... no
  Try fixing it:
  Migrate global projects
  For more information see:
  doc/update/5.4-to-6.0.md in section "#global-projects"
  Please fix the error above and rerun the checks.
repo_three ... no
  Try fixing it:
  Migrate global projects
  For more information see:
  doc/update/5.4-to-6.0.md in section "#global-projects"
  Please fix the error above and rerun the checks.
repo_four ... no
  Try fixing it:
  Migrate global projects
  For more information see:
  doc/update/5.4-to-6.0.md in section "#global-projects"
  Please fix the error above and rerun the checks.
Projects have satellites? ...
repo_one ... can't create, repository is empty
repo_two ... can't create, repository is empty
repo_three ... can't create, repository is empty
repo_four ... can't create, repository is empty
Redis version >= 2.0.0? ... yes
Your git bin path is "/usr/local/bin/git"
Git version >= 1.7.10 ? ... yes (1.8.5)

Checking GitLab ... Finished

I've found that if I run the following "enhanced" backup restore procedure, it seems to work fine, but makes me very uneasy.

$ sudo -u git -H bundle exec rake db:setup RAILS_ENV=production
$ sudo -u git -H bundle exec rake gitlab:backup:restore RAILS_ENV=production force=yes
$ sudo -u git -H bundle exec rake gitlab:satellites:create RAILS_ENV=production

After using that method on a fresh instance, the only failure in the gitlab:check task is the permissions on /home/git/repositories/, but I think that may be a separate issue, e.g. #6064.

From the original backup restore errors, it seems like it could be a postgres configuration issue, but I've followed the installation/configuration instructions, all features are quite functional, and all checks are passing.

Is there something else I can check that would help diagnose this?

Thanks

Assignee
Assign to
Time tracking