[web2py] Re: Error : unable to open database file

2014-07-02 Thread Sandeep Kumar 
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 " 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" 
>> , 
>> line 715, in 
>> plugin_wiki=PluginWiki()
>>   File "/backup1/web2py/applications/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.

[web2py] Re: Error : unable to open database file

2014-06-27 Thread Massimo Di Pierro 
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 " 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" 
> , line 
> 715, in 
> plugin_wiki=PluginWiki()
>   File "/backup1/web2py/applications/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.