Page MenuHomePhabricator

mariadb::binlog_format: 'ROW' not effective on m5/db1175
Closed, ResolvedPublic

Description

db1175 has a discrepancy between puppet and reality:

MariaDB root@(none):(none)> select @@binlog_format;
+-----------------+
| @@binlog_format |
+-----------------+
| MIXED           |
+-----------------+

Event Timeline

ABran-WMF changed the task status from Open to In Progress.Oct 29 2024, 2:46 PM
ABran-WMF triaged this task as Low priority.
ABran-WMF updated the task description. (Show Details)
ABran-WMF moved this task from Triage to Pending comment on the DBA board.

I am not sure if I am missing context here:

cumin2024@db1175.eqiad.wmnet[(none)]> show global variables like 'binlog_format';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| binlog_format | ROW   |
+---------------+-------+
1 row in set (0.035 sec)





cat hieradata/hosts/db1175.yaml
# db1175
mariadb::shard: 's3'
mariadb::binlog_format: 'ROW'
ABran-WMF claimed this task.

either I have missed something or it has been changed in the interval. this issue is now fixed then!