The strange thing is that it works okay with another app. So what I can I
do about permissions. The permissions for the databases folder are okay. If
I change the permissions on those files the changes are non persistent. So
I am stuck.
On Friday, 29 January 2016 14:58:26 UTC, Niphlod wrote:
>
> file permissions should be the issue because those files are not usual
> ones.
>
> On Friday, January 29, 2016 at 3:45:09 PM UTC+1, peter wrote:
>>
>> I am restating my problem with all that I now know.
>>
>>
>>> I have a version of sqlite3 that is 3.7...
>>>
>>> I have been having problems with the database being locked.
>>>
>>> So I tried
>>> db.executesql("PRAGMA journal_mode=WAL;")
>>>
>>> (just once)
>>>
>>> I then cannot access the application without getting a
>>>
>>> OperationalError: unable to open database file
>>>
>>>
>> If I look in the databases folder, I see that there are two file
>> storage.sqlite-wal and
>> storage.sqlite-shm
>>
>> The first of these has 0 bytes as its size.
>> Both of them have the 'wrong' permissions in that they do not include
>> group write permissions.
>> If I change the permissions of the two files, then reload the page, it
>> works.
>> However I will soon again get the 'unable to open database error', and
>> the persmissions will need resetting.
>>
>> Does anyone have any idea why I am getting these permission issues with
>> the WAL file?
>>
>> I set up a very simple application and WAL worked okay on that, so WAL is
>> possible on my system.
>>
>> If I turn WAL off and go back to DELETE everything works fine, but I am
>> at risk of database locking. so I would prefer to be able to use Write
>> Ahead Logging.
>>
>> Thanks for any help
>> Peter
>>
>>
>>
>>
>>
>
--
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.
