Odd folder or file names cause amarok to incorrectly log duplicate entires in the collection database

Bug #112984 reported by gabe
14
This bug affects 1 person
Affects Status Importance Assigned to Milestone
amarok (Ubuntu)
Expired
Low
Unassigned

Bug Description

Binary package hint: amarok

Version: 1.4.5 using 3.5.6 (using KDE KDE 3.5.6)
Installed from: Ubuntu Packages

Odd Folder and File Names cause Amarok to record multiple copies of items in the database. Case in Point:
I have but one Copy of the 10,000 Maniacs unplugged album in my library. Amarok lists three copies of each song in the 10,000 Maniacs directory. It does the same thing with the Tool album 10,000 days. I suspect this is because of the comma.

Here are some screenshots that entertain and delight.

1. This is the the Amarok collection and two of the three files with the 'edit info' box present so you can see the path to the song file.
http://farm1.static.flickr.com/209/487608630_7072dbf037_o.png

2. This is the contents of the 10,000 Maniacs directory as visualized by Firefox. http://farm1.static.flickr.com/168/487608632_6f376618fb_o.png

Note: Upon further inspection, I've discovered that it's with just about any directory that has an 'unusual' character in it. Apostrophes, extra punctuation all seem to make this happen.

Revision history for this message
Lydia Pintscher (lydia-pintscher) wrote :

Can you still reproduce this with Amarok 1.4.8?
Does a full rescan fix it?

Changed in amarok:
status: New → Incomplete
Revision history for this message
Ryan Sinn (ryan-sinn) wrote :

I can reproduce this... with a fresh install of 1.4.8 (as of a week ago.)

A full rescan doesn't fix it -- it just adds more entries.

My filenames and directories aren't "odd" like the above bug describes.

I've attached an image to showcase what I'm seeing.
Running Update or Rescan collection seems to add more entries of SOME songs (need more testing on this) :)

I've got 4 copies of this song in my collection...
/media/multimedia/music/mp3/unsorted/Queensryche - Eyes of a stranger.mp3

There doesn't seem to be anything odd about that name ... no umlaut in Queensryche even. :)

I've also found that moving ONE of the instances of a song moves them all and deleting one deletes them all.

Very annoying :)

I'm going to move my .kde directory and try to rebuild my collection again.

Revision history for this message
Ryan Sinn (ryan-sinn) wrote :

This thread in the forums seems to show others with this unresolved issue...
http://ubuntuforums.org/archive/index.php/t-134525.html

Revision history for this message
Ryan Sinn (ryan-sinn) wrote :

I just tried a "rescan collection ... it took about 10 seconds. WAY too short, especially since the media share is over the network.

I deleted my .kde/apps/amarok/collection* files... and did a rescan it it looks ok... we'll see what happens if I run a rescan / update

Changed in amarok:
importance: Undecided → Low
status: Incomplete → Confirmed
Revision history for this message
Ryan Sinn (ryan-sinn) wrote :

Deleting my collection in the .kde directory and running a rescan fixed this... Leaving the collection and just performing rescan of the existing collection does not.

Revision history for this message
aftertaf (david-wooffindin) wrote :

I have this problem too... with just about any album or group with a Space in the name...

I ditched MySQL and 'removed' my comemction this way, then redeclared it.
It rebuilt from scratch but duplicates are still there.
All is on a local drive, ext3.
I also note that amarok uses a lot more of processor than before, i'm not using equalisers, visualisation or moodbar...
Just listening to music: amarok is always updating the collection though nothing has changed in the files structure or anything.

Revision history for this message
aftertaf (david-wooffindin) wrote :

duh, i meant SQLite, not mysql ....

just deleted the .kde/share/apps/amarok/collection* files too and am rescanning to see if it works. (reticking which folders have the files i want...)
I confirm the changing of db engine to force a rescan didn't fix it, the original file must have remained...

will tell you if this is a lasting fix

Revision history for this message
aftertaf (david-wooffindin) wrote :

anyone know if this is a cause or not for amarok to use a lot of cpu?
maybe due to excessive collection scanning?

Revision history for this message
Ryan Sinn (ryan-sinn) wrote :

Let's not "hijack" this bug with the CPU issue -- but yes ... I have seen Amarok use 6-15% almost continuously and it has been aggressively collection scanning.

I can't find a bug open about the CPU load issue.

Revision history for this message
Jonathan Thomas (echidnaman) wrote :

Is this still a problem in Amarok 2.0.1?

Changed in amarok (Ubuntu):
status: Confirmed → Incomplete
Revision history for this message
aftertaf (david-wooffindin) wrote : Re: [Bug 112984] Re: Odd folder or file names cause amarok to incorrectly log duplicate entires in the collection database

for me, no...

i still have some non conventional folder/filenames (from linux p.o.v) and
2.0.1 is cokking on gas :)

crashed the copy to media devices sometimes (too long names it seems...) but
I think even that is now ok.
:)
keep it coming!!!

2009/3/30 Jonathan Thomas <email address hidden>

> Is this still a problem in Amarok 2.0.1?
>
> ** Changed in: amarok (Ubuntu)
> Status: Confirmed => Incomplete
>
> --
> Odd folder or file names cause amarok to incorrectly log duplicate entires
> in the collection database
> https://bugs.launchpad.net/bugs/112984
> You received this bug notification because you are a direct subscriber
> of the bug.
>

Revision history for this message
Jonathan Thomas (echidnaman) wrote :

Great. :) If this is found to still be a problem with Amarok 2, feel free to reopen this.

Changed in amarok:
status: Incomplete → Fix Released
Revision history for this message
Gramler (maxf) wrote :

Happens in 2.2.0
Might be because character mapping strange when copying from NTFS
(Origin of those directories)

Directories like "Sinéad O'Connor" is duplicated once organize is done.
It seems to go into some error state once it has "seen" such a mangled directory, since "ordinary" directories also end up with duplicate content. a restart and specific organize of the "ordinary" directory results in success. After and attempt to organize the ones with special characters... the whole thing goes "funny" again. Edits to content (changing of genres) are not correctly done

In general results are unpredictable. Might be related to this issue i reported??
https://bugs.launchpad.net/bugs/504765
that causes problems with deletes?

Changed in amarok (Ubuntu):
status: Fix Released → Incomplete
Revision history for this message
rusivi2 (rusivi2-deactivatedaccount) wrote :

Thank you for taking the time to report this bug and helping to make Ubuntu better. I noticed the package your bugging is updated in Maverick. Does this occur in it? If so, please feel free to mark this bug as new. Thanks in advance!

Revision history for this message
Launchpad Janitor (janitor) wrote :

[Expired for amarok (Ubuntu) because there has been no activity for 60 days.]

Changed in amarok (Ubuntu):
status: Incomplete → Expired
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.