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

galera_as_slave_gtid MTR failed: query failed: 1064: You have an error in your SQL syntax;

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.4.13
    • 10.4.14, 10.5.5
    • Galera, Tests
    • None
    • kvm-deb-bionic-ppc64le

    Description

      galera_as_slave_gtid failed on bb : "query 'CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_USER='root', MASTER_PORT=$NODE_MYPORT_3;' failed: 1064: You have an error in your SQL syntax;".

      stdio.log:

      10.4.13 1a73b995fc03cc2fecd5b9288bd657db962bf67b

      galera.galera_as_slave_gtid 'innodb'     w1 [ fail ]
              Test ended at 2020-02-17 08:34:08
       
      CURRENT_TEST: galera.galera_as_slave_gtid
      mysqltest: In included file "/usr/share/mysql/mysql-test/suite/galera/t/galera_as_slave_gtid.inc": 
      included from /usr/share/mysql/mysql-test/suite/galera/t/galera_as_slave_gtid.test at line 11:
      At line 19: query 'CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_USER='root', MASTER_PORT=$NODE_MYPORT_3;' failed: 1064: 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
       
      The result from queries just before the failure was:
      connection node_2;
      connection node_1;
      connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
      connection node_2;
       
       - skipping '/dev/shm/var/1/log/galera.galera_as_slave_gtid-innodb/'
       
      Retrying test galera.galera_as_slave_gtid, attempt(2/3)...
       
      worker[1] > Restart  - not started
      worker[1] > Restart  - not started
      galera.galera_var_wsrep_on_off 'innodb'  w2 [ pass ]   2012
      galera.galera_wsrep_provider_options_syntax 'innodb' w2 [ pass ]   2013
      galera.galera_as_slave_gtid 'innodb'     w1 [ retry-fail ]
              Test ended at 2020-02-17 08:34:15
       
      CURRENT_TEST: galera.galera_as_slave_gtid
      mysqltest: In included file "/usr/share/mysql/mysql-test/suite/galera/t/galera_as_slave_gtid.inc": 
      included from /usr/share/mysql/mysql-test/suite/galera/t/galera_as_slave_gtid.test at line 11:
      At line 19: query 'CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_USER='root', MASTER_PORT=$NODE_MYPORT_3;' failed: 1064: 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
       
      The result from queries just before the failure was:
      connection node_2;
      connection node_1;
      connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
      connection node_2;
       
       - skipping '/dev/shm/var/1/log/galera.galera_as_slave_gtid-innodb/'
       
      Test galera.galera_as_slave_gtid has failed 2 times, no more retries!
       
      worker[1] > Restart  - not started
      worker[1] > Restart  - not started
      

      Attachments

        Activity

          People

            sysprg Julius Goryavsky
            stepan.patryshev Stepan Patryshev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.