Skip to content

Step 1: Prepare `ci_build_needs` for bigint conversion

Laura Montemayor requested to merge lm-convert-ci-build-needs-to-bigint into master

What does this MR do and why?

Prepares ci_build_needs.id conversion to bigint. This is step 1/4.

Related to:

#389343 (closed)

Up

ci: == 20230130104819 InitializeConversionOfCiBuildNeedsToBigint: migrating =======
ci: -- table_exists?(:ci_build_needs)
ci:    -> 0.0451s
ci: -- column_exists?(:ci_build_needs, :id)
ci:    -> 0.0025s
ci: -- column_exists?(:ci_build_needs, :id)
ci:    -> 0.0010s
ci: -- transaction_open?()
ci:    -> 0.0000s
ci: -- columns(:ci_build_needs)
ci:    -> 0.0010s
ci: -- add_column(:ci_build_needs, "id_convert_to_bigint", :bigint, {:default=>0, :null=>false})
ci:    -> 0.0010s
ci: == 20230130104819 InitializeConversionOfCiBuildNeedsToBigint: migrated (0.0602s)

ci: == 20230130110855 BackfillCiBuildNeedsForBigIntConversion: migrating ==========
ci: -- table_exists?(:ci_build_needs)
ci:    -> 0.0007s
ci: -- column_exists?(:ci_build_needs, :id)
ci:    -> 0.0014s
ci: -- column_exists?(:ci_build_needs, :id)
ci:    -> 0.0011s
ci: -- column_exists?(:ci_build_needs, "id_convert_to_bigint")
ci:    -> 0.0011s
ci: == 20230130110855 BackfillCiBuildNeedsForBigIntConversion: migrated (0.0334s) =

Down

ci: == 20230130110855 BackfillCiBuildNeedsForBigIntConversion: reverting ==========
ci: -- execute("DELETE FROM batched_background_migrations WHERE job_class_name = 'CopyColumnUsingBackgroundMigrationJob' AND table_name = 'ci_build_needs' AND column_name = 'id' AND job_arguments = '[[\"id\"],[\"id_convert_to_bigint\"]]'")
ci:    -> 0.0031s
ci: == 20230130110855 BackfillCiBuildNeedsForBigIntConversion: reverted (0.0085s) =

ci: == 20230130104819 InitializeConversionOfCiBuildNeedsToBigint: reverting =======
ci: -- remove_column(:ci_build_needs, "id_convert_to_bigint")
ci:    -> 0.0005s
ci: == 20230130104819 InitializeConversionOfCiBuildNeedsToBigint: reverted (0.0081s)

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Laura Montemayor

Merge request reports