diff options
Diffstat (limited to 'zarb-ml/mageia-dev/2012-January/011012.html')
| -rw-r--r-- | zarb-ml/mageia-dev/2012-January/011012.html | 213 |
1 files changed, 213 insertions, 0 deletions
diff --git a/zarb-ml/mageia-dev/2012-January/011012.html b/zarb-ml/mageia-dev/2012-January/011012.html new file mode 100644 index 000000000..cd290d2b2 --- /dev/null +++ b/zarb-ml/mageia-dev/2012-January/011012.html @@ -0,0 +1,213 @@ +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> +<HTML> + <HEAD> + <TITLE> [Mageia-dev] Numerous mariadb issues today. + </TITLE> + <LINK REL="Index" HREF="index.html" > + <LINK REL="made" HREF="mailto:mageia-dev%40mageia.org?Subject=Re%3A%20%5BMageia-dev%5D%20Numerous%20mariadb%20issues%20today.&In-Reply-To=%3C4F06CB38.50807%40colin.guthr.ie%3E"> + <META NAME="robots" CONTENT="index,nofollow"> + <META http-equiv="Content-Type" content="text/html; charset=us-ascii"> + <LINK REL="Previous" HREF="011112.html"> + <LINK REL="Next" HREF="011029.html"> + </HEAD> + <BODY BGCOLOR="#ffffff"> + <H1>[Mageia-dev] Numerous mariadb issues today.</H1> + <B>Colin Guthrie</B> + <A HREF="mailto:mageia-dev%40mageia.org?Subject=Re%3A%20%5BMageia-dev%5D%20Numerous%20mariadb%20issues%20today.&In-Reply-To=%3C4F06CB38.50807%40colin.guthr.ie%3E" + TITLE="[Mageia-dev] Numerous mariadb issues today.">mageia at colin.guthr.ie + </A><BR> + <I>Fri Jan 6 11:21:44 CET 2012</I> + <P><UL> + <LI>Previous message: <A HREF="011112.html">[Mageia-dev] Orphans - those poor orphans . . . +</A></li> + <LI>Next message: <A HREF="011029.html">[Mageia-dev] Numerous mariadb issues today. +</A></li> + <LI> <B>Messages sorted by:</B> + <a href="date.html#11012">[ date ]</a> + <a href="thread.html#11012">[ thread ]</a> + <a href="subject.html#11012">[ subject ]</a> + <a href="author.html#11012">[ author ]</a> + </LI> + </UL> + <HR> +<!--beginarticle--> +<PRE>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 (<A HREF="http://www.percona.com">http://www.percona.com</A>) 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 +<A HREF="http://colin.guthr.ie/">http://colin.guthr.ie/</A> + +Day Job: + Tribalogic Limited <A HREF="http://www.tribalogic.net/">http://www.tribalogic.net/</A> +Open Source: + Mageia Contributor <A HREF="http://www.mageia.org/">http://www.mageia.org/</A> + PulseAudio Hacker <A HREF="http://www.pulseaudio.org/">http://www.pulseaudio.org/</A> + Trac Hacker <A HREF="http://trac.edgewall.org/">http://trac.edgewall.org/</A> +</PRE> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +<!--endarticle--> + <HR> + <P><UL> + <!--threads--> + <LI>Previous message: <A HREF="011112.html">[Mageia-dev] Orphans - those poor orphans . . . +</A></li> + <LI>Next message: <A HREF="011029.html">[Mageia-dev] Numerous mariadb issues today. +</A></li> + <LI> <B>Messages sorted by:</B> + <a href="date.html#11012">[ date ]</a> + <a href="thread.html#11012">[ thread ]</a> + <a href="subject.html#11012">[ subject ]</a> + <a href="author.html#11012">[ author ]</a> + </LI> + </UL> + +<hr> +<a href="https://www.mageia.org/mailman/listinfo/mageia-dev">More information about the Mageia-dev +mailing list</a><br> +</body></html> |