Bug 350438

Summary: msg: file does not exist; full rescan deletes all files in local collection
Product: [Applications] amarok Reporter: lindadesjardins_84
Component: Collections/LocalAssignee: Amarok Bugs <amarok-bugs-null>
Status: RESOLVED NOT A BUG    
Severity: critical CC: matej, ralf-engels
Priority: NOR    
Version First Reported In: 2.8.0   
Target Milestone: 2.9   
Platform: Mint (Ubuntu based)   
OS: Linux   
Latest Commit: Version Fixed/Implemented In:
Sentry Crash Report:
Attachments: Terminal ouput for amarok -d --nofork > output

Description lindadesjardins_84 2015-07-21 02:22:38 UTC
Tried playing music from local collection but got the msg that the file does not exist. Went on line to find solution and suggestion was to reconfigure/full rescan. After the rescan was done, the local collection had no files listed. NB: the radio streaming station was still there and played.
Forum suggested: amarok -d --nofork > output  and send the output, but don't know how/where to upload file...

Reproducible: Always
Comment 1 lindadesjardins_84 2015-07-21 02:28:18 UTC
Created attachment 93676 [details]
Terminal ouput for amarok -d --nofork > output
Comment 2 Myriam Schweingruber 2015-07-21 08:54:59 UTC
A few questions: 
where is the collection located?
which exact Amarok version is this about (see Amarok Help menu -> About Amarok)?
which Linux distribution do you run?
Which exact KDE version do you use (see Amarok help menu -> About KDE)?
Comment 3 lindadesjardins_84 2015-07-21 19:44:39 UTC
Hi Myriam,
Thrilled that you replied!! Hopefully, this will help.

The music tracks (4500 of them...) were in Media sources - Local Music - 
Local Collection

Amarok Diagnostics

Amarok Version: 2.8.0
KDE Version: 4.13.3
Qt Version: 4.8.6
Phonon Version: 4.7.80
Phonon Backend: GStreamer (4.7.80)
PulseAudio: No

Amarok Scripts:
     Amarok Script Console 1.0 (stopped)
Lyricwiki .2 (running)
Free Music Charts 1.6.0 (running)
Librivox.org 1.0 (running)
Cool Streams 1.0 (running)

Amarok Plugins:
     AudioCd Collection (enabled)
DAAP Collection (disabled)
MTP Collection (enabled)
MySQLServer Collection (enabled)
MySQLe Collection (enabled)
Nepomuk Collection (disabled)
UPnP Collection (disabled)
Universal Mass Storage Collection (enabled)
iPod, iPad & iPhone Collection (enabled)
Ampache (disabled)
Jamendo (enabled)
Last.fm (enabled)
MP3 Music Store (disabled)
MP3tunes (disabled)
Magnatune Store (enabled)
Podcast Directory (enabled)
gpodder.net (disabled)

Linux Mint 17

Regards,
Linda d.

On 15-07-21 04:54 AM, Myriam Schweingruber wrote:
> https://bugs.kde.org/show_bug.cgi?id=350438
>
> Myriam Schweingruber <myriam@kde.org> changed:
>
>             What    |Removed                     |Added
> ----------------------------------------------------------------------------
>               Status|UNCONFIRMED                 |NEEDSINFO
>           Resolution|---                         |WAITINGFORINFO
>
> --- Comment #2 from Myriam Schweingruber <myriam@kde.org> ---
> A few questions:
> where is the collection located?
> which exact Amarok version is this about (see Amarok Help menu -> About
> Amarok)?
> which Linux distribution do you run?
> Which exact KDE version do you use (see Amarok help menu -> About KDE)?
>
Comment 4 Myriam Schweingruber 2015-07-21 21:31:31 UTC
Did you try re-selecting the music location as the collection, do a full rescan, then restart Amarok?

The output you posted didn't really yield any major problem but shows that some database tables are not accessible. (FWIW, you made a type that caused some errors at the start of the output, it's "amarok -d --nofork", not norfork).
Please make sure Amarok is correctly installed, including the MySQL dependencies. The only explanation is that somehow part of the mysql installation was removed, that's why the database became inaccessible, but I see no major errors in that output. You need to make sure you have the package libmysqld-pic in particular as this one provides the default embedded database support.
Comment 5 lindadesjardins_84 2015-07-21 23:17:42 UTC
I checked my synaptic pkg mgr and see that libqt4-sql-mysql 
4:4.8.5Pgitl92-g08'is installed (mysql database driver). I have now 
installed the libmysqld-pic which updated the other one (?)

For Amarok, installed are the following: amarok; amarok-common; amarok-utils

I'm a little nervous to do a full rescan of any other music files for 
fear of having them deleted or otherwise lost. Having said that, the 
files were not there before I looked for solutions which included the 
re-scanning.

Thanks again,
Nervous Newbie...

On 15-07-21 05:31 PM, Myriam Schweingruber wrote:
> https://bugs.kde.org/show_bug.cgi?id=350438
>
> Myriam Schweingruber <myriam@kde.org> changed:
>
>             What    |Removed                     |Added
> ----------------------------------------------------------------------------
>             Platform|Other                       |Mint (Ubuntu based)
>              Version|unspecified                 |2.8.0
>
> --- Comment #4 from Myriam Schweingruber <myriam@kde.org> ---
> Did you try re-selecting the music location as the collection, do a full
> rescan, then restart Amarok?
>
> The output you posted didn't really yield any major problem but shows that some
> database tables are not accessible. (FWIW, you made a type that caused some
> errors at the start of the output, it's "amarok -d --nofork", not norfork).
> Please make sure Amarok is correctly installed, including the MySQL
> dependencies. The only explanation is that somehow part of the mysql
> installation was removed, that's why the database became inaccessible, but I
> see no major errors in that output. You need to make sure you have the package
> libmysqld-pic in particular as this one provides the default embedded database
> support.
>
Comment 6 Myriam Schweingruber 2015-07-22 09:21:28 UTC
Doing a rescan doesn't touch the physical integrity of the files, it just tries to rebuild the database. Unless you proceed to move your files, which asks for confirmation anyway, there is no risk. Just proceed slowly and reads all the messages on the screen.
Comment 7 Myriam Schweingruber 2015-09-10 15:15:41 UTC
Any news on this?
Comment 8 Myriam Schweingruber 2016-02-10 18:57:23 UTC
Closing for lack of feedback, please feel free to reopen if you can provide the requested information.