May 21, 201412 yr Author Im having trouble with my NZBDrone crashing and the error points to SQL logic error or missing database 14-5-21 11:05:15.4|Info|Bootstrap|Starting NzbDrone - /usr/local/nzbdrone/NzbDrone.exe - Version 2.0.0.1397 14-5-21 11:05:16.2|Info|MigrationLogger|*** Migrating data source=/.config/NzbDrone/nzbdrone.db;cache size=-10485760;datetimekind=Utc;journal mode=Wal *** 14-5-21 11:05:16.3|Info|MigrationLogger|*** Migrating data source=/.config/NzbDrone/logs.db;cache size=-10485760;datetimekind=Utc;journal mode=Wal *** 14-5-21 11:05:16.4|Info|Router|Application mode: Interactive 14-5-21 11:05:16.5|Info|OwinHostController|Listening on the following URLs: 14-5-21 11:05:16.5|Info|OwinHostController| http://*:8084/ 14-5-21 11:05:16.6|Info|NancyBootstrapper|Starting NzbDrone API 14-5-21 11:05:17.7|Info|SceneMappingService|Updating Scene mapping 14-5-21 11:05:17.9|Info|HousekeepingService|Running housecleaning tasks 14-5-21 11:05:18.9|Info|Database|Vacuuming database 14-5-21 11:05:19.3|Info|Database|Database Compressed 14-5-21 11:05:33.4|Warn|GlobalExceptionHandlers|SignalR Heartbeat error. 14-5-21 11:05:48.2|Error|QueueService|Error getting queue from download client: Sabnzbd 14-5-21 11:05:48.2|Error|Scheduler|Error occurred while executing task NzbDrone.Core.Download.CheckForFailedDownloadCommand System.Data.SQLite.SQLiteException: SQL logic error or missing database near "--10485760": syntax error at System.Data.SQLite.SQLite3.Prepare (System.Data.SQLite.SQLiteConnection cnn, System.String strSql, System.Data.SQLite.SQLiteStatement previous, UInt32 timeoutMS, System.String& strRemain) [0x00000] in <filename unknown>:0 at System.Data.SQLite.SQLiteCommand.BuildNextCommand () [0x00000] in <filename unknown>:0 14-5-21 11:05:50.2|Info|RssSyncService|Starting RSS Sync 14-5-21 11:05:55.8|Info|DownloadDecisionMaker|Processing 300 reports 14-5-21 11:06:09.0|Info|RssSyncService|RSS Sync Completed. Reports found: 300, Reports downloaded: 0 This is from when i start the plugin, im on the latest plugin version, i have tried downgrading but that hasn't made any difference either. any ideas? thanks I think that means SQL install is messed up. Have you rebooted to see if it is resolved? Do you have any other plugins installing that aren't mine that also install sqlite3? Can you try to run sqlite3 --version from the prompt to see if it throws an error?
May 21, 201412 yr I think that means SQL install is messed up. Have you rebooted to see if it is resolved? Do you have any other plugins installing that aren't mine that also install sqlite3? Can you try to run sqlite3 --version from the prompt to see if it throws an error? i cant restart at the moment as im doing a preclear to replace a failing data drive. No other plugins that use SQLite3. Only things i have running are SABnzbd CouchPototoe apcupsd dynamix none of which i would suspect would run SQLite3 sqlite3 --version = 3.7.5 with no errors
May 21, 201412 yr Author The only other option is that it's a problem with nzbdrone itself and you may need to post to their website for help. Since it runs then fails is probably not the plugin but likely a corrupted SQL database.
May 21, 201412 yr The only other option is that it's a problem with nzbdrone itself and you may need to post to their website for help. Since it runs then fails is probably not the plugin but likely a corrupted SQL database. OK thanks, I might wait till the preclear has finished and after the restart and see if it is any better, ill revert back to sickbeard for the moment i think
May 21, 201412 yr Author OK if you haven't setup anything really in drone you can just locate the .db file in your conduit directory and delete that then start drone again. It will auto recreate the database (as empty) but sickbeard works well too.
May 21, 201412 yr OK if you haven't setup anything really in drone you can just locate the .db file in your conduit directory and delete that then start drone again. It will auto recreate the database (as empty) but sickbeard works well too. I originally had SB setup and moved all over to NZBDrone have been using this for a while now and now its giving me trouble. but i do think its the drive thats failing that is giving me the problem and it holds the tv shows. it takes a long time to do anything with that drive.
May 21, 201412 yr Author OK if you haven't setup anything really in drone you can just locate the .db file in your conduit directory and delete that then start drone again. It will auto recreate the database (as empty) but sickbeard works well too. I originally had SB setup and moved all over to NZBDrone have been using this for a while now and now its giving me trouble. but i do think its the drive thats failing that is giving me the problem and it holds the tv shows. it takes a long time to do anything with that drive. Definitely sounds like a failing drive to me. If the DB is on there, maybe see if you can recover it over to another drive for the time being, might be salvageable.
May 22, 201412 yr NOTES - If you restart the application from within nzbdrone (not form the plugin), the plugin will no longer show the program as running. This is because restarting it from inside nzbdrone doesn't create the daemonized .lock file. To resolve this, stop the application from inside nzbdrone, and restart it using the plugin from the GUI. Not a big deal as it seems to be cosmetic from what I can tell. But I see the plugin as stopped even when I start it from the unraid GUI. I did do an upgrade from the .7 plugin that was out there, to the latest 1.4.3. I reused what I believe was the config directory previously /mnt/user/apps/nzbdrone/AppData My install directory on the old version was this, and was all that could be set of course /mnt/user/apps/nzbdrone Just want to verify.
May 22, 201412 yr Author NOTES - If you restart the application from within nzbdrone (not form the plugin), the plugin will no longer show the program as running. This is because restarting it from inside nzbdrone doesn't create the daemonized .lock file. To resolve this, stop the application from inside nzbdrone, and restart it using the plugin from the GUI. Not a big deal as it seems to be cosmetic from what I can tell. But I see the plugin as stopped even when I start it from the unraid GUI. I did do an upgrade from the .7 plugin that was out there, to the latest 1.4.3. I reused what I believe was the config directory previously /mnt/user/apps/nzbdrone/AppData My install directory on the old version was this, and was all that could be set of course /mnt/user/apps/nzbdrone Just want to verify. Looks right to me.
May 22, 201412 yr It shouldn't be showing up as stopped though correct? Any thoughts on what to look into if it's not supposed to? I watched that config directory when I started it I saw (and sorry I'm not near my unraid box right now) 2 files appear in that AppData directory, I'm wanting to say they had db in them. And then shortly after I would start the plugin, they would disappear and I'd refresh the page and it would show as stopped. Like I said nzbdrone still seemed to be functioning even after it shows that it's stopped.
May 22, 201412 yr Author It shouldn't be showing up as stopped though correct? Any thoughts on what to look into if it's not supposed to? I watched that config directory when I started it I saw (and sorry I'm not near my unraid box right now) 2 files appear in that AppData directory, I'm wanting to say they had db in them. And then shortly after I would start the plugin, they would disappear and I'd refresh the page and it would show as stopped. Like I said nzbdrone still seemed to be functioning even after it shows that it's stopped. I would delete nzbdrone.exe from the install directory then reboot and my plugin will detect it as not installed then you can run install to fix it. The pid file runs in a different location than the old plugins pid and running my plugins install will create the proper run folder for the pid. This happens because you have your install directory persistent.
May 23, 201412 yr Should the "Config Directory" in the plugin match up with the "AppData Directory" in nzbdrone itself? Mine's not, but I'm not sure if that abnormal or not.
May 23, 201412 yr Author Should the "Config Directory" in the plugin match up with the "AppData Directory" in nzbdrone itself? Mine's not, but I'm not sure if that abnormal or not. Can you give me specific examples? My setup is like this: Install Dir: /usr/local/nzbdrone Config Dir: /mnt/cache/.appdata/nzbdrone/AppData The "AppData" part in my config is there because the old plugin i used added that for me. My plugin doesn't auto add that subfolder because some users don't want to use it. Whichever folder has "config.xml" in it, is what you should set your config directory to.
May 26, 201412 yr In the plugin I have it set like this: http://i.imgur.com/xHieWKW.png (config directory as /mnt/user/Apps/nzbdrone) But nzbdrone reports it like this: http://i.imgur.com/D2tyDjN.png (AppData directory as /.config/NzbDrone) Config.xml is indeed in /mnt/user/Apps/nzbdrone - I just spotted what nzbdrone reported and couldn't recall if that was like that before the most recent plugin update, or if it would cause any issues.
May 26, 201412 yr Author In the plugin I have it set like this: http://i.imgur.com/xHieWKW.png (config directory as /mnt/user/Apps/nzbdrone) But nzbdrone reports it like this: http://i.imgur.com/D2tyDjN.png (AppData directory as /.config/NzbDrone) Config.xml is indeed in /mnt/user/Apps/nzbdrone - I just spotted what nzbdrone reported and couldn't recall if that was like that before the most recent plugin update, or if it would cause any issues. Ah, yes, that is normal. When I made this plugin, nzbdrone had no way to change that option (and im not sure if it can still) so your config data is saved to the directory you selected in the plugin settings, and then I have that symlinked to where nzbdrone expects it to be. That way your data is in the correct spot and nzbdrone can find it. Its a work around to drone not having the option to select the config directory via command line options. If you go to unraid prompt and enter that folder, it will actually take you to your /mnt/user/apps/nzbdrone folder
May 26, 201412 yr If you go to unraid prompt and enter that folder, it will actually take you to your /mnt/user/apps/nzbdrone folder It does - symlinked as expected. Thanks!
May 28, 201412 yr Is anybody using XBMC along with NZBdrone? And if you are, is your Drone still updating your XBMC? For the past 3+ weeks or so my drone will not update any XBMC clients. I posted on the drone forums but haven't really received a solution yet. I did try installing drone on windows and it will update XBMC as it is supposed to but the one running on unRAID will not
May 30, 201412 yr Author I was forced to turn off the user name and password on xbmc to get mine working again. I spoke to the Dev and he had no idea why it happened.
May 30, 201412 yr After upgrading from .1397 to .1522 (from the plugin page), it looks like my install is confused. Both settings>nzbdrone and current_version.num file show me upgraded to 2.0.0.1522, but in system>updates, it still shows a checkmark by 2.0.0.1397 and prompts me to update to later versions. Is this a KI? Any suggestions? Cheers!
May 31, 201412 yr Author After upgrading from .1397 to .1522 (from the plugin page), it looks like my install is confused. Both settings>nzbdrone and current_version.num file show me upgraded to 2.0.0.1522, but in system>updates, it still shows a checkmark by 2.0.0.1397 and prompts me to update to later versions. Is this a KI? Any suggestions? Cheers! Try deleting the 'current_version.num' file from your install directory. Then when you go to the plugin page it will not detect your current version and will prompt for an update again. I've updated mine just fine and it does an MD5 check on the download so it must have been something sketchy with the extraction process perhaps, but a reinstall will fix that. All of the plugins i've made have a way to check the current version installed of their application so its 'real time' but drone doesn't have any option to check via command line. Because of this, the version is extracted during install, and stored in that current_version.num file. I prefer not to have version numbers static in a text file because flaws like this can occur, so once drone adds a way to check the current installed version from command line I will update the plugin to use that real time check instead.
June 9, 201412 yr Author Speaking with the dev, there is a way to get the current version from drone via command line, so I'll put out an updated plugin soon that can read the version number real time. This will catch any bad updates that may happen.
July 1, 201412 yr Its been a while, but i think the plugin is broke again. Like the previous poster i did the update, it said i did the update, but nzbdrone was still the old version. I blew my install away in hopes of getting a fresh copy. Now it just says it downloaded, but it never installs. The plugin went above my head when it switched to this: http://update.nzbdrone.com/repos/apt/debian/dists/master/main/binary-i386/ which points to this: http://www.nzbdrone.com Priority: optional Section: web Filename: pool/main/n/nzbdrone/nzbdrone_2.0.0.1617_all.deb However my old goto site ( assume the same place): http://update.nzbdrone.com/repos/apt/debian/pool/main/n/nzbdrone/ has nzbdrone_2.0.0.1617_all.deb and a new nzbdrone_2.0.0.1631_all.deb Still i dont know how to check the logs on why its failing. I still managed a reinstall doing it the old way: GOTO here and get the latest release http://update.nzbdrone.com/repos/apt/debian/pool/main/n/nzbdrone/ -Extract the .deb package with 7zip or ar or whatever and you'll end up with data.tar. Extract that. Everything you need is in "opt/NzbDrone". Move the NzbDrone folder to /mnt/cache/.NzbDrone (hint to make a hidden folder in windows name it .NzbDrone. ).
July 2, 201412 yr Will this plugin be updated with the new url to fetch the new version? It's broken for me too. Thanks
July 2, 201412 yr Will this plugin be updated with the new url to fetch the new version? It's broken for me too. Thanks I dont think its a download problem. I think the package has a version check for the supporting (mono etc) software, and its failing the check. The plug in doesnt check for failed installs, so it just checks the package, pulls the version number, and thinks its good to go.
Archived
This topic is now archived and is closed to further replies.