Bug 284810

Summary:	Amarok MySqlStorage fails with "GREPME MySQLe query failed! (2000) on init"
Product:	[Applications] amarok	Reporter:	Robert Riemann <robert>
Component:	Collections/Local	Assignee:	Amarok Developers <amarok-bugs-dist>
Status:	RESOLVED DOWNSTREAM
Severity:	major	CC:	bartotten, jtamate, kdebugsbmw, ralf-engels, saya.bara, tukkek
Priority:	NOR
Version:	2.4-GIT
Target Milestone:	2.5
Platform:	Compiled Sources
OS:	Linux
See Also:	https://bugzilla.novell.com/show_bug.cgi?id=712749
Latest Commit:		Version Fixed In:
Sentry Crash Report:

Description Robert Riemann 2011-10-23 20:30:22 UTC

Version:           2.4.3 (using KDE 4.7.2) 
OS:                Linux

I compiled amarok from trunk and experienced the same problem.
Is this anyhow related to mysql->mariadb migration?


Kind regards,
Robert

Version:
Qt: 4.7.4
KDE Development Platform: 4.7.2 (4.7.2)
Amarok: 2.4.3


Distribution: openSUSE Factory (12.1 rc) 64bit

Output from amarok --debug:

amarok:         BEGIN: void CollectionManager::init(const QList<Plugins::PluginFactory*>&) 
amarok:           BEGIN: void CollectionManager::loadPlugins(const QList<Collections::CollectionFactory*>&) 
amarok:             [CollectionManager] initializing "amarok_collection-mysqlecollection" 
amarok:             [ERROR__] MySQL library initialization failed. 
amarok:             [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (2000)  on init" 
amarok:             BEGIN: bool DatabaseUpdater::update() 
amarok:               [MySqlStorage] Initialized thread, count== 1 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               Database version:  0 
amarok:               BEGIN: void DatabaseUpdater::createTables() const 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 


Reproducible: Didn't try

Steps to Reproduce:
install amarok, start amarok. Happens after each start

Actual Results:  
Collection is empty

Expected Results:  
No error and a filled music collection

I ran into this problem after upgrading opensuse 12.1 beta to the recent RC. After that I tried to resolve this problem by compiling from git master, but the problem is still there.

Comment 1 Bernhard M. Wiedemann 2011-10-24 07:52:05 UTC

bug was also observed in automated tests of stock openSUSE amarok

first seen 2011-10-05
http://openqa.opensuse.org/viewimg/opensuse/testresults/openSUSE-NET-i586-Build0323/amarok-2.png

Comment 2 Myriam Schweingruber 2011-10-24 12:00:04 UTC

I can't reproduce this here with Kubuntu 11.10. Please check you have no conflicting installations in your MySQL files.

Comment 3 Robert Riemann 2011-10-24 14:34:46 UTC

> Please check you have no conflicting installations in your MySQL files.

How do I do this? What information do you need to help me debugging?

Comment 4 Myriam Schweingruber 2011-10-24 15:13:13 UTC

Well, check the versions of the MySQL packages yo have installed.

Comment 5 Robert Riemann 2011-10-24 21:25:28 UTC

My problem went away after uninstalling mariadb and mariadb-client and installing mysql-community-server{,-client}.

MariaDB seems to got installed by accident when I installed opensuse beta.

So it looks like amarok doesn't accept the drop-in replacement mariadb.

Comment 6 BartOtten 2011-12-20 19:34:36 UTC

I can confirm the work-around from Robert. Who should we talk to to fix this?

Comment 7 Myriam Schweingruber 2011-12-20 23:50:35 UTC

(In reply to comment #6)
> I can confirm the work-around from Robert. Who should we talk to to fix this?

To the distribution IMHO, we clearly ship Amarok with MySQL as a dependency, so does kdelibs btw

Comment 8 BartOtten 2011-12-20 23:57:03 UTC

openSUSE is working on it:

https://bugzilla.novell.com/show_bug.cgi?id=712749

Comment 9 Myriam Schweingruber 2012-06-15 07:58:16 UTC

*** Bug 301918 has been marked as a duplicate of this bug. ***

Comment 10 Myriam Schweingruber 2012-08-16 23:19:01 UTC

*** Bug 305258 has been marked as a duplicate of this bug. ***

Comment 11 saya.bara 2012-08-17 13:43:05 UTC

Thank you so much, the bug not appear again in new version of amarok... :D

On Fri, Aug 17, 2012 at 7:19 AM, Myriam Schweingruber <myriam@kde.org>wrote:

> https://bugs.kde.org/show_bug.cgi?id=284810
>
> Myriam Schweingruber <myriam@kde.org> changed:
>
>            What    |Removed                     |Added
>
> ----------------------------------------------------------------------------
>                  CC|                            |jtamate@gmail.com
>
> --- Comment #10 from Myriam Schweingruber <myriam@kde.org> ---
> *** Bug 305258 has been marked as a duplicate of this bug. ***
>
> --
> You are receiving this mail because:
> You are on the CC list for the bug.
>

Comment 12 Myriam Schweingruber 2012-08-18 07:58:38 UTC

(In reply to comment #11)
> Thank you so much, the bug not appear again in new version of amarok... :D

Which has again nothing to do with Amarok, please check with your distribution, this is a downstream issue with their MySQL implementation.

Comment 13 saya.bara 2012-08-19 15:23:54 UTC

Oh,,
Okay, thanks for the information.. :D

On Sat, Aug 18, 2012 at 3:58 PM, Myriam Schweingruber <myriam@kde.org>wrote:

> https://bugs.kde.org/show_bug.cgi?id=284810
>
> --- Comment #12 from Myriam Schweingruber <myriam@kde.org> ---
> (In reply to comment #11)
> > Thank you so much, the bug not appear again in new version of amarok...
> :D
>
> Which has again nothing to do with Amarok, please check with your
> distribution,
> this is a downstream issue with their MySQL implementation.
>
> --
> You are receiving this mail because:
> You are on the CC list for the bug.
>

Comment 14 Myriam Schweingruber 2017-01-12 15:16:31 UTC

*** Bug 374891 has been marked as a duplicate of this bug. ***