error from master 1
Last_SQL_Error:
Error 'Cannot add or update a child row: a foreign key constraint fails (
stylanzo_live
.report_viewed_product_index
, CONSTRAINTFK_REPORT_VIEWED_PRD_IDX_PRD_ID_CAT_PRD_ENTT_ENTT_ID
FOREIGN KEY (product_id
) REFERENCEScatalog_product_entity
(entity_id
) ON)' on query. Default database: 'stylanzo_live'. Query: 'INSERT INTOreport_viewed_product_index
(visitor_id
,customer_id
,product_id
,store_id
,added_at
) VALUES (NULL, NULL, '1092', '23', '2015-05-28 19:20:00') ON DUPLICATE KEY UPDATEvisitor_id
= VALUES(visitor_id
),customer_id
= VALUES(customer_id
),product_id
= VALUES(product_id
),store_id
= VALUES(store_id
),added_at
= VALUES(added_at
)' Replicate_Ignore_Server_Ids:
error from master 2
Last_SQL_Error:
Error 'Duplicate entry '157493' for key 'PRIMARY'' on query. Default database: 'stylanzo_live'. Query: 'INSERT INTO
log_visitor
(session_id
,first_visit_at
,last_visit_at
,last_url_id
,store_id
) VALUES ('7059f889233675a315cd2a35a92e2480', '2015-05-28 19:20:27', '2015-05-28 19:20:27', '0', '23')SELECT create_statement FROM common_schema.sql_foreign_keys WHERE TABLE_SCHEMA='report_viewed_product_index';
Also, when I am starting replication it shows duplicate error again.