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.
