After upgrading mariadb master/slave cluster from 10.0.33 to 10.3.12, I have a replication issue. on each cluster that I have upgraded, every minute, all slaves connections are closed with the message :
2019-02-12 19:41:20 77017 [Warning] Aborted connection 77017 to db: 'unconnected' user: 'sa' host: 'logarchiverpl2.artprice.bil' (A slave with the same server_uuid/server_id as this slave has co)
I have checked the server-id of all the stack, non are the same.
show slave hosts;
Server_id Host Port Master_id
29 3306 31
30 3306 31
27 3306 31
22 3311 31
25 3311 31
The replication was working fine with 10.0.33. All the slaves have been created via cloning the full data set via rsync, and then restarting changing the server-id.
For the upgrade process, I have started and run myql_upgrade, in 10.1,10.2,10.3 with the last current stable. No upgrade errors.
I have read
MDEV-15660, mentioning the same error message, and trying to raise table_open_cache, but it doesn't help.