Add actual_state_updated_at column to workspaces table

Chad Woolleyrequested to merge
caw-ws-add-actual-state-workspace-var-1-6 into master

Issue: Introduce gl_workspace_reconciled_actual_state ... (#520866 - closed)

What does this MR do and why?

Adds actual_state_updated_at column to workspaces table

References

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Screenshots or screen recordings

Migration output:

gitlab (caw-ws-add-actual-state-workspace-var-1-6 *)$ scripts/database/migrate.rb --debug -t up
Options: {:task=>:up, :dry_run=>false, :debug=>true}
Files: #<Set: {"db/migrate/20250305000001_add_actual_state_updated_at_to_workspaces.rb"}>
Base files: ["20250305000001_add_actual_state_updated_at_to_workspaces.rb"]
Selected files: ["20250305000001_add_actual_state_updated_at_to_workspaces.rb"]
Sorted: ["20250305000001_add_actual_state_updated_at_to_workspaces.rb"]
$ bin/rails db:migrate:up:main db:migrate:up:ci VERSION=20250305000001
DEPRECATION WARNING: Support for Rails versions < 7.1 is deprecated and will be removed from ViewComponent 4.0.0 (ViewComponent v4 will remove support for Rails versions < 7.1 no earlier than April 1, 2025) (called from <main> at /Users/cwoolley/workspace/gitlab-development-kit/gitlab/config/environment.rb:7)
main: == [advisory_lock_connection] object_id: 132100, pg_backend_pid: 4976
main: == 20250305000001 AddActualStateUpdatedAtToWorkspaces: migrating ==============
main: -- add_column(:workspaces, :actual_state_updated_at, :datetime_with_timezone, {:null=>false, :default=>"1970-01-01"})
main:    -> 0.0043s
main: == 20250305000001 AddActualStateUpdatedAtToWorkspaces: migrated (0.0086s) =====

main: == [advisory_lock_connection] object_id: 132100, pg_backend_pid: 4976
ci: == [advisory_lock_connection] object_id: 132820, pg_backend_pid: 5033
ci: == 20250305000001 AddActualStateUpdatedAtToWorkspaces: migrating ==============
ci: -- add_column(:workspaces, :actual_state_updated_at, :datetime_with_timezone, {:null=>false, :default=>"1970-01-01"})
ci:    -> 0.0037s
ci: == 20250305000001 AddActualStateUpdatedAtToWorkspaces: migrated (0.0188s) =====

ci: == [advisory_lock_connection] object_id: 132820, pg_backend_pid: 5033
gitlab (caw-ws-add-actual-state-workspace-var-1-6 *)$ scripts/database/migrate.rb --debug -t down
Options: {:task=>:down, :dry_run=>false, :debug=>true}
Files: #<Set: {"db/migrate/20250305000001_add_actual_state_updated_at_to_workspaces.rb"}>
Base files: ["20250305000001_add_actual_state_updated_at_to_workspaces.rb"]
Selected files: ["20250305000001_add_actual_state_updated_at_to_workspaces.rb"]
Sorted: ["20250305000001_add_actual_state_updated_at_to_workspaces.rb"]
$ bin/rails db:migrate:down:main db:migrate:down:ci VERSION=20250305000001
DEPRECATION WARNING: Support for Rails versions < 7.1 is deprecated and will be removed from ViewComponent 4.0.0 (ViewComponent v4 will remove support for Rails versions < 7.1 no earlier than April 1, 2025) (called from <main> at /Users/cwoolley/workspace/gitlab-development-kit/gitlab/config/environment.rb:7)
main: == [advisory_lock_connection] object_id: 132100, pg_backend_pid: 5394
main: == 20250305000001 AddActualStateUpdatedAtToWorkspaces: reverting ==============
main: -- remove_column(:workspaces, :actual_state_updated_at, :datetime_with_timezone, {:null=>false, :default=>"1970-01-01"})
main:    -> 0.0027s
main: == 20250305000001 AddActualStateUpdatedAtToWorkspaces: reverted (0.0087s) =====

main: == [advisory_lock_connection] object_id: 132100, pg_backend_pid: 5394
ci: == [advisory_lock_connection] object_id: 132660, pg_backend_pid: 5480
ci: == 20250305000001 AddActualStateUpdatedAtToWorkspaces: reverting ==============
ci: -- remove_column(:workspaces, :actual_state_updated_at, :datetime_with_timezone, {:null=>false, :default=>"1970-01-01"})
ci:    -> 0.0013s
ci: == 20250305000001 AddActualStateUpdatedAtToWorkspaces: reverted (0.0149s) =====

ci: == [advisory_lock_connection] object_id: 132660, pg_backend_pid: 5480
gitlab (caw-ws-add-actual-state-workspace-var-1-6 *)$

How to set up and validate locally

  • Test up and down migrations

Merge request reports