/home/stepan/galera/git/10.4/server/sql/mysqld, Version: 10.4.2-MariaDB-debug-log (Source distribution). started with: Tcp port: 16041 Unix socket: /home/stepan/galera/git/10.4/server/mysql-test/var/tmp/1/mysqld.2.sock Time Id Command Argument 190114 12:44:56 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 29 Connect root@localhost as anonymous on 29 Query SET SESSION wsrep_sync_wait = 0 29 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 29 Quit 30 Connect root@localhost as anonymous on 30 Query SHOW SLAVE STATUS 30 Query SELECT 'No such row' = 'No such row' 30 Query select count(*) from mysql.proc 30 Query call mtr.check_testcase() 30 Query select @@datadir 30 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 30 Query SELECT @@wsrep_on 30 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 30 Quit 190114 12:44:57 31 Connect root@localhost as anonymous on test 190114 12:44:58 31 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 31 Query SELECT COUNT(*) = 0 FROM t1 31 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 31 Query DROP TABLE t1 31 Quit 34 Connect root@localhost as anonymous on 34 Query set SQL_LOG_BIN=0 34 Query set WSREP_ON=0 34 Query set debug_dbug="" 34 Query use mtr 34 Query set session transaction read write 34 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 34 Query load data infile '/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.2.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.2.err' 34 Query call mtr.check_warnings(@result) 34 Query select @result = 0 34 Quit 35 Connect root@localhost as anonymous on 35 Query SHOW SLAVE STATUS 35 Query SELECT 'No such row' = 'No such row' 35 Query select count(*) from mysql.proc 35 Query call mtr.check_testcase() 35 Query select @@datadir 35 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 35 Query SELECT @@wsrep_on 35 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 35 Quit 190114 12:44:59 36 Connect root@localhost as anonymous on 36 Query SET SESSION wsrep_sync_wait = 0 36 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 36 Quit 37 Connect root@localhost as anonymous on 37 Query SHOW SLAVE STATUS 37 Query SELECT 'No such row' = 'No such row' 37 Query select count(*) from mysql.proc 37 Query call mtr.check_testcase() 37 Query select @@datadir 37 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 37 Query SELECT @@wsrep_on 37 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 37 Quit 190114 12:45:00 38 Connect root@localhost as anonymous on test 190114 12:45:01 38 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 38 Query DROP TABLE t1 38 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 38 Query DROP TABLE t2 38 Quit 41 Connect root@localhost as anonymous on 41 Query set SQL_LOG_BIN=0 41 Query set WSREP_ON=0 41 Query set debug_dbug="" 41 Query use mtr 41 Query set session transaction read write 41 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 41 Query load data infile '/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.2.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.2.err' 41 Query call mtr.check_warnings(@result) 41 Query select @result = 0 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 43 Query SET SESSION wsrep_sync_wait = 0 43 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 43 Quit 44 Connect root@localhost as anonymous on 44 Query SHOW SLAVE STATUS 44 Query SELECT 'No such row' = 'No such row' 44 Query select count(*) from mysql.proc 44 Query call mtr.check_testcase() 44 Query select @@datadir 44 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 44 Query SELECT @@wsrep_on 44 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 44 Quit 190114 12:45:02 45 Connect root@localhost as anonymous on test 190114 12:45:03 45 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 190114 12:45:05 45 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 45 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.2.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.2.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() 190114 12:45:06 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 190114 12:45:07 52 Connect root@localhost as anonymous on test 190114 12:45:08 52 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 52 Query SELECT COUNT(*) > 0 FROM wsrep_schema.SR 52 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 52 Query SELECT COUNT(*) > 0 FROM t1 52 Quit 54 Connect root@localhost as anonymous on 54 Query set SQL_LOG_BIN=0 54 Query set WSREP_ON=0 54 Query set debug_dbug="" 54 Query use mtr 54 Query set session transaction read write 54 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 54 Query load data infile '/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.2.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.2.err' 54 Query call mtr.check_warnings(@result) 54 Query select @result = 0 54 Quit 55 Connect root@localhost as anonymous on 55 Query SHOW SLAVE STATUS 55 Query SELECT 'No such row' = 'No such row' 55 Query select count(*) from mysql.proc 55 Query call mtr.check_testcase() 55 Query select @@datadir 55 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 55 Query SELECT @@wsrep_on 55 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 55 Quit 56 Connect root@localhost as anonymous on 56 Query SET SESSION wsrep_sync_wait = 0 56 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 56 Quit 57 Connect root@localhost as anonymous on 57 Query SHOW SLAVE STATUS 57 Query SELECT 'No such row' = 'No such row' 57 Query select count(*) from mysql.proc 57 Query call mtr.check_testcase() 57 Query select @@datadir 57 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 57 Query SELECT @@wsrep_on 57 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 57 Quit 190114 12:45:09 58 Connect root@localhost as anonymous on test 190114 12:45:10 58 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 190114 12:45:12 58 Quit 121 Connect root@localhost as anonymous on 121 Query set SQL_LOG_BIN=0 121 Query set WSREP_ON=0 121 Query set debug_dbug="" 121 Query use mtr 121 Query set session transaction read write 121 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 121 Query load data infile '/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.2.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.2.err' 121 Query call mtr.check_warnings(@result) 121 Query select @result = 0 121 Quit 122 Connect root@localhost as anonymous on 122 Query SHOW SLAVE STATUS 122 Query SELECT 'No such row' = 'No such row' 122 Query select count(*) from mysql.proc 122 Query call mtr.check_testcase() 122 Query select @@datadir 122 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 122 Query SELECT @@wsrep_on 122 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 122 Quit 123 Connect root@localhost as anonymous on 123 Query SET SESSION wsrep_sync_wait = 0 123 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 123 Quit 124 Connect root@localhost as anonymous on 124 Query SHOW SLAVE STATUS 124 Query SELECT 'No such row' = 'No such row' 124 Query select count(*) from mysql.proc 124 Query call mtr.check_testcase() 124 Query select @@datadir 124 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 124 Query SELECT @@wsrep_on 124 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 124 Quit 190114 12:45:13 125 Connect root@localhost as anonymous on test 190114 12:45:14 125 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 125 Query SET GLOBAL wsrep_ignore_apply_errors = 2 125 Query SELECT COUNT(*) = 1 125 Query CALL mtr.add_suppression("Could not execute Delete_rows event on table") 125 Query CALL mtr.add_suppression("Can't find record in 't1'") 125 Query SET GLOBAL wsrep_ignore_apply_errors = 7 190114 12:45:15 125 Quit 127 Connect root@localhost as anonymous on 127 Query set SQL_LOG_BIN=0 127 Query set WSREP_ON=0 127 Query set debug_dbug="" 127 Query use mtr 127 Query set session transaction read write 127 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 127 Query load data infile '/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.2.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.2.err' 127 Query call mtr.check_warnings(@result) 127 Query select @result = 0 127 Quit 128 Connect root@localhost as anonymous on 128 Query SHOW SLAVE STATUS 128 Query SELECT 'No such row' = 'No such row' 128 Query select count(*) from mysql.proc 128 Query call mtr.check_testcase() 128 Query select @@datadir 128 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 128 Query SELECT @@wsrep_on 128 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 128 Quit 129 Connect root@localhost as anonymous on 129 Query SET SESSION wsrep_sync_wait = 0 129 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 129 Quit 130 Connect root@localhost as anonymous on 130 Query SHOW SLAVE STATUS 130 Query SELECT 'No such row' = 'No such row' 130 Query select count(*) from mysql.proc 130 Query call mtr.check_testcase() 130 Query select @@datadir 130 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 130 Query SELECT @@wsrep_on 130 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 130 Quit 190114 12:45:16 131 Connect root@localhost as anonymous on test 190114 12:45:17 131 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 131 Query ALTER TABLE t1 DROP COLUMN f2 131 Quit 134 Connect root@localhost as anonymous on 134 Query set SQL_LOG_BIN=0 134 Query set WSREP_ON=0 134 Query set debug_dbug="" 134 Query use mtr 134 Query set session transaction read write 134 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 134 Query load data infile '/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.2.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.2.err' 134 Query call mtr.check_warnings(@result) 134 Query select @result = 0 134 Quit 135 Connect root@localhost as anonymous on 135 Query SHOW SLAVE STATUS 135 Query SELECT 'No such row' = 'No such row' 135 Query select count(*) from mysql.proc 135 Query call mtr.check_testcase() 190114 12:45:18 135 Query select @@datadir 135 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 135 Query SELECT @@wsrep_on 135 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 135 Quit 136 Connect root@localhost as anonymous on 136 Query SET SESSION wsrep_sync_wait = 0 136 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 136 Quit 137 Connect root@localhost as anonymous on 137 Query SHOW SLAVE STATUS 137 Query SELECT 'No such row' = 'No such row' 137 Query select count(*) from mysql.proc 137 Query call mtr.check_testcase() 137 Query select @@datadir 137 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 137 Query SELECT @@wsrep_on 137 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 137 Quit 190114 12:45:19 138 Connect root@localhost as anonymous on test 190114 12:45:20 138 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 190114 12:45:21 138 Query SELECT @@wsrep_slave_threads 138 Query SET GLOBAL wsrep_slave_threads = 4 138 Query SET SESSION wsrep_trx_fragment_size = 1 138 Query INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4 190114 12:53:38 138 Query SELECT COUNT(*) = 30000 FROM t1 190114 12:53:41 138 Query SELECT COUNT(DISTINCT f1) = 30000 FROM t1 138 Query SELECT COUNT(*) = 6 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' 138 Query SET GLOBAL wsrep_slave_threads = 1 190114 12:53:42 138 Quit 10144 Connect root@localhost as anonymous on 10144 Query set SQL_LOG_BIN=0 10144 Query set WSREP_ON=0 10144 Query set debug_dbug="" 10144 Query use mtr 10144 Query set session transaction read write 10144 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 10144 Query load data infile '/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.2.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.2.err' 10144 Query call mtr.check_warnings(@result) 10144 Query select @result = 0 10144 Quit 10145 Connect root@localhost as anonymous on 10145 Query SHOW SLAVE STATUS 10145 Query SELECT 'No such row' = 'No such row' 10145 Query select count(*) from mysql.proc 10145 Query call mtr.check_testcase() 10145 Query select @@datadir 10145 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 10145 Query SELECT @@wsrep_on 10145 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 10145 Quit 10146 Connect root@localhost as anonymous on 10146 Query SET SESSION wsrep_sync_wait = 0 10146 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 10146 Quit 10147 Connect root@localhost as anonymous on 10147 Query SHOW SLAVE STATUS 10147 Query SELECT 'No such row' = 'No such row' 10147 Query select count(*) from mysql.proc 10147 Query call mtr.check_testcase() 10147 Query select @@datadir 10147 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 10147 Query SELECT @@wsrep_on 10147 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 10147 Quit 190114 12:53:43 10148 Connect root@localhost as anonymous on test 190114 12:53:44 10148 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 10148 Query SET AUTOCOMMIT=ON 10148 Query INSERT INTO t1 VALUES (2) 190114 12:53:45 10148 Query SELECT * FROM t1 10148 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2 10148 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 10148 Query SET AUTOCOMMIT=ON 10148 Query INSERT INTO t1 VALUES (2) 10148 Query SELECT * FROM t1 10148 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2 10148 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 10148 Query SET AUTOCOMMIT=ON 10148 Query INSERT INTO t1 VALUES (2) 10148 Query SELECT * FROM t1 10148 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2 10148 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 10148 Query SET AUTOCOMMIT=ON 10148 Query INSERT INTO t1 VALUES (2) 190114 12:53:46 10148 Query SELECT * FROM t1 10148 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2 10148 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 10148 Query SET AUTOCOMMIT=ON 10148 Query INSERT INTO t1 VALUES (2) 10148 Query SELECT * FROM t1 10148 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 1 10148 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2 10148 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 10148 Query SET AUTOCOMMIT=ON 10148 Query INSERT INTO t1 VALUES (2) 10148 Query SELECT * FROM t1 10148 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 1 10148 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2 10148 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 10148 Query SET AUTOCOMMIT=ON 10148 Query INSERT INTO t1 VALUES (2) 190114 12:53:47 10148 Query SELECT * FROM t1 10148 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 1 10148 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2 10148 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 10148 Query SET AUTOCOMMIT=ON 10148 Query INSERT INTO t1 VALUES (2) 10148 Query SELECT * FROM t1 10148 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 1 10148 Query SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2 10148 Query SELECT COUNT(*) = 0 FROM wsrep_schema.SR 10148 Quit 10157 Connect root@localhost as anonymous on 10157 Query set SQL_LOG_BIN=0 10157 Query set WSREP_ON=0 10157 Query set debug_dbug="" 10157 Query use mtr 10157 Query set session transaction read write 10157 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 10157 Query load data infile '/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.2.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.2.err' 10157 Query call mtr.check_warnings(@result) 10157 Query select @result = 0 10157 Quit 10158 Connect root@localhost as anonymous on 10158 Query SHOW SLAVE STATUS 10158 Query SELECT 'No such row' = 'No such row' 10158 Query select count(*) from mysql.proc 10158 Query call mtr.check_testcase() 10158 Query select @@datadir 10158 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 10158 Query SELECT @@wsrep_on 10158 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 10158 Quit 10159 Connect root@localhost as anonymous on 10159 Query SET SESSION wsrep_sync_wait = 0 10159 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 10159 Quit 10160 Connect root@localhost as anonymous on 10160 Query SHOW SLAVE STATUS 10160 Query SELECT 'No such row' = 'No such row' 10160 Query select count(*) from mysql.proc 10160 Query call mtr.check_testcase() 10160 Query select @@datadir 10160 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 10160 Query SELECT @@wsrep_on 10160 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 10160 Quit 190114 12:53:48 10161 Connect root@localhost as anonymous on test 190114 12:53:49 10161 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 10161 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed' 10161 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed' 10161 Query SELECT (30222 - 30221) = 1 AS wsrep_last_committed_delta 190114 12:53:50 10161 Query SELECT COUNT(*) = 1 FROM t1 10161 Query SELECT LENGTH(f1) = 65535 FROM t1 10161 Query DROP TABLE t1 10161 Quit 10163 Connect root@localhost as anonymous on 10163 Query set SQL_LOG_BIN=0 10163 Query set WSREP_ON=0 10163 Query set debug_dbug="" 10163 Query use mtr 10163 Query set session transaction read write 10163 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 10163 Query load data infile '/home/stepan/galera/git/10.4/server/mysql-test/var/1/log/mysqld.2.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.2.err' 10163 Query call mtr.check_warnings(@result) 10163 Query select @result = 0 10163 Quit 10164 Connect root@localhost as anonymous on 10164 Query SHOW SLAVE STATUS 10164 Query SELECT 'No such row' = 'No such row' 10164 Query select count(*) from mysql.proc 10164 Query call mtr.check_testcase() 10164 Query select @@datadir 10164 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 10164 Query SELECT @@wsrep_on 10164 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 10164 Quit 10165 Connect root@localhost as anonymous on 10165 Query SET SESSION wsrep_sync_wait = 0 10165 Query SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 10165 Quit 10166 Connect root@localhost as anonymous on 10166 Query SHOW SLAVE STATUS 10166 Query SELECT 'No such row' = 'No such row' 10166 Query select count(*) from mysql.proc 10166 Query call mtr.check_testcase() 10166 Query select @@datadir 10166 Query SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'wsrep' AND PLUGIN_STATUS='ACTIVE' 10166 Query SELECT @@wsrep_on 10166 Query SELECT COUNT(*) FROM information_schema.innodb_trx WHERE trx_mysql_thread_id != 0 10166 Quit 190114 12:53:51 10167 Connect root@localhost as anonymous on test 190114 12:53:52 10167 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' 10167 Query SELECT @@global.auto_increment_offset 10167 Query CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB 10167 Query SELECT @@wsrep_trx_fragment_size 10167 Query SET SESSION wsrep_trx_fragment_size = 1 10167 Query SET AUTOCOMMIT=OFF 10167 Query START TRANSACTION 10167 Query INSERT INTO t1 VALUES (1) 10167 Query INSERT INTO t1 VALUES (2) 10167 Query INSERT INTO t1 VALUES (3) 10167 Query INSERT INTO t1 VALUES (4) 10167 Query INSERT INTO t1 VALUES (5) 10167 Query SELECT COUNT(*) > 0 FROM wsrep_schema.SR 10173 Connect root@localhost as anonymous on test 10173 Query SET SESSION wsrep_sync_wait=0 10173 Query SELECT @@wsrep_cluster_address 10173 Query SET GLOBAL wsrep_cluster_address = '' 190114 12:54:04 10173 Query SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size' 10173 Query SET SESSION wsrep_sync_wait = DEFAULT 190114 12:54:05 10173 Query SET GLOBAL wsrep_cluster_address='gcomm://127.0.0.1:16042' 190114 12:54:08 10180 Connect root@localhost as anonymous on test 10180 Query SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready'