Ok that appears to have been the problem. Getting rid of db._common_fields.append(standard_fields) fixed it. Didn't hone in on the exact problem but maybe it's because I had not null on created_by, modified_by fields which defaulted to auth.user_id. Does a scheduled task even have a concept of a logged in user?
On Friday, January 10, 2014 7:07:32 PM UTC-5, User wrote: > > I created a bare bones app and the scheduler seems to work without error. > Not really sure what's happening with the problem app but if I had to guess > I'm thinking it might be related to using > > db._common_fields.append(standard_fields) > > where standard_fields is a table with fields such as date_created, > created_by, modified_by etc. which in turn has defaults like > auth.user_id. Unexpected by me, these got appended to the scheduler > tables. Maybe there is some problematic interaction with this. > > I'm going to try explicitly adding standard_fields to my app tables rather > than using db._common_fields.append to see if that fixes it. > > > On Friday, January 10, 2014 10:53:22 AM UTC-5, User wrote: > >> postgresql. Also my app which uses same database works and I can see the >> tables and the row in scheduler_task table from appadmin >> >> On Friday, January 10, 2014 9:57:25 AM UTC-5, Niphlod wrote: >>> >>> what db are you using ? >>> that error usually pops up when the scheduler can't access the >>> scheduler_* tables. >>> >>> On Friday, January 10, 2014 2:09:26 AM UTC+1, User wrote: >>>> >>>> I'm just getting started with the scheduler and I'm getting an error >>>> when I start it on windows 7: >>>> >>>> C:\www\web2py>python web2py.py -K my_app >>>> web2py Web Framework >>>> Created by Massimo Di Pierro, Copyright 2007-2014 >>>> Version 2.8.2-stable+timestamp.2013.12.09.17.54.55 >>>> Database drivers available: SQLite(sqlite3), MySQL(pymysql), PostgreSQL >>>> (psycopg2 >>>> ), PostgreSQL(pg8000), MSSQL(pyodbc), DB2(pyodbc), Teradata(pyodbc), >>>> Ingres(pyod >>>> bc), IMAP(imaplib) >>>> starting single-scheduler for "my_app"... >>>> ERROR:web2py.scheduler.mycomputer#10144:Error retrieving status >>>> ERROR:web2py.scheduler.mycomputer#10144:Error retrieving status >>>> >>>> >>>> This error just continually repeats until I ctrl-c. >>>> Here is my scheduler.py: >>>> >>>> # coding: utf8 >>>> def doit(): >>>> print 'hello world' >>>> >>>> tasks = dict( >>>> doit=doit, >>>> ) >>>> from gluon.scheduler import Scheduler >>>> scheduler = Scheduler(db, tasks) >>>> >>>> >>>> I created a single row in the scheduler_task table. What is causing >>>> this error? How do I begin to debug this? (Note when browsing my site >>>> there >>>> are no errors). >>>> >>>> -- 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/groups/opt_out.
