MySQL Bugs: #30246: mysql command line clients segmentation fault upon reading /var/lib/mysql/mysql.

Bug #30246	mysql command line clients segmentation fault upon reading /var/lib/mysql/mysql.
Submitted:	6 Aug 2007 0:29	Modified:	7 Sep 2007 0:46
Reporter:	Matisse Enzer	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S2 (Serious)
Version:	5.0.27	OS:	Linux (Redhat Fedora Core 6 2.6.20-1.2962.fc6)
Assigned to:		CPU Architecture:	Any

Description:
Command line clients mysql, mysqladmin, an mysqldump (maybe others too) commands exit with a segmentation fault as soon as they read /var/lib/mysql/mysql.sock

This is on Fedora Core 6:
Linux galadriel 2.6.20-1.2962.fc6 #1 SMP Tue Jun 19 18:50:05 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux

MySQL 5.0.27 was installed using yum:
Name   : mysql
Arch   : x86_64
Version: 5.0.27
Release: 1.fc6

# mysql --version 
mysql  Ver 14.12 Distrib 5.0.27, for redhat-linux-gnu (x86_64) using readline 5.0

Here are  strace   output examples for "mysqladmin" and "mysql"

# strace mysqladmin ping
.
.
.
connect(3, {sa_family=AF_FILE, path="/var/lib/mysql/mysql.sock"}, 110) = 0
fcntl(3, F_SETFL, O_RDWR)               = 0
--- SIGSEGV (Segmentation fault) @ 0 (0) ---
+++ killed by SIGSEGV +++
Process 6956 detached

# strace mysql
.
.
.
connect(3, {sa_family=AF_FILE, path="/var/lib/mysql/mysql.sock"}, 110) = 0
--- SIGSEGV (Segmentation fault) @ 0 (0) ---
+++ killed by SIGSEGV +++
Process 7016 detached

How to repeat:
# yum install mysql
# service mysqld start
# mysqladmin ping

Thank you for the report.

But version 5.0.27 is quite old. Please upgrade to current version 5.0.45, try with it and if you can repeat described behaviour provide output of `ls -la /var/lib/mysql/mysql.sock`

As far as I can tell 5.0.27 is the latest version available for update through Red Hat - I will see if I can find out when 5.0.45 will be available through the redhat update system.

You can download RedHat binaries from our download page at http://dev.mysql.com/downloads/mysql/5.0.html

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".

Removing and reinstalling the 5.0.27 version via the redhat "yum" utility fixed the problem. Presumably the previous install was corrupted in some way.