Bug 300170 - Amarok database fails after MySQL update to version 5.5.23.
Summary: Amarok database fails after MySQL update to version 5.5.23.
Status: RESOLVED DUPLICATE of bug 288891
Alias: None
Product: amarok
Classification: Applications
Component: Collections/Local (show other bugs)
Version: unspecified
Platform: openSUSE Linux
: NOR major
Target Milestone: 2.6
Assignee: Amarok Developers
URL:
Keywords:
: 295609 300495 (view as bug list)
Depends on:
Blocks:
 
Reported: 2012-05-16 21:34 UTC by Haro de Grauw
Modified: 2012-05-31 11:22 UTC (History)
4 users (show)

See Also:
Latest Commit:
Version Fixed In:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Haro de Grauw 2012-05-16 21:34:36 UTC 
Application: amarok (2.4.3)
KDE Platform Version: 4.7.2 (4.7.2) "release 5"
Qt Version: 4.7.4
Operating System: Linux 3.1.10-1.9-desktop x86_64
Distribution: "openSUSE 12.1 (x86_64)"

-- Information about the crash:
Every time at Amarok launch, the message "GREPME MySQLe query failed! (2000) on init" is displayed. Sometimes, but not always, Amarok crashes. When it doesn't, the collection is empty, but I can play music by manually selecting a file.

This has happened ever since a routine system update, which included updates of the following packages to version 5.5.23:
- mysql-community-server
- libmysqld18
- libmysqldclient18
- libmysqldclient18-32bit

