Bug 235389

Summary:	Automated Playlist Generator Crash
Product:	[Applications] amarok	Reporter:	Jonas Norlander <jonorland>
Component:	Collections/Local	Assignee:	Amarok Developers <amarok-bugs-dist>
Status:	RESOLVED DUPLICATE
Severity:	crash	CC:	jonorland, stharward
Priority:	NOR
Version:	2.3.0.90
Target Milestone:	---
Platform:	Ubuntu
OS:	Linux
Latest Commit:		Version Fixed In:
Sentry Crash Report:
Attachments:	Amarok chrash backtrace Debug output of crash

Description Jonas Norlander 2010-04-25 21:31:24 UTC

Version:           2.3.0.90 (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...
sock_file=/home/jonas/.kde/socket-Tor/kdeinit4__0
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.