Bug 235389 - Automated Playlist Generator Crash
Summary: Automated Playlist Generator Crash
Status: RESOLVED DUPLICATE of bug 225799
Alias: None
Product: amarok
Classification: Applications
Component: Collections/Local (show other bugs)
Platform: Ubuntu Linux
: NOR crash
Target Milestone: ---
Assignee: Amarok Developers
Depends on:
Reported: 2010-04-25 21:31 UTC by Jonas Norlander
Modified: 2010-04-26 21:34 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:

Amarok chrash backtrace (12.53 KB, application/octet-stream)
2010-04-25 21:34 UTC, Jonas Norlander
Debug output of crash (68.79 KB, text/x-log)
2010-04-26 08:42 UTC, Jonas Norlander

Note You need to log in before you can comment on or make changes to this bug.
Description Jonas Norlander 2010-04-25 21:31:24 UTC
Version:  (using KDE 4.4.2)
OS:                Linux
Installed from:    Ubuntu Packages

Wanted to test test the APG in Amarok Beta 1 so I installed it from Kubuntu Beta PPA. I can create a playlist but when I trying to run it Amarok chrashes. I can reproduce it every time withall possible options in APG. Output in console:

amarok: [APG::ConstraintSolver] Constraint Solver quality factor: 1 
amarok: [APG::ConstraintSolver] New ConstraintSolver with serial number 1132396525 
KCrash: Application 'amarok' crashing...
amarok:  [ERROR!] "GREPME MySQLe query failed! (1194) Table 'tracks' is marked as crashed and should be repaired on 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, tracks.filesize, tracks.samplerate, statistics.createdate, statistics.accessdate, statistics.playcount, tracks.filetype, tracks.bpm, tracks.createdate, 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  tracks INNER JOIN urls ON tracks.url = urls.id 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 LEFT JOIN statistics ON urls.id = statistics.url WHERE 1  AND urls.deviceid in (1,7,8,9,-1) AND ( 1  AND  ( 1 ) )  ORDER BY RAND();"
Comment 1 Jonas Norlander 2010-04-25 21:34:41 UTC
Created attachment 43032 [details]
Amarok chrash backtrace
Comment 2 Soren Harward 2010-04-26 01:41:44 UTC
This doesn't look like an APG bug.  Try either clearing your Amarok collection database, or following these instructions to repair the table: http://dev.mysql.com/doc/refman/5.0/en/myisam-repair.html .  If you still have problems, come back and post a debugging log (run "amarok --debug &> amarok-debug.log" and post the amarok-debug.log file here).
Comment 3 Soren Harward 2010-04-26 02:17:17 UTC

*** This bug has been marked as a duplicate of bug 225799 ***
Comment 4 Jonas Norlander 2010-04-26 08:34:25 UTC
I have tried to repair the tables and deactivate all scripts. myisamchk did not find any errors only "has not been shut down clean or reported was in use" but still got a crash. I have now also deactivate all Internet services and cover fetch from the settings and are now doing a full rescan. I attaching the debug output from last chrash and reporting back later today when the rescan is complete.
Comment 5 Jonas Norlander 2010-04-26 08:42:40 UTC
Created attachment 43039 [details]
Debug output of crash
Comment 6 Jonas Norlander 2010-04-26 09:35:47 UTC
I have now tried to repair the tables, deactivated all scripts, Internet services and all but the "Current Track" widget, done a full rescan of the collection and i still get the same chrash when i trying to add APG selection to the playlist (pressing the blue arrow). It don't look like a problem with last.fm to me as it is deactivated. The debug output in the console is just about the same so I don't attaching it again.

Anything else I can do?
Comment 7 Jonas Norlander 2010-04-26 10:09:16 UTC
One more thing: I Created a new user added two albums to the collection, trying to add a APG and Amarok crash so we can exclude that it is a config or database errors for my user. Could it be a bug introduced with Kubuntu and the PPA packages?
Comment 8 Soren Harward 2010-04-26 14:56:42 UTC
Yeah, this is definitely not an APG crash.  It's a crash in SqlCollection, possibly with SqlQueryMaker.  It shows up in the APG because the APG uses QueryMaker, as does the Last.fm similar artists Bias in the Dynamic system.  So this bug really is a dupe of 225799, and is unrelated to the APG.

Jonas: if you don't mind, please make a tarball of your MySQL directory and email it to me:

cd ~/.kde4/share/apps/amarok/
tar zcf jonas-amarok-mysql.tar.gz mysqle/

This is the only way I'm going to be able to get to the bottom of this crash.
Comment 9 Jonas Norlander 2010-04-26 21:34:40 UTC
(In reply to comment #8)
> Jonas: if you don't mind, please make a tarball of your MySQL directory and
> email it to me:
> cd ~/.kde4/share/apps/amarok/
> tar zcf jonas-amarok-mysql.tar.gz mysqle/
> This is the only way I'm going to be able to get to the bottom of this crash.

I mailed you a link to a tarball of my database.