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