I have a percona cluster of three servers and i am trying to perform rolling schema upgrade with RSU + node dropping method.
Basicaly what you do is:
1.remove the a server from the cluster,
2.change OSU method to RSU,
3.perform the schema change
4. Add server back to cluster
I did the above method on a small table and it all worked well how ever when i tried on a much bigger table (took like 5 hours to complete) when added the server back to cluster i got the following error:
Weird thing is that the change i made was indeed on relevant table on Column 3 from VARCAHR(40) to VARCHAR(100)…
Any ideas?
Do you have any other columns with VARCHAR data type on the same table? Can you check if you have the same column order of the same table among the nodes? How about the SQL_MODE on the new node? It seems that some values are being truncated and due to that, just the node where the transaction has started has the information while other nodes don’t have it. Check data truncation or SQL_MODE…and provide more details about that.