Logging: /home/mleich/Server/10.3/mysql-test/mysql-test-run.pl --mem rpl_t_s_4 vardir: /home/mleich/Server/10.3/bld_debug/mysql-test/var Checking leftover processes... Removing old var directory... Creating var directory '/home/mleich/Server/10.3/bld_debug/mysql-test/var'... - symlinking 'var' to '/dev/shm/var_auto_sUXv' Checking supported features... MariaDB Version 10.3.14-MariaDB-debug - SSL connections supported - binaries are debug compiled Collecting tests... Installing system database... ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019 main.rpl_t_s_4 'innodb,mix' [ skipped ] Not ROW format include/master-slave.inc [connection master] CREATE TABLE t1 (col1 INT, col2 INT, col_c CHAR(20), KEY idx2 (col_c)) ENGINE = InnoDB ; INSERT INTO t1 (col1, col2, col_c) VALUES ( 1 , 1, '1'); INSERT INTO t1 (col1, col2, col_c) VALUES ( 2 , 2, '2'); INSERT INTO t1 (col1, col2, col_c) VALUES ( 3 , 3, '3'); INSERT INTO t1 (col1, col2, col_c) VALUES ( 4 , 4, '3333333333'); INSERT INTO t1 (col1, col2, col_c) VALUES ( 5 , 5, '3333333333'); UPDATE t1 SET col2 = 453 WHERE col1 IN (5,4); UPDATE t1 SET col2 = 130 WHERE col1 IN (5,4); UPDATE t1 SET col2 = 99 WHERE col1 IN (5,4); UPDATE t1 SET col2 = 202 WHERE col1 IN (5,4); UPDATE t1 SET col2 = 464 WHERE col1 IN (5,4); UPDATE t1 SET col2 = 430 WHERE col1 IN (5,4); INSERT INTO t1 (col1, col2, col_c) VALUES ( 6 , 6, '6'); ALTER TABLE t1 ADD UNIQUE KEY uidx2 ( col1, col_c ); UPDATE t1 SET col2 = 213 WHERE col1 = 5; main.rpl_t_s_4 'innodb,row' [ fail ] Test ended at 2019-02-26 20:14:49 CURRENT_TEST: main.rpl_t_s_4 === SHOW MASTER STATUS === ---- 1. ---- File slave-bin.000001 Position 4000 Binlog_Do_DB Binlog_Ignore_DB ========================== === SHOW SLAVE STATUS === ---- 1. ---- Slave_IO_State Waiting for master to send event Master_Host 127.0.0.1 Master_User root Master_Port 16000 Connect_Retry 1 Master_Log_File master-bin.000001 Read_Master_Log_Pos 4259 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 4301 Relay_Master_Log_File master-bin.000001 Slave_IO_Running Yes Slave_SQL_Running No Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno 1062 Last_Error Could not execute Update_rows_v1 event on table test.t1; Duplicate entry '5-3333333333' for key 'uidx2', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log master-bin.000001, end_log_pos 4228 Skip_Counter 0 Exec_Master_Log_Pos 4001 Relay_Log_Space 4868 Until_Condition None Until_Log_File Until_Log_Pos 0 Master_SSL_Allowed No Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master Master_SSL_Verify_Server_Cert No Last_IO_Errno 0 Last_IO_Error Last_SQL_Errno 1062 Last_SQL_Error Could not execute Update_rows_v1 event on table test.t1; Duplicate entry '5-3333333333' for key 'uidx2', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log master-bin.000001, end_log_pos 4228 Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_SSL_Crl Master_SSL_Crlpath Using_Gtid No Gtid_IO_Pos Replicate_Do_Domain_Ids Replicate_Ignore_Domain_Ids Parallel_Mode conservative SQL_Delay 0 SQL_Remaining_Delay Slave_SQL_Running_State Slave_DDL_Groups 2 Slave_Non_Transactional_Groups 0 Slave_Transactional_Groups 13 ========================= === SHOW PROCESSLIST === ---- 1. ---- Id 1 User system user Host db Command Daemon Time State InnoDB purge coordinator Info Progress 0.000 ---- 2. ---- Id 2 User system user Host db Command Daemon Time State InnoDB purge worker Info Progress 0.000 ---- 3. ---- Id 4 User system user Host db Command Daemon Time State InnoDB purge worker Info Progress 0.000 ---- 4. ---- Id 3 User system user Host db Command Daemon Time State InnoDB purge worker Info Progress 0.000 ---- 5. ---- Id 5 User system user Host db Command Daemon Time State InnoDB shutdown handler Info Progress 0.000 ---- 6. ---- Id 10 User root Host localhost:53766 db test Command Sleep Time 0 State Info Progress 0.000 ---- 7. ---- Id 11 User root Host localhost:53768 db test Command Sleep Time 1 State Info Progress 0.000 ---- 8. ---- Id 12 User system user Host db Command Slave_IO Time 0 State Waiting for master to send event Info Progress 0.000 ---- 9. ---- Id 14 User root Host localhost:53780 db test Command Query Time 0 State Init Info SHOW PROCESSLIST Progress 0.000 ---- 10. ---- Id 15 User root Host localhost:53782 db test Command Sleep Time 0 State Info Progress 0.000 ======================== analyze: sync_with_master mysqltest: At line 31: sync_slave_with_master failed: 'select master_pos_wait('master-bin.000001', 4259, 300, '')' returned NULL indicating slave SQL thread failure == /home/mleich/Server/10.3/bld_debug/mysql-test/var/tmp/analyze-sync_with_master-mysqld.2.err == ############################## default ############################## **** SHOW WARNINGS on default **** SHOW WARNINGS; Level Code Message **** SELECT replication-related variables on default **** SELECT NOW(), @@SERVER_ID; NOW() @@SERVER_ID 2019-02-26 20:14:48 2 **** SHOW SLAVE STATUS on default **** SHOW SLAVE STATUS; Slave_IO_State Waiting for master to send event Master_Host 127.0.0.1 Master_User root Master_Port 16000 Connect_Retry 1 Master_Log_File master-bin.000001 Read_Master_Log_Pos 4259 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 4301 Relay_Master_Log_File master-bin.000001 Slave_IO_Running Yes Slave_SQL_Running No Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno 1062 Last_Error Could not execute Update_rows_v1 event on table test.t1; Duplicate entry '5-3333333333' for key 'uidx2', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log master-bin.000001, end_log_pos 4228 Skip_Counter 0 Exec_Master_Log_Pos 4001 Relay_Log_Space 4868 Until_Condition None Until_Log_File Until_Log_Pos 0 Master_SSL_Allowed No Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master NULL Master_SSL_Verify_Server_Cert No Last_IO_Errno 0 Last_IO_Error Last_SQL_Errno 1062 Last_SQL_Error Could not execute Update_rows_v1 event on table test.t1; Duplicate entry '5-3333333333' for key 'uidx2', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log master-bin.000001, end_log_pos 4228 Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_SSL_Crl Master_SSL_Crlpath Using_Gtid No Gtid_IO_Pos Replicate_Do_Domain_Ids Replicate_Ignore_Domain_Ids Parallel_Mode conservative SQL_Delay 0 SQL_Remaining_Delay NULL Slave_SQL_Running_State Slave_DDL_Groups 2 Slave_Non_Transactional_Groups 0 Slave_Transactional_Groups 13 **** SHOW MASTER STATUS on default **** SHOW MASTER STATUS; File slave-bin.000001 Position 4000 Binlog_Do_DB Binlog_Ignore_DB **** SHOW SLAVE HOSTS on default **** SHOW SLAVE HOSTS; **** SHOW PROCESSLIST on default **** SHOW PROCESSLIST; Id User Host db Command Time State Info Progress 1 system user NULL Daemon NULL InnoDB purge coordinator NULL 0.000 2 system user NULL Daemon NULL InnoDB purge worker NULL 0.000 4 system user NULL Daemon NULL InnoDB purge worker NULL 0.000 3 system user NULL Daemon NULL InnoDB purge worker NULL 0.000 5 system user NULL Daemon NULL InnoDB shutdown handler NULL 0.000 12 system user NULL Slave_IO 0 Waiting for master to send event NULL 0.000 16 root localhost NULL Query 0 Init SHOW PROCESSLIST 0.000 **** SHOW BINARY LOGS on default **** SHOW BINARY LOGS; Log_name File_size slave-bin.000001 4000 **** SHOW BINLOG EVENTS on default **** binlog_name = 'slave-bin.000001' SHOW BINLOG EVENTS IN 'slave-bin.000001'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 4 Format_desc 2 256 Server ver: 10.3.14-MariaDB-debug-log, Binlog ver: 4 slave-bin.000001 256 Gtid_list 2 285 [] slave-bin.000001 285 Binlog_checkpoint 2 328 slave-bin.000001 slave-bin.000001 328 Gtid 1 370 GTID 0-1-1 slave-bin.000001 370 Query 1 523 use `test`; CREATE TABLE t1 (col1 INT, col2 INT, col_c CHAR(20), KEY idx2 (col_c)) ENGINE = InnoDB slave-bin.000001 523 Gtid 1 565 BEGIN GTID 0-1-2 slave-bin.000001 565 Annotate_rows 1 643 INSERT INTO t1 (col1, col2, col_c) VALUES ( 1 , 1, '1') slave-bin.000001 643 Table_map 1 692 table_id: 33 (test.t1) slave-bin.000001 692 Write_rows_v1 1 736 table_id: 33 flags: STMT_END_F slave-bin.000001 736 Xid 1 767 COMMIT /* xid=166 */ slave-bin.000001 767 Gtid 1 809 BEGIN GTID 0-1-3 slave-bin.000001 809 Annotate_rows 1 887 INSERT INTO t1 (col1, col2, col_c) VALUES ( 2 , 2, '2') slave-bin.000001 887 Table_map 1 936 table_id: 33 (test.t1) slave-bin.000001 936 Write_rows_v1 1 980 table_id: 33 flags: STMT_END_F slave-bin.000001 980 Xid 1 1011 COMMIT /* xid=168 */ slave-bin.000001 1011 Gtid 1 1053 BEGIN GTID 0-1-4 slave-bin.000001 1053 Annotate_rows 1 1131 INSERT INTO t1 (col1, col2, col_c) VALUES ( 3 , 3, '3') slave-bin.000001 1131 Table_map 1 1180 table_id: 33 (test.t1) slave-bin.000001 1180 Write_rows_v1 1 1224 table_id: 33 flags: STMT_END_F slave-bin.000001 1224 Xid 1 1255 COMMIT /* xid=170 */ slave-bin.000001 1255 Gtid 1 1297 BEGIN GTID 0-1-5 slave-bin.000001 1297 Annotate_rows 1 1384 INSERT INTO t1 (col1, col2, col_c) VALUES ( 4 , 4, '3333333333') slave-bin.000001 1384 Table_map 1 1433 table_id: 33 (test.t1) slave-bin.000001 1433 Write_rows_v1 1 1486 table_id: 33 flags: STMT_END_F slave-bin.000001 1486 Xid 1 1517 COMMIT /* xid=172 */ slave-bin.000001 1517 Gtid 1 1559 BEGIN GTID 0-1-6 slave-bin.000001 1559 Annotate_rows 1 1646 INSERT INTO t1 (col1, col2, col_c) VALUES ( 5 , 5, '3333333333') slave-bin.000001 1646 Table_map 1 1695 table_id: 33 (test.t1) slave-bin.000001 1695 Write_rows_v1 1 1748 table_id: 33 flags: STMT_END_F slave-bin.000001 1748 Xid 1 1779 COMMIT /* xid=174 */ slave-bin.000001 1779 Gtid 1 1821 BEGIN GTID 0-1-7 slave-bin.000001 1821 Annotate_rows 1 1888 UPDATE t1 SET col2 = 453 WHERE col1 IN (5,4) slave-bin.000001 1888 Table_map 1 1937 table_id: 33 (test.t1) slave-bin.000001 1937 Update_rows_v1 1 2051 table_id: 33 flags: STMT_END_F slave-bin.000001 2051 Xid 1 2082 COMMIT /* xid=176 */ slave-bin.000001 2082 Gtid 1 2124 BEGIN GTID 0-1-8 slave-bin.000001 2124 Annotate_rows 1 2191 UPDATE t1 SET col2 = 130 WHERE col1 IN (5,4) slave-bin.000001 2191 Table_map 1 2240 table_id: 33 (test.t1) slave-bin.000001 2240 Update_rows_v1 1 2354 table_id: 33 flags: STMT_END_F slave-bin.000001 2354 Xid 1 2385 COMMIT /* xid=178 */ slave-bin.000001 2385 Gtid 1 2427 BEGIN GTID 0-1-9 slave-bin.000001 2427 Annotate_rows 1 2493 UPDATE t1 SET col2 = 99 WHERE col1 IN (5,4) slave-bin.000001 2493 Table_map 1 2542 table_id: 33 (test.t1) slave-bin.000001 2542 Update_rows_v1 1 2656 table_id: 33 flags: STMT_END_F slave-bin.000001 2656 Xid 1 2687 COMMIT /* xid=180 */ slave-bin.000001 2687 Gtid 1 2729 BEGIN GTID 0-1-10 slave-bin.000001 2729 Annotate_rows 1 2796 UPDATE t1 SET col2 = 202 WHERE col1 IN (5,4) slave-bin.000001 2796 Table_map 1 2845 table_id: 33 (test.t1) slave-bin.000001 2845 Update_rows_v1 1 2959 table_id: 33 flags: STMT_END_F slave-bin.000001 2959 Xid 1 2990 COMMIT /* xid=182 */ slave-bin.000001 2990 Gtid 1 3032 BEGIN GTID 0-1-11 slave-bin.000001 3032 Annotate_rows 1 3099 UPDATE t1 SET col2 = 464 WHERE col1 IN (5,4) slave-bin.000001 3099 Table_map 1 3148 table_id: 33 (test.t1) slave-bin.000001 3148 Update_rows_v1 1 3262 table_id: 33 flags: STMT_END_F slave-bin.000001 3262 Xid 1 3293 COMMIT /* xid=184 */ slave-bin.000001 3293 Gtid 1 3335 BEGIN GTID 0-1-12 slave-bin.000001 3335 Annotate_rows 1 3402 UPDATE t1 SET col2 = 430 WHERE col1 IN (5,4) slave-bin.000001 3402 Table_map 1 3451 table_id: 33 (test.t1) slave-bin.000001 3451 Update_rows_v1 1 3565 table_id: 33 flags: STMT_END_F slave-bin.000001 3565 Xid 1 3596 COMMIT /* xid=186 */ slave-bin.000001 3596 Gtid 1 3638 BEGIN GTID 0-1-13 slave-bin.000001 3638 Annotate_rows 1 3716 INSERT INTO t1 (col1, col2, col_c) VALUES ( 6 , 6, '6') slave-bin.000001 3716 Table_map 1 3765 table_id: 33 (test.t1) slave-bin.000001 3765 Write_rows_v1 1 3809 table_id: 33 flags: STMT_END_F slave-bin.000001 3809 Xid 1 3840 COMMIT /* xid=188 */ slave-bin.000001 3840 Gtid 1 3882 GTID 0-1-14 slave-bin.000001 3882 Query 1 4000 use `test`; ALTER TABLE t1 ADD UNIQUE KEY uidx2 ( col1, col_c ) **** SHOW RELAYLOG EVENTS on default **** relaylog_name = 'slave-relay-bin.000002' SHOW RELAYLOG EVENTS IN 'slave-relay-bin.000002'; Log_name Pos Event_type Server_id End_log_pos Info slave-relay-bin.000002 4 Format_desc 2 256 Server ver: 10.3.14-MariaDB-debug-log, Binlog ver: 4 slave-relay-bin.000002 256 Rotate 1 0 master-bin.000001;pos=4 slave-relay-bin.000002 304 Format_desc 1 256 Server ver: 10.3.14-MariaDB-debug-log, Binlog ver: 4 slave-relay-bin.000002 556 Gtid_list 1 285 [] slave-relay-bin.000002 585 Binlog_checkpoint 1 329 master-bin.000001 slave-relay-bin.000002 629 Gtid 1 371 GTID 0-1-1 slave-relay-bin.000002 671 Query 1 524 use `test`; CREATE TABLE t1 (col1 INT, col2 INT, col_c CHAR(20), KEY idx2 (col_c)) ENGINE = InnoDB slave-relay-bin.000002 824 Gtid 1 566 BEGIN GTID 0-1-2 slave-relay-bin.000002 866 Annotate_rows 1 644 INSERT INTO t1 (col1, col2, col_c) VALUES ( 1 , 1, '1') slave-relay-bin.000002 944 Table_map 1 693 table_id: 32 (test.t1) slave-relay-bin.000002 993 Write_rows_v1 1 737 table_id: 32 flags: STMT_END_F slave-relay-bin.000002 1037 Xid 1 768 COMMIT /* xid=135 */ slave-relay-bin.000002 1068 Gtid 1 810 BEGIN GTID 0-1-3 slave-relay-bin.000002 1110 Annotate_rows 1 888 INSERT INTO t1 (col1, col2, col_c) VALUES ( 2 , 2, '2') slave-relay-bin.000002 1188 Table_map 1 937 table_id: 32 (test.t1) slave-relay-bin.000002 1237 Write_rows_v1 1 981 table_id: 32 flags: STMT_END_F slave-relay-bin.000002 1281 Xid 1 1012 COMMIT /* xid=136 */ slave-relay-bin.000002 1312 Gtid 1 1054 BEGIN GTID 0-1-4 slave-relay-bin.000002 1354 Annotate_rows 1 1132 INSERT INTO t1 (col1, col2, col_c) VALUES ( 3 , 3, '3') slave-relay-bin.000002 1432 Table_map 1 1181 table_id: 32 (test.t1) slave-relay-bin.000002 1481 Write_rows_v1 1 1225 table_id: 32 flags: STMT_END_F slave-relay-bin.000002 1525 Xid 1 1256 COMMIT /* xid=137 */ slave-relay-bin.000002 1556 Gtid 1 1298 BEGIN GTID 0-1-5 slave-relay-bin.000002 1598 Annotate_rows 1 1385 INSERT INTO t1 (col1, col2, col_c) VALUES ( 4 , 4, '3333333333') slave-relay-bin.000002 1685 Table_map 1 1434 table_id: 32 (test.t1) slave-relay-bin.000002 1734 Write_rows_v1 1 1487 table_id: 32 flags: STMT_END_F slave-relay-bin.000002 1787 Xid 1 1518 COMMIT /* xid=138 */ slave-relay-bin.000002 1818 Gtid 1 1560 BEGIN GTID 0-1-6 slave-relay-bin.000002 1860 Annotate_rows 1 1647 INSERT INTO t1 (col1, col2, col_c) VALUES ( 5 , 5, '3333333333') slave-relay-bin.000002 1947 Table_map 1 1696 table_id: 32 (test.t1) slave-relay-bin.000002 1996 Write_rows_v1 1 1749 table_id: 32 flags: STMT_END_F slave-relay-bin.000002 2049 Xid 1 1780 COMMIT /* xid=139 */ slave-relay-bin.000002 2080 Gtid 1 1822 BEGIN GTID 0-1-7 slave-relay-bin.000002 2122 Annotate_rows 1 1889 UPDATE t1 SET col2 = 453 WHERE col1 IN (5,4) slave-relay-bin.000002 2189 Table_map 1 1938 table_id: 32 (test.t1) slave-relay-bin.000002 2238 Update_rows_v1 1 2052 table_id: 32 flags: STMT_END_F slave-relay-bin.000002 2352 Xid 1 2083 COMMIT /* xid=140 */ slave-relay-bin.000002 2383 Gtid 1 2125 BEGIN GTID 0-1-8 slave-relay-bin.000002 2425 Annotate_rows 1 2192 UPDATE t1 SET col2 = 130 WHERE col1 IN (5,4) slave-relay-bin.000002 2492 Table_map 1 2241 table_id: 32 (test.t1) slave-relay-bin.000002 2541 Update_rows_v1 1 2355 table_id: 32 flags: STMT_END_F slave-relay-bin.000002 2655 Xid 1 2386 COMMIT /* xid=141 */ slave-relay-bin.000002 2686 Gtid 1 2428 BEGIN GTID 0-1-9 slave-relay-bin.000002 2728 Annotate_rows 1 2494 UPDATE t1 SET col2 = 99 WHERE col1 IN (5,4) slave-relay-bin.000002 2794 Table_map 1 2543 table_id: 32 (test.t1) slave-relay-bin.000002 2843 Update_rows_v1 1 2657 table_id: 32 flags: STMT_END_F slave-relay-bin.000002 2957 Xid 1 2688 COMMIT /* xid=142 */ slave-relay-bin.000002 2988 Gtid 1 2730 BEGIN GTID 0-1-10 slave-relay-bin.000002 3030 Annotate_rows 1 2797 UPDATE t1 SET col2 = 202 WHERE col1 IN (5,4) slave-relay-bin.000002 3097 Table_map 1 2846 table_id: 32 (test.t1) slave-relay-bin.000002 3146 Update_rows_v1 1 2960 table_id: 32 flags: STMT_END_F slave-relay-bin.000002 3260 Xid 1 2991 COMMIT /* xid=143 */ slave-relay-bin.000002 3291 Gtid 1 3033 BEGIN GTID 0-1-11 slave-relay-bin.000002 3333 Annotate_rows 1 3100 UPDATE t1 SET col2 = 464 WHERE col1 IN (5,4) slave-relay-bin.000002 3400 Table_map 1 3149 table_id: 32 (test.t1) slave-relay-bin.000002 3449 Update_rows_v1 1 3263 table_id: 32 flags: STMT_END_F slave-relay-bin.000002 3563 Xid 1 3294 COMMIT /* xid=144 */ slave-relay-bin.000002 3594 Gtid 1 3336 BEGIN GTID 0-1-12 slave-relay-bin.000002 3636 Annotate_rows 1 3403 UPDATE t1 SET col2 = 430 WHERE col1 IN (5,4) slave-relay-bin.000002 3703 Table_map 1 3452 table_id: 32 (test.t1) slave-relay-bin.000002 3752 Update_rows_v1 1 3566 table_id: 32 flags: STMT_END_F slave-relay-bin.000002 3866 Xid 1 3597 COMMIT /* xid=145 */ slave-relay-bin.000002 3897 Gtid 1 3639 BEGIN GTID 0-1-13 slave-relay-bin.000002 3939 Annotate_rows 1 3717 INSERT INTO t1 (col1, col2, col_c) VALUES ( 6 , 6, '6') slave-relay-bin.000002 4017 Table_map 1 3766 table_id: 32 (test.t1) slave-relay-bin.000002 4066 Write_rows_v1 1 3810 table_id: 32 flags: STMT_END_F slave-relay-bin.000002 4110 Xid 1 3841 COMMIT /* xid=146 */ slave-relay-bin.000002 4141 Gtid 1 3883 GTID 0-1-14 slave-relay-bin.000002 4183 Query 1 4001 use `test`; ALTER TABLE t1 ADD UNIQUE KEY uidx2 ( col1, col_c ) slave-relay-bin.000002 4301 Gtid 1 4043 BEGIN GTID 0-1-15 slave-relay-bin.000002 4343 Annotate_rows 1 4105 UPDATE t1 SET col2 = 213 WHERE col1 = 5 slave-relay-bin.000002 4405 Table_map 1 4154 table_id: 33 (test.t1) slave-relay-bin.000002 4454 Update_rows_v1 1 4228 table_id: 33 flags: STMT_END_F slave-relay-bin.000002 4528 Xid 1 4259 COMMIT /* xid=148 */ connection default; == /home/mleich/Server/10.3/bld_debug/mysql-test/var/tmp/analyze-sync_with_master-mysqld.1.err == ############################## default ############################## **** SHOW WARNINGS on default **** SHOW WARNINGS; Level Code Message **** SELECT replication-related variables on default **** SELECT NOW(), @@SERVER_ID; NOW() @@SERVER_ID 2019-02-26 20:14:48 1 **** SHOW SLAVE STATUS on default **** SHOW SLAVE STATUS; **** SHOW MASTER STATUS on default **** SHOW MASTER STATUS; File master-bin.000001 Position 4259 Binlog_Do_DB Binlog_Ignore_DB **** SHOW SLAVE HOSTS on default **** SHOW SLAVE HOSTS; Server_id 2 Host 127.0.0.1 Port 16001 Master_id 1 **** SHOW PROCESSLIST on default **** SHOW PROCESSLIST; Id User Host db Command Time State Info Progress 1 system user NULL Daemon NULL InnoDB purge coordinator NULL 0.000 2 system user NULL Daemon NULL InnoDB purge worker NULL 0.000 3 system user NULL Daemon NULL InnoDB purge worker NULL 0.000 4 system user NULL Daemon NULL InnoDB purge worker NULL 0.000 5 system user NULL Daemon NULL InnoDB shutdown handler NULL 0.000 13 root localhost:53010 NULL Binlog Dump 0 Master has sent all binlog to slave; waiting for binlog to be updated NULL 0.000 16 root localhost NULL Query 0 Init SHOW PROCESSLIST 0.000 **** SHOW BINARY LOGS on default **** SHOW BINARY LOGS; Log_name File_size master-bin.000001 4259 **** SHOW BINLOG EVENTS on default **** binlog_name = 'master-bin.000001' SHOW BINLOG EVENTS IN 'master-bin.000001'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 4 Format_desc 1 256 Server ver: 10.3.14-MariaDB-debug-log, Binlog ver: 4 master-bin.000001 256 Gtid_list 1 285 [] master-bin.000001 285 Binlog_checkpoint 1 329 master-bin.000001 master-bin.000001 329 Gtid 1 371 GTID 0-1-1 master-bin.000001 371 Query 1 524 use `test`; CREATE TABLE t1 (col1 INT, col2 INT, col_c CHAR(20), KEY idx2 (col_c)) ENGINE = InnoDB master-bin.000001 524 Gtid 1 566 BEGIN GTID 0-1-2 master-bin.000001 566 Annotate_rows 1 644 INSERT INTO t1 (col1, col2, col_c) VALUES ( 1 , 1, '1') master-bin.000001 644 Table_map 1 693 table_id: 32 (test.t1) master-bin.000001 693 Write_rows_v1 1 737 table_id: 32 flags: STMT_END_F master-bin.000001 737 Xid 1 768 COMMIT /* xid=135 */ master-bin.000001 768 Gtid 1 810 BEGIN GTID 0-1-3 master-bin.000001 810 Annotate_rows 1 888 INSERT INTO t1 (col1, col2, col_c) VALUES ( 2 , 2, '2') master-bin.000001 888 Table_map 1 937 table_id: 32 (test.t1) master-bin.000001 937 Write_rows_v1 1 981 table_id: 32 flags: STMT_END_F master-bin.000001 981 Xid 1 1012 COMMIT /* xid=136 */ master-bin.000001 1012 Gtid 1 1054 BEGIN GTID 0-1-4 master-bin.000001 1054 Annotate_rows 1 1132 INSERT INTO t1 (col1, col2, col_c) VALUES ( 3 , 3, '3') master-bin.000001 1132 Table_map 1 1181 table_id: 32 (test.t1) master-bin.000001 1181 Write_rows_v1 1 1225 table_id: 32 flags: STMT_END_F master-bin.000001 1225 Xid 1 1256 COMMIT /* xid=137 */ master-bin.000001 1256 Gtid 1 1298 BEGIN GTID 0-1-5 master-bin.000001 1298 Annotate_rows 1 1385 INSERT INTO t1 (col1, col2, col_c) VALUES ( 4 , 4, '3333333333') master-bin.000001 1385 Table_map 1 1434 table_id: 32 (test.t1) master-bin.000001 1434 Write_rows_v1 1 1487 table_id: 32 flags: STMT_END_F master-bin.000001 1487 Xid 1 1518 COMMIT /* xid=138 */ master-bin.000001 1518 Gtid 1 1560 BEGIN GTID 0-1-6 master-bin.000001 1560 Annotate_rows 1 1647 INSERT INTO t1 (col1, col2, col_c) VALUES ( 5 , 5, '3333333333') master-bin.000001 1647 Table_map 1 1696 table_id: 32 (test.t1) master-bin.000001 1696 Write_rows_v1 1 1749 table_id: 32 flags: STMT_END_F master-bin.000001 1749 Xid 1 1780 COMMIT /* xid=139 */ master-bin.000001 1780 Gtid 1 1822 BEGIN GTID 0-1-7 master-bin.000001 1822 Annotate_rows 1 1889 UPDATE t1 SET col2 = 453 WHERE col1 IN (5,4) master-bin.000001 1889 Table_map 1 1938 table_id: 32 (test.t1) master-bin.000001 1938 Update_rows_v1 1 2052 table_id: 32 flags: STMT_END_F master-bin.000001 2052 Xid 1 2083 COMMIT /* xid=140 */ master-bin.000001 2083 Gtid 1 2125 BEGIN GTID 0-1-8 master-bin.000001 2125 Annotate_rows 1 2192 UPDATE t1 SET col2 = 130 WHERE col1 IN (5,4) master-bin.000001 2192 Table_map 1 2241 table_id: 32 (test.t1) master-bin.000001 2241 Update_rows_v1 1 2355 table_id: 32 flags: STMT_END_F master-bin.000001 2355 Xid 1 2386 COMMIT /* xid=141 */ master-bin.000001 2386 Gtid 1 2428 BEGIN GTID 0-1-9 master-bin.000001 2428 Annotate_rows 1 2494 UPDATE t1 SET col2 = 99 WHERE col1 IN (5,4) master-bin.000001 2494 Table_map 1 2543 table_id: 32 (test.t1) master-bin.000001 2543 Update_rows_v1 1 2657 table_id: 32 flags: STMT_END_F master-bin.000001 2657 Xid 1 2688 COMMIT /* xid=142 */ master-bin.000001 2688 Gtid 1 2730 BEGIN GTID 0-1-10 master-bin.000001 2730 Annotate_rows 1 2797 UPDATE t1 SET col2 = 202 WHERE col1 IN (5,4) master-bin.000001 2797 Table_map 1 2846 table_id: 32 (test.t1) master-bin.000001 2846 Update_rows_v1 1 2960 table_id: 32 flags: STMT_END_F master-bin.000001 2960 Xid 1 2991 COMMIT /* xid=143 */ master-bin.000001 2991 Gtid 1 3033 BEGIN GTID 0-1-11 master-bin.000001 3033 Annotate_rows 1 3100 UPDATE t1 SET col2 = 464 WHERE col1 IN (5,4) master-bin.000001 3100 Table_map 1 3149 table_id: 32 (test.t1) master-bin.000001 3149 Update_rows_v1 1 3263 table_id: 32 flags: STMT_END_F master-bin.000001 3263 Xid 1 3294 COMMIT /* xid=144 */ master-bin.000001 3294 Gtid 1 3336 BEGIN GTID 0-1-12 master-bin.000001 3336 Annotate_rows 1 3403 UPDATE t1 SET col2 = 430 WHERE col1 IN (5,4) master-bin.000001 3403 Table_map 1 3452 table_id: 32 (test.t1) master-bin.000001 3452 Update_rows_v1 1 3566 table_id: 32 flags: STMT_END_F master-bin.000001 3566 Xid 1 3597 COMMIT /* xid=145 */ master-bin.000001 3597 Gtid 1 3639 BEGIN GTID 0-1-13 master-bin.000001 3639 Annotate_rows 1 3717 INSERT INTO t1 (col1, col2, col_c) VALUES ( 6 , 6, '6') master-bin.000001 3717 Table_map 1 3766 table_id: 32 (test.t1) master-bin.000001 3766 Write_rows_v1 1 3810 table_id: 32 flags: STMT_END_F master-bin.000001 3810 Xid 1 3841 COMMIT /* xid=146 */ master-bin.000001 3841 Gtid 1 3883 GTID 0-1-14 master-bin.000001 3883 Query 1 4001 use `test`; ALTER TABLE t1 ADD UNIQUE KEY uidx2 ( col1, col_c ) master-bin.000001 4001 Gtid 1 4043 BEGIN GTID 0-1-15 master-bin.000001 4043 Annotate_rows 1 4105 UPDATE t1 SET col2 = 213 WHERE col1 = 5 master-bin.000001 4105 Table_map 1 4154 table_id: 33 (test.t1) master-bin.000001 4154 Update_rows_v1 1 4228 table_id: 33 flags: STMT_END_F master-bin.000001 4228 Xid 1 4259 COMMIT /* xid=148 */ **** SHOW RELAYLOG EVENTS on default **** relaylog_name = 'No such row' SHOW RELAYLOG EVENTS IN 'No such row'; Log_name Pos Event_type Server_id End_log_pos Info connection default; - saving '/home/mleich/Server/10.3/bld_debug/mysql-test/var/log/main.rpl_t_s_4-innodb,row/' to '/home/mleich/Server/10.3/bld_debug/mysql-test/var/log/main.rpl_t_s_4-innodb,row/' Only 2 of 3 completed. -------------------------------------------------------------------------- The servers were restarted 1 times Spent 0.000 of 11 seconds executing testcases Failure: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.rpl_t_s_4 The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html 1 tests were skipped, 1 by the test itself.