MySQL Bugs: #45700: MTR v1 --start-and-exit --default-storage-engine=Innodb is froken

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:	None
Category:	Tools: MTR / mysql-test-run	Severity:	S3 (Non-critical)
Version:		OS:	Any
Assigned to:	Bjørn Munch	CPU Architecture:	Any

Description:
Hello,

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?

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:

  http://lists.mysql.com/commits/78921

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"

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.

Patch looks fine.

Pushed to 5.1-mtr, will proceed to get this and others into newly created azalea-mtr

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)

Test suite change. No changelog entry needed.

Setting report to NDI pending push into 5.4.x.

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)

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)

Test suite change. No changelog entry needed.

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)

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)

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)

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)