#1  
Old 20th February 2009, 12:58
afaylona afaylona is offline
Junior Member
 
Join Date: Feb 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
Reply With Quote
Sponsored Links
  #2  
Old 21st February 2009, 18:55
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,748 Times in 2,579 Posts
 
Default

The cleanest way to solve this is to set up replication from scratch again.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Related: MySQL Master-Master Replication 127.0.0.1 HOWTO-Related Questions 1 6th May 2008 14:22
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 13:17
ISPConfig server also a MySQL replication slave jamesh Installation/Configuration 1 2nd August 2006 10:59
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04


All times are GMT +2. The time now is 12:21.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.