[gentoo-amd64] mysql update to 5.0.25-r1 and amarok-1.4.3-r1

[gentoo-amd64] mysql update to 5.0.25-r1 and amarok-1.4.3-r1

[Paul Stear]

Hello all.
Yesterday I did my usual update world and noticed that mysql was to be 
upgraded to version 5.  I restarted mysql and ran revdep-update which rebuilt 
a few applications including amarok.  All went well with no errors but when I 
ran amarok it was obvious that things were not quite right.
When I fired amarok up it started to rebuild the database (this took an age), 
when it had finished I noticed that all of the score information was missing.
I played some songs and thought that I would check to see if the new scores 
were saved.  So I closed down and restarted amarok, when the playlist 
appeared no scores had been saved and amarok was again building the database.

Question.
Should I have done something after the world upgrades?
How can I get back all of my score information for all songs?
Has anybody had this problem, what do I do to solve it?

Thanks for any replies
Paul
-- 
This message has been sent using kmail with gentoo linux
-- 
gentoo-amd64@gentoo.org mailing list

Re: [gentoo-amd64] mysql update to 5.0.25-r1 and amarok-1.4.3-r1

[Paul Stear]

On Tuesday 21 November 2006 08:29, Paul Stear wrote:
> Hello all.
> Yesterday I did my usual update world and noticed that mysql was to be
> upgraded to version 5.  I restarted mysql and ran revdep-update which
> rebuilt a few applications including amarok.  All went well with no errors
> but when I ran amarok it was obvious that things were not quite right.
> When I fired amarok up it started to rebuild the database (this took an
> age), when it had finished I noticed that all of the score information was
> missing. I played some songs and thought that I would check to see if the
> new scores were saved.  So I closed down and restarted amarok, when the
> playlist appeared no scores had been saved and amarok was again building
> the database.
>
> Question.
> Should I have done something after the world upgrades?
> How can I get back all of my score information for all songs?
> Has anybody had this problem, what do I do to solve it?

Sorry to reply to my own post but I am just so frustrated.  I have had amarok 
running for 4 hrs now and it keeps updating the database. i.e. as soon as it 
has finished updating it starts again. This is with no changed to the 
collection except the score as a result of playing.  Also on the sidebar it 
says "If you would like to see contextual information about this track, you 
should add it to your collection"
But it's updated at least 5 times.

It's almost as if the amarok database in mysql is not getting writen to, but I 
don't appear to have any errors.

Heeeeeeeeeeeeeelp please
Thanks for any replies Paul

-- 
This message has been sent using kmail with gentoo linux
-- 
gentoo-amd64@gentoo.org mailing list

[gentoo-amd64] Re: mysql update to 5.0.25-r1 and amarok-1.4.3-r1

[Duncan]

Paul Stear <gentoo@appjaws.plus.com> posted
200611211240.31980.gentoo@appjaws.plus.com, excerpted below, on  Tue, 21
Nov 2006 12:40:31 +0000:

> It's almost as if the amarok database in mysql is not getting writen to,
> but I don't appear to have any errors.

I'm no MySQL authority and don't even have it merged, but is there a db
upgrade process necessary after the upgrade?  Did the package log any
messages to that effect?

You may want to try the amarok mailing list.

Or, if you don't have any particular attachment to MySQL, try turning off
that USE flag.  I don't have either that or postgres turned on or merged,
and amarok still seems to manage its database.  Of course, I believe
you'll have to either manually score or start over again with scoring then.

-- 
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

-- 
gentoo-amd64@gentoo.org mailing list

Re: [gentoo-amd64] Re: mysql update to 5.0.25-r1 and amarok-1.4.3-r1

[Michael Weyershäuser]

[-- Attachment #1: Type: text/plain, Size: 627 bytes --]

I've had similar problems with amarok after upgrading mysql, and it's
not for the first time. At some point I just said "screw you", dropped
the whole database and started from scratch (amarok previously wiped out
its statistics a couple of times for me, right now I don't really care
that much any longer).

Duncan wrote:
 > Or, if you don't have any particular attachment to MySQL, try turning off
> that USE flag.  I don't have either that or postgres turned on or merged,
> and amarok still seems to manage its database.

If both mysql and postgres are disabled amarok falls back to using a
sqlite database.


[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 252 bytes --]

[gentoo-amd64] Re: mysql update to 5.0.25-r1 and amarok-1.4.3-r1

[Duncan]

Michael Weyershäuser <thedude0001@gmx.de> posted 4563107C.6030701@gmx.de,
excerpted below, on  Tue, 21 Nov 2006 15:43:08 +0100:

> If both mysql and postgres are disabled amarok falls back to using a
> sqlite database.

Thanks.  Now that you mention it, I think I remember reading exactly that
somewhere.  I had however forgotten.


-- 
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

-- 
gentoo-amd64@gentoo.org mailing list

Re: [gentoo-amd64] Re: mysql update to 5.0.25-r1 and amarok-1.4.3-r1

[Jean-Marc Hengen]

Duncan wrote:
> I'm no MySQL authority and don't even have it merged, but is there a db
> upgrade process necessary after the upgrade?  Did the package log any
> messages to that effect?

How about: http://www.gentoo.org/doc/en/mysql-upgrading.xml

I use myself only MySQL. I followed the upgrade guide and everything
went fine. My web-apps (mostly written by myself) seems to be OK. (I
didn't do heavy testings.)

At least for major upgrades, there should always be some upgrade
process, but I remember, that I had also to do some task from 4.0 to
4.1. I always check the guide, after upgrades.
-- 
gentoo-amd64@gentoo.org mailing list

Re: [gentoo-amd64] mysql update to 5.0.25-r1 and amarok-1.4.3-r1

[Martins Steinbergs]

On Tuesday 21 November 2006 14:40, Paul Stear wrote:
> On Tuesday 21 November 2006 08:29, Paul Stear wrote:
> > Hello all.
> > Yesterday I did my usual update world and noticed that mysql was to be
> > upgraded to version 5.  I restarted mysql and ran revdep-update which
> > rebuilt a few applications including amarok.  All went well with no
> > errors but when I ran amarok it was obvious that things were not quite
> > right. When I fired amarok up it started to rebuild the database (this
> > took an age), when it had finished I noticed that all of the score
> > information was missing. I played some songs and thought that I would
> > check to see if the new scores were saved.  So I closed down and
> > restarted amarok, when the playlist appeared no scores had been saved and
> > amarok was again building the database.
> >
> > Question.
> > Should I have done something after the world upgrades?
> > How can I get back all of my score information for all songs?
> > Has anybody had this problem, what do I do to solve it?
>
> Sorry to reply to my own post but I am just so frustrated.  I have had
> amarok running for 4 hrs now and it keeps updating the database. i.e. as
> soon as it has finished updating it starts again. This is with no changed
> to the collection except the score as a result of playing.  Also on the
> sidebar it says "If you would like to see contextual information about this
> track, you should add it to your collection"
> But it's updated at least 5 times.
>
> It's almost as if the amarok database in mysql is not getting writen to,
> but I don't appear to have any errors.
>
> Heeeeeeeeeeeeeelp please
> Thanks for any replies Paul
>
> --
> This message has been sent using kmail with gentoo linux


I had the same problem but with mysql-5.0.26-r1 I dont remember all steps but 
for some reason i set db master user and password in amarok, not the 
amarok_db user and password, i have all score back.

-- 
gentoo-amd64@gentoo.org mailing list