MySQL 5.1 support for innodb plugin broken

Bug #378831 reported by Katherine Rossiter
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
mysql-dfsg-5.1 (Ubuntu)
Fix Released
Undecided
Unassigned
Declined for Jaunty by Mathias Gug
Declined for Karmic by Mathias Gug

Bug Description

Binary package hint: mysql-server-5.1

MySQL 5.1.31 and 5.1.32 contain a bug that prevents users from loading the InnoDB plugin which replaces the builtin InnoDB.

http://bugs.mysql.com/bug.php?id=42610

This issue is fixed upstream, and a new build of MySQL 5.1.33+ is required for Jaunty+

Description: Ubuntu 9.04
Release: 9.04

mysql-server-5.1:
  Installed: 5.1.31-1ubuntu2
  Candidate: 5.1.31-1ubuntu2
  Version table:
 *** 5.1.31-1ubuntu2 0
        500 http://us.archive.ubuntu.com jaunty/universe Packages
        100 /var/lib/dpkg/status

Changed in mysql-dfsg-5.1 (Ubuntu):
status: New → Confirmed
Revision history for this message
Mathias Gug (mathiaz) wrote :

5.1.37 is in karmic, thus marking this fixed released.

Changed in mysql-dfsg-5.1 (Ubuntu):
status: Confirmed → Fix Released
Revision history for this message
Mathias Gug (mathiaz) wrote :

Declining for jaunty as well - the confirmed bug affects only users wanting to use the innodb plugin instead of the builtin version.

Revision history for this message
Rafal Zawadzki (bluszcz) wrote :

Lack of InnoDB.

From today installation:

mysql> show engines;
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
7 rows in set (0.00 sec)

mysql>

mysql> select version();
+-----------------+
| version() |
+-----------------+
| 5.1.37-1ubuntu5 |
+-----------------+
1 row in set (0.00 sec)

mysql>

dpkg -l |grep mysql
ii libdbd-mysql-perl 4.011-1ubuntu1 A Perl5 database interface to the MySQL data
ii libmysqlclient16 5.1.37-1ubuntu5 MySQL database client library
ii mysql-client-5.1 5.1.37-1ubuntu5 MySQL database client binaries
ii mysql-common 5.1.37-1ubuntu5 MySQL database common files (e.g. /etc/mysql
ii mysql-server-5.1 5.1.37-1ubuntu5 MySQL database server binaries
ii mysql-server-core-5.1

Revision history for this message
Mathias Gug (mathiaz) wrote :

A clean installation of karmic shows InnoDB as an available engine:

mysql> show engines;
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
8 rows in set (0.00 sec)

mysql> select version();
+-----------------+
| version() |
+-----------------+
| 5.1.37-1ubuntu5 |
+-----------------+
1 row in set (0.00 sec)

Could you make sure that innodb hasn't be disable in the configuration file?

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.