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();"
Created attachment 43032 [details] Amarok chrash backtrace
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).
*** This bug has been marked as a duplicate of bug 225799 ***
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.
Created attachment 43039 [details] Debug output of crash
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?
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?
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.
(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.