[MDEV-21773] galera_as_slave_gtid MTR failed: query failed: 1064: You have an error in your SQL syntax; Created: 2020-02-19  Updated: 2020-08-11  Resolved: 2020-06-30

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4.13
Fix Version/s: 10.4.14, 10.5.5

Type: Bug Priority: Critical
Reporter: Stepan Patryshev (Inactive) Assignee: Julius Goryavsky
Resolution: Fixed Votes: 0
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


Generated at Thu Feb 08 09:09:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.