Bug 251515 - Amarok crashes on exit every time [@ MySqlStorage::query]
Summary: Amarok crashes on exit every time [@ MySqlStorage::query]
Status: RESOLVED WORKSFORME
Alias: None
Product: amarok
Classification: Applications
Component: Collections/Local (show other bugs)
Version: 2.4-GIT
Platform: Ubuntu Linux
: NOR crash
Target Milestone: 2.4.0
Assignee: Amarok Developers
URL:
Keywords:
: 252724 252754 252871 253331 253737 254418 254758 271382 (view as bug list)
Depends on:
Blocks:
 
Reported: 2010-09-16 23:29 UTC by manu.wagner
Modified: 2011-04-21 12:19 UTC (History)
12 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments
New crash information added by DrKonqi (14.47 KB, text/plain)
2010-10-31 12:22 UTC, revenant_x
Details
New crash information added by DrKonqi (15.72 KB, text/plain)
2010-11-12 22:25 UTC, Petr Kočandrle
Details
New crash information added by DrKonqi (17.99 KB, text/plain)
2010-12-05 18:39 UTC, kat
Details

Note You need to log in before you can comment on or make changes to this bug.
Description manu.wagner 2010-09-16 23:29:51 UTC
Application: amarok (2.3-GIT)
KDE Platform Version: 4.5.1 (KDE 4.5.1)
Qt Version: 4.7.0
Operating System: Linux 2.6.32-23-generic x86_64
Distribution: Ubuntu 10.04.1 LTS

-- Information about the crash:
- What I was doing when the application crashed:
Quitting amarok 2.3 git
Every time I quit amarok I get a kde crash.
system : ubuntu 10.04 + kde 4.5.1 (ubuntu ppa) + qt 4.7 + amarok 2.3 git compiled from sources

The crash can be reproduced every time.

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

Thread 9 (Thread 0x7ffc65756710 (LWP 3026)):
#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1  0x0000003910e308b2 in ?? () from /usr/lib/libvlccore.so.4
#2  0x00000033bbc069ca in start_thread (arg=<value optimized out>) at pthread_create.c:300
#3  0x00000033bb4e66fd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#4  0x0000000000000000 in ?? ()

Thread 8 (Thread 0x7ffc604e0710 (LWP 3891)):
#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1  0x00000032ddc7beab in QWaitCondition::wait(QMutex*, unsigned long) () from /usr/lib/libQtCore.so.4
#2  0x0000003ff6e09d84 in ?? () from /usr/lib/libthreadweaver.so.4
#3  0x0000003ff6e0cf8b in ?? () from /usr/lib/libthreadweaver.so.4
#4  0x0000003ff6e0cfa4 in ?? () from /usr/lib/libthreadweaver.so.4
#5  0x0000003ff6e0cfa4 in ?? () from /usr/lib/libthreadweaver.so.4
#6  0x0000003ff6e0cfa4 in ?? () from /usr/lib/libthreadweaver.so.4
#7  0x0000003ff6e0b4ff in ?? () from /usr/lib/libthreadweaver.so.4
#8  0x0000003ff6e0ba58 in ThreadWeaver::Thread::run() () from /usr/lib/libthreadweaver.so.4
#9  0x00000032ddc7b2ee in ?? () from /usr/lib/libQtCore.so.4
#10 0x00000033bbc069ca in start_thread (arg=<value optimized out>) at pthread_create.c:300
#11 0x00000033bb4e66fd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#12 0x0000000000000000 in ?? ()

Thread 7 (Thread 0x7ffc5fcdf710 (LWP 3893)):
#0  0x00000033bb4aa38d in nanosleep () at ../sysdeps/unix/syscall-template.S:82
#1  0x00000033bb4aa200 in __sleep (seconds=<value optimized out>) at ../sysdeps/unix/sysv/linux/sleep.c:138
#2  0x00000032e5b9a776 in ?? () from /usr/lib/libQtScript.so.4
#3  0x00000032e5b9a819 in ?? () from /usr/lib/libQtScript.so.4
#4  0x00000033bbc069ca in start_thread (arg=<value optimized out>) at pthread_create.c:300
#5  0x00000033bb4e66fd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#6  0x0000000000000000 in ?? ()

