Itunes XML and it adding millions of songs

[cromei]

I have been running 1696 for weeks and my wife bought an iPod. She now would like her playlists in FireFly so I copied her iTunes XML to my NSLU2 and changed all of the paths for the mp3s in the XML to what they need to be on the NSLU2. When I do a scan I get a crash and the songcount on the Firefly server webpage goes into the millions.
Any ideas? I attached a snippet from my debug level 9 logfrom where I see an error to the end.

Thanks,
Craig

2008-05-15 08:37:49 (00010803): Error: enum_begin failed (error 1): ?
2008-05-15 08:37:49 (00000400): Executing: select count(*) from songs where path=’/share/flash/data/public/MP3/Requiem – Andrew Lloyd Webber/Requiem & Kyrie.mp3′ and idx=0
2008-05-15 08:37:49 (00000400): Executing: UPDATE songs SET title=’Requiem & Kyrie’,artist=’Andrew Lloyd Webber’,album=’Requiem’,genre=’Choral’,comment=”,type=’mp3′,composer=”,orchestra=’Andrew Lloyd Webber’,conductor=”,grouping=”,url=”,bitrate=227,samplerate=44100,song_length=405472,file_size=11538436,year=1985,track=1,total_tracks=0,disc=0,total_discs=0,time_modified=1209912319,db_timestamp=1210865869,bpm=0,disabled=0,compilation=0,rating=0,sample_count=0,codectype=’mpeg’,album_artist=’Andrew Lloyd Webber’ WHERE path=’/share/flash/data/public/MP3/Requiem – Andrew Lloyd Webber/Requiem & Kyrie.mp3′ and idx=0
2008-05-15 08:37:49 (00000400): Rows: 1
2008-05-15 08:37:49 (00000400): Executing: insert into updated (id) select id from songs where path=’/share/flash/data/public/MP3/Requiem – Andrew Lloyd Webber/Requiem & Kyrie.mp3′ and idx=0
2008-05-15 08:37:49 (00000400): Rows: 1
2008-05-15 08:37:49 (00011805): No query/filter
2008-05-15 08:37:49 (00011805): Executing: select count (*) from playlists
2008-05-15 08:37:49 (00011805): Creating new db handle
2008-05-15 08:37:49 (00000400): Scanning iTunes id #4156
2008-05-15 08:37:49 (00000400): scan_path: file://localhost//share/flash/data/public/MP3/Requiem – Andrew Lloyd Webber/Dies irae … Rex tremendae.mp3
2008-05-15 08:37:49 (00010803): Error writing to client socket: Connection reset by peer
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Error writing to client socket: Broken pipe
2008-05-15 08:37:49 (00010803): Thread 64: xml-rpc served
2008-05-15 08:37:49 (00010803): Entering config_set_status
2008-05-15 08:37:49 (00010803): Exiting config_set_status
2008-05-15 08:37:49 (00010803): Thread 64: Terminating
2008-05-15 08:37:49 (00010803): Thread 64: Freeing request headers
2008-05-15 08:37:49 (00010803): Thread 64: Freeing response headers
2008-05-15 08:37:49 (00010803): Thread 64: Freeing request vars
2008-05-15 08:37:49 (00010803): Thread 64: Closing fd
2008-05-15 08:37:49 (00010803): With thread 64 exiting, 3 are still running
2008-05-15 08:38:21 (00011805): Error: enum_begin failed (error 1): Misc SQL Error: database is locked
2008-05-15 08:38:21 (00011805): Enumerating size
2008-05-15 08:38:21 (00000400): Processing rendezvous message
2008-05-15 08:38:21 (00000400): Rendezvous socket closed (daap server crashed?) Aborting.
2008-05-15 08:38:21: Aborting

[cromei]

Fixed,
Deleted the sql database and it worked just fine.
Craig

[Author]

Posts