Mediascanner unable to find table "media_attic"

[maarten klop]

On Aquarius 4.5 Ubuntu, when running music, no files from SD card or dedicated music directory, (either mp3 or ogg) will be displayed in any view in the app.

Also, loading a file from file manager (this seems to be supported) causes the file to be succesfully moved to my music/imported, but then the app reports:
( Waiting for file(s)... )
->
Imported file not found (wait or cancel)

This causes me to think the app has no read permissions for home or the SD card

[Victor Thompson (vthompson)]

Hi Maarten! Thanks for reporting this issue and for helping to make Ubuntu better! Could you please attach the "/home/phablet/.cache/upstart/mediascanner*.log" file? Also, could you try to reboot your device to see if that remedies the issue? Thanks!

[maarten klop (mjdklop)]

I tried rebooting, also reinstalling the app. This did not resolve the issue.

mediascanner.log is a repetition (every second) of:

Mediascanner service starting at 2015-03-26 4:03:30.

terminate called after throwing an instance of 'std::runtime_error'
  what(): no such table: media_attic

I also have some other log.gz files, containing previous succesful scans:

tail of mediascanner-2.0.log.3:
.....
New file was created: /media/phablet/3131-6233/Muziek/Pain Discography - CX/(2007) Psalms of Extinction/12 Bitch.mp3.
New file was created: /media/phablet/3131-6233/Muziek/Nightwish - Ghost Love Score live from Buenos Aires 2012.mp3.
Extracting metadata from /media/phablet/3131-6233/Muziek/Nightwish - Ghost Love Score live from Buenos Aires 2012.mp3.

(mediascanner-service-2.0:18325): GStreamer-CRITICAL **: gst_date_time_new: assertion 'year > 0 && year <= 9999' failed

(mediascanner-service-2.0:18325): GStreamer-CRITICAL **: gst_mini_object_unref: assertion 'mini_object != NULL' failed

mediascanner-2.0.log.2 is very big and I have problems actually opening that one

[Victor Thompson (vthompson)]

I think you are experiencing something similar to bug #1436110. The file "/media/phablet/3131-6233/Muziek/Nightwish - Ghost Love Score live from Buenos Aires 2012.mp3" seems to have an invalid "year" field. Perhaps try either manually editing the year ID3 tag or removing the MP3.

Additionally, it sounds like the mediascanner database may be corrupted/incomplete. Try restarting the service ("service restart mediascanner-2.0") and watching the mediascanner-2.0.log file to see if the "what(): no such table: media_attic" errors go away. If it does not, you may want to do the following to correct the corrupted database:

service stop mediascanner-2.0
rm -r /home/phablet/.cache/mediascanner-2.0/*
service start mediascanner-2.0

[Victor Thompson (vthompson)]

I'm marking this as a duplicate of lp:1436110. Please let us know if this is not accurate.