Hello, Thanks for the reply! So in fact, the issue is the same one the other poster was facing. Do you have any hints on how to use psycopg2 instead? Where would I have to change that? Is there a configuration for that, or would I have to make that change somewhere in the code?
Thanks, Sebastian On Tuesday, October 14, 2014 9:26:07 AM UTC-3, Niphlod wrote: > > the problem comes from pg8000 not supporting the json type. Use psycopg2 > instead. > > On Monday, October 13, 2014 9:56:38 PM UTC+2, Sebastian Echeverria wrote: >> >> Hello, >> >> I am having some trouble starting up web2py's scheduler. I am working on >> a Ubuntu server, using web2py 2.9.9 deployed with nginx, and PostgreSQL. >> Everything works just right, but whenever I try to run the scheduler >> (python web2py.py -K myapp), I get continous "*Error retrieving status*" >> errors. The Scheduler object is being created in a model, and all the >> appropriate scheduler tables have been automatically created, so the issue >> does not seem to be there. >> >> If I modify scheduler.py to get some more info about the error, I see >> that the exception that generates this error message is "NotSupportedError: >> type oid 114 not mapped to py type", thrown from here: >> '..."web2py/gluon/scheduler.py", line 958, in send_heartbeat, >> mybackedstatus = db(sw.worker_name == self.worker_name).select().first()'. >> I found a similar error here ( >> https://groups.google.com/forum/#!topic/web2py/BfSIbUSPk38), but I >> assumed in that case that the bug was on a custom table that person was >> using. Here I am simply trying to start the scheduler with PostgreSQL. I >> hope there is not a bug that prevents using the scheduler with PostgreSQL... >> >> Is there anything that I am missing, or that I am doing wrong? >> >> Thanks in advance, >> >> Sebastian >> > -- 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.
