I am using Percona XtraDB cluster 5.5.37. I have run one alter command (to add unique constraint) on node1. But due to duplicate keys,alter command failed on it. But that failed statement passed to remaining nodes 2,3 and error logged like below.
160524 6:08:21 [ERROR] Slave SQL: Error 'Duplicate entry '176-60-FFP-1' for key 'constraint_name'' on query. Default database: 'db'. Query: 'alter table table_name add constraint constraint_name unique (col1, col2, col3,col4)', Error_code: 1062
My question is why its passed to other nodes, when it has failed on first node itself. It should not passed right. Please let me know where i am thinking wrong.