MySQL Bugs: #28794: Deleting tables in slave when changing the IP

Bug #28794	Deleting tables in slave when changing the IP
Submitted:	31 May 2007 6:12	Modified:	7 Jul 2007 13:34
Reporter:	Venky P	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S1 (Critical)
Version:	5.0.16	OS:	Linux (Redhat 9)
Assigned to:		CPU Architecture:	Any

Description:
I configured master - master configuration using SSL with mysql-5.0.16 sources.
I used only default server certificates on both sides. That certificates avialable with 5.0.16 sources.
I prepared one script to change IPs. 
Before changing IPs i checked with master server have 79 tables and also slave have 79 tables.
After calling change IP checked with master server have 79 tables , but slave have only 16 tables.

Regards,
--venky

How to repeat:
First configured master-master replication.
next change the ip on master and call the restart the sync with new ip by using one script.

Thank you for the report.

But version 5.0.16 is old. Please upgrade to current 5.0.41 version.

>I prepared one script to change IPs. 

What also do the script. Does it change some data?

> next change the ip on master and call the restart the sync with new ip by using one script.

Are you sure cause of the problem is MySQL bug and not bug in the script which restarts the sync? If yes, provide detailed information what the script changes.

changeIp script calling mysql Sync Restart script. Mysql Sync restart create new master.info file for new IP.

Thank you for the feedback.

But what is the "Mysql Sync restart" script? How does it create new master.info file?

Also please upgrade to current 5.0.41 version as we can not fix bugs in old versions. And many replication bugs have been fixed since 5.0.16.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".