I checked for the multiple instances of web2py. There are 10 main processes running which should be actually scheduler workers.. i changed those to scheduler workers again with -K option. It seems the app is working fine.
Thank you for your solution.. On Friday, 27 June 2014 12:33:38 UTC+5:30, Massimo Di Pierro wrote: > > Do you have a background process? Do you have multiple web2py's running in > the same instance? > sqlite is not client server and each instance locks the database. If the > database is locked for too long and another process/thread/request tries to > access, it may timeout. > > On Thursday, 26 June 2014 16:29:05 UTC-5, Sandeep Kumar wrote: >> >> Hi, >> I am getting this strange error one in 10 times in my app. The error >> is "<class 'sqlite3.OperationalError'> unable to open database file". I >> am getting this error after i replaced the *databases* folder with one >> from my backup app which is running on a different server. I think the >> plugin_wiki is has some problem. I want to uninstall this plugin_wiki and >> reinstall it but then i fear of losing all the pages that were created >> using plugin_wiki. Can someone help me out on this? >> >> The error traceback is as follows : >> >> Traceback (most recent call last): >> >> File "/backup1/web2py/gluon/restricted.py", line 212, in restricted >> exec ccode in environment >> File "/backup1/web2py/applications/lims/models/plugin_wiki.py" >> <https://metabolomics.iiit.ac.in/admin/edit/lims/models/plugin_wiki.py>, >> line 715, in <module> >> plugin_wiki=PluginWiki() >> File "/backup1/web2py/applications/lims/models/plugin_wiki.py" >> <https://metabolomics.iiit.ac.in/admin/edit/lims/models/plugin_wiki.py>, >> line 534, in __init__ >> code_page = db(db.plugin_wiki_page.slug=='meta-code').select().first() >> File "/backup1/web2py/gluon/dal.py", line 9958, in select >> return adapter.select(self.query,fields,attributes) >> File "/backup1/web2py/gluon/dal.py", line 2245, in select >> return super(SQLiteAdapter, self).select(query, fields, attributes) >> File "/backup1/web2py/gluon/dal.py", line 1704, in select >> return self._select_aux(sql,fields,attributes) >> File "/backup1/web2py/gluon/dal.py", line 1669, in _select_aux >> self.execute(sql) >> File "/backup1/web2py/gluon/dal.py", line 1784, in execute >> return self.log_execute(*a, **b) >> File "/backup1/web2py/gluon/dal.py", line 1778, in log_execute >> ret = self.cursor.execute(command, *a[1:], **b) >> OperationalError: unable to open database file >> >> -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.