Update project namespace backfilling migration to handle inconsistency with namespace id type
Some customers have been having issues with ProjectNamespaces::BackfillProjectNamespaces
migration due to them having namespaces.id
column type set as bigint
vs .com column type being integer
.
root@gitlab1-ny:~# gitlab-rake gitlab:background_migrations:finalize[ProjectNamespaces::BackfillProjectNamespaces,projects,id,'[null\,"up"]']
rake aborted!
ActiveRecord::StatementInvalid: PG::UndefinedFunction: ERROR: function array_append(integer[], bigint) does not exist
LINE 2: SET traversal_ids = array_append(project_namespaces.traversa...
We can update the migration to do an explicit type conversion to bypass this error.