Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 895112 - dev-db/mariadb-10.6.12 fails unit.pfs test
Summary: dev-db/mariadb-10.6.12 fails unit.pfs test
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: Normal normal
Assignee: Gentoo Linux MySQL bugs team
URL:
Whiteboard: fixed in 10.6.20
Keywords: TESTFAILURE
Depends on:
Blocks: 915000
  Show dependency tree
 
Reported: 2023-02-17 11:26 UTC by Paolo Pedroni
Modified: 2024-11-13 09:43 UTC (History)
4 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments
mariadb-10.6.11:20230217-102748.log.gz (mariadb-10.6.11:20230217-102748.log.gz,271.55 KB, application/gzip)
2023-02-17 11:26 UTC, Paolo Pedroni
Details
failed-test.tar.xz (failed-test.tar.xz,754.16 KB, application/x-xz)
2023-02-17 11:28 UTC, Paolo Pedroni
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Paolo Pedroni 2023-02-17 11:26:33 UTC
Created attachment 852190 [details]
mariadb-10.6.11:20230217-102748.log.gz

unit.pfs                                 w2 [ fail ]
        Test ended at 2023-02-17 11:53:27

CURRENT_TEST: unit.pfs
1..232
# test_bootstrap
ok 1 - boot
ok 2 - boot->get_interface
ok 3 - no version 0
ok 4 - version 1
ok 5 - version 2
# test_bad_registration
ok 6 - zero key
ok 7 - zero key
ok 8 - zero key
ok 9 - zero key
ok 10 - zero key
Bail out! Signal 11 thrown
# 232 tests planned,  0 failed,  10 was last executed


mysqltest failed with unexpected return code 255


 - saving '/var/tmp/portage/dev-db/mariadb-10.6.11/temp/var-tests/2/log/unit.pfs/' to '/var/tmp/portage/dev-db/mariadb-10.6.11/temp/var-tests/log/unit.pfs/'

# emerge --info =dev-db/mariadb-10.6.11
Portage 3.0.44 (python 3.10.9-final-0, default/linux/amd64/17.1/desktop/plasma/systemd/merged-usr, gcc-12, glibc-2.36-r5, 6.1.12-gentoo x86_64)
=================================================================
                         System Settings
=================================================================
System uname: Linux-6.1.12-gentoo-x86_64-AMD_Ryzen_7_5700G_with_Radeon_Graphics-with-glibc2.36
KiB Mem:    65121220 total,  51714736 free
KiB Swap:   67108860 total,  67108860 free
Timestamp of repository gentoo: Fri, 17 Feb 2023 09:15:01 +0000
Head commit of repository gentoo: b21e8670a2ef1239c1448a7b186dca41170756a5
sh dash 0.5.12
ld GNU ld (Gentoo 2.39 p5) 2.39.0
distcc 3.4 x86_64-pc-linux-gnu [disabled]
ccache version 4.7.4 [disabled]
app-misc/pax-utils:        1.3.5::gentoo
app-shells/bash:           5.1_p16-r2::gentoo
dev-java/java-config:      2.3.1::gentoo
dev-lang/perl:             5.36.0-r1::gentoo
dev-lang/python:           3.10.9-r1::gentoo, 3.11.1-r1::gentoo
dev-lang/rust:             1.66.1::gentoo
dev-util/ccache:           4.7.4::gentoo
dev-util/cmake:            3.25.2::gentoo
dev-util/meson:            1.0.0::gentoo
sys-apps/baselayout:       2.9::gentoo
sys-apps/sandbox:          2.29::gentoo
sys-apps/systemd:          252.4-r1::gentoo
sys-devel/autoconf:        2.71-r5::gentoo
sys-devel/automake:        1.16.5::gentoo
sys-devel/binutils:        2.39-r4::gentoo
sys-devel/binutils-config: 5.4.1::gentoo
sys-devel/clang:           15.0.7-r1::gentoo
sys-devel/gcc:             12.2.1_p20230121-r1::gentoo
sys-devel/gcc-config:      2.8::gentoo
sys-devel/libtool:         2.4.7-r1::gentoo
sys-devel/lld:             15.0.7::gentoo
sys-devel/llvm:            15.0.7::gentoo
sys-devel/make:            4.3::gentoo
sys-kernel/linux-headers:  5.15-r3::gentoo (virtual/os-headers)
sys-libs/glibc:            2.36-r5::gentoo
Repositories:

