Slide

  • LINUX

    LINUX:In 1969 AT&T made a decision to withdraw Multics and go with GECOS (General Electric Comprehensive Operating Supervisor / System), with AT & T in Bells Lab when Multics was withdrawn some of the programmers named Ken Thompson and Dennis Ritchie decided to rewrite operating system in order to support low cost computer..To Know More

    CLICK HERE

  • MICROSOFT

    MICROSOFT:Microsoft was established to develop and sell BASIC interpreters for the Altair 8800. It rose to dominate the home computer operating system market with MS-DOS in the mid-1980s,followed by the Microsoft Windows line of operating systems. To Know More

    CLICK HERE

  • CISCO

    CISCO:During the early 1980s, there was a married couple namely Len and Sandy Bosack who used to work in two different departments of computer located in Stanford University. This couple was facing problem in making their computers communicate with each other To Know More

    CLICK HERE

showinfo=1

MYSQL REPLICATION ERROR 1053


MYSQL ERROR 1053





    ERROR:- Query partially completed on the master (error on master: 1053) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;

The error code 1053 which means as much as "server shutdown".



We checked the master and could not find anything unusual. The server had not been shut down at all and nothing seemed wrong with the master replication settings either.

In the end we found out what had caused the problem: Someone had tried to create a dump of the master server using  mysqldump --master-data. This implies a FLUSH TABLES statement. Because that statement took too long it was aborted using the MySQL KILL command. However because that statement had already been replicated to the slaves and was now aborted, the slaves took it for "partially executed" (which is usually something bad). The error code you can see on a killed client is 1053. So the slaves decided that something serious had happened and stopped the communication with their master.
Check on which instance is the mysql running then
Go to the same instance and the following CMD
ERROR OUTPUT
reports error in replication: Query partially completed on the master (error on master: 1053) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; . Query: 'DELETE FROM tc_data_raw_ad_impression WHERE date_time <= '2013-01-29 13:59:59''

     Slave File          <<<      Master File
     master-bin.001769   <<<      master-bin.001797
     Slave Pos           <<<      Master Pos
     83027418            <<<      40366841

Solution:-


mysql> stop slave;
mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
mysql> start slave;
mysql> quit
#rep_mon
OUTPUT
reports it is 3618 seconds behind
     Slave File          <<<      Master File
     master-bin.001798   <<<      master-bin.001801
     Slave Pos           <<<      Master Pos
     85916100            <<<      45308656


done.................

13 comments:

  1. super..................

    ReplyDelete
  2. This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value. Im glad to have found this post as its such an interesting one! I am always on the lookout for quality posts and articles so i suppose im lucky to have found this! I hope you will be adding more in the future..
    bodytech-health.com |

    ReplyDelete
  3. I like you recommendation. Your recommendation is of well use to people. A great article post, this is something very interesting. I really appreciate your post.
    www.dubaitravelshop.com |

    ReplyDelete
  4. Thanks for any other informative site. The place else could I get that kind of info written in such a perfect manner? I have a mission that I am simply now running on, and I've been at the look out for such info.
    thatgirltravel.com |

    ReplyDelete
  5. Always thinking to do the same thing again and again , i am very thankful that i found this one..
    www.privatelyguidedtours.com |

    ReplyDelete
  6. I am really satisfied with this posting that you have given us. This is really a stupendous work done by you.
    www.auto-corner.org |

    ReplyDelete
  7. I like the way you described the topic with such clarity. Thanks for Describing Everything.
    http://www.1890carolinehousebnb.com |

    ReplyDelete
  8. I have been waiting for someone to share this post. This has actually made me think and I hope to read more. Thanks a lot for sharing with us.
    www.ritualjazz.com |

    ReplyDelete
  9. So what does this mean for the future of Rails dev? gw2 gold Does DHH need to find a new gig?
    10-week-fitness.com |

    ReplyDelete
  10. Really impressed! Everything is very open and very clear clarification of issues. It contains truly information. Your website is very beneficial. Thanks for sharing.
    http://www.seattlesbestcars.com |

    ReplyDelete
  11. Interesting point of view and I agree with most of what you say.You've made some valid points and I think you're spot on.
    wasillaweddings.com |

    ReplyDelete

Note:- Comment as: Option available to post without login select "Anonymous" from the drop down...........

For Latest Updates: Subscribe Now | | Test Your Knowledge, Take a Quiz now Click Here | | Site Best Viewed In Firefox

X