Skip to content

Feature Request: Add --force flag for MoveTables / Workflow completion #17517

Closed
@lizztheblizz

Description

@lizztheblizz

Feature Description

Currently, once movetables has executed switchtraffic, and the original source keyspace gets disconnected for any reason, there is no way to force complete it, and the workflow needs to be manually cleaned up from the sidecar db's.

Adding a --force flag to the complete subcommand could allow the proper cleanup to happen even if the workflow outlives the connection to the source keyspace/database.

Use Case(s)

In scenarios where data is being imported into Vitess from an external keyspace, there can be a prolonged period during which the workflow is left after switchtraffic, but before complete, during which the reverse replication streams are kept running.

Sometimes, at that point, the original source database may end up getting removed without having fully cleaned up the Vitess side workflows. Previously, we would have cleaned up there workflows directly with the workflow delete command, but that is also no longer an option in more recent versions of Vitess.

Metadata

Metadata

Assignees

Type

No type

Projects

Status

Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions