rpl.rpl_gtid_master_promote 'innodb_plugin,stmt' w3 [ fail ]
|
Test ended at 2016-06-22 22:07:46
|
|
CURRENT_TEST: rpl.rpl_gtid_master_promote
|
=== SHOW MASTER STATUS ===
|
---- 1. ----
|
File master-bin.000001
|
Position 3011
|
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 16001
|
Connect_Retry 1
|
Master_Log_File slave-bin.000001
|
Read_Master_Log_Pos 5167
|
Relay_Log_File mysqld-relay-bin.000002
|
Relay_Log_Pos 846
|
Relay_Master_Log_File slave-bin.000001
|
Slave_IO_Running Yes
|
Slave_SQL_Running Yes
|
Replicate_Do_DB
|
Replicate_Ignore_DB
|
Replicate_Do_Table
|
Replicate_Ignore_Table
|
Replicate_Wild_Do_Table
|
Replicate_Wild_Ignore_Table
|
Last_Errno 0
|
Last_Error
|
Skip_Counter 0
|
Exec_Master_Log_Pos 1324
|
Relay_Log_Space 3459
|
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 356
|
Master_SSL_Verify_Server_Cert No
|
Last_IO_Errno 0
|
Last_IO_Error
|
Last_SQL_Errno 0
|
Last_SQL_Error
|
Replicate_Ignore_Server_Ids
|
Master_Server_Id 2
|
Master_SSL_Crl
|
Master_SSL_Crlpath
|
Using_Gtid Current_Pos
|
Gtid_IO_Pos 1-2-9,0-1-3,3-2-9,2-2-9
|
=========================
|
|
=== SHOW PROCESSLIST ===
|
---- 1. ----
|
Id 4
|
User root
|
Host localhost:35889
|
db test
|
Command Query
|
Time 0
|
State init
|
Info SHOW PROCESSLIST
|
Progress 0.000
|
---- 2. ----
|
Id 5
|
User root
|
Host localhost:35890
|
db test
|
Command Sleep
|
Time 522
|
State
|
Info
|
Progress 0.000
|
---- 3. ----
|
Id 11
|
User system user
|
Host
|
db
|
Command Connect
|
Time 301
|
State Waiting for master to send event
|
Info
|
Progress 0.000
|
---- 4. ----
|
Id 12
|
User system user
|
Host
|
db test
|
Command Connect
|
Time 463
|
State update
|
Info INSERT INTO t1 VALUES (2)
|
Progress 0.000
|
========================
|
|
analyze: sync_with_master
|
mysqltest: At line 205: sync_with_master failed: 'select master_pos_wait('slave-bin.000001', 5167, 300, '')' returned -1 indicating timeout after 300 seconds
|
|
The result from queries just before the failure was:
|
< snip >
|
2 1
|
2 3
|
3 1
|
3 3
|
*** Now make 2 master and point 3,4,5 to the new master 2
|
SET gtid_domain_id= 1;
|
INSERT INTO t1 values (5);
|
INSERT INTO t4 values (1,5);
|
SET gtid_domain_id= 2;
|
INSERT INTO t2 values (5);
|
INSERT INTO t4 values (2,5);
|
SET gtid_domain_id= 3;
|
INSERT INTO t3 values (5);
|
INSERT INTO t4 values (3,5);
|
CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_2;
|
include/start_slave.inc
|
CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_2;
|
include/start_slave.inc
|
CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_2;
|
include/start_slave.inc
|
|
More results from queries before failure can be found in /var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/3/log/rpl_gtid_master_promote.log
|