Mysql version: 3.23.53 Background: I've got a master and slave setup and I'm switching to a new master server. In the process of switching I need the new master to be a slave for awhile. However, after copying over a snapshot of my data I found that mysql dies whenever the slave thread starts.
Problem: Upon further investigation I found that I can start the mysql daemon (without the slave setup) and connect locally just fine, but if I try to connect from a remote host mysql, segfaults and dies: /usr/local/mysql/bin/safe_mysqld: line 1: 10781 Segmentation fault nice --5 nohup /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/blaa.ncsa.uiuc.edu.pid --skip-locking -O key_buffer\=32M -O table_cache\=256 -O myisam_sort_buffer_size\=32M -O sort_buffer\=16M -O record_buffer\=1M --set-variable\=max_allowed_packet\=8M --log-slow-queries\=\/var\/log\/mysql\/slow-queries --log-update\=\/usr\/local\/mysql-backup\/update.log --log-bin\=\/usr\/local\/mysql-backup\/binlog\/mysqlbin --log-bin-index\=\/usr\/local\/mysql-backup\/binlog\/mysqlbin.index --set-variable\=query_buffer_size\=131072 --set-variable\=join_buffer_size\=262144 --set-variable\=thread_cache_size\=16 --set-variable\=max_connections\=1000 -O max_connect_errors\=10000 --server-id\=3 >>/usr/local/mysql/var/blaa.ncsa.uiuc.edu.err 2>&1 Number of processes running now: 1 mysqld process hanging, pid 10791 - killed 021109 19:15:45 mysqld restarted 021109 19:15:45 mysqld ended ---------------------------------------------- The error log simply says this: Number of processes running now: 1 mysqld process hanging, pid 12010 - killed 021109 20:09:00 mysqld restarted 021109 20:09:00 Can't start server: Bind on TCP/IP port: Address already in use 021109 20:09:00 Do you already have another mysqld server running on port: 3306 ? 021109 20:09:00 Aborting 021109 20:09:00 /usr/local/mysql/libexec/mysqld: Shutdown Complete 021109 20:09:00 mysqld ended -------------------------- The remote host sees this: mysql -h blaa.ncsa.uiuc.edu -u virus-admin -p Enter password: ERROR 2013: Lost connection to MySQL server during query I think that's just a symptom of the above problem. I thought it might be a data corruption problem, so I removed my data and ran mysql_install_db. The problem persists. Any ideas? I've just about run out of things to try. The other two mysql servers don't have this problem and they're installed with the same binaries. Thanks, Mike --------------------------------------------------------------------- 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
