1include/master-slave.inc 2Warnings: 3Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. 4Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 5[connection master] 6call mtr.add_suppression("Recovery from master pos .*"); 7call mtr.add_suppression("Error in Log_event::read_log_event()"); 8call mtr.add_suppression("Failed to read information on Previous GTIDs."); 9call mtr.add_suppression("Error reading GTIDs from binary log"); 10CREATE TABLE t1(id INTEGER) ENGINE= Innodb; 11==== Part 1 ==== 12include/rpl_reset.inc 13---- i=1 ---- 14BEGIN; 15INSERT INTO t1 VALUES(1); 16INSERT INTO t1 VALUES(2); 17COMMIT; 18extra/rpl_tests/rpl_check_gtid.inc 19include/sync_slave_sql_with_master.inc 20extra/rpl_tests/rpl_check_gtid.inc 21extra/rpl_tests/rpl_check_gtid.inc 22BEGIN; 23INSERT INTO t1 VALUES(1); 24INSERT INTO t1 VALUES(2); 25COMMIT; 26extra/rpl_tests/rpl_check_gtid.inc 27FLUSH LOGS; 28FLUSH LOGS; 29---- i=2 ---- 30BEGIN; 31INSERT INTO t1 VALUES(1); 32INSERT INTO t1 VALUES(2); 33COMMIT; 34extra/rpl_tests/rpl_check_gtid.inc 35include/sync_slave_sql_with_master.inc 36extra/rpl_tests/rpl_check_gtid.inc 37extra/rpl_tests/rpl_check_gtid.inc 38BEGIN; 39INSERT INTO t1 VALUES(1); 40INSERT INTO t1 VALUES(2); 41COMMIT; 42extra/rpl_tests/rpl_check_gtid.inc 43FLUSH LOGS; 44FLUSH LOGS; 45---- i=3 ---- 46BEGIN; 47INSERT INTO t1 VALUES(1); 48INSERT INTO t1 VALUES(2); 49COMMIT; 50extra/rpl_tests/rpl_check_gtid.inc 51include/sync_slave_sql_with_master.inc 52extra/rpl_tests/rpl_check_gtid.inc 53extra/rpl_tests/rpl_check_gtid.inc 54BEGIN; 55INSERT INTO t1 VALUES(1); 56INSERT INTO t1 VALUES(2); 57COMMIT; 58extra/rpl_tests/rpl_check_gtid.inc 59FLUSH LOGS; 60FLUSH LOGS; 61---- i=4 ---- 62BEGIN; 63INSERT INTO t1 VALUES(1); 64INSERT INTO t1 VALUES(2); 65COMMIT; 66extra/rpl_tests/rpl_check_gtid.inc 67include/sync_slave_sql_with_master.inc 68extra/rpl_tests/rpl_check_gtid.inc 69extra/rpl_tests/rpl_check_gtid.inc 70BEGIN; 71INSERT INTO t1 VALUES(1); 72INSERT INTO t1 VALUES(2); 73COMMIT; 74extra/rpl_tests/rpl_check_gtid.inc 75FLUSH LOGS; 76FLUSH LOGS; 77==== Part 2 ==== 78include/rpl_reset.inc 79include/stop_slave.inc 80include/start_slave.inc 81BEGIN; 82INSERT INTO t1 VALUES(0); 83COMMIT; 84include/sync_slave_sql_with_master.inc 85---- i=1 ---- 86[connection slave] 87# Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug 88[connection master] 89BEGIN; 90INSERT INTO t1 VALUES(1); 91INSERT INTO t1 VALUES(2); 92COMMIT; 93[connection slave] 94Waiting for 3 more event(s) before flushing relaylog 95SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event'; 96SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event'; 97Waiting for 2 more event(s) before flushing relaylog 98SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event'; 99SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event'; 100Waiting for 1 more event(s) before flushing relaylog 101SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event'; 102SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event'; 103FLUSH LOCAL RELAY LOGS; 104SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event'; 105# Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug 106SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event'; 107[connection master] 108include/sync_slave_sql_with_master.inc 109extra/rpl_tests/rpl_check_gtid.inc 110FLUSH LOGS; 111---- i=2 ---- 112[connection slave] 113# Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug 114[connection master] 115BEGIN; 116INSERT INTO t1 VALUES(1); 117INSERT INTO t1 VALUES(2); 118COMMIT; 119[connection slave] 120Waiting for 3 more event(s) before flushing relaylog 121SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event'; 122SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event'; 123Waiting for 2 more event(s) before flushing relaylog 124SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event'; 125SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event'; 126Waiting for 1 more event(s) before flushing relaylog 127SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event'; 128SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event'; 129FLUSH LOCAL RELAY LOGS; 130SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event'; 131# Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug 132SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event'; 133[connection master] 134include/sync_slave_sql_with_master.inc 135extra/rpl_tests/rpl_check_gtid.inc 136FLUSH LOGS; 137---- i=3 ---- 138[connection slave] 139# Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug 140[connection master] 141BEGIN; 142INSERT INTO t1 VALUES(1); 143INSERT INTO t1 VALUES(2); 144COMMIT; 145[connection slave] 146Waiting for 3 more event(s) before flushing relaylog 147SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event'; 148SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event'; 149Waiting for 2 more event(s) before flushing relaylog 150SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event'; 151SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event'; 152Waiting for 1 more event(s) before flushing relaylog 153SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event'; 154SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event'; 155FLUSH LOCAL RELAY LOGS; 156SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event'; 157# Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug 158SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event'; 159[connection master] 160include/sync_slave_sql_with_master.inc 161extra/rpl_tests/rpl_check_gtid.inc 162FLUSH LOGS; 163---- i=4 ---- 164[connection slave] 165# Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug 166[connection master] 167BEGIN; 168INSERT INTO t1 VALUES(1); 169INSERT INTO t1 VALUES(2); 170COMMIT; 171[connection slave] 172Waiting for 3 more event(s) before flushing relaylog 173SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event'; 174SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event'; 175Waiting for 2 more event(s) before flushing relaylog 176SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event'; 177SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event'; 178Waiting for 1 more event(s) before flushing relaylog 179SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event'; 180SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event'; 181FLUSH LOCAL RELAY LOGS; 182SET DEBUG_SYNC='now WAIT_FOR reached_queuing_event'; 183# Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug 184SET DEBUG_SYNC= 'now SIGNAL continue_queuing_event'; 185[connection master] 186include/sync_slave_sql_with_master.inc 187extra/rpl_tests/rpl_check_gtid.inc 188FLUSH LOGS; 189==== Part 3 ==== 190include/rpl_reset.inc 191include/stop_slave.inc 192SET GLOBAL debug=""; 193include/start_slave.inc 194---- i=1 ---- 195BEGIN; 196INSERT INTO t1 VALUES(1); 197INSERT INTO t1 VALUES(2); 198COMMIT; 199include/sync_slave_sql_with_master.inc 200extra/rpl_tests/rpl_check_gtid.inc 201extra/rpl_tests/rpl_check_gtid.inc 202include/stop_slave.inc 203include/rpl_restart_server.inc [server_number=2] 204include/start_slave.inc 205FLUSH LOGS; 206FLUSH LOGS; 207---- i=2 ---- 208BEGIN; 209INSERT INTO t1 VALUES(1); 210INSERT INTO t1 VALUES(2); 211COMMIT; 212include/sync_slave_sql_with_master.inc 213extra/rpl_tests/rpl_check_gtid.inc 214extra/rpl_tests/rpl_check_gtid.inc 215include/stop_slave.inc 216include/rpl_restart_server.inc [server_number=2] 217include/start_slave.inc 218FLUSH LOGS; 219FLUSH LOGS; 220---- i=3 ---- 221BEGIN; 222INSERT INTO t1 VALUES(1); 223INSERT INTO t1 VALUES(2); 224COMMIT; 225include/sync_slave_sql_with_master.inc 226extra/rpl_tests/rpl_check_gtid.inc 227extra/rpl_tests/rpl_check_gtid.inc 228include/stop_slave.inc 229include/rpl_restart_server.inc [server_number=2] 230include/start_slave.inc 231FLUSH LOGS; 232FLUSH LOGS; 233---- i=4 ---- 234BEGIN; 235INSERT INTO t1 VALUES(1); 236INSERT INTO t1 VALUES(2); 237COMMIT; 238include/sync_slave_sql_with_master.inc 239extra/rpl_tests/rpl_check_gtid.inc 240extra/rpl_tests/rpl_check_gtid.inc 241include/stop_slave.inc 242include/rpl_restart_server.inc [server_number=2] 243include/start_slave.inc 244FLUSH LOGS; 245FLUSH LOGS; 246==== Part 4 ==== 247include/rpl_reset.inc 248---- i=1 ---- 249BEGIN; 250INSERT INTO t1 VALUES(1); 251INSERT INTO t1 VALUES(2); 252COMMIT; 253extra/rpl_tests/rpl_check_gtid.inc 254include/sync_slave_sql_with_master.inc 255extra/rpl_tests/rpl_check_gtid.inc 256extra/rpl_tests/rpl_check_gtid.inc 257include/stop_slave.inc 258include/rpl_restart_server.inc [server_number=1] 259include/start_slave.inc 260FLUSH LOGS; 261FLUSH LOGS; 262---- i=2 ---- 263BEGIN; 264INSERT INTO t1 VALUES(1); 265INSERT INTO t1 VALUES(2); 266COMMIT; 267extra/rpl_tests/rpl_check_gtid.inc 268include/sync_slave_sql_with_master.inc 269extra/rpl_tests/rpl_check_gtid.inc 270extra/rpl_tests/rpl_check_gtid.inc 271include/stop_slave.inc 272include/rpl_restart_server.inc [server_number=1] 273include/start_slave.inc 274FLUSH LOGS; 275FLUSH LOGS; 276---- i=3 ---- 277BEGIN; 278INSERT INTO t1 VALUES(1); 279INSERT INTO t1 VALUES(2); 280COMMIT; 281extra/rpl_tests/rpl_check_gtid.inc 282include/sync_slave_sql_with_master.inc 283extra/rpl_tests/rpl_check_gtid.inc 284extra/rpl_tests/rpl_check_gtid.inc 285include/stop_slave.inc 286include/rpl_restart_server.inc [server_number=1] 287include/start_slave.inc 288FLUSH LOGS; 289FLUSH LOGS; 290---- i=4 ---- 291BEGIN; 292INSERT INTO t1 VALUES(1); 293INSERT INTO t1 VALUES(2); 294COMMIT; 295extra/rpl_tests/rpl_check_gtid.inc 296include/sync_slave_sql_with_master.inc 297extra/rpl_tests/rpl_check_gtid.inc 298extra/rpl_tests/rpl_check_gtid.inc 299include/stop_slave.inc 300include/rpl_restart_server.inc [server_number=1] 301include/start_slave.inc 302FLUSH LOGS; 303FLUSH LOGS; 304==== Part 5 ==== 305---- i=1 ---- 306include/stop_slave.inc 307RESET SLAVE; 308RESET MASTER; 309RESET MASTER; 310include/start_slave.inc 311BEGIN; 312INSERT INTO t1 VALUES(1); 313INSERT INTO t1 VALUES(2); 314COMMIT; 315BEGIN; 316INSERT INTO t1 VALUES(1); 317INSERT INTO t1 VALUES(2); 318COMMIT; 319include/sync_slave_sql_with_master.inc 320extra/rpl_tests/rpl_check_gtid.inc 321FLUSH LOGS; 322FLUSH LOGS; 323---- i=2 ---- 324include/stop_slave.inc 325RESET SLAVE; 326RESET MASTER; 327RESET MASTER; 328include/start_slave.inc 329BEGIN; 330INSERT INTO t1 VALUES(1); 331INSERT INTO t1 VALUES(2); 332COMMIT; 333BEGIN; 334INSERT INTO t1 VALUES(1); 335INSERT INTO t1 VALUES(2); 336COMMIT; 337include/sync_slave_sql_with_master.inc 338extra/rpl_tests/rpl_check_gtid.inc 339FLUSH LOGS; 340FLUSH LOGS; 341---- i=3 ---- 342include/stop_slave.inc 343RESET SLAVE; 344RESET MASTER; 345RESET MASTER; 346include/start_slave.inc 347BEGIN; 348INSERT INTO t1 VALUES(1); 349INSERT INTO t1 VALUES(2); 350COMMIT; 351BEGIN; 352INSERT INTO t1 VALUES(1); 353INSERT INTO t1 VALUES(2); 354COMMIT; 355include/sync_slave_sql_with_master.inc 356extra/rpl_tests/rpl_check_gtid.inc 357FLUSH LOGS; 358FLUSH LOGS; 359---- i=4 ---- 360include/stop_slave.inc 361RESET SLAVE; 362RESET MASTER; 363RESET MASTER; 364include/start_slave.inc 365BEGIN; 366INSERT INTO t1 VALUES(1); 367INSERT INTO t1 VALUES(2); 368COMMIT; 369BEGIN; 370INSERT INTO t1 VALUES(1); 371INSERT INTO t1 VALUES(2); 372COMMIT; 373include/sync_slave_sql_with_master.inc 374extra/rpl_tests/rpl_check_gtid.inc 375FLUSH LOGS; 376FLUSH LOGS; 377==== Part 6 ==== 378include/stop_slave.inc 379RESET SLAVE; 380RESET MASTER; 381RESET MASTER; 382CHANGE MASTER TO MASTER_AUTO_POSITION= 1, MASTER_LOG_FILE= 'master-bin.000001', MASTER_LOG_POS= 4; 383ERROR HY000: Parameters MASTER_LOG_FILE, MASTER_LOG_POS, RELAY_LOG_FILE and RELAY_LOG_POS cannot be set when MASTER_AUTO_POSITION is active. 384include/start_slave.inc 385---- i=1 ---- 386BEGIN; 387INSERT INTO t1 VALUES(1); 388INSERT INTO t1 VALUES(2); 389COMMIT; 390BEGIN; 391INSERT INTO t1 VALUES(1); 392INSERT INTO t1 VALUES(2); 393COMMIT; 394SELECT WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS('MASTER_UUID:1'); 395SELECT WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS('MASTER_UUID:1-2'); 396extra/rpl_tests/rpl_check_gtid.inc 397include/stop_slave.inc 398CHANGE MASTER TO MASTER_HOST= 'SLAVE_MASTER_HOST', MASTER_AUTO_POSITION= 1; 399include/start_slave.inc 400FLUSH LOGS; 401---- i=2 ---- 402BEGIN; 403INSERT INTO t1 VALUES(1); 404INSERT INTO t1 VALUES(2); 405COMMIT; 406BEGIN; 407INSERT INTO t1 VALUES(1); 408INSERT INTO t1 VALUES(2); 409COMMIT; 410SELECT WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS('MASTER_UUID:1-3', 300); 411SELECT WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS('MASTER_UUID:1-4', 300); 412extra/rpl_tests/rpl_check_gtid.inc 413include/stop_slave.inc 414CHANGE MASTER TO MASTER_HOST= 'SLAVE_MASTER_HOST', MASTER_AUTO_POSITION= 1; 415include/start_slave.inc 416FLUSH LOGS; 417---- i=3 ---- 418BEGIN; 419INSERT INTO t1 VALUES(1); 420INSERT INTO t1 VALUES(2); 421COMMIT; 422BEGIN; 423INSERT INTO t1 VALUES(1); 424INSERT INTO t1 VALUES(2); 425COMMIT; 426SELECT WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS('MASTER_UUID:1-5'); 427SELECT WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS('MASTER_UUID:1-6'); 428extra/rpl_tests/rpl_check_gtid.inc 429include/stop_slave.inc 430CHANGE MASTER TO MASTER_HOST= 'SLAVE_MASTER_HOST', MASTER_AUTO_POSITION= 1; 431include/start_slave.inc 432FLUSH LOGS; 433---- i=4 ---- 434BEGIN; 435INSERT INTO t1 VALUES(1); 436INSERT INTO t1 VALUES(2); 437COMMIT; 438BEGIN; 439INSERT INTO t1 VALUES(1); 440INSERT INTO t1 VALUES(2); 441COMMIT; 442SELECT WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS('MASTER_UUID:1-7', 300); 443SELECT WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS('MASTER_UUID:1-8', 300); 444extra/rpl_tests/rpl_check_gtid.inc 445include/stop_slave.inc 446CHANGE MASTER TO MASTER_HOST= 'SLAVE_MASTER_HOST', MASTER_AUTO_POSITION= 1; 447include/start_slave.inc 448FLUSH LOGS; 449==== Part 7 ==== 450include/stop_slave.inc 451RESET SLAVE; 452RESET MASTER; 453RESET MASTER; 454CHANGE MASTER TO MASTER_HOST= 'SLAVE_MASTER_HOST', MASTER_AUTO_POSITION= 1; 455---- i=1 ---- 456BEGIN; 457INSERT INTO t1 VALUES(1); 458INSERT INTO t1 VALUES(2); 459COMMIT; 460BEGIN; 461INSERT INTO t1 VALUES(1); 462INSERT INTO t1 VALUES(2); 463COMMIT; 464START SLAVE UNTIL SQL_BEFORE_GTIDS= "MASTER_UUID:2"; 465include/wait_for_slave_sql_to_stop.inc 466include/stop_slave.inc 467extra/rpl_tests/rpl_check_gtid.inc 468FLUSH LOGS; 469---- i=2 ---- 470BEGIN; 471INSERT INTO t1 VALUES(1); 472INSERT INTO t1 VALUES(2); 473COMMIT; 474BEGIN; 475INSERT INTO t1 VALUES(1); 476INSERT INTO t1 VALUES(2); 477COMMIT; 478START SLAVE UNTIL SQL_BEFORE_GTIDS= "MASTER_UUID:4"; 479include/wait_for_slave_sql_to_stop.inc 480include/stop_slave.inc 481extra/rpl_tests/rpl_check_gtid.inc 482FLUSH LOGS; 483---- i=3 ---- 484BEGIN; 485INSERT INTO t1 VALUES(1); 486INSERT INTO t1 VALUES(2); 487COMMIT; 488BEGIN; 489INSERT INTO t1 VALUES(1); 490INSERT INTO t1 VALUES(2); 491COMMIT; 492START SLAVE UNTIL SQL_BEFORE_GTIDS= "MASTER_UUID:6"; 493include/wait_for_slave_sql_to_stop.inc 494include/stop_slave.inc 495extra/rpl_tests/rpl_check_gtid.inc 496FLUSH LOGS; 497---- i=4 ---- 498BEGIN; 499INSERT INTO t1 VALUES(1); 500INSERT INTO t1 VALUES(2); 501COMMIT; 502BEGIN; 503INSERT INTO t1 VALUES(1); 504INSERT INTO t1 VALUES(2); 505COMMIT; 506START SLAVE UNTIL SQL_BEFORE_GTIDS= "MASTER_UUID:8"; 507include/wait_for_slave_sql_to_stop.inc 508include/stop_slave.inc 509extra/rpl_tests/rpl_check_gtid.inc 510FLUSH LOGS; 511==== Part 8 ==== 512include/stop_slave.inc 513Warnings: 514Note 3084 Replication thread(s) for channel '' are already stopped. 515RESET MASTER; 516RESET SLAVE; 517CHANGE MASTER TO MASTER_HOST= '127.0.0.1', MASTER_AUTO_POSITION= 0; 518RESET MASTER; 519include/start_slave.inc 520---- i=1 ---- 521BEGIN; 522INSERT INTO t1 VALUES(1); 523INSERT INTO t1 VALUES(2); 524COMMIT; 525include/sync_slave_sql_with_master.inc 526extra/rpl_tests/rpl_check_gtid.inc 527extra/rpl_tests/rpl_check_gtid.inc 528include/stop_slave.inc 529include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1 --debug=d,skip_writing_previous_gtids_log_event] 530include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1] 531include/start_slave.inc 532FLUSH LOGS; 533FLUSH LOGS; 534---- i=2 ---- 535BEGIN; 536INSERT INTO t1 VALUES(1); 537INSERT INTO t1 VALUES(2); 538COMMIT; 539include/sync_slave_sql_with_master.inc 540extra/rpl_tests/rpl_check_gtid.inc 541extra/rpl_tests/rpl_check_gtid.inc 542include/stop_slave.inc 543include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1 --debug=d,skip_writing_previous_gtids_log_event] 544include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1] 545include/start_slave.inc 546FLUSH LOGS; 547FLUSH LOGS; 548---- i=3 ---- 549BEGIN; 550INSERT INTO t1 VALUES(1); 551INSERT INTO t1 VALUES(2); 552COMMIT; 553include/sync_slave_sql_with_master.inc 554extra/rpl_tests/rpl_check_gtid.inc 555extra/rpl_tests/rpl_check_gtid.inc 556include/stop_slave.inc 557include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1 --debug=d,skip_writing_previous_gtids_log_event] 558include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1] 559include/start_slave.inc 560FLUSH LOGS; 561FLUSH LOGS; 562---- i=4 ---- 563BEGIN; 564INSERT INTO t1 VALUES(1); 565INSERT INTO t1 VALUES(2); 566COMMIT; 567include/sync_slave_sql_with_master.inc 568extra/rpl_tests/rpl_check_gtid.inc 569extra/rpl_tests/rpl_check_gtid.inc 570include/stop_slave.inc 571include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1 --debug=d,skip_writing_previous_gtids_log_event] 572include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1] 573include/start_slave.inc 574FLUSH LOGS; 575FLUSH LOGS; 576==== Part 9 ==== 577include/rpl_reset.inc 578---- i=1 ---- 579BEGIN; 580INSERT INTO t1 VALUES(1); 581INSERT INTO t1 VALUES(2); 582COMMIT; 583include/sync_slave_sql_with_master.inc 584extra/rpl_tests/rpl_check_gtid.inc 585extra/rpl_tests/rpl_check_gtid.inc 586include/stop_slave.inc 587include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1 --debug=d,write_partial_previous_gtids_log_event] 588include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1] 589include/start_slave.inc 590FLUSH LOGS; 591FLUSH LOGS; 592---- i=2 ---- 593BEGIN; 594INSERT INTO t1 VALUES(1); 595INSERT INTO t1 VALUES(2); 596COMMIT; 597include/sync_slave_sql_with_master.inc 598extra/rpl_tests/rpl_check_gtid.inc 599extra/rpl_tests/rpl_check_gtid.inc 600include/stop_slave.inc 601include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1 --debug=d,write_partial_previous_gtids_log_event] 602include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1] 603include/start_slave.inc 604FLUSH LOGS; 605FLUSH LOGS; 606---- i=3 ---- 607BEGIN; 608INSERT INTO t1 VALUES(1); 609INSERT INTO t1 VALUES(2); 610COMMIT; 611include/sync_slave_sql_with_master.inc 612extra/rpl_tests/rpl_check_gtid.inc 613extra/rpl_tests/rpl_check_gtid.inc 614include/stop_slave.inc 615include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1 --debug=d,write_partial_previous_gtids_log_event] 616include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1] 617include/start_slave.inc 618FLUSH LOGS; 619FLUSH LOGS; 620---- i=4 ---- 621BEGIN; 622INSERT INTO t1 VALUES(1); 623INSERT INTO t1 VALUES(2); 624COMMIT; 625include/sync_slave_sql_with_master.inc 626extra/rpl_tests/rpl_check_gtid.inc 627extra/rpl_tests/rpl_check_gtid.inc 628include/stop_slave.inc 629include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1 --debug=d,write_partial_previous_gtids_log_event] 630include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery=1] 631include/start_slave.inc 632FLUSH LOGS; 633FLUSH LOGS; 634include/rpl_reset.inc 635DROP TABLE t1; 636# Failure on creating compression thread 637include/sync_slave_sql_with_master.inc 638include/stop_slave.inc 639call mtr.add_suppression("Can not create thread to compress gtid_executed table .*"); 640include/rpl_restart_server.inc [server_number=2 parameters: --debug=d,simulate_create_compress_thread_failure] 641include/assert.inc [compression thread is destroied;] 642call mtr.add_suppression("Plugin 'InnoDB' will be forced to shutdown"); 643call mtr.add_suppression("Plugin 'InnoDB' has ref_count=.* after shutdown"); 644include/rpl_restart_server.inc [server_number=2] 645include/start_slave.inc 646include/rpl_end.inc 647