The issue is that sqlite database is locked every time it is accessed. So if you have a-lot of concurrent requests, some of those will fail due to it being locked by other threads.
The solution is to use a database that does not rely on locking such as postgresql or mysql. -Thadeus On Thu, Mar 4, 2010 at 2:57 PM, vince <lapcc...@gmail.com> wrote: > here's some more errorlog just fyi. > > actually it's easy to reproduce when opening page with lots of image > needs to be download via web2py > > Traceback (most recent call last): > File "/home/web2py/gluon/main.py", line 488, in wsgibase > session._try_store_in_db(request, response) > File "/home/web2py/gluon/globals.py", line 358, in _try_store_in_db > record_id = table.insert(**dd) > File "/home/web2py/gluon/sql.py", line 1879, in insert > self._db._execute(query) > File "/home/web2py/applications/skyyer/models/db.py", line 76, in > <lambda> > db['_execute']=lambda *a,**b: > timer(db,lambda:db._cursor.execute(*a,**b)) > File "/home/web2py/applications/skyyer/models/db.py", line 73, in > timer > f() > File "/home/web2py/applications/skyyer/models/db.py", line 76, in > <lambda> > db['_execute']=lambda *a,**b: > timer(db,lambda:db._cursor.execute(*a,**b)) > OperationalError: database is locked > > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
