Mysql 5.5.54 upgrade / Warnings
Pascal Longrais <[email protected]> Fri, 30 Jun 2017 16:49:09 +0200
| Newsgroups | gmane.mail.imap.dbmail |
|---|---|
| Message-ID | <[email protected]> |
Hello, Since I upgraded mysql in use with DBMail 2.2.17, I now have continuously warning messages flooding the log file. 170630 16:30:25 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave. Statement: INSERT INTO dbmail_messages (mailbox_idnr,physmessage_id, seen_flag, answered_flag, deleted_flag, flagged_flag, recent_flag, draft_flag, unique_id, status) SELECT 1, physmessage_id, seen_flag, answered_flag, deleted_flag, flagged_flag, recent_flag, draft_flag, '00e88ea75a58a5653ab2fb0615e2bec6', status FROM dbmail_messages WHERE message_idnr = 1179279 How is this warning critical ? Can I fix something ? Thx & best regards _______________________________________________ DBmail mailing list [email protected] http://lists.nfg.nl/mailman/listinfo/dbmail