[17-0] Fix Sidekiq migration timeout
What does this MR do and why?
For #458743 (closed), the migration db/post_migrate/20240124043507_migrate_sidekiq_queued_and_future_jobs
is timing out on Dedicated customers environment due to the migration running in DB transaction. This migration however doesn't interact with the DB at all, as it only migrates Sidekiq jobs to the correct queue based on routing_rules configuration.
This fix adds disable_ddl_transaction!
to the migration.
MR for master branch fix: !152754 (merged)
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
This MR is backporting a bug fix, documentation update, or spec fix, previously merged in the default branch. -
The MR that fixed the bug on the default branch has been deployed to GitLab.com (not applicable for documentation or spec changes). -
This MR has a severity label assigned (if applicable). -
Set the milestone of the merge request to match the target backport branch version. -
This MR has been approved by a maintainer (only one approval is required). -
Ensure the e2e:package-and-test-ee
job has either succeeded or been approved by a Software Engineer in Test. Failures are unrelated !153574 (comment 1913624072).
Note to the merge request author and maintainer
If you have questions about the patch release process, please:
- Refer to the patch release runbook for engineers and maintainers for guidance.
- Ask questions on the
#releases
Slack channel (internal only).
Edited by Luke Duncalfe