Bug#662125: forked-daapd: scans whole DB on startup which takes ages

[Balint Reczey]

Control: tags -1 moreinfo

Hi Tino,

On Sun, 04 Mar 2012 11:21:48 +0100 Tino Keitel
<tino.keitel+debbugs at tikei.de> wrote:
> Package: forked-daapd
> Version: 0.19gcd-2
> Severity: normal
> 
> Hi,
> 
> whenever I start forked-daapd it takes several minutes until it gets usable.
> 
> When I start it using the command
> 
> 	$ forked -f -d 4 -D db,scan,config
> 
> I see thousands of lines like this:
> 
> db: Running query 'SELECT f.id, f.db_timestamp FROM files f WHERE f.path =
> '/home/storage2/mp3/music/Tomte/Hinter all diesen Fenstern/08 -
> Insecuritate.mp3';'
> 
> It looks like it scans the whole library. There is no high disk usage or CPU
> load during this, but it takes a view minutes.  Forked-daapd does not react
> to ctrl-C or SIGTERM for a while in that situation.  When I try to access
> forked-daapd using rhythmbox, it takes ~30 seconds to get the available
> music.
> 
> I expect forked-daapd to be instantly ready when nothing was changed in the
> library, and only scan files that changed since the last DB update, which
> should be fast enough. I also expect forked-daapd to respond to SIGTERM
> within a few seconds.
Could you please test the latest version in testing?
It has quite some improvements and may have improved the situation.

Cheers,
Balint