This is not a bug report as such, it is an ADVISORY for anyone else who runs into this problem. The recommended secure method of running mydumper without exposing credentials on the command line is to run mydumper as root, reading its user and password from the [mydumper] tag in /root/.my.cnf, which should be mode 600. IF you are using mydumper as a backup tool in a RunBeforeJob script run from Bacula, when you upgrade from kernel 3.11 to kernel 3.12, this will stop working, because mydumper will stop reading credentials from the /root/.my.cnf file. There will be no obvious reason why this is suddenly failing. The non-obvious fix for this problem is to simply emerge -1 app-backup/bacula, then restart the Bacula director. Reproducible: Always Actual Results: Before recompiling Bacula: Mon Dec 16 15:22:20 EST 2013 - ========== Starting Database Dumps ========== Mon Dec 16 15:22:20 EST 2013 - Starting dump of epsilon3 using mydumper... ** (mydumper:6189): CRITICAL **: Error connecting to database: Access denied for user 'root'@'localhost' (using password: NO) Mon Dec 16 15:22:21 EST 2013 - ANOMALY: logstatus contains '** (mydumper:6189): CRITICAL **: Error connecting to database: Access denied for user 'root'@'localhost' (using password: NO)', logtime is 'Mon Dec 16 15:22:20 EST 2013'. Mon Dec 16 15:22:21 EST 2013 - Dump may have terminated abnormally. Please investigate. Mon Dec 16 15:22:21 EST 2013 - ========== Errors Encountered During Data Dump ========== After recompiling Bacula: Mon Dec 16 15:40:43 EST 2013 - ========== Starting Database Dumps ========== Mon Dec 16 15:40:43 EST 2013 - Starting dump of epsilon3 using mydumper... Mon Dec 16 15:46:11 EST 2013 - Dump Finished Mon Dec 16 15:46:11 EST 2013 - ========== All Databases Dumped Successfully ========== I also tried recompiling dev-db/mydumper, but that had no effect. Recompiling app-backup/bacula under kernel 3.12.x is both necessary and sufficient.
The non-obvious workaround (it's not a fix) makes no sense at all. Please investigate further and report back when you have found the actual bug. It looks a lot like bug #488492. To begin with, please post your `emerge --info' output in a comment.
(In reply to Jeroen Roovers from comment #1) > The non-obvious workaround (it's not a fix) makes no sense at all. Please > investigate further and report back when you have found the actual bug. It > looks a lot like bug #488492. To begin with, please post your `emerge > --info' output in a comment. #488492 does not look like the same issue at all. There was no build failure in any package at any point. Absolutely everything was normal except that one single backup job (the database backup) out of eight began consistently failing every day, but every individual part of the job succeeded when tested at the command line. It could only be induced to fail by letting Bacula run it as a scheduled job. Recompiling Bacula against the new kernel, with no other changes to anything, fixed the problem. I don't recall at this point what kernel version this bacula release was originally compiled under, but it was previously emerged on March 15. I've updated the kernel a lot of times since then, and glibc has updated as well, but the problem did not appear until I updated from kernel 3.11 to 3.12. Emerge info: Portage 2.2.7 (default/linux/amd64/13.0, gcc-4.8.2, glibc-2.16.0, 3.12.4-gentoo-epsilon3 x86_64) ================================================================= System uname: Linux-3.12.4-gentoo-epsilon3-x86_64-Quad-Core_AMD_Opteron-tm-_Processor_2354-with-gentoo-2.2 KiB Mem: 32904092 total, 848268 free KiB Swap: 0 total, 0 free Timestamp of tree: Wed, 18 Dec 2013 07:00:01 +0000 ld GNU ld (GNU Binutils) 2.23.1 ccache version 3.1.9 [disabled] app-shells/bash: 4.2_p45 dev-java/java-config: 2.1.12-r1 dev-lang/python: 2.7.5-r3, 3.2.5-r3, 3.3.2-r2 dev-util/ccache: 3.1.9 dev-util/cmake: 2.8.11.2 dev-util/pkgconfig: 0.28 sys-apps/baselayout: 2.2 sys-apps/openrc: 0.12.4 sys-apps/sandbox: 2.6-r1 sys-devel/autoconf: 2.13, 2.69 sys-devel/automake: 1.11.6, 1.12.6, 1.13.4 sys-devel/binutils: 2.23.1 sys-devel/gcc: 4.5.3-r2, 4.6.3, 4.7.3-r1, 4.8.2 sys-devel/gcc-config: 1.7.3 sys-devel/libtool: 2.4.2 sys-devel/make: 3.82-r4 sys-kernel/linux-headers: 3.9 (virtual/os-headers) sys-libs/glibc: 2.16.0 Repositories: gentoo mysql perl-experimental mozilla x11 overlay-dev-alaric ACCEPT_KEYWORDS="amd64" ACCEPT_LICENSE="*" CBUILD="x86_64-pc-linux-gnu" CFLAGS="-march=barcelona -O2 -pipe -mfpmath=sse -mcx16 -mpopcnt" CHOST="x86_64-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/share/gnupg/qualified.txt /var/bind /var/lib/hsqldb" CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo" CXXFLAGS="-march=barcelona -O2 -pipe -mfpmath=sse -mcx16 -mpopcnt" DISTDIR="/usr/portage/distfiles" FCFLAGS="-O2 -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 -pipe" GENTOO_MIRRORS="http://mirror.mcs.anl.gov/pub/gentoo ftp://mirror.iawnet.sandia.gov/pub/gentoo http://gentoo.cites.uiuc.edu/pub/gentoo http://gentoo.chem.wisc.edu/gentoo http://gentoo.osuosl.org http://www.gtlib.gatech.edu/pub/gentoo ftp://mirrors.rit.edu/gentoo http://mirrors.cs.wmich.edu/gentoo " LANG="en_US.UTF-8" LDFLAGS="-Wl,-O1 -Wl,--as-needed" MAKEOPTS="-j16" 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="/var/lib/layman/mysql /var/lib/layman/perl-experimental /var/lib/layman/mozilla /var/lib/layman/x11 /var/lib/alaric" SYNC="rsync://rsync.gentoo.org/gentoo-portage" USE="3dnow 3dnowext acl amd64 bash-completion berkdb bzip2 cli cracklib crypt cxx dri fortran gdbm iconv imagemagick ipv6 java jpeg2k mmx mmxext modules mudflap multilib mysql ncurses nls nptl openmp pam pcre readline session sse sse2 ssl tcpd threads tk tools unicode utils x264 xpm zlib" ABI_X86="64" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" APACHE2_MODULES="authn_core authz_core socache_shmcb unixd 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" 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="evdev keyboard mouse" KERNEL="linux" LIBREOFFICE_EXTENSIONS="presenter-console presenter-minimizer" LINGUAS="en" OFFICE_IMPLEMENTATION="libreoffice" PHP_TARGETS="php5-5" PYTHON_SINGLE_TARGET="python2_7" PYTHON_TARGETS="python2_7 python3_3" RUBY_TARGETS="ruby19 ruby18" USERLAND="GNU" VIDEO_CARDS="ast modesetting" 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, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, USE_PYTHON
(In reply to Jeroen Roovers from comment #1) > The non-obvious workaround (it's not a fix) Oh, and yes, you're correct, 'workaround' is a much better word than 'fix'. I don't know what the deep underlying problem actually is, but at this point I have no way to reconstruct the exact environment app-backup/bacula-5.2.13 was originally compiled under, so we may never know.
