Rockbox

This is the bug/patch tracker for Rockbox. Click here for more information.

Quick links: Bugs · Patches · Rockbox frontpage

Tasklist

FS#8414 - Duplicate entries in database (not caused by trash folders)

Attached to Project: Rockbox
Opened by Petter Sundlöf (peppo) - Sunday, 06 January 2008, 19:55 GMT+2
Last edited by Daniel Stenberg (bagder) - Saturday, 26 January 2008, 12:29 GMT+2
Task Type Bugs
Category Database
Status Unconfirmed   Reopened
Assigned To No-one
Player type iPod 5G
Severity Low
Priority Normal
Reported Version current build
Due in Version Undecided
Due Date Undecided
Percent Complete 0%
Private No

Details

Using r15994.

I've lately been having a lot of issues with the database creating duplicate (mostly double but some times three or four repeats of the same song) entries for identical files. This usually happens after one or too reboots/powerdowns. These are not caused by stray .Trash, .Trashes etc

I have repeatedly tried deleting all my .tcds in .rockbox/ and recreating the database.

I'm attaching my .tcds and an example playlist (analord11.m3u8)
(application/x-gzip)    databaseduplicate.tar.gz (310.8 KiB)
This task depends upon

Comment by Lee Kang Hyuk (alwaysbluepop) - Monday, 07 January 2008, 15:47 GMT+2
This happened to me when i renamed the files, or changed the paths.
I guess i found a solution. Please check  FS#8423 .
You may have to 'Initialize Now' to clear the duplicated entries.
Comment by Petter Sundlöf (peppo) - Monday, 07 January 2008, 15:50 GMT+2
I don't see how that's related -- your bug seems to pertain to files that are no longer there?
Comment by Lee Kang Hyuk (alwaysbluepop) - Tuesday, 08 January 2008, 10:52 GMT+2
When renaming files, its entries are deleted at first. In this case the file's title field could be no longer in use. This is why i thought it a same thing.
Does it occured when you did altered nothing? Please let me know if the latest build does not solve your problem.
Comment by Petter Sundlöf (peppo) - Tuesday, 08 January 2008, 11:00 GMT+2
I've not altered any files, not even added any.
And still, after one reboot, there are duplicate entries everwhere, a few triple entries.
Also, a new behaviour I've witnessed with recent firmwares is that it will do a "Searching..." on entering almost any album/place in database. This considerably slows down navigation.
I will try the latest firmware now.
Comment by Lee Kang Hyuk (alwaysbluepop) - Tuesday, 08 January 2008, 16:38 GMT+2
Slow browsing is normal behaviour with 'Load DB into RAM' not enabled.
Comment by Giles (gilesn) - Wednesday, 09 January 2008, 14:24 GMT+2
I also get duplicate entries for iPod5G but only when Auto Update is set to YES.

It's happening with release r16027 and for previous releases since Dec 2007.
Comment by Miika Pekkarinen (miipekk) - Tuesday, 22 January 2008, 18:14 GMT+2
I think this has been now fixed. Please re-open the task if problem still happens.
Comment by Giles (gilesn) - Thursday, 28 February 2008, 18:37 GMT+2
can't reproduce in r16441, looks OK now.
Comment by Steve (TheBashar) - Sunday, 02 March 2008, 01:28 GMT+2
I'm still seeing this problem using r16460 on my c200. It seems to be related to booting in to the OF. After several sessions with RB, I connected the USB and booted into the OF just to charge the battery (because I didn't know I could charge only from within RB). When I disconnected the OF did the usual "Refresheing Database" message. When it completed I powered off and then booted into RB. When it came up I immediately checked and found every entry in the database had a duplicate.
Comment by Marc Guay (Marc_Guay) - Monday, 10 March 2008, 19:28 GMT+2
Sansa e200 + r16601 + Database Initialized + Auto Update On. Booted into Sansa firmware, let it refresh the database, went back to Rockbox, database contains single entries.
Comment by Lee Kang Hyuk (alwaysbluepop) - Tuesday, 11 March 2008, 02:44 GMT+2
Hard to figure out when and why, and hard to reproduce, but I can sure duplicated entries problem still exists.
This problem seems to occur only when 'Load DB into Ram' is disabled.
If I'm not wrong, it seems that database_tmp.tcd does not erased at proper time.(due to a low voltage, immediate power down during boot-up, or whatever)
As a result of that, entries may committed twice.
This could happen in Sim too. Try kill simulator window while large amount of entries being committed.
Comment by David Banks (amoe) - Wednesday, 23 July 2008, 19:44 GMT+2
I have also experienced this problem with a Sansa e200, r17826.
It seems to affect random files in the database, since only about half my collection gets duplicated.
Running 'Initialize Now' always fixes it, but also erases the history, which sucks.

I did two things recently before the problem started: 1, started syncing my music with rsync, rather than copying the entire folder every time (don't laugh); 2, enabled 'Gather Runtime Data'. So maybe it could be related to one of these.

Loading...