Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bug Report: Starting MoveTables for sequence tables drops the VSchema type sequence attribute #13216

Closed
FancyFane opened this issue Jun 1, 2023 · 0 comments · Fixed by #13220

Comments

@FancyFane
Copy link
Collaborator

Overview of the Issue

On a shard by shard migration, when you start a MoveTables for Sequence tables it can drop the sequence attribute from the vSchema.

Reproduction Steps

  1. Apply your VSchema for sequences and validate:
$ vtctlclient --server localhost:15999 GetVSchema fane_import
{
  "tables": {
    "sbtest1_seq": {
      "type": "sequence"
    },
    "sbtest2_seq": {
      "type": "sequence"
    },
    "sbtest3_seq": {
      "type": "sequence"
    },
    "sbtest4_seq": {
      "type": "sequence"
    },
    "sbtest5_seq": {
      "type": "sequence"
    },
    "sbtest6_seq": {
      "type": "sequence"
    }
  }
}
  1. Start your MoveTables command (this is using shard by shard migration)
$ vtctlclient --server localhost:15999 MoveTables -- --cells="${CELLS}" --all --tablet_types="in_order:REPLICA,PRIMARY" --source="fane_import_source" Create fane_import.import
Waiting for workflow to start:

Workflow started successfully with 1 stream(s)

The following vreplication streams exist for workflow fane_import.import:

id=2 on -/aws_useast1b_4-4141702636: Status: Copying. VStream Lag: 0s.
  1. Check you vSchema once again, and note the sequences attribute has been removed:
$ vtctlclient --server localhost:15999 GetVSchema fane_import
{
  "tables": {
    "sbtest1_seq": {},
    "sbtest2_seq": {},
    "sbtest3_seq": {},
    "sbtest4_seq": {},
    "sbtest5_seq": {},
    "sbtest6_seq": {}
  }
}

Binary Version

Version: Vitess 16.0.3

Operating System and Environment details

n/a

Log Fragments

n/a
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants