Hi Massimo, thank you for your time.
I had marked this thread as "no action needed" because I found the cause of
the issue.
First I thought it was a different problem, so I opened a new thread in
this forum:
https://groups.google.com/forum/#!topic/web2py/E9jrmf5E-B4
The title of that thread is
That query itself cannot case hanging but maybe when that query is executed
the database is busy with some other background task?
Try setting migrations to false. may be you are doing more database IO than
you should
On Friday, 6 April 2018 09:41:09 UTC-5, Lisandro wrote:
>
> Hi Anthony, again,
Hi Anthony, again, thank you very much for your time, I really appreciate
it.
El jueves, 5 de abril de 2018, 17:52:36 (UTC-3), Anthony escribió:
>
> On Thursday, April 5, 2018 at 2:57:20 PM UTC-4, Lisandro wrote:
>>
>> Thank you Anthony, yes I'm aware of that.
>> I use it like that for this
On Thursday, April 5, 2018 at 2:57:20 PM UTC-4, Lisandro wrote:
>
> Thank you Anthony, yes I'm aware of that.
> I use it like that for this reason: sometimes (not very often) an external
> app modifies a field of the auth_user table (specifically, it sets true or
> false a field that I use as a
Thank you Anthony, yes I'm aware of that.
I use it like that for this reason: sometimes (not very often) an external
app modifies a field of the auth_user table (specifically, it sets true or
false a field that I use as a flag). However that change isn't updated to
auth.user. In order to do so,
On Tuesday, April 3, 2018 at 8:43:31 AM UTC-4, Lisandro wrote:
>
> I store the sessions in the database, so there is no problem with a locked
> file.
>
> I've just found something interesting that could help to figure out: when
> the problem presents, I checked the pg_stat_activity in postgres
I store the sessions in the database, so there is no problem with a locked
file.
I've just found something interesting that could help to figure out: when
the problem presents, I checked the pg_stat_activity in postgres to see if
there was a long running query, and there is indeed. But the
I would use redis for sessions instead of the default file based ones, it
makes the site a lot quicker and it would probably solve your problem as I
would bet this is happening due to a locked session file.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
-
8 matches
Mail list logo