Thread 6 (Thread 0x7ffc5548c710 (LWP 4148)):
#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1  0x00000032ddc7beab in QWaitCondition::wait(QMutex*, unsigned long) () from /usr/lib/libQtCore.so.4
#2  0x0000003ff6e09d84 in ?? () from /usr/lib/libthreadweaver.so.4
#3  0x0000003ff6e0cf8b in ?? () from /usr/lib/libthreadweaver.so.4
#4  0x0000003ff6e0cfa4 in ?? () from /usr/lib/libthreadweaver.so.4
#5  0x0000003ff6e0cfa4 in ?? () from /usr/lib/libthreadweaver.so.4
#6  0x0000003ff6e0b4ff in ?? () from /usr/lib/libthreadweaver.so.4
#7  0x0000003ff6e0ba58 in ThreadWeaver::Thread::run() () from /usr/lib/libthreadweaver.so.4
#8  0x00000032ddc7b2ee in ?? () from /usr/lib/libQtCore.so.4
#9  0x00000033bbc069ca in start_thread (arg=<value optimized out>) at pthread_create.c:300
#10 0x00000033bb4e66fd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#11 0x0000000000000000 in ?? ()

Thread 5 (Thread 0x7ffc5484d710 (LWP 4149)):
#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1  0x00000032ddc7beab in QWaitCondition::wait(QMutex*, unsigned long) () from /usr/lib/libQtCore.so.4
#2  0x0000003ff6e09d84 in ?? () from /usr/lib/libthreadweaver.so.4
#3  0x0000003ff6e0cf8b in ?? () from /usr/lib/libthreadweaver.so.4
#4  0x0000003ff6e0b4ff in ?? () from /usr/lib/libthreadweaver.so.4
#5  0x0000003ff6e0ba58 in ThreadWeaver::Thread::run() () from /usr/lib/libthreadweaver.so.4
#6  0x00000032ddc7b2ee in ?? () from /usr/lib/libQtCore.so.4
#7  0x00000033bbc069ca in start_thread (arg=<value optimized out>) at pthread_create.c:300
#8  0x00000033bb4e66fd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#9  0x0000000000000000 in ?? ()

Thread 4 (Thread 0x7ffc5404c710 (LWP 4150)):
[KCrash Handler]
#6  0x00007ffc64a4a43d in emb_read_query_result (mysql=0x2042450) at lib_sql.cc:262
#7  0x00007ffc64a39ca2 in mysql_real_query (mysql=0x2042450, 
    query=0x3453748 "SELECT urls.deviceid, urls.rpath, urls.uniqueid, tracks.id, tracks.title, tracks.comment, tracks.tracknumber, tracks.discnumber, statistics.score, statistics.rating, tracks.bitrate, tracks.length, tra"..., length=1040) at client.c:2920
#8  0x00007ffc64a3c641 in mysql_query (mysql=0x2042450, 
    query=0x3453748 "SELECT urls.deviceid, urls.rpath, urls.uniqueid, tracks.id, tracks.title, tracks.comment, tracks.tracknumber, tracks.discnumber, statistics.score, statistics.rating, tracks.bitrate, tracks.length, tra"...) at libmysql.c:1095
#9  0x00007ffc64a2f928 in MySqlStorage::query (this=0x1f57440, statement=...) at /home/manu/kde/src/amarok/src/core-impl/collections/sqlcollection/mysql-shared/MySqlStorage.cpp:122
#10 0x00007ffc6454d3d4 in Collections::SqlQueryMakerInternal::run (this=0x4d17fc0) at /home/manu/kde/src/amarok/src/core-impl/collections/sqlcollection/SqlQueryMakerInternal.cpp:48
#11 0x00007ffc6454a932 in SqlWorkerThread::run (this=0x3bea320) at /home/manu/kde/src/amarok/src/core-impl/collections/sqlcollection/SqlQueryMaker.cpp:65
#12 0x0000003ff6e0c1e1 in ?? () from /usr/lib/libthreadweaver.so.4
#13 0x0000003ff6e0c4de in ThreadWeaver::Job::execute(ThreadWeaver::Thread*) () from /usr/lib/libthreadweaver.so.4
#14 0x0000003ff6e0b4cf in ?? () from /usr/lib/libthreadweaver.so.4
#15 0x0000003ff6e0ba58 in ThreadWeaver::Thread::run() () from /usr/lib/libthreadweaver.so.4
#16 0x00000032ddc7b2ee in ?? () from /usr/lib/libQtCore.so.4
#17 0x00000033bbc069ca in start_thread (arg=<value optimized out>) at pthread_create.c:300
#18 0x00000033bb4e66fd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#19 0x0000000000000000 in ?? ()

