ERROR: relation "public.timelogs" does not exist

Summary

when restore from a backup file, there are errors, but finally, the restore succeeds, and find no exception

Steps to reproduce

  1. sudo gitlab-rake gitlab:backup:create
  2. sudo gitlab-ctl stop unicorn
  3. sudo gitlab-ctl stop sidekiq

Verify

  1. sudo gitlab-ctl status
  2. sudo gitlab-rake gitlab:backup:restore BACKUP=1491873415_2017_04_11

What is the current bug behavior?

there is no error for step1 to step 4, but in step 5, error occurs

image

What is the expected correct behavior?

No error

Relevant logs and/or screenshots

(Paste any relevant logs - please use code blocks (```) to format console output, logs, and code as it's very hard to read otherwise.)

Output of checks

(If you are reporting a bug on GitLab.com, write: This bug happens on GitLab.com)

Results of GitLab environment info

(For installations with omnibus-gitlab package run and paste the output of: image

Results of GitLab application Check

(For installations with omnibus-gitlab package run and paste the output of: sudo gitlab-rake gitlab:check SANITIZE=true) Checking GitLab Shell ...

GitLab Shell version >= 5.0.0 ? ... OK (5.0.0) Repo base directory exists? default... yes Repo storage directories are symlinks? default... no Repo paths owned by git:git? default... yes Repo paths access is drwxrws---? default... yes hooks directories in repos are links: ... 3/2 ... ok 4/14 ... ok 3/19 ... repository is empty 3/20 ... ok 13/21 ... ok 3/22 ... ok 7/23 ... ok 8/24 ... repository is empty 1/25 ... repository is empty 1/26 ... repository is empty 1/27 ... repository is empty 1/28 ... repository is empty 1/29 ... repository is empty 8/30 ... ok 8/31 ... ok 8/33 ... ok 1/34 ... repository is empty 1/35 ... repository is empty 1/36 ... repository is empty 1/37 ... repository is empty 8/38 ... ok 1/39 ... repository is empty 1/40 ... repository is empty 1/41 ... repository is empty 1/42 ... repository is empty 1/43 ... repository is empty 1/44 ... repository is empty 1/45 ... repository is empty 1/46 ... repository is empty 1/47 ... repository is empty 1/48 ... repository is empty 1/49 ... repository is empty 1/50 ... repository is empty 1/51 ... repository is empty 1/52 ... repository is empty 1/53 ... repository is empty 1/54 ... repository is empty 1/55 ... repository is empty 1/56 ... repository is empty 1/57 ... repository is empty 1/58 ... repository is empty 1/59 ... repository is empty 1/60 ... repository is empty 1/61 ... repository is empty 1/62 ... repository is empty 1/63 ... repository is empty 1/64 ... repository is empty 1/65 ... repository is empty 1/66 ... repository is empty 1/67 ... repository is empty 1/68 ... repository is empty 1/69 ... repository is empty 1/70 ... repository is empty 1/71 ... repository is empty 1/72 ... repository is empty 1/73 ... repository is empty 1/74 ... repository is empty 1/75 ... repository is empty 1/76 ... repository is empty 1/77 ... repository is empty 1/78 ... repository is empty 1/79 ... repository is empty 1/80 ... repository is empty 9/81 ... ok 5/82 ... ok Running /opt/gitlab/embedded/service/gitlab-shell/bin/check Check GitLab API access: OK Access to /var/opt/gitlab/.ssh/authorized_keys: OK Send ping to redis server: OK gitlab-shell self-check successful

Checking GitLab Shell ... Finished

Checking Sidekiq ...

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

Checking Sidekiq ... Finished

Checking Reply by email ...

Reply by email is disabled in config/gitlab.yml

Checking Reply by email ... Finished

Checking LDAP ...

Server: ldapmain LDAP authentication... Success LDAP users with access to your GitLab server (only showing the first 100 results)

    DN: CN=Cao Lei(10xxx),OU=xx,OU=Users,OU=xxx,OU=LDA,DC=v01,DC=net        sAMAccountName:xxxx

Checking LDAP ... Finished

Checking GitLab ...

Git configured with autocrlf=input? ... yes Database config exists? ... yes All migrations up? ... yes Database contains orphaned GroupMembers? ... no GitLab config exists? ... yes GitLab config outdated? ... no Log directory writable? ... yes Tmp directory writable? ... yes Uploads directory setup correctly? ... skipped (no tmp uploads folder yet) Init script exists? ... skipped (omnibus-gitlab has no init script) Init script up-to-date? ... skipped (omnibus-gitlab has no init script) projects have namespace: ... 3/2 ... yes 4/14 ... yes 3/19 ... yes 3/20 ... yes 13/21 ... yes 3/22 ... yes 7/23 ... yes 8/24 ... yes 1/25 ... yes 1/26 ... yes 1/27 ... yes 1/28 ... yes 1/29 ... yes 8/30 ... yes 8/31 ... yes 8/33 ... yes 1/34 ... yes 1/35 ... yes 1/36 ... yes 1/37 ... yes 8/38 ... yes 1/39 ... yes 1/40 ... yes 1/41 ... yes 1/42 ... yes 1/43 ... yes 1/44 ... yes 1/45 ... yes 1/46 ... yes 1/47 ... yes 1/48 ... yes 1/49 ... yes 1/50 ... yes 1/51 ... yes 1/52 ... yes 1/53 ... yes 1/54 ... yes 1/55 ... yes 1/56 ... yes 1/57 ... yes 1/58 ... yes 1/59 ... yes 1/60 ... yes 1/61 ... yes 1/62 ... yes 1/63 ... yes 1/64 ... yes 1/65 ... yes 1/66 ... yes 1/67 ... yes 1/68 ... yes 1/69 ... yes 1/70 ... yes 1/71 ... yes 1/72 ... yes 1/73 ... yes 1/74 ... yes 1/75 ... yes 1/76 ... yes 1/77 ... yes 1/78 ... yes 1/79 ... yes 1/80 ... yes 9/81 ... yes 5/82 ... yes Redis version >= 2.8.0? ... yes Ruby version >= 2.1.0 ? ... yes (2.3.3) Your git bin path is "/opt/gitlab/embedded/bin/git" Git version >= 2.7.3 ? ... yes (2.10.2) Active users: 6

Checking GitLab ... Finished

Possible fixes

(If you can, link to the line of code that might be responsible for the problem)