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 errors which were indicative of data corruption while
> executing queries. This happened as the CPU usage climbed very
> rapidly, and ultimately the entire master machine crashed with an out
> of memory error.
>
> Does this sound like something that could have been caused by a short-
> lived server ID conflict? All servers involved were running 5.0.27.
>
> Your answers would be most helpful!
>
> Thanks,
> David
>
> On Sep 13, 2007, at 7:58 AM, Shawn Green wrote:
>
>> 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 ID in your slave servers is "BAD". It has
>> caused minor problems like duplicate entries on the slaves and
>> major problems like over a TB of error logs in just a few minutes
>> (because of "failure to connect" errors). There are several very
>> good reasons why *each and every* server in a replication setup
>> needs its own, unique server_id. Many of them are discussed in the
>> chapter on Replication:
>> http://dev.mysql.com/doc/refman/5.0/en/replication.html>>
>> To see what has been fixed in MySQL since 5.0.27 was released,
>> please review the change logs documented here:
>> http://dev.mysql.com/doc/refman/5.0/en/releasenotes-cs-5-0.html>>
>> For a list of all other bugs (active and inactive) you are invited
>> to research the bugs database (it is a public forum) at:
>> http://bugs.mysql.com>>
>> --
>> Shawn Green, Support Engineer
>> MySQL Inc., USA, www.mysql.com
>> Office: Blountville, TN
>> __ ___ ___ ____ __
>> / |/ /_ __/ __/ __ \/ /
>> / /|_/ / // /\ \/ /_/ / /__
>> /_/ /_/\_, /___/\___\_\___/
>> <___/
>> Join the Quality Contribution Program Today!
>> http://dev.mysql.com/qualitycontribution.html>>
>
>
--
high performance mysql consulting
www.provenscaling.com

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.