Bug 520164 – dev-db/mysql-5.6.20 fails to start with old default config

• Product: Gentoo Linux
• Status: RESOLVED DUPLICATE

[Description Patrick Lauer 2014-08-18 06:15:27 UTC]

1407231649:  === (13 of 14) Post-Build Cleaning (dev-db/mysql-5.6.20::/usr/portage/dev-db/mysql/mysql-5.6.20.ebuild)
1407231649:  ::: completed emerge (13 of 14) dev-db/mysql-5.6.20 to /


# /etc/init.d/mysql start --debug

+ ebegin 'Starting mysql'
 * Starting mysql ...
+ MY_CNF=/etc/mysql/my.cnf
+ '[' '!' -r /etc/mysql/my.cnf ']'
++ get_config /etc/mysql/my.cnf basedir
++ tail -n1
++ my_print_defaults --config-file=/etc/mysql/my.cnf mysqld
++ sed -n -e 's/^--basedir=//p'
+ local basedir=/usr
++ get_config /etc/mysql/my.cnf datadir
++ tail -n1
++ my_print_defaults --config-file=/etc/mysql/my.cnf mysqld
++ sed -n -e 's/^--datadir=//p'
+ local datadir=/var/lib/mysql
++ get_config /etc/mysql/my.cnf pid-file
++ tail -n1
++ my_print_defaults --config-file=/etc/mysql/my.cnf mysqld
++ sed -n -e 's/^--pid-file=//p'
+ local pidfile=/var/run/mysqld/mysqld.pid
++ get_config /etc/mysql/my.cnf socket
++ tail -n1
++ my_print_defaults --config-file=/etc/mysql/my.cnf mysqld
++ sed -n -e 's/^--socket=//p'
+ local socket=/var/run/mysqld/mysqld.sock
+ '[' '!' -d /var/lib/mysql ']'
+ '[' '!' -d /var/lib/mysql/mysql ']'
+ local piddir=/var/run/mysqld
+ checkpath -d --owner mysql:mysql --mode 0755 /var/run/mysqld
+ rc=0
+ '[' 0 -ne 0 ']'
+ local startup_timeout=900
+ local startup_early_timeout=1000
+ local tmpnice=
+ local tmpionice=
+ start-stop-daemon --start --exec /usr/sbin/mysqld --pidfile /var/run/mysqld/mysqld.pid --background --wait 1000 -- --defaults-file=/etc/mysql/my.cnf
+ local ret=0
+ '[' 0 -ne 0 ']'
+ ewaitfile 900 /var/run/mysqld/mysqld.sock
^C * mysql: caught SIGINT, aborting


at this point it hangs "indefinitely", logfiles show no obvious errors.


