The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB - Replication Warnings in Log

Hi,

Our slaves are logging the following:

110110 20:55:38 [Warning] Statement may not be safe to log in statement format. Statement: UPDATE tablename_line SET
                                        stock_type                      = '',
                                        product_id                      = 58755,
                                        product_qty                     = 1,

We're getting hundreds of them, each one listing a statement. In this case each table is MyISAM. I've not checked to see if this is also impacting INNODB tables.

How do we set to ignore these warnings and not log them. Also it would be nice to just eliminate these warnings and still have other warnings. Our system is heavily transaction oriented, and so we are getting our logs flooded with these messages.

Any help would be appreciated.

Answer

Found that this is logged on the MySQL website as a known issue. Im sorry to inconvenience you with the question. Looks like we need to go to MIXED mode replication i guess. We shall investigate further.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.