maria-discuss team mailing list archive

[Justin Swanhart <greenlion@xxxxxxxxx>]

I think the problem is that DDL is written to the binary log using
STATEMENT based replication.  So you have DDL (which produces SBR)
involving mysql.slow_log which will generate this error.

On Mon, Jan 19, 2015 at 2:14 PM, Reindl Harald <h.reindl@xxxxxxxxxxxxx>
wrote:

> uhm - binlog-format = ROW since at least 5 years everywhere
>
> how does 10.0.x come to the crazy idea it is "BINLOG_FORMAT = STATEMENT"?
>
> 150119 22:07:52 [Warning] Unsafe statement written to the binary log using
> statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe
> because it uses the general log, slow query log, or performance_schema
> table(s). This is unsafe because system tables may differ on slaves.
> Statement: repair table `mysql`.`column_stats`, `mysql`.`columns_priv`,
> `mysql`.`db`, `mysql`.`event`, `mysql`.`func`, `mysql`.`general_log`,
> `mysql`.`help_category`, `mysql`.`help_keyword`, `mysql`.`help_relation`,
> `mysql`.`help_topic`, `mysql`.`host`, `mysql`.`index_stats`,
> `mysql`.`ndb_binlog_index`, `mysql`.`plugin`, `mysql`.`proc`,
> `mysql`.`procs_priv`, `mysql`.`proxies_priv`, `mysql`.`roles_mapping`,
> `mysql`.`servers`, `mysql`.`slow_log`, `mysql`.`table_stats`,
> `mysql`.`tables_priv`, `mysql`.`time_zone`, `mysql`.`time_zone_leap_second`,
> `mysql`.`time_zone_name`, `mysql`.`time_zone_transition`,
> `mysql`.`time_zone_transition_type`, `mysql`.`user`
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>