Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4211

Galera: with binlog-checksum=1 any ALTER TABLE statement results in Error_code: 1064 and not replicated on other nodes

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5.28a-galera
    • 5.5.29-galera
    • None
    • Cent OS 5.x Ubuntu 12.04

    Description

      We have a setup of 3 servers in a galera cluster: db01, db02, db03.

      If we run an ALTER TABLE statement on one of the nodes then the other two nodes get an error in the log and the statement is not replicated. For example, the following queries run on db01:

      ALTER TABLE `test` ADD INDEX `started_time` (`started_time`);
      ALTER TABLE `test2` ADD COLUMN `ip` varchar(39) DEFAULT NULL;

      Resulted in the following errors on db02 (db03 errors look the same):

      130227 7:30:09 [ERROR] Slave SQL: Error 'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1' on query. Default database: 'test'. Query: 'ALTER TABLE `test` ADD INDEX `started_time` (`started_time`)', Error_code: 1064
      130227 7:30:09 [Warning] WSREP: RBR event 1 Query apply warning: 1, 9952638
      130227 7:30:09 [Warning] WSREP: Ignoring error for TO isolated action: source: 6885794c-7ea3-11e2-0800-7f8704162adb version: 2 local: 0 state: APPLYING flags: 65 conn_id: 2863428 trx_id: -1 seqnos (l: 60187, g: 9952638, s: 9952637, d: 9952637, ts: 1361950209418672000)
      130227 7:36:10 [ERROR] Slave SQL: Error 'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 2' on query. Default database: 'test'. Query: 'ALTER TABLE `test2` ADD COLUMN `ip` varchar(39) DEFAULT NULL', Error_code: 1064
      130227 7:36:10 [Warning] WSREP: RBR event 1 Query apply warning: 1, 9955444
      130227 7:36:10 [Warning] WSREP: Ignoring error for TO isolated action: source: 6885794c-7ea3-11e2-0800-7f8704162adb version: 2 local: 0 state: APPLYING flags: 65 conn_id: 2862856 trx_id: -1 seqnos (l: 63003, g: 9955444, s: 9955443, d: 9955443, ts: 1361950570003527000)

      No errors have been produced on the db01.

      I've submitted my.cnf for another bug (https://mariadb.atlassian.net/browse/MDEV-4136), the only change is the following addition:

      wsrep_log_conflicts=1

      Aleksey

      Attachments

        Activity

          People

            seppo Seppo Jaakola
            aleksey.sanin Aleksey Sanin (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.