* [gentoo-dev] News item: MySQL 5.1 bump
@ 2010-02-15 21:21 Robin H. Johnson
2010-02-15 21:32 ` Samuli Suominen
` (5 more replies)
0 siblings, 6 replies; 24+ messages in thread
From: Robin H. Johnson @ 2010-02-15 21:21 UTC (permalink / raw
To: gentoo-dev
[-- Attachment #1: Type: text/plain, Size: 696 bytes --]
This is my last blocker for getting MySQL 5.1 series into ~arch status.
====
itle: MySQL 5.1 unmasking
Author: "Robin H. Johnson" <robbat2@gentoo.rog>
Content-Type: text/plain
Posted: 2010-02-15
Revision: 1
News-Item-Format: 1.0
Display-If-Installed: <dev-db/mysql-5.1
The 5.1 series of MySQL is going to be unmasked at the same time as the release
of this news item. When upgrading from an older major version, you will be
required to rebuild everything linked to the libmysqlclient.so.15.
====
--
Robin Hugh Johnson
Gentoo Linux: Developer, Trustee & Infrastructure Lead
E-Mail : robbat2@gentoo.org
GnuPG FP : 11AC BA4F 4778 E3F6 E4ED F38E B27B 944E 3488 4E85
[-- Attachment #2: Type: application/pgp-signature, Size: 330 bytes --]
^ permalink raw reply [flat|nested] 24+ messages in thread
* Re: [gentoo-dev] News item: MySQL 5.1 bump
2010-02-15 21:21 [gentoo-dev] News item: MySQL 5.1 bump Robin H. Johnson
@ 2010-02-15 21:32 ` Samuli Suominen
2010-02-15 21:41 ` Robin H. Johnson
2010-02-15 21:51 ` [gentoo-dev] " Nikos Chantziaras
` (4 subsequent siblings)
5 siblings, 1 reply; 24+ messages in thread
From: Samuli Suominen @ 2010-02-15 21:32 UTC (permalink / raw
To: gentoo-dev
On 02/15/2010 11:21 PM, Robin H. Johnson wrote:
> This is my last blocker for getting MySQL 5.1 series into ~arch status.
>
> ====
> itle: MySQL 5.1 unmasking
> Author: "Robin H. Johnson" <robbat2@gentoo.rog>
> Content-Type: text/plain
> Posted: 2010-02-15
> Revision: 1
> News-Item-Format: 1.0
> Display-If-Installed: <dev-db/mysql-5.1
>
> The 5.1 series of MySQL is going to be unmasked at the same time as the release
> of this news item. When upgrading from an older major version, you will be
> required to rebuild everything linked to the libmysqlclient.so.15.
You can do this by installing gentoolkit and running:
revdep-rebuild --library libmysqlclient.so.15
> ====
>
Perhaps?
-Samuli
^ permalink raw reply [flat|nested] 24+ messages in thread
* Re: [gentoo-dev] News item: MySQL 5.1 bump
2010-02-15 21:32 ` Samuli Suominen
@ 2010-02-15 21:41 ` Robin H. Johnson
2010-02-16 0:08 ` Thilo Bangert
0 siblings, 1 reply; 24+ messages in thread
From: Robin H. Johnson @ 2010-02-15 21:41 UTC (permalink / raw
To: gentoo-dev
On Mon, Feb 15, 2010 at 11:32:10PM +0200, Samuli Suominen wrote:
> On 02/15/2010 11:21 PM, Robin H. Johnson wrote:
> > This is my last blocker for getting MySQL 5.1 series into ~arch status.
> >
> > ====
> > itle: MySQL 5.1 unmasking
> > Author: "Robin H. Johnson" <robbat2@gentoo.rog>
> > Content-Type: text/plain
> > Posted: 2010-02-15
> > Revision: 1
> > News-Item-Format: 1.0
> > Display-If-Installed: <dev-db/mysql-5.1
> >
> > The 5.1 series of MySQL is going to be unmasked at the same time as the release
> > of this news item. When upgrading from an older major version, you will be
> > required to rebuild everything linked to the libmysqlclient.so.15.
You can do this by installing gentoolkit and running:
# revdep-rebuild --library libmysqlclient.so.15
If you use the Portage 2.2 series, you may also use:
# emerge @preserved-rebuild
--
Robin Hugh Johnson
Gentoo Linux: Developer, Trustee & Infrastructure Lead
E-Mail : robbat2@gentoo.org
GnuPG FP : 11AC BA4F 4778 E3F6 E4ED F38E B27B 944E 3488 4E85
^ permalink raw reply [flat|nested] 24+ messages in thread
* [gentoo-dev] Re: News item: MySQL 5.1 bump
2010-02-15 21:21 [gentoo-dev] News item: MySQL 5.1 bump Robin H. Johnson
2010-02-15 21:32 ` Samuli Suominen
@ 2010-02-15 21:51 ` Nikos Chantziaras
2010-02-15 22:12 ` Robin H. Johnson
2010-02-15 22:03 ` [gentoo-dev] " Ulrich Mueller
` (3 subsequent siblings)
5 siblings, 1 reply; 24+ messages in thread
From: Nikos Chantziaras @ 2010-02-15 21:51 UTC (permalink / raw
To: gentoo-dev
On 02/15/2010 11:21 PM, Robin H. Johnson wrote:
> This is my last blocker for getting MySQL 5.1 series into ~arch status.
>
> ====
> itle: MySQL 5.1 unmasking
> Author: "Robin H. Johnson"<robbat2@gentoo.rog>
> Content-Type: text/plain
> Posted: 2010-02-15
> Revision: 1
> News-Item-Format: 1.0
> Display-If-Installed:<dev-db/mysql-5.1
>
> The 5.1 series of MySQL is going to be unmasked at the same time as the release
> of this news item. When upgrading from an older major version, you will be
> required to rebuild everything linked to the libmysqlclient.so.15.
> ====
I assume "older major version" means 4.x versions and older, not 5.0, right?
^ permalink raw reply [flat|nested] 24+ messages in thread
* Re: [gentoo-dev] News item: MySQL 5.1 bump
2010-02-15 21:21 [gentoo-dev] News item: MySQL 5.1 bump Robin H. Johnson
2010-02-15 21:32 ` Samuli Suominen
2010-02-15 21:51 ` [gentoo-dev] " Nikos Chantziaras
@ 2010-02-15 22:03 ` Ulrich Mueller
2010-02-15 22:06 ` Dawid Węgliński
` (2 subsequent siblings)
5 siblings, 0 replies; 24+ messages in thread
From: Ulrich Mueller @ 2010-02-15 22:03 UTC (permalink / raw
To: gentoo-dev
>>>>> On Mon, 15 Feb 2010, Robin H Johnson wrote:
> itle: MySQL 5.1 unmasking
> Author: "Robin H. Johnson" <robbat2@gentoo.rog>
Typo: ^^^
And the real name shouldn't be quoted (news items aren't e-mail).
Ulrich
^ permalink raw reply [flat|nested] 24+ messages in thread
* Re: [gentoo-dev] News item: MySQL 5.1 bump
2010-02-15 21:21 [gentoo-dev] News item: MySQL 5.1 bump Robin H. Johnson
` (2 preceding siblings ...)
2010-02-15 22:03 ` [gentoo-dev] " Ulrich Mueller
@ 2010-02-15 22:06 ` Dawid Węgliński
2010-02-15 22:15 ` Robin H. Johnson
2010-02-16 0:14 ` Robin H. Johnson
2010-02-21 2:23 ` [gentoo-dev] " Robin H. Johnson
5 siblings, 1 reply; 24+ messages in thread
From: Dawid Węgliński @ 2010-02-15 22:06 UTC (permalink / raw
To: gentoo-dev
On Monday 15 February 2010 22:21:36 Robin H. Johnson wrote:
> This is my last blocker for getting MySQL 5.1 series into ~arch status.
>
> ====
> itle: MySQL 5.1 unmasking
Is there an "upgrade path" for databases itself?
--
Cheers
Dawid Węgliński
^ permalink raw reply [flat|nested] 24+ messages in thread
* Re: [gentoo-dev] Re: News item: MySQL 5.1 bump
2010-02-15 21:51 ` [gentoo-dev] " Nikos Chantziaras
@ 2010-02-15 22:12 ` Robin H. Johnson
2010-02-16 10:27 ` Nikos Chantziaras
0 siblings, 1 reply; 24+ messages in thread
From: Robin H. Johnson @ 2010-02-15 22:12 UTC (permalink / raw
To: gentoo-dev
[-- Attachment #1: Type: text/plain, Size: 1179 bytes --]
On Mon, Feb 15, 2010 at 11:51:59PM +0200, Nikos Chantziaras wrote:
> On 02/15/2010 11:21 PM, Robin H. Johnson wrote:
> >This is my last blocker for getting MySQL 5.1 series into ~arch status.
> >
> >====
> >itle: MySQL 5.1 unmasking
> >Author: "Robin H. Johnson"<robbat2@gentoo.rog>
> >Content-Type: text/plain
> >Posted: 2010-02-15
> >Revision: 1
> >News-Item-Format: 1.0
> >Display-If-Installed:<dev-db/mysql-5.1
> >
> >The 5.1 series of MySQL is going to be unmasked at the same time as the release
> >of this news item. When upgrading from an older major version, you will be
> >required to rebuild everything linked to the libmysqlclient.so.15.
> >====
> I assume "older major version" means 4.x versions and older, not 5.0, right?
The following transitions required rebuilds:
3.23 -> 4.0
4.0 -> 4.1
4.1 -> 5.0
5.0 -> 5.1
5.1 -> 5.[45] don't require anything at present, but 5.x -> 6.0 may.
Major version in the context of upstream MySQL is the first TWO digits.
--
Robin Hugh Johnson
Gentoo Linux: Developer, Trustee & Infrastructure Lead
E-Mail : robbat2@gentoo.org
GnuPG FP : 11AC BA4F 4778 E3F6 E4ED F38E B27B 944E 3488 4E85
[-- Attachment #2: Type: application/pgp-signature, Size: 330 bytes --]
^ permalink raw reply [flat|nested] 24+ messages in thread
* Re: [gentoo-dev] News item: MySQL 5.1 bump
2010-02-15 22:06 ` Dawid Węgliński
@ 2010-02-15 22:15 ` Robin H. Johnson
2010-02-15 22:54 ` Dawid Węgliński
0 siblings, 1 reply; 24+ messages in thread
From: Robin H. Johnson @ 2010-02-15 22:15 UTC (permalink / raw
To: gentoo-dev
[-- Attachment #1: Type: text/plain, Size: 675 bytes --]
On Mon, Feb 15, 2010 at 11:06:37PM +0100, Dawid Węgliński wrote:
> On Monday 15 February 2010 22:21:36 Robin H. Johnson wrote:
> > This is my last blocker for getting MySQL 5.1 series into ~arch status.
> >
> > ====
> > itle: MySQL 5.1 unmasking
>
> Is there an "upgrade path" for databases itself?
The official upgrade docs are:
http://dev.mysql.com/doc/refman/5.1/en/upgrade.html
My unofficial recommendation is just doing a backup before and running
'mysql_upgrade' after.
--
Robin Hugh Johnson
Gentoo Linux: Developer, Trustee & Infrastructure Lead
E-Mail : robbat2@gentoo.org
GnuPG FP : 11AC BA4F 4778 E3F6 E4ED F38E B27B 944E 3488 4E85
[-- Attachment #2: Type: application/pgp-signature, Size: 330 bytes --]
^ permalink raw reply [flat|nested] 24+ messages in thread
* Re: [gentoo-dev] News item: MySQL 5.1 bump
2010-02-15 22:15 ` Robin H. Johnson
@ 2010-02-15 22:54 ` Dawid Węgliński
0 siblings, 0 replies; 24+ messages in thread
From: Dawid Węgliński @ 2010-02-15 22:54 UTC (permalink / raw
To: gentoo-dev
On Monday 15 February 2010 23:15:02 Robin H. Johnson wrote:
> On Mon, Feb 15, 2010 at 11:06:37PM +0100, Dawid Węgliński wrote:
> > On Monday 15 February 2010 22:21:36 Robin H. Johnson wrote:
> > > This is my last blocker for getting MySQL 5.1 series into ~arch status.
> > >
> > > ====
> > > itle: MySQL 5.1 unmasking
> >
> > Is there an "upgrade path" for databases itself?
>
> The official upgrade docs are:
> http://dev.mysql.com/doc/refman/5.1/en/upgrade.html
>
> My unofficial recommendation is just doing a backup before and running
> 'mysql_upgrade' after.
I'd like to see this link in news item. Thanks. ;)
--
Cheers
Dawid Węgliński
^ permalink raw reply [flat|nested] 24+ messages in thread
* Re: [gentoo-dev] News item: MySQL 5.1 bump
2010-02-15 21:41 ` Robin H. Johnson
@ 2010-02-16 0:08 ` Thilo Bangert
0 siblings, 0 replies; 24+ messages in thread
From: Thilo Bangert @ 2010-02-16 0:08 UTC (permalink / raw
To: gentoo-dev
[-- Attachment #1: Type: Text/Plain, Size: 883 bytes --]
"Robin H. Johnson" <robbat2@gentoo.org> said:
> On Mon, Feb 15, 2010 at 11:32:10PM +0200, Samuli Suominen wrote:
> > On 02/15/2010 11:21 PM, Robin H. Johnson wrote:
> > > This is my last blocker for getting MySQL 5.1 series into ~arch
> > > status.
> > >
> > > ====
> > > itle: MySQL 5.1 unmasking
> > > Author: "Robin H. Johnson" <robbat2@gentoo.rog>
> > > Content-Type: text/plain
> > > Posted: 2010-02-15
> > > Revision: 1
> > > News-Item-Format: 1.0
> > > Display-If-Installed: <dev-db/mysql-5.1
> > >
> > > The 5.1 series of MySQL is going to be unmasked at the same time as
> > > the release of this news item. When upgrading from an older major
> > > version, you will be required to rebuild everything linked to the
> > > libmysqlclient.so.15.
>
> You can do this by installing gentoolkit and running:
FQPN: app-portage/gentoolkit
thanks
Thilo
[-- Attachment #2: This is a digitally signed message part. --]
[-- Type: application/pgp-signature, Size: 198 bytes --]
^ permalink raw reply [flat|nested] 24+ messages in thread
* Re: [gentoo-dev] News item: MySQL 5.1 bump
2010-02-15 21:21 [gentoo-dev] News item: MySQL 5.1 bump Robin H. Johnson
` (3 preceding siblings ...)
2010-02-15 22:06 ` Dawid Węgliński
@ 2010-02-16 0:14 ` Robin H. Johnson
2010-02-16 4:20 ` [gentoo-dev] " Duncan
2010-02-21 2:23 ` [gentoo-dev] " Robin H. Johnson
5 siblings, 1 reply; 24+ messages in thread
From: Robin H. Johnson @ 2010-02-16 0:14 UTC (permalink / raw
To: gentoo-dev
[-- Attachment #1: Type: text/plain, Size: 1015 bytes --]
Updated with all of the suggestions thusfar.
====
Title: MySQL 5.1 unmasking and upgrade procedures
Author: Robin H. Johnson <robbat2@gentoo.org>
Content-Type: text/plain
Posted: 2010-02-15
Revision: 2
News-Item-Format: 1.0
Display-If-Installed: <dev-db/mysql-5.1
The 5.1 series of MySQL is going to be unmasked at the same time as the release
of this news item. When upgrading from an older major version (including
5.0), you will be required to rebuild everything linked to the
libmysqlclient.so.15.
You can do this by installing app-portage/gentoolkit and running:
# revdep-rebuild --library libmysqlclient.so.15
If you use the Portage 2.2 series, you may also use:
# emerge @preserved-rebuild
The official upgrade docs are available here:
http://dev.mysql.com/doc/refman/5.1/en/upgrade.html
====
--
Robin Hugh Johnson
Gentoo Linux: Developer, Trustee & Infrastructure Lead
E-Mail : robbat2@gentoo.org
GnuPG FP : 11AC BA4F 4778 E3F6 E4ED F38E B27B 944E 3488 4E85
[-- Attachment #2: Type: application/pgp-signature, Size: 330 bytes --]
^ permalink raw reply [flat|nested] 24+ messages in thread
* [gentoo-dev] Re: News item: MySQL 5.1 bump
2010-02-16 0:14 ` Robin H. Johnson
@ 2010-02-16 4:20 ` Duncan
2010-02-16 4:33 ` Robin H. Johnson
0 siblings, 1 reply; 24+ messages in thread
From: Duncan @ 2010-02-16 4:20 UTC (permalink / raw
To: gentoo-dev
Robin H. Johnson posted on Tue, 16 Feb 2010 00:14:08 +0000 as excerpted:
> Title: MySQL 5.1 unmasking and upgrade procedures Author: Robin H.
> Johnson <robbat2@gentoo.org> Content-Type: text/plain
> Posted: 2010-02-15
> Revision: 2
> News-Item-Format: 1.0
> Display-If-Installed: <dev-db/mysql-5.1
>
> The 5.1 series of MySQL is going to be unmasked at the same time as the
> release of this news item. When upgrading from an older major version
> (including 5.0), you will be required to rebuild everything linked to
> the libmysqlclient.so.15.
>
> You can do this by installing app-portage/gentoolkit and running: #
> revdep-rebuild --library libmysqlclient.so.15
>
> If you use the Portage 2.2 series, you may also use: # emerge
> @preserved-rebuild
>
> The official upgrade docs are available here:
> http://dev.mysql.com/doc/refman/5.1/en/upgrade.html
FWIW, there's a lot of folks running mysql now that weren't before, due to
the kde 4 thing. I'm one of them, so this is of personal interest.
From your reply to Dawid W, it appears that database upgrades will need to
be done as well. Please specifically mention that, perhaps by changing
the reference to the official upgrade docs as so:
"""
Note that existing databases will need converted as well,
again including those upgrading from 5.0 to 5.1.
Details can be found in the official upgrade docs at:
http://dev.mysql.com/doc/refman/5.1/en/upgrade.html
"""
If you wish to put the unofficial upgrade recommendation in too, that
would be fine.
Hopefully that'll cover us users that don't particularly care about
databases, we just want our kde to work... and it'll continue to do so.
=:^) (IOW, are there any particularly different procedures for upgrading
databases in user's $HOME dirs? Perhaps a note for kde users telling them
where their databases are located so they /can/ back them up, etc.)
Thanks!
--
Duncan - List replies preferred. No HTML msgs.
"Every nonfree program has a lord, a master --
and if you use the program, he is your master." Richard Stallman
^ permalink raw reply [flat|nested] 24+ messages in thread
* Re: [gentoo-dev] Re: News item: MySQL 5.1 bump
2010-02-16 4:20 ` [gentoo-dev] " Duncan
@ 2010-02-16 4:33 ` Robin H. Johnson
2010-02-16 6:11 ` Duncan
0 siblings, 1 reply; 24+ messages in thread
From: Robin H. Johnson @ 2010-02-16 4:33 UTC (permalink / raw
To: gentoo-dev
On Tue, Feb 16, 2010 at 04:20:27AM +0000, Duncan wrote:
> """
> Note that existing databases will need converted as well,
> again including those upgrading from 5.0 to 5.1.
> Details can be found in the official upgrade docs at:
> http://dev.mysql.com/doc/refman/5.1/en/upgrade.html
> """
_may_ need to be converted, not _will_.
> If you wish to put the unofficial upgrade recommendation in too, that
> would be fine.
That would encourage users not to read the above document.
> Hopefully that'll cover us users that don't particularly care about
> databases, we just want our kde to work... and it'll continue to do so.
> =:^) (IOW, are there any particularly different procedures for upgrading
> databases in user's $HOME dirs?
- If you're using embedded MySQL (Amarok), you're going to be on your
own.
- If you actually ran mysqld as your own user (Akonadi w/ internal MySQL
instance), use the mysql_upgrade with suitable parameters to connect
to the database (as to what those are, you're the one running it, not
me).
> Perhaps a note for kde users telling them where their databases are
> located so they /can/ back them up, etc.)
I've got no idea where they are located, I just focus on MySQL itself.
I wasn't even aware of Akonadi's usage until a couple of weeks ago.
--
Robin Hugh Johnson
Gentoo Linux: Developer, Trustee & Infrastructure Lead
E-Mail : robbat2@gentoo.org
GnuPG FP : 11AC BA4F 4778 E3F6 E4ED F38E B27B 944E 3488 4E85
^ permalink raw reply [flat|nested] 24+ messages in thread
* [gentoo-dev] Re: News item: MySQL 5.1 bump
2010-02-16 4:33 ` Robin H. Johnson
@ 2010-02-16 6:11 ` Duncan
2010-02-16 6:26 ` Robin H. Johnson
0 siblings, 1 reply; 24+ messages in thread
From: Duncan @ 2010-02-16 6:11 UTC (permalink / raw
To: gentoo-dev
Robin H. Johnson posted on Tue, 16 Feb 2010 04:33:20 +0000 as excerpted:
> On Tue, Feb 16, 2010 at 04:20:27AM +0000, Duncan wrote:
>> """
>> Note that existing databases will need converted as well, again
>> including those upgrading from 5.0 to 5.1. Details can be found in the
>> official upgrade docs at:
>> http://dev.mysql.com/doc/refman/5.1/en/upgrade.html """
> _may_ need to be converted, not _will_.
>
>> If you wish to put the unofficial upgrade recommendation in too, that
>> would be fine.
> That would encourage users not to read the above document.
Agreed.
>> Hopefully that'll cover us users that don't particularly care about
>> databases, we just want our kde to work... and it'll continue to do so.
>> =:^) (IOW, are there any particularly different procedures for
>> upgrading databases in user's $HOME dirs?
> - If you're using embedded MySQL (Amarok), you're going to be on your
> own.
I'm not going there. Suffice it to say I'm no longer an amarok user.
> - If you actually ran mysqld as your own user (Akonadi w/ internal MySQL
> instance), use the mysql_upgrade with suitable parameters to connect
> to the database (as to what those are, you're the one running it, not
> me).
It's automagic from here. I just run kde. What it does, I don't know. I
just don't want it to break! (And upgrade implications will get worse
with kde 4.5 in August, as kmail will be depending on it then, and users
tend to get rather cross when their mail store gets hosed! With 4.4, it's
mainly the address book.)
>> Perhaps a note for kde users telling them where their databases are
>> located so they /can/ back them up, etc.)
> I've got no idea where they are located, I just focus on MySQL itself. I
> wasn't even aware of Akonadi's usage until a couple of weeks ago.
What I was suggesting, between the lines, is to coordinate with the kde
project. They may want to create their own upgrade document, which might
be listed in the news release or in a separate one (testing for both mysql
and kde). Hopefully they reply to this thread with whatever their
concerns there might be.
--
Duncan - List replies preferred. No HTML msgs.
"Every nonfree program has a lord, a master --
and if you use the program, he is your master." Richard Stallman
^ permalink raw reply [flat|nested] 24+ messages in thread
* Re: [gentoo-dev] Re: News item: MySQL 5.1 bump
2010-02-16 6:11 ` Duncan
@ 2010-02-16 6:26 ` Robin H. Johnson
2010-02-16 10:14 ` Duncan
2010-02-16 14:37 ` Petteri Räty
0 siblings, 2 replies; 24+ messages in thread
From: Robin H. Johnson @ 2010-02-16 6:26 UTC (permalink / raw
To: gentoo-dev
On Tue, Feb 16, 2010 at 06:11:13AM +0000, Duncan wrote:
> > - If you actually ran mysqld as your own user (Akonadi w/ internal MySQL
> > instance), use the mysql_upgrade with suitable parameters to connect
> > to the database (as to what those are, you're the one running it, not
> > me).
> It's automagic from here. I just run kde. What it does, I don't know. I
> just don't want it to break! (And upgrade implications will get worse
> with kde 4.5 in August, as kmail will be depending on it then, and users
> tend to get rather cross when their mail store gets hosed! With 4.4, it's
> mainly the address book.)
All of that is under the Akonadi side of KDE. I really don't think
storing mail inside MySQL is going to be a good idea.
> >> Perhaps a note for kde users telling them where their databases are
> >> located so they /can/ back them up, etc.)
> > I've got no idea where they are located, I just focus on MySQL itself. I
> > wasn't even aware of Akonadi's usage until a couple of weeks ago.
> What I was suggesting, between the lines, is to coordinate with the kde
> project. They may want to create their own upgrade document, which might
> be listed in the news release or in a separate one (testing for both mysql
> and kde). Hopefully they reply to this thread with whatever their
> concerns there might be.
I announced it 2 weeks ago, on February 1st, Message-Id:
robbat2-20100201T012126-637073772Z@orbis-terrarum.net I just hadn't
gotten to actually doing it yet due to travel and getting sick on my way
home (and Delta doing everything in their power to screw things up, I
still haven't got one of my pieces of luggage back yet).
As soon as the 72 hours on this news announcement are done, I'm going to
be unmasking it. I do expect most of the breakage to come from the
client libraries, and NOT any actual data storage issues. If MySQL
detects that it's not safe to access a table, it does give you a
suitable error to repair the table.
mysql_upgrade is actually really just running 'CHECK TABLE ... FOR
UPGRADE;' && 'REPAIR TABLE ...' on tables with something that needs to
change. Doing a 'REPAIR TABLE ...' globally will cover you if you don't
have any other way to issue the check statements manually.
That is of course me assuming that you have a way to issue 'REPAIR TABLE
...', because that's a critical MySQL command for the DBA/user to know
in managing their data.
--
Robin Hugh Johnson
Gentoo Linux: Developer, Trustee & Infrastructure Lead
E-Mail : robbat2@gentoo.org
GnuPG FP : 11AC BA4F 4778 E3F6 E4ED F38E B27B 944E 3488 4E85
^ permalink raw reply [flat|nested] 24+ messages in thread
* [gentoo-dev] Re: News item: MySQL 5.1 bump
2010-02-16 6:26 ` Robin H. Johnson
@ 2010-02-16 10:14 ` Duncan
2010-02-16 10:34 ` Duncan
2010-02-16 14:37 ` Petteri Räty
1 sibling, 1 reply; 24+ messages in thread
From: Duncan @ 2010-02-16 10:14 UTC (permalink / raw
To: gentoo-dev
Robin H. Johnson posted on Tue, 16 Feb 2010 06:26:03 +0000 as excerpted:
> On Tue, Feb 16, 2010 at 06:11:13AM +0000, Duncan wrote:
>> It's automagic from here. I just run kde. What it does, I don't know.
>> I just don't want it to break! (And upgrade implications will get
>> worse with kde 4.5 in August, as kmail will be depending on it then,
>> and users tend to get rather cross when their mail store gets hosed!
>> With 4.4, it's mainly the address book.)
> All of that is under the Akonadi side of KDE. I really don't think
> storing mail inside MySQL is going to be a good idea.
Me neither, but I'm just a user. <shrug>
>> What I was suggesting, between the lines, is to coordinate with the kde
>> project. They may want to create their own upgrade document [,etc.]
> I announced it 2 weeks ago, on February 1st, Message-Id:
> robbat2-20100201T012126-637073772Z@orbis-terrarum.net
Is there a bug on it for the KDE folks? Should I open one?
I /am/ going to post a message to the kde lists (where I'm a regular)
asking about mysql upgrades there. We'll see what they say.
> As soon as the 72 hours on this news announcement are done, I'm going to
> be unmasking it. I do expect most of the breakage to come from the
> client libraries, and NOT any actual data storage issues. If MySQL
> detects that it's not safe to access a table, it does give you a
> suitable error to repair the table.
>
> mysql_upgrade is actually really just running 'CHECK TABLE ... FOR
> UPGRADE;' && 'REPAIR TABLE ...' on tables with something that needs to
> change. Doing a 'REPAIR TABLE ...' globally will cover you if you don't
> have any other way to issue the check statements manually.
>
> That is of course me assuming that you have a way to issue 'REPAIR TABLE
> ...', because that's a critical MySQL command for the DBA/user to know
> in managing their data.
I'd think KDE would have mysql upgrade methods documented, if they're
going to be using the software. But there's a lot of stuff I'd have
thought, before the kde4 upgrade mess, that I'm considerably more cynical
about now... <shrug>
--
Duncan - List replies preferred. No HTML msgs.
"Every nonfree program has a lord, a master --
and if you use the program, he is your master." Richard Stallman
^ permalink raw reply [flat|nested] 24+ messages in thread
* [gentoo-dev] Re: News item: MySQL 5.1 bump
2010-02-15 22:12 ` Robin H. Johnson
@ 2010-02-16 10:27 ` Nikos Chantziaras
0 siblings, 0 replies; 24+ messages in thread
From: Nikos Chantziaras @ 2010-02-16 10:27 UTC (permalink / raw
To: gentoo-dev
On 02/16/2010 12:12 AM, Robin H. Johnson wrote:
> On Mon, Feb 15, 2010 at 11:51:59PM +0200, Nikos Chantziaras wrote:
>> On 02/15/2010 11:21 PM, Robin H. Johnson wrote:
>>> This is my last blocker for getting MySQL 5.1 series into ~arch status.
>>>
>>> ====
>>> itle: MySQL 5.1 unmasking
>>> Author: "Robin H. Johnson"<robbat2@gentoo.rog>
>>> Content-Type: text/plain
>>> Posted: 2010-02-15
>>> Revision: 1
>>> News-Item-Format: 1.0
>>> Display-If-Installed:<dev-db/mysql-5.1
>>>
>>> The 5.1 series of MySQL is going to be unmasked at the same time as the release
>>> of this news item. When upgrading from an older major version, you will be
>>> required to rebuild everything linked to the libmysqlclient.so.15.
>>> ====
>> I assume "older major version" means 4.x versions and older, not 5.0, right?
> The following transitions required rebuilds:
> 3.23 -> 4.0
> 4.0 -> 4.1
> 4.1 -> 5.0
> 5.0 -> 5.1
>
> 5.1 -> 5.[45] don't require anything at present, but 5.x -> 6.0 may.
>
> Major version in the context of upstream MySQL is the first TWO digits.
This should be mentioned in the news item since what MySQL thinks are
"major" version numbers disagrees with the common sense of:
Major.minor.patch
Most people will interpret "older major version" as being MySQL 4.x and
older.
^ permalink raw reply [flat|nested] 24+ messages in thread
* [gentoo-dev] Re: News item: MySQL 5.1 bump
2010-02-16 10:14 ` Duncan
@ 2010-02-16 10:34 ` Duncan
0 siblings, 0 replies; 24+ messages in thread
From: Duncan @ 2010-02-16 10:34 UTC (permalink / raw
To: gentoo-dev
Duncan posted on Tue, 16 Feb 2010 10:14:08 +0000 as excerpted:
> I /am/ going to post a message to the kde lists (where I'm a regular)
> asking about mysql upgrades there. We'll see what they say.
You'll probably not be particulary interested in this, robbat2, but for
others following who might be:
http://comments.gmane.org/gmane.comp.kde.general/22753
No response yet, of course, I just posted it.
--
Duncan - List replies preferred. No HTML msgs.
"Every nonfree program has a lord, a master --
and if you use the program, he is your master." Richard Stallman
^ permalink raw reply [flat|nested] 24+ messages in thread
* Re: [gentoo-dev] Re: News item: MySQL 5.1 bump
2010-02-16 6:26 ` Robin H. Johnson
2010-02-16 10:14 ` Duncan
@ 2010-02-16 14:37 ` Petteri Räty
2010-02-16 18:48 ` Joshua Saddler
1 sibling, 1 reply; 24+ messages in thread
From: Petteri Räty @ 2010-02-16 14:37 UTC (permalink / raw
To: gentoo-dev
On 15.2.2010 22.26, Robin H. Johnson wrote:
>
> As soon as the 72 hours on this news announcement are done, I'm going to
> be unmasking it. I do expect most of the breakage to come from the
> client libraries, and NOT any actual data storage issues. If MySQL
> detects that it's not safe to access a table, it does give you a
> suitable error to repair the table.
>
pr@gentoo.org has yet to be CCed to any mails as far as I can see.
It's done now.
Regards,
Petteri
^ permalink raw reply [flat|nested] 24+ messages in thread
* Re: [gentoo-dev] Re: News item: MySQL 5.1 bump
2010-02-16 14:37 ` Petteri Räty
@ 2010-02-16 18:48 ` Joshua Saddler
2010-02-16 19:20 ` Robin H. Johnson
0 siblings, 1 reply; 24+ messages in thread
From: Joshua Saddler @ 2010-02-16 18:48 UTC (permalink / raw
To: gentoo-dev
[-- Attachment #1: Type: text/plain, Size: 751 bytes --]
On Tue, 16 Feb 2010 06:37:03 -0800
Petteri Räty <betelgeuse@gentoo.org> wrote:
> On 15.2.2010 22.26, Robin H. Johnson wrote:
>
> >
> > As soon as the 72 hours on this news announcement are done, I'm going to
> > be unmasking it. I do expect most of the breakage to come from the
> > client libraries, and NOT any actual data storage issues. If MySQL
> > detects that it's not safe to access a table, it does give you a
> > suitable error to repair the table.
> >
>
> pr@gentoo.org has yet to be CCed to any mails as far as I can see.
> It's done now.
I still don't know why we're always CCed . . . but anyway, the latest version that Robin posted looks okay. Including the upgrade procedure link was the most important add-on.
[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 198 bytes --]
^ permalink raw reply [flat|nested] 24+ messages in thread
* Re: [gentoo-dev] Re: News item: MySQL 5.1 bump
2010-02-16 18:48 ` Joshua Saddler
@ 2010-02-16 19:20 ` Robin H. Johnson
2010-02-16 19:48 ` Joshua Saddler
0 siblings, 1 reply; 24+ messages in thread
From: Robin H. Johnson @ 2010-02-16 19:20 UTC (permalink / raw
To: gentoo-dev
On Tue, Feb 16, 2010 at 10:48:52AM -0800, Joshua Saddler wrote:
> > pr@gentoo.org has yet to be CCed to any mails as far as I can see.
> > It's done now.
Hmm, I did CC it with the second rev. Not sure why you didn't get it.
> I still don't know why we're always CCed . . . but anyway, the latest
> version that Robin posted looks okay. Including the upgrade procedure
> link was the most important add-on.
The GLEP says:
====
Thus, at least 72 hours before a proposed news item is committed, it must be
posted to the gentoo-dev mailing list and Cc:ed to pr@gentoo.org (exceptions
may be made in exceptional circumstances). Any complaints — for example
regarding wording, clarity or accuracy — must be addressed before the news item
goes live.
====
Giving the staffing levels of PR vs. the eyes on the -dev ML, I don't see the
point either.
--
Robin Hugh Johnson
Gentoo Linux: Developer, Trustee & Infrastructure Lead
E-Mail : robbat2@gentoo.org
GnuPG FP : 11AC BA4F 4778 E3F6 E4ED F38E B27B 944E 3488 4E85
^ permalink raw reply [flat|nested] 24+ messages in thread
* Re: [gentoo-dev] Re: News item: MySQL 5.1 bump
2010-02-16 19:20 ` Robin H. Johnson
@ 2010-02-16 19:48 ` Joshua Saddler
0 siblings, 0 replies; 24+ messages in thread
From: Joshua Saddler @ 2010-02-16 19:48 UTC (permalink / raw
To: gentoo-dev
[-- Attachment #1: Type: text/plain, Size: 577 bytes --]
On Tue, 16 Feb 2010 19:20:06 +0000
"Robin H. Johnson" <robbat2@gentoo.org> wrote:
> Giving the staffing levels of PR vs. the eyes on the -dev ML, I don't see the
> point either.
Yup. Besides, it's not like any of us have commit access to go back and fix something in a news announcement after the fact. Portage tree news items . . . what we do in PR really doesn't seem like it's suited to that aspect of Gentoo.
The thing I care about most is that there's proper documentation released (or linked) along with the announcement. In this case, you did, so well done.
[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 198 bytes --]
^ permalink raw reply [flat|nested] 24+ messages in thread
* Re: [gentoo-dev] News item: MySQL 5.1 bump
2010-02-15 21:21 [gentoo-dev] News item: MySQL 5.1 bump Robin H. Johnson
` (4 preceding siblings ...)
2010-02-16 0:14 ` Robin H. Johnson
@ 2010-02-21 2:23 ` Robin H. Johnson
2010-02-21 12:01 ` Richard Freeman
5 siblings, 1 reply; 24+ messages in thread
From: Robin H. Johnson @ 2010-02-21 2:23 UTC (permalink / raw
To: gentoo-dev
On Mon, Feb 15, 2010 at 09:21:36PM +0000, Robin H. Johnson wrote:
> This is my last blocker for getting MySQL 5.1 series into ~arch status.
The MySQL 5.1 news item with all updates is now commited, and 5.1.x have
been unblocked in package.mask.
--
Robin Hugh Johnson
Gentoo Linux: Developer, Trustee & Infrastructure Lead
E-Mail : robbat2@gentoo.org
GnuPG FP : 11AC BA4F 4778 E3F6 E4ED F38E B27B 944E 3488 4E85
^ permalink raw reply [flat|nested] 24+ messages in thread
* Re: [gentoo-dev] News item: MySQL 5.1 bump
2010-02-21 2:23 ` [gentoo-dev] " Robin H. Johnson
@ 2010-02-21 12:01 ` Richard Freeman
0 siblings, 0 replies; 24+ messages in thread
From: Richard Freeman @ 2010-02-21 12:01 UTC (permalink / raw
To: gentoo-dev
On 02/20/2010 09:23 PM, Robin H. Johnson wrote:
> The MySQL 5.1 news item with all updates is now commited, and 5.1.x have
> been unblocked in package.mask.
>
It looks like that news item is visible to users running stable as well.
When 5.1 eventually goes stable we might want to re-announce it since
it may have been long forgotten by then...
^ permalink raw reply [flat|nested] 24+ messages in thread
end of thread, other threads:[~2010-02-21 12:02 UTC | newest]
Thread overview: 24+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2010-02-15 21:21 [gentoo-dev] News item: MySQL 5.1 bump Robin H. Johnson
2010-02-15 21:32 ` Samuli Suominen
2010-02-15 21:41 ` Robin H. Johnson
2010-02-16 0:08 ` Thilo Bangert
2010-02-15 21:51 ` [gentoo-dev] " Nikos Chantziaras
2010-02-15 22:12 ` Robin H. Johnson
2010-02-16 10:27 ` Nikos Chantziaras
2010-02-15 22:03 ` [gentoo-dev] " Ulrich Mueller
2010-02-15 22:06 ` Dawid Węgliński
2010-02-15 22:15 ` Robin H. Johnson
2010-02-15 22:54 ` Dawid Węgliński
2010-02-16 0:14 ` Robin H. Johnson
2010-02-16 4:20 ` [gentoo-dev] " Duncan
2010-02-16 4:33 ` Robin H. Johnson
2010-02-16 6:11 ` Duncan
2010-02-16 6:26 ` Robin H. Johnson
2010-02-16 10:14 ` Duncan
2010-02-16 10:34 ` Duncan
2010-02-16 14:37 ` Petteri Räty
2010-02-16 18:48 ` Joshua Saddler
2010-02-16 19:20 ` Robin H. Johnson
2010-02-16 19:48 ` Joshua Saddler
2010-02-21 2:23 ` [gentoo-dev] " Robin H. Johnson
2010-02-21 12:01 ` Richard Freeman
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox