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.................
super..................
ReplyDeleteI 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.
ReplyDeletewww.dubaitravelshop.com |
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.
ReplyDeletethatgirltravel.com |
Always thinking to do the same thing again and again , i am very thankful that i found this one..
ReplyDeletewww.privatelyguidedtours.com |
I am really satisfied with this posting that you have given us. This is really a stupendous work done by you.
ReplyDeletewww.auto-corner.org |
I like the way you described the topic with such clarity. Thanks for Describing Everything.
ReplyDeletehttp://www.1890carolinehousebnb.com |
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.
ReplyDeletewww.ritualjazz.com |
So what does this mean for the future of Rails dev? gw2 gold Does DHH need to find a new gig?
ReplyDelete10-week-fitness.com |
Really impressed! Everything is very open and very clear clarification of issues. It contains truly information. Your website is very beneficial. Thanks for sharing.
ReplyDeletehttp://www.seattlesbestcars.com |
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.
ReplyDeletewasillaweddings.com |
louboutin shoes
ReplyDeletekate spade
pandora charms sale clearanc
coach factory outlet online
air max 90
longchamp outlet store
toms outlet store
canada goose outlet
true religion jeans outlet
yeezy boost
zhi20161228
ReplyDeleteشركة نقل عفش من الدمام الى الرياض شركة نقل عفش من الدمام الى الرياض
ارخص شركة نقل عفش بمكة شركة نقل عفش بمكة
شركة نقل عفش من جدة الى الاردن شركة نقل عفش من جدة الى الاردن
شركة نقل عفش من الرياض الى مصر شركة نقل عفش من الرياض الى مصر
شركة نقل عفش بالدمام شركة نقل عفش بالدمام
شركة نقل عفش بالاحساء شركة نقل عفش بالاحساء
نقل عفش داخل مكة نقل عفش داخل مكة