Greetings,
My postgresql server was upgraded from 9.1 to 9.3. Web2py now crashes on
startup with this error code:
Traceback (most recent call last):
File "/home/jose/python-environments/silves/web2py/gluon/restricted.py", line
227, in restricted
exec ccode in environment
File
"/home/jose/python-environments/silves/web2py/applications/silves/models/5_scheduler.py"
<http://localhost:8060/admin/edit/silves/models/5_scheduler.py>, line 24, in
<module>
scheduler = Scheduler(db, heartbeat=5 if RUNNING_LIVE else 20)
File "/home/jose/python-environments/silves/web2py/gluon/scheduler.py", line
587, in __init__
self.define_tables(db, migrate=migrate)
File "/home/jose/python-environments/silves/web2py/gluon/scheduler.py", line
679, in define_tables
migrate=self.__get_migrate('scheduler_worker', migrate)
File
"/home/jose/python-environments/silves/web2py/gluon/packages/dal/pydal/base.py",
line 817, in define_table
table = self.lazy_define_table(tablename,*fields,**args)
File
"/home/jose/python-environments/silves/web2py/gluon/packages/dal/pydal/base.py",
line 856, in lazy_define_table
polymodel=polymodel)
File
"/home/jose/python-environments/silves/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 491, in create_table
fake_migrate=fake_migrate
File
"/home/jose/python-environments/silves/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 604, in migrate_table
self.execute(sub_query)
File
"/home/jose/python-environments/silves/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 1326, in execute
return self.log_execute(*a, **b)
File
"/home/jose/python-environments/silves/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 1320, in log_execute
ret = self.cursor.execute(command, *a[1:], **b)
ProgrammingError: column "worker_stats__tmp" is of type json but expression is
of type text
LINE 1: UPDATE scheduler_worker SET worker_stats__tmp=worker_stats;
^
HINT: You will need to rewrite or cast the expression.
Not sure if this is a scheduler issue or pydal issue. My migrate settings
are explicitly set to False in the model definitions.
web2py version: 2.10.4
Suggestions appreciated.
Jose
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
