MySQL Bugs: #55547: InnoDB is not included when configuring by default

Bug #55547	InnoDB is not included when configuring by default
Submitted:	26 Jul 2010 8:12	Modified:	4 Sep 2010 15:30
Reporter:	Alexander Nozdrin	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Compiling	Severity:	S1 (Critical)
Version:	M3 (Celosia), M4 (Dahlia)	OS:	Any
Assigned to:	Magne Mæhre	CPU Architecture:	Any

Description:
When running ./configure.am without any options (with default settings)
InnoDB is not included. That means, for one, the tests just can not
start.

A workaround is to use CMake-build scheme instead of the one
based on GNU auto-tools.

How to repeat:
Get sources
$ cd <mysql src>
$ ./BUILD/autorun.sh
$ ./configure.am

$ cd mysql-test
$ ./mysql-test-run.pl 1st

Thank you for the report.

Verified as described:

$./mtr alias
Logging: ./mtr  alias
MySQL Version 5.6.99
Checking supported features...
 - skipping ndbcluster, mysqld not compiled with ndbcluster
 - skipping SSL, mysqld not compiled with SSL
Collecting tests...
vardir: /users/ssmirnova/blade12/src/mysql-next-mr/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/users/ssmirnova/blade12/src/mysql-next-mr/mysql-test/var'...
Installing system database...
mysql-test-run: *** ERROR: Error executing mysqld --bootstrap
Could not install system database from /users/ssmirnova/blade12/src/mysql-next-mr/mysql-test/var/tmp/bootstrap.sql
see /users/ssmirnova/blade12/src/mysql-next-mr/mysql-test/var/log/bootstrap.log for errors

$cat var/log/bootstrap.log 
/users/ssmirnova/blade12/src/mysql-next-mr/sql/mysqld --no-defaults --bootstrap --basedir=/users/ssmirnova/blade12/src/mysql-next-mr --datadir=/users/ssmirnova/blade12/src/mysql-next-mr/mysql-test/var/install.db --loose-skip-falcon --loose-skip-ndbcluster --tmpdir=/users/ssmirnova/blade12/src/mysql-next-mr/mysql-test/var/tmp/ --core-file --lc-messages-dir=/users/ssmirnova/blade12/src/mysql-next-mr/sql/share/ --character-sets-dir=/users/ssmirnova/blade12/src/mysql-next-mr/sql/share/charsets
100726 10:47:16 [Warning] /users/ssmirnova/blade12/src/mysql-next-mr/sql/.libs/lt-mysqld: unknown option '--loose-skip-falcon'
100726 10:47:16 [Warning] /users/ssmirnova/blade12/src/mysql-next-mr/sql/.libs/lt-mysqld: unknown option '--loose-skip-ndbcluster'
100726 10:47:16 [ERROR] Unknown/unsupported storage engine: InnoDB
100726 10:47:16 [ERROR] Aborting

100726 10:47:16 [Note] /users/ssmirnova/blade12/src/mysql-next-mr/sql/.libs/lt-mysqld: Shutdown complete

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

3101 Magne Mahre	2010-08-11
      Bug #55547 InnoDB is not included when configuring by default
      
      When using autotools to build MySQL, InnoDB is not included
      by default, which causes all tests to fail.
      
      Since autotools is being phased out, and the auto-inclusion
      of InnoDB requires quite a lot of m4 hacking, this fix will
      instead set the default storage engine to MyISAM in the case 
      InnoDB hasn't been built.  This allows the tests to pass, with
      some minor modifications.
     @ mysql-test/t/bootstrap-master.opt
        If InnoDB hasn't been built, the option --skip-innodb
        isn't available.  We prefix with 'loose' to allow the
        option to be used at all times.
     @ sql/mysqld.cc
        If this is the embedded version, MyISAM will be default.
        If InnoDB has not been built, MyISAM will be default.
        Otherwise, InnoDB will be default.

Disregard this last patch.  It's no good

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

3101 Magne Mahre	2010-08-12
      Bug #55547 InnoDB is not included when configuring by default
      
      Added InnoDB to the 'default' plugin group, and modified 
      the autoconf script so the 'default' group is actually 
      built by default.
      
      (i.e  ./configure.am == ./configure.am --plugins=default ,
      instead of being ./configure.am --plugins=none )

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

3110 Magne Mahre	2010-08-18
      Bug #55547 InnoDB is not included when configuring by default
            
      Added InnoDB to the 'default' plugin group, and modified 
      the autoconf script so the 'default' group is actually 
      built by default.
            
      (i.e  ./configure.am == ./configure.am --with-plugins=default ,
      instead of being ./configure.am --with-plugins=none )

Pushed into mysql-5.5 5.5.6-m3 (revid:alik@ibmvm-20100825092002-2yvkb3iwu43ycpnm) (version source revid:alik@ibmvm-20100825092002-2yvkb3iwu43ycpnm) (merge vers: 5.5.6-m3) (pib:20)

A note has been added to the 5.5.6 changelog: 

        The <literal>InnoDB</literal> storage engine was not included                                                                                      
        in the default installation when using                                                                                                             
        the <command>configure</command> script.

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@sun.com-20100830082732-n2eyijnv86exc5ci) (version source revid:alik@sun.com-20100830082732-n2eyijnv86exc5ci) (merge vers: 5.6.1-m4) (pib:21)

Pushed into mysql-next-mr (revid:alik@sun.com-20100830082745-n6sh01wlwh3itasv) (version source revid:alik@sun.com-20100830082745-n6sh01wlwh3itasv) (pib:21)

Added to the 5.6.1 changelog