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

**URL:** <https://forums.percona.com/t/mysql-errors-on-node-2-and-3-but-not-on-node-1/4139>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [April 6, 2015, 11:03am UTC](https://forums.percona.com/t/mysql-errors-on-node-2-and-3-but-not-on-node-1/4139 "2015-04-06T11:03:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![akang](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@akang](https://forums.percona.com/u/akang)\
**Post date:** [April 6, 2015, 11:03am UTC](https://forums.percona.com/t/mysql-errors-on-node-2-and-3-but-not-on-node-1/4139/1 "2015-04-06T11:03:51Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![wagnerbianchi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/wagnerbianchi/32/802_2.png) [@wagnerbianchi](https://forums.percona.com/u/wagnerbianchi)\
**Post date:** [April 7, 2015, 9:01am UTC](https://forums.percona.com/t/mysql-errors-on-node-2-and-3-but-not-on-node-1/4139/2 "2015-04-07T09:01:46Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![akang](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@akang](https://forums.percona.com/u/akang)\
**Post date:** [April 7, 2015, 2:05pm UTC](https://forums.percona.com/t/mysql-errors-on-node-2-and-3-but-not-on-node-1/4139/3 "2015-04-07T14:05:33Z")

</div>

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).