Description of problem: Following update of MariaDB from 5.5.23-4.mga2 to 5.5.25-1.mga2, the server failed to start. The log file contained: 120729 13:47:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/ mysql 120729 13:47:57 [Note] Plugin 'PBXT' is disabled. 120729 13:47:57 [Note] Plugin 'InnoDB' is disabled. 120729 13:47:57 [ERROR] Unknown/unsupported storage engine: InnoDB 120729 13:47:57 [ERROR] Aborting repeated many times as the service tried to restart. The config file /etc/my.cnf contained the following relevant lines: #default-storage-engine = InnoDB skip-innodb It seems that in the new 5.5.25 version of MariaDB InnoDB is the default storage engine and the server cannot start if InnoDB is disabled - this was not a problem in 5.5.23. The solution was to change the two lines to read: default-storage-engine = MyISAM skip-innodb ie to explicitly set a default engine which is not InnoDB. Version-Release number of selected component (if applicable): How reproducible: Not tested on any other system but reproducible on this machine. Steps to Reproduce: 1. Configure MariaDB as documented above 2. Update MariaDB to 5.5.25 3.
Assignee: bugsquad => alien
I don't see the problem here. Default my.cnf doesn't disable InnoDB. If you disabled it manually then you also have to change default engine. Even MySQL on Mageia 1 doesn't disable InnoDB, so you had to do it manually.
Status: NEW => RESOLVEDCC: (none) => sander.lepikResolution: (none) => WORKSFORMEAssignee: alien => bugsquad
I agree that my my.cnf file is illogical, at least since InnoDB became the default engine (mysql 5.5.5?). However it has worked for at least five years, first on mysql/Mandriva and right up to the last Mageia version 5.5.23. I have now documented the change here, so hopefully anyone else with a similar setup will be able to find the solution ;-)
actually, it might be possible that 5.5.23 had forgotten to use innodb as default. but it is/was definately the idea that 5.5 branch, since GA, should have had innodb as default.
CC: (none) => alien