I am using XtraDB cluster 5.5 and have a cluster of 3 nodes, with node 1 as the primary node. When I look at my mysql error log, I see the same errors on node 2 and node 3 but not in node 1 (no errors at all). These are duplicate column/can’t drop columns errors.
I have an application that uses the the cluster and I believe that users are trying to create/drop tables with the same name more than once, therefore causing the db errors.
I was wondering if anyone knows why these errors are occurring on node 2 and 3 but not on node 1.
Thanks in advance.