After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 652191 - Browsing of "Artists" folder leads to "timeout" in Marantz M-CR603
Browsing of "Artists" folder leads to "timeout" in Marantz M-CR603
Status: RESOLVED FIXED
Product: rygel
Classification: Applications
Component: MediaExport plugin
0.10.x
Other Linux
: Normal normal
: ---
Assigned To: Jens Georg
Zeeshan Ali
Depends on:
Blocks:
 
 
Reported: 2011-06-09 13:55 UTC by florent.angly
Modified: 2011-09-13 06:01 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
Artist lookup "timeout" (Rygel debug log) (39.18 KB, text/x-log)
2011-06-12 01:34 UTC, florent.angly
Details
Artist lookup "timeout" (Wireshark dump) (62.40 KB, application/cap)
2011-06-12 01:35 UTC, florent.angly
Details
Genre lookup (Rygel debug log) (60.95 KB, text/x-log)
2011-06-12 01:35 UTC, florent.angly
Details
Genre lookup (Wireshark dump) (97.56 KB, application/cap)
2011-06-12 01:36 UTC, florent.angly
Details

Description florent.angly 2011-06-09 13:55:28 UTC
When retrieving albums, genres, or years, I can see with the debug mode on that Rygel and the Media Export plugin are quite fast at returning results. However, when I try to retrieve artists, each artist retrieval is as slow as 1s. In practice, when retrieving 50 artists at a time, this takes way too long and my DLNA device (Marantz M-CR603) sort of times out and does not display any artists.
Comment 1 Jens Georg 2011-06-09 14:00:09 UTC
Can you please attach a wireshark dump of the communication between rygel and the device as well as a log output of rygel run with with -g 5?
Comment 2 florent.angly 2011-06-12 01:34:40 UTC
Created attachment 189746 [details]
Artist lookup "timeout" (Rygel debug log)
Comment 3 florent.angly 2011-06-12 01:35:21 UTC
Created attachment 189747 [details]
Artist lookup "timeout" (Wireshark dump)
Comment 4 florent.angly 2011-06-12 01:35:55 UTC
Created attachment 189748 [details]
Genre lookup (Rygel debug log)
Comment 5 florent.angly 2011-06-12 01:36:46 UTC
Created attachment 189750 [details]
Genre lookup (Wireshark dump)
Comment 6 florent.angly 2011-06-12 01:38:40 UTC
I attached Rygel debug logs and Wireshark dumps of what happens when I lookup artists (failure) or genres (success).
Comment 7 Jens Georg 2011-09-08 18:56:07 UTC
Does the following improve the situation:

echo "CREATE INDEX idx_artist_album ON meta_data(author,album); CREATE INDEX idx_album_artist ON meta_data(album,author); ANALYZE;" | sqlite3 $HOME/.cache/rygel/media-export.db

improve the situation?
Comment 8 florent.angly 2011-09-13 00:20:07 UTC
I don't know if you figured it out on your own, Jens, but the issue is specific of the MediaExport plugin. With the Tracker plugin, no such issue is present.

As for your command for the MediaExport database, it improves things a lot: querying artists is now very fast and does not time out. Thanks!
Comment 9 florent.angly 2011-09-13 00:21:45 UTC
And the SQLite command itself was fast too, which was a surprise as I thought that it would take some time.
Comment 10 Jens Georg 2011-09-13 06:01:48 UTC
This has been fixed with http://git.gnome.org/browse/rygel/commit/?id=9bdebf59bbc0010dd347e07948cbfc375e6908b6

commit 9bdebf59bbc0010dd347e07948cbfc375e6908b6
Author: Jens Georg <mail@jensge.org>
Date:   Thu Sep 8 21:17:47 2011 +0200

    media-export: Add indices for virtual containers


which will be included in the next stable release 0.12.1. Users of the previous stable release are advised to run the queries themselves.