[web2py] Re: scheduler processes cooperation issue

2016-09-30 Thread Pierre
Chapter 13. Concurrency Control https://www.postgresql.org/docs/9.1/static/mvcc.html -- 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

[web2py] Re: scheduler processes cooperation issue

2016-09-30 Thread Pierre
sorry Dave here's the correct link : https://groups.google.com/d/msg/web2py/Z581Pk3RCYI/qdiy0INcm2oJ -- 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

[web2py] Re: scheduler processes cooperation issue

2016-09-30 Thread Pierre
Dave take a look at this : https://groups.google.com/forum/?fromgroups#!topicsearchin/web2py/race$20condition;context-place=forum/web2py/web2py/Z581Pk3RCYI/web2py/Z581Pk3RCYI/web2py/Z581Pk3RCYI I wasn't aware of the "race condition issue".( concurrent Parallel Threads "collision") . I did some

[web2py] Re: scheduler processes cooperation issue

2016-09-29 Thread Niphlod
ha: yep, the logic is totally flawed. You can't be sure your task has been correctly processed just by queueing it. The task DOESN'T obviously run in the same transaction the webpage displaying the form is. On Thursday, September 29, 2016 at 5:54:20 PM UTC+2, Pierre wrote: > > very confusing

[web2py] Re: scheduler processes cooperation issue

2016-09-29 Thread Dave S
On Thursday, September 29, 2016 at 8:54:20 AM UTC-7, Pierre wrote: > > very confusing situation > problem has been addressed long time ago: > > > https://groups.google.com/forum/?fromgroups#!topicsearchin/web2py/race$20condition;context-place=forum/web2py/web2py/Z581Pk3RCYI/web2py/Z581Pk3RCYI >

[web2py] Re: scheduler processes cooperation issue

2016-09-29 Thread Pierre
very confusing situation problem has been addressed long time ago: https://groups.google.com/forum/?fromgroups#!topicsearchin/web2py/race$20condition;context-place=forum/web2py/web2py/Z581Pk3RCYI/web2py/Z581Pk3RCYI what I observe is that transaction logic doesn't work as expected in the

[web2py] Re: scheduler processes cooperation issue

2016-09-29 Thread Pierre
I am starting the workers/sched processes with this : python web2py.py -a 'password' -K appname,appname and the tasks are queued in a controller function then . Tasks use module functions As far as I understand ret = db.validate_and_insert(fa='something',fb='somethingelse') is not supposed

[web2py] Re: scheduler processes cooperation issue

2016-09-28 Thread Niphlod
the POV of this question is wrong. Scheduler processes do what you ask them to do, without nothing else added. The same thing you observe would happen if you try to execute your tasks manually. It just seems that what you are asking them to do violates your model (i.e. either you had already a

[web2py] Re: scheduler processes cooperation issue

2016-09-28 Thread Dave S
On Wednesday, September 28, 2016 at 3:58:10 AM UTC-7, Pierre wrote: > > Hi , > > > I noticed an unexpected behaviour when running two scheduler processes. > > > The situation is this : > > > A db with a table like : > > > db.define_table('taba', > Field('fa', unique=True, requires =