mysql errors on node 2 and 3 but not on node 1

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hi,

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.

2

Could you share the error log contents that state the error?

3

We mainly get these type of errors.

150406 16:22:49 [ERROR] Slave SQL: Error ‘Duplicate column name ‘example_col_name’’ on query. Default database: ‘exampleDB’. Query: ‘ALTER TABLE ex_table_name ADD ex_element INT(1) NULL’, Error_code: 1060

150407 14:07:49 [ERROR] Slave SQL: Error ‘Can’t DROP ‘my_element1’; check that column/key exists’ on query. Default database: ‘exampleDB’. Query: ‘ALTER TABLE ex_tablename DROP my_element1’, Error_code: 1091

I believe I know what is causing these errors but I’m just confused on why these errors would only show up on my node 2 and node 3 but not on my node 1 (which is primary).