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

[27 Jun 2010 8:56] Elena Stepanova
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.
[28 Jun 2010 10:30] Matthias Leich
This also affects RQG.
At least my tests which need InnoDB do no more work.
[28 Jun 2010 10:41] Vladislav Vaintroub
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
[28 Jun 2010 14:54] Jon Olav Hauglid
This prevents RQG tests in PB2 from running. Hope this can be fixed soon.
[30 Jun 2010 11:37] 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:

  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.
[30 Jun 2010 11:40] Jon Olav Hauglid
Temporary patch pushed to mysql-trunk-runtime so that we could get
RQG tests on this tree running again in pb2.
[15 Jul 2010 14:50] Bjørn Munch
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.
[16 Jul 2010 8:24] 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:

  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
[16 Jul 2010 8:33] Bjørn Munch
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.
[30 Jul 2010 7:05] John Embretsen
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
[4 Aug 2010 7:52] Bugs System
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)
[4 Aug 2010 8:06] Bugs System
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)
[4 Aug 2010 8:22] Bugs System
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)
[4 Aug 2010 9:02] Bugs System
Pushed into mysql-next-mr (revid:alik@ibmvm-20100804081630-ntapn8bf9pko9vj3) (version source revid:marko.makela@oracle.com-20100621094008-o9fa153s3f09merw) (pib:20)
[4 Aug 2010 20:02] Paul DuBois
Changes to test suite. No changelog entry needed.
[16 Aug 2010 6:30] Bugs System
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)
[16 Aug 2010 6:35] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100816062819-bluwgdq8q4xysmlg) (version source revid:alik@sun.com-20100816062612-enatdwnv809iw3s9) (pib:20)

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.078 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.