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.