/home/stepan/galera/git/10.4/server/sql/mysqld, Version: 10.4.2-MariaDB-debug-log (Source distribution). started with: Tcp port: 16040 Unix socket: /home/stepan/galera/git/10.4/server/mysql-test/var/tmp/1/mysqld.1.sock Time Id Command Argument 190114 12:44:51 27 Connect root@localhost as anonymous on 27 Query SET SESSION wsrep_sync_wait = 0 27 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 27 Quit 28 Connect root@localhost as anonymous on 28 Query SET SESSION wsrep_sync_wait = 0 28 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 28 Quit 190114 12:44:56 29 Connect root@localhost as anonymous on 29 Query SHOW SLAVE STATUS 29 Query SELECT 'No such row' = 'No such row' 29 Query select count(*) from mysql.proc 29 Query call mtr.check_testcase() 29 Query select @@datadir 29 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 29 Query SELECT @@wsrep_on 29 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 29 Quit 30 Connect root@localhost as anonymous on test 30 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 30 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'wsrep_on' AND VARIABLE_VALUE='ON' 30 Query SHOW STATUS LIKE 'wsrep_ready' 30 Query SHOW STATUS LIKE 'wsrep_ready' 190114 12:44:58 31 Connect root@localhost as anonymous on test 31 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 31 Query CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB 31 Query SET SESSION wsrep_trx_fragment_size = 1 31 Query SET AUTOCOMMIT=OFF 31 Query START TRANSACTION 31 Query INSERT INTO t1 VALUES (1) 31 Query INSERT INTO t1 VALUES (2) 31 Query INSERT INTO t1 VALUES (3) 31 Query INSERT INTO t1 VALUES (4) 31 Query INSERT INTO t1 VALUES (5) 37 Connect root@localhost as anonymous on test 37 Query ALTER TABLE t1 ADD COLUMN f2 INTEGER 31 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 37 Quit 30 Quit 31 Quit 39 Connect root@localhost as anonymous on 39 Query set SQL_LOG_BIN=0 39 Query set WSREP_ON=0 39 Query set debug_dbug="" 39 Query use mtr 39 Query set session transaction read write 39 Query create temporary table error_log ( row int auto_increment primary key, suspicious int default 1, file_name varchar(255), line varchar(1024) default null ) engine=myisam 39 Query load data infile '/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.1.err.warnings' into table error_log fields terminated by 'xykls37' escaped by '' ignore 1 lines (line) set file_name='/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.1.err' 39 Query call mtr.check_warnings(@result) 39 Query select @result = 0 39 Quit 40 Connect root@localhost as anonymous on 40 Query SHOW SLAVE STATUS 40 Query SELECT 'No such row' = 'No such row' 40 Query select count(*) from mysql.proc 40 Query call mtr.check_testcase() 40 Query select @@datadir 40 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 40 Query SELECT @@wsrep_on 40 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 40 Quit 190114 12:44:59 41 Connect root@localhost as anonymous on 41 Query SET SESSION wsrep_sync_wait = 0 41 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 41 Quit 42 Connect root@localhost as anonymous on 42 Query SHOW SLAVE STATUS 42 Query SELECT 'No such row' = 'No such row' 42 Query select count(*) from mysql.proc 42 Query call mtr.check_testcase() 42 Query select @@datadir 42 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 42 Query SELECT @@wsrep_on 42 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 42 Quit 43 Connect root@localhost as anonymous on test 43 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 43 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'wsrep_on' AND VARIABLE_VALUE='ON' 43 Query SHOW STATUS LIKE 'wsrep_ready' 43 Query SHOW STATUS LIKE 'wsrep_ready' 190114 12:45:01 44 Connect root@localhost as anonymous on test 44 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 44 Query CREATE TABLE t1 (f1 INTEGER, f2 VARCHAR(10)) ENGINE=InnoDB 44 Query CREATE TABLE t2 (f1 INTEGER) 44 Query SET SESSION wsrep_trx_fragment_size = 1 44 Query SET AUTOCOMMIT=OFF 44 Query START TRANSACTION 44 Query INSERT INTO t1 VALUES (1, 'a') 47 Connect root@localhost as anonymous on test 47 Query INSERT INTO t1 VALUES (2) 44 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 47 Quit 44 Quit 43 Quit 48 Connect root@localhost as anonymous on 48 Query set SQL_LOG_BIN=0 48 Query set WSREP_ON=0 48 Query set debug_dbug="" 48 Query use mtr 48 Query set session transaction read write 48 Query create temporary table error_log ( row int auto_increment primary key, suspicious int default 1, file_name varchar(255), line varchar(1024) default null ) engine=myisam 48 Query load data infile '/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.1.err.warnings' into table error_log fields terminated by 'xykls37' escaped by '' ignore 1 lines (line) set file_name='/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.1.err' 48 Query call mtr.check_warnings(@result) 48 Query select @result = 0 48 Quit 49 Connect root@localhost as anonymous on 49 Query SHOW SLAVE STATUS 49 Query SELECT 'No such row' = 'No such row' 49 Query select count(*) from mysql.proc 49 Query call mtr.check_testcase() 49 Query select @@datadir 49 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 49 Query SELECT @@wsrep_on 49 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 49 Quit 50 Connect root@localhost as anonymous on 50 Query SET SESSION wsrep_sync_wait = 0 50 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 50 Quit 51 Connect root@localhost as anonymous on 51 Query SHOW SLAVE STATUS 51 Query SELECT 'No such row' = 'No such row' 51 Query select count(*) from mysql.proc 51 Query call mtr.check_testcase() 51 Query select @@datadir 51 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 51 Query SELECT @@wsrep_on 51 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 51 Quit 52 Connect root@localhost as anonymous on test 52 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 52 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'wsrep_on' AND VARIABLE_VALUE='ON' 52 Query SHOW STATUS LIKE 'wsrep_ready' 52 Query SHOW STATUS LIKE 'wsrep_ready' 190114 12:45:03 53 Connect root@localhost as anonymous on test 53 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 53 Query CREATE TABLE IF NOT EXISTS t1 (f1 INTEGER) ENGINE = InnoDB 54 Connect root@localhost as anonymous on test 54 Query SET SESSION AUTOCOMMIT=OFF 54 Query SET SESSION wsrep_trx_fragment_size = 1 54 Query INSERT INTO t1 VALUES (161) 54 Query COMMIT 54 Query DELETE FROM t1 WHERE f1 > 13 54 Quit 190114 12:45:05 53 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 53 Query DROP TABLE t1 53 Query SELECT CONCAT('/home/stepan/galera/git/10.4/server/mysql-test/var/1/tmp/_ag_', UUID()) 53 Query SELECT LOAD_FILE('/home/stepan/galera/git/10.4/server/mysql-test/var/1/tmp/_ag_1284e5f9-17e1-11e9-921b-00155d419d00') 53 Query SELECT SUBSTRING('1', 1, 1) 53 Query SELECT SUBSTRING('1', 2) 53 Query SELECT SUBSTRING('1', 1, 1) 53 Query SELECT SUBSTRING('1', 2) 53 Query SELECT SUBSTRING('1', 1, 1) 53 Query SELECT SUBSTRING('1', 2) 53 Query SELECT SUBSTRING('1', 1, 1) 53 Query SELECT SUBSTRING('1', 2) 53 Query SELECT SUBSTRING_INDEX('node_1,', ',', 1) 53 Query SELECT SUBSTRING('node_1,', LENGTH('node_1') + 2) 53 Query SELECT REPEAT('.', 0) 52 Quit 53 Quit 58 Connect root@localhost as anonymous on 58 Query set SQL_LOG_BIN=0 58 Query set WSREP_ON=0 58 Query set debug_dbug="" 58 Query use mtr 58 Query set session transaction read write 58 Query create temporary table error_log ( row int auto_increment primary key, suspicious int default 1, file_name varchar(255), line varchar(1024) default null ) engine=myisam 58 Query load data infile '/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.1.err.warnings' into table error_log fields terminated by 'xykls37' escaped by '' ignore 1 lines (line) set file_name='/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.1.err' 58 Query call mtr.check_warnings(@result) 58 Query select @result = 0 58 Quit 59 Connect root@localhost as anonymous on 59 Query SHOW SLAVE STATUS 59 Query SELECT 'No such row' = 'No such row' 59 Query select count(*) from mysql.proc 59 Query call mtr.check_testcase() 59 Query select @@datadir 59 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 59 Query SELECT @@wsrep_on 59 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 59 Quit 60 Connect root@localhost as anonymous on 60 Query SET SESSION wsrep_sync_wait = 0 60 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 60 Quit 61 Connect root@localhost as anonymous on 61 Query SHOW SLAVE STATUS 61 Query SELECT 'No such row' = 'No such row' 61 Query select count(*) from mysql.proc 61 Query call mtr.check_testcase() 190114 12:45:06 61 Query select @@datadir 61 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 61 Query SELECT @@wsrep_on 61 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 61 Quit 62 Connect root@localhost as anonymous on test 62 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 62 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'wsrep_on' AND VARIABLE_VALUE='ON' 62 Query SHOW STATUS LIKE 'wsrep_ready' 62 Query SHOW STATUS LIKE 'wsrep_ready' 190114 12:45:08 63 Connect root@localhost as anonymous on test 63 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 63 Query CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB 63 Query SET SESSION WSREP_TRX_FRAGMENT_SIZE=1 63 Query SET SESSION AUTOCOMMIT=OFF 63 Query INSERT INTO t1 VALUES (10) 63 Query SELECT COUNT(*) > 0 FROM wsrep_schema.SR 63 Query START TRANSACTION 63 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 63 Query SELECT COUNT(*) > 0 FROM t1 63 Query DROP TABLE t1 63 Quit 62 Quit 65 Connect root@localhost as anonymous on 65 Query set SQL_LOG_BIN=0 65 Query set WSREP_ON=0 65 Query set debug_dbug="" 65 Query use mtr 65 Query set session transaction read write 65 Query create temporary table error_log ( row int auto_increment primary key, suspicious int default 1, file_name varchar(255), line varchar(1024) default null ) engine=myisam 65 Query load data infile '/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.1.err.warnings' into table error_log fields terminated by 'xykls37' escaped by '' ignore 1 lines (line) set file_name='/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.1.err' 65 Query call mtr.check_warnings(@result) 65 Query select @result = 0 65 Quit 66 Connect root@localhost as anonymous on 66 Query SHOW SLAVE STATUS 66 Query SELECT 'No such row' = 'No such row' 66 Query select count(*) from mysql.proc 66 Query call mtr.check_testcase() 66 Query select @@datadir 66 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 66 Query SELECT @@wsrep_on 66 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 66 Quit 67 Connect root@localhost as anonymous on 67 Query SET SESSION wsrep_sync_wait = 0 67 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 67 Quit 68 Connect root@localhost as anonymous on 68 Query SHOW SLAVE STATUS 68 Query SELECT 'No such row' = 'No such row' 68 Query select count(*) from mysql.proc 68 Query call mtr.check_testcase() 68 Query select @@datadir 68 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 68 Query SELECT @@wsrep_on 68 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 68 Quit 69 Connect root@localhost as anonymous on test 69 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 69 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'wsrep_on' AND VARIABLE_VALUE='ON' 69 Query SHOW STATUS LIKE 'wsrep_ready' 69 Query SHOW STATUS LIKE 'wsrep_ready' 190114 12:45:10 70 Connect root@localhost as anonymous on test 70 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 70 Query CREATE TABLE t1 (f1 INTEGER) Engine=InnoDB 71 Connect root@localhost as anonymous on test 71 Query SET SESSION wsrep_trx_fragment_size = 1 71 Query SET SESSION wsrep_sync_wait = 0 72 Connect root@localhost as anonymous on test 72 Query SET SESSION wsrep_trx_fragment_size = 1 72 Query SET SESSION wsrep_sync_wait = 0 73 Connect root@localhost as anonymous on test 73 Query SET SESSION wsrep_trx_fragment_size = 1 73 Query SET SESSION wsrep_sync_wait = 0 74 Connect root@localhost as anonymous on test 74 Query SET SESSION wsrep_trx_fragment_size = 1 74 Query SET SESSION wsrep_sync_wait = 0 75 Connect root@localhost as anonymous on test 75 Query SET SESSION wsrep_trx_fragment_size = 1 75 Query SET SESSION wsrep_sync_wait = 0 76 Connect root@localhost as anonymous on test 76 Query SET SESSION wsrep_trx_fragment_size = 1 76 Query SET SESSION wsrep_sync_wait = 0 77 Connect root@localhost as anonymous on test 77 Query SET SESSION wsrep_trx_fragment_size = 1 77 Query SET SESSION wsrep_sync_wait = 0 78 Connect root@localhost as anonymous on test 78 Query SET SESSION wsrep_trx_fragment_size = 1 78 Query SET SESSION wsrep_sync_wait = 0 79 Connect root@localhost as anonymous on test 79 Query SET SESSION wsrep_trx_fragment_size = 1 79 Query SET SESSION wsrep_sync_wait = 0 80 Connect root@localhost as anonymous on test 80 Query SET SESSION wsrep_trx_fragment_size = 1 80 Query SET SESSION wsrep_sync_wait = 0 81 Connect root@localhost as anonymous on test 81 Query SET SESSION wsrep_trx_fragment_size = 1 81 Query SET SESSION wsrep_sync_wait = 0 82 Connect root@localhost as anonymous on test 82 Query SET SESSION wsrep_trx_fragment_size = 1 82 Query SET SESSION wsrep_sync_wait = 0 83 Connect root@localhost as anonymous on test 83 Query SET SESSION wsrep_trx_fragment_size = 1 83 Query SET SESSION wsrep_sync_wait = 0 84 Connect root@localhost as anonymous on test 84 Query SET SESSION wsrep_trx_fragment_size = 1 84 Query SET SESSION wsrep_sync_wait = 0 85 Connect root@localhost as anonymous on test 85 Query SET SESSION wsrep_trx_fragment_size = 1 85 Query SET SESSION wsrep_sync_wait = 0 86 Connect root@localhost as anonymous on test 86 Query SET SESSION wsrep_trx_fragment_size = 1 86 Query SET SESSION wsrep_sync_wait = 0 87 Connect root@localhost as anonymous on test 87 Query SET SESSION wsrep_trx_fragment_size = 1 87 Query SET SESSION wsrep_sync_wait = 0 88 Connect root@localhost as anonymous on test 88 Query SET SESSION wsrep_trx_fragment_size = 1 88 Query SET SESSION wsrep_sync_wait = 0 89 Connect root@localhost as anonymous on test 89 Query SET SESSION wsrep_trx_fragment_size = 1 89 Query SET SESSION wsrep_sync_wait = 0 90 Connect root@localhost as anonymous on test 90 Query SET SESSION wsrep_trx_fragment_size = 1 90 Query SET SESSION wsrep_sync_wait = 0 91 Connect root@localhost as anonymous on test 91 Query SET SESSION wsrep_trx_fragment_size = 1 91 Query SET SESSION wsrep_sync_wait = 0 92 Connect root@localhost as anonymous on test 92 Query SET SESSION wsrep_trx_fragment_size = 1 92 Query SET SESSION wsrep_sync_wait = 0 93 Connect root@localhost as anonymous on test 93 Query SET SESSION wsrep_trx_fragment_size = 1 93 Query SET SESSION wsrep_sync_wait = 0 94 Connect root@localhost as anonymous on test 94 Query SET SESSION wsrep_trx_fragment_size = 1 94 Query SET SESSION wsrep_sync_wait = 0 95 Connect root@localhost as anonymous on test 95 Query SET SESSION wsrep_trx_fragment_size = 1 95 Query SET SESSION wsrep_sync_wait = 0 96 Connect root@localhost as anonymous on test 96 Query SET SESSION wsrep_trx_fragment_size = 1 96 Query SET SESSION wsrep_sync_wait = 0 97 Connect root@localhost as anonymous on test 97 Query SET SESSION wsrep_trx_fragment_size = 1 97 Query SET SESSION wsrep_sync_wait = 0 98 Connect root@localhost as anonymous on test 98 Query SET SESSION wsrep_trx_fragment_size = 1 98 Query SET SESSION wsrep_sync_wait = 0 99 Connect root@localhost as anonymous on test 99 Query SET SESSION wsrep_trx_fragment_size = 1 99 Query SET SESSION wsrep_sync_wait = 0 100 Connect root@localhost as anonymous on test 100 Query SET SESSION wsrep_trx_fragment_size = 1 100 Query SET SESSION wsrep_sync_wait = 0 101 Connect root@localhost as anonymous on test 101 Query SET SESSION wsrep_trx_fragment_size = 1 101 Query SET SESSION wsrep_sync_wait = 0 102 Connect root@localhost as anonymous on test 102 Query SET SESSION wsrep_trx_fragment_size = 1 102 Query SET SESSION wsrep_sync_wait = 0 103 Connect root@localhost as anonymous on test 103 Query SET SESSION wsrep_trx_fragment_size = 1 103 Query SET SESSION wsrep_sync_wait = 0 104 Connect root@localhost as anonymous on test 104 Query SET SESSION wsrep_trx_fragment_size = 1 104 Query SET SESSION wsrep_sync_wait = 0 105 Connect root@localhost as anonymous on test 105 Query SET SESSION wsrep_trx_fragment_size = 1 105 Query SET SESSION wsrep_sync_wait = 0 106 Connect root@localhost as anonymous on test 106 Query SET SESSION wsrep_trx_fragment_size = 1 106 Query SET SESSION wsrep_sync_wait = 0 107 Connect root@localhost as anonymous on test 107 Query SET SESSION wsrep_trx_fragment_size = 1 107 Query SET SESSION wsrep_sync_wait = 0 108 Connect root@localhost as anonymous on test 108 Query SET SESSION wsrep_trx_fragment_size = 1 108 Query SET SESSION wsrep_sync_wait = 0 109 Connect root@localhost as anonymous on test 109 Query SET SESSION wsrep_trx_fragment_size = 1 109 Query SET SESSION wsrep_sync_wait = 0 110 Connect root@localhost as anonymous on test 110 Query SET SESSION wsrep_trx_fragment_size = 1 110 Query SET SESSION wsrep_sync_wait = 0 111 Connect root@localhost as anonymous on test 111 Query SET SESSION wsrep_trx_fragment_size = 1 111 Query SET SESSION wsrep_sync_wait = 0 112 Connect root@localhost as anonymous on test 112 Query SET SESSION wsrep_trx_fragment_size = 1 112 Query SET SESSION wsrep_sync_wait = 0 113 Connect root@localhost as anonymous on test 113 Query SET SESSION wsrep_trx_fragment_size = 1 113 Query SET SESSION wsrep_sync_wait = 0 114 Connect root@localhost as anonymous on test 114 Query SET SESSION wsrep_trx_fragment_size = 1 114 Query SET SESSION wsrep_sync_wait = 0 115 Connect root@localhost as anonymous on test 115 Query SET SESSION wsrep_trx_fragment_size = 1 115 Query SET SESSION wsrep_sync_wait = 0 116 Connect root@localhost as anonymous on test 116 Query SET SESSION wsrep_trx_fragment_size = 1 116 Query SET SESSION wsrep_sync_wait = 0 117 Connect root@localhost as anonymous on test 117 Query SET SESSION wsrep_trx_fragment_size = 1 117 Query SET SESSION wsrep_sync_wait = 0 118 Connect root@localhost as anonymous on test 118 Query SET SESSION wsrep_trx_fragment_size = 1 118 Query SET SESSION wsrep_sync_wait = 0 119 Connect root@localhost as anonymous on test 119 Query SET SESSION wsrep_trx_fragment_size = 1 119 Query SET SESSION wsrep_sync_wait = 0 120 Connect root@localhost as anonymous on test 120 Query SET SESSION wsrep_trx_fragment_size = 1 120 Query SET SESSION wsrep_sync_wait = 0 121 Connect root@localhost as anonymous on test 121 Query SET SESSION wsrep_trx_fragment_size = 1 121 Query SET SESSION wsrep_sync_wait = 0 122 Connect root@localhost as anonymous on test 122 Query SET SESSION wsrep_trx_fragment_size = 1 122 Query SET SESSION wsrep_sync_wait = 0 123 Connect root@localhost as anonymous on test 123 Query SET SESSION wsrep_trx_fragment_size = 1 123 Query SET SESSION wsrep_sync_wait = 0 124 Connect root@localhost as anonymous on test 124 Query SET SESSION wsrep_trx_fragment_size = 1 124 Query SET SESSION wsrep_sync_wait = 0 125 Connect root@localhost as anonymous on test 125 Query SET SESSION wsrep_trx_fragment_size = 1 125 Query SET SESSION wsrep_sync_wait = 0 126 Connect root@localhost as anonymous on test 126 Query SET SESSION wsrep_trx_fragment_size = 1 126 Query SET SESSION wsrep_sync_wait = 0 127 Connect root@localhost as anonymous on test 127 Query SET SESSION wsrep_trx_fragment_size = 1 127 Query SET SESSION wsrep_sync_wait = 0 128 Connect root@localhost as anonymous on test 128 Query SET SESSION wsrep_trx_fragment_size = 1 128 Query SET SESSION wsrep_sync_wait = 0 129 Connect root@localhost as anonymous on test 129 Query SET SESSION wsrep_trx_fragment_size = 1 129 Query SET SESSION wsrep_sync_wait = 0 130 Connect root@localhost as anonymous on test 130 Query SET SESSION wsrep_trx_fragment_size = 1 130 Query SET SESSION wsrep_sync_wait = 0 131 Connect root@localhost as anonymous on test 131 Query SET SESSION wsrep_trx_fragment_size = 1 131 Query SET SESSION wsrep_sync_wait = 0 132 Connect root@localhost as anonymous on test 132 Query SET SESSION wsrep_trx_fragment_size = 1 132 Query SET SESSION wsrep_sync_wait = 0 71 Query START TRANSACTION 72 Query START TRANSACTION 71 Query INSERT INTO t1 VALUES (62) 73 Query START TRANSACTION 72 Query INSERT INTO t1 VALUES (61) 74 Query START TRANSACTION 73 Query INSERT INTO t1 VALUES (60) 74 Query INSERT INTO t1 VALUES (59) 75 Query START TRANSACTION 75 Query INSERT INTO t1 VALUES (58) 76 Query START TRANSACTION 77 Query START TRANSACTION 76 Query INSERT INTO t1 VALUES (57) 77 Query INSERT INTO t1 VALUES (56) 78 Query START TRANSACTION 79 Query START TRANSACTION 78 Query INSERT INTO t1 VALUES (55) 80 Query START TRANSACTION 81 Query START TRANSACTION 80 Query INSERT INTO t1 VALUES (53) 79 Query INSERT INTO t1 VALUES (54) 81 Query INSERT INTO t1 VALUES (52) 82 Query START TRANSACTION 82 Query INSERT INTO t1 VALUES (51) 83 Query START TRANSACTION 84 Query START TRANSACTION 84 Query INSERT INTO t1 VALUES (49) 83 Query INSERT INTO t1 VALUES (50) 85 Query START TRANSACTION 86 Query START TRANSACTION 87 Query START TRANSACTION 86 Query INSERT INTO t1 VALUES (47) 87 Query INSERT INTO t1 VALUES (46) 88 Query START TRANSACTION 88 Query INSERT INTO t1 VALUES (45) 89 Query START TRANSACTION 90 Query START TRANSACTION 89 Query INSERT INTO t1 VALUES (44) 90 Query INSERT INTO t1 VALUES (43) 85 Query INSERT INTO t1 VALUES (48) 91 Query START TRANSACTION 91 Query INSERT INTO t1 VALUES (42) 92 Query START TRANSACTION 92 Query INSERT INTO t1 VALUES (41) 93 Query START TRANSACTION 94 Query START TRANSACTION 93 Query INSERT INTO t1 VALUES (40) 95 Query START TRANSACTION 94 Query INSERT INTO t1 VALUES (39) 95 Query INSERT INTO t1 VALUES (38) 96 Query START TRANSACTION 96 Query INSERT INTO t1 VALUES (37) 97 Query START TRANSACTION 97 Query INSERT INTO t1 VALUES (36) 98 Query START TRANSACTION 98 Query INSERT INTO t1 VALUES (35) 99 Query START TRANSACTION 99 Query INSERT INTO t1 VALUES (34) 100 Query START TRANSACTION 100 Query INSERT INTO t1 VALUES (33) 101 Query START TRANSACTION 101 Query INSERT INTO t1 VALUES (32) 102 Query START TRANSACTION 102 Query INSERT INTO t1 VALUES (31) 103 Query START TRANSACTION 103 Query INSERT INTO t1 VALUES (30) 104 Query START TRANSACTION 104 Query INSERT INTO t1 VALUES (29) 105 Query START TRANSACTION 105 Query INSERT INTO t1 VALUES (28) 106 Query START TRANSACTION 106 Query INSERT INTO t1 VALUES (27) 107 Query START TRANSACTION 108 Query START TRANSACTION 107 Query INSERT INTO t1 VALUES (26) 109 Query START TRANSACTION 108 Query INSERT INTO t1 VALUES (25) 110 Query START TRANSACTION 109 Query INSERT INTO t1 VALUES (24) 110 Query INSERT INTO t1 VALUES (23) 111 Query START TRANSACTION 111 Query INSERT INTO t1 VALUES (22) 112 Query START TRANSACTION 112 Query INSERT INTO t1 VALUES (21) 113 Query START TRANSACTION 114 Query START TRANSACTION 114 Query INSERT INTO t1 VALUES (19) 115 Query START TRANSACTION 116 Query START TRANSACTION 115 Query INSERT INTO t1 VALUES (18) 117 Query START TRANSACTION 116 Query INSERT INTO t1 VALUES (17) 118 Query START TRANSACTION 118 Query INSERT INTO t1 VALUES (15) 119 Query START TRANSACTION 113 Query INSERT INTO t1 VALUES (20) 117 Query INSERT INTO t1 VALUES (16) 119 Query INSERT INTO t1 VALUES (14) 120 Query START TRANSACTION 120 Query INSERT INTO t1 VALUES (13) 121 Query START TRANSACTION 122 Query START TRANSACTION 121 Query INSERT INTO t1 VALUES (12) 122 Query INSERT INTO t1 VALUES (11) 123 Query START TRANSACTION 123 Query INSERT INTO t1 VALUES (10) 124 Query START TRANSACTION 125 Query START TRANSACTION 125 Query INSERT INTO t1 VALUES (8) 124 Query INSERT INTO t1 VALUES (9) 126 Query START TRANSACTION 127 Query START TRANSACTION 126 Query INSERT INTO t1 VALUES (7) 127 Query INSERT INTO t1 VALUES (6) 128 Query START TRANSACTION 128 Query INSERT INTO t1 VALUES (5) 129 Query START TRANSACTION 130 Query START TRANSACTION 129 Query INSERT INTO t1 VALUES (4) 130 Query INSERT INTO t1 VALUES (3) 131 Query START TRANSACTION 131 Query INSERT INTO t1 VALUES (2) 132 Query START TRANSACTION 132 Query INSERT INTO t1 VALUES (1) 71 Query COMMIT 190114 12:45:11 72 Query COMMIT 73 Query COMMIT 74 Query COMMIT 75 Query COMMIT 76 Query COMMIT 77 Query COMMIT 78 Query COMMIT 79 Query COMMIT 80 Query COMMIT 81 Query COMMIT 82 Query COMMIT 83 Query COMMIT 84 Query COMMIT 85 Query COMMIT 86 Query COMMIT 87 Query COMMIT 88 Query COMMIT 89 Query COMMIT 90 Query COMMIT 91 Query COMMIT 92 Query COMMIT 93 Query COMMIT 94 Query COMMIT 95 Query COMMIT 96 Query COMMIT 97 Query COMMIT 98 Query COMMIT 99 Query COMMIT 100 Query COMMIT 101 Query COMMIT 102 Query COMMIT 103 Query COMMIT 104 Query COMMIT 105 Query COMMIT 106 Query COMMIT 107 Query COMMIT 108 Query COMMIT 190114 12:45:12 109 Query COMMIT 110 Query COMMIT 111 Query COMMIT 112 Query COMMIT 113 Query COMMIT 114 Query COMMIT 115 Query COMMIT 116 Query COMMIT 117 Query COMMIT 118 Query COMMIT 119 Query COMMIT 120 Query COMMIT 121 Query COMMIT 122 Query COMMIT 123 Query COMMIT 124 Query COMMIT 125 Query COMMIT 126 Query COMMIT 127 Query COMMIT 128 Query COMMIT 129 Query COMMIT 130 Query COMMIT 131 Query COMMIT 132 Query COMMIT 132 Query DROP TABLE t1 132 Quit 131 Quit 123 Quit 130 Quit 122 Quit 124 Quit 125 Quit 128 Quit 120 Quit 119 Quit 115 Quit 116 Quit 113 Quit 109 Quit 118 Quit 107 Quit 108 Quit 110 Quit 103 Quit 92 Quit 106 Quit 90 Quit 101 Quit 88 Quit 104 Quit 87 Quit 99 Quit 91 Quit 82 Quit 98 Quit 81 Quit 78 Quit 80 Quit 77 Quit 97 Quit 79 Quit 70 Quit 96 Quit 75 Quit 95 Quit 74 Quit 94 Quit 73 Quit 89 Quit 71 Quit 76 Quit 69 Quit 72 Quit 93 Quit 83 Quit 111 Quit 84 Quit 129 Quit 85 Quit 86 Quit 127 Quit 126 Quit 121 Quit 117 Quit 114 Quit 112 Quit 105 Quit 102 Quit 100 Quit 195 Connect root@localhost as anonymous on 195 Query set SQL_LOG_BIN=0 195 Query set WSREP_ON=0 195 Query set debug_dbug="" 195 Query use mtr 195 Query set session transaction read write 195 Query create temporary table error_log ( row int auto_increment primary key, suspicious int default 1, file_name varchar(255), line varchar(1024) default null ) engine=myisam 195 Query load data infile '/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.1.err.warnings' into table error_log fields terminated by 'xykls37' escaped by '' ignore 1 lines (line) set file_name='/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.1.err' 195 Query call mtr.check_warnings(@result) 195 Query select @result = 0 195 Quit 196 Connect root@localhost as anonymous on 196 Query SHOW SLAVE STATUS 196 Query SELECT 'No such row' = 'No such row' 196 Query select count(*) from mysql.proc 196 Query call mtr.check_testcase() 196 Query select @@datadir 196 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 196 Query SELECT @@wsrep_on 196 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 196 Quit 197 Connect root@localhost as anonymous on 197 Query SET SESSION wsrep_sync_wait = 0 197 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 197 Quit 198 Connect root@localhost as anonymous on 198 Query SHOW SLAVE STATUS 198 Query SELECT 'No such row' = 'No such row' 198 Query select count(*) from mysql.proc 198 Query call mtr.check_testcase() 198 Query select @@datadir 198 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 198 Query SELECT @@wsrep_on 198 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 198 Quit 199 Connect root@localhost as anonymous on test 199 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 199 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'wsrep_on' AND VARIABLE_VALUE='ON' 199 Query SHOW STATUS LIKE 'wsrep_ready' 199 Query SHOW STATUS LIKE 'wsrep_ready' 190114 12:45:14 200 Connect root@localhost as anonymous on test 200 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 200 Query CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB 200 Query SET SESSION wsrep_on = OFF 200 Query INSERT INTO t1 VALUES (1) 200 Query SET SESSION wsrep_on = ON 200 Query SET SESSION wsrep_trx_fragment_size = 1 200 Query DELETE FROM t1 WHERE f1 = 1 200 Query SET SESSION wsrep_trx_fragment_size = 0 200 Query INSERT INTO t1 VALUES (1) 200 Query SELECT COUNT(*) = 1 200 Query DROP TABLE t1 190114 12:45:15 200 Quit 199 Quit 202 Connect root@localhost as anonymous on 202 Query set SQL_LOG_BIN=0 202 Query set WSREP_ON=0 202 Query set debug_dbug="" 202 Query use mtr 202 Query set session transaction read write 202 Query create temporary table error_log ( row int auto_increment primary key, suspicious int default 1, file_name varchar(255), line varchar(1024) default null ) engine=myisam 202 Query load data infile '/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.1.err.warnings' into table error_log fields terminated by 'xykls37' escaped by '' ignore 1 lines (line) set file_name='/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.1.err' 202 Query call mtr.check_warnings(@result) 202 Query select @result = 0 202 Quit 203 Connect root@localhost as anonymous on 203 Query SHOW SLAVE STATUS 203 Query SELECT 'No such row' = 'No such row' 203 Query select count(*) from mysql.proc 203 Query call mtr.check_testcase() 203 Query select @@datadir 203 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 203 Query SELECT @@wsrep_on 203 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 203 Quit 204 Connect root@localhost as anonymous on 204 Query SET SESSION wsrep_sync_wait = 0 204 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 204 Quit 205 Connect root@localhost as anonymous on 205 Query SHOW SLAVE STATUS 205 Query SELECT 'No such row' = 'No such row' 205 Query select count(*) from mysql.proc 205 Query call mtr.check_testcase() 205 Query select @@datadir 205 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 205 Query SELECT @@wsrep_on 205 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 205 Quit 206 Connect root@localhost as anonymous on test 206 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 206 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'wsrep_on' AND VARIABLE_VALUE='ON' 206 Query SHOW STATUS LIKE 'wsrep_ready' 206 Query SHOW STATUS LIKE 'wsrep_ready' 190114 12:45:17 207 Connect root@localhost as anonymous on test 207 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 207 Query CREATE TABLE t1 (f1 INT PRIMARY KEY, f2 INT) ENGINE=InnoDB 207 Query SET SESSION wsrep_trx_fragment_size = 128 207 Query START TRANSACTION 207 Query INSERT INTO t1 VALUES (1, 0) 208 Connect root@localhost as anonymous on test 208 Query SET SESSION wsrep_trx_fragment_size = 1 208 Query START TRANSACTION 208 Query INSERT INTO t1 VALUES (2, 0) 208 Query DROP TABLE t1 208 Quit 207 Quit 206 Quit 211 Connect root@localhost as anonymous on 211 Query set SQL_LOG_BIN=0 211 Query set WSREP_ON=0 211 Query set debug_dbug="" 211 Query use mtr 211 Query set session transaction read write 211 Query create temporary table error_log ( row int auto_increment primary key, suspicious int default 1, file_name varchar(255), line varchar(1024) default null ) engine=myisam 211 Query load data infile '/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.1.err.warnings' into table error_log fields terminated by 'xykls37' escaped by '' ignore 1 lines (line) set file_name='/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.1.err' 211 Query call mtr.check_warnings(@result) 211 Query select @result = 0 211 Quit 212 Connect root@localhost as anonymous on 212 Query SHOW SLAVE STATUS 212 Query SELECT 'No such row' = 'No such row' 212 Query select count(*) from mysql.proc 212 Query call mtr.check_testcase() 212 Query select @@datadir 212 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 212 Query SELECT @@wsrep_on 212 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 212 Quit 190114 12:45:18 213 Connect root@localhost as anonymous on 213 Query SET SESSION wsrep_sync_wait = 0 213 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 213 Quit 214 Connect root@localhost as anonymous on 214 Query SHOW SLAVE STATUS 214 Query SELECT 'No such row' = 'No such row' 214 Query select count(*) from mysql.proc 214 Query call mtr.check_testcase() 214 Query select @@datadir 214 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 214 Query SELECT @@wsrep_on 214 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 214 Quit 215 Connect root@localhost as anonymous on test 215 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 215 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'wsrep_on' AND VARIABLE_VALUE='ON' 215 Query SHOW STATUS LIKE 'wsrep_ready' 215 Query SHOW STATUS LIKE 'wsrep_ready' 190114 12:45:20 216 Connect root@localhost as anonymous on test 216 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 190114 12:45:21 217 Connect root@localhost as anonymous on test 217 Query SET SESSION wsrep_trx_fragment_size = 1 216 Query CREATE TABLE ten (f1 INTEGER) 216 Query INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10) 216 Query CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY, f2 INTEGER) Engine=InnoDB 216 Query SET SESSION wsrep_trx_fragment_size = 1 217 Query INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4 216 Query INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4 190114 12:53:41 215 Query DROP TABLE t1 190114 12:53:42 215 Query DROP TABLE ten 217 Quit 216 Quit 215 Quit 20219 Connect root@localhost as anonymous on 20219 Query set SQL_LOG_BIN=0 20219 Query set WSREP_ON=0 20219 Query set debug_dbug="" 20219 Query use mtr 20219 Query set session transaction read write 20219 Query create temporary table error_log ( row int auto_increment primary key, suspicious int default 1, file_name varchar(255), line varchar(1024) default null ) engine=myisam 20219 Query load data infile '/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.1.err.warnings' into table error_log fields terminated by 'xykls37' escaped by '' ignore 1 lines (line) set file_name='/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.1.err' 20219 Query call mtr.check_warnings(@result) 20219 Query select @result = 0 20219 Quit 20220 Connect root@localhost as anonymous on 20220 Query SHOW SLAVE STATUS 20220 Query SELECT 'No such row' = 'No such row' 20220 Query select count(*) from mysql.proc 20220 Query call mtr.check_testcase() 20220 Query select @@datadir 20220 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 20220 Query SELECT @@wsrep_on 20220 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 20220 Quit 20221 Connect root@localhost as anonymous on 20221 Query SET SESSION wsrep_sync_wait = 0 20221 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 20221 Quit 20222 Connect root@localhost as anonymous on 20222 Query SHOW SLAVE STATUS 20222 Query SELECT 'No such row' = 'No such row' 20222 Query select count(*) from mysql.proc 20222 Query call mtr.check_testcase() 20222 Query select @@datadir 20222 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 20222 Query SELECT @@wsrep_on 20222 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 20222 Quit 20223 Connect root@localhost as anonymous on test 20223 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 20223 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'wsrep_on' AND VARIABLE_VALUE='ON' 20223 Query SHOW STATUS LIKE 'wsrep_ready' 20223 Query SHOW STATUS LIKE 'wsrep_ready' 190114 12:53:44 20224 Connect root@localhost as anonymous on test 20224 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 20224 Query select count(*) = 0 from information_schema.session_variables where variable_name = 'debug_sync' and variable_value like 'on %' 20224 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' 20225 Connect root@localhost as anonymous on test 20225 Query SET SESSION wsrep_sync_wait = 0 20224 Query CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB 20224 Query SET SESSION wsrep_trx_fragment_size = 1 20224 Query SET AUTOCOMMIT=OFF 20224 Query INSERT INTO t1 VALUES (1) 20224 Query SELECT * FROM t1 FOR UPDATE 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync' 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'apply_monitor_slave_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,after_replicate_sync' 20224 Query INSERT INTO t1 VALUES (3) 20225 Query SELECT STRCMP('apply_monitor_slave_enter_sync', 'after_replicate_sync') = -1 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'after_replicate_sync apply_monitor_slave_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,abort_trx_end' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync' 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'abort_trx_end after_replicate_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=after_replicate_sync' 190114 12:53:45 20224 Query ROLLBACK 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end' 20224 Query SELECT * FROM t1 20224 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2 20224 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 20224 Query SET AUTOCOMMIT=ON 20224 Query SET SESSION wsrep_trx_fragment_size = 0 20224 Query DELETE FROM t1 20224 Query DROP TABLE t1 20224 Query CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB 20224 Query SET SESSION wsrep_trx_fragment_size = 1 20224 Query SET AUTOCOMMIT=OFF 20224 Query INSERT INTO t1 VALUES (1) 20224 Query SELECT * FROM t1 FOR UPDATE 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync' 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'apply_monitor_slave_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,local_monitor_master_enter_sync' 20224 Query INSERT INTO t1 VALUES (3) 20225 Query SELECT STRCMP('apply_monitor_slave_enter_sync', 'local_monitor_master_enter_sync') = -1 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'apply_monitor_slave_enter_sync local_monitor_master_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,abort_trx_end' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync' 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'abort_trx_end local_monitor_master_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=local_monitor_master_enter_sync' 20224 Query ROLLBACK 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end' 20224 Query SELECT * FROM t1 20224 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2 20224 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 20224 Query SET AUTOCOMMIT=ON 20224 Query SET SESSION wsrep_trx_fragment_size = 0 20224 Query DELETE FROM t1 20224 Query DROP TABLE t1 20224 Query CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB 20224 Query SET SESSION wsrep_trx_fragment_size = 1 20224 Query SET AUTOCOMMIT=OFF 20224 Query INSERT INTO t1 VALUES (1) 20224 Query SELECT * FROM t1 FOR UPDATE 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync' 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'apply_monitor_slave_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_master_enter_sync' 20224 Query INSERT INTO t1 VALUES (3) 20225 Query SELECT STRCMP('apply_monitor_slave_enter_sync', 'apply_monitor_master_enter_sync') = -1 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'apply_monitor_master_enter_sync apply_monitor_slave_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,abort_trx_end' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync' 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'abort_trx_end apply_monitor_master_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_master_enter_sync' 20224 Query ROLLBACK 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end' 20224 Query SELECT * FROM t1 20224 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2 20224 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 20224 Query SET AUTOCOMMIT=ON 20224 Query SET SESSION wsrep_trx_fragment_size = 0 20224 Query DELETE FROM t1 20224 Query DROP TABLE t1 20224 Query CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB 20224 Query SET SESSION wsrep_trx_fragment_size = 1 20224 Query SET AUTOCOMMIT=OFF 20224 Query INSERT INTO t1 VALUES (1) 20224 Query SELECT * FROM t1 FOR UPDATE 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync' 190114 12:53:46 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'apply_monitor_slave_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,commit_monitor_master_enter_sync' 20224 Query INSERT INTO t1 VALUES (3) 20225 Query SELECT STRCMP('apply_monitor_slave_enter_sync', 'commit_monitor_master_enter_sync') = -1 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'apply_monitor_slave_enter_sync commit_monitor_master_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,abort_trx_end' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync' 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'abort_trx_end commit_monitor_master_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=commit_monitor_master_enter_sync' 20224 Query ROLLBACK 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end' 20224 Query SELECT * FROM t1 20224 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2 20224 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 20224 Query SET AUTOCOMMIT=ON 20224 Query SET SESSION wsrep_trx_fragment_size = 0 20224 Query DELETE FROM t1 20224 Query DROP TABLE t1 20224 Query CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB 20224 Query SET SESSION wsrep_trx_fragment_size = 1 20224 Query SET AUTOCOMMIT=OFF 20224 Query INSERT INTO t1 VALUES (1) 20224 Query SELECT * FROM t1 FOR UPDATE 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync' 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'apply_monitor_slave_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,after_replicate_sync' 20225 Query SELECT STRCMP('apply_monitor_slave_enter_sync', 'after_replicate_sync') = -1 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20224 Query COMMIT 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'after_replicate_sync apply_monitor_slave_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,abort_trx_end' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync' 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'abort_trx_end after_replicate_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=after_replicate_sync' 20224 Query ROLLBACK 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end' 20224 Query SELECT * FROM t1 20224 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 1 20224 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2 20224 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 20224 Query SET AUTOCOMMIT=ON 20224 Query SET SESSION wsrep_trx_fragment_size = 0 20224 Query DELETE FROM t1 20224 Query DROP TABLE t1 20224 Query CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB 20224 Query SET SESSION wsrep_trx_fragment_size = 1 20224 Query SET AUTOCOMMIT=OFF 20224 Query INSERT INTO t1 VALUES (1) 20224 Query SELECT * FROM t1 FOR UPDATE 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync' 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'apply_monitor_slave_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,local_monitor_master_enter_sync' 20224 Query COMMIT 20225 Query SELECT STRCMP('apply_monitor_slave_enter_sync', 'local_monitor_master_enter_sync') = -1 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'apply_monitor_slave_enter_sync local_monitor_master_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,abort_trx_end' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync' 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'abort_trx_end local_monitor_master_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=local_monitor_master_enter_sync' 20224 Query ROLLBACK 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end' 20224 Query SELECT * FROM t1 20224 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 1 20224 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2 20224 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 20224 Query SET AUTOCOMMIT=ON 20224 Query SET SESSION wsrep_trx_fragment_size = 0 20224 Query DELETE FROM t1 20224 Query DROP TABLE t1 20224 Query CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB 20224 Query SET SESSION wsrep_trx_fragment_size = 1 20224 Query SET AUTOCOMMIT=OFF 20224 Query INSERT INTO t1 VALUES (1) 20224 Query SELECT * FROM t1 FOR UPDATE 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync' 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'apply_monitor_slave_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_master_enter_sync' 20224 Query COMMIT 20225 Query SELECT STRCMP('apply_monitor_slave_enter_sync', 'apply_monitor_master_enter_sync') = -1 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'apply_monitor_master_enter_sync apply_monitor_slave_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,abort_trx_end' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync' 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'abort_trx_end apply_monitor_master_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_master_enter_sync' 20224 Query ROLLBACK 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end' 20224 Query SELECT * FROM t1 190114 12:53:47 20224 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 1 20224 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2 20224 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 20224 Query SET AUTOCOMMIT=ON 20224 Query SET SESSION wsrep_trx_fragment_size = 0 20224 Query DELETE FROM t1 20224 Query DROP TABLE t1 20224 Query CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB 20224 Query SET SESSION wsrep_trx_fragment_size = 1 20224 Query SET AUTOCOMMIT=OFF 20224 Query INSERT INTO t1 VALUES (1) 20224 Query SELECT * FROM t1 FOR UPDATE 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync' 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'apply_monitor_slave_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,commit_monitor_master_enter_sync' 20225 Query SELECT STRCMP('apply_monitor_slave_enter_sync', 'commit_monitor_master_enter_sync') = -1 20224 Query COMMIT 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'apply_monitor_slave_enter_sync commit_monitor_master_enter_sync' 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'apply_monitor_slave_enter_sync commit_monitor_master_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=d,abort_trx_end' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync' 20225 Query SELECT @@wsrep_on 20225 Query SET SESSION wsrep_on = 0 20225 Query SELECT 10 * 10 20225 Query SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'abort_trx_end commit_monitor_master_enter_sync' 20225 Query SET SESSION wsrep_on = 1 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=commit_monitor_master_enter_sync' 20224 Query ROLLBACK 20225 Query SET GLOBAL wsrep_provider_options = 'dbug=' 20225 Query SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end' 20224 Query SELECT * FROM t1 20224 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 1 20224 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2 20224 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 20224 Query SET AUTOCOMMIT=ON 20224 Query SET SESSION wsrep_trx_fragment_size = 0 20224 Query DELETE FROM t1 20224 Query DROP TABLE t1 20224 Query CALL mtr.add_suppression("WSREP: fragment replication failed: 1") 20224 Quit 20225 Quit 20223 Quit 20242 Connect root@localhost as anonymous on 20242 Query set SQL_LOG_BIN=0 20242 Query set WSREP_ON=0 20242 Query set debug_dbug="" 20242 Query use mtr 20242 Query set session transaction read write 20242 Query create temporary table error_log ( row int auto_increment primary key, suspicious int default 1, file_name varchar(255), line varchar(1024) default null ) engine=myisam 20242 Query load data infile '/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.1.err.warnings' into table error_log fields terminated by 'xykls37' escaped by '' ignore 1 lines (line) set file_name='/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.1.err' 20242 Query call mtr.check_warnings(@result) 20242 Query select @result = 0 20242 Quit 20243 Connect root@localhost as anonymous on 20243 Query SHOW SLAVE STATUS 20243 Query SELECT 'No such row' = 'No such row' 20243 Query select count(*) from mysql.proc 20243 Query call mtr.check_testcase() 20243 Query select @@datadir 20243 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 20243 Query SELECT @@wsrep_on 20243 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 20243 Quit 20244 Connect root@localhost as anonymous on 20244 Query SET SESSION wsrep_sync_wait = 0 20244 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 20244 Quit 20245 Connect root@localhost as anonymous on 20245 Query SHOW SLAVE STATUS 20245 Query SELECT 'No such row' = 'No such row' 20245 Query select count(*) from mysql.proc 20245 Query call mtr.check_testcase() 20245 Query select @@datadir 20245 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 20245 Query SELECT @@wsrep_on 20245 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 20245 Quit 20246 Connect root@localhost as anonymous on test 20246 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 20246 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'wsrep_on' AND VARIABLE_VALUE='ON' 20246 Query SHOW STATUS LIKE 'wsrep_ready' 20246 Query SHOW STATUS LIKE 'wsrep_ready' 190114 12:53:49 20247 Connect root@localhost as anonymous on test 20247 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 20247 Query CREATE TABLE t1 (f1 TEXT) ENGINE=InnoDB 20247 Query SET SESSION wsrep_trx_fragment_size = 1 20247 Query SET AUTOCOMMIT=OFF 20247 Query START TRANSACTION 20247 Query INSERT INTO t1 VALUES (REPEAT('x', 65535)) 20247 Query COMMIT 190114 12:53:50 20246 Quit 20247 Quit 20249 Connect root@localhost as anonymous on 20249 Query set SQL_LOG_BIN=0 20249 Query set WSREP_ON=0 20249 Query set debug_dbug="" 20249 Query use mtr 20249 Query set session transaction read write 20249 Query create temporary table error_log ( row int auto_increment primary key, suspicious int default 1, file_name varchar(255), line varchar(1024) default null ) engine=myisam 20249 Query load data infile '/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.1.err.warnings' into table error_log fields terminated by 'xykls37' escaped by '' ignore 1 lines (line) set file_name='/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.1.err' 20249 Query call mtr.check_warnings(@result) 20249 Query select @result = 0 20249 Quit 20250 Connect root@localhost as anonymous on 20250 Query SHOW SLAVE STATUS 20250 Query SELECT 'No such row' = 'No such row' 20250 Query select count(*) from mysql.proc 20250 Query call mtr.check_testcase() 20250 Query select @@datadir 20250 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 20250 Query SELECT @@wsrep_on 20250 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 20250 Quit 20251 Connect root@localhost as anonymous on 20251 Query SET SESSION wsrep_sync_wait = 0 20251 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 20251 Quit 20252 Connect root@localhost as anonymous on 20252 Query SHOW SLAVE STATUS 20252 Query SELECT 'No such row' = 'No such row' 20252 Query select count(*) from mysql.proc 20252 Query call mtr.check_testcase() 20252 Query select @@datadir 20252 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 20252 Query SELECT @@wsrep_on 20252 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 20252 Quit 20253 Connect root@localhost as anonymous on test 20253 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 20253 Query SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'wsrep_on' AND VARIABLE_VALUE='ON' 20253 Query SHOW STATUS LIKE 'wsrep_ready' 20253 Query SHOW STATUS LIKE 'wsrep_ready' 190114 12:53:52 20254 Connect root@localhost as anonymous on test 20254 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 20254 Query SELECT @@global.auto_increment_offset 20254 Query SELECT COUNT(*) > 0 FROM wsrep_schema.SR 190114 12:54:04 20254 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 190114 12:54:08 20254 Query SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'