RE: MySQL 3.23.49 - strange replication error

[Liz Carroll]

It only happened the once, I've checked the history and no one executed any
odd commands (that I noticed:-)

Thanks
Liz

-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: 26 November 2002 15:45
To: [EMAIL PROTECTED]
Subject: re: MySQL 3.23.49 - strange replication error


Liz,
Monday, November 25, 2002, 6:47:35 PM, you wrote:

LC I've got a master database with 2 slaves.  I've had them up and running
for
LC quite a while now with no problems, but today I noticed an error - there
was
LC a slave running on the master!

LC I checked /etc/my.cnf - no mention of slaves (it hadn't been changed for
a
LC good while anyway).  I looked everywhere else mysql looks for my.cnf
files
LC but there were none.  I tried to stop the slave by running SLAVE STOP -
it
LC said 0 rows changed and SHOW SLAVE STATUS showed that the slave was
still
LC running!   I stopped mysql, moved the master.info and restarted mysql -
this
LC fixed the problem (none of the proper slaves reported any errors at any
LC point) but I'm still a little worried why this happened.

LC The master.info created on the master is shown below (I've put in the
\n's
LC so you can see where there were blank lines):

LC \n
LC 4\n
LC \n
LC test\n
LC \n
LC 3306\n
LC 60\n

LC Anyone have any ideas why this might have happened?  This error first
LC started when one of my colleagues restarted mysql today, but we restart
it
LC fairly regularly, I checked the command he used - it was fine.  FYI - we
run
LC Redhat 7.2.

It happens each time when you restart the MySQL server? or just once?
Did someone executed command like CHANGE MASTER TO .. ?




--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL 3.23.49 - strange replication error

[Liz Carroll]

Hi

I've got a master database with 2 slaves.  I've had them up and running for
quite a while now with no problems, but today I noticed an error - there was
a slave running on the master!

I checked /etc/my.cnf - no mention of slaves (it hadn't been changed for a
good while anyway).  I looked everywhere else mysql looks for my.cnf files
but there were none.  I tried to stop the slave by running SLAVE STOP - it
said 0 rows changed and SHOW SLAVE STATUS showed that the slave was still
running!   I stopped mysql, moved the master.info and restarted mysql - this
fixed the problem (none of the proper slaves reported any errors at any
point) but I'm still a little worried why this happened.

The master.info created on the master is shown below (I've put in the \n's
so you can see where there were blank lines):

\n
4\n
\n
test\n
\n
3306\n
60\n

Anyone have any ideas why this might have happened?  This error first
started when one of my colleagues restarted mysql today, but we restart it
fairly regularly, I checked the command he used - it was fine.  FYI - we run
Redhat 7.2.

Kind regards
Liz


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php