Thread 3 (Thread 0x7ffc52bbf710 (LWP 4151)):
#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1  0x00000032e2a53bbe in ?? () from /usr/lib/libQtWebKit.so.4
#2  0x00000032e2a53cd9 in ?? () from /usr/lib/libQtWebKit.so.4
#3  0x00000033bbc069ca in start_thread (arg=<value optimized out>) at pthread_create.c:300
#4  0x00000033bb4e66fd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#5  0x0000000000000000 in ?? ()

Thread 2 (Thread 0x7ffc560bf710 (LWP 27684)):
#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:211
#1  0x00000032ddc7be12 in QWaitCondition::wait(QMutex*, unsigned long) () from /usr/lib/libQtCore.so.4
#2  0x00000032ddc70e22 in ?? () from /usr/lib/libQtCore.so.4
#3  0x00000032ddc7b2ee in ?? () from /usr/lib/libQtCore.so.4
#4  0x00000033bbc069ca in start_thread (arg=<value optimized out>) at pthread_create.c:300
#5  0x00000033bb4e66fd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#6  0x0000000000000000 in ?? ()

Thread 1 (Thread 0x7ffc95768780 (LWP 3008)):
#0  0x00000033bb4d9f83 in *__GI___poll (fds=<value optimized out>, nfds=<value optimized out>, timeout=<value optimized out>) at ../sysdeps/unix/sysv/linux/poll.c:87
#1  0x00000033bdc092da in ?? () from /usr/lib/libxcb.so.1
#2  0x00000033bdc09837 in ?? () from /usr/lib/libxcb.so.1
#3  0x00000033bdc09ae5 in xcb_writev () from /usr/lib/libxcb.so.1
#4  0x00000033bd4427ec in _XSend () from /usr/lib/libX11.so.6
#5  0x00000033bd4428d7 in _XReply () from /usr/lib/libX11.so.6
#6  0x00000033bd43e483 in XSync () from /usr/lib/libX11.so.6
#7  0x00000032dfe46eae in ?? () from /usr/lib/libQtGui.so.4
#8  0x00000032dfdd5db7 in QApplication::~QApplication() () from /usr/lib/libQtGui.so.4
#9  0x00007ffc970ea20e in ~App (this=0x7fff3e2fd160, __in_chrg=<value optimized out>) at /home/manu/kde/src/amarok/src/App.cpp:286
#10 0x000000000040b037 in main (argc=3, argv=0x7fff3e2ff0b8) at /home/manu/kde/src/amarok/src/main.cpp:237

Possible duplicates by query: bug 208468.

Reported using DrKonqi
Comment 1 Myriam Schweingruber 2010-09-17 11:20:25 UTC
Which MySQL version do you use? This looks very much like a problem in MySQL itself
Comment 2 Myriam Schweingruber 2010-09-29 11:23:47 UTC
*** Bug 252724 has been marked as a duplicate of this bug. ***
Comment 3 Myriam Schweingruber 2010-09-29 11:24:46 UTC
To both reporters: Do you use the embedded MySQL or do you use an external database? Also please specify which MySQL version you use.
Comment 4 Nikita Krupenko 2010-09-29 11:31:05 UTC
I use embedded MySQL version 5.1.46-4.1mdv2010.1. Amarok 2.3.2 compiled from sources.
Comment 5 Myriam Schweingruber 2010-09-29 11:36:19 UTC
Thank you for the feedback.
Comment 6 Myriam Schweingruber 2010-09-29 23:50:51 UTC
*** Bug 252754 has been marked as a duplicate of this bug. ***
Comment 7 Myriam Schweingruber 2010-10-06 01:37:08 UTC
*** Bug 253331 has been marked as a duplicate of this bug. ***
Comment 8 Myriam Schweingruber 2010-10-10 16:02:07 UTC
*** Bug 253737 has been marked as a duplicate of this bug. ***
Comment 9 Myriam Schweingruber 2010-10-17 10:51:47 UTC
*** Bug 254418 has been marked as a duplicate of this bug. ***
Comment 10 Myriam Schweingruber 2010-10-17 10:57:04 UTC
*** Bug 252871 has been marked as a duplicate of this bug. ***
Comment 11 Myriam Schweingruber 2010-10-20 13:21:13 UTC
*** Bug 254758 has been marked as a duplicate of this bug. ***
Comment 12 Māris Nartišs 2010-10-21 08:14:38 UTC
mysql-5.1.51 amarok-2.3.2-r1 both emerged without embedded MySQL support on Gentoo ~AMD64.

