[MDEV-27045] Test perfschema.privilege_table_io seems unstable Created: 2021-11-14  Updated: 2021-11-14

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.6.5
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Thomas Deutschmann Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment: 

sh bash 5.1_p8
 
ld GNU ld (Gentoo 2.37_p1 p0) 2.37
 
ccache version 4.4.2 [enabled]
 
app-shells/bash: 5.1_p8::gentoo
 
dev-lang/perl: 5.34.0-r3::gentoo
 
dev-lang/python: 3.9.7_p1::gentoo
 
dev-util/ccache: 4.4.2::gentoo
 
dev-util/cmake: 3.20.5::gentoo
 
sys-apps/baselayout: 2.7::gentoo
 
sys-apps/openrc: 0.44.7::gentoo
 
sys-apps/sandbox: 2.25::gentoo
 
sys-devel/autoconf: 2.71-r1::gentoo
 
sys-devel/automake: 1.16.4::gentoo
 
sys-devel/binutils: 2.37_p1::gentoo
 
sys-devel/gcc: 10.3.0-r2::gentoo
 
sys-devel/gcc-config: 2.4::gentoo
 
sys-devel/libtool: 2.4.6-r6::gentoo
 
sys-devel/make: 4.3::gentoo
 
sys-kernel/linux-headers: 5.10::gentoo (virtual/os-headers)
 
sys-libs/glibc: 2.33-r7::gentoo


cmake -C /var/tmp/portage/dev-db/mariadb-10.6.5/work/mariadb-10.6.5_build/gentoo_common_config.cmake -G Ninja -DCMAKE_INSTALL_PREFIX=/usr -DCMAKE_C_FLAGS_RELWITHDEBINFO=-DNDEBUG -DCMAKE_CXX_FLAGS_RELWITHDEBINFO=-DNDEBUG -DMYSQL_DATADIR=/var/lib/mysql -DSYSCONFDIR=/etc/mysql -DINSTALL_BINDIR=bin -DINSTALL_DOCDIR=share/doc/mariadb-10.6.5 -DINSTALL_DOCREADMEDIR=share/doc/mariadb-10.6.5 -DINSTALL_INCLUDEDIR=include/mysql -DINSTALL_INFODIR=share/info -DINSTALL_LIBDIR=lib64 -DINSTALL_MANDIR=share/man -DINSTALL_MYSQLSHAREDIR=share/mariadb -DINSTALL_PLUGINDIR=lib64/mariadb/plugin -DINSTALL_SCRIPTDIR=bin -DINSTALL_MYSQLDATADIR=/var/lib/mysql -DINSTALL_SBINDIR=sbin -DINSTALL_SUPPORTFILESDIR=/usr/share/mariadb -DWITH_COMMENT=Gentoo Linux mariadb-10.6.5 -DWITH_UNIT_TESTS=ON -DWITH_LIBEDIT=0 -DWITH_ZLIB=system -DWITHOUT_LIBWRAP=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_UNIX_ADDR=/var/run/mysqld/mysqld.sock -DINSTALL_UNIX_ADDRDIR=/var/run/mysqld/mysqld.sock -DWITH_DEFAULT_COMPILER_OPTIONS=0 -DWITH_DEFAULT_FEATURE_SET=0 -DINSTALL_SYSTEMD_UNITDIR=/lib/systemd/system -DSTACK_DIRECTION=-1 -DPKG_CONFIG_EXECUTABLE=/usr/bin/x86_64-pc-linux-gnu-pkg-config -DPLUGIN_AUTH_GSSAPI=NO -DAUTH_GSSAPI_PLUGIN_TYPE=OFF -DCONC_WITH_EXTERNAL_ZLIB=YES -DWITH_EXTERNAL_ZLIB=YES -DSUFFIX_INSTALL_DIR= -DWITH_UNITTEST=OFF -DWITHOUT_CLIENTLIBS=YES -DCLIENT_PLUGIN_DIALOG=OFF -DCLIENT_PLUGIN_AUTH_GSSAPI_CLIENT=OFF -DCLIENT_PLUGIN_CLIENT_ED25519=OFF -DCLIENT_PLUGIN_MYSQL_CLEAR_PASSWORD=STATIC -DCLIENT_PLUGIN_CACHING_SHA2_PASSWORD=OFF -DINSTALL_MYSQLTESTDIR=share/mariadb/mysql-test -DWITH_SSL=system -DCLIENT_PLUGIN_SHA256_PASSWORD=STATIC -DWITH_READLINE=0 -DNOT_FOR_DISTRIBUTION=1 -DENABLE_DTRACE=no -DPLUGIN_CONNECT=NO -DPLUGIN_FEDERATED=NO -DPLUGIN_FEDERATEDX=NO -DWITH_PCRE=system -DPLUGIN_OQGRAPH=NO -DPLUGIN_SPHINX=NO -DPLUGIN_AUTH_PAM=YES -DPLUGIN_AWS_KEY_MANAGEMENT=NO -DPLUGIN_CRACKLIB_PASSWORD_CHECK=NO -DPLUGIN_SEQUENCE=NO -DPLUGIN_SPIDER=NO -DPLUGIN_S3=NO -DPLUGIN_COLUMNSTORE=NO -DCONNECT_WITH_MYSQL=1 -DCONNECT_WITH_LIBXML2=no -DCONNECT_WITH_ODBC=no -DCONNECT_WITH_JDBC=no -DCONNECT_WITH_MONGO=OFF -DWITH_WSREP=no -DWITH_INNODB_LZ4=OFF -DWITH_INNODB_LZO=OFF -DWITH_INNODB_SNAPPY=OFF -DPLUGIN_MROONGA=NO -DPLUGIN_AUTH_GSSAPI=NO -DWITH_MARIABACKUP=ON -DWITH_LIBARCHIVE=ON -DINSTALL_SQLBENCHDIR= -DPLUGIN_ROCKSDB=NO -DWITH_SYSTEMD=no -DWITH_NUMA=OFF -DSKIP_TESTS=ON -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_unicode_520_ci -DEXTRA_CHARSETS=all -DMYSQL_USER=mysql -DDISABLE_SHARED=NO -DWITH_DEBUG=no -DWITH_EMBEDDED_SERVER=OFF -DWITH_PROFILING=no -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_CSV_STORAGE_ENGINE=1 -DWITH_HEAP_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MYISAMMRG_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DCMAKE_BUILD_TYPE=RelWithDebInfo -DCMAKE_TOOLCHAIN_FILE=/var/tmp/portage/dev-db/mariadb-10.6.5/work/mariadb-10.6.5_build/gentoo_toolchain.cmake /var/tmp/portage/dev-db/mariadb-10.6.5/work/mysql



 Description   

