| Summary: | Amarok crashes after "MySQLe query failed! (23) Out of resources when opening file" message | ||
|---|---|---|---|
| Product: | [Applications] amarok | Reporter: | Myriam Schweingruber <myriam> |
| Component: | Collections/Local | Assignee: | Amarok Developers <amarok-bugs-dist> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | crash | CC: | matej, myriam, ralf-engels |
| Priority: | NOR | Keywords: | regression |
| Version: | 2.7-git | ||
| Target Milestone: | 2.8 | ||
| Platform: | Ubuntu | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
| Attachments: | New crash information added by DrKonqi | ||
|
Description
Myriam Schweingruber
2013-01-18 17:51:28 UTC
Created attachment 76734 [details]
New crash information added by DrKonqi
amarok (2.7-git) on KDE Platform 4.9.98 using Qt 4.8.3
Now the backtrace is slightly different.
-- Backtrace (Reduced):
#6 0x00007fac81bf4425 in __GI_raise (sig=<optimized out>) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
#7 0x00007fac81bf7b8b in __GI_abort () at abort.c:91
[...]
#11 0x00007fac640e3c30 in KSharedPtr<Meta::SqlTrack>::operator-> (this=0x7fac5a6e28f0) at /usr/include/ksharedptr.h:126
#12 0x00007fac64158b1a in SqlScanResultProcessor::commitTrack (this=0x7fac4c022920, track=0x7fac4c246b50, srcAlbum=0x7fac4cc90150) at /home/myriam/kde/src/amarok/src/core-impl/collections/db/sql/SqlScanResultProcessor.cpp:173
#13 0x00007fac6415815f in SqlScanResultProcessor::commitAlbum (this=0x7fac4c022920, album=0x7fac4cc90150) at /home/myriam/kde/src/amarok/src/core-impl/collections/db/sql/SqlScanResultProcessor.cpp:100
(In reply to comment #1) > Created attachment 76734 [details] > New crash information added by DrKonqi > > amarok (2.7-git) on KDE Platform 4.9.98 using Qt 4.8.3 > > Now the backtrace is slightly different. ... and it happens with a local playlist, not podcasts. I didn't do anything, just opened Amarok, it crashed after a few minutes, nothing playing: amarok: BEGIN: virtual void SqlScanResultProcessor::commit() amarok: BEGIN: void SqlScanResultProcessor::urlsCacheInit() amarok: END__: void SqlScanResultProcessor::urlsCacheInit() [Took: 0.68s] amarok: [SqlRegistry] SqlRegistry::getDirectory update Directory "67557" from 1358884721 to 1359135413 amarok: [SqlRegistry] "UPDATE directories SET changedate = 1359135413 WHERE id = 67557;" amarok: BEGIN: void Podcasts::GpodderProvider::requestEpisodeActionsInCascade() amarok: [GpodderProvider] Requesting actions for "http://deimhart.net/rss.php?version=2.0&podcast_format=ogg" amarok: END__: void Podcasts::GpodderProvider::requestEpisodeActionsInCascade() [Took: 0.002s] JSonScanner::yylex - unknown char, returning -1 amarok: BEGIN: void Podcasts::GpodderProvider::episodeActionsInCascadeParseError() amarok: [GpodderProvider] episodeActionsInCascade [Status Synchronization] - Parse Error amarok: END__: void Podcasts::GpodderProvider::episodeActionsInCascadeParseError() [Took: 0s] amarok: [SqlRegistry] SqlRegistry::getDirectory update Directory "67568" from 1358534245 to 1359113832 amarok: [SqlRegistry] "UPDATE directories SET changedate = 1359113832 WHERE id = 67568;" amarok: [SqlRegistry] SqlRegistry::getDirectory update Directory "67577" from 1358530648 to 1359113939 amarok: [SqlRegistry] "UPDATE directories SET changedate = 1359113939 WHERE id = 67577;" amarok: [SqlRegistry] SqlRegistry::getDirectory update Directory "67580" from 1358884666 to 1359113833 amarok: [SqlRegistry] "UPDATE directories SET changedate = 1359113833 WHERE id = 67580;" amarok: [SqlRegistry] SqlRegistry::getDirectory update Directory "67581" from 1358534202 to 1359133601 amarok: [SqlRegistry] "UPDATE directories SET changedate = 1359133601 WHERE id = 67581;" amarok: [SqlRegistry] SqlRegistry::getDirectory update Directory "67599" from 1358884703 to 1359113935 amarok: [SqlRegistry] "UPDATE directories SET changedate = 1359113935 WHERE id = 67599;" amarok: [SqlRegistry] SqlRegistry::getDirectory update Directory "67602" from 1358884723 to 1359113906 amarok: [SqlRegistry] "UPDATE directories SET changedate = 1359113906 WHERE id = 67602;" amarok: [SqlRegistry] SqlRegistry::getDirectory update Directory "67606" from 1358534205 to 1359130005 amarok: [SqlRegistry] "UPDATE directories SET changedate = 1359130005 WHERE id = 67606;" amarok: [SqlRegistry] SqlRegistry::getDirectory update Directory "67607" from 1358884668 to 1359113824 amarok: [SqlRegistry] "UPDATE directories SET changedate = 1359113824 WHERE id = 67607;" amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (23) Out of resources when opening file '/home/myriam/.kde/share/apps/amarok/mysqle/amarok/years.MYD' (Errcode: 24) on SELECT urls.id, urls.deviceid, urls.rpath, urls.directory, urls.uniqueid, tracks.id, tracks.title, tracks.comment, tracks.tracknumber, tracks.discnumber, statistics.score, statistics.rating, tracks.bitrate, tracks.length, tracks.filesize, tracks.samplerate, statistics.id, statistics.createdate, statistics.accessdate, statistics.playcount, tracks.filetype, tracks.bpm, tracks.createdate, tracks.modifydate, tracks.albumgain, tracks.albumpeakgain, tracks.trackgain, tracks.trackpeakgain, artists.name, artists.id, albums.name, albums.id, albums.artist, genres.name, genres.id, composers.name, composers.id, years.name, years.id FROM urls LEFT JOIN tracks ON urls.id = tracks.url LEFT JOIN statistics ON urls.id = statistics.url LEFT JOIN artists ON tracks.artist = artists.id LEFT JOIN albums ON tracks.album = albums.id LEFT JOIN genres ON tracks.genre = genres.id LEFT JOIN composers ON tracks.composer = composers.id LEFT JOIN years ON tracks.year = years.id WHERE urls.deviceid = 2 AND urls.rpath = './Podcasts/RTS - 120 secondes - Couleur 3/leve-toi-et-marche_20130125_standard_120-secondes_9a2646e0-332b-4d2c-899e-203208f0b648-128k.mp3';" amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (23) Out of resources when opening file '/home/myriam/.kde/share/apps/amarok/mysqle/amarok/years.MYD' (Errcode: 24) on SELECT id FROM years WHERE name = '2013';" amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (23) Out of resources when opening file '/home/myriam/.kde/share/apps/amarok/mysqle/amarok/years.MYD' (Errcode: 24) on INSERT INTO years( name ) VALUES ('2013');" amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (23) Out of resources when opening file '/home/myriam/.kde/share/apps/amarok/mysqle/amarok/years.MYD' (Errcode: 24) on SELECT urls.id, urls.deviceid, urls.rpath, urls.directory, urls.uniqueid, tracks.id, tracks.title, tracks.comment, tracks.tracknumber, tracks.discnumber, statistics.score, statistics.rating, tracks.bitrate, tracks.length, tracks.filesize, tracks.samplerate, statistics.id, statistics.createdate, statistics.accessdate, statistics.playcount, tracks.filetype, tracks.bpm, tracks.createdate, tracks.modifydate, tracks.albumgain, tracks.albumpeakgain, tracks.trackgain, tracks.trackpeakgain, artists.name, artists.id, albums.name, albums.id, albums.artist, genres.name, genres.id, composers.name, composers.id, years.name, years.id FROM urls LEFT JOIN tracks ON urls.id = tracks.url LEFT JOIN statistics ON urls.id = statistics.url LEFT JOIN artists ON tracks.artist = artists.id LEFT JOIN albums ON tracks.album = albums.id LEFT JOIN genres ON tracks.genre = genres.id LEFT JOIN composers ON tracks.composer = composers.id LEFT JOIN years ON tracks.year = years.id WHERE urls.deviceid = 2 AND urls.rpath = './Podcasts/RTS - 120 secondes - Couleur 3/leve-toi-et-marche_20130124_standard_120-secondes_d5b0786e-84cc-418f-aedb-d25ab3dd3c65-128k.mp3';" amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (23) Out of resources when opening file '/home/myriam/.kde/share/apps/amarok/mysqle/amarok/years.MYD' (Errcode: 24) on SELECT id FROM years WHERE name = '2013';" amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (23) Out of resources when opening file '/home/myriam/.kde/share/apps/amarok/mysqle/amarok/years.MYD' (Errcode: 24) on INSERT INTO years( name ) VALUES ('2013');" amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (23) Out of resources when opening file '/home/myriam/.kde/share/apps/amarok/mysqle/amarok/years.MYD' (Errcode: 24) on SELECT urls.id, urls.deviceid, urls.rpath, urls.directory, urls.uniqueid, tracks.id, tracks.title, tracks.comment, tracks.tracknumber, tracks.discnumber, statistics.score, statistics.rating, tracks.bitrate, tracks.length, tracks.filesize, tracks.samplerate, statistics.id, statistics.createdate, statistics.accessdate, statistics.playcount, tracks.filetype, tracks.bpm, tracks.createdate, tracks.modifydate, tracks.albumgain, tracks.albumpeakgain, tracks.trackgain, tracks.trackpeakgain, artists.name, artists.id, albums.name, albums.id, albums.artist, genres.name, genres.id, composers.name, composers.id, years.name, years.id FROM urls LEFT JOIN tracks ON urls.id = tracks.url LEFT JOIN statistics ON urls.id = statistics.url LEFT JOIN artists ON tracks.artist = artists.id LEFT JOIN albums ON tracks.album = albums.id LEFT JOIN genres ON tracks.genre = genres.id LEFT JOIN composers ON tracks.composer = composers.id LEFT JOIN years ON tracks.year = years.id WHERE urls.deviceid = 2 AND urls.rpath = './Podcasts/RTS - 120 secondes - Couleur 3/leve-toi-et-marche_20130123_standard_120-secondes_af453961-9770-4313-a5ea-a481f49b9bf5-128k.mp3';" amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (23) Out of resources when opening file '/home/myriam/.kde/share/apps/amarok/mysqle/amarok/years.MYD' (Errcode: 24) on SELECT id FROM years WHERE name = '2013';" amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (23) Out of resources when opening file '/home/myriam/.kde/share/apps/amarok/mysqle/amarok/years.MYD' (Errcode: 24) on INSERT INTO years( name ) VALUES ('2013');" amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (23) Out of resources when opening file '/home/myriam/.kde/share/apps/amarok/mysqle/amarok/years.MYD' (Errcode: 24) on SELECT urls.id, urls.deviceid, urls.rpath, urls.directory, urls.uniqueid, tracks.id, tracks.title, tracks.comment, tracks.tracknumber, tracks.discnumber, statistics.score, statistics.rating, tracks.bitrate, tracks.length, tracks.filesize, tracks.samplerate, statistics.id, statistics.createdate, statistics.accessdate, statistics.playcount, tracks.filetype, tracks.bpm, tracks.createdate, tracks.modifydate, tracks.albumgain, tracks.albumpeakgain, tracks.trackgain, tracks.trackpeakgain, artists.name, artists.id, albums.name, albums.id, albums.artist, genres.name, genres.id, composers.name, composers.id, years.name, years.id FROM urls LEFT JOIN tracks ON urls.id = tracks.url LEFT JOIN statistics ON urls.id = statistics.url LEFT JOIN artists ON tracks.artist = artists.id LEFT JOIN albums ON tracks.album = albums.id LEFT JOIN genres ON tracks.genre = genres.id LEFT JOIN composers ON tracks.composer = composers.id LEFT JOIN years ON tracks.year = years.id WHERE urls.id = 86907" ASSERT: "d" in file /usr/include/ksharedptr.h, line 126 Git commit 31f75878b6658b5c29fa681a1dc61454b35e502f by Ralf Engels. Committed on 12/02/2013 at 01:19. Pushed by rengels into branch 'master'. Fix: Amarok crashes on start if a playlist source is unavailable FIXED-IN: 2.8 M +3 -3 src/core-impl/collections/db/sql/SqlScanResultProcessor.cpp http://commits.kde.org/amarok/31f75878b6658b5c29fa681a1dc61454b35e502f Git commit ae35ba412120b3cbcfb1e651811b4669dab36cad by Matěj Laitl. Committed on 21/02/2013 at 00:43. Pushed by laitl into branch 'master'. Revert "Fix: Amarok crashes on start if a playlist source is unavailable" This reverts commit 31f75878b6658b5c29fa681a1dc61454b35e502f. Ralf, this is not the Q_ASSERT in SqlScanResultProcessor.cpp that fails, it is the metaTrack-> (i.e. KShatedPtr::operator->) that fails! This needs to be solved differently, reverting this for now. M +3 -3 src/core-impl/collections/db/sql/SqlScanResultProcessor.cpp http://commits.kde.org/amarok/ae35ba412120b3cbcfb1e651811b4669dab36cad > amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (23) Out of resources when opening file '/home/myriam/.kde/share/apps/amarok/mysqle/amarok/years.MYD' (Errcode: 24) on SELECT urls.id, urls.deviceid, urls.rpath, urls.directory, urls.uniqueid, tracks.id, tracks.title, tracks.comment, tracks.tracknumber, tracks.discnumber, statistics.score, statistics.rating, tracks.bitrate, tracks.length, tracks.filesize, tracks.samplerate, statistics.id, statistics.createdate, statistics.accessdate, statistics.playcount, tracks.filetype, tracks.bpm, tracks.createdate, tracks.modifydate, tracks.albumgain, tracks.albumpeakgain, tracks.trackgain, tracks.trackpeakgain, artists.name, artists.id, albums.name, albums.id, albums.artist, genres.name, genres.id, composers.name, composers.id, years.name, years.id FROM urls LEFT JOIN tracks ON urls.id = tracks.url LEFT JOIN statistics ON urls.id = statistics.url LEFT JOIN artists ON tracks.artist = artists.id LEFT JOIN albums ON tracks.album = albums.id LEFT JOIN genres ON tracks.genre = genres.id LEFT JOIN composers ON tracks.composer = composers.id LEFT JOIN years ON tracks.year = years.id WHERE urls.deviceid = 2 AND urls.rpath = './Podcasts/RTS - 120 secondes - Couleur 3/leve-toi-et-marche_20130125_standard_120-secondes_9a2646e0-332b-4d2c-899e-203208f0b648-128k.mp3';"
^^^^ Myriam, I think this is the root cause, the Amarok crash is just a consequence. I don't know what (23) Out of resources when opening file '/home/myriam/.kde/share/apps/amarok/mysqle/amarok/years.MYD' actually means, but it could be you running out of memory, disk partition space, open file descriptors or other system-imposed limit.
Please try to fix the problem with opening the database file and then try to reproduce. I just tried with v2.7.0-95-g914c24e and can't reproduce this anymore. But since I tried last time I cleaned up some stuff on that partition as it was quite full, so that might have been the problem indeed. |