maybe the fact that you're using sqlite :D If you have a recent sqlite distribution activate the WAL, it can zero out the issues for normal loads (usually also for low loads SQLite ends up locked) Jokes aside, that's why I implemented multiple queries as regroupings in python, to alleviate db pressure on "normal" db and to see if sqlite can cope with it. Where are you seeing this error? If you were on the main page, did you try turning the autorefresh off ? Did you try increasing the cache time ? and setting GROUPING_MODE to python instead of database ?
PS: you did not used this as a model, right ? it queues a new task at every request in that case.... On Friday, March 15, 2013 11:14:46 AM UTC+1, Paolo valleri wrote: > > Hi, > I have in plan to use it in a future project, today a started a very easy > app but I ended up in the error: 'database is locked'. > The tests were done by using sqlite. What is wrong in my app? Please find > attached the example test > The ticket: > > Traceback (most recent call last): > File "/home/pvalleri/src/web2py/gluon/restricted.py", line 212, in > restricted > exec ccode in environment > File "/home/pvalleri/src/web2py/applications/scapp/models/scheduler.py" > <http://127.0.0.1:8000/admin/default/edit/scapp/models/scheduler.py>, line > 31, in <module> > scheduler.queue_task(test_rest, period=10, repeats=0) > File "/home/pvalleri/src/web2py/gluon/scheduler.py", line 959, in queue_task > **kwargs) > File "/home/pvalleri/src/web2py/gluon/dal.py", line 8460, in > validate_and_insert > response.id = self.insert(**new_fields) > File "/home/pvalleri/src/web2py/gluon/dal.py", line 8443, in insert > ret = self._db._adapter.insert(self, self._listify(fields)) > File "/home/pvalleri/src/web2py/gluon/dal.py", line 1201, in insert > raise e > OperationalError: database is locked > > > > Paolo > > On Thursday, February 28, 2013 10:57:40 PM UTC+1, Niphlod wrote: >> >> plugin just got beta status. >> I'd gladly take patches for: >> - a nicer layout ? >> - removing all the javascript in template views and consolidate it in a >> separate js file >> >> As always, testers are more than welcome. > > -- --- 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.