Attempt to repair the database fails as follows:
(ref: http://amarok.kde.org/wiki/MySQL_Server#Repair_a_Corrupted_Database)
bureau:/home/hadg # mysqlcheck -p --auto-repair --all-databases
Enter password: 
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2) when trying to connect
(Any help here? I'm obviously no expert on MySQL.)

NB, internal database is used (default setting).

amarokcollectionscanner -r /path/to/collection
This seems to work ok, output looks normal (I can post it if you want it), but amarok still boots with the error message and empty collection.

-- Backtrace:
Application: Amarok (amarok), signal: Segmentation fault
[Current thread is 1 (Thread 0x7fe288f12760 (LWP 4843))]

Thread 8 (Thread 0x7fe2655d9700 (LWP 4900)):
#0  0x00007fe2839ed1eb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00007fe26f013341 in ?? () from /usr/lib64/libxine.so.1
#2  0x00007fe2839e8f05 in start_thread () from /lib64/libpthread.so.0
#3  0x00007fe28588810d in clone () from /lib64/libc.so.6

Thread 7 (Thread 0x7fe264dd8700 (LWP 4901)):
#0  0x00007fe28587eff3 in poll () from /lib64/libc.so.6
#1  0x00007fe27f54ba98 in ?? () from /usr/lib64/libglib-2.0.so.0
#2  0x00007fe27f54bf59 in g_main_context_iteration () from /usr/lib64/libglib-2.0.so.0
#3  0x00007fe286e89586 in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/libQtCore.so.4
#4  0x00007fe286e5da32 in QEventLoop::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/libQtCore.so.4
#5  0x00007fe286e5dc2f in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/libQtCore.so.4
#6  0x00007fe286d755df in QThread::exec() () from /usr/lib64/libQtCore.so.4
#7  0x00007fe26f2978c4 in ?? () from /usr/lib64/kde4/plugins/phonon_backend/phonon_xine.so
#8  0x00007fe286d78025 in ?? () from /usr/lib64/libQtCore.so.4
#9  0x00007fe2839e8f05 in start_thread () from /lib64/libpthread.so.0
#10 0x00007fe28588810d in clone () from /lib64/libc.so.6

Thread 6 (Thread 0x7fe25ffff700 (LWP 4902)):
#0  0x00007fe27d1ad1b0 in pa_mainloop_prepare () from /usr/lib64/libpulse.so.0
#1  0x00007fe27d1adc7d in pa_mainloop_iterate () from /usr/lib64/libpulse.so.0
#2  0x00007fe27d1add40 in pa_mainloop_run () from /usr/lib64/libpulse.so.0
#3  0x00007fe27d1bc1bf in ?? () from /usr/lib64/libpulse.so.0
#4  0x00007fe278a1b248 in ?? () from /usr/lib64/libpulsecommon-1.1.so
#5  0x00007fe2839e8f05 in start_thread () from /lib64/libpthread.so.0
#6  0x00007fe28588810d in clone () from /lib64/libc.so.6

Thread 5 (Thread 0x7fe25b7fd700 (LWP 4903)):
#0  0x00007fe2839ece6c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00007fe26f0248d3 in ?? () from /usr/lib64/libxine.so.1
#2  0x00007fe2839e8f05 in start_thread () from /lib64/libpthread.so.0
#3  0x00007fe28588810d in clone () from /lib64/libc.so.6

Thread 4 (Thread 0x7fe25abf1700 (LWP 4904)):
#0  0x00007fe2839ece6c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00007fe26f0248d3 in ?? () from /usr/lib64/libxine.so.1
#2  0x00007fe2839e8f05 in start_thread () from /lib64/libpthread.so.0
#3  0x00007fe28588810d in clone () from /lib64/libc.so.6

Thread 3 (Thread 0x7fe25a3f0700 (LWP 4905)):
#0  0x00007fe2839ece6c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00007fe26f0248d3 in ?? () from /usr/lib64/libxine.so.1
#2  0x00007fe2839e8f05 in start_thread () from /lib64/libpthread.so.0
#3  0x00007fe28588810d in clone () from /lib64/libc.so.6

Thread 2 (Thread 0x7fe24bfff700 (LWP 5036)):
[KCrash Handler]
#6  0x00007fe2527c526b in ?? () from /usr/lib64/libamarok-sqlcollection.so.1
#7  0x00007fe282dd5d31 in ThreadWeaver::JobRunHelper::runTheJob (this=0x7fe24bffedc0, th=0x81edd0, job=0xd14e10) at /usr/src/debug/kdelibs-4.7.2/threadweaver/Weaver/Job.cpp:106
#8  0x00007fe282dd5e5c in ThreadWeaver::Job::execute (this=0xd14e10, th=0x81edd0) at /usr/src/debug/kdelibs-4.7.2/threadweaver/Weaver/Job.cpp:135
#9  0x00007fe282dd553f in ThreadWeaver::ThreadRunHelper::run (this=0x7fe24bffee40, parent=0xdc1100, th=0x81edd0) at /usr/src/debug/kdelibs-4.7.2/threadweaver/Weaver/Thread.cpp:95
#10 0x00007fe282dd55fb in ThreadWeaver::Thread::run (this=0x81edd0) at /usr/src/debug/kdelibs-4.7.2/threadweaver/Weaver/Thread.cpp:142
#11 0x00007fe286d78025 in ?? () from /usr/lib64/libQtCore.so.4
#12 0x00007fe2839e8f05 in start_thread () from /lib64/libpthread.so.0
#13 0x00007fe28588810d in clone () from /lib64/libc.so.6

Thread 1 (Thread 0x7fe288f12760 (LWP 4843)):
#0  0x00007fe2839ed1eb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00007fe286d77308 in ?? () from /usr/lib64/libQtCore.so.4
#2  0x00007fe286d77740 in QThread::msleep(unsigned long) () from /usr/lib64/libQtCore.so.4
#3  0x00007fe26f2b0312 in ?? () from /usr/lib64/kde4/plugins/phonon_backend/phonon_xine.so
#4  0x00007fe26f2b0459 in ?? () from /usr/lib64/kde4/plugins/phonon_backend/phonon_xine.so
#5  0x00007fe282667a57 in ?? () from /usr/lib64/libphonon.so.4
#6  0x00007fe282667be9 in ?? () from /usr/lib64/libphonon.so.4
#7  0x00007fe2857e49a1 in __run_exit_handlers () from /lib64/libc.so.6
#8  0x00007fe2857e4a25 in exit () from /lib64/libc.so.6
#9  0x00007fe286299d78 in ?? () from /usr/lib64/libQtGui.so.4
#10 0x00007fe288917118 in KApplication::xioErrhandler (this=0x7fff09a1c940, dpy=0x7b2d60) at /usr/src/debug/kdelibs-4.7.2/kdeui/kernel/kapplication.cpp:419
#11 0x00007fe2876b651e in _XIOError () from /usr/lib64/libX11.so.6
#12 0x00007fe2876b3e2d in _XEventsQueued () from /usr/lib64/libX11.so.6
#13 0x00007fe2876a481f in XEventsQueued () from /usr/lib64/libX11.so.6
#14 0x00007fe2862d0dcc in ?? () from /usr/lib64/libQtGui.so.4
#15 0x00007fe27f54b264 in g_main_context_check () from /usr/lib64/libglib-2.0.so.0
#16 0x00007fe27f54bab2 in ?? () from /usr/lib64/libglib-2.0.so.0
#17 0x00007fe27f54bf59 in g_main_context_iteration () from /usr/lib64/libglib-2.0.so.0
#18 0x00007fe286e89586 in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/libQtCore.so.4
#19 0x00007fe2862d0f9e in ?? () from /usr/lib64/libQtGui.so.4
#20 0x00007fe286e5da32 in QEventLoop::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/libQtCore.so.4
#21 0x00007fe286e5dc2f in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/libQtCore.so.4
#22 0x00007fe2866dff86 in QDialog::exec() () from /usr/lib64/libQtGui.so.4
#23 0x00007fe288880c9a in KMessageBox::createKMessageBox (dialog=0xd04b10, icon=<optimized out>, text=..., strlist=<optimized out>, ask=..., checkboxReturn=0x0, options=..., details=..., notifyType=QMessageBox::Critical) at /usr/src/debug/kdelibs-4.7.2/kdeui/dialogs/kmessagebox.cpp:344
#24 0x00007fe2888814cb in KMessageBox::createKMessageBox (dialog=0xd04b10, icon=QMessageBox::Critical, text=..., strlist=..., ask=..., checkboxReturn=0x0, options=..., details=...) at /usr/src/debug/kdelibs-4.7.2/kdeui/dialogs/kmessagebox.cpp:159
#25 0x00007fe28888210b in KMessageBox::errorListWId (parent_id=0, text=..., strlist=..., caption=..., options=...) at /usr/src/debug/kdelibs-4.7.2/kdeui/dialogs/kmessagebox.cpp:854
#26 0x00007fe2888822c5 in KMessageBox::error (parent=<optimized out>, text=..., caption=..., options=<optimized out>) at /usr/src/debug/kdelibs-4.7.2/kdeui/dialogs/kmessagebox.cpp:821
#27 0x00007fe2527cb05e in Collections::SqlCollection::SqlCollection(QString const&, QString const&, SqlStorage*) () from /usr/lib64/libamarok-sqlcollection.so.1
#28 0x00007fe2527ccd4f in Collections::SqlCollectionFactory::createSqlCollection(QString const&, QString const&, SqlStorage*) const () from /usr/lib64/libamarok-sqlcollection.so.1
#29 0x00007fe252a32eaa in ?? () from /usr/lib64/kde4/amarok_collection-mysqlecollection.so
#30 0x00007fe287dda2e9 in CollectionManager::loadPlugins(QList<Collections::CollectionFactory*> const&) () from /usr/lib64/libamaroklib.so.1
#31 0x00007fe287dddf74 in CollectionManager::init(QList<Plugins::PluginFactory*> const&) () from /usr/lib64/libamaroklib.so.1
#32 0x00007fe287f3d30a in Plugins::PluginManager::init() () from /usr/lib64/libamaroklib.so.1
#33 0x00007fe287f3e559 in Plugins::PluginManager::PluginManager(QObject*) () from /usr/lib64/libamaroklib.so.1
#34 0x00007fe287f3e727 in Plugins::PluginManager::instance() () from /usr/lib64/libamaroklib.so.1
#35 0x00007fe287f2065d in MainWindow::MainWindow() () from /usr/lib64/libamaroklib.so.1
#36 0x00007fe287ef82ce in App::continueInit() () from /usr/lib64/libamaroklib.so.1
#37 0x00007fe287ef9a8c in App::App() () from /usr/lib64/libamaroklib.so.1
#38 0x00000000004093c5 in ?? ()
#39 0x00007fe2857ce23d in __libc_start_main () from /lib64/libc.so.6
#40 0x000000000040bf9d in _start ()

This bug may be a duplicate of or related to bug 288385.

Possible duplicates by query: bug 299413, bug 298425, bug 298112, bug 298052, bug 298050.

Reproducible: Always
Comment 1 Myriam Schweingruber 2012-05-17 15:15:37 UTC 
Please install the amarok debugging package and try again, your backtrace is not useful.

FWIW: this is most likely a MySQL packaging problem on Opensuse, please report it to them, as there is apparently no MySQLe available with that version.
Comment 2 Haro de Grauw 2012-05-17 21:23:34 UTC 
For reference, openSUSE bugzilla link:
https://bugzilla.novell.com/show_bug.cgi?id=712749

Everything currently working fine after downgrading MySQL from 5.5.23 to 5.5.16 (which is what everyone seems to be doing).

Thank you for your input Myriam. On the assumption that this will be fixed at the packaging level, I'm closing the bug here.
Comment 3 Maarten ter Huurne 2012-05-19 09:16:40 UTC 
Downgrading MySQL, specifically the libmysqld18 package, worked for me as well. Other openSUSE users bitten by this problem, please try this as a workaround:

zypper install --force libmysqld18-5.5.16
Comment 4 Myriam Schweingruber 2012-05-20 03:12:07 UTC 
*** Bug 295609 has been marked as a duplicate of this bug. ***
Comment 5 Myriam Schweingruber 2012-05-23 23:35:20 UTC 
*** Bug 300495 has been marked as a duplicate of this bug. ***
Comment 6 Myriam Schweingruber 2012-05-31 11:22:40 UTC 

*** This bug has been marked as a duplicate of bug 288891 ***