cherrypy and sql query errors

Get help with all aspects of SABnzbd
Forum rules
Help us help you:
  • Are you using the latest stable version of SABnzbd? Downloads page.
  • Tell us what system you run SABnzbd on.
  • Adhere to the forum rules.
  • Do you experience problems during downloading?
    Check your connection in Status and Interface settings window.
    Use Test Server in Config > Servers.
    We will probably ask you to do a test using only basic settings.
  • Do you experience problems during repair or unpacking?
    Enable +Debug logging in the Status and Interface settings window and share the relevant parts of the log here using [ code ] sections.
NunyaBzness
Newbie
Newbie
Posts: 16
Joined: April 24th, 2017, 10:23 am

Re: cherrypy and sql query errors

Post by NunyaBzness » March 8th, 2019, 1:07 pm

kvoorhees wrote:
March 8th, 2019, 12:04 pm
I don't think it is a 2019 issue specifically to be honest. I had a similar experience after upgrading from 2012 to 2016 years ago. Unfortunately it persisted until I wiped the box clean and installed the OS fresh. I am very much hoping it doesn't come to that this time. I actually wiped my install of SABNzbd yesterday. Deleted everything in appdata and program files and installed fresh. Worked great and downloaded a bunch of stuff, an hour ago, same error.
My VM install was a completely fresh 2019 and SAB, with only the .ini file transitioning between old and new.

Trying the beta 2.3.8 as well...

User avatar
safihre
Administrator
Administrator
Posts: 3467
Joined: April 30th, 2015, 7:35 am
Location: Switzerland
Contact:

Re: cherrypy and sql query errors

Post by safihre » March 9th, 2019, 4:51 pm

We don't have a version with Python 2.7.16 yet.. Our build platform (appveyor) doesn't support it yet so we have to wait for that.

NunyaBzness
Newbie
Newbie
Posts: 16
Joined: April 24th, 2017, 10:23 am

Re: cherrypy and sql query errors

Post by NunyaBzness » March 9th, 2019, 7:24 pm

OK, I wrote a quick PowerShell to monitor the API for warnings containing the error condition, so things are at least functional over time.

For now, clearing the warnings and restarting SABNZBd seems to work...

User avatar
safihre
Administrator
Administrator
Posts: 3467
Joined: April 30th, 2015, 7:35 am
Location: Switzerland
Contact:

Re: cherrypy and sql query errors

Post by safihre » March 12th, 2019, 2:17 am

I created a test-build of 2.3.8Beta1 that uses Python 2.7.16:
https://github.com/sabnzbd/sabbuild/releases/tag/test3

Could you guys test if this helps?

NunyaBzness
Newbie
Newbie
Posts: 16
Joined: April 24th, 2017, 10:23 am

Re: cherrypy and sql query errors

Post by NunyaBzness » March 14th, 2019, 6:14 pm

Sure. I was on travel this week, so I didn't have access to the machine.

Do you still want to test it, or is it already rolled in the the RC? I've already loaded it, if this is a good target.

User avatar
safihre
Administrator
Administrator
Posts: 3467
Joined: April 30th, 2015, 7:35 am
Location: Switzerland
Contact:

Re: cherrypy and sql query errors

Post by safihre » March 15th, 2019, 8:12 am

The RC also has Python 2.7.16!

NunyaBzness
Newbie
Newbie
Posts: 16
Joined: April 24th, 2017, 10:23 am

Re: cherrypy and sql query errors

Post by NunyaBzness » March 15th, 2019, 9:54 am

Nothing definitive to report, but no cherrypy failures in the first 16 hours of operation on RC1.

NunyaBzness
Newbie
Newbie
Posts: 16
Joined: April 24th, 2017, 10:23 am

Re: cherrypy and sql query errors

Post by NunyaBzness » March 16th, 2019, 11:43 am

Follow up: Sometime during the evening of the 24th hour, the problem recurred with 2.3.8RC1. Interestingly, the script works a few times, but later I can see clusterred temp file request failures in cherrypy even after clearing the warning log and restarting SABNZBd. Would you like a full log?

Note: I'm not sure I've ever seen the SQL errors reported by the OP.

User avatar
safihre
Administrator
Administrator
Posts: 3467
Joined: April 30th, 2015, 7:35 am
Location: Switzerland
Contact:

Re: cherrypy and sql query errors

Post by safihre » March 16th, 2019, 12:11 pm

Too bad, hoped this would fix it..
Maybe you can copy paste the errors here? Not sure what I can do about it. Maybe you can somehow give the Sab process/service more permissions?
Or maybe it's a problem of too active cleaning of the temp directory by this new windows.

NunyaBzness
Newbie
Newbie
Posts: 16
Joined: April 24th, 2017, 10:23 am

Re: cherrypy and sql query errors

Post by NunyaBzness » March 16th, 2019, 2:13 pm

Interesting line of thought. Windows 10 1809 (and Server 2019) have a built-in tool that seems to automate cleanup of temporary files. I've turned all of the features off and we'll run through it again. I'll update you in 24 hours or so.

NunyaBzness
Newbie
Newbie
Posts: 16
Joined: April 24th, 2017, 10:23 am

Re: cherrypy and sql query errors

Post by NunyaBzness » March 17th, 2019, 1:25 pm

After a little more than 24 hours of running without incident, it looks like there is a setting that remediates the problem described in this thread...

Both Windows 10 (1809) and Server 2019 (1809) automatically delete temporary files that "apps aren't using". There is no apparent configuration parameter to tune this functionality beyond turning it on and off. The setting is buried under storage management along with a bunch of other storage related settings. Default behavior is to let the system automatically manage temporary files.
  • Under Windows 10 Settings/System/Storage, select "Change how we free up space automatically"
  • Uncheck "Delete temporary files that my apps aren't using"
This is a per user setting that can also be set by GPO or registry, if you want to dig...
I'll advise if I see the problem reoccur.

User avatar
OneCD
Sr. Member
Sr. Member
Posts: 306
Joined: March 4th, 2017, 3:47 pm

Re: cherrypy and sql query errors

Post by OneCD » March 17th, 2019, 2:37 pm

NunyaBzness wrote:
March 17th, 2019, 1:25 pm
Both Windows 10 (1809) and Server 2019 (1809) automatically delete temporary files that "apps aren't using". There is no apparent configuration parameter to tune this functionality beyond turning it on and off. The setting is buried under storage management along with a bunch of other storage related settings. Default behavior is to let the system automatically manage temporary files.
Thanks for posting. I had no idea Windows did this. :-[
Stuff I like: Apache BASH CRON DD-WRT Debian DNSMasq Entware FireFox GitHub ImageMagick Kate KDE LibreELEC Netrunner NFS NVIDIA OpenVPN Orvibo S20 Python Raspberry Pi RAID SABnzbd+ SickChill Transmission Usenet VirtualBox Watcher3 WordPress XFCE

NunyaBzness
Newbie
Newbie
Posts: 16
Joined: April 24th, 2017, 10:23 am

Re: cherrypy and sql query errors

Post by NunyaBzness » March 17th, 2019, 4:16 pm

Well hell, after about 28 hours, the CherryPy error returned for a blip. Will keep monitoring.

Post Reply