Bug #45700 MTR v1 --start-and-exit --default-storage-engine=Innodb is froken
Submitted: 24 Jun 2009 12:22 Modified: 19 Dec 2009 0:12
Reporter: Philip Stoev Email Updates:
Status: Closed Impact on me:
Category:Tools: MTR / mysql-test-run Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Bjørn Munch CPU Architecture:Any

[24 Jun 2009 12:22] Philip Stoev

It is not possible to use --start-and-exit to start a server with --mysqld=--default-storage-engine=Innodb

This is a recent regression...

How to repeat:
MTR_VERSION=1 perl mysql-test-run.pl --mysqld=--innodb --mysqld=--default-storage-engine=Innodb --start-and-exit 1st

  WARNING: Using mysql-test-run.pl version 1!
Logging: lib/v1/mysql-test-run.pl --mysqld=--innodb --mysqld=--default-storage-engine=Innodb --start-and-exit innodb
090624 15:21:48 [Note] Plugin 'FEDERATED' is disabled.
090624 15:21:48 [Warning] Forcing shutdown of 1 plugins
MySQL Version 5.4.4
Using dynamic switching of binlog format
Using default engine 'Innodb'
Skipping ndbcluster, mysqld not compiled with ndbcluster
Setting mysqld to support SSL connections
Binaries are debug compiled
mysql-test-run: WARNING: Could not find all required instance manager binaries, all im tests will fail, use --skip-im to continue without instance manager
Using MTR_BUILD_THREAD      = 0
Using MASTER_MYPORT         = 9306
Using MASTER_MYPORT1        = 9307
Using SLAVE_MYPORT          = 9308
Using SLAVE_MYPORT1         = 9309
Using SLAVE_MYPORT2         = 9310
Using IM_PORT               = 9313
Using IM_MYSQLD1_PORT       = 9314
Using IM_MYSQLD2_PORT       = 9315
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
Installing Master Database

TEST                           RESULT         TIME (ms)

main.innodb                    [ skipped ]   No innodb support
Stopping All Servers
All 0 tests were successful.
The servers were restarted 0 times

Suggested fix:
Can we somehow prevent MTRv1 from suffering any future regressions due to changes elsewhere in MTR?
[17 Jul 2009 9:12] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:


2808 Bjorn Munch	2009-07-17
      Bug #45700 MTR v1 --start-and-exit --default-storage-engine=Innodb is froken
      Change of variable states in Bug 19027 was not backported to v1
      Changed ne "TRUE" to eq "OFF"
[17 Jul 2009 9:18] Bjørn Munch
The fix for Bug #19027 necessitated a small change to MTR but this was not backported to v1 by the committer, hence it stopped working despite not being changed.
[20 Jul 2009 9:26] Joerg Bruehe
Patch looks fine.
[20 Jul 2009 9:30] Bjørn Munch
Pushed to 5.1-mtr, will proceed to get this and others into newly created azalea-mtr
[3 Sep 2009 17:12] Bugs System
Pushed into 5.1.40 (revid:bjorn.munch@sun.com-20090903170735-679d64zp580wl39j) (version source revid:bjorn.munch@sun.com-20090903170735-679d64zp580wl39j) (merge vers: 5.1.40) (pib:11)
[4 Sep 2009 0:52] Paul DuBois
Test suite change. No changelog entry needed.

Setting report to NDI pending push into 5.4.x.
[30 Sep 2009 8:17] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20090929093622-1mooerbh12e97zux) (version source revid:alik@sun.com-20090922182109-vs5ign07cwht12z6) (merge vers: 6.0.14-alpha) (pib:11)
[30 Sep 2009 8:20] Bugs System
Pushed into 5.4.5-beta (revid:alik@sun.com-20090925094254-tjl9eajkzwzgthoe) (version source revid:alik@sun.com-20090922142453-x275o41whpyezh4q) (merge vers: 5.4.4-beta) (pib:11)
[30 Sep 2009 19:43] Paul DuBois
Test suite change. No changelog entry needed.
[18 Dec 2009 10:27] Bugs System
Pushed into 5.1.41-ndb-7.1.0 (revid:jonas@mysql.com-20091218102229-64tk47xonu3dv6r6) (version source revid:jonas@mysql.com-20091218095730-26gwjidfsdw45dto) (merge vers: 5.1.41-ndb-7.1.0) (pib:15)
[18 Dec 2009 10:43] Bugs System
Pushed into 5.1.41-ndb-6.2.19 (revid:jonas@mysql.com-20091218100224-vtzr0fahhsuhjsmt) (version source revid:jonas@mysql.com-20091217101452-qwzyaig50w74xmye) (merge vers: 5.1.41-ndb-6.2.19) (pib:15)
[18 Dec 2009 10:58] Bugs System
Pushed into 5.1.41-ndb-6.3.31 (revid:jonas@mysql.com-20091218100616-75d9tek96o6ob6k0) (version source revid:jonas@mysql.com-20091217154335-290no45qdins5bwo) (merge vers: 5.1.41-ndb-6.3.31) (pib:15)
[18 Dec 2009 11:12] Bugs System
Pushed into 5.1.41-ndb-7.0.11 (revid:jonas@mysql.com-20091218101303-ga32mrnr15jsa606) (version source revid:jonas@mysql.com-20091218064304-ezreonykd9f4kelk) (merge vers: 5.1.41-ndb-7.0.11) (pib:15)