[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. When the pair would suggest indeed no updates to the file, how about However FLUSH LOGS on the master must trigger "master.info" updating. I double-quoted the famous file name |
| 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 Thanks! Andrei |
| Comment by Ian Gilfillan [ 2019-07-15 ] |
|
Thanks, documentation updates look clear enough. |