gentoo
    location: /var/db/repos/gentoo
    sync-type: rsync
    sync-uri: rsync://rsync.europe.gentoo.org/gentoo-portage
    priority: -1000
    volatile: True
    sync-rsync-verify-max-age: 24
    sync-rsync-verify-metamanifest: yes
    sync-rsync-verify-jobs: 1
    sync-rsync-extra-opts: 

x-portage
    location: /usr/local/portage
    masters: gentoo
    priority: 0
    volatile: True

ACCEPT_KEYWORDS="amd64"
ACCEPT_LICENSE="@FREE"
AR="/usr/bin/gcc-ar"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-O2 -pipe -frecord-gcc-switches -march=znver3 -ftree-vectorize -flto=8"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/lib64/libreoffice/program/sofficerc /usr/share/config /usr/share/easy-rsa /usr/share/gnupg/qualified.txt"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/dconf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/revdep-rebuild /etc/sandbox.d"
CXXFLAGS="-O2 -pipe -frecord-gcc-switches -march=znver3 -ftree-vectorize -flto=8"
DISTDIR="/var/cache/distfiles"
EMERGE_DEFAULT_OPTS="--keep-going y --with-bdeps y"
ENV_UNSET="CARGO_HOME DBUS_SESSION_BUS_ADDRESS DISPLAY GDK_PIXBUF_MODULE_FILE GOBIN GOPATH PERL5LIB PERL5OPT PERLPREFIX PERL_CORE PERL_MB_OPT PERL_MM_OPT XAUTHORITY XDG_CACHE_HOME XDG_CONFIG_HOME XDG_DATA_HOME XDG_RUNTIME_DIR XDG_STATE_HOME"
FCFLAGS="-O2 -pipe -frecord-gcc-switches -march=znver3 -ftree-vectorize -flto=8"
FEATURES="assume-digests binpkg-docompress binpkg-dostrip binpkg-logs buildpkg-live cgroup compress-build-logs config-protect-if-modified distlocks ebuild-locks ipc-sandbox merge-sync multilib-strict network-sandbox news parallel-fetch pid-sandbox preserve-libs protect-owned qa-unresolved-soname-deps sandbox sfperms sign split-elog split-log strict test unknown-features-warn unmerge-logs unmerge-orphans userfetch userpriv usersandbox usersync xattr"
FFLAGS="-O2 -pipe -frecord-gcc-switches -march=znver3 -ftree-vectorize -flto=8"
GENTOO_MIRRORS="http://mirrors.aliyun.com/gentoo/ https://mirrors.aliyun.com/gentoo/ http://mirror.leaseweb.com/gentoo/ http://ftp.uni-hannover.de/gentoo/"
LANG="it_IT.utf8"
LDFLAGS="-Wl,-O1 -Wl,--as-needed -Wl,--hash-style=gnu -Wl,--sort-common -ftree-vectorize -flto=8"
LEX="flex"
LINGUAS="it it_IT"
MAKEOPTS="-j16 -l16"
NM="/usr/bin/gcc-nm"
PKGDIR="/var/cache/binpkgs"
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"
RANLIB="/usr/bin/gcc-ranlib"
SHELL="/bin/bash"
USE="X a52 aac aalib acl acpi activities adns alsa amd64 ao audiofile bash-completion bluetooth branding brotli bzip2 cairo caps cdda cddb cdparanoia cdr cli crypt css cups curl dbus declarative dga djvu dri dts dvd dvdr encode exif expat fbcon ffmpeg fftw flac fontconfig foomaticdb fortran ftp gd gdbm geoip gif gimp gmp gnutls gphoto2 gpm graphviz gstreamer gtk gui guile handbook iconv icu idn imagemagick imlib introspection ipv6 java javascript jbig jemalloc jpeg jpeg2k kde kwallet lame lcms libass libglvnd libnotify libsamplerate libtirpc lm-sensors lua lz4 lzma lzo mad magic mhash mmap mng mp3 mp4 mpeg multilib musicbrainz ncurses nls nptl offensive ogg openal opengl openmp opus pam pango pcre pdf plasma png policykit postscript ppds pulseaudio qml qt5 rdesktop readline recode samba screencast sctp sdl seccomp sndfile sockets sound speex spell sqlite ssl startup-notification svg symlink syslog systemd sysvipc taglib telemetry test test-rust theora threads tidy tiff truetype udev udisks unicode upower usb v4l vaapi vala verify-sig vim-syntax vnc vorbis wavpack wayland webp widgets win32codecs wmf wxwidgets x264 xattr xcb xft xinerama xml xpm xscreensaver xv xvid yahoo zip zlib zstd" ABI_X86="64" ADA_TARGET="gnat_2021" ALSA_CARDS="hda-intel virmidi" 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 sheets words" CAMERAS="ptp2" COLLECTD_PLUGINS="df interface irq load memory rrdtool swap syslog" CPU_FLAGS_X86="aes avx avx2 f16c fma3 mmx mmxext pclmul popcnt rdrand sha sse sse2 sse3 sse4_1 sse4_2 sse4a ssse3" CURL_SSL="gnutls" ELIBC="glibc" GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock greis isync itrax mtk3301 nmea ntrip navcom oceanserver oldstyle oncore rtcm104v2 rtcm104v3 sirf skytraq superstar2 timing tsip tripmate tnt ublox ubx" INPUT_DEVICES="libinput" KERNEL="linux" L10N="it en" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LIBREOFFICE_EXTENSIONS="presenter-console presenter-minimizer" LLVM_TARGETS="AMDGPU" LUA_SINGLE_TARGET="lua5-1" LUA_TARGETS="lua5-1" OFFICE_IMPLEMENTATION="libreoffice" PHP_TARGETS="php7-4 php8-0" POSTGRES_TARGETS="postgres12 postgres13" PYTHON_SINGLE_TARGET="python3_10" PYTHON_TARGETS="python3_10" RUBY_TARGETS="ruby31" USERLAND="GNU" VIDEO_CARDS="amdgpu radeon radeonsi" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip fuzzy condition tee tarpit sysrq proto steal rawnat logmark ipmark dhcpmac delude chaos account"
Unset:  ADDR2LINE, ARFLAGS, AS, ASFLAGS, CC, CCLD, CONFIG_SHELL, CPP, CPPFLAGS, CTARGET, CXX, CXXFILT, ELFEDIT, EXTRA_ECONF, F77FLAGS, FC, GCOV, GPROF, INSTALL_MASK, LC_ALL, LD, LFLAGS, LIBTOOL, MAKE, MAKEFLAGS, OBJCOPY, OBJDUMP, PORTAGE_BINHOST, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, READELF, RUSTFLAGS, SIZE, STRINGS, STRIP, YACC, YFLAGS

