GTID: If slave was set up with master_gtid_pos=auto, IO thread restart makes it start from the beginning of the binlog

revision-id: knielsen@knielsen-hq.org-20130311151655-yc1i3z72v6c00pfz

revno: 3468

branch-nick: 10.0-mdev26

--source include/master-slave.inc

--connection slave

STOP SLAVE;

--source include/wait_for_slave_to_stop.inc

RESET SLAVE ALL;

--connection master

RESET MASTER;

--connection slave

eval CHANGE MASTER TO master_host='127.0.0.1', master_port=$MASTER_MYPORT, master_user='root', master_gtid_pos=auto;

START SLAVE;

--source include/wait_for_slave_to_start.inc

--connection master

CREATE TABLE t1 (i INT);

INSERT INTO t1 VALUES (1);

--sync_slave_with_master

STOP SLAVE IO_THREAD;

--source include/wait_for_slave_io_to_stop.inc

START SLAVE IO_THREAD;

--source include/wait_for_slave_io_to_start.inc

--sync_with_master

=== 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	311

Relay_Log_File	slave-relay-bin.000002

Relay_Log_Pos	599

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	1050

Last_Error	Error 'Table 't1' already exists' on query. Default database: 'test'. Query: 'CREATE TABLE t1 (i INT)'

Skip_Counter	0

Exec_Master_Log_Pos	311

Relay_Log_Space	1863

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	1050

Last_SQL_Error	Error 'Table 't1' already exists' on query. Default database: 'test'. Query: 'CREATE TABLE t1 (i INT)'

Replicate_Ignore_Server_Ids	

Master_Server_Id	1

Using_Gtid	1

=========================