Type: New Feature
Affects Version/s: None
Fix Version/s: None
PXC joiner node is stuck in "State transfer in progress, setting sleep higher" if the following are configured:
This does not happen upon initialization of the datadir, this only happens when a node is re-joined to the cluster even if only only one record is changed. It does not matter if the change is to an encrypted table or not.
How to repeat:
Assume you have a running 3-node cluster, with encrypted tablespace enabled as above.
- shutdown node3
- insert one record on any table on node1 or node2
- start node3 and let it join the cluster, node3 will stay stuck trying to complete the state transfer ....
To resolve, one has to rm the contents of the datadir on node3 and upon restart of mysqld it would re-initialize the datadir and would then join the cluster via SST with no problems.
If early_plugin_load and keyring_file_data is commented out in my.cnf SST/IST works when the above steps are tested.