Re: Conflicting server IDs on slaves

2007-09-14 Thread Jeremy Cole
Hi David, This sounds strange, and should NOT occur because of a server_id conflict. Regards, Jeremy David Schneider-Joseph wrote: Thank you. We had a situation recently where two slaves had a conflicting server ID for several minutes, and shortly thereafter the master started reporting

Re: Conflicting server IDs on slaves

2007-09-14 Thread David Schneider-Joseph
Jeremy, We observed thousands of errors in the logs of one of our slave servers suggesting that it was making repeated failed connections to our master. Example: 070905 20:15:21 [Note] Slave: received end packet from server, apparent master shutdown: 070905 20:15:21 [Note] Slave I/O

Re: Conflicting server IDs on slaves

2007-09-13 Thread Shawn Green
Hello David, David Schneider-Joseph wrote: Hi all, What do you know about the effect of conflicting slave server IDs on the master in general? And specifically, are you aware of any issues with MySQL 5.0.27? Your help is very much appreciated. Thanks! David Repeating the same Server

Re: Conflicting server IDs on slaves

2007-09-13 Thread David Schneider-Joseph
Thank you. We had a situation recently where two slaves had a conflicting server ID for several minutes, and shortly thereafter the master started reporting errors which were indicative of data corruption while executing queries. This happened as the CPU usage climbed very rapidly, and

Conflicting server IDs on slaves

2007-09-12 Thread David Schneider-Joseph
Hi all, What do you know about the effect of conflicting slave server IDs on the master in general? And specifically, are you aware of any issues with MySQL 5.0.27? Your help is very much appreciated. Thanks! David -- MySQL General Mailing List For list archives: