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 ***
