Skip to content

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

Open
@lizztheblizz

Description

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

Assignees

No one assigned

    Type

    No type

    Projects

    • Status

      Backlog

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions