Bugzilla Bug 166606

When using baselayout 1.13.0_alpha12, the init script that comes with
mysql-init-scripts doesn't work.
It starts the daemon, but throws an error about not being able to find the pid
file.

I think this is a start-stop-daemon bug.

Reproducible: Always

Steps to Reproduce:
1. emerge =sys-apps/baselayout-1.13.0_alpha12
2. update config files and reboot (just to make sure)
2. emerge mysql
3. /etc/init.d/mysql start

Actual Results:  
Throws an error, even though the daemon is started

Expected Results:  
It should behave as it does with baselayout 1.12

Portage 2.1.2-r9 (default-linux/x86/2006.1/server, gcc-4.1.1, glibc-2.5-r0,
2.6.20-gentoo i686)
=================================================================
System uname: 2.6.20-gentoo i686 Pentium II (Deschutes)
Gentoo Base System release 1.13.0_alpha12
Timestamp of tree: Mon, 12 Feb 2007 22:50:01 +0000
dev-lang/python:     2.4.4
dev-python/pycrypto: 2.0.1-r5
sys-apps/sandbox:    1.2.18.1
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.17
sys-devel/gcc-config: 1.3.14
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.20
ACCEPT_KEYWORDS="x86 ~x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-march=pentium2 -mmmx -O3 -pipe -fomit-frame-pointer -funit-at-a-time"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /var/bind"
CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/revdep-rebuild /etc/terminfo"
CXXFLAGS="-march=pentium2 -mmmx -O3 -pipe -fomit-frame-pointer
-funit-at-a-time"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig cvs distlocks metadata-transfer sandbox sfperms strict"
GENTOO_MIRRORS="http://distfiles.gentoo.org/"
LC_ALL="en_DK.UTF-8"
MAKEOPTS="-j2 -s"
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"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage"
SYNC="rsync://rsync.gurlinet.dk/gentoo-portage"
USE="acl acpi apache2 berkdb bzip2 cgi chroot cli cracklib crypt dhcp fam
fastbuild force-cgi-redirect gd hardened iconv innodb ipv6 kerberos md5sum
memlimit mmx mng mysql ncurses nls nptl nptlonly openssl opensslcrypt pam pcre
perl php pic posix pppd python radius readline samba session simplexml slp soap
sockets spl ssl subversion symlink sysfs syslog tcpd threads tokenizer unicode
userlocales vhosts x86 xml xsl xslt zlib" ALSA_CARDS="ali5451 als4000 atiixp
atiixp-modem bt87x ca0106 cmipci emu10k1 emu10k1x ens1370 ens1371 es1938 es1968
fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx
via82xx-modem ymfpci" 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 evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780
lb216 lcdm001 mtxorb ncurses text" USERLAND="GNU" VIDEO_CARDS="apm ark ati
chips cirrus cyrix dummy fbdev glint i128 i740 i810 imstt mga neomagic nsc nv
rendition s3 s3virge savage siliconmotion sis sisusb tdfx tga trident tseng v4l
vesa vga via vmware voodoo"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LDFLAGS, LINGUAS,
PORTAGE_RSYNC_EXTRA_OPTS

Revert changes to fix bug #158769
sed -e 's|#see bug #158769||' -i /etc/init.d/mysql

worksforme, a better fix should be provided though, I'm available to consulting
for everyone interested in fix/rewrite the mysql-init-scripts package, just
email or query me on irc

(In reply to comment #1)
> Revert changes to fix bug #158769
> sed -e 's|#see bug #158769||' -i /etc/init.d/mysql
> worksforme, a better fix should be provided though, I'm available to consulting
> for everyone interested in fix/rewrite the mysql-init-scripts package, just
> email or query me on irc

That doesn't fix it here, tried it, and the output is still the same :-(

workarounded in "=dev-db/mysql-init-scripts-1.2",
there is a race condition in the code, still not catched.

wondering if http://bugs.mysql.com/bug.php?id=21884 is related to this

Removing "--pidfile ${pidfile}" from the end of line 283 of /etc/init.d/mysql
fixes the problem for me. The start-stop-daemon seems to be creating the pid
file, which mysql then overwrites with it's own pid file, and somewhere in
there... I don't know, a race condition maybe... that results in the server
being up, but the init script thinking it failed. Hard to pinpoint, as it only
happens on boot, not regular start/stop, and I've got a headless server.

As a side-note, I think the "DEBUG" setting in conf.d/mysql should actually
result in debug info going into the logs, not just the console, for exactly
this sort of case.

Packages:
dev-db/mysql-5.0.38  
dev-db/mysql-init-scripts-1.2  
sys-apps/baselayout-1.13.0_alpha12

what's the status here? still doesn't work with baselayout-2.. mysql starts,
but output is still borked:

 * Starting  ...
 * Starting  (/etc/mysql/my.cnf)  [ ok ]
.....
 * Stopping  ...
 * Stopping mysqld (0)            [ ok ]


Since the mysql init script is such a fcking mess i won't touch it, so please
fix it asap...

(In reply to comment #6)
> what's the status here? still doesn't work with baselayout-2.. mysql starts,
> but output is still borked:

baselayout-2 is package.masked, for starters (presumably for a reason).

If someone would create some transition documentation for ebuild maintainers
(as baselayout/s-s-d updates keep breaking initscripts over and over again),
life would be much easier.

Problem still persists with a brand-new mysql installation on a vserver guest

maseltov ~ # vemerge abdullah -- -pv baselayout mysql

These are the packages that would be merged, in order:

Calculating dependencies... done!
[ebuild   R   ] sys-apps/baselayout-1.13.0_alpha12  USE="pam unicode -bootstrap
-build -static" 226 kB
[ebuild   R   ] dev-db/mysql-5.0.42  USE="berkdb perl ssl -big-tables -cluster
-debug -embedded -extraengine -latin1 -max-idx-128 -minimal (-selinux) -static"
0 kB

Solution from Xepher (comment #5) worked for me, too.
Best, Simon

This is where working init scripts are

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