Firefly Server will not stay running.

[gomedog]

My Firefly server was working perfectly initially. Now the tray icon is showing that the server is not running. When I try to start the server, it will “run” for about ten seconds and then revert back to not running. The log for this type of event is below. Please help.
XPsp2

2006-11-24 11:18:05 (a1832be5): Starting with debuglevel 0
2006-11-24 11:18:05 (a1832be5): Starting rendezvous daemon
2006-11-24 11:18:05 (a1832be5): Initializing database
2006-11-24 11:18:19 (a1832be5): Query: vacuum
2006-11-24 11:18:19 (a1832be5): Error: playlistitems.playlistid may not be NULL
2006-11-24 11:18:19: Aborting

[rpedde]

@gomedog wrote:

My Firefly server was working perfectly initially. Now the tray icon is showing that the server is not running. When I try to start the server, it will “run” for about ten seconds and then revert back to not running. The log for this type of event is below. Please help.
XPsp2

2006-11-24 11:18:05 (a1832be5): Starting with debuglevel 0
2006-11-24 11:18:05 (a1832be5): Starting rendezvous daemon
2006-11-24 11:18:05 (a1832be5): Initializing database
2006-11-24 11:18:19 (a1832be5): Query: vacuum
2006-11-24 11:18:19 (a1832be5): Error: playlistitems.playlistid may not be NULL
2006-11-24 11:18:19: Aborting

Delete the songs.db. It’s in c:program filesfirefly media server, or in ~/Library/Application Support/Firefly on mac.

— Ron

[gomedog]

Thank you Ron. That did the trick. Is this a glitch in the programming that will require me to delete songs.db occasionally?

[rpedde]

@gomedog wrote:

Thank you Ron. That did the trick. Is this a glitch in the programming that will require me to delete songs.db occasionally?

No, it happens if power is lost or the server terminated ungracefully when it’s in the middle of a scan.

Since I vacuum on every startup, it seems like that would be a good time to sense corruption and automatically rebuild the database, but I just haven’t done it yet.

It shouldn’t much happen, but this is the second or third time I’ve heard of it, so I suppose it makes sense to throw some defensive code at it.

[fizze]

yep, as long as its skippable just like the vacuum is.

Such semi-transient events are hard to graps, or detect.
A Hard-crash during disk-IO just plain sucks.
I’d assume the only means of detecting are some time-constraints during DB scan/read.

Stuff like this shouldnt be happening on a journaled (ext3) fs though, afaik. I deffo wouldnt like the mt-daapd startup even further delayed on my slug.

[rpedde]

@fizze wrote:

yep, as long as its skippable just like the vacuum is.

Such semi-transient events are hard to graps, or detect.
A Hard-crash during disk-IO just plain sucks.
I’d assume the only means of detecting are some time-constraints during DB scan/read.

Stuff like this shouldnt be happening on a journaled (ext3) fs though, afaik. I deffo wouldnt like the mt-daapd startup even further delayed on my slug.

Yeah, but if the first thing I try to do with the database gives me an error, I can always just move the db out of the way and make a new one. that would be relatively painless and easy.

[cliffyboy34]

Same thing happended to me. Firefly media server would not stay running – and would disconnect frequently. I deleted the song.db file manually – and will wait and see what happens.

I encourage a patch – it was / is very frustrating!

[boskodog]

I, too, have the problem of keeping firefly running. I have deleted the songs.db file, “repaired” the Bonjour program, scanned and rescanned, rebooted, tried to run debug. Debug mode aborts without completing task. I do not know what else to do. Any suggestions?

boskodog

[boskodog]

@boskodog wrote:

I, too, have the problem of keeping firefly running. I have deleted the songs.db file, “repaired” the Bonjour program, scanned and rescanned, rebooted, tried to run debug. Debug mode aborts without completing task. I do not know what else to do. Any suggestions?

boskodog

This is the latest error log from the debug program:

Log file: firefly.log

