[MDEV-30169] warning about BINLOG_FORMAT = STATEMENT on galera cluster members Created: 2022-12-06  Updated: 2023-07-23  Resolved: 2023-07-23

Status: Closed
Project: MariaDB Server
Component/s: Galera, Replication
Affects Version/s: 10.4.26
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Eugene Assignee: Jan Lindström
Resolution: Incomplete Votes: 0
Labels: binlog
Environment:

Linux 6.0.10-gentoo



 Description   

Noticed warnings written to mysqld.err log file:

2022-12-05 18:49:34 33 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the slave Statement: OPTIMIZE TABLE `table1`

According to the warning, it appears due to having "BINLOG_FORMAT = STATEMENT". However, in fact binlog_format = ROW is set in configuration file, also corresponding variable value is correct.

mysql -e 'select @@binlog_format;'
@@binlog_format
ROW

Since we don't use bin_log replication, this warning doesn't affect anything. However, it's a bit strange to get it on galera cluster members.



 Comments   
Comment by Jan Lindström [ 2023-06-22 ]

euglorg Can you provide full node config file, .e.g. what is value for wsrep_forced_binlog_format ?

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