[debian-mysql] Bug#624564: [mysql-server] mysql-server: should error on table creates with unsupported engines

[Török Edwin]

Package: mysql-server
Version: 5.1.56-1
Severity: normal

--- Please enter the report below this line. ---

Mysql turned off InnoDB on startup for some reason [1], and then it
created all further tables as MyISAM.
Even when CREATE TABLE explicitly specified ENGINE=InnoDB.

I think Mysql should give an error if you ask it to create a table, and
it doesn't have that engine enabled.


[1]
I specified innodb_buffer_pool_size = 768M innodb_log_file_size = 256M
in my.cnf, presumably it didn't like the old logfile's size
Confirmed via SHOW ENGINES, InnoDB wasn't there. After removing the
logfiles and restarting InnoDB got enabled again.


--- System information. ---
Architecture: amd64
Kernel:       Linux 2.6.39-rc4-phenom

Debian Release: wheezy/sid
  500 unstable        ftp.ro.debian.org
  500 unstable        ftp.lug.ro
  500 testing         security.debian.org
  500 testing         ftp.ro.debian.org
  500 stable          ftp.ro.debian.org
    1 experimental    ftp.ro.debian.org

--- Package information. ---
Depends               (Version) | Installed
===============================-+-===========
mysql-server-5.1                | 5.1.56-1


Package's Recommends field is empty.

Package's Suggests field is empty.