[Bug 792607] [NEW] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

[Dan Christian]

Public bug reported:

First: I'm not a mysql admin (and may be missing something obvious).
mythtv does work, but mythweb does not.  All sql configuration is the
default.  The system has been upgraded to 11.04 from the original 9.04
install.

mythweb dies with an error:  !!NoTrans: SQL Error: Unknown table engine
'InnoDB' [#1286]!!

These errors seem to indicated that the plugin can't be loaded:
# grep -i innodb /var/log/mysql/error.log | tail
110603 11:24:56  InnoDB: Initializing buffer pool, size = 8.0M
110603 11:24:56  InnoDB: Completed initialization of buffer pool
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
110603 11:24:56 [ERROR] Plugin 'InnoDB' init function returned error.
110603 11:24:56 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.


/etc/mysql/my.cnf says that a default innodb file will be created in /var/lib/mysql/. (but doesn't say what files to expect).

# ll /var/lib/mysql/.
total 20508
-rw-r--r-- 1 mysql mysql        0 2011-05-22 14:46 debian-5.1.flag
-rw-rw---- 1 mysql mysql 10485760 2011-01-22 08:39 ibdata1
-rw-rw---- 1 mysql mysql  5242880 2011-01-22 08:39 ib_logfile0
-rw-rw---- 1 mysql mysql  5242880 2009-09-29 14:31 ib_logfile1
drwx------ 2 mysql mysql     4096 2011-05-22 14:47 mysql/
-rw------- 1 mysql mysql        6 2011-05-22 14:47 mysql_upgrade_info
drwx------ 2 mysql mysql    16384 2011-06-03 11:35 mythconverg/
-rw-rw---- 1 mysql mysql        5 2011-06-03 11:24 vonbraun.pid

ProblemType: Bug
DistroRelease: Ubuntu 11.04
Package: mysql-server 5.1.54-1ubuntu4
ProcVersionSignature: Ubuntu 2.6.38-8.42-generic 2.6.38.2
Uname: Linux 2.6.38-8-generic x86_64
NonfreeKernelModules: nvidia
Architecture: amd64
Date: Fri Jun  3 16:05:37 2011
PackageArchitecture: all
ProcEnviron:
 LANGUAGE=en_US:en
 PATH=(custom, user)
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: mysql-5.1
UpgradeStatus: Upgraded to natty on 2011-05-22 (12 days ago)

** Affects: mysql-5.1 (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: amd64 apport-bug natty

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-5.1 in Ubuntu.
https://bugs.launchpad.net/bugs/792607

Title:
  Plugin 'InnoDB' registration as a STORAGE ENGINE failed.