MySQL Bugs: #583: Segmentation fault when attempting to start server

Bug #583	Segmentation fault when attempting to start server
Submitted:	4 Jun 2003 3:57	Modified:	5 Jul 2003 4:17
Reporter:	Jon Marston	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	4.0.13	OS:	Linux (linux 2.4.20 - i686)
Assigned to:		CPU Architecture:	Any

Description:
On attempting to start mysql server using bin/mysqld_safe while in mysql directory, the server starts for about 1 second, then dumps a constant loop of errors to the terminal as follows:

localhost mysql # bin/mysqld_safe

Starting mysqld daemon with databases from /usr/local/mysql/data

bin/mysqld_safe: line 320: 18041 Segmentation fault      $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1

 

Number of processes running now: 9

mysqld process hanging, pid 18050 - killed

mysqld process hanging, pid 18049 - killed

mysqld process hanging, pid 18048 - killed

mysqld process hanging, pid 18047 - killed

mysqld process hanging, pid 18046 - killed

mysqld process hanging, pid 18045 - killed

mysqld process hanging, pid 18044 - killed

mysqld process hanging, pid 18043 - killed

mysqld process hanging, pid 18042 - killed

030604 11:15:11  mysqld restarted

bin/mysqld_safe: line 320: 18133 Segmentation fault      $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1

 

Number of processes running now: 9

mysqld process hanging, pid 18142 - killed

mysqld process hanging, pid 18141 - killed

mysqld process hanging, pid 18140 - killed

mysqld process hanging, pid 18139 - killed

mysqld process hanging, pid 18138 - killed

mysqld process hanging, pid 18137 - killed

mysqld process hanging, pid 18136 - killed

mysqld process hanging, pid 18135 - killed

mysqld process hanging, pid 18134 - killed

030604 11:15:12  mysqld restarted

bin/mysqld_safe: line 320: 18225 Segmentation fault      $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1

 

Number of processes running now: 9

mysqld process hanging, pid 18234 - killed

mysqld process hanging, pid 18233 - killed

mysqld process hanging, pid 18232 - killed

mysqld process hanging, pid 18231 - killed

mysqld process hanging, pid 18230 - killed

mysqld process hanging, pid 18229 - killed

mysqld process hanging, pid 18228 - killed

mysqld process hanging, pid 18227 - killed

mysqld process hanging, pid 18226 - killed

030604 11:15:13  mysqld restarted

bin/mysqld_safe: line 320: 18317 Segmentation fault      $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1

 

Number of processes running now: 9

mysqld process hanging, pid 18326 - killed

mysqld process hanging, pid 18325 - killed

mysqld process hanging, pid 18324 - killed

mysqld process hanging, pid 18323 - killed

mysqld process hanging, pid 18322 - killed

mysqld process hanging, pid 18321 - killed

mysqld process hanging, pid 18320 - killed

mysqld process hanging, pid 18319 - killed

mysqld process hanging, pid 18318 - killed

030604 11:15:14  mysqld restarted

bin/mysqld_safe: line 320: 18409 Segmentation fault      $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1

 

Number of processes running now: 9

mysqld process hanging, pid 18418 - killed

mysqld process hanging, pid 18417 - killed

mysqld process hanging, pid 18416 - killed

mysqld process hanging, pid 18415 - killed

mysqld process hanging, pid 18414 - killed

mysqld process hanging, pid 18413 - killed

mysqld process hanging, pid 18412 - killed

mysqld process hanging, pid 18411 - killed

mysqld process hanging, pid 18410 - killed

030604 11:15:15  mysqld restarted

bin/mysqld_safe: line 320: 18501 Segmentation fault      $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1

 

Number of processes running now: 9

mysqld process hanging, pid 18510 - killed

mysqld process hanging, pid 18509 - killed

mysqld process hanging, pid 18508 - killed

mysqld process hanging, pid 18507 - killed

mysqld process hanging, pid 18506 - killed

mysqld process hanging, pid 18505 - killed

mysqld process hanging, pid 18504 - killed

mysqld process hanging, pid 18503 - killed

mysqld process hanging, pid 18502 - killed

030604 11:15:16  mysqld restarted

030604 11:15:16  mysqld ended

How to repeat:
Install binary release 4.0.13 by untarring files into /usr/local/mysql, then install usual way (scripts/mysql_installdb) and copying support-file/my-medium.cnf to /etc/my.cnf.
cd to /usr/local/mysql
run: bin/mysqld_safe

You need to provide some more details for us to be able to reproduce this. 
Which Linux distribution is that? What version of glibc is installed?

Linux distro is Gentoo, with glibc 2.3.1-r4
PII 350Mhz with 192 Mb RAM.
Need anything else, just say ;)

Thanks for the feedback. Unfortunately we don't have a Gentoo Linux system available to reproduce this. 
I understand you have been using our official Linux binary. 
There should be a backtrace in /usr/local/mysql/data/<hostname>.err 
Could you please try to decode it as documented in 
http://www.mysql.com/doc/en/Using_stack_trace.html ? This should give us a hint where exactly it 
fails. Thanks in advance!

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".