OK,
I have two machines, one with web2py+nginx (machine A) and the other with
postgresql (machine B)
On machine A:
I check migrate = 0
I delete all the scheduler tables
I check that I deleted all the scheduler tables
On machine B:
I delete all the scheduler tables in postgres
On machine A:
I check that there are no scheduler tables.
I reboot it
I check that there are no scheduler tables
I turn on migrate = 1
There are now scheduler tables.
I go to scheduler tables in web2py admin, scheduler_tasks show new tasks
that have since completed,
scheduler_run show new tasks that have completed,
but scheduler_worker has error:
Traceback (most recent call last):
File
"/home/www-data/web2py/applications/temperature/controllers/appadmin.py:select",
line 270, in select
File "/home/www-data/web2py/gluon/packages/dal/pydal/objects.py", line 2045,
in select
return adapter.select(self.query, fields, attributes)
File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", line
746, in select
return self._select_aux(sql, fields, attributes, colnames)
File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", line
727, in _select_aux
return processor(rows, fields, colnames, cacheable=cacheable)
File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", line
305, in parse
for row in rows
File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", line
229, in _parse
value = self.parse_value(value, fit, ft, blob_decode)
File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", line
196, in parse_value
return self.parser.parse(value, field_itype, field_type)
File "/home/www-data/web2py/gluon/packages/dal/pydal/parsers/__init__.py",
line 101, in parse
return self.registered[field_itype](value, field_type)
File "/home/www-data/web2py/gluon/packages/dal/pydal/parsers/__init__.py",
line 76, in __call__
return self.call(value, field_type)
File "/home/www-data/web2py/gluon/packages/dal/pydal/parsers/__init__.py",
line 73, in _call
return self.f(self.parser, value)
File "/home/www-data/web2py/gluon/packages/dal/pydal/parsers/base.py", line
129, in _json
raise RuntimeError('json data not a string')
RuntimeError: json data not a string
On Friday, August 26, 2016 at 4:41:38 PM UTC-7, Ben Lawrence wrote:
>
> Thanks, I must have got the sequence wrong.
>
> On Thursday, August 25, 2016 at 12:05:38 PM UTC-7, Niphlod wrote:
>>
>> if you get any error with __tmp is because you didn't drop tables on the
>> backend AND .table files before hitting the app with migrate=True.
>>
>> On Thursday, August 25, 2016 at 6:53:07 PM UTC+2, Ben Lawrence wrote:
>>>
>>> Hi Niphlod,
>>> I deleted all the scheduler tables , created a new database and then
>>> rebooted with DAL(..migrate=True..) yet still get this error
>>> column "worker_stats__tmp" is of type json but expression is of type
>>> text'
>>>
>>> using postgresql 9.4 on raspberry pi.
>>> In
>>> http://stackoverflow.com/questions/32501027/casting-text-type-column-to-json-type-in-postgresql
>>> there is a mention of recasting. If this is a solution, would you know
>>> how I can incorporate this into web2py?
>>> thanks,
>>> Ben
>>>
>>>
>>> On Wednesday, May 27, 2015 at 12:53:40 PM UTC-7, Niphlod wrote:
>>>>
>>>> Please drop the scheduler_worker table from the database and remove the
>>>> file *_scheduler_worker.table from the databases/ folder of your
>>>> application, then set migrate to True (a single request with migrate=True
>>>> will suffice). The table will be recreated properly and the error will go
>>>> away.
>>>>
>>>> The error comes from the fact that the adapter chooses "at connection
>>>> time" the "nicest" column type to play with based on the backend version.
>>>> The definition of the scheduler_worker table has a "json" Field, that on
>>>> postgresql 9.3 maps to a "json" column, while on 9.1 was a "text" column,
>>>> hence the misbehaviour if you don't drop and re-create the table.
>>>>
>>>>
--
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.
