Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

issues when migrating from sameersbn/gitlab:9.4.3 to gitlab/gitlab-ce:9.4.3-ce.0 #15

Open
colinbrownec opened this issue Aug 11, 2017 · 1 comment

Comments

@colinbrownec
Copy link

I had been using the docker container by sameersbn, until GitLab made their official omnibus docker container.

I encountered a couple of issue's along the way.

Some quick background, I updated from 9.1.3 -> 9.4.3 using sameersbn/gitlab on a MySQL database and then converted the MySQL database from 9.4.3 to a Postgres database to restore from.

After following the instructions in this projects README and this document. I had to make the following changes to be able to import the database into Postgres.

  1. The wrong binary type is used when creating table merge_request_diff_commits
    "sha" varbinary(20) NOT NULL,

The correct binary type for Postgres should by bytea

    "sha" bytea NOT NULL,
  1. Several '0000-00-00 00:00:00' timestamps are not replaced when creating tables ci_group_variables, ci_pipeline_schedule_variables, and merge_request_diff_commits
    "updated_at" timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',

I replace all null timestamps with CURRENT_TIMESTAMP since the fields were also marked as non-null

    "updated_at" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

But at the end of the day I had a working database, thanks for the work!

@Tsubashi
Copy link

Had the same issue, except I was migrating from a source install with MySQL to the docker version.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

2 participants