Firefly dies with "Unable to open database file"

FireFly Media Server Firefly Media Server Forums Firefly Media Server General Discussion Firefly dies with "Unable to open database file"

Viewing 14 posts - 1 through 14 (of 14 total)
  • Author
    Posts
  • #506
    fatveg
    Participant

    Hi there,
    I’ve just installed Firefly on my WinXP machine. Got the RC4 release linked from Roku site. I have configured it using the iTunes database (which is in the My Documents forlder for a user ‘iTunes’, and which points to mp3s on another disk).

    Server works fine, except that every few hours it dies with an ‘unable to open database file’.

    At the time it dies, I am doing nothing on either the PC or the Roku. Both of the examples below happened when it was playing a preset which does a random play through all songs in the library.

    Here is my set-up:

    Firefly Service	1.0 svn-1313	C:Program FilesFirefly Media Serverfirefly.exe
    FireflyShell 1.0 svn-1313 C:Program FilesFirefly Media ServerFireflyShell.exe
    RSP Output Plugin 1.0 svn-1313 C:Program FilesFirefly Media Serverpluginsrsp.dll
    FFMPEG Transcoder Plugin 1.0 svn-1313 C:Program FilesFirefly Media Serverpluginsssc-ffmpeg.dll
    WMA Transcoder Plugin 1.0 svn-1313 C:Program FilesFirefly Media Serverpluginsssc-wma.dll
    Win32 Event Plugin 1.0 svn-1313 C:Program FilesFirefly Media Serverpluginsw32-event.dll

    And here are two examples of the failure:

    snip
    snip

    In the above I have scanning set to ‘0 – Normal’ with a frequency of once every two hours. I am running BitDefender, but apart from that a normal XP SP2 set-up.

    Let me know if you need more info.

    Thanks, Chris.

    #5903
    fatveg
    Participant

    For more info: Here’s a log of it failing while it’s NOT streaming, so it seems to be a problem just while scanning. I’m not sure why its trying to do the update as nothing will have changed.

    Log file: firefly.log

    2006-08-13 11:42:47 (47a075f8): Starting with debuglevel 0
    2006-08-13 11:42:47 (47a075f8): Starting rendezvous daemon
    2006-08-13 11:42:47 (47a075f8): Initializing database
    2006-08-13 11:42:53 (47a075f8): Starting web server from C:Program FilesFirefly Media Serveradmin-root on port 9999
    2006-08-13 11:42:54 (47a075f8): Registering rendezvous names
    2006-08-13 11:42:54 (47a075f8): Serving 5145 songs. Startup complete in 7 seconds
    2006-08-13 11:42:54 (47a075f8): Rescanning database
    2006-08-13 11:42:54 (47a075f8): Scanning C:Documents and SettingsiTunesMy DocumentsMy MusiciTunesiTunes Music Library.xml

    2006-08-13 11:47:49 (47a075f8): Error: unable to open database file
    2006-08-13 11:47:49 (47a075f8): Error updating file: ae10380c_0f2b411d_12.mp3
    2006-08-13 11:47:49: Aborting

    Any help would be greatly appreciated as I really like this server and would love to be able to use it.

    ‘veg

    #5904
    rpedde
    Participant

    @fatveg wrote:

    For more info: Here’s a log of it failing while it’s NOT streaming, so it seems to be a problem just while scanning. I’m not sure why its trying to do the update as nothing will have changed.

    could you try latest nightlies at http://nightlies.mt-daapd.org?

    #5905
    fatveg
    Participant

    @rpedde wrote:

    @fatveg wrote:

    For more info: Here’s a log of it failing while it’s NOT streaming, so it seems to be a problem just while scanning. I’m not sure why its trying to do the update as nothing will have changed.

    could you try latest nightlies at http://nightlies.mt-daapd.org?

    Just installed that — will let you know what happens. Thanks!

    #5906
    fatveg
    Participant

    Hi there — I re-installed nightlies, same thing happening. Again, it seems to be that during the rescan it tries to do an UPDATE and fails. Not sure why it would be trying to update, as nothing would have changed in the library. Here’s the info:

    Firefly Service	1.0 svn-1340	C:Program FilesFirefly Media Serverfirefly.exe
    FireflyShell 1.0 svn-1340 C:Program FilesFirefly Media ServerFireflyShell.exe
    RSP Output Plugin 1.0 svn-1340 C:Program FilesFirefly Media Serverpluginsrsp.dll
    FFMPEG Transcoder Plugin 1.0 svn-1340 C:Program FilesFirefly Media Serverpluginsssc-ffmpeg.dll
    WMA Transcoder Plugin 1.0 svn-1340 C:Program FilesFirefly Media Serverpluginsssc-wma.dll
    Win32 Event Plugin 1.0 svn-1340 C:Program FilesFirefly Media Serverpluginsw32-event.dll
    snip

    FF was installed and run from an administrator account. The iTunes db is set up from a different account than the one I used to install FF — don’t know if that’s pertinant. Any ideas? Thanks!

    #5907
    rpedde
    Participant

    @fatveg wrote:

    Hi there — I re-installed nightlies, same thing happening.

    Do you have any anti-virus software installed? Is it possible to exclude the firefly directory from scanning for viruses? The way sqlite works, it connects and disconnects from the database whenever it does something (an insert, an update, whatever). I’m wondering if an AV product is scanning the database and causing sqlite to have a problem opening it.

    #5908
    fatveg
    Participant

    OK, might be on to something. Yes, I had BitDefender running. I switched it off completely, and firefly has stayed up for a day. I have now re-started BitDefender, but with Shield settings “scan prog files only/Exclude xml”. I’ll let you know if it still stays up and running.

    Thanks, ‘veg

    #5909
    fatveg
    Participant

    Well, I thought it was better, but it still died after trying an update. My final work-around was to no-longer point to the iTunes database but to the folders containing the mp3s — has now been working with no problems for a couple of weeks, but I can’t access iTunes playlists of course.

    Doing a search it seems like a few people have had this problem. I’m guessing it is a conflict with BitDefender, but still don’t understand why FF was trying to do the Update in the first place.

    People elsewhere with the same problem have recommended setting ‘Always Scan’ to ‘No’ — what does that do?

    thanks, ‘veg

    #5910
    rpedde
    Participant

    @fatveg wrote:

    Well, I thought it was better, but it still died after trying an update. My final work-around was to no-longer point to the iTunes database but to the folders containing the mp3s — has now been working with no problems for a couple of weeks, but I can’t access iTunes playlists of course.

    Doing a search it seems like a few people have had this problem. I’m guessing it is a conflict with BitDefender, but still don’t understand why FF was trying to do the Update in the first place.

    People elsewhere with the same problem have recommended setting ‘Always Scan’ to ‘No’ — what does that do?

    thanks, ‘veg

    It only does rescans when someone is connected to the server. It’s like turning down the scanning interval — it makes the problem occur less frequently, not disappear.

    — Ron

    #5911
    diablodale
    Guest

    The first scan when the firefly service starts up works, but the 2nd scan fails with can’t open database.

    1. If I disable mcafee virus, then it stays running fine.
    2. If I run firefly in debug mode, then it stays running fine.

    Mcafee doesn’t allow customers to define directory exclusions or specific extensions to ignore. Argh.

    Perhaps the firefly codebase can do a retry or have a longer timeout for the db file i/o to return while virus protection is scanning? Or would this happen so many time to make firefly non performant?

    –Dale

    #5912
    rpedde
    Participant

    @diablodale wrote:

    Mcafee doesn’t allow customers to define directory exclusions or specific extensions to ignore. Argh.

    That’s brain-damaged. The only thing worse than scanning a database would be false-positiving it and corrupting it while “fixing” it. Norton used to do that pretty regularly to exchange servers, as I recall.

    Strange they can’t do that.

    Perhaps the firefly codebase can do a retry or have a longer timeout for the db file i/o to return while virus protection is scanning? Or would this happen so many time to make firefly non performant?

    The sqlite2 drive retries for 30 seconds before it gives up.

    What version of McAfee is that? There have to be some kind of hidden registry settings or something. I’m almost positive that ePO can push out directory exclusions, so it stands to reason there must be some way to do it on the client — at least with some reg settings or something.

    #5913
    diablodale
    Guest

    It’s McAfee Security Center 7.0.331. I called into McAfee support on this a month or so ago and grilled them over and over asking for config settings to exclude directories or create user-defined extension exclusions. He repeatedly said its not possible with this product.

    McAfee does have an enterprise product which likely does have group policies like you describe. But it seems they’ve dumbed down the features soo much for their consumer product, that they’ve hobbled it.

    I’m experimenting now. I turned off heuristic scanning yesterday and it stayed running about 17 hours. I’ve restarted the service and am going to see how long it runs again. Then turn heuristics back on and see if it fails on the 2nd scan. Want to ensure it really is McAfee since the behavior did change yesterday.

    –Dale

    #5914
    diablodale
    Guest

    When I turned heuristics back on, it fails on the 2nd scan. But with it off, it eventually fails. But I’m not sure the cause. It might stay running 18 or so hours or up to several days. When I remember to check the log file, the log file says the familiar ‘unable to open db’

    #5915
    rpedde
    Participant

    @diablodale wrote:

    When I turned heuristics back on, it fails on the 2nd scan. But with it off, it eventually fails. But I’m not sure the cause. It might stay running 18 or so hours or up to several days. When I remember to check the log file, the log file says the familiar ‘unable to open db’

    That’s unquestionably the virus scanner. I will double-check the retry interval though. It might be that I’m not actually retrying for 30 seconds. I’ll double-check that.

    — Ron

Viewing 14 posts - 1 through 14 (of 14 total)
  • The forum ‘General Discussion’ is closed to new topics and replies.