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.
