Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1071050
  • 博文数量: 186
  • 博客积分: 4939
  • 博客等级: 上校
  • 技术积分: 2075
  • 用 户 组: 普通用户
  • 注册时间: 2010-04-08 17:15
文章分类

全部博文(186)

文章存档

2018年(1)

2017年(3)

2016年(11)

2015年(42)

2014年(21)

2013年(9)

2012年(18)

2011年(46)

2010年(35)

分类: Mysql/postgreSQL

2012-10-24 14:38:24


  1. 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`
  2. 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
  3. twork_id`) VALUES (797920, 48745364, 144556)', Error_code: 1452
  4. 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
  5. EY (`lt_asset_id`) REFERENCES `lt_asset` (`id`) ON UPDATE CASCADE) Error_code: 1452
  6. 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
阅读(1866) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~