Re: [web2py] Re: Web2py freezing on live deployment!

2013-11-20 Thread Andrew Buchan
Hi Niphlod, what is asking for disasters? Bumping it up to 500? Can you elaborate on why? (I'm all for avoiding disasters given what's been happening!) The server-status page was showing 150 worker threads active, except lots of the seem not to be from proper requests. Here's my post on apacheloung

[web2py] Re: Web2py freezing on live deployment!

2013-11-20 Thread Niphlod
On Wednesday, November 20, 2013 3:56:51 PM UTC+1, Andrew Buchan wrote: > > Further update: > > Apache did finally crash, with the following message: > > "Server ran out of threads to serve requests. Consider raising the > ThreadsPerChild setting" > > I've bumped that up to 500, and there a

[web2py] Re: Web2py freezing on live deployment!

2013-11-20 Thread Andrew Buchan
Further update: Apache did finally crash, with the following message: "Server ran out of threads to serve requests. Consider raising the ThreadsPerChild setting" I've bumped that up to 500, and there are less than that number of users on the system (although I understand there will be mor

Re: [web2py] Re: Web2py freezing on live deployment!

2013-11-15 Thread Derek
That's cool, I was just asking about the side project of Niphlod's to look at the pytds so that we could finally have a pure python database adapter. With a pure python adapter, gevent could properly use greenlets to make database queries, thus there would be no blocking on the queries. On Frid

Re: [web2py] Re: Web2py freezing on live deployment!

2013-11-15 Thread Andrew Buchan
Hi Derek, the install on Apache is running fine and the ajax issue it threw up I was able to fix as described above. So my problem is solved, but thanks for checking in again. I found that after updating to the latest version of web2py, it was easy to get apache running following the deployment rec

[web2py] Re: Web2py freezing on live deployment!

2013-11-14 Thread Derek
any luck? On Thursday, November 7, 2013 12:26:44 AM UTC-7, Niphlod wrote: > > hard ? with DAL it's pretty easy if a module exposes the dbapi just > force the driver and implement the connect method and it's usually good to > go. > I'll test it when I get back home. > -- Resources: - http:/

Re: [web2py] Re: Web2py freezing on live deployment!

2013-11-08 Thread Andrew Buchan
Yes, I've been caught out by that quite a few times! Not a problem with Apached I may add, the wsgi file redirects stdout to show up in the apache error log, but I suppose you could point it anywhere really. On Fri, Nov 8, 2013 at 12:31 PM, Tim Richardson wrote: > I had a puzzling problem with 2

Re: [web2py] Re: Web2py freezing on live deployment!

2013-11-08 Thread Tim Richardson
> > I had a puzzling problem with 2.7.4 as a rocket service on Windows 2003, > but this was a problem with sqlform.grids. There was a print statement left > in code which caused the service to stop working. This cause doesn't match > with your insights into the problem, but I mention it anyway.

Re: [web2py] Re: Web2py freezing on live deployment!

2013-11-07 Thread Andrew Buchan
Thanks for the suggestions, gevent looks good but I am indeed using pyodbc and this seems to be working with Apache so I'd rather stick with this for time being. (Note I had to embedd the Python27.dll manifest into pyodbc.pyd to get it to work with Apache). The reason for using ajax in the first p

[web2py] Re: Web2py freezing on live deployment!

2013-11-06 Thread Niphlod
hard ? with DAL it's pretty easy if a module exposes the dbapi just force the driver and implement the connect method and it's usually good to go. I'll test it when I get back home. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Re: Web2py freezing on live deployment!

2013-11-06 Thread Derek
It does look like there is a pure python implementation of TDS called pytds, which may actually work... the hard part would be getting web2py to use it... On Wednesday, November 6, 2013 5:15:57 PM UTC-7, Derek wrote: > > Yea, I'm working on a communication layer for pyodbc or pypyodbc which > w

[web2py] Re: Web2py freezing on live deployment!

2013-11-06 Thread Derek
Yea, I'm working on a communication layer for pyodbc or pypyodbc which will handle requests with gevent, thus your application should yield properly, but it's not available just yet, and it won't necessarily be a drop-in replacement for pyodbc though. In the meantime, this is usually good enoug

[web2py] Re: Web2py freezing on live deployment!

