Well, the sceduler starts with an error because im mapping booleans to
tinyint in 01_db.py. But it doesnt fail inserting booleans.
db = DAL("mysql://cnnstring", pool_size = 10, check_reserved=None, migrate=
True)
db._adapter.types['boolean']='TINYINT(1)'
db._adapter.TRUE = 1
db._adapter.FALSE = 0
Scheduler tables booleans are also mapped to tinyint on migration.
This is the scheduler's console:
starting single-scheduler for "myapp"...
/home/myapp/web2py/gluon/packages/dal/pydal/adapters/base.py:1379: Warning:
Incorrect integer value: 'F' for
column 'is_ticker' at row 1
ret = self.get_cursor().execute(command, *a[1:], **b)
/home/myapp/web2py/gluon/packages/dal/pydal/adapters/base.py:1379: Warning:
Incorrect integer value: 'T' for
column 'is_ticker' at row 1
ret = self.get_cursor().execute(command, *a[1:], **b)
Even with that, it works as expected.
After a few days is when it becomes unresponsive. Import data fails
randomly using the same file. If i restart the scheduler it completes the
operation within those ranges 20-30 mins.
If hangs happens i dont have to restart the webapp just kill the scheduler
process and launch it again.
My guess is that pythonanywhere garbage collects the scheduler after some
time. Can't be sure about it.
--
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.
