Advertisement
Guest User

Untitled

a guest
Oct 23rd, 2016
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. ------ ------
  2. | m1 | --- | m2 |
  3. ------ ------
  4. || ||
  5. ------ ------
  6. | s1 | | s2 |
  7. ------ ------
  8.  
  9. STOP SLAVE;
  10. CHANGE MASTER TO MASTER_HOST='m1', MASTER_USER='repl', MASTER_PASSWORD='password', MASTER_LOG_FILE='mariadb-bin.NNNNNN', MASTER_LOG_POS=nnn;
  11. START SLAVE;
  12.  
  13. 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