Skip to content

Draft: Create project_statistics_events table

Radamanthus Batnag requested to merge 434324-create-project-statistics-events into master

What does this MR do and why?

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.

DB Migration Logs

Up 
main: == [advisory_lock_connection] object_id: 182900, pg_backend_pid: 53898
main: == 20240104135745 AddProjectStatisticsEvents: migrating =======================
main: -- create_table(:project_statistics_events)
main: -- quote_column_name(:field)
main:    -> 0.0000s
main: -- quote_column_name(:triggered_by)
main:    -> 0.0000s
main:    -> 0.0096s
main: == 20240104135745 AddProjectStatisticsEvents: migrated (0.0236s) ==============

main: == [advisory_lock_connection] object_id: 182900, pg_backend_pid: 53898
ci: == [advisory_lock_connection] object_id: 183240, pg_backend_pid: 53900
ci: == 20240104135745 AddProjectStatisticsEvents: migrating =======================
ci: -- create_table(:project_statistics_events)
ci: -- quote_column_name(:field)
ci:    -> 0.0000s
ci: -- quote_column_name(:triggered_by)
ci:    -> 0.0000s
ci:    -> 0.0061s
I, [2024-01-08T12:40:06.645954 #53738]  INFO -- : Database: 'ci', Table: 'project_statistics_events': Lock Writes
ci: == 20240104135745 AddProjectStatisticsEvents: migrated (0.0166s) ==============

ci: == [advisory_lock_connection] object_id: 183240, pg_backend_pid: 53900
Down 
main: == [advisory_lock_connection] object_id: 182520, pg_backend_pid: 52999
main: == 20240104135745 AddProjectStatisticsEvents: reverting =======================
main: -- drop_table(:project_statistics_events)
main:    -> 0.0050s
main: == 20240104135745 AddProjectStatisticsEvents: reverted (0.0085s) ==============

main: == [advisory_lock_connection] object_id: 182520, pg_backend_pid: 52999
ci: == [advisory_lock_connection] object_id: 182440, pg_backend_pid: 53405
ci: == 20240104135745 AddProjectStatisticsEvents: reverting =======================
ci: -- drop_table(:project_statistics_events)
ci:    -> 0.0027s
ci: == 20240104135745 AddProjectStatisticsEvents: reverted (0.0106s) ==============

ci: == [advisory_lock_connection] object_id: 182440, pg_backend_pid: 53405

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

Related to #434324

Edited by Radamanthus Batnag

Merge request reports