[MDEV-9171] innodb.innodb_uninstall Test Failure Created: 2015-11-23  Updated: 2016-05-05  Resolved: 2016-04-27

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Tests, wsrep
Affects Version/s: 10.1
Fix Version/s: 10.1.14

Type: Bug Priority: Critical
Reporter: Brian Evans Assignee: Nirbhay Choubey (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-7069 Fix buildbot failures in main server ... Stalled
Sprint: 10.1.14

 Description   

Test fails with Warning differences

CURRENT_TEST: innodb.innodb_uninstall
 
--- /var/tmp/portage/dev-db/mariadb-10.1.9/work/mysql/mysql-test/suite/innodb/r/innodb_uninstall.result 2015-11-20 20:08:03.000000000 -0500
 
+++ /var/tmp/portage/dev-db/mariadb-10.1.9/work/mysql/mysql-test/suite/innodb/r/innodb_uninstall.reject 2015-11-23 12:24:05.990663334 -0500
 
@@ -1,6 +1,4 @@
 
 install plugin innodb soname 'ha_innodb';
 
-Warnings:
 
-Warning        1105    Cannot enable tc-log at run-time. XA features of InnoDB are disabled
 
 create table t1(a int not null primary key) engine=innodb;
 
 begin;
 
 insert into t1 values(1);
 
@@ -12,8 +10,6 @@
 
 Warnings:
 
 Warning        1620    Plugin is busy and will be uninstalled on shutdown
 
 install plugin innodb soname 'ha_innodb';
 
-Warnings:
 
-Warning        1105    Cannot enable tc-log at run-time. XA features of InnoDB are disabled
 
 drop table t1;
 
 create table t2(a int not null primary key) engine=innodb;
 
 insert into t2 values(1);
 
 
 
mysqltest: Result length mismatch
 
 
 
 - saving '/var/tmp/portage/dev-db/mariadb-10.1.9/temp/var-tests/2/log/innodb.innodb_uninstall/' to '/var/tmp/portage/dev-db/mariadb-10.1.9/temp/var-t
 
ests/log/innodb.innodb_uninstall/'
 
 



 Comments   
Comment by Elena Stepanova [ 2015-11-24 ]

grknight,

How do you build (cmake options), and how do you run the test (command line)?

Comment by Brian Evans [ 2015-11-24 ]

CMake command: (Yes I know there are unused options)

cmake --no-warn-unused-cli -C /var/tmp/portage/dev-db/mariadb-10.1.9/work/mysql-abi_x86_64.amd64/gentoo_common_config.cmake -G Unix Makefiles -DCMAKE_INSTALL_PREFIX=/usr -DCMAKE_C_FLAGS_RELWITHDEBINFO=-DNDEBUG -DCMAKE_CXX_FLAGS_RELWITHDEBINFO=-DNDEBUG -DCMAKE_INSTALL_PREFIX=/usr -DMYSQL_DATADIR=/var/lib/mysql -DSYSCONFDIR=/etc/mysql -DINSTALL_BINDIR=bin -DINSTALL_DOCDIR=share/doc/mariadb-10.1.9 -DINSTALL_DOCREADMEDIR=share/doc/mariadb-10.1.9 -DINSTALL_INCLUDEDIR=include/mysql -DINSTALL_INFODIR=share/info -DINSTALL_LIBDIR=lib64 -DINSTALL_MANDIR=share/man -DINSTALL_MYSQLDATADIR=/var/lib/mysql -DINSTALL_MYSQLSHAREDIR=share/mysql -DINSTALL_MYSQLTESTDIR=share/mysql/mysql-test -DINSTALL_PLUGINDIR=lib64/mysql/plugin -DINSTALL_SBINDIR=sbin -DINSTALL_SCRIPTDIR=share/mysql/scripts -DINSTALL_SQLBENCHDIR=share/mysql -DINSTALL_SUPPORTFILESDIR=/usr/share/mysql -DWITH_COMMENT=Gentoo Linux mariadb-10.1.9 -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=/usr/lib/systemd/system -DWITH_SYSTEMD=no -DWITH_SSL=system -DWITH_READLINE=0 -DNOT_FOR_DISTRIBUTION=1 -DWITH_JEMALLOC=system -DWITH_PCRE=system -DDEFAULT_CHARSET=latin1 -DDEFAULT_COLLATION=latin1_swedish_ci -DEXTRA_CHARSETS=all -DMYSQL_USER=mysql -DMYSQL_UNIX_ADDR=/var/run/mysqld/mysqld.sock -DDISABLE_SHARED=OFF  -DWITH_DEBUG=OFF -DWITH_EMBEDDED_SERVER=ON  -DWITH_PROFILING=ON -DENABLE_DTRACE=OFF -DWITH_SAFEMALLOC=OFF -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 -DWITH_OQGRAPH=1 -DPLUGIN_OQGRAPH=YES -DWITHOUT_SPHINX=1 -DWITH_SPHINX=0 -DPLUGIN_SPHINX=NO -DWITH_TOKUDB=1 -DPLUGIN_TOKUDB=YES -DWITH_AUTH_PAM=1 -DPLUGIN_AUTH_PAM=YES -DWITHOUT_CASSANDRA=1 -DWITH_CASSANDRA=0 -DPLUGIN_CASSANDRA=NO -DWITH_SEQUENCE=1 -DPLUGIN_SEQUENCE=YES -DWITH_SPIDER=1 -DPLUGIN_SPIDER=YES -DWITH_CONNECT=1 -DPLUGIN_CONNECT=YES -DCONNECT_WITH_MYSQL=1 -DCONNECT_WITH_LIBXML2=OFF -DCONNECT_WITH_ODBC=OFF -DWITHOUT_MROONGA=1 -DWITH_WSREP=OFF -DWITH_INNODB_LZ4=OFF -DWITH_INNODB_LZO=OFF -DWITH_INNODB_SNAPPY=OFF -DWITH_CRACKLIB_PASSWORD_CHECK=1 -DPLUGIN_CRACKLIB_PASSWORD_CHECK=YES -DENABLE_DTRACE=OFF -DCMAKE_BUILD_TYPE=RelWithDebInfo -DCMAKE_INSTALL_DO_STRIP=OFF -DCMAKE_USER_MAKE_RULES_OVERRIDE=/var/tmp/portage/dev-db/mariadb-10.1.9/work/mysql-abi_x86_64.amd64/gentoo_rules.cmake -DCMAKE_TOOLCHAIN_FILE=/var/tmp/portage/dev-db/mariadb-10.1.9/work/mysql-abi_x86_64.amd64/gentoo_toolchain.cmake  /var/tmp/portage/dev-db/mariadb-10.1.9/work/mysql

Tests were run by: 'perl mysql-test-run.pl --force --vardir="/var/tmp/portage/dev-db/mariadb-10.1.9/temp/var-tests" --reorder'

Comment by Kolbe Kegel (Inactive) [ 2015-12-19 ]

I see this same issue on SLES 11 on s390x (System z), building 10.1e 088fa386c6627c55f8ce4f96954628a3de158cf8:

cmake . -DBUILD_CONFIG=mysql_release -DWITH_JEMALLOC=no -DWITH_WSREP=no -DRPM=sles11

I installed all resulting RPMs, and then did 

cd /usr/share/mysql-test/ && ./mysql-test-run.pl

Comment by Elena Stepanova [ 2016-01-13 ]

Thanks.
The culprit here is -DWITH_WSREP=OFF. Otherwise, default cmake options are enough.
I'm increasing the priority, because to my knowledge it is not supposed to have side-effects.

Without WSREP

 
MariaDB [test]> show variables like '%version%';
 
+-------------------------+----------------------------+
 
| Variable_name           | Value                      |
 
+-------------------------+----------------------------+
 
| protocol_version        | 10                         |
 
| slave_type_conversions  |                            |
 
| version                 | 10.1.10-MariaDB            |
 
| version_comment         | Source distribution        |
 
| version_compile_machine | x86_64                     |
 
| version_compile_os      | Linux                      |
 
| version_malloc_library  | system jemalloc            |
 
| version_ssl_library     | OpenSSL 1.0.1e 11 Feb 2013 |
 
+-------------------------+----------------------------+
 
8 rows in set (0.00 sec)
 
 
 
MariaDB [test]> show variables like 'wsrep%';
 
Empty set (0.00 sec)
 
 
 
MariaDB [test]> install plugin innodb soname 'ha_innodb';
 
Query OK, 0 rows affected (0.53 sec)

With WSREP

 
MariaDB [test]> show variables like '%version%';
 
+-------------------------+----------------------------+
 
| Variable_name           | Value                      |
 
+-------------------------+----------------------------+
 
| protocol_version        | 10                         |
 
| slave_type_conversions  |                            |
 
| version                 | 10.1.10-MariaDB            |
 
| version_comment         | Source distribution        |
 
| version_compile_machine | x86_64                     |
 
| version_compile_os      | Linux                      |
 
| version_malloc_library  | system jemalloc            |
 
| version_ssl_library     | OpenSSL 1.0.1e 11 Feb 2013 |
 
| wsrep_patch_version     | wsrep_25.11                |
 
+-------------------------+----------------------------+
 
9 rows in set (0.00 sec)
 
 
 
MariaDB [test]> show variables like 'wsrep%';
 
+---------------------------------+-----------------------------------------+
 
| Variable_name                   | Value                                   |
 
+---------------------------------+-----------------------------------------+
 
| wsrep_osu_method                | TOI                                     |
 
...
 
| wsrep_sync_wait                 | 0                                       |
 
+---------------------------------+-----------------------------------------+
 
43 rows in set (0.00 sec)
 
 
 
MariaDB [test]> install plugin innodb soname 'ha_innodb';
 
Query OK, 0 rows affected, 1 warning (0.58 sec)
 
 
 
MariaDB [test]> show warnings;
 
+---------+------+----------------------------------------------------------------------+
 
| Level   | Code | Message                                                              |
 
+---------+------+----------------------------------------------------------------------+
 
| Warning | 1105 | Cannot enable tc-log at run-time. XA features of InnoDB are disabled |
 
+---------+------+----------------------------------------------------------------------+
 
1 row in set (0.00 sec)

Comment by Elena Stepanova [ 2016-01-26 ]

Same problem in buildbot (this builder also builds without WSREP):
http://buildbot.askmonty.org/buildbot/builders/ibmz-rhel6-bintar/builds/192/steps/test/logs/stdio

Comment by Sergey Vojtovich [ 2016-02-29 ]

Raising priority since the issue is been around since 3 months already and affects bb.

Generated at Thu Feb 08 07:32:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.