Package: banshee
Version: 2.6.2-2
Followup-For: Bug #766560
Same here, and makes banshee quite unusable. Some snippets from the log:
banshee --debug-sql
shows after a couple of similar lines:
[1 Warn 20:54:16.067] HyenaSqliteConnection command issued from the main thread
[4 Debug 20:55:19.625] Executed in 63558ms
DELETE FROM CoreCache WHERE ModelID = 1286;
INSERT INTO CoreCache (ModelID, ItemID) SELECT 1286,
CoreTracks.TrackID
FROM (SELECT MIN(CoreTracks.TrackID) AS TrackID,
CoreTracks.Year FROM CoreTracks GROUP BY CoreTracks.Year) AS CoreTracks
WHERE CoreTracks.Year IN
(SELECT CoreTracks.Year FROM CoreTracks, CoreCache
WHERE CoreCache.ModelID = 19 AND
CoreCache.ItemID = CoreTracks.TrackID )
ORDER BY Year
I have this specific SQL statement three times in the log, each time taking
about the same
amount of time. All other SQL statements in the log take less than 100 ms.
Hope that helps,
thanks
Florian
-- System Information:
Debian Release: 8.0
APT prefers testing
APT policy: (500, 'testing')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 3.16.0-4-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages banshee depends on:
ii gnome-icon-theme 3.12.0-1
ii gstreamer1.0-plugins-bad [gstreamer1.0-audi 1.4.4-2
ii gstreamer1.0-plugins-base 1.4.4-2
ii gstreamer1.0-plugins-good [gstreamer1.0-aud 1.4.4-2
ii gstreamer1.0-pulseaudio [gstreamer1.0-audio 1.4.4-2
ii libboo2.0.9-cil 0.9.5~git20110729.r1.202a430-2
ii libc6 2.19-13
ii libcairo2 1.14.0-2.1
ii libdbus-glib-1-2 0.102-1
ii libdbus-glib2.0-cil 0.6.0-1
ii libdbus2.0-cil 0.8.1-1
ii libgconf2.0-cil 2.24.2-3
ii libgdata2.1-cil 2.2.0.0-2
ii libgdk-pixbuf2.0-0 2.31.1-2+b1
ii libgkeyfile1.0-cil 0.1-4
ii libglib2.0-0 2.42.1-1
ii libglib2.0-cil 2.12.10-5
ii libgpod4 0.8.3-1.1+b1
ii libgstreamer-plugins-base1.0-0 1.4.4-2
ii libgstreamer1.0-0 1.4.4-2
ii libgtk-sharp-beans-cil 2.14.1-3
ii libgtk2.0-0 2.24.25-1
ii libgtk2.0-cil 2.12.10-5
ii libgudev1.0-cil 0.1-3
ii libkarma0 0.1.2-2.3
ii libmono-addins0.2-cil 1.0+git20130406.adcd75b-3
ii libmono-cairo4.0-cil 3.2.8+dfsg-8
ii libmono-corlib4.5-cil 3.2.8+dfsg-8
ii libmono-posix4.0-cil 3.2.8+dfsg-8
ii libmono-sharpzip4.84-cil 3.2.8+dfsg-8
ii libmono-system-core4.0-cil 3.2.8+dfsg-8
ii libmono-system-xml4.0-cil 3.2.8+dfsg-8
ii libmono-system4.0-cil 3.2.8+dfsg-8
ii libmono-zeroconf1.0-cil 0.9.0-4
ii libmtp9 1.1.8-1+b1
ii libnotify0.4-cil 0.4.0~r3032-7
ii libpango-1.0-0 1.36.8-3
ii libpangocairo-1.0-0 1.36.8-3
ii libsoup-gnome2.4-1 2.48.0-1
ii libsoup2.4-1 2.48.0-1
ii libsqlite3-0 3.8.7.1-1
ii libtaglib2.1-cil 2.1.0.0-3
ii libwebkitgtk-1.0-0 2.4.7-2
ii libwnck22 2.30.7-2
ii libx11-6 2:1.6.2-3
ii libxrandr2 2:1.4.2-1+b1
ii libxxf86vm1 1:1.1.3-1+b1
ii mono-runtime 3.2.8+dfsg-8
Versions of packages banshee recommends:
ii avahi-daemon 0.6.31-4+b2
ii brasero 3.11.4-1
ii gstreamer1.0-pulseaudio 1.4.4-2
ii media-player-info 22-2
Versions of packages banshee suggests:
pn banshee-dbg <none>
pn gstreamer1.0-ffmpeg <none>
ii gstreamer1.0-plugins-bad 1.4.4-2
ii gstreamer1.0-plugins-ugly 1.4.4-2
-- no debconf information
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
