[Mageia-dev] Numerous mariadb issues today.

Fri Jan 6 11:21:44 CET 2012

Hi,
+
+There are several problems today with mariadb, some more serious than
+others:
+
+Firstly, (a minor problem) the log file:
+Jan  3 14:04:34 jimmy mysqld_safe[10642]: 120103 14:04:34 mysqld_safe
+Logging to '/var/log/mysqld/mysqld.log'.
+Jan  3 14:04:34 jimmy mysqld_safe[10642]: 120103 14:04:34 mysqld_safe
+Starting mysqld daemon with databases from /var/lib/mysql
+Jan  3 14:05:53 jimmy mysqld-prepare-db-dir[11245]: touch: cannot touch
+`/var/log/mysqld.log': Permission denied
+Jan  3 14:05:53 jimmy mysqld-prepare-db-dir[11245]: chown: cannot access
+`/var/log/mysqld.log': No such file or directory
+Jan  3 14:05:53 jimmy mysqld-prepare-db-dir[11245]: chmod: cannot access
+`/var/log/mysqld.log': No such file or directory
+
+As the script is run as the mysql user, it cannot touch the
+(non-existant) log file as the directory is owned by root. Better to do
+this in a %post script to ensure the file is all present and properly
+owned to avoid this error.
+
+
+
+Secondly, several plugins were moved to mariadb-obsolete. I have most of
+my databases stored in innodb format and this was one of the plugins
+moved over. Even when I did install the -obsolete package to get
+ha_innodb back, I couldn't use it:
+
+120106 10:15:02 Percona XtraDB (http://www.percona.com) 1.1.8-20.1
+started; log sequence number 52870027141
+120106 10:15:02 [ERROR] Function 'InnoDB' already exists
+120106 10:15:02 [ERROR] Couldn't load plugin named 'InnoDB' with soname
+'ha_innodb.so'.
+
+Now I believe this is due to XtraDB duplicating the features of InnoDB
+and thus effectively obsoleting it... does this mean I simply shouldn't
+load InnoDB plugin now? Does it mean all the tweaks I made in my.cnf for
+innodb pool sizes etc. now no longer work? What is the fallout from this
+change?
+
+
+Thirdly, federated was changed to fedaratedx, but federated was still
+shipped in the mariadb-obsolete package... Sadly however the default
+my.cnf still tries to load the ha_federated.so by default and activate
+via a "federated" option in default my.cnf. So not only is a plugin
+activated that is not installed, even when you do install
+mariadb-obsolete, the "federated" option seems to no longer work anyway:
+
+120106 10:14:16 [ERROR] /usr/sbin/mysqld: unknown option '--federated'
+
+So the "federated" option and the plugin load itself in my.cnf needs to
+be updated somehow, both in the default my.cnf but also some attempt
+should be made to update existing my.cnf too (with a backup).
+
+
+Col
+
+-- 
+
+Colin Guthrie
+colin(at)mageia.org
+http://colin.guthr.ie/
+
+Day Job:
+  Tribalogic Limited http://www.tribalogic.net/
+Open Source:
+  Mageia Contributor http://www.mageia.org/
+  PulseAudio Hacker http://www.pulseaudio.org/
+  Trac Hacker http://trac.edgewall.org/
+