GNOME Bugzilla – Bug 552608
Files removed from disk not removed from library on rescan
Last modified: 2009-12-30 00:48:00 UTC
Please describe the problem: While rescanning the library imports new files, it does not remove files from the library, that aren't present on the disk anymore. Steps to reproduce: 1. delete songs from disk 2. rescan library 3. deleted songs still present in banshee Actual results: Expected results: song disappeared from library Does this happen every time? yes Other information:
Can you still reproduce this bug in 1.4.2 or svn trunk?
yes, i still see this in revision 5021. i compiled banshee with --disable-docs and --disable-ipod. but it's also present in 1.4.2 from launchpad's ppa.
*** Bug 573642 has been marked as a duplicate of this bug. ***
Could run the following command (all in one line), where you replace filename.mp3 with the filename of one of the files that were not removed from the banshee library. sqlite3 ~/.config/banshee-1/banshee.db "select trackid, primarysourceid, uritype, uri from coretracks where uri like '%filename.mp3';" This query might tell why those files were not removed.
the output is the following for a deleted file: dominik@dominik-laptop:~$ sqlite3 ~/.config/banshee-1/banshee.db "select trackid, primarysourceid, uritype, uri from coretracks where uri like '%09 - Appollonia.mp3';" dominik@dominik-laptop:~$ whereas for an existing file: dominik@dominik-laptop:~$ sqlite3 ~/.config/banshee-1/banshee.db "select trackid, primarysourceid, uritype, uri from coretracks where uri like '%11. The View.mp3';" 9003|1|1|Modest Mouse/Good News For People Who Love Bad News/11. The View.mp3 dominik@dominik-laptop:~$
I'm not sure I understand what you mean : The "09 - Appollonia.mp3" file is not present on the disk but still visible in banshee ? The query seems to indicate that it's not present in the banshee database. The "11. The View.mp3" file seems fine, its path is relative to the library. If it wasn't, it wouldn't get cleaned up from the database by a rescan.
Exactly, the file appollonia.mp3 is not present on the disk. According to the query, it's also not present in the database, but it's still in my library in Banshee. So, I deleted my banshee.db, imported all my music, deleted a file, rescanned and then it was gone from the library. After that, I reimported my old banshee.db, deleted a file, rescanned, and it was gone. Now everything works as expected and I don't know what the problem was...
try using select title, uri from coretracks where title like "%_mp3 idv3 tag name_%"; You should get row(s) for files that have been moved/deleted.
$ ./Banshee.exe --version Banshee 1.6 Beta 2 (1.5.1) Just re-did a test, single file. Running from some version d/l via git. Seems to be working. Scanning process takes time. Status bar hides itself before process is done, tricking me into thinking that it failed/completed.
Closing per comment #9.