- 论坛徽章:
- 0
|
本帖最后由 最不爱吃鱼 于 2011-09-27 14:09 编辑
回复 9# 飞鸿无痕
110927 14:06:19 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000050' at position 101673, relay log './mail-relay-bin.000002' position: 101819
110927 14:06:19 [ERROR] Slave SQL: Error 'Duplicate entry 'd174a64b68f9a917d982d02d7e3eb57a' for key 'PRIMARY'' on query. Default database: 'feng_production'. Query: 'INSERT INTO `online_members` (`member_id`, `ip`, `location`, `updated_at`, `created_at`, `time_count`, `visitor`) VALUES (0, '116.63.131.55', 'http://www..com/login?upurl=http%3A%2F%2Fwww.j.com%2Fmy', '2011-09-23 17:19:20', '2011-09-23 17:19:20', 0, 'd174a64b68f9a917d982d02d7e3eb57a')', Error_code: 1062
110927 14:06:19 [Warning] Slave: Duplicate entry 'd174a64b68f9a917d982d02d7e3eb57a' for key 'PRIMARY' Error_code: 1062
110927 14:06:19 [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.000050' position 101673
是不是我操作的时候要锁住master的表才可以? |
|