=================================================================
                        Package Settings
=================================================================

dev-db/mariadb-10.6.11::gentoo was built with the following:
USE="backup cracklib extraengine jemalloc odbc pam perl server systemd xml -bindist -columnstore -debug -galera -innodb-lz4 -innodb-lzo -innodb-snappy -jdbc -kerberos -latin1 (-mroonga) -numa -oqgraph -profiling -rocksdb -s3 (-selinux) -sphinx -sst-mariabackup -sst-rsync -static -systemtap -tcmalloc -test -yassl" ABI_X86="(64)"
CFLAGS="-O2 -pipe -frecord-gcc-switches -march=znver3 -ftree-vectorize -flto=8 -fno-lto -fno-strict-aliasing"
CXXFLAGS="-O2 -pipe -frecord-gcc-switches -march=znver3 -ftree-vectorize -flto=8 -fno-lto -felide-constructors -fno-strict-aliasing"
FEATURES="usersync parallel-fetch userfetch strict config-protect-if-modified multilib-strict cgroup network-sandbox qa-unresolved-soname-deps news xattr pid-sandbox distlocks binpkg-logs binpkg-dostrip sfperms buildpkg-live ebuild-locks unmerge-logs assume-digests protect-owned split-log merge-sync userpriv compress-build-logs sign unknown-features-warn sandbox unmerge-orphans preserve-libs ipc-sandbox split-elog binpkg-docompress"
LDFLAGS="-Wl,-O1 -Wl,--as-needed -Wl,--hash-style=gnu -Wl,--sort-common -ftree-vectorize -flto=8 -fno-lto"

# emerge -1pqv =dev-db/mariadb-10.6.11
[ebuild   R   ] dev-db/mariadb-10.6.11  USE="backup cracklib extraengine jemalloc odbc pam perl server systemd test* xml -bindist -columnstore -debug -galera -innodb-lz4 -innodb-lzo -innodb-snappy -jdbc -kerberos -latin1 (-mroonga) -numa -oqgraph -profiling -rocksdb -s3 (-selinux) -sphinx -sst-mariabackup -sst-rsync -static -systemtap -tcmalloc -yassl"
Comment 1 Paolo Pedroni 2023-02-17 11:28:30 UTC
Created attachment 852192 [details]
failed-test.tar.xz

