2021-09-04 01:27:46 +05:30
|
|
|
# frozen_string_literal: true
|
|
|
|
|
|
|
|
require 'spec_helper'
|
|
|
|
|
2023-03-04 22:38:38 +05:30
|
|
|
RSpec.describe "Admin > Admin sees background migrations", feature_category: :database do
|
2023-03-17 16:20:25 +05:30
|
|
|
include ListboxHelpers
|
|
|
|
|
2021-09-04 01:27:46 +05:30
|
|
|
let_it_be(:admin) { create(:admin) }
|
2022-08-13 15:12:31 +05:30
|
|
|
let(:job_class) { Gitlab::BackgroundMigration::CopyColumnUsingBackgroundMigrationJob }
|
2021-09-04 01:27:46 +05:30
|
|
|
|
2022-06-21 17:19:12 +05:30
|
|
|
let_it_be(:active_migration) { create(:batched_background_migration, :active, table_name: 'active') }
|
|
|
|
let_it_be(:failed_migration) { create(:batched_background_migration, :failed, table_name: 'failed', total_tuple_count: 100) }
|
|
|
|
let_it_be(:finished_migration) { create(:batched_background_migration, :finished, table_name: 'finished') }
|
2021-09-04 01:27:46 +05:30
|
|
|
|
|
|
|
before_all do
|
2022-04-04 11:22:00 +05:30
|
|
|
create(:batched_background_migration_job, :failed, batched_migration: failed_migration, batch_size: 10, min_value: 6, max_value: 15, attempts: 3)
|
2021-09-04 01:27:46 +05:30
|
|
|
end
|
|
|
|
|
|
|
|
before do
|
|
|
|
sign_in(admin)
|
|
|
|
gitlab_enable_admin_mode_sign_in(admin)
|
|
|
|
end
|
|
|
|
|
|
|
|
it 'can navigate to background migrations' do
|
|
|
|
visit admin_root_path
|
|
|
|
|
|
|
|
within '.nav-sidebar' do
|
|
|
|
link = find_link 'Background Migrations'
|
|
|
|
|
|
|
|
link.click
|
|
|
|
|
|
|
|
expect(page).to have_current_path(admin_background_migrations_path)
|
|
|
|
expect(link).to have_ancestor(:css, 'li.active')
|
|
|
|
end
|
|
|
|
end
|
|
|
|
|
2022-07-16 23:28:13 +05:30
|
|
|
it 'can click on a specific migration' do
|
|
|
|
visit admin_background_migrations_path
|
|
|
|
|
|
|
|
within '#content-body' do
|
|
|
|
tab = find_link active_migration.job_class_name
|
|
|
|
tab.click
|
|
|
|
|
|
|
|
expect(page).to have_current_path admin_background_migration_path(active_migration)
|
|
|
|
end
|
|
|
|
end
|
|
|
|
|
|
|
|
it 'can view failed jobs' do
|
|
|
|
visit admin_background_migration_path(failed_migration)
|
|
|
|
|
|
|
|
within '#content-body' do
|
|
|
|
expect(page).to have_content('Failed jobs')
|
|
|
|
expect(page).to have_content('Id')
|
|
|
|
expect(page).to have_content('Started at')
|
|
|
|
expect(page).to have_content('Finished at')
|
|
|
|
expect(page).to have_content('Batch size')
|
|
|
|
end
|
|
|
|
end
|
|
|
|
|
|
|
|
it 'can click on a specific job' do
|
|
|
|
job = create(:batched_background_migration_job, :failed, batched_migration: failed_migration)
|
|
|
|
|
|
|
|
visit admin_background_migration_path(failed_migration)
|
|
|
|
|
|
|
|
within '#content-body' do
|
|
|
|
tab = find_link job.id
|
|
|
|
tab.click
|
|
|
|
|
|
|
|
expect(page).to have_current_path admin_background_migration_batched_job_path(id: job.id, background_migration_id: failed_migration.id)
|
|
|
|
end
|
|
|
|
end
|
|
|
|
|
|
|
|
context 'when there are no failed jobs' do
|
|
|
|
it 'dos not display failed jobs' do
|
|
|
|
visit admin_background_migration_path(active_migration)
|
|
|
|
|
|
|
|
within '#content-body' do
|
|
|
|
expect(page).not_to have_content('Failed jobs')
|
|
|
|
end
|
|
|
|
end
|
|
|
|
end
|
|
|
|
|
2021-09-30 23:02:18 +05:30
|
|
|
it 'can view queued migrations and pause and resume them' do
|
2021-09-04 01:27:46 +05:30
|
|
|
visit admin_background_migrations_path
|
|
|
|
|
|
|
|
within '#content-body' do
|
|
|
|
expect(page).to have_selector('tbody tr', count: 1)
|
|
|
|
|
|
|
|
expect(page).to have_content(active_migration.job_class_name)
|
|
|
|
expect(page).to have_content(active_migration.table_name)
|
|
|
|
expect(page).to have_content('0.00%')
|
2021-09-30 23:02:18 +05:30
|
|
|
expect(page).not_to have_content('Paused')
|
|
|
|
expect(page).to have_content('Active')
|
|
|
|
|
2023-04-23 21:23:45 +05:30
|
|
|
click_on('Pause')
|
2021-09-30 23:02:18 +05:30
|
|
|
expect(page).not_to have_content('Active')
|
|
|
|
expect(page).to have_content('Paused')
|
|
|
|
|
2023-04-23 21:23:45 +05:30
|
|
|
click_on('Resume')
|
2021-09-30 23:02:18 +05:30
|
|
|
expect(page).not_to have_content('Paused')
|
|
|
|
expect(page).to have_content('Active')
|
2021-09-04 01:27:46 +05:30
|
|
|
end
|
|
|
|
end
|
|
|
|
|
2021-11-11 11:23:49 +05:30
|
|
|
context 'when there are failed migrations' do
|
|
|
|
before do
|
|
|
|
allow_next_instance_of(Gitlab::BackgroundMigration::BatchingStrategies::PrimaryKeyBatchingStrategy) do |batch_class|
|
2022-05-07 20:08:51 +05:30
|
|
|
allow(batch_class).to receive(:next_batch).with(
|
|
|
|
anything,
|
|
|
|
anything,
|
|
|
|
batch_min_value: 6,
|
|
|
|
batch_size: 5,
|
2022-08-13 15:12:31 +05:30
|
|
|
job_arguments: failed_migration.job_arguments,
|
|
|
|
job_class: job_class
|
2022-05-07 20:08:51 +05:30
|
|
|
).and_return([6, 10])
|
2021-11-11 11:23:49 +05:30
|
|
|
end
|
|
|
|
end
|
2021-09-04 01:27:46 +05:30
|
|
|
|
2022-07-16 23:28:13 +05:30
|
|
|
it 'can fire an action with a database param' do
|
|
|
|
visit admin_background_migrations_path(database: 'main')
|
|
|
|
|
|
|
|
within '#content-body' do
|
|
|
|
tab = find_link 'Failed'
|
|
|
|
tab.click
|
|
|
|
|
2023-04-23 21:23:45 +05:30
|
|
|
expect(page).to have_selector("[data-method='post'][href='/admin/background_migrations/#{failed_migration.id}/retry?database=main']")
|
2022-07-16 23:28:13 +05:30
|
|
|
end
|
|
|
|
end
|
|
|
|
|
2021-11-11 11:23:49 +05:30
|
|
|
it 'can view and retry them' do
|
|
|
|
visit admin_background_migrations_path
|
2021-09-04 01:27:46 +05:30
|
|
|
|
2021-11-11 11:23:49 +05:30
|
|
|
within '#content-body' do
|
|
|
|
tab = find_link 'Failed'
|
|
|
|
tab.click
|
2021-09-04 01:27:46 +05:30
|
|
|
|
2021-11-11 11:23:49 +05:30
|
|
|
expect(page).to have_current_path(admin_background_migrations_path(tab: 'failed'))
|
2022-04-04 11:22:00 +05:30
|
|
|
expect(tab[:class]).to include('gl-tab-nav-item-active')
|
2021-11-11 11:23:49 +05:30
|
|
|
|
|
|
|
expect(page).to have_selector('tbody tr', count: 1)
|
|
|
|
|
|
|
|
expect(page).to have_content(failed_migration.job_class_name)
|
|
|
|
expect(page).to have_content(failed_migration.table_name)
|
|
|
|
expect(page).to have_content('0.00%')
|
2022-06-21 17:19:12 +05:30
|
|
|
expect(page).to have_content(failed_migration.status_name.to_s)
|
2021-09-04 01:27:46 +05:30
|
|
|
|
2023-04-23 21:23:45 +05:30
|
|
|
click_on('Retry')
|
2021-11-11 11:23:49 +05:30
|
|
|
expect(page).not_to have_content(failed_migration.job_class_name)
|
|
|
|
expect(page).not_to have_content(failed_migration.table_name)
|
|
|
|
expect(page).not_to have_content('0.00%')
|
|
|
|
end
|
2021-09-04 01:27:46 +05:30
|
|
|
end
|
|
|
|
end
|
|
|
|
|
|
|
|
it 'can view finished migrations' do
|
|
|
|
visit admin_background_migrations_path
|
|
|
|
|
|
|
|
within '#content-body' do
|
|
|
|
tab = find_link 'Finished'
|
|
|
|
tab.click
|
|
|
|
|
|
|
|
expect(page).to have_current_path(admin_background_migrations_path(tab: 'finished'))
|
2022-04-04 11:22:00 +05:30
|
|
|
expect(tab[:class]).to include('gl-tab-nav-item-active')
|
2021-09-04 01:27:46 +05:30
|
|
|
|
|
|
|
expect(page).to have_selector('tbody tr', count: 1)
|
|
|
|
|
|
|
|
expect(page).to have_content(finished_migration.job_class_name)
|
|
|
|
expect(page).to have_content(finished_migration.table_name)
|
|
|
|
expect(page).to have_content('100.00%')
|
2022-06-21 17:19:12 +05:30
|
|
|
expect(page).to have_content(finished_migration.status_name.to_s)
|
2021-09-04 01:27:46 +05:30
|
|
|
end
|
|
|
|
end
|
2022-07-16 23:28:13 +05:30
|
|
|
|
|
|
|
it 'can change tabs and retain database param' do
|
2023-04-23 21:23:45 +05:30
|
|
|
skip_if_multiple_databases_not_setup(:ci)
|
2022-07-16 23:28:13 +05:30
|
|
|
|
|
|
|
visit admin_background_migrations_path(database: 'ci')
|
|
|
|
|
|
|
|
within '#content-body' do
|
|
|
|
tab = find_link 'Finished'
|
|
|
|
expect(tab[:class]).not_to include('gl-tab-nav-item-active')
|
|
|
|
|
|
|
|
tab.click
|
|
|
|
|
|
|
|
expect(page).to have_current_path(admin_background_migrations_path(tab: 'finished', database: 'ci'))
|
|
|
|
expect(tab[:class]).to include('gl-tab-nav-item-active')
|
|
|
|
end
|
|
|
|
end
|
|
|
|
|
|
|
|
it 'can view documentation from Learn more link' do
|
|
|
|
visit admin_background_migrations_path
|
|
|
|
|
|
|
|
within '#content-body' do
|
2023-05-27 22:25:52 +05:30
|
|
|
expect(page).to have_link('Learn more', href: help_page_path('update/background_migrations'))
|
2022-07-16 23:28:13 +05:30
|
|
|
end
|
|
|
|
end
|
|
|
|
|
|
|
|
describe 'selected database toggle', :js do
|
|
|
|
context 'when multi database is not enabled' do
|
|
|
|
before do
|
|
|
|
skip_if_multiple_databases_are_setup
|
|
|
|
|
|
|
|
allow(Gitlab::Database).to receive(:db_config_names).and_return(['main'])
|
|
|
|
end
|
|
|
|
|
|
|
|
it 'does not render the database listbox' do
|
|
|
|
visit admin_background_migrations_path
|
|
|
|
|
2023-03-17 16:20:25 +05:30
|
|
|
expect(page).not_to have_button('main')
|
2022-07-16 23:28:13 +05:30
|
|
|
end
|
|
|
|
end
|
|
|
|
|
|
|
|
context 'when multi database is enabled' do
|
|
|
|
before do
|
2023-04-23 21:23:45 +05:30
|
|
|
skip_if_multiple_databases_not_setup(:ci)
|
2022-07-16 23:28:13 +05:30
|
|
|
|
|
|
|
allow(Gitlab::Database).to receive(:db_config_names).and_return(%w[main ci])
|
|
|
|
end
|
|
|
|
|
2023-03-17 16:20:25 +05:30
|
|
|
it 'renders the database listbox' do
|
2022-07-16 23:28:13 +05:30
|
|
|
visit admin_background_migrations_path
|
|
|
|
|
2023-03-17 16:20:25 +05:30
|
|
|
expect(page).to have_button('main')
|
2022-07-16 23:28:13 +05:30
|
|
|
end
|
|
|
|
|
|
|
|
it 'shows correct database when a parameter is passed' do
|
|
|
|
visit admin_background_migrations_path(database: 'ci')
|
|
|
|
|
2023-03-17 16:20:25 +05:30
|
|
|
expect(page).to have_button('ci')
|
2022-07-16 23:28:13 +05:30
|
|
|
end
|
|
|
|
|
|
|
|
it 'updates the path to correct database when clicking on listbox option' do
|
|
|
|
visit admin_background_migrations_path
|
|
|
|
|
2023-03-17 16:20:25 +05:30
|
|
|
click_button 'main'
|
|
|
|
select_listbox_item('ci')
|
2022-07-16 23:28:13 +05:30
|
|
|
|
|
|
|
expect(page).to have_current_path(admin_background_migrations_path(database: 'ci'))
|
2023-03-17 16:20:25 +05:30
|
|
|
expect(page).to have_button('ci')
|
2022-07-16 23:28:13 +05:30
|
|
|
end
|
|
|
|
end
|
|
|
|
end
|
2021-09-04 01:27:46 +05:30
|
|
|
end
|