List:General Discussion« Previous MessageNext Message »
From:Mike Dopheide Date:November 10 2002 2:16am
Subject:mysqld crashing
View as plain text  
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

Thread
mysqld crashingMike Dopheide10 Nov
  • re: mysqld crashingVictoria Reznichenko11 Nov