ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY is unsafe

07, 27, 2012
bullgare
No category
Comment: 1

При переходе на MySQL 5.5 с репликацией стали возникать ошибки:

Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. 
INSERT... ON DUPLICATE KEY UPDATE  on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO Table
                    (zabbix_event_id, next_report_after)
                VALUES
                    (8273354, NOW()), (8273312, NOW())
                ON DUPLICATE KEY UPDATE
                    next_report_after = next_report_after

Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.

INSERT... ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO Table

(zabbix_event_id, next_report_after)

VALUES

(8273354, NOW()), (8273312, NOW())

ON DUPLICATE KEY UPDATE

next_report_after = next_report_after

Daily Archives: 27.07.2012

ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY is unsafe