MySQL Bugs: #54835: MTR version 1 cannot start server - bootstrap reports unknown InnoDB engine

Bug #54835	MTR version 1 cannot start server - bootstrap reports unknown InnoDB engine
Submitted:	27 Jun 2010 8:56	Modified:	20 Aug 2010 14:47
Reporter:	Elena Stepanova	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Tools: MTR / mysql-test-run	Severity:	S3 (Non-critical)
Version:	5.5.5-m3	OS:	Any
Assigned to:	Bjørn Munch	CPU Architecture:	Any

Description:
MTR version 1 runs bootstrap with --loose-skip-innodb option, which causes startup abort.

MTR output:

...
Removing Stale Files
Creating Directories
Installing Master Database
mysql-test-run: *** ERROR: Error executing mysqld --bootstrap
Could not install system database from bin64_555-m3/mysql-test/var/tmp/bootstrap.sql

bootstrap.log:

bin64_555-m3/bin/mysqld --no-defaults --bootstrap --basedir=bin64_555-m3 --datadir=bin64_555-m3/mysql-test/var/master-data --loose-skip-innodb --loose-skip-ndbcluster --tmpdir=. --core-file --lc-messages-dir=bin64_555-m3/share --character-sets-dir=bin64_555-m3/share/charsets
100627 10:53:09 [Note] Buffered information: Performance schema disabled (reason: start parameters).

100627 10:53:09 [Note] Plugin 'FEDERATED' is disabled.
100627 10:53:09 [Note] Plugin 'InnoDB' is disabled.
100627 10:53:09 [Warning] bin64_555-m3/bin/mysqld: unknown option '--loose-skip-ndbcluster'
100627 10:53:09 [ERROR] Unknown/unsupported storage engine: InnoDB
100627 10:53:09 [ERROR] Aborting

100627 10:53:09 [Note] bin64_555-m3/bin/mysqld: Shutdown complete

How to repeat:
export MTR_VERSION=1
perl ./mysql-test-run.pl --start-and-exit 1st

Suggested fix:
Remove --loose-skip-innodb from the list of hardcoded server startup options.

This also affects RQG.
At least my tests which need InnoDB do no more work.

It is probably easily fixed by adding --default-storage-engine=myisam to mysqld --bootstrap command line .Windows build implemented this trick recently, it also runs mysqld --bootstrap for the "initial_database" target

This prevents RQG tests in PB2 from running. Hope this can be fixed soon.

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

3068 Jon Olav Hauglid	2010-06-30
      Temporary fix for bug#54835 
      MTR version 1 cannot start server - bootstrap reports unknown InnoDB engine
      
      Removes --loose-skip-innodb from the list of server startup options.

Temporary patch pushed to mysql-trunk-runtime so that we could get
RQG tests on this tree running again in pb2.

Jon Olav's "temporary fix" to the mysql-trunk-runtime tree is actually the correct way to fix this. It's just a case of backporting the change done as part of WL #5349 from MTR v2 to v1.

If this tree isn't being merged soon, I can push to the -mtr trees which are planned merged to main branches soon.

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

2955 Bjorn Munch	2010-07-16
      Bug #54835 MTR version 1 cannot start server - bootstrap reports unknown InnoDB engine
      Remove --loose-skip-innodb from startup options
      This is a simple backport of change done in WL #5349
      Same as shown as "temporary fix", cherry picked to -mtr branch

Pushed to mysql-trunk-mtr and mysql-next-mr-mtr. I consider this a simple backport of an existing fix so not worthy of review.

Note that Jon Olav's temporary fix was merged to main-bugfixing branches 2010-07-29:

 - mysql-trunk-bugfixing
    - revid kostja@sun.com-20100729101813-7d64i478hyazwgy5
 - mysql-next-mr-bugfixing
    - revid kostja@sun.com-20100729110624-vrs3enxg4xlf0nvl

Pushed into mysql-trunk 5.5.6-m3 (revid:alik@sun.com-20100731131027-1n61gseejyxsqk5d) (version source revid:marko.makela@oracle.com-20100621094008-o9fa153s3f09merw) (merge vers: 5.1.49) (pib:18)

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:marko.makela@oracle.com-20100621094008-o9fa153s3f09merw) (merge vers: 5.1.49) (pib:18)

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804081533-c1d3rbipo9e8rt1s) (version source revid:marko.makela@oracle.com-20100621094008-o9fa153s3f09merw) (merge vers: 5.1.49) (pib:18)

Pushed into mysql-next-mr (revid:alik@ibmvm-20100804081630-ntapn8bf9pko9vj3) (version source revid:marko.makela@oracle.com-20100621094008-o9fa153s3f09merw) (pib:20)

Changes to test suite. No changelog entry needed.

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@sun.com-20100816062701-qo9dpnk5tkt1pksb) (version source revid:alik@sun.com-20100816062603-xc16eftmv7rmktyq) (merge vers: 5.6.1-m4) (pib:20)

Pushed into mysql-next-mr (revid:alik@sun.com-20100816062819-bluwgdq8q4xysmlg) (version source revid:alik@sun.com-20100816062612-enatdwnv809iw3s9) (pib:20)