Displayed projects creation dates reset after hashed storage migration
Summary
Since hashed storage migration was carried out on my gitlab instance, all the projects in the Group UI are displaying creation dates dating back to the migration date, at most.
Steps to reproduce
Didn't get to reproduce it but I guess I could try to migrate back to legacy storage and redo the migration.
What is the current bug behavior?
As per Gitlab recommendations I ran the hashed storage migration for my Gitlab instances, running v13.0.3.
However, it seems that a side effect of the migration is that projects creation dates displayed in the Group UI projects list (eg. https://gitlab.tld/my-group?sort=created_asc) displays all projects with creation dates starting at the time of the hashed storage migration.
I believe that the date displayed here is taken from the actual storage system timestamps rather than from the project creation date registered in the database. If I run a Gitlab project API call on a project I actually get the correct creation date.
What is the expected correct behavior?
The projects creation dates displayed in this view should be the actual projects creation dates.
Relevant logs and/or screenshots
My instance has around 6k projects and dates back to 2014.
Output of checks
I'm running Gitlab Omnibus v13.0.3 as a docker container.
Results of GitLab environment info
Expand for output related to GitLab environment info
# gitlab-rake gitlab:env:info System information System: Current User: git Using RVM: no Ruby Version: 2.6.6p146 Gem Version: 2.7.10 Bundler Version:1.17.3 Rake Version: 12.3.3 Redis Version: 5.0.9 Git Version: 2.26.2 Sidekiq Version:5.2.7 Go Version: unknown GitLab information Version: 13.0.3 Revision: e2397fc2acb Directory: /opt/gitlab/embedded/service/gitlab-rails DB Adapter: PostgreSQL DB Version: 12.3 URL: https://gitlab.tld HTTP Clone URL: https://gitlab.tld/some-group/some-project.git SSH Clone URL: git@gitlab.tld:some-group/some-project.git Using LDAP: no Using Omniauth: yes Omniauth Providers: shibboleth GitLab Shell Version: 13.2.0 Repository storage paths: - default: /var/opt/gitlab/git-data/repositories GitLab Shell path: /opt/gitlab/embedded/service/gitlab-shell Git: /opt/gitlab/embedded/bin/git
Results of GitLab application Check
Expand for output related to the GitLab application check
# gitlab-rake gitlab:check SANITIZE=true Checking GitLab subtasks ...Checking GitLab Shell ...
GitLab Shell: ... GitLab Shell version >= 13.2.0 ? ... OK (13.2.0) Running /opt/gitlab/embedded/service/gitlab-shell/bin/check Internal API available: OK Redis available via internal API: OK gitlab-shell self-check successful
Checking GitLab Shell ... Finished
Checking Gitaly ...
Gitaly: ... default ... OK
Checking Gitaly ... Finished
Checking Sidekiq ...
Sidekiq: ... Running? ... yes Number of Sidekiq processes ... 1
Checking Sidekiq ... Finished
Checking Incoming Email ...
Incoming Email: ... Reply by email is disabled in config/gitlab.yml
Checking Incoming Email ... Finished
Checking LDAP ...
LDAP: ... LDAP is disabled in config/gitlab.yml
Checking LDAP ... Finished
Checking GitLab App ...
Git configured correctly? ... yes Database config exists? ... yes All migrations up? ... yes Database contains orphaned GroupMembers? ... no GitLab config exists? ... yes GitLab config up to date? ... yes Log directory writable? ... yes Tmp directory writable? ... yes Uploads directory exists? ... yes Uploads directory has correct permissions? ... yes Uploads directory tmp has correct permissions? ... yes 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: ... 4/1 ... yes
[...]
4984/9584 ... yes 6302/9585 ... yes 6286/9586 ... yes 600/9587 ... yes Redis version >= 4.0.0? ... yes Ruby version >= 2.5.3 ? ... yes (2.6.6) Git version >= 2.22.0 ? ... yes (2.26.2) Git user has default SSH configuration? ... yes Active users: ... 3675 Is authorized keys file accessible? ... yes GitLab configured to store new projects in hashed storage? ... yes All projects are in hashed storage? ... yes
Checking GitLab App ... Finished
Checking GitLab subtasks ... Finished
Possible fixes
Sorry, I'm not much of an expert of Rails, ruby and such. :/