Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
-
None
-
None
Description
With RBR, statements like CREATE TABLE .. AS SELECT .. are written into the binary log in two parts: the CREATE part is in the statement format, as any DDL, and the INSERT part in the row format. When it's written on the server that executed it, both parts share the same GTID. But when it's applied on the slave, each part gets its own GTID. Thus, it causes a discrepancy between master and slave GTID sequences, and between binlog_pos and slave_pos.
Test output:
include/master-slave.inc
|
[connection master]
|
ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
|
CREATE TABLE t1 AS SELECT 1;
|
SHOW BINLOG EVENTS;
|
Log_name Pos Event_type Server_id End_log_pos Info
|
master-bin.000001 4 Format_desc 1 248 Server ver: 10.0.1-MariaDB-gcov-debug-log, Binlog ver: 4
|
master-bin.000001 248 Gtid_list 1 273 []
|
master-bin.000001 273 Binlog_checkpoint 1 313 master-bin.000001
|
master-bin.000001 313 Gtid 1 351 GTID 0-1-1
|
master-bin.000001 351 Query 1 460 use `test`; ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB
|
master-bin.000001 460 Gtid 1 498 BEGIN GTID 0-1-2
|
master-bin.000001 498 Query 1 616 use `test`; CREATE TABLE `t1` (
|
`1` int(1) NOT NULL DEFAULT '0'
|
)
|
master-bin.000001 616 Table_map 1 657 table_id: 45 (test.t1)
|
master-bin.000001 657 Write_rows 1 691 table_id: 45 flags: STMT_END_F
|
master-bin.000001 691 Query 1 760 COMMIT
|
SHOW BINLOG EVENTS;
|
Log_name Pos Event_type Server_id End_log_pos Info
|
slave-bin.000001 4 Format_desc 2 248 Server ver: 10.0.1-MariaDB-gcov-debug-log, Binlog ver: 4
|
slave-bin.000001 248 Gtid_list 2 273 []
|
slave-bin.000001 273 Binlog_checkpoint 2 312 slave-bin.000001
|
slave-bin.000001 312 Gtid 1 350 GTID 0-1-1
|
slave-bin.000001 350 Query 1 459 use `test`; ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB
|
slave-bin.000001 459 Gtid 1 497 GTID 0-1-2
|
slave-bin.000001 497 Query 1 615 use `test`; CREATE TABLE `t1` (
|
`1` int(1) NOT NULL DEFAULT '0'
|
)
|
slave-bin.000001 615 Gtid 1 653 BEGIN GTID 0-1-3
|
slave-bin.000001 653 Table_map 1 694 table_id: 46 (test.t1)
|
slave-bin.000001 694 Write_rows 1 728 table_id: 46 flags: STMT_END_F
|
slave-bin.000001 728 Query 1 788 COMMIT
|
SHOW VARIABLES LIKE 'gtid%';
|
Variable_name Value
|
gtid_binlog_pos 0-1-3
|
gtid_current_pos 0-1-2
|
gtid_domain_id 0
|
gtid_seq_no 0
|
gtid_slave_pos 0-1-2
|
gtid_strict_mode OFF
|
Test case:
--source include/master-slave.inc
|
--source include/have_innodb.inc
|
--source include/have_binlog_format_row.inc
|
|
|
ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB; |
CREATE TABLE t1 AS SELECT 1; |
SHOW BINLOG EVENTS;
|
|
|
--sync_slave_with_master
|
SHOW BINLOG EVENTS;
|
SHOW VARIABLES LIKE 'gtid%'; |
bzr version-info
revision-id: knielsen@knielsen-hq.org-20130528112831-vwbv19062dipob0b
|
revno: 3636
|
branch-nick: 10.0-base
|
