[Bug 712749] New: Amarok fails to initialize collection GREPME MySQLe query failed! (2000) on init
https://bugzilla.novell.com/show_bug.cgi?id=712749 https://bugzilla.novell.com/show_bug.cgi?id=712749#c0 Summary: Amarok fails to initialize collection GREPME MySQLe query failed! (2000) on init Classification: openSUSE Product: openSUSE 12.1 Version: Milestone 3 Platform: All OS/Version: Other Status: NEW Severity: Critical Priority: P5 - None Component: KDE4 Applications AssignedTo: kde-maintainers@suse.de ReportedBy: cobexer@gmail.com QAContact: qa@suse.de Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:6.0) Gecko/20100101 Firefox/6.0 since a while now amarok fails to load its collection with the error: GREPME MySQLe query failed! (2000) on init fails the same way for a new user amarok compiled from git does not experience this problem and it seems this has happened before: Bug 530562 - Amarok2 is unable to initialized embedded MySQL database https://bugzilla.novell.com/show_bug.cgi?id=530562 Bug 509815 - Amarok2 no longer builds music collection https://bugzilla.novell.com/show_bug.cgi?id=509815 Bug 528312 - Amarok 2.1.1 doesn't want to load local collection https://bugzilla.novell.com/show_bug.cgi?id=528312 Reproducible: Always Steps to Reproduce: 1. start amarok 2. 3. Actual Results: GREPME MySQLe query failed! (2000) on init Expected Results: working embedded collection amarok: [CollectionManager] initializing "amarok_collection-mysqlecollection" 110817 22:19:08 InnoDB: The InnoDB memory heap is disabled 110817 22:19:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110817 22:19:08 InnoDB: Compressed tables use zlib 1.2.5 110817 22:19:08 InnoDB: Initializing buffer pool, size = 128,0M 110817 22:19:08 InnoDB: Completed initialization of buffer pool 110817 22:19:08 InnoDB: highest supported file format is Barracuda. 110817 22:19:08 InnoDB: Waiting for the background threads to start amarok: [ERROR__] MySQL library initialization failed. amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (2000) on init" cobexer@christoph-game:~> amarok --version Qt: 4.7.3 KDE Development Platform: 4.7.00 (4.7.0) Amarok: 2.4.3 amarok and KDE is from KDF -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c1
Glenn Doig
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c2
--- Comment #2 from Christoph Obexer
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c3
Christoph Obexer
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c4
Aram Dulyan
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c5
--- Comment #5 from Christoph Obexer
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c6
Christian Trippe
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c7
--- Comment #7 from Bernhard Wiedemann
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c8
Robert Riemann
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c9
Robert Riemann
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c10
Robert Riemann
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c11
Christoph Obexer
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c12
Stephan Kulow
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c13
Stephan Kulow
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c14
Michal Hrusecky
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c15
--- Comment #15 from Michal Hrusecky
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c16
Michal Hrusecky
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c17
--- Comment #17 from Bernhard Wiedemann
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c18
Dirk Mueller
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c
Dirk Mueller
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c19
--- Comment #19 from Benjamin Brunner
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c20
Benjamin Brunner
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c21
Giuseppe Salinaro
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c22
--- Comment #22 from Michal Hrusecky
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c23
--- Comment #23 from Benjamin Brunner
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c24
Sven Burmeister
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c25
Michal Hrusecky
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c26
--- Comment #26 from Bernhard Wiedemann
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c27
Oliver Schmidt
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c28
John Farrar
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c29
Till Dörges
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c30
Alex Savin
Problem back again today. Downgrade from 5.5.23 to 5.5.16 solves issue.
+1 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c31
Matthias Pfafferodt
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c32
--- Comment #32 from Max Lin
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c33
Klaus Gast
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c34
--- Comment #34 from Giuseppe Salinaro
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c35
Sverre Moe
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c36
--- Comment #36 from Matthias Pfafferodt
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c37
Kalenz .
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c38
Christian Boltz
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c39
Dainius Masiliunas
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c40
James PEARSON
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c41
--- Comment #41 from Kalenz .
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c
Kalenz .
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c42
Lucas Timm
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c43
Christoph Obexer
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c44
Andreas Schneider
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c45
Vojtech Zeisek
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c46
Robert Wittwer
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c47
Herbert Graeber
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c48
--- Comment #48 from Sven Burmeister
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c49
--- Comment #49 from Sven Burmeister
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c50
--- Comment #50 from Alberto Passalacqua
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c51
--- Comment #51 from Dainius Masiliunas
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c52
David Ward
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c53
--- Comment #53 from Harland Coles
The responsible package is libmysqld18 version 5.5.23; downgrading to 5.5.16 resolves the issue.
Confirmed libmysqld18 downgrade works. "zypper patch" will break again as online update contains libmysqld18-5.5.23. -- poke: opensuse 12.1, kde 4.8.4(r511), amarok-2.5.0-159.3.x86_64 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c54
--- Comment #54 from Cor Blom
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c55
--- Comment #55 from Sven Burmeister
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c56
Stefan Brüns
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c57
--- Comment #57 from Cor Blom
Could you do the same for the amarok package in KDF and re-submit it with the notice that unless the maintainers do not have any other fix to remove the patch is a viable solution? KR48 are just links to that repo.
I have a package prepared, but wait with submitting to see whether another solution is forthcoming. Reading comment #14 again removing the patch means amarok is depending on mysql-community-server, and that seems not desirable. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c58
Sven Burmeister
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c59
--- Comment #59 from Stefan Brüns
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c
Dirk Mueller
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c60
--- Comment #60 from Antonio Varilla Román
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c61
--- Comment #61 from Sven Burmeister
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c62
Benjamin Brunner
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c63
--- Comment #63 from Bernhard Wiedemann
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c64
--- Comment #64 from Matthias Pfafferodt
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c65
Christian Herenz
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c66
--- Comment #66 from Martin Schlander
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c67
--- Comment #67 from Kalenz .
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c68
Alex Savin
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c69
Cristian Morales Vega
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c70
--- Comment #70 from Kalenz .
it seems Amarok needs to be rebuilt every time mysql is updated
If this is the case, then the simplest solution IMHO is for the Amarok packagers to specify a requirement for mysql=5.5.16 (for example), rather than mysql>=5.5.16. This will trigger a dependency conflict warning from zypper/YaST when a new MySQL becomes available: - Desktop user case: keep old mysql (and functioning amarok). - Server user case: upgrade mysql (amarok probably not installed). Then, when a new amarok becomes available (compatible with new mysql), a zypper/YaST update will automatically pull in the latest mysql and amarok.
you need a fix that doesn't require a rebuild with every mysql update
Not strictly necessary... but probably wouldn't be a bad idea! I would have thought that the mysql developers make considerable efforts for backward compatibility... More in general, I should perhaps clarify that my last post was not meant as an attack to any individual, and I appreciate everybody's great work on Amarok and openSUSE. But irrespective of this *specific* instance (resolving amarok-mysql dependencies), it worries me that *in general* it is apparently possible for an important openSUSE component to be broken for so long. Which means, there is something wrong with the system, something wrong with how we communicate here. This bug simply did not get the attention it deserved, fast enough. I hope that, after this bug is permanently resolved, maintainers will give some thought to "how do we make sure this doesn't happen again". Not just with amarok/mysql, but in general, with any (important) part of openSUSE. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c71
--- Comment #71 from Cristian Morales Vega
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c72
--- Comment #72 from Stefan Brüns
it seems Amarok needs to be rebuilt every time mysql is updated
If this is the case, then the simplest solution IMHO is for the Amarok packagers to specify a requirement for mysql=5.5.16 (for example), rather than mysql>=5.5.16.
NO NO NO! errmsg.sys is _not_ a dependency of amarok, it is a dependency of libmysqld. Putting the errmsg.sys into the amarok package and hardcoding the path to it is just plain ***!
you need a fix that doesn't require a rebuild with every mysql update
Not strictly necessary... but probably wouldn't be a bad idea! I would have thought that the mysql developers make considerable efforts for backward compatibility...
Current packages for 12.2 and factory have this all fixed. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c73
Marcus Meissner
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c74
--- Comment #74 from Marcus Meissner
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c75
Benjamin Brunner
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c76
Stefan Brüns
@stefan: libmysqld18 is not requiring the errormessage package in your fix... is this correct? (i just see it in the mainpackage and in -client)
The original request (https://build.opensuse.org/request/show/125482 ) was correct, i.e. it had the requires for the mainpackage and libmysqld18, but _not_ for -client (which is wrong). Unfortunately the request was not merged correctly, possibly due to the request being processed by the format_spec_file service, leading to a quite large diff. submitted new request https://build.opensuse.org/request/show/128035 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c77
--- Comment #77 from Marcus Meissner
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c78
Malvern Star
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c79
Benjamin Brunner
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c80
--- Comment #80 from Swamp Workflow Management
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c81
Johannes Obermayr
https://bugzilla.novell.com/show_bug.cgi?id=712749
https://bugzilla.novell.com/show_bug.cgi?id=712749#c82
--- Comment #82 from Bernhard Wiedemann
participants (1)
-
bugzilla_noreply@novell.com