Bugzilla will be upgraded to version 5.0 on a still to be determined date in the near future. The original upgrade date has been delayed.
Bug 58732 - /etc/init.d/mysqld doesn't wait for server to start
/etc/init.d/mysqld doesn't wait for server to start
Product: Red Hat Linux
Classification: Retired
Component: mysql (Show other bugs)
All Linux
medium Severity medium
: ---
: ---
Assigned To: Kim Ho
David Lawrence
: 106833 (view as bug list)
Depends On:
  Show dependency treegraph
Reported: 2002-01-23 16:04 EST by aaron brick
Modified: 2007-04-18 12:39 EDT (History)
1 user (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2003-10-27 15:32:04 EST
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

External Trackers
Tracker ID Priority Status Summary Last Updated
Red Hat Product Errata RHSA-2004:569 normal SHIPPED_LIVE Low: mysql security update 2004-10-20 00:00:00 EDT

  None (edit)
Description aaron brick 2002-01-23 16:04:54 EST
From Bugzilla Helper:
User-Agent: Mozilla/5.0 Galeon/1.0.2 (X11; Linux i686; U;) Gecko/20011224

Description of problem:
one can run /etc/init.d/mysqld start and since it backgrounds the safe_mysqld
process and doesn't do any mysqladmin pinging, the server isn't guaranteed to
have started. this causes problems if steps soon after the server (re)start
depend upon it.

Version-Release number of selected component (if applicable):

How reproducible:

Steps to Reproduce:
1. run /etc/init.d/mysqld restart
2. try to make a mysql query right away

Actual Results:  the client failed to find the socket by which to communicate
with the server.

Expected Results:  step (1) should have waited for the server to come online
before returning. then (2) would succeed.

Additional info:

the debian start script (/etc/init.d/mysql in the mysql-server package) does
this rationally, by mysqladmin pinging a number of times until the server comes
online or dying after a timeout.
Comment 1 Trond Eivind Glomsrxd 2002-02-08 16:16:31 EST
Seems like a good enhancement.
Comment 2 Patrick Macdonald 2003-08-12 13:33:18 EDT
Kim, can you handle this please.  Have the script loop five times with a 1
second hold. Break out of the loop if the mysqladmin ping succeeds, bail otherwise.
Comment 3 Patrick Macdonald 2003-10-14 10:39:04 EDT
*** Bug 106833 has been marked as a duplicate of this bug. ***
Comment 4 Patrick Macdonald 2003-10-27 15:32:04 EST
Fixed in rawhide.  We chose to wait for a max of tens seconds, pinging every
Comment 5 Josh Bressers 2004-10-20 15:41:22 EDT
An errata has been issued which should help the problem 
described in this bug report. This report is therefore being 
closed with a resolution of ERRATA. For more information
on the solution and/or where to find the updated files, 
please follow the link below. You may reopen this bug report 
if the solution does not work for you.


Note You need to log in before you can comment on or make changes to this bug.