maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #02131
10.0.x: [Warning] Unsafe statement written to the binary log using statement format
-
To:
maria-discuss@xxxxxxxxxxxxxxxxxxx
-
From:
Reindl Harald <h.reindl@xxxxxxxxxxxxx>
-
Date:
Mon, 19 Jan 2015 22:14:09 +0100
-
Openpgp:
id=7F780279; url=http://arrakis.thelounge.net/gpg/h.reindl_thelounge.net.pub.txt
-
Organization:
the lounge interactive design
-
User-agent:
Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.4.0
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`
Attachment:
signature.asc
Description: OpenPGP digital signature
Follow ups