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 [email protected].
For more options, visit https://groups.google.com/d/optout.
