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

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 10.4.13
    • Fix Version/s: 10.4.14, 10.5.5
    • Component/s: Galera, Tests
    • Labels:
      None
    • Environment:
      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

            Assignee:
            sysprg Julius Goryavsky
            Reporter:
            stepan.patryshev Stepan Patryshev
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: