Test percona_show_slave_status_nolock is unstable
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Fix Released
|
Low
|
Laurynas Biveinis | |||
5.6 |
Fix Released
|
Low
|
Laurynas Biveinis | |||
5.7 |
Invalid
|
Undecided
|
Laurynas Biveinis |
Bug Description
main.percona_
Test ended at 2016-08-01 09:01:47
CURRENT_TEST: main.percona_
=== SHOW MASTER STATUS ===
---- 1. ----
File slave-bin.000001
Position 1167
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 13021
Connect_Retry 1
Master_Log_File master-bin.000001
Read_Master_Log_Pos 1270
Relay_Log_File slave-relay-
Relay_Log_Pos 357
Relay_Master_
Slave_IO_Running Yes
Slave_SQL_Running Yes
Replicate_Do_DB
Replicate_Ignore_DB
Replicate_Do_Table
Replicate_
Replicate_
Replicate_
Last_Errno 0
Last_Error
Skip_Counter 0
Exec_Master_Log_Pos 1270
Relay_Log_Space 1720
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_
Master_
Last_IO_Errno 0
Last_IO_Error
Last_SQL_Errno 0
Last_SQL_Error
Replicate_
Master_Server_Id 1
=======
=== SHOW PROCESSLIST ===
---- 1. ----
Id 18
User root
Host localhost:50759
db test
Command Sleep
Time 303
State
Info
Rows_sent 1
Rows_examined 0
Rows_read 0
---- 2. ----
Id 19
User root
Host localhost:50761
db test
Command Sleep
Time 303
State
Info
Rows_sent 1
Rows_examined 0
Rows_read 0
---- 3. ----
Id 22
User root
Host localhost:50774
db test
Command Query
Time 0
State
Info SHOW PROCESSLIST
Rows_sent 0
Rows_examined 0
Rows_read 0
---- 4. ----
Id 23
User root
Host localhost:50775
db test
Command Sleep
Time 303
State
Info
Rows_sent 1
Rows_examined 0
Rows_read 0
---- 5. ----
Id 24
User root
Host localhost:50776
db test
Command Sleep
Time 302
State
Info
Rows_sent 0
Rows_examined 0
Rows_read 0
---- 6. ----
Id 25
User root
Host localhost:50777
db test
Command Sleep
Time 301
State
Info
Rows_sent 0
Rows_examined 0
Rows_read 0
---- 7. ----
Id 26
User root
Host localhost:50792
db test
Command Sleep
Time 300
State
Info
Rows_sent 1
Rows_examined 0
Rows_read 0
---- 8. ----
Id 27
User system user
Host
db
Command Connect
Time 300
State Waiting for master to send event
Info
Rows_sent 0
Rows_examined 0
Rows_read 0
---- 9. ----
Id 28
User system user
Host
db
Command Connect
Time 300
State Slave has read all relay log; waiting for the slave I/O thread to update it
Info
Rows_sent 0
Rows_examined 0
Rows_read 0
=======
analyze: sync_with_master
mysqltest: At line 88: sync_slave_
The result from queries just before the failure was:
< snip >
SHOW SLAVE STATUS NOLOCK;
SET DEBUG_SYNC='now WAIT_FOR signal.
# should be 'signal.
SIGNAL after SHOW SLAVE STATUS NOLOCK is 'signal.
[slave]
SET DEBUG_SYNC='now SIGNAL signal.continue';
[slave]
SET DEBUG_SYNC='now SIGNAL signal.empty';
[slave_stop]
include/
START SLAVE;
include/
[master]
SET DEBUG_SYNC='RESET';
[slave]
SET GLOBAL DEBUG='';
SET DEBUG_SYNC='RESET';
[master]
DROP TABLE t;
More results from queries before failure can be found in /mnt/workspace/
safe_process[
== /mnt/workspace/
#######
**** SHOW WARNINGS on default ****
SHOW WARNINGS;
Level Code Message
**** SELECT replication-related variables on default ****
SELECT NOW(), @@SERVER_ID;
NOW() @@SERVER_ID
2016-08-01 16:01:47 1
**** SHOW SLAVE STATUS on default ****
SHOW SLAVE STATUS;
**** SHOW MASTER STATUS on default ****
SHOW MASTER STATUS;
File master-bin.000001
Position 1270
Binlog_Do_DB
Binlog_Ignore_DB
**** SHOW SLAVE HOSTS on default ****
SHOW SLAVE HOSTS;
Server_id 2
Host 127.0.0.1
Port 13022
Master_id 1
**** SHOW PROCESSLIST on default ****
SHOW PROCESSLIST;
Id User Host db Command Time State Info Rows_sent Rows_examined Rows_read
17 root localhost:33468 NULL Binlog Dump 300 Master has sent all binlog to slave; waiting for binlog to be updated NULL 0 0 0
18 root localhost NULL Query 0 NULL SHOW PROCESSLIST 0 0 0
**** SHOW BINARY LOGS on default ****
SHOW BINARY LOGS;
Log_name File_size
master-bin.000001 1270
**** SHOW BINLOG EVENTS on default ****
binlog_name = 'master-bin.000001'
SHOW BINLOG EVENTS IN 'master-
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000001 4 Format_desc 1 107 Server ver: 5.5.50-
master-bin.000001 107 Query 1 174 BEGIN
master-bin.000001 174 Query 1 455 use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST(
master-bin.000001 455 Query 1 523 COMMIT
master-bin.000001 523 Query 1 636 use `test`; DROP TABLE IF EXISTS `t` /* generated by server */
master-bin.000001 636 Query 1 721 use `test`; CREATE TABLE t(id INT)
master-bin.000001 721 Query 1 789 BEGIN
master-bin.000001 789 Query 1 875 use `test`; INSERT INTO t VALUES(0)
master-bin.000001 875 Query 1 944 COMMIT
master-bin.000001 944 Query 1 1012 BEGIN
master-bin.000001 1012 Query 1 1098 use `test`; INSERT INTO t VALUES(1)
master-bin.000001 1098 Query 1 1167 COMMIT
master-bin.000001 1167 Query 1 1270 use `test`; DROP TABLE `t` /* generated by server */
**** SHOW RELAYLOG EVENTS on default ****
relaylog_name = 'No such row'
SHOW RELAYLOG EVENTS IN 'No such row';
Log_name Pos Event_type Server_id End_log_pos Info
== /mnt/workspace/
#######
**** SHOW WARNINGS on default ****
SHOW WARNINGS;
Level Code Message
**** SELECT replication-related variables on default ****
SELECT NOW(), @@SERVER_ID;
NOW() @@SERVER_ID
2016-08-01 16:01:47 2
**** SHOW SLAVE STATUS on default ****
SHOW SLAVE STATUS;
Slave_IO_State Waiting for master to send event
Master_Host 127.0.0.1
Master_User root
Master_Port 13021
Connect_Retry 1
Master_Log_File master-bin.000001
Read_Master_Log_Pos 1270
Relay_Log_File slave-relay-
Relay_Log_Pos 357
Relay_Master_
Slave_IO_Running Yes
Slave_SQL_Running Yes
Replicate_Do_DB
Replicate_Ignore_DB
Replicate_Do_Table
Replicate_
Replicate_
Replicate_
Last_Errno 0
Last_Error
Skip_Counter 0
Exec_Master_Log_Pos 1270
Relay_Log_Space 1720
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_
Master_
Last_IO_Errno 0
Last_IO_Error
Last_SQL_Errno 0
Last_SQL_Error
Replicate_
Master_Server_Id 1
**** SHOW MASTER STATUS on default ****
SHOW MASTER STATUS;
File slave-bin.000001
Position 1270
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 Rows_sent Rows_examined Rows_read
27 system user NULL Connect 300 Waiting for master to send event NULL 0 0 0
28 system user NULL Connect 300 Slave has read all relay log; waiting for the slave I/O thread to update it NULL 0 0 0
29 root localhost NULL Query 0 NULL SHOW PROCESSLIST 0 0 0
**** SHOW BINARY LOGS on default ****
SHOW BINARY LOGS;
Log_name File_size
slave-bin.000001 1270
**** 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 107 Server ver: 5.5.50-
slave-bin.000001 107 Query 1 174 BEGIN
slave-bin.000001 174 Query 1 455 use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST(
slave-bin.000001 455 Query 1 523 COMMIT
slave-bin.000001 523 Query 1 636 use `test`; DROP TABLE IF EXISTS `t` /* generated by server */
slave-bin.000001 636 Query 1 721 use `test`; CREATE TABLE t(id INT)
slave-bin.000001 721 Query 1 789 BEGIN
slave-bin.000001 789 Query 1 875 use `test`; INSERT INTO t VALUES(0)
slave-bin.000001 875 Query 1 944 COMMIT
slave-bin.000001 944 Query 1 1012 BEGIN
slave-bin.000001 1012 Query 1 1098 use `test`; INSERT INTO t VALUES(1)
slave-bin.000001 1098 Query 1 1167 COMMIT
slave-bin.000001 1167 Query 1 1270 use `test`; DROP TABLE `t` /* generated by server */
**** SHOW RELAYLOG EVENTS on default ****
relaylog_name = 'slave-
SHOW RELAYLOG EVENTS IN 'slave-
Log_name Pos Event_type Server_id End_log_pos Info
slave-relay-
slave-relay-
slave-relay-
slave-relay-
select master_
tags: | added: ci |
https:/ /github. com/percona/ percona- server/ pull/759 /github. com/percona/ percona- server/ pull/760 /github. com/percona/ percona- server/ pull/761
https:/
https:/