* [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
* 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
* [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] 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
* [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
* 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] 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: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-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