Details
-
Bug
-
Status: Done
-
Low
-
Resolution: Reopened
-
5.7.21-21, 5.7.22-22, 5.7.26-29
-
None
Description
**Reported in Launchpad by monty solomon last update 17-01-2018 21:05:57
Some slaves are behind and hung with status "Waiting for binlog lock" while xtrabackup is running.
Server version: 5.6.25-73.1-log Percona Server (GPL), Release 73.1, Revision 07b797f
xtrabackup version 2.2.12 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 8726828)
root 5269 5243 0 05:00 ? 00:00:00 perl /usr/bin/innobackupex --slave-info --stream=tar ./
root 5289 5269 0 05:00 ? 00:00:22 xtrabackup --defaults-group=mysqld --backup --suspend-at-end --target-dir=/opt/mysql/dblogs1/comments-p0/tmp --innodb_data_file_path=ibdata1:12M:autoextend --tmpdir=/opt/mysql/dblogs1/comments-p0/tmp --extra-lsndir=/opt/mysql/dblogs1/comments-p0/tmp --stream=tar
mysql> show slave status\G
1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: featherwoman
Master_User: SUSR_Repl
Master_Port: 3306
Connect_Retry: 15
Master_Log_File: bin.013900
Read_Master_Log_Pos: 76892
Relay_Log_File: relay.041706
Relay_Log_Pos: 802598
Relay_Master_Log_File: bin.013898
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: 802441
Relay_Log_Space: 1867701
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: 2393
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: 1285626324
Master_UUID: 9142b755-ac30-11e4-ab03-0e946fe5c82d
Master_Info_File: /opt/mysql/dbdata1/comments-p0/master.info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Waiting for binlog lock
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
1 row in set (0.00 sec)
mysql> show processlist;
----------------------+++-------------------------------------------------------------------------------------------------------------------------
| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined |
----------------------+++-------------------------------------------------------------------------------------------------------------------------
| 5 | system user | NULL | Connect | 6845243 | Waiting for master to send event | NULL | 0 | 0 | |
| 6 | system user | NULL | Connect | 2654 | Waiting for binlog lock | NULL | 0 | 0 | |
| 4429539 | SUSR_Monitor | 172.16.45.179:50025 | NULL | Sleep | 22 | NULL | 0 | 0 | |
| 6922906 | root | localhost | NULL | Sleep | 2654 | NULL | 0 | 0 | |
| 6925239 | SUSR_Heartbeat | 127.0.0.1:38044 | NULL | Sleep | 0 | NULL | 0 | 0 | |
| 6925385 | SUSR_Heartbeat | 127.0.0.1:38302 | NULL | Sleep | 0 | NULL | 403 | 403 | |
| 6925532 | SUSR_Monitor | 172.16.6.27:12112 | mysql | Sleep | 164 | NULL | 0 | 0 | |
| 6925676 | SUSR_Monitor | 172.18.7.134:58842 | mysql | Sleep | 22 | NULL | 0 | 0 | |
| 6925697 | root | localhost | NULL | Query | 0 | init | show processlist | 0 | 0 |
| 6925701 | SUSR_Heartbeat | localhost | heartbeat | Sleep | 0 | NULL | 1 | 1 |
----------------------+++-------------------------------------------------------------------------------------------------------------------------
10 rows in set (0.00 sec)
Attachments
Issue Links
- relates to
-
-
- Done
-
