Skip to content

Improve deletion of batched background migration

Problem

For migrations that have many jobs and transition logs, the DELETE query generated by delete_batched_background_migration may have execution time close to the statement timeout (because of the cascading deletes triggered by the FKs). For example - !138574 (comment 1677679706).

Proposal

Change the helper so that the associated batched_background_migration_jobs records are deleted (preferably in batches) before the batched_background_migrations record is deleted.

Edited by Krasimir Angelov