This archive contains the '/var/tmp/portage/dev-db/mariadb-10.6.11/temp/var-tests/log/unit.pfs/' where the build system saved all the data for the failing test.
Comment 2 Tomáš Mózes 2023-02-17 14:55:42 UTC
Can you please test 10.6.12?
Comment 3 Paolo Pedroni 2023-02-17 15:06:17 UTC
(In reply to Tomáš Mózes from comment #2)
> Can you please test 10.6.12?

I already did, but I forgot to mention it: same failure.
Comment 4 Tomáš Mózes 2023-02-17 19:40:56 UTC
Can you please try to remove "-frecord-gcc-switches -march=znver3 -ftree-vectorize -flto=8" from FLAGS in your make.conf?

CFLAGS="-O2 -pipe -frecord-gcc-switches -march=znver3 -ftree-vectorize -flto=8"
CXXFLAGS="-O2 -pipe -frecord-gcc-switches -march=znver3 -ftree-vectorize -flto=8"
FFLAGS="-O2 -pipe -frecord-gcc-switches -march=znver3 -ftree-vectorize -flto=8"
...

->

CFLAGS="-O2 -pipe"
CXXFLAGS="-O2 -pipe"
FFLAGS="-O2 -pipe"
...
Comment 5 Paolo Pedroni 2023-03-07 16:21:22 UTC
(In reply to Tomáš Mózes from comment #4)
> Can you please try to remove "-frecord-gcc-switches -march=znver3
> -ftree-vectorize -flto=8" from FLAGS in your make.conf?
> 
> CFLAGS="-O2 -pipe -frecord-gcc-switches -march=znver3 -ftree-vectorize
> -flto=8"
> CXXFLAGS="-O2 -pipe -frecord-gcc-switches -march=znver3 -ftree-vectorize
> -flto=8"
> FFLAGS="-O2 -pipe -frecord-gcc-switches -march=znver3 -ftree-vectorize
> -flto=8"
> ...
> 
> ->
> 
> CFLAGS="-O2 -pipe"
> CXXFLAGS="-O2 -pipe"
> FFLAGS="-O2 -pipe"
> ...

I tried several combinations, and the culprit is "-march=znver3": with it, tests fail, with all other flags, tests succeed.

I have to try with other -march options on other PCs, but today.
Comment 6 Sam James archtester Gentoo Infrastructure gentoo-dev Security 2023-03-07 16:22:21 UTC
That's quite concerning.
Comment 7 Paolo Pedroni 2023-03-08 12:29:29 UTC
(In reply to Sam James from comment #6)
> That's quite concerning.

-march=skylake and -march=icelake-client give the same problem on their respective PCs, while -march=amdfam10 on an old Phenom II seems to work fine.
Comment 8 Paolo Pedroni 2023-03-08 15:35:29 UTC
I think I found a solution: if I put '-mno-avx' in *FLAGS, tests succeed.
Comment 9 Petr Vaněk gentoo-dev 2024-02-01 07:31:43 UTC
dev-db/mariadb-10.11.6 has also this issue. I was able to trigger it with *FLAGS="-O2 -pipe -mavx"
Comment 10 Petr Vaněk gentoo-dev 2024-02-01 15:37:32 UTC
The issue affects tests only. They use different allocators in pfs unit tests, some of them unaligned, but -mavx can produce code which requires aligned memory. For me it SIGSEGV here

#0  register_mutex_class (name=0x7ffd1d499960 "wait/synch/mutex/1234567890123/X", name_length=32,
    flags=<optimized out>)
    at /var/tmp/portage/dev-db/mariadb-10.11.6/work/mysql/storage/perfschema/pfs_instr_class.cc:1120
        index = 0
        entry = 0x55875f9b2550

entry address is stored in r14 register and the code SIGSEGVs on this instruction:

=> 0x000055875dd6960d <+381>:   vmovdqa %ymm0,0xa0(%r14)

The 0x55875f9b2550 address is not aligned to 32.
Comment 11 Arniii 2024-07-03 15:11:53 UTC
reproducible with dev-db/mariadb-10.6.17
Comment 12 Petr Vaněk gentoo-dev 2024-11-13 09:43:04 UTC
The issue was fixed in commit https://github.com/MariaDB/server/commit/7e0afb1c73688e11f4095f883ce913f33fcdba43.