Re: [web2py] Scheduler error on last stable web2py version 2.24.1

2023-06-22 Thread Lisandro
I've posted an issue and I've already proposed a small fix and made a pull request :) El miércoles, 21 de junio de 2023 a la(s) 11:25:45 UTC-3, Lisandro escribió: > (sorry, I've deleted my previous message because I have more detailed > information

Re: [web2py] Scheduler error on last stable web2py version 2.24.1

2023-06-21 Thread Lisandro
(sorry, I've deleted my previous message because I have more detailed information). Thank you for pointing that out, I had seen that issue but I missed out that I had to use Scheduler(..., with_spawn=True) so I did that change and, apparently, scheduler is stable (hasn't crashed so far). Howeve

Re: [web2py] Scheduler error on last stable web2py version 2.24.1

2023-06-21 Thread Lisandro
Hey there! Thanks for pointing that out. I had already seen that issue but I missed out that I had to instantiate Scheduler() with use_spawn=True. I've made that change, but now I have this error: Traceback (most recent call last): File "/var/www/medios/gluon/scheduler.py", line 491, in execut

Re: [web2py] Scheduler error on last stable web2py version 2.24.1

2023-06-21 Thread Massimiliano
There was an issue but should be fixed now. https://github.com/web2py/web2py/issues/1999 Il giorno lun 19 giu 2023 alle ore 20:57 Lisandro < rostagnolisan...@gmail.com> ha scritto: > I've recently upgraded to web2py Version > 2.24.1-stable+timestamp.2023.03.23.05.07.17 > It's running on python

[web2py] Scheduler error on last stable web2py version 2.24.1

2023-06-19 Thread Lisandro
I've recently upgraded to web2py Version 2.24.1-stable+timestamp.2023.03.23.05.07.17 It's running on python 3.9.14, Rocky Linux RHEL9, using PostgreSQL 15.2 for database. Since I did the upgrade, the scheduler fails from time to time with this traceback: ERROR:web2py.scheduler.main#1531711:

Re: [web2py] Scheduler stopping for some reason

2022-04-29 Thread Massimiliano
Try to look at the task item in the database. There are some infos like status, last run time, next run time, how many times has been executed etc Il giorno ven 29 apr 2022 alle ore 09:37 António Ramos ha scritto: > Hello i user scheduler and it was working like a charm > this is my code in a mo

[web2py] Scheduler stopping for some reason

2022-04-29 Thread António Ramos
Hello i user scheduler and it was working like a charm this is my code in a module scheduler=current.scheduler scheduler.queue_task(self.callPager, pvars=dict(pager=11, local='')) i see the tasks in db.scheduler_task but they are QUEUED and dont complete. I se

[web2py] Re: Web2py Scheduler, db query is not executing.

2021-10-05 Thread Jim S
Have you tried adding a db.commit() to your delete_after_hours() function? -Jim On Tuesday, October 5, 2021 at 8:49:44 AM UTC-5 Andrew wrote: > Hello, I am trying to run a database query using the web2py scheduler, but > for some reason I can't get the query to commit. I&#x

[web2py] Web2py Scheduler, db query is not executing.

2021-10-05 Thread Andrew
Hello, I am trying to run a database query using the web2py scheduler, but for some reason I can't get the query to commit. I've tested the function in a controller to see that it works, and I'm pretty sure the scheduler is running correctly because I have a scheduler_worker wit

Re: [web2py] Scheduler on Opalstack

2020-11-12 Thread AGRogers
Regarding Scheduler code in, I understand you can put it in any Model file. On Fri, 13 Nov 2020, 5:01 am Gaël Princivalle, wrote: > I can see if I create a new app in Webpy 2.20.4 that the db file have this: > if configuration.get('scheduler.enabled'): > from gluon.scheduler import Scheduler

Re: [web2py] Scheduler on Opalstack

2020-11-12 Thread Gaël Princivalle
I can see if I create a new app in Webpy 2.20.4 that the db file have this: if configuration.get('scheduler.enabled'): from gluon.scheduler import Scheduler scheduler = Scheduler(db, heartbeat=configuration.get('scheduler.heartbeat')) In my db.py file I don't have that, the scheduler is c

Re: [web2py] Scheduler on Opalstack

2020-11-12 Thread Gaël Princivalle
Sure, here is the complete scheduler.py file: My main DB is db, the DB with the scheduler tables is db_sc. # -*- coding: utf-8 -*- def e_db(): today = datetime.datetime.today() file_name = '%s_%s_%s_%s_%s:%s.csv' % (request.application, today.day, today.month, today.year, today.hour, toda

Re: [web2py] Scheduler on Opalstack

2020-11-12 Thread Dave S
On Wednesday, November 11, 2020 at 11:17:21 PM UTC-8, Gaël Princivalle wrote: > > Running it without nohup I can see this error. How can I debug that? > This app was running first on Web2py 2.14.16 and now it runs on the 2.20.4 > version. > > ~/apps/web2py_folder2/env/bin/python ~/apps/web2py_

Re: [web2py] Scheduler on Opalstack

2020-11-11 Thread Gaël Princivalle
Running it without nohup I can see this error. How can I debug that? This app was running first on Web2py 2.14.16 and now it runs on the 2.20.4 version. ~/apps/web2py_folder2/env/bin/python ~/apps/web2py_folder2/web2py/web2py.py -K myapp2 Traceback (most recent call last): File "apps/web2py_fo

Re: [web2py] Scheduler on Opalstack

2020-11-11 Thread Gaël Princivalle
Ok the problem was that the python command must be the one of the env. So this works: nohup ~/apps/web2py_folder1/env/bin/python ~/apps/web2py_folder1/web2py/web2py.py -K myapp1 & However I've another another web2py in another folder with another app and it don't works: nohup ~/apps/web2py_folde

Re: [web2py] Scheduler on Opalstack

2020-11-10 Thread António Ramos
it worked for me. Em ter., 10 de nov. de 2020 às 09:25, Gaël Princivalle < gaelprinciva...@gmail.com> escreveu: > > Hello. > > Did someone tried to use the scheduler on Opalstack? > > I was used to run this command to start a worker in Webfaction but in > Opalstack it don't works: > nohup python

[web2py] Scheduler on Opalstack

2020-11-10 Thread Gaël Princivalle
Hello. Did someone tried to use the scheduler on Opalstack? I was used to run this command to start a worker in Webfaction but in Opalstack it don't works: nohup python web2py.py -K applicationname & I've tried in also in the virtualenv no way. Someone knows how I can do it? Thanks. -- Re

Re: [web2py] scheduler gives and error about datetime

2020-06-23 Thread AGRogers
I haven't done anything in the scheduler yet. It's on my to do list though. I will come back here if I have any good suggestions. On Tue, 23 Jun 2020, 10:22 pm Pierre, wrote: > I advance like you by trying tons of things :) > I did the most simple thing with the task just putting a

