[MDEV-2506] LP:609813 - mtr skips tests from --suite=innodb_plugin for lp:maria/5.2 Created: 2010-07-25  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Mark Callaghan Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug609813.xml    

 Description   

All of the tests in suite/innodb_plugin are skipped. I assume that the problem is:
– source include/have_innodb_plugin.inc

The contents of that are:
disable_query_log;
--require r/true.require
SELECT (plugin_library LIKE 'ha_innodb_plugin%') AS `TRUE` FROM information_schema.plugins WHERE LOWER(plugin_name) = 'innodb' AND LOWER(plugin_status) = 'active';
enable_query_log;

./mysql-test-run.pl -mtr-port-base=13300 --force -suite=innodb_plugin --mysqld=-plugin-load=ha_xtradb.so
Logging: ./mysql-test-run.pl -mtr-port-base=13300 --force -suite=innodb_plugin --mysqld=-plugin-load=ha_xtradb.so
...
cmd: /s/bld/52mariabzr/sql/mysqld --no-defaults --datadir=/s/bld/52mariabzr/mysql-test/var/tmp --basedir=/s/bld/52mariabzr --language=/s/bld/52mariabzr/sql/share/english --skip-grant-tables --plugin-dir=/s/bld/52mariabzr/mysql-test/var/plugins --plugin-load=ha_xtradb.so --verbose --help
...
==============================================================================

TEST RESULT TIME (ms)
------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 330, with reserved ports 13300..13309
innodb_plugin.innodb [ skipped ] Test requires: 'true'
innodb_plugin.innodb_bug39438 [ skipped ] Test requires: 'true'

innodb_plugin.innodb-use-sys-malloc [ skipped ] Test requires: 'true'
innodb_plugin.innodb_bug42101-nonzero [ skipped ] Test requires: 'true'
innodb_plugin.innodb-consistent [ skipped ] Test requires: 'true'
innodb_plugin.innodb-semi-consistent [ skipped ] Test requires: 'true'
innodb_plugin.innodb-analyze [ skipped ] Test requires: 'true'
innodb_plugin.innodb-autoinc [ skipped ] Test requires: 'true'
innodb_plugin.innodb-autoinc-44030 [ skipped ] Test requires: 'true'
innodb_plugin.innodb-index [ skipped ] Test requires: 'true'
innodb_plugin.innodb-index_ucs2 [ skipped ] Test requires: 'true'
innodb_plugin.innodb-lock [ skipped ] Test requires: 'true'
innodb_plugin.innodb-replace [ skipped ] Test requires: 'true'
innodb_plugin.innodb-timeout [ skipped ] Test requires: 'true'
innodb_plugin.innodb-zip [ skipped ] Test requires: 'true'
innodb_plugin.innodb_bug21704 [ skipped ] Test requires: 'true'
innodb_plugin.innodb_bug34053 [ skipped ] Test requires: 'true'
innodb_plugin.innodb_bug34300 [ skipped ] Test requires: 'true'
innodb_plugin.innodb_bug35220 [ skipped ] Test requires: 'true'
innodb_plugin.innodb_bug36169 [ skipped ] Test requires: 'true'
innodb_plugin.innodb_bug36172 [ skipped ] Test requires: 'true'
innodb_plugin.innodb_bug38231 [ skipped ] Test requires: 'true'
innodb_plugin.innodb_bug40360 [ skipped ] Test requires: 'true'
innodb_plugin.innodb_bug40565 [ skipped ] Test requires: 'true'
innodb_plugin.innodb_bug41904 [ skipped ] Test requires: 'true'
innodb_plugin.innodb_bug42101 [ skipped ] Test requires: 'true'
innodb_plugin.innodb_bug44032 [ skipped ] Test requires: 'true'
innodb_plugin.innodb_bug44369 [ skipped ] Test requires: 'true'

In contrast, the results for --suite=innodb are better:

worker[1] Using MTR_BUILD_THREAD 330, with reserved ports 13300..13309
innodb.innodb_bug51920 [ disabled ] Waiting for merge with XtraDB
innodb.innodb_bug52663 [ disabled ] Waiting for merge with XtraDB
innodb.innodb_misc1 [ pass ] 5965
innodb.innodb_bug39438 [ pass ] 30
innodb.innodb-semi-consistent [ pass ] 12822
innodb.innodb_bug42101-nonzero [ pass ] 3
innodb.innodb-autoinc [ pass ] 22406
innodb.innodb-autoinc-44030 [ pass ] 10671
innodb.innodb-lock [ pass ] 4142
innodb.innodb-replace [ pass ] 14
innodb.innodb-use-sys-malloc [ pass ] 34
innodb.innodb_bug21704 [ pass ] 177
innodb.innodb_bug34053 [ pass ] 78
innodb.innodb_bug35220 [ pass ] 18
innodb.innodb_bug38231 [ pass ] 26
innodb.innodb_bug40565 [ pass ] 34
innodb.innodb_bug42101 [ pass ] 3
innodb.innodb_bug44369 [ pass ] 3
innodb.innodb_bug45357 [ pass ] 35
innodb.innodb_bug46000 [ pass ] 37
innodb.innodb_bug47621 [ pass ] 40
innodb.innodb_bug47777 [ pass ] 138
innodb.innodb_trx_weight [ pass ] 620



 Comments   
Comment by Mark Callaghan [ 2010-07-25 ]

Re: mtr skips tests from --suite=innodb_plugin for lp:maria/5.2
Change the query in include/have_innodb_plugin.inc to this:

SELECT (plugin_library LIKE 'ha_innodb_plugin%' OR plugin_library LIKE 'ha_xtradb%') AS `TRUE` FROM information_schema.plugins WHERE LOWER(plugin_name) = 'innodb' AND LOWER(plugin_status) = 'active';

Comment by Mark Callaghan [ 2010-07-25 ]

Re: mtr skips tests from --suite=innodb_plugin for lp:maria/5.2
With that change these tests fail:
innodb_plugin.innodb-index
innodb_plugin.innodb-timeout
innodb_plugin.innodb_bug21704
innodb_plugin.innodb-lock
innodb_plugin.innodb-zip
innodb_plugin.innodb-replace
innodb_plugin.innodb-index_ucs2
innodb_plugin.innodb_bug52745

innodb_plugin.innodb_bug52745 fails with a segfault

Comment by Mark Callaghan [ 2010-07-25 ]

Re: mtr skips tests from --suite=innodb_plugin for lp:maria/5.2
storage/innodb_plugin has fewer failures and no segfaults:

innodb_plugin.innodb
innodb_plugin.innodb-index
innodb_plugin.innodb-autoinc-44030

Comment by Michael Widenius [ 2010-08-03 ]

Re: mtr skips tests from --suite=innodb_plugin for lp:maria/5.2
Have now pushed into 5.1-release the following:

  • Modified innodb_plugin test suite so that all not disabled tests passes for both innodb_plugin and xtradb
  • Innodb_plugin tests are now run for xtradb by default.
  • Some innodb_plugin tests are temporarly disabled, waiting for a merge with newest xtradb (merge is done and should be pushed in a few days)
  • If one compiles innodb_plugin, then the innodb_plugin test suite will use innodb_plugin (not xtradb)
  • Fixed a bug in innodb_plugin that caused a test to fail.

5.1-release will be merged with 5.1 when we do the next MariaDB 5.1.49 release (should happen shortly)

Comment by Rasmus Johansson (Inactive) [ 2010-08-12 ]

Launchpad bug id: 609813

Generated at Thu Feb 08 06:42:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.