[MDEV-9230] mysql 5.6.22 mirgate to mariadb 10.0.22, slave stop not error Created: 2015-12-02  Updated: 2022-11-10  Resolved: 2022-11-10

Status: Closed
Project: MariaDB Server
Component/s: Replication
Affects Version/s: 10.0.22
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: sysdljr Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None
Environment:

centos 6.6 , mysql 5.6.22 (GTID) migrate to mariadb 10.0.22

Attachments: HTML File errorlog     File my.cnf     Text File showallslavestatus.txt    
Issue Links:
Duplicate
is duplicated by MDEV-9291 Parallel Slave SQL Thread Status Norm... Closed

 Description   

hello ,all
we migrating mysql 5.6.22 (gtid) to mariadb 10.0.22, use three machine:
A: mysql 5.6.22 (gtid) , master
B: mariadb 10.0.22 , slave of A (use Fusion IO)
C: mairadb 10.0.22 , slave of B (use Fusion IO)

First run xtrabackup at A machine, recover to B machine , start slave normal at B.
Then run xtrabackup at B machine, recover to C machine, start slave normal at begin, After 10 minutes , slave thread status is YES, but Exec_Master_Log_Pos value not change.
if run stop slave , not response. but run ddl, dml statement normal .
error log file not error also.

when run /etc/init.d/mysql stop , mysql not stop . only kill -9 `pidof mysql`
after start mysql, run start slave normal . but only normal about 10 minutes. The same question before

when run show slave status \G , red row value not change
Master_Log_File: mysql-bin.000049
Read_Master_Log_Pos: 703551739 # value change
Relay_Log_File: relay-bin.000002
Relay_Log_Pos: 293817098
Relay_Master_Log_File: mysql-bin.000046
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Exec_Master_Log_Pos: 532843833 # value not change
Relay_Log_Space: 3683986049 # value change
Seconds_Behind_Master: 10602 # value increase

 Comments   
Comment by Elena Stepanova [ 2015-12-02 ]

Does C replicate from B, or from A?
Where does the problem happen, on B or on C?
To which server does the attached my.cnf belong? Please attach the other two as well.
Please paste the complete output of 

SHOW ALL SLAVES STATUS \G
 
SHOW PROCESSLIST;

from the server where the problem happens. Please also attach the error log even if there is nothing wrong in there.
Thanks.

Comment by sysdljr [ 2015-12-03 ]

Thanks.
attached my.cnf belong C,
C replicate from B, we test C replicate from A, the same problem occur.

At Server C:
show all slave status: view attach file showallslavestatus.txt

MariaDB [(none)]> show processlist;
 
+----+-------------+-----------+------+---------+--------+--------------------------------------------------------------------------------+------------------+----------+
 
| Id | User        | Host      | db   | Command | Time   | State                                                                          | Info             | Progress |
 
+----+-------------+-----------+------+---------+--------+--------------------------------------------------------------------------------+------------------+----------+
 
|  4 | root        | localhost | NULL | Query   |      0 | init                                                                           | show processlist |    0.000 |
 
|  5 | system user |           | NULL | Connect |   1314 | Waiting for master to send event                                               | NULL             |    0.000 |
 
|  6 | system user |           | NULL | Connect | 127827 | closing tables                                                                 | NULL             |    0.000 |
 
|  7 | system user |           | NULL | Connect | 127827 | Waiting for prior transaction to start commit before starting next transaction | NULL             |    0.000 |
 
|  8 | system user |           | NULL | Connect | 127827 | Waiting for prior transaction to start commit before starting next transaction | NULL             |    0.000 |
 
|  9 | system user |           | NULL | Connect | 127827 | Waiting for prior transaction to start commit before starting next transaction | NULL             |    0.000 |
 
| 10 | system user |           | NULL | Connect | 127827 | Waiting for prior transaction to start commit before starting next transaction | NULL             |    0.000 |
 
| 11 | system user |           | NULL | Connect | 127827 | Waiting for prior transaction to start commit before starting next transaction | NULL             |    0.000 |
 
| 12 | system user |           | NULL | Connect |   1314 | Waiting for room in worker thread event queue                                  | NULL             |    0.000 |

when slave run normal, a process's state is "executing" and others is "Waiting for prior transaction to start commit before starting next transaction" in processlist ,
when Exec_Master_Log_Pos not change, no process state is "executing"

when occur problem , mysql service not stop normal. use kill -9 mysqld. Then start mysql.

attach error log is since start mysql normal :
errorlog

Comment by Elena Stepanova [ 2022-11-10 ]

Closing as both MySQL 5.6 and MariaDB 10.0 have long been EOL.

Generated at Thu Feb 08 07:33:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.