Error 1714: INSERT IGNORE... SELECT is unsafe because the order in which rows are retrieved by the S
Error Code
SQLSTATE
Error
Description
1714
HY000
ER_BINLOG_UNSAFE_INSERT_IGNORE_SELECT
INSERT IGNORE... SELECT is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are ignored. This order cannot be predicted and may differ on master and the slave.
Possible Causes and Solutions
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
PreviousError 1713: Undo log record is too bigNextError 1715: INSERT... SELECT... ON DUPLICATE KEY UPDATE is unsafe because the order in which rows ar
Last updated
Was this helpful?