2013-11-06 Thread Niphlod
On Thursday, November 7, 2013 12:23:06 AM UTC+1, Derek wrote: > > Ah, if you are on Windows, I would recommend you run it with gevent > instead of rocket, it should be faster than even apache. > > unfortunately it doesn't work as happily as it should: if you're using any non-green module (he's

Re: [web2py] Re: Web2py freezing on live deployment!

2013-11-06 Thread Derek
Yea, the ajax running synchronously - you provide callbacks because they do run asynchronously. To quote the jQuery book: The* first letter in Ajax stands for "asynchronous,"* meaning that the operation occurs in parallel and the order of completion is not guaranteed. The async option to $.aja

Re: [web2py] Re: Web2py freezing on live deployment!

2013-11-06 Thread Ricardo Pedroso
On Tue, Nov 5, 2013 at 11:53 AM, Andrew Buchan wrote: > Ok, the IT guy has disabled McAffee's "on access" scan for the folders > containing web2py stuff as well as python's installation directory. He > tells me that parts of McAffee other than "on access" scan may still > interfere but there's no

[web2py] Re: Web2py freezing on live deployment!

2013-11-06 Thread Derek
I'll also add this: look at anyserver.py for how to get it going... also, gevent does monkey.patch_all which means that all your tcp sockets would become async, which means if you are freezing up because a single connection is frozen, that won't be the case with gevent. Your individual connecti

[web2py] Re: Web2py freezing on live deployment!

2013-11-06 Thread Derek
Ah, if you are on Windows, I would recommend you run it with gevent instead of rocket, it should be faster than even apache. On Monday, November 4, 2013 4:15:56 AM UTC-7, Andrew Buchan wrote: > > Hi, > > I have a serious issue. Got a web2py install running as a service on a > Windows 2003 bo

Re: [web2py] Re: Web2py freezing on live deployment!

2013-11-06 Thread Andrew Buchan
Hi Derek, Thanks for replying, I had checked those but the last entry was months old, so that was a dead end. I finally got web2py running on Apache, though it took me till 5 am :-) (ps: if anyone else plans on attempting to install Apache on Windows against MSSQL, I'm happy to help out or write

[web2py] Re: Web2py freezing on live deployment!

2013-11-06 Thread Derek
Check the logs, find the last line in the log - that's probably what caused the freeze. Check your logging.conf to find out where the logs are kept. On Tuesday, November 5, 2013 1:59:43 PM UTC-7, Andrew Buchan wrote: > > Update: > > I made a copy of the web2py installation on a new server (still

[web2py] Re: Web2py freezing on live deployment!

2013-11-05 Thread Andrew Buchan
Update: I made a copy of the web2py installation on a new server (still pointing to old database) and eventually got it set it up as a service but it still freezes with no errors in web2py or in the event manager... I'm pretty sure it's a programming error on my part somewhere or a migration i

[web2py] Re: Web2py freezing on live deployment!

2013-11-05 Thread Andrew Buchan
Ok, the IT guy has disabled McAffee's "on access" scan for the folders containing web2py stuff as well as python's installation directory. He tells me that parts of McAffee other than "on access" scan may still interfere but there's not much we can do about that. This hasn't made any difference

[web2py] Re: Web2py freezing on live deployment!

2013-11-04 Thread Andrew Buchan
It's running on rocket. I now think it's dying during a specific ajax call, but only some of the time and/or shortly after its called (there's usually a page load after it) and/or when it's excessively busy. Not sure if siege can automate the button clicks that trigger the ajax calls but I might

[web2py] Re: Web2py freezing on live deployment!

2013-11-04 Thread Derek
McAfee always seems to block things incorrectly, at least for me. On Monday, November 4, 2013 8:56:32 AM UTC-7, Andrew Buchan wrote: > > Thanks Willoughby, > > We've got McAffee on that network, so have asked the IT guy to set it to > ignore python and web2py folders. Will let you know what the

[web2py] Re: Web2py freezing on live deployment!

2013-11-04 Thread LightDot
Which version of web2py is it? Are you using gevent or rocket web server? Can you try load testing your devel version and see if you can replicate the issue? You can use something like siege or a similar tool. Regards On Monday, November 4, 2013 4:56:32 PM UTC+1, Andrew Buchan wrote: > > Thank

[web2py] Re: Web2py freezing on live deployment!

2013-11-04 Thread Andrew Buchan
Thanks Willoughby, We've got McAffee on that network, so have asked the IT guy to set it to ignore python and web2py folders. Will let you know what the upshot is once that's in place... Regards, Andy. On Monday, November 4, 2013 1:29:23 PM UTC, Willoughby wrote: > > Are you running Microsoft

[web2py] Re: Web2py freezing on live deployment!

2013-11-04 Thread Willoughby
Are you running Microsoft Endpoint Security? I have problems with the virus scanner 'locking up' things under even light usage. One or two users can bang all day, no problem but get more than 10 and it randomly freezes. Our fix was to exclude pretty much anything Python related. YMMV. On Mo