Red Hat Bugzilla – Bug 75404
mysqld (compiled from source) experiences intermittent crashes.
Last modified: 2007-04-18 12:47:19 EDT
From Bugzilla Helper:
User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)
Description of problem:
The MySQL server 'mysqld' experiences intermittent crashes and hangups.
Following much difficulty (see below) getting the server running in the first
place, now whenever I try to connect and/or execute a query (from the command
line or manually within the mysql client), I lose the connection and
mysqld "restarts". The server remains 'active' for a maximum of about 15-20
seconds (barely time to type a query), before restarting again. This problem is
present using mysql versions 3.23.51 and 3.23.52 compiled from source, as well
as using the 3.23.52-3 SRPM.
This generally happens only when trying to perform a "write" query (e.g.
update, insert, create, etc) - however there is nothing wrong with the
permissions - they've been checked. It also happens, on occasion, with select
or connect queries as well.
Additionally, when compiling MySQL from the source distribution,
using ./configure with "--localstatedir=/server/local/mysql/", mysqld compiles
with the value "/ser/" (as can be seen using the "mysqld --help" command and
looking for the "datadir" variable).
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Compile and install mysql (on RedHat8.0) using the standard source
instructions that come with the mysql distribution.
2. Verify that the "datadir" value is correct, as set using the --localstatedir
option at configure time.
3. Start the mysql daemon (using safe_mysqld).
4. Start the mysql client, and execute a number of queries.
Actual Results: Intermittently, the mysql client will display an error "Lost
connection to MySQL server during query". Additionally, the following is
printed on STDERR and in the log file:
Number of processes running now: 0
021008 13:17:22 mysqld restarted
Expected Results: At this point, mysqld should have performed the query.
I'm almost sure this is not a bug with mysql, as I've had this version of mysql
working on RedHat 7.2, using exactly these steps. My initial guess is that it's
something to do with one of the components that mysql uses, that's changed in
RH8 (such as, e.g. glibc or something).
Are you testing the server from a different machine? Probably a duplicate of bug
77467 if so.
I've tried this using the latest glibc/kernel and can not reproduce. Can
you please upgrade and see if it still fails.
Using the 3.23.54a-11 version of MySQL with the latest glibc and kernel
Also, Joe asks an important question: Are you attempting remote connections?
If so, there was a problem with MySQL + glibc.
Moving this to NEEDINFO.