Not the answer you need?
Register and ask your own question!

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

akangakang EntrantCurrent User Role Beginner
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.

Comments

  • wagnerbianchiwagnerbianchi Remote DBA Current User Role Patron
    Could you share the error log contents that state the error?
  • akangakang Entrant Current User Role Beginner
    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).
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.