Mike,
Sunday, November 10, 2002, 4:16:29 AM, you wrote:
MD> Background: I've got a master and slave setup
MD> and I'm switching to a new master server. In the process of switching I
MD> need the new master to be a slave for awhile. However, after copying
MD> over a snapshot of my data I found that mysql dies whenever the slave
MD> thread starts.
MD> Problem:
MD> Upon further investigation I found that I can start the mysql daemon
MD> (without the slave setup) and connect locally just fine, but if I try to
MD> connect from a remote host mysql, segfaults and dies:
[skip]
MD> Number of processes running now: 1
MD> mysqld process hanging, pid 10791 - killed
MD> 021109 19:15:45 mysqld restarted
MD> 021109 19:15:45 mysqld ended
MD> ----------------------------------------------
MD> The error log simply says this:
MD> Number of processes running now: 1
MD> mysqld process hanging, pid 12010 - killed
MD> 021109 20:09:00 mysqld restarted
MD> 021109 20:09:00 Can't start server: Bind on TCP/IP port: Address already
MD> in use
MD> 021109 20:09:00 Do you already have another mysqld server running on
MD> port: 3306 ?
MD> 021109 20:09:00 Aborting
MD> 021109 20:09:00 /usr/local/mysql/libexec/mysqld: Shutdown Complete
MD> 021109 20:09:00 mysqld ended
MD> --------------------------
MD> The remote host sees this:
MD> mysql -h blaa.ncsa.uiuc.edu -u virus-admin -p
MD> Enter password:
MD> ERROR 2013: Lost connection to MySQL server during query
MD> I think that's just a symptom of the above problem. I thought it might be
MD> a data corruption problem, so I removed my data and ran mysql_install_db.
MD> The problem persists.
MD> Any ideas? I've just about run out of things to try. The other two mysql
MD> servers don't have this problem and they're installed with the same
MD> binaries.
What OS do you use?
If you are using RedHat, seems your problem is related to the glibc
problem:
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128
https://rhn.redhat.com/errata/RHSA-2002-197.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [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
