mediascanner respawns on supposedly blacklisted video

[Alan Pope 🍺🐧🐱 🦄]

big_buck_bunny_480p_MPEG4_MP3_25fps_1600K.AVI in my Videos folder causes mediascanner to repeatedly / rapidly respawn and crash.

[Jussi Pakkanen (jpakkane)]

This is extremely strange. This happens also with a version compiled from trunk. The problem seems to be that MediaStore will claim that a file is not broken even if the file in question is in the database.

sqlite3 ~/.cache/mediascanner-2.0/mediastore.db "select * from broken_files;"

gives

/home/phablet/Videos/big_buck_bunny_480p_MPEG4_MP3_25fps_1600K_short.AVI|1409927801:865485

and so does

sqlite3 ~/.cache/mediascanner-2.0/mediastore.db "select * from broken_files where filename = '/home/phablet/Videos/big_buck_bunny_480p_MPEG4_MP3_25fps_1600K_short.AVI' and etag = '1409927801:865485';

However printf debugging on the device says that sqlite returns false when asked if the file is broken.

The major headache is that this seems to happen nondeterministically. Sometimes the system will work. Then you delete the entire cache directory and then magically it will start failing. Or maybe it doesn't. Something really strange is going on here.