[MDEV-16083] Implausible high "Binlog_bytes_written" value Created: 2018-05-03  Updated: 2021-01-22

Status: Open
Project: MariaDB Server
Component/s: Replication
Affects Version/s: 10.1.29
Fix Version/s: 10.1

Type: Bug Priority: Minor
Reporter: Hartmut Holzgraefe Assignee: Andrei Elkin
Resolution: Unresolved Votes: 1
Labels: None

Issue Links:
Relates
relates to MDEV-22427 Unrealistic Rows_read status variable... Open

 Description   

MariaDB [(none)]> show global status where Value > pow(2,63) and variable_name like '%Binlog%';;
+----------------------+----------------------+
| Variable_name | Value |
+----------------------+----------------------+
| Binlog_bytes_written | 18446743820171207911 |
+----------------------+----------------------+

The master this was seen on is pretty busy, but by far not busy enough to produce 18 Exabytes of binlog. During the systems Uptime about 5TB per second would have been written on average if the shown value were correct.

How to reproduce this is not clear, so far this was a one time incident.



 Comments   
Comment by Louka Dlagnekov (Inactive) [ 2021-01-21 ]

We are still seeing this issue in production with some SkySQL db instances and other server variables. Some values are so unrealistically large that they eventually cause an overflow.

Comment by Andrei Elkin [ 2021-01-22 ]

louka: It'd be very helpful to see the server state at that point. If it's possible could you please provide outputs of
show global variables like '%binlog%', show binary logs, show processlist, show global status next time?

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