Re: [web2py] scheduler gives and error about datetime

2020-06-23 Thread Pierre
I advance like you by trying tons of things :) I did the most simple thing with the task just putting a = datetime.datetime.now() and it gives the exact same error. Tasks doesn't like datetime period :) Not yet figured out how to jsonify the task yet based on your suggest

Re: [web2py] scheduler gives and error about datetime

2020-06-22 Thread AGRogers
Yeah, i dont really understand how web2py sends locals() etc back to the view and how that differs from JSON data. I just keep trying random things until it works :) On Tue, 23 Jun 2020 at 12:15, Pierre wrote: > thanks AG I will look into your suggestion. > Fiddling with the error,

Re: [web2py] scheduler gives and error about datetime

2020-06-22 Thread Pierre
thanks AG I will look into your suggestion. Fiddling with the error, found out that it's when reading back from sqlite that the error arise. It's like something from web2py doesn't like the format of my date in the field of the table. But at this time, i do not know how to tell "web

Re: [web2py] scheduler gives and error about datetime

2020-06-22 Thread AGRogers
Hi I use this code to solve this problem: result = json.dumps(result, indent=4, sort_keys=True, default=str) Don't know what it does but it solves my problem. I found it here: https://stackoverflow.com/questions/11875770/how-to-overcome-datetime-datetime-not-json-serializable On Wed, 17 Jun

[web2py] scheduler gives and error about datetime

2020-06-17 Thread Pierre
Gooday, In the controler the function works correctly. But as a task, it gives an error about Json not beeing able to deal with datetime. any suggestion would be appreciated :) here is the error : TypeError: datetime.datetime(2020, 6, 16, 5, 17, 49) is not JSON serializable here is the code:

[web2py] Scheduler for py4web ?

2019-10-30 Thread António Ramos
Hello, is the web2py scheduler planned for py4web ??? Regards -- 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 message because you are

[web2py] scheduler error

