Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!

Bug 178088

Summary: dev-db/mysql-5.0.38 - init script reports failure on boot but the daemon is still started
Product: Gentoo Linux Reporter: Sergej Pisarenko <drseergio>
Component: Current packagesAssignee: Gentoo Linux MySQL bugs team <mysql-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal    
Priority: High    
Version: unspecified   
Hardware: x86   
OS: Linux   
Whiteboard:
Package list:
Runtime testing required: ---

Description Sergej Pisarenko 2007-05-11 18:56:10 UTC
I am suffering from MySQL which does not start when its added by rc-update. During the boot an error message appears saying "MySQL NOT started (0)" but the actual mysqld daemon is started and .pid, .sock files are created. If I comment out following lines from /etc/init.d/mysql everything seems to be ok:

Code:

                if [[ ! -S "${socket}" ]] ; then
                       eerror "MySQL${MY_SUFFIX} NOT started (${retstatus})"
                       retstatus=1
                else


so the check is not evaluated at all. What is also strange is that if I try to launch MySQL manually after the boot it did NOT experience this problem EVER, no matter how many times I tried. I also know that this issue did not appear after a bunch of upgrades and installation of apache, tomcat and all related stuff but I am not sure that this is relevant.

It might be a problem with the init script as it checks for .sock file which seems not to be present at that moment of time.

MySQL version:
dev-db/mysql-5.0.38, compiled with these flags: berkdb perl ssl.

Reproducible: Sometimes

Steps to Reproduce:
1. add mysql startup script to any level
2. restart
3. error message is displayed

Actual Results:  
The error message is displayed and the state of mysql script says that it is not started, however, mysqld is actually running.

Expected Results:  
The mysql should have started normally without any problems.
Comment 1 Jakub Moc (RETIRED) gentoo-dev 2007-05-11 19:34:53 UTC
emerge --info please.
Comment 2 Sergej Pisarenko 2007-05-11 19:38:48 UTC
Portage 2.1.2.2 (default-linux/x86/2006.1/desktop, gcc-4.1.1, glibc-2.5-r2, 2.6.20-gentoo-r8 i686)
=================================================================
System uname: 2.6.20-gentoo-r8 i686 Genuine Intel(R) CPU           T2300  @ 1.66GHz
Gentoo Base System release 1.12.9
Timestamp of tree: Fri, 11 May 2007 13:20:01 +0000
distcc 2.18.3 i686-pc-linux-gnu (protocols 1 and 2) (default port 3632) [disabled]
ccache version 2.4 [disabled]
dev-java/java-config: 1.3.7, 2.0.31-r5
dev-lang/python:     2.4.4
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     2.4-r7
sys-apps/sandbox:    1.2.17
sys-devel/autoconf:  2.13, 2.61
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10
sys-devel/binutils:  2.16.1-r3
sys-devel/gcc-config: 1.3.16
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.17-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O2 -march=prescott -pipe -msse3 -mfpmath=sse -fomit-frame-pointer"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config"
CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/gconf /etc/java-config/vms/ /etc/php/apache1-php5/ext-active/ /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/terminfo /etc/texmf/web2c"
CXXFLAGS="-O2 -march=prescott -pipe -msse3 -mfpmath=sse -fomit-frame-pointer"
DISTDIR="/usr/portage/distfiles"
FEATURES="distlocks metadata-transfer sandbox sfperms strict"
GENTOO_MIRRORS=" http://ds.thn.htu.se/linux/gentoo http://mirror.gentoo.no http://mirror.switch.ch/ftp/mirror/gentoo"
LANG="en_US.UTF-8"
LINGUAS="ru en en_US en_GB se lv"
MAKEOPTS="-j3"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages --filter=H_**/files/digest-*"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/portage/local/layman/voip /usr/portage/local/layman/xeffects"
SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage"
USE="X a52 aac aalib acpi aiglx alsa amr apache2 avahi berkdb bitmap-fonts bluetooth bzip2 cairo cdparanoia cdr cli cracklib crypt cups db2 dbus dri dts dvd dvdr dvdread emboss encode fam ffmpeg firefox flac fortran ftp fuse gd-external gdbm gif gpm gstreamer hal hdaps iconv imagemagick isdnlog java java5 javascript jpeg kde latex lcms ldap libcaca libg++ lirc lua lzo mad matroska midi mikmod mime mmx mng mono mp3 mpeg musepack musicbrainz mysql mysqli ncurses nls nptl nptlonly nsplugin ogg openal opengl oss pcmcia pcre pdf perl php png portaudio ppds pppd python qt3 qt4 quicktime readline reflection ruby samba sdl session slp speex spell spl sse sse2 ssl svg tcl tcpd theora thinkpad tidy tiff timidity truetype truetype-fonts type1-fonts unicode usb v4l2 vcd vhosts vorbis wifi win32codecs wmf x86 xine xinerama xml xorg xpm xscreensaver xv xvid xvmc zeroconf zlib" ALSA_CARDS="hda-intel" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mulaw multi null plug rate route share shm softvol" ELIBC="glibc" INPUT_DEVICES="keyboard mouse joystick synaptics evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="ru en en_US en_GB se lv" LIRC_DEVICES="sir" USERLAND="GNU" VIDEO_CARDS="fglrx"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LC_ALL, LDFLAGS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Comment 3 Sergej Pisarenko 2007-05-11 20:43:08 UTC
Bugs that seem to related:

173057 http://bugs.gentoo.org/show_bug.cgi?id=173057 mysql & apache
176643 http://bugs.gentoo.org/show_bug.cgi?id=176643 mysql & ldap
166606 http://bugs.gentoo.org/show_bug.cgi?id=166606 mysql & baselayout

Symptoms look similar.
Comment 4 Sergej Pisarenko 2007-05-12 10:17:50 UTC
Added additional information
Comment 5 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2007-05-12 23:19:39 UTC
upgrade to 5.0.40


*** This bug has been marked as a duplicate of bug 177128 ***