Created attachment 554804 [details] build.log.xz As with bug #670816 I'm just trying to eliminate false-failures that otherwise make perl regression testing complicated to automate. FEATURES="-usersandbox" is set for this test as suggested. ---- rpl.rpl_semi_sync_shutdown_hang 'mix' w1 [ fail ] Test ended at 2018-11-10 21:27:17 CURRENT_TEST: rpl.rpl_semi_sync_shutdown_hang mysqltest: At line 48: command "$MYSQLADMIN -uroot -S $MASTER_MYSOCK -P $MASTER_MYPORT shutdown 2>&1" failed Output from before failure: exec of '/var/tmp/portage/dev-db/mysql-5.6.40-r2/work/mysql-5.6.40_build/client//mysqladmin -uroot -S /var/tmp/portage/dev-db/mysql-5.6.40-r2/temp/var-tests/tmp/1/mysqld.1.sock -P 10710 shutdown 2>&1' failed, error: 256, status: 1, errno: 0 The result from queries just before the failure was: include/master-slave.inc Warnings: Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. [connection master] include/install_semisync.inc call mtr.add_suppression("Read semi-sync reply network error"); call mtr.add_suppression("SEMISYNC: Forced shutdown. Some updates might not be replicated."); [connection master] SET GLOBAL rpl_semi_sync_master_timeout = 10000000; [connection slave] include/stop_slave_io.inc [connection master] CREATE TABLE t(f INT) ENGINE=INNODB;; [connection master1] - the logfile can be found in '/var/tmp/portage/dev-db/mysql-5.6.40-r2/temp/var-tests/log/rpl.rpl_semi_sync_shutdown_hang-mix/rpl_semi_sync_shutdown_hang.log' ----- Portage 2.3.40 (python 2.7.15-final-0, default/linux/amd64/17.1/no-multilib, gcc-8.2.0, glibc-2.27-r6, 4.9.6-gentoo-r1 x86_64) ================================================================= System Settings ================================================================= System uname: Linux-4.9.6-gentoo-r1-x86_64-Intel-R-_Core-TM-2_Duo_CPU_E6750_@_2.66GHz-with-gentoo-2.4.1 KiB Mem: 2042732 total, 153140 free KiB Swap: 18588764 total, 18556920 free Head commit of repository gentoo: c7440022b6226bc29679d55522e522bb2b64be20 sh bash 4.4_p12 ld GNU ld (Gentoo 2.30 p5) 2.30.0 ccache version 3.3.4 [enabled] app-shells/bash: 4.4_p12::gentoo dev-lang/perl: 5.28.0::gentoo dev-lang/python: 2.7.15::gentoo, 3.6.5::gentoo dev-util/ccache: 3.3.4-r1::gentoo dev-util/cmake: 3.9.6::gentoo sys-apps/baselayout: 2.4.1-r2::gentoo sys-apps/openrc: 0.38.3::gentoo sys-apps/sandbox: 2.13::gentoo sys-devel/autoconf: 2.69-r4::gentoo sys-devel/automake: 1.15.1-r2::gentoo sys-devel/binutils: 2.30-r4::gentoo sys-devel/gcc: 8.2.0-r4::gentoo sys-devel/gcc-config: 1.8-r1::gentoo sys-devel/libtool: 2.4.6-r3::gentoo sys-devel/make: 4.2.1-r4::gentoo sys-kernel/linux-headers: 4.13::gentoo (virtual/os-headers) sys-libs/glibc: 2.27-r6::gentoo Repositories: gentoo location: /usr/portage sync-type: git sync-uri: https://github.com/gentoo/gentoo.git priority: -1000 ACCEPT_KEYWORDS="amd64" ACCEPT_LICENSE="* -@EULA" CBUILD="x86_64-pc-linux-gnu" CFLAGS="-march=native -mtune=native -O2 -pipe" CHOST="x86_64-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/share/gnupg/qualified.txt" CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/gconf /etc/gentoo-release /etc/sandbox.d /etc/terminfo" CXXFLAGS="-march=native -mtune=native -O2 -pipe" DISTDIR="/usr/portage/distfiles" EMERGE_DEFAULT_OPTS="--quiet-build y --jobs 3 --autounmask=n" ENV_UNSET="DBUS_SESSION_BUS_ADDRESS DISPLAY PERL5LIB PERL5OPT PERLPREFIX PERL_CORE PERL_MB_OPT PERL_MM_OPT XAUTHORITY XDG_CACHE_HOME XDG_CONFIG_HOME XDG_DATA_HOME XDG_RUNTIME_DIR" FCFLAGS="-O2 -pipe" FEATURES="assume-digests binpkg-logs binpkg-multi-instance ccache clean-logs config-protect-if-modified distlocks ebuild-locks fixlafiles merge-sync multilib-strict news parallel-fetch preserve-libs protect-owned sandbox sfperms split-elog split-log strict test unknown-features-warn unmerge-logs unmerge-orphans userfetch userpriv usersandbox usersync xattr" FFLAGS="-O2 -pipe" GENTOO_MIRRORS="http://127.0.0.1/ http://distfiles.gentoo.org" LANG="en_NZ.UTF-8" LDFLAGS="-Wl,-O1 -Wl,--as-needed" MAKEOPTS="-j3" 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 --exclude=/.git" PORTAGE_TMPDIR="/var/tmp" USE="acl amd64 berkdb bzip2 cli crypt cxx dri fortran gdbm iconv ipv6 libtirpc minimal ncurses nls nptl openmp pam pcre perl readline seccomp ssl tcpd unicode xattr 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="karbon plan sheets stage words" COLLECTD_PLUGINS="df interface irq load memory rrdtool swap syslog" CPU_FLAGS_X86="mmx mmxext sse sse2 sse3 ssse3" ELIBC="glibc" GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock isync itrax mtk3301 nmea ntrip navcom oceanserver oldstyle oncore rtcm104v2 rtcm104v3 sirf skytraq superstar2 timing tsip tripmate tnt ublox ubx" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LIBREOFFICE_EXTENSIONS="presenter-console presenter-minimizer" LLVM_TARGETS="X86" OFFICE_IMPLEMENTATION="libreoffice" PHP_TARGETS="php5-6 php7-1" POSTGRES_TARGETS="postgres9_5 postgres10" PYTHON_SINGLE_TARGET="python3_6" PYTHON_TARGETS="python2_7 python3_6" RUBY_TARGETS="ruby23" USERLAND="GNU" 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: CC, CPPFLAGS, CTARGET, CXX, INSTALL_MASK, LC_ALL, LINGUAS, PORTAGE_BINHOST, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS ================================================================= Package Settings ================================================================= dev-db/mysql-5.6.40-r2::gentoo was built with the following: USE="perl server (-client-libs) -cracklib -debug -jemalloc -latin1 -libressl -numa -profiling (-selinux) -static -static-libs -systemtap -tcmalloc -test -yassl" CFLAGS="-march=native -mtune=native -O2 -pipe -fno-strict-aliasing" CXXFLAGS="-march=native -mtune=native -O2 -pipe -felide-constructors -fno-strict-aliasing"
Created attachment 554806 [details] contents of ${T}/var-tests/log/rpl.rpl_semi_sync_shutdown_hang-mix
It is fixed in >=5.7 via https://github.com/mysql/mysql-server/commit/a9840ba26e9f2af18c5f16ee79d0b008f98f22d0 Let's see if we are going to backport or remove <mysql-5.7.
The bug has been referenced in the following commit(s): https://gitweb.gentoo.org/proj/mysql-extras.git/commit/?id=0f5f17c5a15d7a2bba4fd46615a655b0f0bf5ca7 commit 0f5f17c5a15d7a2bba4fd46615a655b0f0bf5ca7 Author: Thomas Deutschmann <whissi@gentoo.org> AuthorDate: 2018-11-11 23:14:29 +0000 Commit: Thomas Deutschmann <whissi@gentoo.org> CommitDate: 2018-11-11 23:14:29 +0000 Add 20036_all_mysql-5.6-fix-rpl_semi_sync_shutdown_hang.test.patch Bug: https://bugs.gentoo.org/670882 Signed-off-by: Thomas Deutschmann <whissi@gentoo.org> ...-5.6-fix-rpl_semi_sync_shutdown_hang.test.patch | 52 ++++++++++++++++++++++ 1 file changed, 52 insertions(+)
The bug has been closed via the following commit(s): https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=a700871f5aa1971376b7fd7182bc9021f09ab273 commit a700871f5aa1971376b7fd7182bc9021f09ab273 Author: Thomas Deutschmann <whissi@gentoo.org> AuthorDate: 2018-11-11 23:19:16 +0000 Commit: Thomas Deutschmann <whissi@gentoo.org> CommitDate: 2018-11-11 23:19:35 +0000 dev-db/mysql: fix rpl.rpl_semi_sync_shutdown_hang test failure Closes: https://bugs.gentoo.org/670882 Package-Manager: Portage-2.3.51, Repoman-2.3.12 Signed-off-by: Thomas Deutschmann <whissi@gentoo.org> dev-db/mysql/Manifest | 1 + dev-db/mysql/mysql-5.6.40-r2.ebuild | 5 +++-- dev-db/mysql/mysql-5.6.41.ebuild | 5 +++-- 3 files changed, 7 insertions(+), 4 deletions(-)