,sample_count=0,codectype=’mpeg’ WHERE path=’E:iTunesiTunes MusicCompilationsThe Commitments2 Take Me To The River.mp3′ and idx=0
2007-02-09 14:14:15 (a1832be5): Rows: 1
2007-02-09 14:14:15 (a1832be5): Scanning iTunes id #2469
2007-02-09 14:14:15 (a1832be5): scan_path: file://localhost/E:/iTunes/iTunes Music/Cosmonauti/Bikini Angel/01 She’s Not There.mp3
2007-02-09 14:14:15 (a1832be5): Executing: select * from songs where path=’E:iTunesiTunes MusicCosmonautiBikini Angel1 She”s Not There.mp3′ and idx=0
2007-02-09 14:14:15 (a1832be5): Executing: INSERT INTO updated VALUES (11733)
2007-02-09 14:14:15 (a1832be5): Rows: 1
2007-02-09 14:14:15 (a1832be5): Executing: select count(*) from songs where path=’E:iTunesiTunes MusicCosmonautiBikini Angel1 She”s Not There.mp3′ and idx=0
2007-02-09 14:14:15 (a1832be5): Executing: UPDATE songs SET title=’She”s Not There’,artist=’Cosmonauti’,album=’Bikini Angel’,genre=’Rock’,comment=”,type=’mp3′,composer=”,orchestra=”,conductor=”,grouping=’Surf’,url=”,bitrate=192,samplerate=44100,song_length=145084,file_size=3550337,year=2003,track=1,total_tracks=0,disc=0,total_discs=0,time_modified=1133315532,db_timestamp=1171048455,bpm=0,disabled=0,compilation=0,rating=0,sample_count=0,codectype=’mpeg’ WHERE path=’E:iTunesiTunes MusicCosmonautiBikini Angel1 She”s Not There.mp3′ and idx=0
2007-02-09 14:14:15 (a1832be5): Query: UPDATE songs SET title=’She”s Not There’,artist=’Cosmonauti’,album=’Bikini Angel’,genre=’Rock’,comment=”,type=’mp3′,composer=”,orchestra=”,conductor=”,grouping=’Surf’,url=”,bitrate=192,samplerate=44100,song_length=145084,file_size=3550337,year=2003,track=1,total_tracks=0,disc=0,total_discs=0,time_modified=1133315532,db_timestamp=1171048455,bpm=0,disabled=0,compilation=0,rating=0,sample_count=0,codectype=’mpeg’ WHERE path=’E:iTunesiTunes MusicCosmonautiBikini Angel1 She”s Not There.mp3′ and idx=0
2007-02-09 14:14:15 (a1832be5): Error: unable to open database file
2007-02-09 14:14:15 (a1832be5): Error updating file: 01 She’s Not There.mp3
2007-02-09 14:14:15: Aborting

[boskodog]

@boskodog wrote:

I, too, have the problem of keeping firefly running. I have deleted the songs.db file, “repaired” the Bonjour program, scanned and rescanned, rebooted, tried to run debug. Debug mode aborts without completing task. I do not know what else to do. Any suggestions?

boskodog

This is the latest error log while trying to play:

Log file: firefly.log

2007-02-09 14:23:00 (1e8a145d): Starting with debuglevel 0
2007-02-09 14:23:00 (1e8a145d): Starting rendezvous daemon
2007-02-09 14:23:00 (1e8a145d): Initializing database
2007-02-09 14:23:09 (1e8a145d): Starting web server from C:Program FilesFirefly Media Serveradmin-root on port 9999
2007-02-09 14:23:09 (1e8a145d): Registering rendezvous names
2007-02-09 14:23:09 (1e8a145d): Serving 30284 songs. Startup complete in 9 seconds
2007-02-09 14:23:09 (1e8a145d): Rescanning database
2007-02-09 14:23:22 (afb60a1f): Session 0: Streaming file ’01 Out Of This World.mp3′ to 192.168.1.102 (offset 0)
2007-02-09 14:24:21 (1e8a145d): Scanning E:iTunesiTunes MusiciTunesaiTunes Music Library.xml
2007-02-09 14:24:32 (1e8a145d): Scanning E:iTunesiTunes MusiciTunesiTunes Music Library.xml
2007-02-09 14:25:52 (afb722e1): Session 0: Streaming file ‘4-01 I’ve Got A Crush On You.mp3’ to 192.168.1.102 (offset 0)
2007-02-09 14:28:00 (1e8a145d): Query: UPDATE songs SET title=’Pillar Of Davidson’,artist=’Live’,album=’Throwing Copper’,genre=’Rock’,comment=”,type=’mp3′,composer=’Kowalczyk, Ed; Taylor, Chad; Dahlheimer, Patrick & Gracey, Chad’,orchestra=”,conductor=”,grouping=”,url=”,bitrate=192,samplerate=44100,song_length=406151,file_size=9777265,year=1994,track=12,total_tracks=14,disc=1,total_discs=1,time_modified=1133903264,db_timestamp=1171049280,bpm=0,disabled=0,compilation=0,rating=0,sample_count=0,codectype=’mpeg’ WHERE path=’E:iTunesiTunes MusicLiveThrowing Copper12 Pillar Of Davidson.mp3′ and idx=0
2007-02-09 14:28:00 (1e8a145d): Error: unable to open database file
2007-02-09 14:28:00 (1e8a145d): Error updating file: 12 Pillar Of Davidson.mp3
2007-02-09 14:28:00: Aborting

[Author]

Posts