2019-08-17 Thread HY Peng
run web2py with uwsgi and python3.6. Traceback (most recent call last): File "/home/www-data/web2py2000/gluon/restricted.py", line 219, in restricted exec(ccode, environment) File "applications/sai_admin/models/menu.py", line 49, in menus = menu_service.get_menu_config() File "/h

[web2py] Scheduler is Not Running

2019-05-24 Thread Suhas Jadhav
Hi, I have following code def fun1: do something returns locals() I have below code in scheduler.py def hcstar(): LOAD('monitoring',' fun1') from gluon.scheduler import Scheduler scheduler2 = Scheduler(db,tasks=dict(hcstar=hcstar,fun1=func2)) I have scheduled the task to run e

[web2py] Scheduler tasks fail intermitently with no apparent reason (sys.exit(1))

2019-01-15 Thread Niphlod
Timeout?! -- 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 message because you are subscribed to the Google Groups "web2py-users" group.

[web2py] Scheduler tasks fail intermitently with no apparent reason (sys.exit(1))

2019-01-14 Thread Lisandro
I've seeing this for a while now, but I can't figure out why it happens. I have several tasks (around 150) that run once per day (at different hours, maybe some of them run simultaneously). They always run successfully with no problems. However, once every time, one of them fail with this trace

[web2py] Scheduler

2019-01-03 Thread fiubarc
Hello! I have configured the scheduler to start at server restart but it does not take the tasks that already exists in scheduler_task table. Then I have to delete them and reassign them every time I restart the server. These tasks should run once a day, every day Is there a better way to s

[web2py] Scheduler Replacement

2018-11-21 Thread Boris Aramis Aguilar Rodríguez
TL;DR : Do you guys know or has experience with an alternative scheduler to web2py's one that you would recommend? we use features such as scheduling tasks at a specific time, repetitions, timeouts, and check the task current state. Any further comments, advice and experience is really appreciat

[web2py] Re: Multiprocessing and Web2py Scheduler

2018-10-30 Thread Dave S
On Tuesday, October 30, 2018 at 7:41:09 AM UTC-7, Daniel R. wrote: > > Hello, > > I've been working on an application in Web2py for a while now and, for the > most part, I've been able to find answers to my questions online. However, > I am having trouble now trying to figure out if I can use P

[web2py] Multiprocessing and Web2py Scheduler

2018-10-30 Thread Daniel R.
Hello, I've been working on an application in Web2py for a while now and, for the most part, I've been able to find answers to my questions online. However, I am having trouble now trying to figure out if I can use Python multiprocessing along with the Scheduler in Web2py in the way that I need

[web2py] Scheduler task (defined inside a module) won't run new code even after restarting uWSGI

2018-10-12 Thread Lisandro
I'm facing a weird issue: I have a scheduler task that is defined inside a module. At the same time, that function calls another function that is defined in **another** module. I had to make some changes to the last module, so I restarted uWSGI, but the task is still running with the old code :/

[web2py] Scheduler workers die on python 3 + Ubuntu 18.04

2018-08-29 Thread Antonio Salazar
Using python 2 on the same system, the scheduler is rock-solid, but using python 3 the workers die after processing a task. The rest of the tasks are left in queue and the worker entry is deleted from the scheduler_worker table. Aug 28 20:22:03 ubuntu1806 sudo[16121]: Exception in thread Thread

[web2py] scheduler DAL object has no attribute

2018-08-22 Thread Yebach
Hello I have a scheduler running some emailing tasks. After email is sent it should write into table mail_logger. When insert should happen I get an error DAL object has no attribute mail_logger. On my test environment everything is working fine. any suggestions? Thank you -- Resources: -

[web2py] Scheduler migrate=True doesn't recreate tables

2018-07-25 Thread Ur. Kr.
scheduler = Scheduler(db, migrate=True) This doesn't recreate tables for me when I rerun the scheduler and the application. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] scheduler trouble

2018-07-05 Thread Manuele Pesenti
Hi! I'm in a trouble with the web2py (2.14.6 on python 2.7) scheduler that seams stop to run correctly... the tasks get the RUNNING status but nothing is performed and the task stay in the running status forever. I cannot understand how can it be possible. Any idea? Thanks a lot     Manuel

[web2py] Scheduler not creating its tables

