Stop or restart an Astra DB Sideloader migration
If necessary, you can pause, cancel, or restart an Astra DB Sideloader migration.
Pause a migration
Use the DevOps API to pause a migration:
curl -X POST \
-H "Authorization: Bearer ${token}" \
https://api.astra.datastax.com/v2/databases/${dbID}/migrations/${migrationID}/pause \
| jq .
A paused migration retains its current state and progress.
Any in-progress jobs will complete, but no new jobs will start.
Resume a migration
Resume a previously-paused migration from the point at which it was paused:
curl -X POST \
-H "Authorization: Bearer ${token}" \
https://api.astra.datastax.com/v2/databases/${dbID}/migrations/${migrationID}/resume \
| jq .
You can only resume an active migration that has been paused. Running this command against migrations in other statuses, such as idle migrations that were automatically cleaned up, has no effect.
Abort a migration
Abort a migration only if you want to abandon it completely.
-
Abort a migration and remove all migration progress:
curl -X POST \ -H "Authorization: Bearer ${token}" \ https://api.astra.datastax.com/v2/databases/${dbID}/migrations/${migrationID}/abort \ | jq .
You can abort a migration up until the point at which Astra DB Sideloader starts importing SSTable metadata. After this point, you must wait for the migration to finish, and then you can use the CQL shell to drop the keyspace/table in your target database before repeating the entire migration procedure. For more information about what happens during each phase of a migration and the point of no return, see About Astra DB Sideloader.
-
Wait a few minutes, and then check the migration status to confirm that the migration stopped:
curl -X GET \ -H "Authorization: Bearer ${token}" \ https://api.astra.datastax.com/v2/databases/${dbID}/migrations/${migrationID} \ | jq .
A successful response contains a
MigrationStatus
object. It can take a few minutes for the DevOps API to reflect status changes during a migration. Immediately calling this endpoint after starting a new phase of the migration might not return the actual current status.
Retry a failed migration
For information about reattempting a failed migration, see Troubleshoot Astra DB Sideloader.