Replication error in Mysql
Hi,
Good Day!I'm a newbie here and I'm not sure if I post this on the correct category. anyway, I have a problems in mysql replication. I have servermaster and serverSlave. ABout last 3 days ago mysql replication server failed. But I was able to resolve the problem by doing a "reset slave". then a start slave command in mysql command prompt. for about 30 mins it was working fine and started updating tables(I guess). but after 30 mins the replication popped an error again, the disk is full, so I have to stop the slave and increase the size of the disk. After doing a start slave again on mysql the error was this .
[COLOR="red"][COLOR="Red"][ERROR] Slave: Error 'Duplicate entry '23858319' for key 1' on query. Default database: 'friendster_gateway'. Query: 'insert into charge_status_log (msg_id, access_code, phone, result, tariff, session, carrier, log_date, log_time) values ('27613660', '247', '639164226868', '21', 'CHG0250', 'SESSION4126CDC9795D97350515AB8B4', '92', curdate(), curtime())', Error_code: 1062
How will I resolve the problem. the last error no is 1062.
Please help me with my problem
|
Recent comments
1 day 5 hours ago
1 day 10 hours ago
1 day 14 hours ago
1 day 16 hours ago
2 days 6 hours ago
2 days 6 hours ago
2 days 11 hours ago
2 days 18 hours ago
2 days 19 hours ago
2 days 20 hours ago