2018-07-03 Thread Simona Chovancová
Hello, I am trying to use scheduler for the first time in my app and I cannot get it to work. Tables for scheduler are never really created. This is my model scheduler.py: from gluon.scheduler import Scheduler from gluon import current scheduler = Scheduler( storage.mailer_db, tasks={'send_em

[web2py] Scheduler and far-away tasks

2018-06-10 Thread Joe Barnhart
Are there any reasons I should not schedule tasks days, weeks, or months in advance in the web2py scheduler? It seems such a fantastic, general-purpose tool that I'm using it for more and more things in the site. Currently I'm considering using it to "reveal" embargo&

[web2py] Scheduler error using python3.6 and psycopg2

2018-06-06 Thread Bart
For a new application, i have installed web2py 2.16.1 under python 3.6 and using psycopg2 2.7.4 for postgresql access. Everything is working okay, except the web2py scheduler. After successfull execution of the first task, the scheduler gives an error in the send_heartbeat function. The task

[web2py] Scheduler: Is it possible to assign a task to all workers that are part of a group?

2018-05-04 Thread Francisco Ribeiro
The question refers to submitting a task simultaneously to all workers within a group. Thank you -- 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 rec

[web2py] Re: Web2py scheduler

2018-02-10 Thread Massimo Di Pierro
Please install and use psycopg2. There are known issues with pg8000. On Tuesday, 6 February 2018 08:17:51 UTC-6, Simona Chovancová wrote: > > solved, ran worker in different application than the task was sent from > > On Tuesday, February 6, 2018 at 2:34:24 PM UTC+1, Simona Chovancová wrote: >> >

[web2py] scheduler question

2018-02-06 Thread Andrea Fae'
Hello, days ago I started to use scheduler and all was working very well. I could see db.scheduler_run.task_id lines in the db with all the results and console. Now the scheduler works very well but I don't see nothing in the table db.scheduler_run.task_id. Why? Talk completed without problems.

[web2py] Re: Web2py scheduler

2018-02-06 Thread Simona Chovancová
solved, ran worker in different application than the task was sent from On Tuesday, February 6, 2018 at 2:34:24 PM UTC+1, Simona Chovancová wrote: > > Hello, > > I'm having trouble using the scheduler. I have managed to set it up to > queue tasks and successfully complete them. Although, that onl

[web2py] Web2py scheduler

2018-02-06 Thread Simona Chovancová
Hello, I'm having trouble using the scheduler. I have managed to set it up to queue tasks and successfully complete them. Although, that only works if I do not use database. If I include db in function that is tasked, I get this: Traceback (most recent call last): File "/srv/www/web2py/gluon/

[web2py] Scheduler on PythonAnywhere not working since Dec 1

2017-12-06 Thread Scott Hunter
Since Dec 1, I can no longer schedule tasks in the scheduler for my web2py (Version 2.14.6-stable+timestamp.2016.05.10.00.21.47) app on PythonAnywhere.com; the task log is a LONG permutation of the following 3 lines: ERROR:web2py.scheduler.giles-livetask1#7087:error popping tasks ER

[web2py] Scheduler workers crash on usage of urllib

2017-12-06 Thread Ryan Herbert
Hello, I am currently experiencing an issue with my scheduler workers crashing on startup with the following error: Exception in thread Thread-1: Traceback (most recent call last): File "/usr/lib/python2.7/threading.py", line 801, in __bootstrap_inner self.run() File "/usr/share/vidjil/se

[web2py] scheduler processes synchronization

2017-12-01 Thread Pierre
Hi, well, i already pulled off my hairs so i'm late.. here is the situation: i have 3 sched process that can execute the same task function (diffrerent params) in parallel: task function is like that: def task(params): try: call module.functionA call module.functionB

[web2py] scheduler: force another try, count tries

2017-11-22 Thread Martin Weissenboeck
Two questions: ​(1) Under some conditions (email send not successfully) ​I want to force an other try after some minutes. Would it be a good idea to raise an Exception? (2) Let's say scheduler_task.retry_failed is 5 and we are in the second repetition. How can I get these number = 2? Is there any

[web2py] scheduler can't normal run my script

2017-11-15 Thread yytrying
i write a scripy to get some information and use scheduler to auto ,but scheduler is display FAILED,this is my script def redhat(): bug_num ='' try: try: url = 'https://access.redhat.com/security/vulnerabilities' rea = requests.get(url) rea.enco

[web2py] scheduler speed up task run

2017-08-14 Thread Yebach
Hello I am experiencing some issues with scheduler.py module While running on my local machine (Windows 10, postgres database,..) the scheduler under the following command start relatively quick scheduler = Scheduler(db, tasks = dict(runWoshiEngine = runWoshiEngine,saveIdOut=saveIdOut ) ,heart

[web2py] scheduler worker process looks frozen, stuck in state 'PICK'

2017-07-26 Thread Brendan Fox
So I've noticed that every few days my scheduler task appears to be frozen. New tasks are put into the queue, but are not being processed. When I look at the status of the single worker process in the system the db.scheduler_worker.status = 'PICK'. I don't see this in the web2py docs anywhere.

[web2py] Re: How do I run the web2py scheduler under the models directory

2017-04-24 Thread Dave S
web2py-developers/cI7R-9hex7k/PfTsGodYEwAJ> The pull request has been merged, and should be visible on the web2py website when the next release is out of the gate. /dps > On Monday, April 24, 2017 at 3:36:53 PM UTC-4, Kenneth Ban wrote: >> >> Hi, >> >> I'm try

[web2py] Re: How do I run the web2py scheduler under the models directory

2017-04-24 Thread Anthony
could create a special restricted-access control function and visit its URL just once to schedule the task. Anthony On Monday, April 24, 2017 at 3:36:53 PM UTC-4, Kenneth Ban wrote: > > Hi, > > I'm trying to set up the web2py scheduler to run an hourly task and put &

[web2py] How do I run the web2py scheduler under the models directory

2017-04-24 Thread Kenneth Ban
Hi, I'm trying to set up the web2py scheduler to run an hourly task and put the following code as scheduler.py in the models directory: from gluon.scheduler import Scheduler def log(): logging.warning('is when this event was logged.') import logging logger = lo

[web2py] scheduler error: column "worker_stats__tmp" is of type json

2017-03-21 Thread António Ramos
any ideas ? 2017-03-20 12:54 GMT+00:00 António Ramos : > any help? I´m hosting with webfaction and they moved my app to another > server > column "worker_stats__tmp" is of type > json but expression is of type text LINE 1: UPDATE scheduler_worker SET > worker_stats__tmp=worker_stats; ^ HINT: You

[web2py] scheduler task setting 127.0.0.1 when Host=True

2017-01-31 Thread António Ramos
hello i´m using webfaction hosting for my app. inside my task controller i have this url=sign_url('fileit','events','list',args,vars,host,auth.user_id) i then print the url to check the content and i get url=":http://127.0.0.1:8000/fileit/events/list"; why is 127.0.0.1 instead of the public ip

[web2py] Scheduler queue_task inside a running task

2017-01-29 Thread Filipe Reis
Hey guys, I am trying to start a task from a task and I found this post: https://groups.google.com/forum/?fromgroups#!searchin/web2py/queue$20tasks|sort:relevance/web2py/mpVWhW5QVxw/yufdedADDbYJ However I still have one issue where I get: AttributeError: type object 'datetime.datetime' has no a

[web2py] Scheduler is_ticker and deadlock issues

2017-01-24 Thread Jason Solack
Hello all, I'm having some re-occurring issue with the scheduler. We are currently running multiple environments (production, beta) and have several nodes in each environment. If we have scheduler services running on all machines on each node we get a lot of deadlock errors. If we drop each

[web2py] Web2py scheduler breaks connection tot he server

2017-01-02 Thread Aydin
I cann't get the scheduler run in my ubuntu or debian linux machines. Originally I had db = DAL('sqlite://storage.sqlite') which causes a weird situation where the website becomes unavailable (the browser cannot establish a connection to the server at 127.0.0.1) but when I run the same app with

[web2py] Scheduler in systemd environment (running very long tasks)

2016-12-12 Thread Zbigniew Pomianowski
First of all: I decided to use web2py for my purposes becase it is awesome ;) I believe it is not a web2py's bug or anything like related thing. It can be more OS and systemd related issue. Let me explain what I do and what is the environment. I work in a lab where we try to automate many tests

[web2py] Scheduler task every first day of every month ?

2016-12-09 Thread António Ramos
Hello all, i dont know how to define a task to run every 1st day of every month. Thank you Antonio -- 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 r

Re: [web2py] Scheduler - no workers working...

2016-12-08 Thread António Ramos
IT works now. Thank you... 2016-12-08 12:42 GMT+00:00 Anthony : > Have you scheduled any tasks? It always helps to show your code. > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/w

[web2py] Scheduler - no workers working...

2016-12-08 Thread Anthony
Have you scheduled any tasks? It always helps to show your code. -- 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 message because you are

[web2py] Scheduler - no workers working...

2016-12-08 Thread António Ramos
hello i have a scheduler set up and then in the console i wrote python web2py.py -K myapp no error so far but it does not do anything... db.scheduler_worker is empty and i have it running for 3 days now... Any ideas? regards António -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Scheduler error

2016-11-23 Thread António Ramos
what can be wrong with the code in my scheduler.py ? *montlyreport* is called by a task with the same name I have 2 users in auth_user table I see 2 emails generated in table "emails" then 2 tasks generated in scheduler_task But these 2 tasks fail and no info about what failed... Regards [image: Im

[web2py] scheduler creates "zombie" processes

2016-11-02 Thread Erwn Ltmann
Dear all, I'm astonished about a lot of processes as sub process of scheduler worker are not finished. pstree -p 16731 > > bash(16731)---python2.7(24545)-+-python2.7(24564)---{python2.7}(24565) >|-python2.7(24572)-+-python2.7(1110) >

[web2py] Scheduler - response.render no longer working

2016-10-02 Thread Brian M
OK, so I've had multiple scheduled tasks running for years that use response.render('path/to/template.html', dict(var= 'something')) to help build email bodies and it has been working perfectly. Now when I try to upgrade to the latest web2py trunk (was on 2.13.4 - yeah I'm a bit behind) all tha

[web2py] scheduler processes cooperation issue

2016-09-28 Thread Pierre
Hi , I noticed an unexpected behaviour when running two scheduler processes. The situation is this : A db with a table like : db.define_table('taba', Field('fa', unique=True, requires = IS_NOT_IN_DB(db,'taba.fa')), Field('fb')) a task (same function different args) distributed to

[web2py] Scheduler task runs before it is supposed to run

2016-09-19 Thread Bernardo Leon
Hi, I am trying to run tasks in the future based on a time the user specifies but as soon as the task is queued it is executed, what am I doing wrong? I am using web2py Version 2.14.6-stable+timestamp.2016.05.10.00.21.47 This is my model.db (part of it) db = DAL('sqlite://recomendadorexpertos.

[web2py] scheduler and long tasks

2016-09-17 Thread Niphlod
You can have a task that selects and groups and queues for each group the task that processes the atom. -- 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) --- Y

[web2py] scheduler and long tasks

2016-09-17 Thread Pierre
Hi, right now I have a single task that runs once a day and am wondering if it would be a good idea to split it into "atoms"/ smaller bits soas to take advantage of work division ( use several workers instead of just one). I can't figure out how to do this since all the work to do depends on a

[web2py] scheduler task_id assigned to multiple workers

2016-08-16 Thread Jason Solack
Hello all, i am having a situation where my scheduled jobs are being picked up by multiple workers. My last task was picked up by all 12 workers and is crushing the machines. This is a load balanced machine with 3 machine and 4 workers on each machine. has anyone experienced something like th

[web2py] Re: Web2py scheduler linked postgres processes consuming too much memory

2016-07-29 Thread Abhishek Ram
able memory, if you didn't tinker with the defaults >>> settings of postgresql... >>> >>> On Wednesday, July 27, 2016 at 5:09:34 AM UTC+2, Abhishek Ram wrote: >>>> >>>> Well the memory leak was from the postgres processes spawned by the >

[web2py] Re: Web2py scheduler linked postgres processes consuming too much memory

2016-07-29 Thread Massimo Di Pierro
you using ? it's rather strange that postrgresql acts up >> and eat all the available memory, if you didn't tinker with the defaults >> settings of postgresql... >> >> On Wednesday, July 27, 2016 at 5:09:34 AM UTC+2, Abhishek Ram wrote: >>> >>> Wel

[web2py] Re: Web2py scheduler linked postgres processes consuming too much memory

2016-07-28 Thread Niphlod
ange that postrgresql acts up >> and eat all the available memory, if you didn't tinker with the defaults >> settings of postgresql... >> >> On Wednesday, July 27, 2016 at 5:09:34 AM UTC+2, Abhishek Ram wrote: >>> >>> Well the memory leak was from th

[web2py] Re: Web2py scheduler linked postgres processes consuming too much memory

2016-07-28 Thread Abhishek Ram
f postgresql... > > On Wednesday, July 27, 2016 at 5:09:34 AM UTC+2, Abhishek Ram wrote: >> >> Well the memory leak was from the postgres processes spawned by the >> web2py scheduler process. I am sure about this as I have seen TOP and >> confirmed that it was these proces

[web2py] Re: Web2py scheduler linked postgres processes consuming too much memory

2016-07-28 Thread Niphlod
rom the postgres processes spawned by the web2py > scheduler process. I am sure about this as I have seen TOP and confirmed > that it was these processes that were consuming the memory. I even tried > with a basic app and the postgres processes continued to consume memory. So > finally I

[web2py] Re: start_time in web2py scheduler task seems to be ignored on Windows

2016-07-28 Thread Niphlod
confirmed, I can't reproduce. Which version of web2py are you on ? On Thursday, July 28, 2016 at 3:42:26 PM UTC+2, Niphlod wrote: > > next_run_time should definitely be there, no matter what... let me check. > > On Thursday, July 28, 2016 at 10:52:40 AM UTC+2, schnee wrote: >> >> As a quick fix

[web2py] Re: start_time in web2py scheduler task seems to be ignored on Windows

2016-07-28 Thread Niphlod
next_run_time should definitely be there, no matter what... let me check. On Thursday, July 28, 2016 at 10:52:40 AM UTC+2, schnee wrote: > > As a quick fix I just added the "next_run_time" argument to the queue_task > function and it's working: > > scheduler.queue_task( > test, >

[web2py] Re: start_time in web2py scheduler task seems to be ignored on Windows

2016-07-28 Thread schnee
As a quick fix I just added the "next_run_time" argument to the queue_task function and it's working: scheduler.queue_task( test, pargs=[], pvars={}, start_time = datetime.datetime(2016, 7, 29, 0, 0), next_run_time = datetime.datetime(2016, 7, 29, 0, 0),

[web2py] Re: start_time in web2py scheduler task seems to be ignored on Windows

2016-07-28 Thread cam schn
A simple example: scheduler = Scheduler(db, utc_time=False) def test(): print("test") return True scheduler.queue_task( test, pargs=[], pvars={}, start_time = datetime.datetime(2016, 7, 29, 0, 0), stop_time = None, #datetime time

[web2py] Re: Web2py scheduler linked postgres processes consuming too much memory

2016-07-26 Thread Abhishek Ram
Well the memory leak was from the postgres processes spawned by the web2py scheduler process. I am sure about this as I have seen TOP and confirmed that it was these processes that were consuming the memory. I even tried with a basic app and the postgres processes continued to consume memory

[web2py] Scheduler runs

2016-07-26 Thread Sagar Shah
I have to tasks running by a scheduler. I see custom logs from one and not from the other. All I see from the other one is: 2016-07-25 15:44:07,707 - web2py.app.Sentinel - DEBUG - new task report: COMPLETED 2016-07-25 15:44:07,707 - web2py.app.Sentinel - DEBUG -result: null Also, I do n

[web2py] Re: start_time in web2py scheduler task seems to be ignored on Windows

2016-07-26 Thread Niphlod
I'd say too "lets see the scheduler_run and scheduler_task table" for an example task. the logic behind picking tasks is the same without differences on Win and Linux, and if you use queue_task it's even more likely that there will be no differences between recent and not-so-recent scheduler ve

[web2py] Re: start_time in web2py scheduler task seems to be ignored on Windows

2016-07-25 Thread Dave S
On Monday, July 25, 2016 at 10:50:25 AM UTC-7, cam schn wrote: > > Hello everyone. > > I am trying to schedule a task to run only once at a specific time. I am > using the "start_time" argument in the function queue_task of the scheduler > as below: > > scheduler.queue_task( >

[web2py] start_time in web2py scheduler task seems to be ignored on Windows

2016-07-25 Thread cam schn
Hello everyone. I am trying to schedule a task to run only once at a specific time. I am using the "start_time" argument in the function queue_task of the scheduler as below: scheduler.queue_task( mytask, pargs=[], pvars= dict(a=2, b=3

[web2py] Re: Web2py scheduler linked postgres processes consuming too much memory

2016-07-18 Thread Niphlod
in all distros) you won't ever see postgresql leaking. On Sunday, July 17, 2016 at 5:50:04 AM UTC+2, Abhishek Ram wrote: > > Hi, > > I am using the web2py scheduler to run some background jobs. I am starting > the scheduler using systemd and once started it also spawns t

[web2py] Web2py scheduler linked postgres processes consuming too much memory

2016-07-16 Thread Abhishek Ram
Hi, I am using the web2py scheduler to run some background jobs. I am starting the scheduler using systemd and once started it also spawns two postgres processes as that is my DB. Now the problem is that the postgres processes continue to consume more and more memory even when no process is

[web2py] Re: web2py scheduler service dead - how to prevent it?

2016-05-30 Thread Dave S
On Monday, May 30, 2016 at 3:15:18 AM UTC-7, Mirek Zvolský wrote: > > Please help > > Debian Jessie, postgres, web2py-scheduler > > How can I prevent following crash - inactive scheduler? > Is the real problem that you're using pg8000? I think there's be

[web2py] Re: web2py scheduler service dead - how to prevent it?

2016-05-30 Thread Mirek Zvolský
. Dne pondělí 30. května 2016 12:15:18 UTC+2 Mirek Zvolský napsal(a): > > Please help > > Debian Jessie, postgres, web2py-scheduler > > How can I prevent following crash - inactive scheduler? > Or how can I be sure that the scheduler is running and restart it if > need

[web2py] web2py scheduler service dead - how to prevent it?

2016-05-30 Thread Mirek Zvolský
Please help Debian Jessie, postgres, web2py-scheduler How can I prevent following crash - inactive scheduler? Or how can I be sure that the scheduler is running and restart it if needed? /etc/systemd/system/web2py-scheduler.service - [Unit

[web2py] Scheduler menu empty (on purpose?)

2016-05-26 Thread Scott Hunter
In the latest stable release (2.14.6), the Scheduler menu is empty. When I looked in widget.py, I see this: def update_schedulers(self, start=False): applications_folder = os.path.join(self.options.folder, 'applications') apps = [] ##FIXME - can't start scheduler in

[web2py] scheduler use python modules

2016-05-21 Thread 黄祥
is scheduler can use python modules? e.g. *models/scheduler.py* def task_mail_investor_monthly_report(): title = 'Mutual Funds Investor Monthly Report' rows_investor = db(db.investor.id > 0).select() for row_investor in rows_investor: query_account = (db.account.investor == row_investor.id) rows_ac

[web2py] Scheduler - limit on how large the result can be?

2016-05-12 Thread Andre Kozaczka
This question is in reference to Brad's post a couple years ago: https://groups.google.com/forum/#!searchin/web2py/scheduler$20results/web2py/WM7cyrUV5-U/49JVuq5uL0wJ Is there a limit on how large a "result" from a scheduled task can be? If so, how are folks working around this?

[web2py] Re: web2py scheduler with huge output or return values always timeout (even if the task finishes)

2016-05-12 Thread Niphlod
lks have come up with regarding this issue. > > On Monday, February 29, 2016 at 1:41:41 PM UTC-5, Boris Aramis Aguilar > Rodríguez wrote: >> >> Hi, there is an issue driving me crazy with the web2py scheduler: >> >> If you return something that has a huge size then

[web2py] Re: web2py scheduler with huge output or return values always timeout (even if the task finishes)

2016-05-11 Thread Andre Kozaczka
I'm curious what workarounds folks have come up with regarding this issue. On Monday, February 29, 2016 at 1:41:41 PM UTC-5, Boris Aramis Aguilar Rodríguez wrote: > > Hi, there is an issue driving me crazy with the web2py scheduler: > > If you return something that has a huge

[web2py] Scheduler not finding module

2016-04-13 Thread peter
I have an issue with processes run by the scheduler are not seeing a module. If I Do python2.6 >>>import dropbox it imports fine. The conf file for the web2py scheduler contains DAEMON=python2.6 PARAMETERS="/opt/web-apps/web2py/web2py.py -K new_spin2" LOGFILE=/var/log/w

[web2py] Scheduler always QUEUED in windows

2016-04-02 Thread narges Rezaei
hi i have an application for send sms in certain time . i use pycharm (web2py) for writing this program and web2py scheduler . i can see the records of tasks in db.scheduler_task but no records in scheduler_run and scheduler_worker tables and also the task will execute befor insert in table

[web2py] Re: web2py-scheduler

2016-03-21 Thread Dave S
On Monday, March 21, 2016 at 3:58:25 PM UTC-7, Dave S wrote: > > > > On Monday, March 21, 2016 at 3:31:06 PM UTC-7, phoeb...@gmail.com wrote: >> >> hi >> i want 10 min after click on submit button , my program do a function and >> in that 10min my program do another functions , how can i impleme

  1   2   3   4   >