Test perfschema.privilege_table_io seems unstable on Gentoo Linux – failing during normal build but passing when running manually:

perfschema.privilege_table_io            w13 [ fail ]
 
        Test ended at 2021-11-14 19:48:24
 
 
 
CURRENT_TEST: perfschema.privilege_table_io
 
--- /var/tmp/portage/dev-db/mariadb-10.6.5/work/mysql/mysql-test/suite/perfschema/r/privilege_table_io.result   2021-11-05 21:03:30.000000000 +0100
 
+++ /var/tmp/portage/dev-db/mariadb-10.6.5/work/mysql/mysql-test/suite/perfschema/r/privilege_table_io.reject   2021-11-14 19:48:23.959874931 +0100
 
@@ -117,13 +117,11 @@
 
 wait/io/table/sql/handler              TABLE   mysql   global_priv     fetch   1
 
 wait/io/table/sql/handler              TABLE   mysql   global_priv     fetch   1
 
 wait/io/table/sql/handler              TABLE   mysql   global_priv     fetch   1
 
-wait/io/table/sql/handler              TABLE   mysql   global_priv     fetch   1
 
 wait/io/table/sql/handler              TABLE   mysql   db      fetch   1
 
 wait/io/table/sql/handler              TABLE   mysql   db      fetch   1
 
 wait/io/table/sql/handler              TABLE   mysql   db      fetch   1
 
 wait/io/table/sql/handler              TABLE   mysql   proxies_priv    fetch   1
 
 wait/io/table/sql/handler              TABLE   mysql   proxies_priv    fetch   1
 
-wait/io/table/sql/handler              TABLE   mysql   proxies_priv    fetch   1
 
 wait/io/table/sql/handler              TABLE   mysql   roles_mapping   fetch   1
 
 wait/io/table/sql/handler              TABLE   mysql   tables_priv     fetch   1
 
 wait/io/table/sql/handler              TABLE   mysql   tables_priv     fetch   1
 
 
 
mysqltest: Result length mismatch


Generated at Thu Feb 08 09:49:55 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.