I have looked into it further, and two new files are created in my
databases directory.
storage.sqlite-wal
and
storage.sqlite-shm
They need their group write permissions to be set. However, they seem to
keep on getting deleted and recreated. Each time they are created their
group write permissions are not being set.
Anyone got any ideas on this.
Thanks for your suggestion Ron, I am not sure it is going to help here.
Peter
On Thursday, 28 January 2016 15:47:54 UTC, peter wrote:
>
> 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
>
>
> Any ideas how I can turn WAL on without this problem?
>
> Things were otherwise working fine prior to trying to turn WAL on.
>
> Thanks
>
>
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
