Ubuntu
mysql-dfsg-5.1 package

mysql-server-5.1 does not include the InnoDB engine

Bug #488373 reported by Gary
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
mysql-dfsg-5.1 (Ubuntu)
Invalid
Undecided
Unassigned

Bug Description

root@zabbix:~# dpkg -l | grep mysql-server
ii mysql-server 5.1.37-1ubuntu5 MySQL database server (metapackage depending
ii mysql-server-5.1 5.1.37-1ubuntu5 MySQL database server binaries
ii mysql-server-core-5.1 5.1.37-1ubuntu5 MySQL database core server files

root@zabbix:~# uname -a
Linux zabbix 2.6.31-14-server #48-Ubuntu SMP Fri Oct 16 15:07:34 UTC 2009 x86_64 GNU/Linux

root@zabbix:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12283
Server version: 5.1.37-1ubuntu5-log (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SHOW ENGINES\G
*************************** 1. row ***************************
      Engine: MyISAM
     Support: DEFAULT
     Comment: Default engine as of MySQL 3.23 with great performance
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 2. row ***************************
      Engine: MRG_MYISAM
     Support: YES
     Comment: Collection of identical MyISAM tables
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 3. row ***************************
      Engine: BLACKHOLE
     Support: YES
     Comment: /dev/null storage engine (anything you write to it disappears)
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 4. row ***************************
      Engine: CSV
     Support: YES
     Comment: CSV storage engine
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 5. row ***************************
      Engine: MEMORY
     Support: YES
     Comment: Hash based, stored in memory, useful for temporary tables
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 6. row ***************************
      Engine: FEDERATED
     Support: NO
     Comment: Federated MySQL storage engine
Transactions: NULL
          XA: NULL
  Savepoints: NULL
*************************** 7. row ***************************
      Engine: ARCHIVE
     Support: YES
     Comment: Archive storage engine
Transactions: NO
          XA: NO
  Savepoints: NO
7 rows in set (0.00 sec)

mysql>

ProblemType: Bug
Architecture: amd64
Date: Wed Nov 25 18:39:16 2009
DistroRelease: Ubuntu 9.10
MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
 [mysqld_safe]
 syslog
MySQLVarLibDirListing: ['debian-5.1.flag', 'ib_logfile0', 'ib_logfile1', 'ibdata1', 'mysql', 'mysql_upgrade_info', 'zabbix']
Package: mysql-server-5.1 5.1.37-1ubuntu5
ProcEnviron:
 PATH=(custom, no user)
 LANG=en_GB.UTF-8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 2.6.31-14.48-server
SourcePackage: mysql-dfsg-5.1
Uname: Linux 2.6.31-14-server x86_64

Revision history for this message
Gary (thevoid) wrote :
Revision history for this message
Ante Karamatić (ivoks) wrote :

Anything in /etc/mysql/conf.d/?

Gary (thevoid)
Changed in mysql-dfsg-5.1 (Ubuntu):
status: New → Invalid
Ancoron Luziferis (ancoron)
Changed in mysql-dfsg-5.1 (Ubuntu):
status: Invalid → New
Revision history for this message
Ancoron Luziferis (ancoron) wrote :

I have this problem since I updated package from version 5.1.37-1ubuntu5 to 5.1.37-1ubuntu5.1. InnoDB supported silently dissappeared:

$ mysql -u root -p -e 'SHOW ENGINES\G' | egrep '(Engine|Support): '
Enter password:
      Engine: MyISAM
     Support: DEFAULT
      Engine: MRG_MYISAM
     Support: YES
      Engine: BLACKHOLE
     Support: YES
      Engine: CSV
     Support: YES
      Engine: MEMORY
     Support: YES
      Engine: FEDERATED
     Support: NO
      Engine: ARCHIVE
     Support: YES

My InnoDB configuration is:

$ grep 'innodb' /etc/mysql/my.cnf
innodb
innodb_data_home_dir = /srv/mysql/innodb
innodb_data_file_path = ibdata1:2G:autoextend
innodb_autoextend_increment = 64M
innodb_status_file = 1
innodb_thread_concurrency = 4
innodb_file_per_table
innodb_support_xa = 0
innodb_buffer_pool_size = 2G
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 512M
innodb_log_buffer_size = 64M
innodb_flush_log_at_trx_commit = 0
innodb_lock_wait_timeout = 50

There is nothing in /etc/mysql/conf.d/ except the file from mysql-server-5.1 package:

$ dpkg -S /etc/mysql/conf.d/*
mysql-server-5.1: /etc/mysql/conf.d/mysqld_safe_syslog.cnf

AppArmor is also realigned for my configuration and doesn't complain.

Revision history for this message
Ancoron Luziferis (ancoron) wrote :

Well, problem solved.

The problem was I moved the database files and MySQL doesn't like that (excerpt from /var/log/daemon.log):

Feb 11 12:24:40 spawn mysqld: InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
Feb 11 12:24:40 spawn mysqld: InnoDB: than specified in the .cnf file 0 268435456 bytes!
Feb 11 12:24:40 spawn mysqld: 100211 12:24:40 [ERROR] Plugin 'InnoDB' init function returned error.
Feb 11 12:24:40 spawn mysqld: 100211 12:24:40 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

After some postwork I have my InnoDB support back.

Changed in mysql-dfsg-5.1 (Ubuntu):
status: New → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

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