Bug #21664 InnoDb storage engine gets disabled with 5.1.11-beta Tarball

• Submitted: 15 Aug 2006 22:31
• Modified: 16 Aug 2006 16:41
• Reporter: lotusxxl
• Status: Closed
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.1.11
• OS: Linux (Linux)
• Assigned to: MySQL Verification Team
• CPU Architecture: Any
• Tags: innodb

[15 Aug 2006 22:31] lotusxxl

Description:
Innodb gets disabled with 5.1.11 compiled version.

Tarball (in 5.1 both Unix & Windows, tar.gz)		5.1.11-beta	20.3M 

Only this engines ar enabled: CSV, MRG_MYISAM, MEMORY, MyISAM.

How to repeat:
If enable innodb startup-options in my.cnf mysql server doesn't start.

Error log says: [ERROR] /usr/local/mysql/libexec/mysqld: unknown variable 'innodb_data_home_dir=/usr/local/mysql/var/'

If start mysql without my.cnf and show storage engines, innodb doesn't enabled.

[15 Aug 2006 22:59] lotusxxl

With 5.1.9 version too.

[15 Aug 2006 23:48] MySQL Verification Team

Thank you for the bug report. I was unable to repeat the behavior reported
I downloaded the below tarball and installed according the Manual instructions:

-rw-r--r--  1 miguel users 65350254 2006-08-15 20:24 mysql-5.1.11-beta-linux-i686-glibc23.tar.gz

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.1.11-beta

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show variables like "%have_inno%";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_innodb   | YES   |
+---------------+-------+
1 row in set (0.01 sec)

mysql>

[16 Aug 2006 10:47] lotusxxl

This bug is with source downloads.

[16 Aug 2006 16:02] Heikki Tuuri

Lotus,

5.1 source you must configure --with-innodb:

./configure --with-innodb

Regards,

Heikki

[16 Aug 2006 16:41] lotusxxl

Ok, thanks. But in documentataion doesn't say nothing.