Portage 2.2.12 (python 2.7.8-final-0, default/linux/x86/13.0, gcc-4.7.3, glibc-2.19-r1, 3.16.1-gentoo i686)
=================================================================
System uname: Linux-3.16.1-gentoo-i686-Intel-R-_Pentium-R-_4_CPU_2.60GHz-with-gentoo-2.2
KiB Mem:     1028568 total,    854548 free
KiB Swap:    2097144 total,   2097144 free
Timestamp of tree: Mon, 18 Aug 2014 00:45:01 +0000
ld GNU ld (GNU Binutils) 2.24
app-shells/bash:          4.2_p47
dev-lang/python:          2.7.8, 3.2.5-r1, 3.3.5-r1, 3.4.1
dev-util/cmake:           2.8.12.2-r1
dev-util/pkgconfig:       0.28-r2
sys-apps/baselayout:      2.2
sys-apps/openrc:          0.13
sys-apps/sandbox:         2.6-r1
sys-devel/autoconf:       2.69
sys-devel/automake:       1.11.6, 1.12.6, 1.13.4, 1.14.1
sys-devel/binutils:       2.24-r3
sys-devel/gcc:            4.6.3, 4.7.3-r1, 4.8.3
sys-devel/gcc-config:     1.8
sys-devel/libtool:        2.4.2-r1
sys-devel/make:           4.0-r1
sys-kernel/linux-headers: 3.16 (virtual/os-headers)
sys-libs/glibc:           2.19-r1
Repositories: gentoo x-overlay
ACCEPT_KEYWORDS="x86 ~x86"
ACCEPT_LICENSE="* -@EULA"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O2 -march=i686 -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /var/spool/munin-async/.ssh"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/php/apache2-php5.3/ext-active/ /etc/php/cgi-php5.3/ext-active/ /etc/php/cli-php5.3/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo"
CXXFLAGS="-O2 -march=i686 -pipe"
DISTDIR="/usr/portage/distfiles"
FCFLAGS="-O2 -march=i686 -pipe"
FEATURES="assume-digests binpkg-logs config-protect-if-modified distlocks ebuild-locks fixlafiles merge-sync news parallel-fetch preserve-libs protect-owned sandbox sfperms strict unknown-features-warn unmerge-logs unmerge-orphans userfetch userpriv usersandbox usersync"
FFLAGS="-O2 -march=i686 -pipe"
GENTOO_MIRRORS="http://distfiles.gentoo.org"
LANG="en_US.utf8"
LDFLAGS="-Wl,-O1 -Wl,--as-needed"
PKGDIR="/usr/portage/packages"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --omit-dir-times --compress --force --whole-file --delete --stats --human-readable --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/root/overlay"
USE="acl apache2 berkdb bzip2 cli cracklib crypt cxx dri fortran fpm gd gdbm iconv ldap ldb modules mysql mysqli nagios-ping ncurses nls nptl openmp pam pcre plugins python readline session ssl tcpd unicode x86 zlib" ABI_X86="32" 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" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache cgi cgid dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias auth_digest authn_db" CALLIGRA_FEATURES="kexi words flow plan sheets stage tables krita karbon braindump author" CAMERAS="ptp2" COLLECTD_PLUGINS="df interface irq load memory rrdtool swap syslog" ELIBC="glibc" GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock itrax mtk3301 nmea ntrip navcom oceanserver oldstyle oncore rtcm104v2 rtcm104v3 sirf superstar2 timing tsip tripmate tnt ublox ubx" INPUT_DEVICES="keyboard mouse evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LIBREOFFICE_EXTENSIONS="presenter-console presenter-minimizer" NGINX_MODULES_HTTP="access auth_basic autoindex browser charset empty_gif fastcgi geo gzip limit_conn limit_req map memcached proxy referer rewrite scgi split_clients ssi upstream_ip_hash userid uwsgi fancyindex" OFFICE_IMPLEMENTATION="libreoffice" PHP_TARGETS="5.3" PYTHON_SINGLE_TARGET="python2_7" PYTHON_TARGETS="python2_7 python3_3" RUBY_TARGETS="ruby19 ruby20" USERLAND="GNU" VIDEO_CARDS="fbdev glint intel mach64 mga nouveau nv r128 radeon savage sis tdfx trident vesa via vmware dummy v4l" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip fuzzy condition tee tarpit sysrq steal rawnat logmark ipmark dhcpmac delude chaos account"
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LC_ALL, MAKEOPTS, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, SYNC, USE_PYTHON

[Comment 1 Patrick Lauer 2014-08-18 06:20:19 UTC]

# /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf
2014-08-18 14:17:30 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2014-08-18 14:17:30 0 [Warning] The syntax '--language/-l' is deprecated and will be removed in a future release. Please use '--lc-messages-dir' instead.
2014-08-18 14:17:30 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-08-18 14:17:30 2997 [Warning] Using pre 5.5 semantics to load error messages from /usr/share/mysql/english/.
2014-08-18 14:17:30 2997 [Warning] If this is not intended, refer to the documentation for valid usage of --lc-messages-dir and --language parameters.



... oh, just found this gem in the mysqld.err:


 
2014-08-18 14:17:30 2997 [ERROR] /usr/sbin/mysqld: unknown variable 'table_cache=64'
2014-08-18 14:17:30 2997 [ERROR] Aborting


So it quietly kills itself! And OpenRC keeps waiting for it a looooong time, so the init script looks like it hangs.

[Comment 2 Brian Evans (RETIRED) 2014-08-18 13:54:35 UTC]

The config variable change was reported and fixed 2.5 years ago with bug 403425.
This originated with MySQL 5.1.3 but was not updated until the bug report.

Upstream regularly changes variable names and we try to keep pace in our default my.cnf.
I cannot help when config updates are simply zapped away.

There should also have been deprecation warnings in the /var/log/mysql/mysqld.err

It is part of the admin's job to read release notes and deprecation warnings each upgrade.

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