Vince has had this problem in the past, and it was due to the .table files being locked, he solved it by setting migrate=False.
Has he forgotten about this? I just did a quick search on the groups for "lots of images" -Thadeus On Thu, Mar 4, 2010 at 3:23 PM, Jonathan Lundell <[email protected]> wrote: > On Mar 4, 2010, at 1:08 PM, Thadeus Burgess wrote: > >> 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. > > Vince is right, though: there's no reason to crash. The locking is just for > serializing. Something seems wrong; if this were normal, SQLite would be > useless. > >> >> -Thadeus >> >> >> >> >> >> On Thu, Mar 4, 2010 at 2:57 PM, vince <[email protected]> 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 [email protected]. > To unsubscribe from this group, send email to > [email protected]. > 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
