Usrbinmysqlbug Script test process status

The results of the test performed by mysql-test-run.pl are as follows:

CURRENT_TEST:rpl.rpl_ssl
= = = SHOW MASTER STATUS = = =
----1. ----
File slave-bin.000001
Position 357
binlog_do_db
binlog_ignore_db
==========================

= = = SHOW SLAVE STATUS = = =
----1. ----
Slave_io_state
Master_host 127.0.0.1
Master_user Replssl
Master_port 13000
Connect_retry 1
Master_log_file master-bin.000001
Read_master_log_pos 357
Relay_log_file slave-relay-bin.000001
Relay_log_pos 4
Relay_master_log_file master-bin.000001
Slave_io_running No
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 357
Relay_log_space 106
Until_condition None
Until_log_file
Until_log_pos 0
Master_ssl_allowed Yes
Master_ssl_ca_file/usr/share/mysql-test/std_data/cacert.pem
Master_ssl_ca_path
Master_ssl_cert/usr/share/mysql-test/std_data/client-cert.pem
Master_ssl_cipher
Master_ssl_key/usr/share/mysql-test/std_data/client-key.pem
Seconds_behind_master
Master_ssl_verify_server_cert No
Last_io_errno 2026
Last_io_error Error connecting to Master'[email protected]: 13000 ' -retry-time:1  retries:10
last_sql_errno 0
Last_sql_error  
=========================

= = = SHOW Processlist = =
----1.----
id 105
User root
host localhost:51189
db test
command sleep
time 300
state 
Info &NBSP
----2.----
id 106
user root
host localhost:51190
db test
Command  sleep
time 300
state 
info 
----3.----
id 109
User root
host localhost:51196
Db test
command query
time 0
state 
Info  SHOW processlist
----4.----
id 110
user root
host localhost:51197
Db test
Command sleep
time 300
state 
info 
----5.----
id 112
User  system user
host 
db 
Command connect
time 300
State has Read all Relay log; Waiting for the slave I/O thread to update it
info 
========================

analyze:sync_with_master
Mysqltest:at line 26:sync_slave_with_master Failed: ' Select master_pos_wait (' master-bin.000001 ', 444, $) ' returned-1 indicating timeout after seconds

The result from queries just before, the failure was:
Include/master-slave.inc
[Connection Master]
Grant Replication Slave on * * to [email protected] require SSL;
CREATE table t1 (t int auto_increment, KEY (t));
Stop slave;
Change Master to
Master_user= ' Replssl ',
Master_password= ',
Master_ssl=1,
Master_ssl_ca = ' Mysql_test_dir/std_data/cacert.pem ',
Master_ssl_cert= ' Mysql_test_dir/std_data/client-cert.pem ',
master_ssl_key= ' Mysql_test_dir/std_data/client-key.pem ';
Start slave;
INSERT into T1 values (1);

= =/usr/share/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
2016-06-22 13:16:28 1

SHOW SLAVE STATUS on Default * * * *
SHOW SLAVE STATUS;

SHOW MASTER STATUS on Default * * * * *
SHOW MASTER STATUS;
File master-bin.000001
Position 444
binlog_do_db
binlog_ignore_db

SHOW SLAVE HOSTS on Default * * * *
SHOW SLAVE HOSTS;
SERVER_ID 2
Host 127.0.0.1
Port 13001
Rpl_recovery_rank 0
MASTER_ID 1

SHOW processlist on Default * * * *
SHOW processlist;
Id User Host db Command time State Info
109 root localhost:48082 NULL Binlog Dump 301 have sent all Binlog to slave; Waiting for Binlog to be updated NULL
122 root localhost null Query 0 null SHOW processlist

SHOW BINARY LOGS on Default * * * *
SHOW BINARY LOGS;
Log_name file_size
master-bin.000001 444

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 106 server Ver:5.1.66-log, Binlog ver:4
master-bin.000001 106  Query 1 248 use ' test '; Grant Replication Slave on * * to [email protected] require SSL
master-bin.000001 248 query 1 357 use ' test '; CREATE table T1 (t int Auto_increment, KEY (t))
Master-bin.000001 357 query 1 444 use ' test '; INSERT into T1 VALUES (1)

= =/usr/share/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
2016-06-22 13:16:28 2

SHOW SLAVE STATUS on Default * * * *
SHOW SLAVE STATUS;
Slave_io_state
Master_host 127.0.0.1
Master_user Replssl
Master_port 13000
Connect_retry 1
Master_log_file master-bin.000001
Read_master_log_pos 357
Relay_log_file slave-relay-bin.000001
Relay_log_pos 4
Relay_master_log_file master-bin.000001
Slave_io_running No
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 357
Relay_log_space 106
Until_condition None
Until_log_file
Until_log_pos 0
Master_ssl_allowed Yes
Master_ssl_ca_file/usr/share/mysql-test/std_data/cacert.pem
Master_ssl_ca_path
Master_ssl_cert/usr/share/mysql-test/std_data/client-cert.pem
Master_ssl_cipher
Master_ssl_key/usr/share/mysql-test/std_data/client-key.pem
Seconds_behind_master NULL
Master_ssl_verify_server_cert No
Last_io_errno 2026
Last_io_error Error connecting to Master'[email protected]: 13000 ' -Retry-time:1 retries:10
Last_sql_errno 0
Last_sql_error

SHOW MASTER STATUS on Default * * * * *
SHOW MASTER STATUS;
File slave-bin.000001
Position 357
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
The system User NULL Connect 301 have read all relay log; Waiting for the slave I/O thread to update it NULL
113 root localhost null Query 0 null SHOW processlist

SHOW BINARY LOGS on Default * * * *
SHOW BINARY LOGS;
Log_name file_size
SLAVE-BIN.000001 357

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 106 Server ver:5.1.66-log, Binlog ver:4
SLAVE-BIN.000001 106 Query 1 248 use ' test '; Grant Replication Slave on * * to [email protected] require SSL
slave-bin.000001 248 Query 1 357 use ' test '; CREATE table t1 (t int auto_increment, KEY (t))

-saving '/usr/share/mysql-test/var/log/rpl.rpl_ssl-mix/' to '/usr/share/mysql-test/var/log/rpl.rpl_ssl-mix/'

Only 340 of 1634 completed.
Mysql-test-run: * * * error:not all tests completed

This article from the "Technology in hand, the world I have" blog, please be sure to keep this source http://xin521long.blog.51cto.com/11884590/1832410

Usrbinmysqlbug Script test process status