[MDEV-21760] second_behind_master not good at all Created: 2020-02-18  Updated: 2020-02-18

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Aurélien LEQUOY Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Attachments: PNG File Capture d’écran de 2020-02-18 11-41-34.png    

 Description   

I monitor SHOW SLAVE STATUS each 5 seconds, and some time without any reason second behind master give me a crazy number :

MariaDB [pmacontrol]> select * from ts_value_slave_int where id_ts_variable = 815 and date= '2020-02-18 06:25:24' and id_mysql_server=33;
+---------+-----------------+----------------+-----------------+---------------------+--------+
| id      | id_mysql_server | id_ts_variable | connection_name | date                | value  |
+---------+-----------------+----------------+-----------------+---------------------+--------+
| 3823039 |              33 |            815 |                 | 2020-02-18 06:25:24 | 411094 |
+---------+-----------------+----------------+-----------------+---------------------+--------+

The one (second behind master) before is 0 and the one after is 0 too.

here : 411094 , an other 423565 (on an other slave on same master).

it seem an even generate this problem, it's all time happen on the same Master/Slave (when it's happen)


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