[MDEV-17469] Replication Slave + SQL_Delay Created: 2018-10-16  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Replication
Affects Version/s: 10.3.9
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Aurélien LEQUOY Assignee: Andrei Elkin
Resolution: Unresolved Votes: 0
Labels: None
Environment:

debian 9

Attachments: PNG File Screenshot from 2018-10-16 12-08-11.png     PNG File Screenshot from 2018-10-18 11-32-03.png    
Issue Links:
Relates
relates to MDEV-13895 GTID and Master_Delay causes excessiv... Closed

 Description   

Hello, I have some trouble when I set up SQL_Delay, if you set it from 0 no problem, until you change DELAY, and / or you change stop / start replication.

In some time it's look like the slave ask again the binlog to the master !

 Comments   
Comment by Aurélien LEQUOY [ 2018-10-18 ]

and without reason he decide to recover delta around 21h45, (between 9h00 and 21h45 the replication don't moved), maybe server reask binlog again from master?

Comment by Andrei Elkin [ 2018-10-29 ]

Thank you for the report Aurelien. I think this is a highly probable duplicate of MDEV-13895 which we take on first. If you could help a bit its fixing trying out a how-to-repeat test on that page.

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