[MDEV-9171] innodb.innodb_uninstall Test Failure - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.1(EOL)
Fix Version/s: 10.1.14
Component/s: Storage Engine - InnoDB, Tests, wsrep
Labels:
None

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/'

Attachments

Issue Links

blocks

MDEV-7069 Fix buildbot failures in main server trees

Stalled

links to

Commit

Activity

Ascending order - Click to sort in descending order

Brian Evans created issue - 2015-11-23 20:10

Elena Stepanova added a comment - 2015-11-24 01:37

grknight,

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

Elena Stepanova added a comment - 2015-11-24 01:37 grknight , How do you build (cmake options), and how do you run the test (command line)?

Elena Stepanova made changes - 2015-11-24 01:37

Field	Original Value	New Value
Labels		need_feedback

Brian Evans added a comment - 2015-11-24 17:02

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'

Brian Evans added a comment - 2015-11-24 17:02 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'

Elena Stepanova made changes - 2015-11-25 00:53

Labels

need_feedback

Kolbe Kegel (Inactive) added a comment - 2015-12-19 00:31

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

Kolbe Kegel (Inactive) added a comment - 2015-12-19 00:31 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

Elena Stepanova made changes - 2016-01-13 03:22

Status

Open [ 1 ]

Confirmed [ 10101 ]

Elena Stepanova added a comment - 2016-01-13 03:25

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)

Elena Stepanova made changes - 2016-01-13 03:25

Fix Version/s		10.1 [ 16100 ]
Affects Version/s		10.1 [ 16100 ]
Affects Version/s	10.1.9 [ 20301 ]
Assignee		Nirbhay Choubey [ nirbhay_c ]
Priority	Minor [ 4 ]	Major [ 3 ]

Elena Stepanova made changes - 2016-01-13 03:26

Environment

Gentoo x86_64

Elena Stepanova made changes - 2016-01-13 03:26

Component/s

wsrep [ 11500 ]

Elena Stepanova added a comment - 2016-01-26 02:20

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

Elena Stepanova added a comment - 2016-01-26 02:20 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

Elena Stepanova made changes - 2016-01-26 02:20

Link

This issue blocks MDEV-7069 [ MDEV-7069 ]

Sergey Vojtovich made changes - 2016-02-29 09:12

Priority

Major [ 3 ]

Critical [ 2 ]

Sergey Vojtovich added a comment - 2016-02-29 09:13

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

Sergey Vojtovich added a comment - 2016-02-29 09:13 Raising priority since the issue is been around since 3 months already and affects bb.

Rasmus Johansson (Inactive) made changes - 2016-04-27 07:04

Sprint

10.1.14 [ 51 ]

Rasmus Johansson (Inactive) made changes - 2016-04-27 07:04

Rank

Ranked lower

Nirbhay Choubey (Inactive) made changes - 2016-04-27 14:31

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Nirbhay Choubey (Inactive) made changes - 2016-04-27 15:33

Fix Version/s		10.1.14 [ 21804 ]
Fix Version/s	10.1 [ 16100 ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Nirbhay Choubey (Inactive) made changes - 2016-04-27 15:33

Remote Link

This issue links to "Commit (Web Link)" [ 27334 ]

Nirbhay Choubey (Inactive) made changes - 2016-05-05 14:36

Remote Link

This issue links to "Commit (Web Link)" [ 27334 ]

Nirbhay Choubey (Inactive) made changes - 2016-05-05 14:37

Remote Link

This issue links to "Commit (Web Link)" [ 27339 ]

Sergei Golubchik made changes - 2021-12-06 21:42

Workflow

MariaDB v3 [ 72711 ]

MariaDB v4 [ 149855 ]

People

Assignee:: Nirbhay Choubey (Inactive)

Reporter:: Brian Evans

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2015-11-23 20:10

Updated:: 2016-05-05 14:37

Resolved:: 2016-04-27 15:33

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration