task stuck in queue?

[Dave S]

I have a task stuck in the queue.  I've tried manually advancing the start time in scheduler_task, using PICK in scheduler_worker, and waiting an hour or so

(see thread at <URL:https://groups.google.com/d/topic/web2py/i-xJYQkkASU/discussion>)

I haven't yet tried waiting 24 hours.

What can I do?

Here's the task and worker info

sqlite> select * from scheduler_task  where id > 47 ;
48|uploader/default|watch4new|main|QUEUED|watch4new|c96fd870-1d96-4490-bdbc-cd8b8ffcc624|[]|{}|T|2016-02-04 20:00:00|2016-02-05 16:00:00||1|0|86400|F|60|0|0|0||
sqlite> select * from scheduler_worker  where id > 2;
17|ip-172-31-16-18#17914|2016-02-04 20:03:54|2016-02-04 20:07:08|ACTIVE|T||main||{"status": "ACTIVE", "errors": 0, "workers": 1, "queue": 0, "empty_runs": 64, "sleep": 3, "distribution": {"main": {"workers": [{"c": 0, "name": "ip-172-31-16-18#17914"}]}}, "total": 0}
sqlite>

/dps

[Dave S]

On Thursday, February 4, 2016 at 2:19:57 PM UTC-8, Dave S wrote:

I have a task stuck in the queue.  I've tried manually advancing the start time in scheduler_task, using PICK in scheduler_worker, and waiting an hour or so

(see thread at <URL:https://groups.google.com/d/topic/web2py/i-xJYQkkASU/discussion>)

I haven't yet tried waiting 24 hours.

Never mind.  I manually updated next_run_time, and the task fired as desired.