[MDEV-19279] Some slaves stop updating master.info Created: 2019-04-18  Updated: 2020-12-08  Resolved: 2019-07-15

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Affects Version/s: 10.1.35, 10.2.16
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Hartmut Holzgraefe Assignee: Ian Gilfillan
Resolution: Fixed Votes: 1
Labels: None


 Description   

In a multi slave replication setup some, but not all, slaves at some point stop to write to master.info, its last-modified time does not go up anymore, for longer than sync_master_info settings would explain.

Looking at lsof / fuser output the slave mysqld processes still have the master.info file open.



 Comments   
Comment by Andrei Elkin [ 2019-07-02 ]

hholzgra I am guessing there's no way to reproduce it?

Comment by Andrei Elkin [ 2019-07-05 ]

hholzgra, Thanks the report and attempts to resolve it! Like I pointed on the support page the case has too little customer data collected.
As they claim the slave(s) is (are) running per Show-Slave-Status, it would be reasonable to request
the SHOW results and ls -l master.info matching those times.

When the pair would suggest indeed no updates to the file, how about
A. if they actually use multi source replication;
B. Events coming from network are big enough and their network link is thin so 10 000 would be of some time to wait.
(The file would still be updated).

However FLUSH LOGS on the master must trigger "master.info" updating. I double-quoted the famous file name
just in case the use indeed run multi-source replication.

Comment by Andrei Elkin [ 2019-07-05 ]

hholzgra, actually change master to .. master_use_gtid > no; makes the IO thread bypass updating flush_master_info (slave, when needed, resumes retrieval using gtid protocol). I hope this is what happened. Cheers.

Comment by Andrei Elkin [ 2019-07-12 ]

greenman Hello. Let me redirect the issue to the docs team. I added details missing, could you please review them

in 50th change in https://mariadb.com/kb/en/library/gtid/+history
and 37th in https://mariadb.com/kb/en/library/change-master-to/+history

Thanks!

Andrei

Comment by Ian Gilfillan [ 2019-07-15 ]

Thanks, documentation updates look clear enough.

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