A simple reboot and it unlocked
damned computers
--
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 subsc
uhm. it stays locked no matter what ? sqlite locks the entire db when
writing, so make sure your app is the only one accessing the db...
On Tuesday, November 24, 2015 at 5:54:32 PM UTC+1, Pierre wrote:
>
> Hi everyone,
> I tried to unlock with db.executesql('PRAGMA journal_mode=WAL')
2013/4/7 vince
> from my experience if u running web2py on apache with mod_wsgi u will get
> database locked more often than running web2py alone with it's buildin
> webserver.
web2py + apache + mod_wsgi is my configuration.
ok, I will try the internal webserver.
>
> u should also avoid using
from my experience if u running web2py on apache with mod_wsgi u will get
database locked more often than running web2py alone with it's buildin
webserver.
u should also avoid using session on sqlite database.
On Saturday, April 6, 2013 11:14:16 PM UTC+8, BlueShadow wrote:
>
> I know that I wi
If I would change from SQlite to another system, what do you propose?
2013/4/6 BlueShadow
> [(u'wal',)]thats what the db.executesql("PRAGMA journal_mode") returns. :(
> I guess I have to migrate faster.
>
> --
>
> ---
> You received this message because you are subscribed to the Google Groups
[(u'wal',)]thats what the db.executesql("PRAGMA journal_mode") returns. :(
I guess I have to migrate faster.
--
---
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
this statement
PRAGMA journal_mode
returns the current journal mode. By default should return "delete", while
if the db is in WAL mode, it returns "wal"
On Saturday, April 6, 2013 5:11:16 PM UTC+2, BlueShadow wrote:
>
> How can I test if wal is enabled?
>
> On Saturday, April 6, 2013 3:54:10 P
I know that I will eventually have that problem. thats why I got the plan
to migrate to postgres when I got more time. the problem with postgres
migration is that I used a couple field names which you are not allowed to
use in postgres so I can't simply move the db with me thats quite a bit of
How can I test if wal is enabled?
On Saturday, April 6, 2013 3:54:10 PM UTC+2, Vasile Ermicioi wrote:
>
> and are you sure that wal is enabled?
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop recei
On Saturday, April 6, 2013 3:29:24 PM UTC+2, Vasile Ermicioi wrote:
>
> Don't really know where you saw the 100k user statement
>
> http://www.sqlite.org/whentouse.html
>
Make a simple app (even with "less bloated" frameworks) that writes to a db
every time a user hits a page. I bet I can
so, you're writing to the db for every page every user hits. expect other
lockings, even with SQLite with WAL.
On Saturday, April 6, 2013 3:41:26 PM UTC+2, BlueShadow wrote:
>
> I did check the version: 3.7.9
> So it should be fine.
> I got very little db writes like I said 30 users a day and inc
and are you sure that wal is enabled?
--
---
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://
I did check the version: 3.7.9
So it should be fine.
I got very little db writes like I said 30 users a day and incresing an
integer per page view is about all I do.
On Saturday, April 6, 2013 3:29:24 PM UTC+2, Vasile Ermicioi wrote:
>
> Don't really know where you saw the 100k user statement...
>
> Don't really know where you saw the 100k user statement
http://www.sqlite.org/whentouse.html
for every request you are issuing that query once WAL is active,
> there's no further need to issue that statement
I agree, +1
editing a single table from multiple users ... no.
with WAL en
thanks Niphlod
I have the google app engine still active I guess thats the problem or at
least I hope so.
On Saturday, April 6, 2013 3:19:16 PM UTC+2, Niphlod wrote:
>
> noo
> for every request you are issuing that query once WAL is active,
> there's no further need to issue tha
noo
for every request you are issuing that query once WAL is active,
there's no further need to issue that statement, unless you revert to the
default journal mode or delete phisically the file.
remove also the part of "if request.env.web2py_runtime_gae" if you're not
using it.
when migrate=False it fixed the .table locking problem. but this
database locking issue is just another one, actually it's just a
single user application and i still have this problem.
i think it should be delay instead of return error when the file is
locked. same case apply to .table files altho
Vince has had this problem in the past, and it was due to the .table
files being locked, he solved it by setting migrate=False.
Has he forgotten about this?
I just did a quick search on the groups for "lots of images"
-Thadeus
On Thu, Mar 4, 2010 at 3:23 PM, Jonathan Lundell wrote:
> On Ma
On Mar 4, 2010, at 1:08 PM, Thadeus Burgess wrote:
> The issue is that sqlite database is locked every time it is accessed.
> So if you have a-lot of concurrent requests, some of those will fail
> due to it being locked by other threads.
>
> The solution is to use a database that does not rely on
The issue is that sqlite database is locked every time it is accessed.
So if you have a-lot of concurrent requests, some of those will fail
due to it being locked by other threads.
The solution is to use a database that does not rely on locking such
as postgresql or mysql.
-Thadeus
On Thu, M
here's some more errorlog just fyi.
actually it's easy to reproduce when opening page with lots of image
needs to be download via web2py
Traceback (most recent call last):
File "/home/web2py/gluon/main.py", line 488, in wsgibase
session._try_store_in_db(request, response)
File "/home/web2
21 matches
Mail list logo
