zarb-ml/mageia-dev/2011-November/009615.html


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
 <HEAD>
   <TITLE> [Mageia-dev] HEADSUP: mariadb available for testing
   </TITLE>
   <LINK REL="Index" HREF="index.html" >
   <LINK REL="made" HREF="mailto:mageia-dev%40mageia.org?Subject=Re%3A%20%5BMageia-dev%5D%20HEADSUP%3A%20mariadb%20available%20for%20testing&In-Reply-To=%3CBC90B9B4-C498-43E6-AA03-1193B088B05E%40ono.com%3E">
   <META NAME="robots" CONTENT="index,nofollow">
   <META http-equiv="Content-Type" content="text/html; charset=us-ascii">
   <LINK REL="Previous"  HREF="009609.html">
   <LINK REL="Next"  HREF="009619.html">
 </HEAD>
 <BODY BGCOLOR="#ffffff">
   <H1>[Mageia-dev] HEADSUP: mariadb available for testing</H1>
    <B>JA Magallon</B> 
    <A HREF="mailto:mageia-dev%40mageia.org?Subject=Re%3A%20%5BMageia-dev%5D%20HEADSUP%3A%20mariadb%20available%20for%20testing&In-Reply-To=%3CBC90B9B4-C498-43E6-AA03-1193B088B05E%40ono.com%3E"
       TITLE="[Mageia-dev] HEADSUP: mariadb available for testing">jamagallon at ono.com
       </A><BR>
    <I>Fri Nov 18 15:29:51 CET 2011</I>
    <P><UL>
        <LI>Previous message: <A HREF="009609.html">[Mageia-dev] HEADSUP: mariadb available for testing
</A></li>
        <LI>Next message: <A HREF="009619.html">[Mageia-dev] HEADSUP: mariadb available for testing
</A></li>
         <LI> <B>Messages sorted by:</B> 
              <a href="date.html#9615">[ date ]</a>
              <a href="thread.html#9615">[ thread ]</a>
              <a href="subject.html#9615">[ subject ]</a>
              <a href="author.html#9615">[ author ]</a>
         </LI>
       </UL>
    <HR>  
<!--beginarticle-->
<PRE>
On 2011.11.18, at 13:15, Maarten Vanraes wrote:

&gt;<i> Op vrijdag 18 november 2011 12:55:36 schreef Sam Bailey:
</I>&gt;<i> [...]
</I>&gt;&gt;<i> I was testing on mga1 with basic rebuild only. I'll be setting up a
</I>&gt;&gt;<i> cauldron test environment this weekend though to compare.
</I>&gt;<i> 
</I>&gt;<i> awesome
</I>&gt;<i> 
</I>&gt;<i> meanwhile, i hear from mariadb, that next week they'll be merging the latest 
</I>&gt;<i> changes from 5.3 branch into it, and that should be the last big push for 5.5 
</I>&gt;<i> branch.
</I>

I got the problem in /etc/rc.d/init.d/mysqld, line 329:

    # Check if the system database should be updated and alert the user.
    NEW_VER=&quot;`$libexecdir/mysqld --version | awk '{ print $3}'`&quot;
    OLD_VER=&quot;`cat $datadir/mysql_upgrade_info`&quot;

    get_mysql_id() {
    MAJOR=&quot;`echo $1|cut -d. -f1`&quot;; MINOR=&quot;`echo $1|cut -d. -f2`&quot;; PATCH=&quot;`echo $1|cut -d. -f3`&quot;
    expr 10000 \* ${MAJOR} + 100 \* ${MINOR} + ${PATCH}
    }

Original MySQL gives (tested on CentOS):

nada:~&gt; /usr/libexec/mysqld --version
/usr/libexec/mysqld  Ver 5.1.52 for unknown-linux-gnu on x86_64 (Source distribution)
nada:~&gt; /usr/libexec/mysqld --version | awk '{ print $3}'
5.1.52

MariaDB:

werewolf:~# /usr/sbin/mysqld --version
/usr/sbin/mysqld  Ver 5.5.15-MariaDB for Linux on x86_64 (Mageia - MariaDB Community Edition (GPL))
werewolf:~# /usr/sbin/mysqld --version | awk '{ print $3}'
5.5.15-MariaDB
werewolf:~# /usr/sbin/mysqld --version | awk '{ print $3}' | cut -d. -f3
15-MariaDB

See the -MariaDB tail in version ? This makes expr fail because PATCH is
not a number.

Quick Hack: change awk to:

/usr/sbin/mysqld --version | cut -d' ' -f4 | cut -d- -f 1

Works both in MySQL and MariaDB.


</PRE>


<!--endarticle-->
    <HR>
    <P><UL>
        <!--threads-->
	<LI>Previous message: <A HREF="009609.html">[Mageia-dev] HEADSUP: mariadb available for testing
</A></li>
	<LI>Next message: <A HREF="009619.html">[Mageia-dev] HEADSUP: mariadb available for testing
</A></li>
         <LI> <B>Messages sorted by:</B> 
              <a href="date.html#9615">[ date ]</a>
              <a href="thread.html#9615">[ thread ]</a>
              <a href="subject.html#9615">[ subject ]</a>
              <a href="author.html#9615">[ 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>