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.


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()

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

-- 
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.

Reply via email to