Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ------ ------
- | m1 | --- | m2 |
- ------ ------
- || ||
- ------ ------
- | s1 | | s2 |
- ------ ------
- STOP SLAVE;
- CHANGE MASTER TO MASTER_HOST='m1', MASTER_USER='repl', MASTER_PASSWORD='password', MASTER_LOG_FILE='mariadb-bin.NNNNNN', MASTER_LOG_POS=nnn;
- START SLAVE;
- Could not execute Write_rows_v1 event on table db.table; Cannot add or update a child row: a foreign key constraint fails (`db`.`table`, CONSTRAINT `FK3EBA76781F6AACF1` FOREIGN KEY (`job`) REFERENCES `table2` (`id`)), Error_code: 1452; handler error HA_ERR_NO_REFERENCED_ROW; the event's master log mariadb-bin.000710, end_log_pos 1523526
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement