Migrate unmanaged tablet to Vitess keyspace about vitess-operator

[jawabuu]

Hey @zehweh
Could you try this
https://gist.github.com/jawabuu/da27bb6bbb562d9caa5d1692955c892a

[zehweh]

Thanks @jawabuu for your quick response.

Unfortunately, I get connection errors again.
You can see the logs here: https://gist.github.com/zehweh/c55ebe1aedcee5acd498e954baa1cd27

I noticed, that vttablet complains about mysql running in read-only mode... This looks suspicious.

Some additional information I forgot to add:

• kubernetes version 1.22.4
• flannel for networking

[jawabuu]

@zehweh Are you on #vitess slack channel?

[jawabuu]

I'd like to see your
kubectl get po after running my gist

[zehweh]

I found out what was causing the issues:

1: The resource limits were set too low in my VitessCluster manifest which resulted in occasional OOM kills of the mysql container and the logs you see above.

2: I'm working with a master-master replication on the external database (unmanaged tablet). The master I'm connecting to has multiple sets of GTIDs:

mysql> SHOW SLAVE STATUS\G

*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
[...]
            Executed_Gtid_Set: 01af65be-d03d-11ec-a14f-0cc47a6af5da:1-28538331:544939690-544939696,
d048674a-e588-11ec-80cd-0cc47a6c65c8:1-65287695
[...]

Because of this, the MoveTables workflow wouldn't start:

❯ vtctlclient MoveTables  --source testdb -all Create vitesstest.testremote2vitess                                          
Waiting for workflow to start:
0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... 0% ... E0606 09:56:06.404528    5131 main.go:67] E0606 09:56:06.404251 vtctl.go:2582] workflow did not start within 30s
MoveTables Error: rpc error: code = Unknown desc = workflow did not start within 30s
E0606 09:56:06.406961    5131 main.go:76] remote error: rpc error: code = Unknown desc = workflow did not start within 30s

After switching to a master-slave setup and resetting the GTIDs, I was able to successfully start the VReplication.

Thanks @jawabuu for your help!