- 121024 4:04:36 [ERROR] Slave SQL: Error 'Cannot add or update a child row: a foreign key constraint fails (`db1`.`lt_asset_group_assignment`, CONSTRAINT `fk_lt_asset_group_assignment_lt_asset_id`
- FOREIGN KEY (`lt_asset_id`) REFERENCES `lt_asset` (`id`) ON UPDATE CASCADE)' on query. Default database: 'db1'. Query: 'INSERT INTO `lt_asset_group_assignment` (`asset_group_id`, `lt_asset_id`, `ne
- twork_id`) VALUES (797920, 48745364, 144556)', Error_code: 1452
- 121024 4:04:36 [Warning] Slave: Cannot add or update a child row: a foreign key constraint fails (`db1`.`lt_asset_group_assignment`, CONSTRAINT `fk_lt_asset_group_assignment_lt_asset_id` FOREIGN K
- EY (`lt_asset_id`) REFERENCES `lt_asset` (`id`) ON UPDATE CASCADE) Error_code: 1452
- 121024 4:04:36 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.003717' position 19625392
set foreign_key_checks=0 and restart slave ,then set xxx =1;
if you regard some of erros as meaningless and incline to skip it ,there are two methods:
1.stop slave ;SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; show slave status; and repeat again and again until the errors are gone away .
2.vim /etc/my.cnf
skip xxx
阅读(1905) | 评论(0) | 转发(0) |