afaylona
20th February 2009, 12:58
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"][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', 'SESS[COLOR="red"]ION4126CDC9795D97350515AB8B4', '92', curdate(), curtime())', Error_code: 1062
How will I resolve the problem. the last error no is 1062.
Please help me with my problem
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"][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', 'SESS[COLOR="red"]ION4126CDC9795D97350515AB8B4', '92', curdate(), curtime())', Error_code: 1062
How will I resolve the problem. the last error no is 1062.
Please help me with my problem