Bug 2720 - Initial scan can delete entries from genre_track
: Initial scan can delete entries from genre_track
Status: RESOLVED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: 6.2.2
: PC Linux (other)
: P2 normal (vote)
: ---
Assigned To: Dan Sully
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2005-12-17 21:12 UTC by Dirk Bergstrom
Modified: 2011-03-16 04:39 UTC (History)
1 user (show)

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Dirk Bergstrom 2005-12-17 21:12:50 UTC
+++ This bug was initially created as a clone of Bug #2656 +++

This bug is listed as fixed in a 6.2.2 nightly, however, I downloaded  SlimServer_6_2_x_v2005-12-14, and I'm still getting the problem.

It's especially vexing to me as I'm using the slim sqlite db as a datasource for another project (populating a phatbox from linux).

Thanks.

---------------- Original description -------------------
I have now identified a very weird repeatable bug in the slimserver scanning process for 6.2.1

Process is as follows:

1) stop server
2) delete database
3) restart server - it begins scanning database
4) during rescan process use web interface to browse to 'Browse Genre/GenreX'
5) perform refresh

During this process I can see artists being added to the list as I expect.

6) wait for end of scan
7) refresh again


Observation:
Many of the tracks that were correctly identified in the GenreX are missing - ie tracks that were identified during the scan process were added and REMOVED/DELETED/CORRUPTED

This is entirely repeatable on my collection, and I have screenshots to show the process if it helps.

It only seems to affect the genre based information (all tracks seem ok when accessed other ways).

Finally I use multiple genres in one tag using a ';' to separate them.

LATER . . . . .

I have narrowed down the bug, but I don't know the root cause.

The bug is because $genreObj->delete; is called in _postCheckAttributes in DBIStore.pm (line 1544 in my version)

To prove this I put in a logging line as follows:
	$::d_import && msg("MALCOLM: deleting a genre $genreObj->name()\n"); #MALCOLM

When slimserver does an initial scan of the database it logs that it is deleting genres (but I don't know why), here's a short extract from the log

2005-11-29 20:53:08.9335 
2005-11-29 20:53:11.9701 Import: Scanning with 2 import plugins
2005-11-29 20:53:11.9704 	Playlist scan started at: Tue Nov 29 20:50:14 2005
2005-11-29 20:53:11.9706 	Folder scan started at: Tue Nov 29 20:50:15 2005
2005-11-29 20:53:11.9707 
2005-11-29 20:53:13.4017 MALCOLM: deleting a genre ChilledVocal->name()
2005-11-29 20:53:13.8109 MALCOLM: deleting a genre QualityPop->name()
2005-11-29 20:53:14.7144 MALCOLM: deleting a genre BruceSpringsteen->name()
2005-11-29 20:53:16.9955 Import: Scanning with 2 import plugins
2005-11-29 20:53:16.9958 	Playlist scan started at: Tue Nov 29 20:50:14 2005
2005-11-29 20:53:16.9959 	Folder scan started at: Tue Nov 29 20:50:15 2005
2005-11-29 20:53:16.9959 

That's about as far as I can take it I think . . . .
Comment 1 malcolmwotton 2005-12-18 02:09:44 UTC
Apologies,

I reported this bug as fixed, and I still believe it is. However I use the latest code from SVN. I don't understand the relationship between this version and the nightlies.

So, for clarity my slimserver is based on SVN code and reports itself as. . .

'SlimServer Version: 6.5b1 - trunk - Windows XP - EN - cp1252'

I can't actually find a way to identify the last revision I downloaded but the last update I did was probably on or around Thursday 15/12/2006

Malcolm
Comment 2 Dan Sully 2006-06-13 00:29:47 UTC
Is this still an issue with the latest 6.5 nightly?

Thanks
Comment 3 Dan Sully 2006-06-28 14:50:27 UTC
This shouldn't be an issue in 6.5.

Please reopen if you can reproduce.

Thanks