MySQL Forums
Forum List  »  Replication

Master updates Slave but not Master itself
Posted by: Mannoj Kumar
Date: April 30, 2013 04:54AM

I have a setup master/slave in which applications are pointed only to master. Yesterday Master had got crashed due to "multi bit error on dimm detected" in Front indication panel in orange color.

After reboot I see the master went for recovery then it came up and application started to use the Master normally but still the err msg exist in Front indication panel. But now the slave had stuck out due to primary key constraint for a table.

The problem I face is master has a table data until what exist in binlog of master. But slave has the table data what is not in master binlog. Below is the table details when compared to Master table and Slave table.

Last info in binlog timestamp is 2013-04-29 02:13:11
System shut down timestamp 2013-04-29 02:54

mysql> select * from audit where id=11298907;
------------------------------------------------------------
| id | ipaddress | dated | msisdn |
+----------+----------------+-------------------------------
|11298907 | 82.25.226.183 | 2013-04-29 02:13:11 | 998282821|
-----------------------------------------------------------
mysql> select * from audit where id > 11298907 limit 1;

-----------------------------------------------------------
| id | ipaddress | dated |msisdn |
+----------+----------------+------------------------------
|11298908 | 82.25.226.183 | 2013-04-29 04:31:13 | 992828111|
------------------------------------------------------------

On Slave
==========

mysql> select * from audit where id=11298907;
------------------------------------------------------------
| id | ipaddress | dated | msisdn |
+----------+----------------+-------------------------------
|11298907 | 82.25.226.183 | 2013-04-29 02:13:11 | 998282821|
-----------------------------------------------------------



mysql> select * from audit where id > 11298907 limit 1;

-----------------------------------------------------------
| id | ipaddress | dated |msisdn |
+--------+----------------+---------------------------------
|11298908 | 82.25.226.183 | 2013-04-29 02:13:12 | 762616173|
------------------------------------------------------------
Both the servers are ntp synched with GST. And they remain same after Master reboot too. It took almost 2 hrs to bring up Master Server. How come only slave can have the data that Master is not aware of? Please have someone come accross such a thing?

Options: ReplyQuote


Subject
Views
Written By
Posted
Master updates Slave but not Master itself
1749
April 30, 2013 04:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.