Issues with 2.0.0.1207

I’ve noticed since Monday that most of my shows have not been picked up. I’ve observed Drone crashing/stopping and then having to manually restart it. every time is comes up it goes through the processing report and then eventually stops responding. not quiet sure what is going on. I haven’t noticed anything calling for attention in the log.

Any help would be great, at this point I am not able to get any new shows.

On Windows or Linux?

Could you post the logs when it crashes? Does it always hang doing the same thing (RSS sync, refresh, etc)?

Sorry for the delay, works been nuts. This is on Win7-64.
It appears to be crashing during the sync and refresh. I also put in a call to fetch a file and I can’t tell if that is also causing issues. I’ve attached a link below to my log file, i would have used pastebin, but since i don’t have a pro account I can’t have files bigger than 500KB and this one is 800KB. Thanks

Log File: https://dl.dropboxusercontent.com/u/8105098/nzbdrone.txt

I’ll throw a suggestion out there for you.

Myself and 3 of my friends I setup all had issues this weekend when NONE of our shows downloaded on Sunday night. It seems an update was pushed that enforces the use of an API key or a username and password when connecting to Sabnzbd. I disable API key in Sab and do not use a user/pass so all connections to Sab were failing and I saw that in the logs.

I went into the settings page for Sab in NZBDrone and I saw a message telling me I needed an API key or User/Pass, so I pasted in the “disabled” API key from Sab and it connected and everything has been working since. Maybe it’s a completely different issue, but give this a try first and see if it helps.

Looks to be crashing/restarting during the library update, after a bunch of lock errors, I’ll take a look.

Some possible causes are anti virus or Windows search indexer locking the files. I checked out some of the code I thought might be causing it, but it doesn’t look to be the culprit (also not seeing this on my system and this change has been running since last week).

i’ve noticed a few of my eps weren’t downloading this week either but after performing a manual search it said the episodes were blacklisted and this is for the episodes that were out that day i know some shows can be quickly removed but just something i noticed

I might try forcing a grab of these blacklisted episodes and see if they download regardless and report back either way

Update:
Hmm interesting i noticed an episode of Blue bloods that was release today did not auto-download so i did a manual search as i mentioned above and it said the release was blacklisted so i press to force it to grab and download and the episode downloaded successfully

not sure why it would say blacklisted if i downloaded correctly perhaps someone at the indexer couldn’t get it to download with their usenet provider so assumed it was broken

Over downloading, my issue is just keeping drone up at this point. I do see that some episodes are being found and sent successfully to sab, but maybe only one a day if that. Plus I do have a dozen shows (looks like from when this issue started) that have yet to be picked up my drone yet just sitting in the directory.

I’m going to do what i really didn’t want to, and that is reboot. But since I am the only one having this issue so far, I will see if that"fixes" the issue. I’ll let you know what happens.

Thanks so far to everyone who has provided assistance.

So a reboot didn’t solve my issue. I’ve verified that nothing appears to be accessing the DB. I haven’t installed anything recent or changed any programs.

Here is the latest drone log
http://pastebin.com/K3szqL90

are you running Drone on a server or just a regular desktop the reason i ask is with a server OS like Windows Server 2012 (which i use) or i would assume some of the linux issues perhaps some of the security features are preventing NzbDrone’s stability perhaps folder or file permissions

are you running it as a service as i have experienced issue with the service stopping either randomly or after a reboot to get around this i have set the nzbdrone.exe to launch at startup with Task Scheduler and using that instead of the service that being said i have recently started from scratch and setup drone again and currently it is just running as the service and not as a scheduled task like i mentioned above and so far it is stable but i haven’t reboot yet either so who knows at this stage

i would if running windows check the service properties in there the option to restart the service after a failure is something you could try or do like i have and simply try just running the .exe and see if that runs ok (assuming you are running as a service)

sorry can’t be much more help but hopefully some of these suggestions might help

I verified the only processes accessing nzbdrone.db is NzbDrone.Console.exe and Path is locked to nzbdrone.db , nzbdrone.db-wal and nzbdrone.db-shm. Currently it appears it is now finding shows and sending the request to SAB. However, I have not yet seen drone pickup any newly downloaded files and process them.

Hopefully these details will help narrow in on the issue.

So this is the root cause, but I have no idea why…frankly it is starting to drive me a bit crazy. The only thing I can see that is accessing the drone db is drone. I wonder if the db is corrupt or something…

[Error] Owin: SQLite error (5): database is locked
[Error] Owin: SQLite error (5): database is locked
[Error] Owin: SQLite error (5): database is locked

Process is terminated due to StackOverflowException.

I’ve also noticed these, I’m sure they are unrelated, but it would be nice to resolve it.

[Warn] MediaCoverMapper: File C:\\ProgramData\zbDrone\\MediaCover\\61\\poster.jpg not found
[Warn] MediaCoverMapper: File C:\\ProgramData\zbDrone\\MediaCover\\370\\poster.jpg not found
[Warn] MediaCoverMapper: File C:\\ProgramData\zbDrone\\MediaCover\\383\\poster.jpg not found

Did that all come immediately during a refresh of a series? I saw the DB locks, then a restart in the middle of a series refresh before, but the stack overflow exception is new.

There was also one error that preceeded the Database locks, which was a warning saying it was locked and was waiting for 25ms.

The warnings are unrelated, those shows don’t have posters is he issue.

This is what I am seeing during the lock

![log.db] ()

![nzbdrone.db] ()

It appears to be coming on random shows, but yes, they are coming during the show refresh. Have not seen a pattern, I can restart drone and it could refresh a ton of shows before we see the locks. Other times it locks on the first show refresh.

I was first assuming the issue was w/the nzbdrone.db, is it possible the issue is really with the log.db?

Seeing errors with 15, in addition to the 5, not quiet sure the difference in the RC

[Error] Owin: SQLite error (15): locking protocol
[Error] Owin: SQLite error (15): locking protocol

more log messages…

[Error] Owin: SQLite error (10): delayed 25ms for lock/sharing conflict
[Error] Owin: SQLite error (283): recovered 3 frames from WAL file C:\\ProgramData\zbDrone\\logs.db-wal
[Error] Owin: SQLite error (15): locking protocol

Here are the two different RC I am getting

                             ,5,"SQLITE_BUSY"       ;The database file is locked
                            ,15,"SQLITE_PROTOCOL"   ;Database lock protocol error 

How big is your logging database? Try stopping drone and deleting logs.db and see if it continues, does look like a logging issue. I’ll have to review what changed with the logging.