svn-1696 on NSLU2 crashes when I have it start a scan

FireFly Media Server (formerly mt-daapd) Firefly Media Server Forums Firefly Media Server Nightlies Feedback svn-1696 on NSLU2 crashes when I have it start a scan

Viewing 15 posts - 1 through 15 (of 18 total)
  • Author
    Posts
  • #1928
    Anonymous
    Inactive

    I have a reproducible crash on Firefly svn-1696 on NSLU2. When I push the “Scan now” button in the Firefly status Web UI, then within 8 minutes the music stops, and within 20 minutes Firefly crashes.

    My Firefly is svn-1696 running on an NSLU2 with rev6.8 beta Unslung firmware. The log is at -d9 level.

    My client is iTunes 7.4.2 (4) on Mac OS 10.3.9.

    The music collection is one directory of MP3’s which was taken over from iTune’s care, so it’s in iTunes structure with iTunes static and smart playlists; plus one director of flac-encoded music that iTunes never saw until Firefly began serving them.

    Here is an excerpt of the possibly interesting lines from a 28,000-line log file. Boy, -d9 is verbose.


    ...
    2007-11-10 17:40:15 (00000400): Executing: drop table plupdated
    2007-11-10 17:40:15 (00000400): Query: drop table plupdated
    2007-11-10 17:40:15 (00000400): Error: no such table: plupdated
    2007-11-10 17:40:15 (00000400): Executing: create temp table plupdated(id int)
    2007-11-10 17:40:15 (00000400): Rows: 0
    2007-11-10 17:40:15 (00000400): Scanning for MP3s in /share/flash/data/media/Music/flac_format_content
    2007-11-10 17:40:15 (00000400): Found /share/flash/data/media/Music/flac_format_content/abcde.e00e8113
    2007-11-10 17:40:15 (00000400): Found abcde.e00e8113.. recursing
    ...
    2007-11-10 17:40:15 (00000400): Found Bobino.. recursing
    2007-11-10 17:40:15 (00000400): Found /share/flash/data/media/Music/flac_format_content/Bobino/It etait une fois l'operette
    2007-11-10 17:40:15 (00000400): Found It etait une fois l'operette.. recursing
    2007-11-10 17:40:15 (00000400): Found /share/flash/data/media/Music/flac_format_content/Bobino/It etait une fois l'operette/01 - Intro de Le Petit Duc.flac
    2007-11-10 17:40:15 (00000400): Executing: select * from songs where path='/share/flash/data/media/Music/flac_format_content/Bobino/It etait une fois l''operette/01 - Intro de Le Petit Duc.flac' and idx=0
    2007-11-10 17:40:15 (00000400): Executing: INSERT INTO updated VALUES (1)
    2007-11-10 17:40:15 (00000400): Rows: 1
    2007-11-10 17:40:15 (00000400): Skipping file, not modified
    2007-11-10 17:40:15 (00000400): Found /share/flash/data/media/Music/flac_format_content/Bobino/It etait une fois l'operette/02 - La lecon de chant.flac
    2007-11-10 17:40:15 (00000400): Executing: select * from songs where path='/share/flash/data/media/Music/flac_format_content/Bobino/It etait une fois l''operette/02 - La lecon de chant.flac' and idx=0
    2007-11-10 17:40:15 (00000400): Executing: INSERT INTO updated VALUES (2)
    2007-11-10 17:40:15 (00000400): Rows: 1
    2007-11-10 17:40:15 (00000400): Skipping file, not modified
    ...
    2007-11-10 17:40:20 (00000400): Found /share/flash/data/media/Music/flac_format_content/Mahler, Gustav/Symphony No 1. in D Major - San Francisco Symphony, Michael Tilson Thomas/04 - Symphony No 1. in D Major: 4th Movement: With violent movement.flac
    2007-11-10 17:40:20 (00000400): Executing: select * from songs where path='/share/flash/data/media/Music/flac_format_content/Mahler, Gustav/Symphony No 1. in D Major - San Francisco Symphony, Michael Tilson Thomas/04 - Symphony No 1. in D Major: 4th Movement: With violent movement.flac' and idx=0
    2007-11-10 17:40:20 (00000400): Executing: INSERT INTO updated VALUES (238)
    2007-11-10 17:40:20 (00000400): Rows: 1
    2007-11-10 17:40:20 (00000400): Skipping file, not modified
    2007-11-10 17:40:20 (00000400): Found /share/flash/data/media/Music/flac_format_content/Mahler
    2007-11-10 17:40:20 (00000400): Found Mahler.. recursing
    2007-11-10 17:40:20 (00000400): Found /share/flash/data/media/Music/flac_format_content/Mahler/Symphony 7 - San Francisco Symphony
    2007-11-10 17:40:20 (00000400): Found Symphony 7 - San Francisco Symphony.. recursing
    2007-11-10 17:40:20 (00000402): Got listen socket 36
    2007-11-10 17:40:20 (00159005): Thread 1378:
    ...
    2007-11-10 17:40:24 (00000400): Found /share/flash/data/media/Music/flac_format_content/Vaughan Williams, Ralph/Symphony No.7 (Antarctica)/05 - Epilogue: Alla marcia, moderato.flac
    2007-11-10 17:40:24 (00000400): Executing: select * from songs where path='/share/flash/data/media/Music/flac_format_content/Vaughan Williams, Ralph/Symphony No.7 (Antarctica)/05 - Epilogue: Alla marcia, moderato.flac' and idx=0
    2007-11-10 17:40:24 (00000400): Executing: INSERT INTO updated VALUES (437)
    2007-11-10 17:40:24 (00000400): Rows: 1
    2007-11-10 17:40:24 (00000400): Skipping file, not modified
    2007-11-10 17:40:24 (0012bc03): timeout in select
    2007-11-10 17:40:24 (00000400): Found /share/flash/data/media/Music/flac_format_content/.DS_Store
    2007-11-10 17:40:24 (00000400): Scanning for MP3s in /share/flash/data/media/Music/iTunes/
    2007-11-10 17:40:24 (00000400): Found /share/flash/data/media/Music/iTunes/.DS_Store
    2007-11-10 17:40:24 (00000400): Found /share/flash/data/media/Music/iTunes/._.DS_Store
    2007-11-10 17:40:24 (00000400): Found /share/flash/data/media/Music/iTunes/iTunes Music
    2007-11-10 17:40:24 (00000400): Found iTunes Music.. recursing
    2007-11-10 17:40:24 (00000400): Found /share/flash/data/media/Music/iTunes/iTunes Music/.DS_Store
    2007-11-10 17:40:24 (00000400): Found /share/flash/data/media/Music/iTunes/iTunes Music/._.DS_Store
    2007-11-10 17:40:24 (00000400): Found /share/flash/data/media/Music/iTunes/iTunes Music/Academy of St. Martin in the Fields - Neville Marriner
    2007-11-10 17:40:24 (00000400): Found Academy of St. Martin in the Fields - Neville Marriner.. recursing
    2007-11-10 17:40:24 (00000400): Found /share/flash/data/media/Music/iTunes/iTunes Music/Academy of St. Martin in the Fields - Neville Marriner/il barbiere di Siviglia (Disk 1)
    2007-11-10 17:40:24 (00000400): Found il barbiere di Siviglia (Disk 1).. recursing
    2007-11-10 17:40:24 (00000400): Found /share/flash/data/media/Music/iTunes/iTunes Music/Academy of St. Martin in the Fields - Neville Marriner/il barbiere di Siviglia (Disk 1)/01 Sinfonia.mp3
    2007-11-10 17:40:24 (00000400): Executing: select * from songs where path='/share/flash/data/media/Music/iTunes/iTunes Music/Academy of St. Martin in the Fields - Neville Marriner/il barbiere di Siviglia (Disk 1)/01 Sinfonia.mp3' and idx=0
    2007-11-10 17:40:24 (00000400): Executing: INSERT INTO updated VALUES (438)
    2007-11-10 17:40:24 (00000400): Rows: 1
    2007-11-10 17:40:24 (00000400): Skipping file, not modified
    ...
    2007-11-10 17:41:33 (00000400): Scanning iTunes id #194
    2007-11-10 17:41:33 (00000400): scan_path: file://localhost/Volumes/192.150.23.77/us/res/Music/iTunes/iTunes Music/P.D.Q. Bach (Peter Schikele)/1712 Overture and Other Musical Assaults/14 The Preachers of Crimetheus_ III. Finale_ Special Deliverance.mp3
    2007-11-10 17:41:33 (00000400): Mapping file://localhost/Volumes/192.150.23.77/us/res/Music/iTunes/iTunes Music/P.D.Q. Bach (Peter Schikele)/1712 Overture and Other Musical Assaults/14 The Preachers of Crimetheus_ III. Finale_ Special Deliverance.mp3 to /share/flash/data/media/Music/iTunes/iTunes Music/P.D.Q. Bach (Peter Schikele)/1712 Overture and Other Musical Assaults/14 The Preachers of Crimetheus_ III. Finale_ Special Deliverance.mp3
    2007-11-10 17:41:33 (00000400): Executing: select * from songs where path='/share/flash/data/media/Music/iTunes/iTunes Music/P.D.Q. Bach (Peter Schikele)/1712 Overture and Other Musical Assaults/14 The Preachers of Crimetheus_ III. Finale_ Special Deliverance.mp3' and idx=0
    2007-11-10 17:41:33 (00000400): Executing: INSERT INTO updated VALUES (1406)
    2007-11-10 17:41:33 (00000400): Rows: 1
    2007-11-10 17:41:33 (00000400): Executing: select count(*) from songs where path='/share/flash/data/media/Music/iTunes/iTunes Music/P.D.Q. Bach (Peter Schikele)/1712 Overture and Other Musical Assaults/14 The Preachers of Crimetheus_ III. Finale_ Special Deliverance.mp3' and idx=0
    2007-11-10 17:41:33 (00000400): Executing: UPDATE songs SET title='The Preachers of Crimetheus: III. Finale: Special Deliverance',artist='P.D.Q. Bach (Peter Schikele)',album='1712 Overture and Other Musical Assaults',genre='Humor',comment='14',type='mp3',composer='',orchestra='',conductor='',grouping='',url='' ,bitrate=128,samplerate=44100,song_length=366915,file_size=5872805,year=0,track=14,total_tracks=14, disc=0,total_discs=0,time_modified=1065028098,db_timestamp=1194745293,bpm=0,disabled=1,compilation=0, rating=0,sample_count=0,codectype='mpeg',album_artist='' WHERE path='/share/flash/data/media/Music/iTunes/iTunes Music/P.D.Q. Bach (Peter Schikele)/1712 Overture and Other Musical Assaults/14 The Preachers of Crimetheus_ III. Finale_ Special Deliverance.mp3' and idx=0
    2007-11-10 17:41:33 (00000400): Rows: 1
    2007-11-10 17:41:33 (00000400): Executing: insert into updated (id) select id from songs where path='/share/flash/data/media/Music/iTunes/iTunes Music/P.D.Q. Bach (Peter Schikele)/1712 Overture and Other Musical Assaults/14 The Preachers of Crimetheus_ III. Finale_ Special Deliverance.mp3' and idx=0
    2007-11-10 17:41:33 (00000400): Rows: 1
    2007-11-10 17:41:33 (00000400): Scanning iTunes id #195
    2007-11-10 17:41:33 (00000400): scan_path: file://localhost/Users/ducky/Music.lighthouse/iTunes/iTunes Music/Unknown Artist/Unknown Album/01 Sapo Cancioneo.mp3
    2007-11-10 17:41:33 (00000400): Mapping file://localhost/Users/ducky/Music.lighthouse/iTunes/iTunes Music/Unknown Artist/Unknown Album/01 Sapo Cancioneo.mp3 to /share/flash/data/media/Music/iTuness Music
    2007-11-10 17:41:33 (00000400): Executing: select * from songs where path='/share/flash/data/media/Music/iTuness Music' and idx=0

    2007-11-10 17:41:33 (00000400): Error statting: No such file or directory

    2007-11-10 17:41:33 (00000400): Executing: select * from songs where path='/share/flash/data/media/Music/iTuness Music' and idx=0
    2007-11-10 17:41:33 (00000400): Scanning iTunes id #196
    2007-11-10 17:41:33 (00000400): scan_path: file://localhost/Volumes/192.150.23.77/us/res/Music/iTunes/iTunes Music/Compilations/ Latin American music (exact album title unknown)/01 De Paisano a paisano.mp3
    2007-11-10 17:41:33 (00000400): Mapping file://localhost/Volumes/192.150.23.77/us/res/Music/iTunes/iTunes Music/Compilations/ Latin American music (exact album title unknown)/01 De Paisano a paisano.mp3 to /share/flash/data/media/Music/iTunes/iTunes Music/Compilations/Latin American music (exact album title unknown)/01 De Paisano a paisano.mp3
    2007-11-10 17:41:33 (00000400): Executing: select * from songs where path='/share/flash/data/media/Music/iTunes/iTunes Music/Compilations/Latin American music (exact album title unknown)/01 De Paisano a paisano.mp3' and idx=0
    2007-11-10 17:41:33 (00000400): Executing: INSERT INTO updated VALUES (857)
    ...
    2007-11-10 17:55:30 (00000400): Scanning iTunes id #755
    2007-11-10 17:55:30 (00000400): scan_path: file://localhost/Volumes/192.150.23.77/us/res/Music/iTunes/iTunes Music/St. Peter's Brass/St. Peter's Brass/04 Handel_ Baroque Suite Sarabande.mp3
    2007-11-10 17:55:30 (00000400): Mapping file://localhost/Volumes/192.150.23.77/us/res/Music/iTunes/iTunes Music/St. Peter's Brass/St. Peter's Brass/04 Handel_ Baroque Suite Sarabande.mp3 to /share/flash/data/media/Music/iTunes/iTunes Music/St. Peter's Brass/St. Peter's Brass/04 Handel_ Baroque Suite Sarabande.mp3
    2007-11-10 17:55:31 (00160003): Thread 1406:
    2007-11-10 17:55:31 (00160003): Request: GET /databases/1/items?type=music&meta=dmap.itemid,dmap.itemname, dmap.itemkind,dmap.persistentid,daap.songalbum,daap.songgrouping, daap.songartist,daap.songalbumartist,daap.songbitrate,daap.songbeatsperminute, daap.songcomment,daap.songcodectype,daap.songcodecsubtype,daap.songcompilation, daap.songcomposer,daap.songdateadded,daap.songdatemodified, daap.songdisccount,daap.songdiscnumber,daap.songdisabled,daap.songeqpreset, daap.songformat,daap.songgenre,daap.songdescription,daap.songrelativevolume, daap.songsamplerate,daap.songsize,daap.songstarttime,daap.songstoptime, daap.songtime,daap.songtrackcount,daap.songtracknumber,daap.songuserrating, daap.songyear,daap.songdatakind,daap.songdataurl,daap.songcontentrating, com.apple.itunes.norm-volume,com.apple.itunes.itms-songid,com.apple.itunes.itms-artistid, com.apple.itunes.itms-playlistid,com.apple.itunes.itms-composerid, com.apple.itunes.itms-genreid,com.apple.itunes.itms-storefrontid, com.apple.itunes.has-video,daap.songcategory,daap.songextradata, daap.songcontentdescription,daap.songlongcontentdescription, daap.songkeywords,com.apple.itunes.is-podcast,com.apple.itunes.mediakind, com.apple.itunes.series-name,com.apple.itunes.network-name, com.apple.itunes.episode-num-str,com.apple.itunes.episode-sort, com.apple.itunes.season-num,daap.songgapless,com.apple.itunes.gapless-enc-del, com.apple.itunes.gapless-heur,com.apple.itunes.gapless-enc-dr, com.apple.itunes.gapless-dur,com.apple.itunes.gapless-resy HTTP/1.1

    2007-11-10 17:55:31 (00160003): Thread 1406: Read: Host: 192.150.23.77

    2007-11-10 17:55:31 (00160003): Thread 1406: Adding header *Host=192.150.23.77*
    2007-11-10 17:55:31 (00160003): Added *Host=192.150.23.77*
    2007-11-10 17:55:31 (00160003): Thread 1406: Read: Client-DAAP-Version: 3.5
    ...
    2007-11-10 17:56:09 (00161005): Status inquiry
    2007-11-10 17:56:09 (00161005): Returning status 0
    2007-11-10 17:56:36 (00160003): Error: enum_begin failed (error 1): Misc SQL Error: database is locked
    2007-11-10 17:56:36 (00160003): Enumerating size
    2007-11-10 17:56:36 (00000400): Executing: select count(*) from songs where path='/share/flash/data/media/Music/iTunes/iTunes Music/St. Peter''s Brass/St. Peter''s Brass/04 Handel_ Baroque Suite Sarabande.mp3' and idx=0
    2007-11-10 17:56:36 (00000400): Rendezvous socket closed (daap server crashed?) Aborting.
    2007-11-10 17:56:36: Aborting

    Trust me, that’s the abridged version of the log!

    The workaround which I’m pretty sure works for me is to shut down Firefly; delete the database, i.e. all files in /opt/var/songs.* (not sure of exact path); then restart Firefly and let it regenerate the database. As long as it doesn’t scan while there’s an existing database, it seems to run OK.

    (I may find that I’ve blown away my Firefly smart playlist by deleting the database, though. 🙁 )

    Ron, I don’t know where diagnosing this falls on your priorities. If you’d like to take a look at the full log, I’d be happy to send it to you. Thanks for all your efforts for Firefly.

    #14348
    rpedde
    Participant

    @Jim DeLaHunt wrote:

    Ron, I don’t know where diagnosing this falls on your priorities. If you’d like to take a look at the full log, I’d be happy to send it to you. Thanks for all your efforts for Firefly.

    When I changed out all the file io code, I somehow broke the database. Not sure how, but I’m getting sqlite misuse errors. I spent the bulk of a Sunday trying to find it, and didn’t get anywhere.

    What I’m working towards right now is pulling the playlists back out of the database and storing them in files. Once I have that done, then I’ll be simplifying the database backend drastically. I hope that I won’t have any room for sqlite problems once I’ve simplified it. that’s the hope, anyway.

    So I’m kind of working toward sliding around the problem, rather than fixing it head-on.

    Actually, once that’s done, I’ll be pushing for a stable release, so I’ll start working toward stabilizing everything here soon.

    So it’s on the priority list, but only in a roundabout way. 🙂

    — Ron

    #14349
    Anonymous
    Inactive

    Hi,

    First post & unslung NSLU2 newbie so sorry if this is irrelevant.

    I seem to have a similar issue here. The end of my log reads:

    17:33:35 (00000400): Updating playlists
    17:33:51 (00000400): Updating playlists
    17:33:52 (00000400): Scanned 5651 songs (was 5651) in 696 seconds
    17:41:32 (00001c03): Session 0: Streaming file '03 Bewilder.mp3' to 192.168.1.1
    17:42:03 (00002403): Session 0: Streaming file '04 Fall in a River.mp3' to 192.
    17:43:52 (00000400): Rescanning database
    17:44:04 (00000400): Error reading: Unknown error
    17:44:04 (00000400): Skipping /public/Music/iTunes/iTunes Music/The Martin Harl
    17:44:17 (00000400): Error reading: Unknown error
    17:44:18 (00000400): Skipping /public/Music/iTunes/iTunes Music/Take That/Beaut
    17:44:20 (00002c03): Session 0: Streaming file '05 Camping Next to Water.mp3' t
    17:44:30 (00000400): Error reading: Unknown error
    17:44:30 (00000400): Skipping /public/Music/iTunes/iTunes Music/Red Hot Chili P
    17:44:30 (00000400): Error reading: Unknown error
    17:44:30 (00000400): Skipping /public/Music/iTunes/iTunes Music/Red Hot Chili P
    17:44:40 (00000400): Error reading: Unknown error
    17:44:40 (00000400): Skipping /public/Music/iTunes/iTunes Music/Norah Jones/Com
    17:45:26 (00000400): Error reading: Unknown error
    17:45:26 (00000400): Skipping /public/Music/iTunes/iTunes Music/Bruce Springste
    17:46:00 (00000400): Starting playlist scan
    17:49:15 (00003004): Error: enum_begin failed (error 1): Misc SQL Error: databa
    17:49:15 (00000400): Rendezvous socket closed (daap server crashed?) Aborting.
    17:49:15: Aborting

    My Firefly server seems to crash whilst it’s being used and a library scan starts. 😕 I thought I’d see if you thought this was related.

    Regards,

    #14350
    Anonymous
    Inactive

    Hi,

    Further to my post above, I have since deleted my database and let Firefly recreate it and all seems a lot happier. I will monitor the situation and report back as necessary.

    #14351
    rpedde
    Participant

    @fivesboy wrote:

    Hi,

    Further to my post above, I have since deleted my database and let Firefly recreate it and all seems a lot happier. I will monitor the situation and report back as necessary.

    There are also two db backends — sqlite and sqlite3. If one doesn’t work, it might be worth trying the other, just to see if it’s more stable.

    I’d be interested to hear any results on that.

    — Ron

    #14352
    Anonymous
    Inactive

    Hi Ron,

    There are also two db backends — sqlite and sqlite3. If one doesn’t work, it might be worth trying the other, just to see if it’s more stable.

    I’d be interested to hear any results on that.

    I changed from sqlite to sqlite3 in mt-daapd.conf. as recommended by you Ron.

    This seems to have helped. I had changed my scan interval to be 86400 (24 hours) to minimise potential conflicts with the scan whilst actually using the media server. I set off a manual scan from the web interface whilst playing songs and for the first time it has not caused the server to crash within 10 minutes.

    The only thing I’ve noticed is that a re-scan seems to send the song count on the web interface into silly numbers

    Arrgg! It’s just crashed again:


    2007-11-12 13:07:15 (00000400): Firefly Version svn-1696: Starting with debuglev
    2007-11-12 13:07:15 (00000400): Plugin loaded: ssc-script/svn-1696
    2007-11-12 13:07:15 (00000400): Plugin loaded: daap/svn-1696
    2007-11-12 13:07:15 (00000400): Plugin loaded: rsp/svn-1696
    2007-11-12 13:07:15 (00000400): Starting rendezvous daemon
    2007-11-12 13:07:15 (00000400): Starting signal handler
    2007-11-12 12:34:24 (00000400): Error reading: Unknown error
    2007-11-12 12:34:24 (00000400): Skipping /public/Music/iTunes/iTunes Music/Red H
    2007-11-12 12:34:25 (00000400): Error reading: Unknown error
    2007-11-12 12:34:25 (00000400): Skipping /public/Music/iTunes/iTunes Music/Red H
    2007-11-12 12:35:49 (000b8003): Session 0: Streaming file '08 Chelsea Walk.mp3'
    2007-11-12 12:35:50 (00000400): Error reading: Unknown error
    2007-11-12 12:35:50 (00000400): Skipping /public/Music/iTunes/iTunes Music/Norah
    2007-11-12 12:39:00 (000c1403): Session 0: Streaming file '09 Outside of a Circl
    2007-11-12 12:41:10 (00000400): Error reading: Unknown error
    2007-11-12 12:41:10 (00000400): Skipping /public/Music/iTunes/iTunes Music/Bruce
    2007-11-12 12:41:35 (000c9c04): Session 0: Streaming file '01 Concrete Jungle.mp
    2007-11-12 12:41:36 (000c1403): Write error: Broken pipe
    2007-11-12 12:42:47 (00000400): Starting playlist scan
    2007-11-12 12:45:55 (000d5404): Session 0: Streaming file '03 400 Years.mp3' to
    2007-11-12 12:47:56 (000d5404): Write error: Broken pipe
    2007-11-12 12:47:56 (000e2403): Session 0: Streaming file '04 Stop the Train.mp3
    2007-11-12 12:48:33 (000e2403): Write error: Broken pipe
    2007-11-12 12:48:39 (000e5003): Session 0: Streaming file '05 Baby We've Got a D
    2007-11-12 12:49:11 (000e5003): Write error: Broken pipe
    2007-11-12 12:49:34 (000e6404): Error: enum_begin failed (error 1): ?
    2007-11-12 12:50:04 (000e6805): Error: enum_begin failed (error 1): Misc SQL Err
    2007-11-12 12:50:05 (00000400): Rendezvous socket closed (daap server crashed?)
    2007-11-12 12:50:05: Aborting

    And then again, mid-stream:

    2007-11-12 13:13:42 (00012403): Session 0: Streaming file '01 Trench Town Rock.m
    2007-11-12 13:14:04 (00000400): Error reading: Unknown error
    2007-11-12 13:14:04 (00000400): Skipping /public/Music/iTunes/iTunes Music/Norah
    2007-11-12 13:17:41 (0001dc03): Session 0: Streaming file '02 Burnin' and Lootin
    2007-11-12 13:19:22 (00000400): Error reading: Unknown error
    2007-11-12 13:19:22 (00000400): Skipping /public/Music/iTunes/iTunes Music/Bruce
    2007-11-12 13:20:56 (00000400): Starting playlist scan
    2007-11-12 13:23:15 (0002cc03): Session 0: Streaming file '04 Lively Up Yourself
    2007-11-12 13:27:25 (00037004): Error: enum_begin failed (error 1): ?
    2007-11-12 13:28:25 (00037805): Error: enum_begin failed (error 1): Misc SQL Err
    2007-11-12 13:28:25 (00000400): Rendezvous socket closed (daap server crashed?)
    2007-11-12 13:28:25: Aborting
    ~

    So not ideal but better. I had reset the scan time to 600 secs but will change this to 24 hours again and see if that helps.

    As an aside it also seem easier to restart mt-daapd. Before when it crashed, issuing the /opt/etc/init.d/S60mt-daapd command would not always work (two of the four processes only would start)and I would need to turn off the NSLU2 and reboot.

    Also, sometimes, when things don’t seem quite right, I seem to have quite a few processes running:


    1735 ttyp0 guest 4012 S /opt/sbin/mt-daapd -c /opt/etc/mt-daapd/mt-
    1736 ttyp0 guest 17952 S /opt/sbin/mt-daapd -c /opt/etc/mt-daapd/mt-
    1739 ttyp0 guest 17952 S /opt/sbin/mt-daapd -c /opt/etc/mt-daapd/mt-
    1740 ttyp0 guest 17952 S /opt/sbin/mt-daapd -c /opt/etc/mt-daapd/mt-
    1878 ttyp0 guest 17952 S /opt/sbin/mt-daapd -c /opt/etc/mt-daapd/mt-
    1879 ttyp0 guest 17952 S /opt/sbin/mt-daapd -c /opt/etc/mt-daapd/mt-
    1890 ttyp0 guest 17952 S /opt/sbin/mt-daapd -c /opt/etc/mt-daapd/mt-
    1892 ttyp0 root 2668 S grep mt-daapd

    Just thinking aloud I’ve also put all my music into /public to aid transfer within XP environment. I’ve resolved necessary permissions and obviously configured mt-daapd to look here.

    Anyway, sorry for rambling but it does seem to be this MIsc SQL Error that kicks of the abort.

    Cheers,

    #14353
    Anonymous
    Inactive

    Me again. Addendum to last post – since setting scan interval back to 24 hrs (i.e. so that it does not do a scan whilst streaming), mt-daapd has been stable so I think there is a definite link with the SQL error during the scan and streaming. As to how to go about resolving it ….

    Cheers,

    #14354
    rpedde
    Participant

    @fivesboy wrote:

    Me again. Addendum to last post – since setting scan interval back to 24 hrs (i.e. so that it does not do a scan whilst streaming), mt-daapd has been stable so I think there is a definite link with the SQL error during the scan and streaming. As to how to go about resolving it ….

    Cheers,

    Turn of background scanning and use the web interface to kick off a scan when you add new music.

    That’s what I’d do. 🙂

    At least as a workaround.

    #14355
    Anonymous
    Inactive

    Turn of background scanning and use the web interface to kick off a scan when you add new music.

    Ok. Thanks for the response Ron … and I have to say, this software is absolutely fab. Many thanks for all your time and effort on it.

    Cheers,
    Nick.

    #14356
    rpedde
    Participant

    @fivesboy wrote:

    Turn of background scanning and use the web interface to kick off a scan when you add new music.

    Ok. Thanks for the response Ron … and I have to say, this software is absolutely fab. Many thanks for all your time and effort on it.

    Cheers,
    Nick.

    I’ll get this fixed, just lots of other stuff to shape up before a stable right now.

    — Ron

    #14357
    dovad
    Participant

    I’m running a Linkstation LS1 PPC with Freelink and svn-1696. Every time I run a scan Firefly crashes. I stopped auto-scanning for this reason. Is there a work- around until time allows for a fix? Is it possible and sensible to delete the database and have a new one created when rebooting?

    #14358
    fizze
    Participant

    svn-1696 is horribly with sqlite2.
    I just migrated to sqlite3, which seems stabler. At least it scans, plus its faster than sqlite2.

    Here’s how to change to sqlite3 yourself:

    sqlite /path/to/songs.db .dump | sqlite3 /path/to/songs3.db 

    Make sure mt-daapd is stopped, albeit.

    Then change the db_type in mt-daapd.conf to sqlite3, and fire up mt-daapd.

    That’s it – on an unslung NSLU2 at least. 🙂

    #14359
    dovad
    Participant

    OK, I tried this but now Firefly will not start. The error log is as follows:

    2007-12-02 09:48:18 (3001f380): Firefly Version svn-1696: Starting with debuglevel 2
    2007-12-02 09:48:18 (3001f380): Plugin loaded: ssc-script/svn-1696
    2007-12-02 09:48:18 (3001f380): Plugin loaded: rsp/svn-1696
    2007-12-02 09:48:18 (3001f380): Plugin loaded: daap/svn-1696
    2007-12-02 09:48:18 (3001f380): Starting rendezvous daemon
    2007-12-02 09:48:18 (3001f380): Starting signal handler
    2007-12-02 09:48:18 (3001f380): Error opening db: No backend database support for type: sqlite3

    Note that I tried switching to Sqlite3 via the web interface a couple of days ago and could not start Firefly so this time I assumed that I did not have sqlite3 installed and had to:

    “apt-get install sqlite3” before I followed your instructions and did the install of sqlite3 first. I assume that I have to install something else because of the “Error opening db: No backend database support for type: sqlite3”? I did modify the config file specifying sqlite3 as the default database after your instructions but before trying to start Firefly.

    #14360
    fizze
    Participant

    You probably forgot to do

    ldconfig

    So the sqlite3 libs are not known to the rest of the system 😉

    If you sure you did, do a “which -a sqlite sqlite3” and see if the sqlite3 binary is present.

    #14361
    rpedde
    Participant

    @dovad wrote:

    OK, I tried this but now Firefly will not start. The error log is as follows:

    2007-12-02 09:48:18 (3001f380): Firefly Version svn-1696: Starting with debuglevel 2
    2007-12-02 09:48:18 (3001f380): Plugin loaded: ssc-script/svn-1696
    2007-12-02 09:48:18 (3001f380): Plugin loaded: rsp/svn-1696
    2007-12-02 09:48:18 (3001f380): Plugin loaded: daap/svn-1696
    2007-12-02 09:48:18 (3001f380): Starting rendezvous daemon
    2007-12-02 09:48:18 (3001f380): Starting signal handler
    2007-12-02 09:48:18 (3001f380): Error opening db: No backend database support for type: sqlite3

    Note that I tried switching to Sqlite3 via the web interface a couple of days ago and could not start Firefly so this time I assumed that I did not have sqlite3 installed and had to:

    “apt-get install sqlite3” before I followed your instructions and did the install of sqlite3 first. I assume that I have to install something else because of the “Error opening db: No backend database support for type: sqlite3”? I did modify the config file specifying sqlite3 as the default database after your instructions but before trying to start Firefly.

    That would mean that your version isn’t compiled with sqlite3. Where did you get the package?

    I hope not from, me, I thought I was compiling all mine with both. eek!

    — Ron

Viewing 15 posts - 1 through 15 (of 18 total)
  • The forum ‘Nightlies Feedback’ is closed to new topics and replies.