Your message dated Wed, 21 Mar 2012 06:34:45 +0000
with message-id <[email protected]>
and subject line solved
has caused the Debian Bug report #624564,
regarding [mysql-server] mysql-server: should error on table creates with
unsupported engines
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
624564: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=624564
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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.
--- End Message ---
--- Begin Message ---
You should look at the NO_ENGINE_SUBSTITUTION sql_mode. I think it would
solve all your issues.
--- End Message ---
