[web2py] Scheduler - Worker node heartbeats stop randomly

2015-11-05 Thread Benson Myrtil
Good morning, I am sure this is a noob question but I cant seem to find a solid answer. I have started a worker nodes using the 'python web2py.py -K [app]' command. Everything appears to work fine for a while. My scheduled task need to run once a day but I am noticing that the worker node rando

[web2py] Detect worker node vs http request

2015-11-06 Thread Benson Myrtil
Is there an easy way to detect if it is a worker making a request vs an http request? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this m

[web2py] MySQL Error 1148 The used command is not allowed with this MySQL version

2015-11-06 Thread Benson Myrtil
I am attempting to run the following within executesql on a MySQL database: LOAD DATA LOCAL INFILE '[path]' INTO TABLE ps_cc CHARACTER SET UTF8 FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (

[web2py] Re: MySQL Error 1148 The used command is not allowed with this MySQL version

2015-11-06 Thread Benson Myrtil
, 2015 at 5:28:17 PM UTC-5, Dave S wrote: > > > > On Friday, November 6, 2015 at 1:31:59 PM UTC-8, Benson Myrtil wrote: >> >> I am attempting to run the following within executesql on a MySQL >> database: >> >> LOAD DATA LO

[web2py] Re: MySQL Error 1148 The used command is not allowed with this MySQL version

2015-11-08 Thread Benson Myrtil
Just wanted to add more information. I run the exact same script on my local development machine (Win 7 x64) and it executes just fine. However when I run it within my production environment (Win Server 2008 x64), i get this error. On Friday, November 6, 2015 at 4:31:59 PM UTC-5, Benson Myrtil

[web2py] Scheduler not reassigning task after restart

2015-11-10 Thread Benson Myrtil
I am running on a windows server 2008. I have nssm setup which manages my 4 worker nodes. The workers appear to be working correctly in the sense that the heartbeat is consistently updating. However, the tasks are stuck in the QUEUE status assigned to old worker nodes that do not exist. Is ther

[web2py] Re: Scheduler not reassigning task after restart

2015-11-11 Thread Benson Myrtil
This problem appeared to fix itself. I woke up this morning and all the task were finally reassigned. Thanks! On Tuesday, November 10, 2015 at 3:33:38 PM UTC-5, Benson Myrtil wrote: > > I am running on a windows server 2008. I have nssm setup which manages my > 4 worker nodes. Th

[web2py] Re: Scheduler not reassigning task after restart

2015-11-11 Thread Benson Myrtil
: what you're experiencing > should last 15 seconds AT THE MOST. > > On Tuesday, November 10, 2015 at 9:33:38 PM UTC+1, Benson Myrtil wrote: >> >> I am running on a windows server 2008. I have nssm setup which manages my >> 4 worker nodes. The workers appear to be w

[web2py] Re: Detect worker node vs http request

2015-11-14 Thread Benson Myrtil
Just noticed I don't believe this code works on PC using nssm. the cmd_options.scheduler is still None On Friday, November 6, 2015 at 2:34:20 PM UTC-5, Anthony wrote: > > On Friday, November 6, 2015 at 2:15:33 PM UTC-5, Benson Myrtil wrote: >> >> Is there an easy way to d

[web2py] Scheduler timing out even though the task completes

2015-11-23 Thread Benson Myrtil
Hey guys I have the scheduler running a task. The task hits an API, downloads data and imports into our database using MySQL LOAD DATA INFILE. There are several API endpoints we hit so I use the same base code to make the request, and pass in a variable that tells the system which endpoint to h

[web2py] Scheduler erroring when threading and trying to do database update.

2015-11-23 Thread Benson Myrtil
I am getting the following error when running a scheduler task with threading: Traceback (most recent call last): File "C:\Users\devteam\Desktop\web_apps\launchpad\production\web2py\gluon\scheduler.py", line 298, in executor functions = current._scheduler.tasks AttributeError: 'thread._

[web2py] Re: Scheduler timing out even though the task completes

2015-11-24 Thread Benson Myrtil
instead of a proper logging, > and limit as much as you can external programs littering your buffer) and > you'll have your "issue" fixed. > > On Monday, November 23, 2015 at 9:50:38 PM UTC+1, Benson Myrtil wrote: >> >> Hey guys >> >> I have the sc

[web2py] Re: Scheduler erroring when threading and trying to do database update.

2015-12-02 Thread Benson Myrtil
will probably work when queued in the > Scheduler. If it doesn't in web2py's shell, start debugging from there > instead of inside the scheduler > > On Monday, November 23, 2015 at 9:54:14 PM UTC+1, Benson Myrtil wrote: >> >> I am getting the following error

[web2py] Type Cast Field On The Fly

2015-10-21 Thread Benson Myrtil
Hey guys, I have a quick question. Does the DAL support type casting on the fly? I am working with a legacy mssql 2008 database that I cannot alter. Within this database it has a field of integers but the field type is string. When I try to run the sum() function on that field I get ((u'42000'