You are here: Home » Topic » Itunes XML and it adding millions of songs

Itunes XML and it adding millions of songs

This topic contains 1 reply, has 1 voice, and was last updated by  cromei 9 years, 6 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #2436

    cromei
    Participant

    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

    #17011

    cromei
    Participant

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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.