On Thursday, February 22, 2018 at 4:51:30 PM UTC-8, Fabrizzio Abogadoc
wrote:
>
> I've migrated to a new server (AWS),
> ubuntu/images/hvm-ssd/ubuntu-trusty-14.04-amd64-server-20180201
> (ami-a22323d8),
>
> Last migration was around four months ago, everithing were ok, all the
> configuration server, web2py, and code it's do it by ansible playbooks, so
> there is "not possible some misconfiguration".
>
> Now, task creation inside task ( and task in general) are not working, not
> created, I could issolate the issue to some commit problem with the
> scheduler_task table.
>
> I've created some tests, for debuggin the server, I can insert in all
> tables, but, when it comes scheduler_task table, I cannot commit.
>
>
What DBS are you using?
>
> Definition of Scheduler and Tasks in one Model:
>
> db_scheduler = DAL(path,
>pool_size=20,
>migrate=True,
>fake_migrate=False)
>
> tasks = dict()
> tasks['master_updates_task'] = master_updates_task
> tasks['master_abogadoc_task'] = master_abogadoc_task
>
> scheduler = Scheduler(db_scheduler, tasks=tasks, heartbeat=3)
>
> I have a controller from where I call to Test Insertion
>
> def insert_task():
> from datetime import date, time
> from abogadoc import utilitario
> import random
>
> dia = date.today()
> dia_str = dia.strftime('%Y-%m-%d')
> numero = random.randint(1, 1000)
> abogadoc_task_name = '%s_%s' % (dia_str, str(numero))
>
> start_time = utilitario.santiago_to_utc(hora=8)
> stop_time = utilitario.santiago_to_utc(hora=20)
>
> scheduler.queue_task('agendar_abogadoc',
> task_name=abogadoc_task_name,
> period=cuatro_horas,
> timeout=treinta_min, repeats=0)
> scheduler.queue_task('master_abogadoc_task',
> period=cinco_min,
> timeout=una_hora, repeats=0)
> db_scheduler.commit()
>
That line was what I was going to suggest. queue_task returns an ID,
doesn't it? Do those IDs show up in the table at all?
>
> Also I 've other function to insert in other table one register
>
> Locally, I don have problems, can insert in any table, and scheduler task,
> but in the server, just can commit in any table but no in scheduler_task,
> i've tried, different versions of web2py (2.14, locally and server), also
> using different DBs one for code and other for scheduler, same behaviour
>
> I have the same version of Web2PY,
> Version 2.16.1-stable+timestamp.2017.11.14.05.54.25
> Server:
> Version 2.16.1-stable+timestamp.2017.11.13.23.50.07
>
> Maybe someone can give me any directon, i'm running out of ideas
>
Just to check the obvious, I think you're saying you can queue tasks when
not inside a task.
There may be a table-level lock involved when you're inside a task.
/dps
--
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.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.