OFT: Strange that DrKonqui wasn't considering this issue to be related to #254758
Comment 13 revenant_x 2010-10-31 12:22:23 UTC
Created attachment 53011 [details]
New crash information added by DrKonqi

Amarok crash by Exit
Comment 14 Petr Kočandrle 2010-11-12 22:25:00 UTC
Created attachment 53370 [details]
New crash information added by DrKonqi

amarok (2.3.2) on KDE Platform 4.5.2 (KDE 4.5.2) using Qt 4.7.0

I was closing the application through tray icon. It doesn't fall everytime. In some cases it close properly and I can run it again and close without falling down until I change current track in playlist. But changing it back doesn't help.

-- Backtrace (Reduced):
#7  0x00007fe81f8c20a7 in my_message_sql (error=1317, str=0x2025014 "Query execution was interrupted", MyFlags=0) at ../sql/mysqld.cc:2987
#8  0x00007fe81faa7012 in send_kill_message (join=0x7fe808063ea0, join_tab=0x7fe808069148, error=<value optimized out>) at ../sql/sql_class.h:2172
#9  evaluate_join_record (join=0x7fe808063ea0, join_tab=0x7fe808069148, error=<value optimized out>) at sql_select.cc:11452
#10 0x00007fe81faab5ae in sub_select (join=0x7fe808063ea0, join_tab=0x7fe808069148, end_of_records=<value optimized out>) at sql_select.cc:11416
#11 0x00007fe81fab6445 in do_select (join=0x7fe808063ea0, fields=0x0, table=0x7fe808070e00, procedure=0x0) at sql_select.cc:11168
Comment 15 kat 2010-12-05 18:39:28 UTC
Created attachment 54173 [details]
New crash information added by DrKonqi

amarok (2.3.2) on KDE Platform 4.5.3 (KDE 4.5.3) using Qt 4.7.0

- What I was doing when the application crashed:

I had attached a CD-R with MP3 files on it. 
I added tracks to the playlist from my local collection which is on a NAS by selecting and droping them on the Add To Playlist in the center bar
 then added some tracks from the CD to the playlist by selecting them in Nautilus and dragging them to the playlist.
Then I pushed play. 
Listened for a few moments
then went to File... Quit...

Amarok Crashed.

-- Backtrace (Reduced):
#8  0x00007ffdc7cbd4fb in __libc_message (do_abort=<value optimized out>, fmt=<value optimized out>) at ../sysdeps/unix/sysv/linux/libc_fatal.c:189
#9  0x00007ffdc7cc75b6 in malloc_printerr (action=3, str=0x7ffdc7d9acd8 "double free or corruption (!prev)", ptr=<value optimized out>) at malloc.c:6266
[...]
#11 0x00007ffd931aa5e9 in vio_delete () from /usr/lib/libmysqlclient.so.16
#12 0x00007ffd931a63a0 in end_server () from /usr/lib/libmysqlclient.so.16
#13 0x00007ffd931a8362 in mysql_close () from /usr/lib/libmysqlclient.so.16
Comment 16 Myriam Schweingruber 2010-12-05 18:58:19 UTC
Is this still valid for current 2.4-git? I can't reproduce this here at all, using 2.4 git of today on KDE 4.6 beta1, Kubuntu 10.10
Comment 17 kat 2010-12-06 12:14:43 UTC
I am able to reproduce the crash every time. Am using Ubuntu (Gnome desktop) and not Kubuntu. Maybe this is the difference?
Comment 18 Myriam Schweingruber 2010-12-06 15:15:37 UTC
Kat, did you see what version I was talking about? Unless you are running the latest 2.4-git build your version is older.
Can somebody reproduce this with the latest git build?
Comment 19 kat 2010-12-06 17:50:53 UTC
My appologies... 
My git version is much older...

kat@linus:~$ git --version
git version 1.7.0.4

Amarok
versie 2.3.2
Gebruikmakend van KDE 4.5.3 (KDE 4.5.3)

I'll back out of this bug report and see if I can find a newer version of Amarok to test the behaviour against.
Comment 20 Myriam Schweingruber 2011-01-10 22:19:48 UTC
Closing correctly.
Comment 21 kat 2011-01-14 22:50:05 UTC
I don't know yet if this is resolved. I haven't been able to get the git version to install on Ubuntu 10.04. Plus work time constraints.
Comment 22 Myriam Schweingruber 2011-04-21 12:19:00 UTC
*** Bug 271382 has been marked as a duplicate of this bug. ***