Bugzilla – Bug 5715
Advanced search for songs modified after 01/10/2007 froze the server
Last modified: 2014-08-05 16:07:45 UTC
In the new Default WebUI skin, I searched for songs that had a modification date later than 01/10/2007. The Web UI reported "Loading...", but after many minutes there was still no change in the display. I tried to abort the search by refreshing the browser. I even exited the browser and started another WebUI window, but the WebUI was not responding.
need log data for this. i can run this search, but of course get no results as the response. If the task is failing for a reason, then the log will often show "select task failed..." in the log.
I tried the same query again, and got the same effect. There doesn't appear to be any specific errors reported in the output stream. Do I need to turn on additional debug flags?
database.sql set to DEBUG should cover any search query. network.http to DEBUG covers web responses. is it just that date or do all date only queries fail for you?
When I perform the search, I get lots of sql debugging, so it seems like it is doing something, just not efficiently? [23:42:02.1610] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_track me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ?, ? ) ) AND ( me.track = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '1', '6', '394' [23:42:02.1645] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_track me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ?, ? ) ) AND ( me.track = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '1', '6', '394' [23:42:02.1686] Slim::Schema::Debug::query_start (26) SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( ( me.id = ? ) ): '394' [23:42:02.1736] Slim::Schema::Debug::query_start (26) SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'file:///M:/Music/Live%20Concerts/Anathema/2007-06-08/09%20-%20Judgement.flac' [23:42:02.1770] Slim::Schema::Debug::query_start (26) SELECT me.id, me.track, me.value FROM comments me WHERE ( me.track = ? ): '394' [23:42:02.2269] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_track me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.track = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '1', '394' [23:42:02.2297] Slim::Schema::Debug::query_start (26) SELECT genre.id, genre.name, genre.namesort, genre.namesearch, genre.musicmagic_mixable FROM genre_track me JOIN genres genre ON ( genre.id = me.genre ) WHERE ( me.track = ? ): '394' [23:42:02.2850] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' [23:42:07.2852] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' [23:42:11.2201] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_track me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ?, ? ) ) AND ( me.track = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '1', '6', '394' [23:42:11.2225] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_track me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ?, ? ) ) AND ( me.track = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '1', '6', '394' [23:42:11.2268] Slim::Schema::Debug::query_start (26) SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( ( me.id = ? ) ): '394' [23:42:11.2315] Slim::Schema::Debug::query_start (26) SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'file:///M:/Music/Live%20Concerts/Anathema/2007-06-08/09%20-%20Judgement.flac' [23:42:11.2347] Slim::Schema::Debug::query_start (26) SELECT me.id, me.track, me.value FROM comments me WHERE ( me.track = ? ): '394' [23:42:11.2824] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_track me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.track = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '1', '394' [23:42:11.2853] Slim::Schema::Debug::query_start (26) SELECT genre.id, genre.name, genre.namesort, genre.namesearch, genre.musicmagic_mixable FROM genre_track me JOIN genres genre ON ( genre.id = me.genre ) WHERE ( me.track = ? ): '394'
please fo logs as attachments. the word wrapping is a mess if you just paste.
Okay, I'll try to add as an attachment. I thought the whole reason for making the "Additional Comments" field on the bug report so wide as to not fit a browser window nicely, was so that people could just paste the log content into the comment field. I find it irritating that this field is so wide - if I add logs as an attachment, can someone make the comment field smaller please ;)
Created attachment 2304 [details] database.sql debug logging
QA to repro
I just tried but this works fine for me, Philip have you tested this against a more recent build?
Tried again with SVN 14403. All I am doing is going to advanced search and entering Date Modified after 01/10/2007. This has taken over 3 minutes without any response so far...
Strange it still works instantly for me, how large is your music library?
Total Albums: 1,612 Total Artists: 545 Total Tracks: 17,650
OK using Caleb's mega-mini-music (Thanks Caleb and Steven) I'm able to reproduce this. There are 35,033 songs in the library, advanced searching for modified after 1/10/2007 goes nowhere and eventually makes my 256mb ram virtual image go very slow.
Can you please retest with the latest 7.6?
Commit 6d8c1673b0126f9762699238933c7f64c531f8d8 - fixed in 7.9