You are here: Home » Reply » Reply To: Feedback on 1236

Reply To: Feedback on 1236

#5134
mbaker
Participant

Hi there. I’ve been running in heavy debug mode for the last couple of days (and have a nice 130M log file to show for it that I need to do some grawking on).

Grommet, thanks for the config addition. On the meta errors, I know that’s a known bug, but I thought it was interesting that they seem to coincide with the memory leak. I’ll continue monitoring that one.

A couple of tidbits…
I’ve been running with the following settings:

always_scan = 0
scan_type = 2
supports_update = 0

…and with iTunes listening turned off as recommended. But when I rip CDs and the iTunes XML is being updated regularly, I’m still getting lots of TMP files because of the lock on the XML file. Would it be reasonable to take a temporary copy of the XML file for digestion leaving the main file unlocked?

While running in -9 mode I noticed the following behaviour during updates:

...
2006-06-22 : Rows: 506883
2006-06-22 : Adding itunes track #756
2006-06-22 : Executing: select type from playlists where id=443
2006-06-22 : Executing: select count(*) from songs where id=714
2006-06-22 : Executing: insert into playlistitems (playlistid, songid) values (443,714)
2006-06-22 : Rows: 506884...

This appears to be what’s taking all the time on the rescans (taking up to an hour). Surely it shouldn’t have managed to generate 500k rows. I don’t have that many playlists.

Also, when the server restarted, it seemed to decide that doing a full rescan of every song was a good idea. Is that normal? Here’s what I see in the log (this is the start after I’d done a complete rebuild so I wouldn’t have expected so much activity):

...
2006-06-22 : Scanning iTunes id #457
2006-06-22 : scan_path: file://localhost//Horace/multimedia/iTunes/iTunes Music/Nine Inch Nails/Pretty Hate Machine/02 Terrible Lie.mp3
2006-06-22 : Executing: select * from songs where path='\horacemultimediaitunesitunes musicnine inch nailspretty hate machine2 terrible lie.mp3'
2006-06-22 : Executing: INSERT INTO updated VALUES (417)
2006-06-22 : Rows: 1
2006-06-22 : Executing: select count(*) from songs where path='\horacemultimediaitunesitunes musicnine inch nailspretty hate machine2 terrible lie.mp3'
2006-06-22 : Executing: UPDATE songs SET title='Terrible Lie',artist='Nine Inch Nails',album='Pretty Hate Machine',genre='Other',comment='',type='mp3',composer=
'Trent Reznor',orchestra='Nine Inch Nails',conductor='',grouping='',url='',
bitrate=128,samplerate=44100,song_length=282566,file_size=4528935,
year=1989,track=2,total_tracks=0,disc=0,total_discs=0,
time_modified=1105002673,db_timestamp=1150958979,bpm=0,
disabled=0,compilation=0,rating=0,sample_count=0,codectype='mpeg' WHERE path='\horacemultimediaitunesitunes musicnine inch nailspretty hate machine2 terrible lie.mp3'
2006-06-22 : Rows: 1
2006-06-22 : Executing: insert into updated (id) select id from songs where path
='\horacemultimediaitunesitunes musicnine inch nailspretty hate machine2 terrible lie.mp3'
2006-06-22 : Rows: 1
2006-06-22 : Scanning iTunes id #458
...

Thoughts?

M