from:"niphlod"

[web2py] Re: Web2py dal significantly slower than raw query

2023-10-03 Thread Niphlod

ober 3, 2023 at 8:29:12 AM UTC+2 urban@gmail.com wrote: > > 12 columns, 50k rows (17k rows in the query result) > cacheable=True is about 0.3s faster. > > The costliness of building the whole model comes (mostly) from reference > types? > On Monday, October 2, 2023 at 11:22

[web2py] Re: Web2py dal significantly slower than raw query

2023-10-02 Thread Niphlod

how many rows and how many columns ? the raw one is returning whatever type the underlying database structure has as it is, the pydal one is building the whole model (including references) did you try with cacheable=True in the pydal one ? it won't build update_records and delete_records, for s

[web2py] Re: pyodbc error on windows machine

2023-09-08 Thread Niphlod

just as an off chance thing what's the default language of the user ? never had troubles with english. Also, what's your table model definition and what's the DDL for the underlying table ? On Thursday, September 7, 2023 at 10:49:29 PM UTC+2 jays...@gmail.com wrote: > still hoping for some

Re: [web2py] Re: sessions folder under application

2022-07-07 Thread Niphlod

there's an handy session cleaner web2py/sessions2trash.py at master · web2py/web2py (github.com) and a whole section in the docs web2py - Deployment recipes

Re: [web2py] Re: How to add command line arguments to web2py when it is running as an application pool on IIS?

2021-09-02 Thread Niphlod

e having with internal server error messages. > > Get Outlook for Android <https://aka.ms/AAb9ysg> > -- > *From:* web...@googlegroups.com on behalf of > Niphlod > *Sent:* Wednesday, September 1, 2021 10:35:35 AM > *To:* web2py-users > *Subj

[web2py] Re: How to add command line arguments to web2py when it is running as an application pool on IIS?

2021-09-01 Thread Niphlod

what command line argument, specifically ? On Tuesday, August 31, 2021 at 5:59:31 AM UTC+2 snide...@gmail.com wrote: > On Thursday, August 26, 2021 at 11:30:34 PM UTC-7 david@gmail.com > wrote: > >> Hi web2py folks, >> >> I would like to add a command line argument to the startup of web2py

[web2py] Re: nssm does not work

2019-06-05 Thread Niphlod

what happened may differ from what you thought it should happen which may differ from what needs to happen. said that, nssm just bootstrap the process. the fact that you have a service up&running may already indicate that everything is running smoothly but if you wanna do a check, open the task

[web2py] Scheduler tasks fail intermitently with no apparent reason (sys.exit(1))

2019-01-15 Thread Niphlod

Timeout?! -- 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.

[web2py] Re: Scheduler Replacement

2018-11-23 Thread Niphlod

jokes aside, yeah, you definitely hit scheduler's limits, or, for better saying, limits using a relational database as a queue table. web2py's scheduler can still be optimized, and I feel that 30k tasks are manageable, if they are spread throughout the day (20 tasks a minute if math is not faili

[web2py] Re: Scheduler Replacement

2018-11-22 Thread Niphlod

of > them, and each local scheduler then deals with its own workers only. Not > quite like sharding on Elastisearch, but definitely division of labor. > > If Niphlod was still monitoring the group, that would get you the best > comments on the in-box scheduler. He's th

[web2py] Re: Scheduler: Is it possible to assign a task to all workers that are part of a group?

2018-05-08 Thread Niphlod

hint: if the api doesn't allow it, it's not an envisioned scenario. That being said, there's no limit on the worker-group configuration. As auth relies on RBAC, workers rely on groups. A particular group is able to process a given task ? Queue the task assigning the correct group. Only one work

[web2py] Re: How to force browser to cache css and js ?

2017-06-28 Thread Niphlod

we have a section on the book on static asset management http://web2py.com/books/default/chapter/29/04/the-core#Static-asset-management On Sunday, June 25, 2017 at 10:01:27 PM UTC+2, Ramos wrote: > > I´m using this > https://github.com/mjbeller/web2py-starter > but i noticed that with only me as

[web2py] Re: Suddenly my task scheduler stopped working

2017-06-28 Thread Niphlod

it's normal if the execution timeoutted. On Tuesday, June 27, 2017 at 7:11:12 PM UTC+2, Ramos wrote: > > this is the error i see in task_run table record with status failed > > Traceback (most recent call last): > File "/.../new2py/web2py/gluon/scheduler.py", line 293, in executor > _env = e

[web2py] Re: queue_task :: trouble with quoted json strings for pvars and args

2017-06-08 Thread Niphlod

seems more a problem of the adapter rather than the scheduler itself On Thursday, June 8, 2017 at 5:16:32 AM UTC+2, Richard P wrote: > > I just came across this same issue when using the web2py scheduler for the > first time with an Oracle DB. I spent a good amount of time googling > before fin

[web2py] Re: Should I modify response.headers in order to get nginx's uwsgi_cache work properly?

2017-04-19 Thread Niphlod

It'd be easier to see if it works with a slightly modified directive for uwsgi_cache_valid uwsgi_cache_valid any 1m Because if you miss the 3 parameter notation, only 200 responses are cached. Then you can try returning a proper X-Accel-Expires that should "trump" any other header. uwsg

[web2py] Re: ProgrammingError: column "worker_stats__tmp" is of type json but expression is of type text

2017-03-23 Thread Niphlod

quot;/home/www-data/web2py/gluon/packages/dal/pydal/parsers/__init__.py", line >>> 101, in parse >>> return self.registered[field_itype](value, field_type) >>> File >>> "/home/www-data/web2py/gluon/packages/dal/pydal/parsers/__init__.py", l

[web2py] Re: info: interesting hack, sort in IS_IN_DB lists with regard to current locale

2017-02-12 Thread Niphlod

BTW: setlocale is not threadsafe. -- 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 Group

[web2py] Re: Scheduler is_ticker and deadlock issues

2017-01-30 Thread Niphlod

it really doesn't matter. the IPC is done on the database, so having local workers hitting it or remote ones doesn't turn into more transactions. On Friday, January 27, 2017 at 6:08:56 PM UTC+1, Jason Solack wrote: > > In your scenario do you have 10 workers on multiple machines? So having > 5

[web2py] Re: SystemExit: 1 ticket on scheduler

2017-01-30 Thread Niphlod

or it got a SIGTERM, or it was timing out. On Monday, January 30, 2017 at 10:16:49 PM UTC+1, Anthony wrote: > > Looks like maybe an error somewhere in your model files. Is that the > traceback from the associated record in the scheduler_run table? > > Anthony > > On Monday, January 30, 2017 at 8

[web2py] Re: Scheduler is_ticker and deadlock issues

2017-01-26 Thread Niphlod

n - 6 >>>> records in our worker table and we're getting dealocks. >>>> >>>> >>> Which DB are you using? Can you show your relevant code? >>> >>> /dps >>> >>> >>>> On Wednesday, January 25, 2017 at 3:05:37 AM

[web2py] Re: Scheduler is_ticker and deadlock issues

2017-01-25 Thread Niphlod

you *should* have one different db for each environment. Each scheduler tied to the same db will process incoming tasks, and it doesn't matter what app effectively pushes them. This is good if you want to have a single scheduler (which can be composed by several workers) serving many apps, but *

[web2py] Re: Are executesql parameters escaped?

2017-01-13 Thread Niphlod

when you do that, you're passing 'string'.format() (which is a string) to executesql. the proper way is to use parameters!!! db.executesql('select * from auth_user where id = ?', placeholders=(1, ), as_dict=True) the nitty gritty details of the syntax depend on the driver parameter On Thursda

[web2py] Re: Selecting booleans from sqlite3 database

2017-01-09 Thread Niphlod

did you try dropping the databae and letting web2py recreate it ? sqlite doesn't go well with fields altering their type "afterwards" (i.e. maybe you created it as a string and then turned into a boolean) On Monday, January 9, 2017 at 9:17:19 PM UTC+1, LoveWeb2py wrote: > > Hello, > > > I'm tryi

[web2py] Re: Call functions from other applications without network requests

2017-01-05 Thread Niphlod

never though about just scheduling the functions via the scheduler ? On Thursday, January 5, 2017 at 6:54:59 AM UTC+1, Brendan Barnwell wrote: > > I have a situation where I have (or am going to have) multiple > applications running on a single web2py instance. Each application will do > its ow

[web2py] Re: Simple scheduler issue

2017-01-04 Thread Niphlod

s 2 years ago and I guess > it was more intuitive to feel like python web2py.py -a pass -K myapp will > run both the server and scheduler!!! Sorry everyone for the confusion. > > On Monday, January 2, 2017 at 6:04:57 PM UTC-5, Niphlod wrote: >> >> if you run a single proc

[web2py] Re: Simple scheduler issue

2017-01-02 Thread Niphlod

//vimeo.com/27478796) >>>> and it gets stuck at (starting single-scheduler for myapp...) and the >>>> website does not come up saying browser cannot establish a connection). >>>> Running on ubuntu and debian. >>>> >>> >>> Can you show us you

[web2py] Re: Simple scheduler issue

2017-01-02 Thread Niphlod

scheduler definitely works for mysql. what you experienced is perfectly fine. a scheduler process just sits there if there is nothing to do (i.e. no tasks to process). On Sunday, January 1, 2017 at 5:14:21 PM UTC+1, Aydin wrote: > > I have used the scheduler before without being worried about th

[web2py] Re: Shared worker

2017-01-02 Thread Niphlod

no probl at all. the scheduler happily processes tasks from whatever app is available. it just needs to be defined in one (and , of course, you need to use a unique db for the scheduler throughout your apps) On Thursday, December 29, 2016 at 8:37:59 PM UTC+1, Gael Princivalle wrote: > > Hello. >

[web2py] Re: column must appear in the GROUP BY clause or be used in an aggregate function

2016-12-14 Thread Niphlod

once you group, you can only select the grouped fields and any other field as an aggregate. >From a set-based logic perspective (which is what "serious" database enforce) it has absolutely no meaning asking for entity.id in your case. On Wednesday, December 14, 2016 at 5:44:05 PM UTC+1, Ramos w

[web2py] Re: Authomatic Single sign-on with MS Active Directory

2016-12-14 Thread Niphlod

I took a stab at it but it's incredibly resource-intensive. In fact, I just coded a very complicated routine for single sign-on (kerberos) in an app that does only user authentication and is used as a cas backend by other apps. Restricting the usage to just logging in a few times a day is good:

[web2py] Re: jquery 1.12.2 vulnerability

2016-12-14 Thread Niphlod

you are free to use whatever you may like in your own app. btw, jquery 1.12.2 afaik is not vulnerable, just "old". On Monday, December 12, 2016 at 7:53:29 PM UTC+1, Jacinto Parga wrote: > > > Hi, > > I have recently made a security analisys in a web application deployed > with web2py in Google

[web2py] Re: Scheduler in systemd environment (running very long tasks)

2016-12-14 Thread Niphlod

that piece of code is in place to let the worker being terminated by a sigterm, i.e a ctrl+c, that is useful for development purposes. it *should* have nothing to do with long running tasks, but I'm really honest saying I never had a single task alive for more than an hour. Frankly I don't know

[web2py] Re: Contributing to web2py

2016-12-14 Thread Niphlod

- if you cloned from github without reading the main page I wonder what "documentation" needs to be more explicit. - you can single tests with run python -m unittest gluon.tests.whatever On Monday, December 12, 2016 at 12:20:26 AM UTC+1, Marlysson Silva wrote: > > Guys , good night . > > I

Re: [web2py] Re: Scheduler task every first day of every month ?

2016-12-10 Thread Niphlod

this is an already-solved problem. fetch scheduler.py from the master repo: you can schedule recurrences using the cronline parameter. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/iss

[web2py] Re: build bridging scanner and Active Directory with scanner API (xml)

2016-12-07 Thread Niphlod

it's still absolutely NOT clear what you need to do. "bridge a scanner with LDAP" is quite vague -- 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: Syntax question: db(db.mytable.id == request.post_vars["id"]).update(**{key:value})

2016-12-07 Thread Niphlod

I'd loop collecting the needed updates in a dict and then issue a single update at the end with the **dict On Tuesday, December 6, 2016 at 11:44:56 PM UTC+1, Henk huisman wrote: > > Is this correct syntax? > > if request.post_vars["id"]: >> for key, value in request.post_vars.items(): >>

[web2py] Re: db Field unique=True

2016-12-06 Thread Niphlod

web2py forms use postbacks (the submit is directed to the same address that generated it) so the general flow is the following: - user hits the page - the form was not submitted nor accepted nor errored (goes to the last else) - user fills the forms and click submit - form was submitted: it can

[web2py] Re: build bridging scanner and Active Directory with scanner API (xml)

2016-12-06 Thread Niphlod

why not ? what's your problem ? On Tuesday, December 6, 2016 at 9:32:31 PM UTC+1, 黄祥 wrote: > > is it possible to build bridging scanner and Active Directory with scanner > API (xml) using web2py? > *e.g. xml for Menu to choosing system* > > > > > > Select Job</T</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg157186.html">[web2py] Re: Syntax for placeholders in executesql</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161206&o=newest">2016-12-06</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+Syntax+for+placeholders+in+executesql%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> apparently it's :1, :2, etc etc etc see the end of http://www.oracle.com/technetwork/articles/dsl/prez-python-queries-101587.html On Tuesday, December 6, 2016 at 6:58:01 PM UTC+1, Ty oc wrote: > > By the way, what case would be the xintaxis for oracle as database? > > El martes, 6 de diciembre</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg157185.html">Re: [web2py] Re: switch to python 3</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161206&o=newest">2016-12-06</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+switch+to+python+3%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> as I said, definitely not stable nor released. On Tuesday, December 6, 2016 at 7:34:09 PM UTC+1, Paolo Valleri wrote: > > What about https://gitlab.com/m2crypto/m2crypto/commits/python3 ? > > > On Monday, December 5, 2016 at 9:57:19 PM UTC+1, Niphlod wrote: >> >></span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg157172.html">Re: [web2py] Re: Moving from sqlite to postgresql - operator does not exist: integer = text</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161206&o=newest">2016-12-06</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+Moving+from+sqlite+to+postgresql+%5C-+operator+does+not+exist%5C%3A+integer+%3D+text%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment">us.id==db.events.event) > status.id is integer but db.events.event is a text field that contains > "1" > "2" > "3" > "4" > "sometext" > "anothertext" > "6" > "7" > "8" > > How do i so</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg157157.html">[web2py] Re: admin interface</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161205&o=newest">2016-12-05</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+admin+interface%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> this is far clearer. If you want a single web2py instance to behave like that, you NEED to use routes.py, enabling/disabling routes to the admin app inspecting the hostname it's called in. OR, you can just short-circuit admin adding a model file (name it alphabetically so it gets executed bef</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg157156.html">Re: [web2py] Re: switch to python 3</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161205&o=newest">2016-12-05</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+switch+to+python+3%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment">er 5, 2016 at 1:31:19 AM UTC+1, Jason Solack wrote: > > Does not having m2crypto mean auth is less secure or does it just effect > x509 authentication? > > > On Sunday, November 6, 2016 at 2:15:08 PM UTC-5, Niphlod wrote: >> >> the same gain moving any piece of co</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg157155.html">[web2py] Re: Javascript functions for Canvas not working</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161205&o=newest">2016-12-05</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+Javascript+functions+for+Canvas+not+working%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> it'd be hardly an issue with bootstrap itself given bootstrap "share" among websites On Friday, December 2, 2016 at 9:38:09 PM UTC+1, Dave S wrote: > > > > On Friday, December 2, 2016 at 11:55:33 AM UTC-8, Brian M wrote: >> >> In case others have this sort of a problem where javascript events are</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg157154.html">[web2py] Re: Moving from sqlite to postgresql - operator does not exist: integer = text</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161205&o=newest">2016-12-05</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+Moving+from+sqlite+to+postgresql+%5C-+operator+does+not+exist%5C%3A+integer+%3D+text%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> just check that all your columns where you do == have the same type. sqlite datatype handling is more resilient than standard, meaning that there is no strict type check. dunno how you migrated data from sqlite to postgresql but probably something doesn't match . -- Resources: - http://web2py.</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg157092.html">[web2py] Re: admin interface</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161202&o=newest">2016-12-02</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+admin+interface%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> you open /admin ?! why is that an issue ? BTW: for disabling ATM you can just put a "DISABLED" file in the root folder of the app. On Friday, December 2, 2016 at 11:38:56 AM UTC+1, Annet wrote: > > I have an application with limited functionality in which I want to access > web2py's admin inte</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg157091.html">[web2py] Re: import issues</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161202&o=newest">2016-12-02</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+import+issues%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> simplejson was dropped, as we target 2.7 only and there's the json module globally available. you should use that. I **think** this still works, but it's the only thing permitted. from gluon.contrib.simplejson import json On Friday, December 2, 2016 at 2:37:36 AM UTC+1, Dave S wrote: > > As </span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156987.html">[web2py] Action commit and scheduled task commit racing?</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161127&o=newest">2016-11-27</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Action+commit++and+scheduled+task+commit+racing%5C%3F%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> It absolutely can't happen. But the logic in the code is quite prone to inconveniences: every time a task runs, it only processes the last record of the table...what happens if you have called the webhook function several times before the task has the chance to be executed? You end up having hol</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156988.html">[web2py] Action commit and scheduled task commit racing?</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161127&o=newest">2016-11-27</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Action+commit++and+scheduled+task+commit+racing%5C%3F%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> It absolutely can't happen. But the logic in the code is quite prone to inconveniences: every time a task runs, it only processes the last record of the table...what happens if you have called the webhook function several times before the task has the chance to be executed? You end up having hol</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156986.html">[web2py] Action commit and scheduled task commit racing?</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161127&o=newest">2016-11-27</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Action+commit++and+scheduled+task+commit+racing%5C%3F%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> It absolutely can't happen. But the logic in the code is quite prone to inconveniences: every time a task runs, it only processes the last record of the table...what happens if you have called the webhook function several times before the task has the chance to be executed? You end up having hol</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156916.html">Re: [web2py] Re: Scheduler error</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161123&o=newest">2016-11-23</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+Scheduler+error%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> BTW: you could be facign this issue that was resolved on master https://github.com/web2py/web2py/issues/1485 On Wednesday, November 23, 2016 at 6:58:03 PM UTC+1, Niphlod wrote: > > it's very simple then: if it's failed , the traceback is stored in the > corresponding </span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156915.html">[web2py] Re: 502 Bad Gateway - no tmp/web2py.socket file</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161123&o=newest">2016-11-23</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+502+Bad+Gateway+%5C-+no+tmp%5C%2Fweb2py.socket+file%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment">ournal files were found." > > > On Wednesday, November 23, 2016 at 1:14:00 PM UTC, Niphlod wrote: > >> okay, you can see in the first line that /tmp/web2py.socket is mentioned. >> >> if uwsgi is running, need to check the log to see if any errors comes up >></span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156914.html">Re: [web2py] how to quit ajax LOAD loop</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161123&o=newest">2016-11-23</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+how+to+quit+ajax+LOAD+loop%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> if you add "w2p_component_stop" as a class to the element, the cycle will be interrupted. On Wednesday, November 23, 2016 at 4:50:47 PM UTC+1, Richard wrote: > > Did you try ajax_trap=False > > Or you can redirect by specifying the extension='html' if it does work, so > you can redirect once for</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156913.html">Re: [web2py] Re: Scheduler error</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161123&o=newest">2016-11-23</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+Scheduler+error%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment">alaxy. > > Mensagem original > De: Niphlod > > Data: 23/11/16 13:08 (GMT+00:00) > Para: web2py-users > > Assunto: [web2py] Re: Scheduler error > > when you say "fail" you mean the status of the task itelf is set as FAILED > or that your </span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156907.html">[web2py] Re: 502 Bad Gateway - no tmp/web2py.socket file</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161123&o=newest">2016-11-23</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+502+Bad+Gateway+%5C-+no+tmp%5C%2Fweb2py.socket+file%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment">d 1044 0.0 0.1 4276 1824 pts/0S+ 10:54 0:00 grep > --color=auto uwsgi > > > > On Wednesday, November 23, 2016 at 11:54:21 AM UTC, Niphlod wrote: > >> ok, let's break it down. >> The script basically does: >> - install and configure nginx </span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156906.html">[web2py] Re: Scheduler error</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161123&o=newest">2016-11-23</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+Scheduler+error%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> when you say "fail" you mean the status of the task itelf is set as FAILED or that your db.emails.status is 'failed' ? On Wednesday, November 23, 2016 at 1:13:10 PM UTC+1, Ramos wrote: > > web2py 2.14.3 > > 2016-11-23 12:07 GMT+00:00 António Ramos > >: > >> i think the problem is in response.ren</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156905.html">[web2py] Re: Processing taking a long time in web2py?</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161123&o=newest">2016-11-23</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+Processing+taking+a+long+time+in+web2py%5C%3F%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment">> least find out where the time is being spent. Web2py adding ~20 seconds is > quite a lot of time. > In the future I will be using a library, but for now I have to use this > external process. > > > On Sunday, 20 November 2016 20:47:33 UTC, Niphlod wrote: >> >> hi</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156900.html">[web2py] Re: 502 Bad Gateway - no tmp/web2py.socket file</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161123&o=newest">2016-11-23</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+502+Bad+Gateway+%5C-+no+tmp%5C%2Fweb2py.socket+file%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> ok, let's break it down. The script basically does: - install and configure nginx - install and configure uwsgi uwsgi is the process that takes care of executing any python code (meaning, your webapp) . nginx is the process that takes care of receiving an http request, passing it down to uwsgi, </span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156895.html">[web2py] Re: How to create RSS feed from internal table?</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161123&o=newest">2016-11-23</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+How+to+create+RSS+feed+from+internal+table%5C%3F%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> see https://github.com/web2py/web2py/blob/master/applications/welcome/views/generic.rss On Wednesday, November 23, 2016 at 8:20:20 AM UTC+1, Alex Glaros wrote: > > I have a web2py table, db.meeting, whose records are to be consumed by > outside parties as an RSS feed. > > In other words, people </span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156894.html">[web2py] Re: 502 Bad Gateway - no tmp/web2py.socket file</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161123&o=newest">2016-11-23</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+502+Bad+Gateway+%5C-+no+tmp%5C%2Fweb2py.socket+file%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment">t > something that should have happened or something I should have done, and > how do I resolve it? I used the 'one step deployment' script as thought it > would do everything I need to get Web2py working. > > Richard > > On Tuesday, November 22, 2016 at 7:19:25 PM</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156887.html">[web2py] Re: 502 Bad Gateway - no tmp/web2py.socket file</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161122&o=newest">2016-11-22</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+502+Bad+Gateway+%5C-+no+tmp%5C%2Fweb2py.socket+file%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> that should be generated by the uwsgi daemon On Tuesday, November 22, 2016 at 6:34:40 PM UTC+1, Richard Brown wrote: > > I've just tried to do a new install of Web2py on a Raspberry Pi 3 having > been using it under Apache on a Model B for a few years now. I used the > script "setup-web2py-nginx</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156886.html">[web2py] Re: why DAL decode_credentials=True can't work for task scheduler worker?</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161122&o=newest">2016-11-22</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+why+DAL+decode_credentials%3DTrue++can%27t+work+for+task+scheduler+worker%5C%3F%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> scheduler just accepts a DAL connection as a parameter. There's no way that db connection can work for the web process and not the scheduler one. On Monday, November 21, 2016 at 4:42:55 PM UTC+1, DengFeng Mao wrote: > > I am using web2py Version 2.14.3-stable+timestamp.2016.03.26.23.02.02 with </span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156885.html">[web2py] Re: what is in the cache ?</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161122&o=newest">2016-11-22</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+what+is+in+the+cache+%5C%3F%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> in redis terms (which will set an expire timing accordingly) doesn't make much sense. In the default implementation, which never expires anything, time_expire=0 basically means "update that key". On Monday, November 21, 2016 at 4:30:07 PM UTC+1, Pierre wrote: > > I understand use-cases for ></span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156821.html">[web2py] Re: what is in the cache ?</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161120&o=newest">2016-11-20</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+what+is+in+the+cache+%5C%3F%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> goes to redis, obviously! and redis usually stores it into ram (although it usually saves a copy to the disk, which is configurable, but just to not make it totally volatile between restarts of redis) On Friday, November 18, 2016 at 12:21:05 PM UTC+1, Pierre wrote: > > Yes I improved my understa</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156820.html">[web2py] Re: Processing taking a long time in web2py?</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161120&o=newest">2016-11-20</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+Processing+taking+a+long+time+in+web2py%5C%3F%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment">> > On Thursday, 17 November 2016 22:53:50 UTC, Niphlod wrote: >> >> well... you're asking why opening a process in python rather than doing >> it directly takes more time. no wonders there: of course it takes more >> time! Especially if your process writes lots</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156775.html">[web2py] Re: Processing taking a long time in web2py?</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161117&o=newest">2016-11-17</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+Processing+taking+a+long+time+in+web2py%5C%3F%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> well... you're asking why opening a process in python rather than doing it directly takes more time. no wonders there: of course it takes more time! Especially if your process writes lots to stdout/stderr that python needs to collect. BTW: never ever ever run ANY external process from the webse</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156774.html">[web2py] Re: Script timed out before returning headers for apache server when scheduler task is running</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161117&o=newest">2016-11-17</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+Script+timed+out+before+returning+headers+for+apache+server+when+scheduler+task+is+running%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> are you running sqlite ? if so, AT LEAST run the scheduler on a different sqlite database, as sqlite doesn't really withstand lots of concurrent writes (that the scheduler does). if your web app shares the same sqlite db as the scheduler, it gets blocked whenever the scheduler writes something </span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156773.html">[web2py] Re: what is in the cache ?</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161117&o=newest">2016-11-17</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+what+is+in+the+cache+%5C%3F%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> read CAREFULLY http://web2py.com/books/default/chapter/29/04/the-core#cache . Unfortunately (?) web2py's cache isn't "the usual" cache object, as it's designed to store indefinitely values that do not expire automatically. Basically time_expire vouches to either fetch the stored value or to upd</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156772.html">[web2py] Re: web2py as Grafana endpoint</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161117&o=newest">2016-11-17</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+web2py+as+Grafana+endpoint%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> if the request comes in either as a POST or as a PUT it has a body (since all examples report a faily nested query structure, I'd say it's the case vs a simple querystring in a GET) If the body carries the correct content-encoding, it's automatically parsed into request.vars. You can still read</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156771.html">[web2py] Re: Starting scheduler worker from controller</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161117&o=newest">2016-11-17</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+Starting+scheduler+worker+from+controller%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> I'll say it once again: you need a scheduler to run out-of-band pieces of things (tasks) that ARE NOT embedded in the web-serving process(es). At that point you may as well process out-of-band tasks with a simple ajax call, and save yourself setting up the scheduler at all. It's strongly discour</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156669.html">Re: [web2py] Re: auth_hasmembership(["admin","supervisor","auditor"]) ?</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161111&o=newest">2016-11-11</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+auth_hasmembership%5C%28%5C%5B%5C%22admin%5C%22%2C%5C%22supervisor%5C%22%2C%5C%22auditor%5C%22%5C%5D%5C%29+%5C%3F%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> and yes, using a lambda makes that piece of code execute only when that decorated function is called rather than every time the controller is hit. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156668.html">Re: [web2py] Re: auth_hasmembership(["admin","supervisor","auditor"]) ?</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161111&o=newest">2016-11-11</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+auth_hasmembership%5C%28%5C%5B%5C%22admin%5C%22%2C%5C%22supervisor%5C%22%2C%5C%22auditor%5C%22%5C%5D%5C%29+%5C%3F%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment">Simone, > > I don't understand why you say you cached groups, from what you showed you > only prevent accessing db until the very end with the lambda no? > > Richard > > On Fri, Nov 11, 2016 at 8:16 AM, Niphlod > > wrote: > >> any and all are definitely py</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156660.html">[web2py] Re: auth_hasmembership(["admin","supervisor","auditor"]) ?</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161111&o=newest">2016-11-11</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+auth_hasmembership%5C%28%5C%5B%5C%22admin%5C%22%2C%5C%22supervisor%5C%22%2C%5C%22auditor%5C%22%5C%5D%5C%29+%5C%3F%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> any and all are definitely python syntax. I do this using the cached groups, so I don't reach the db for every check ALLOWED = set(('admin', 'contributor')) @auth.requires(lambda: auth.user_id and ALLOWED & set(auth.user_groups. values())) On Friday, November 11, 2016 at 1:55:25 PM UTC+1, 黄祥 </span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156652.html">[web2py] Re: Invalid field name although rname is set</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161111&o=newest">2016-11-11</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+Invalid+field+name+although+rname+is+set%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> update() is a methodyou can't use a model that has a field that is named "update". It's true that you're using rname, but the problem is that you need to choose a less "funny" name for the field name, not the rname. On Friday, November 11, 2016 at 7:40:32 AM UTC+1, Edwin Haver wrote</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156612.html">[web2py] Re: strange behavior of $@ bash parameter expansion</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161108&o=newest">2016-11-08</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+strange+behavior+of+%24%40+bash+parameter+expansion%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> the error you've seen has nothing to do with either $@ or "$@". it just signalled that you had a migration error. once you deleted both metadata and the underlying tables, everything was fixed. On Monday, November 7, 2016 at 6:28:22 PM UTC+1, Mirek Zvolský wrote: > > I use Debian (testing), Post</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156592.html">[web2py] Re: scheduler creates "zombie" processes</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161106&o=newest">2016-11-06</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+scheduler+creates+%5C%22zombie%5C%22+processes%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> 4, 2016 at 11:50:14 PM UTC+1, Erwn Ltmann wrote: > > On Friday, November 4, 2016 at 10:44:31 PM UTC+1, Niphlod wrote: >> >> BTW: do your task write a lot on stdout/stderr and/or return huge results >> ? >> > > Probably. I wrote into the log more than usual</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156590.html">[web2py] Re: Making two queries into one</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161106&o=newest">2016-11-06</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+Making+two+queries+into+one%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> it seems that on the whole set there's something missing 1st query indiban anos empresas *indicadores* 2nd query eleban anos empresas *elementos* moreover, in your "DAL syntax", only the references to those external tables are taken. The real missing link that could get you the answer is how to</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156589.html">Re: [web2py] Re: switch to python 3</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161106&o=newest">2016-11-06</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+switch+to+python+3%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> the same gain moving any piece of code from python 2 to python 3 (read on the interwebs, there are a few). at least now you can choose and have web2py not standing in the way. On Sunday, November 6, 2016 at 12:34:39 AM UTC+1, Ramos wrote: > > what is the gain moving to python 3? > > 2016-11-05 17</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156568.html">[web2py] Re: scheduler creates "zombie" processes</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161104&o=newest">2016-11-04</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+scheduler+creates+%5C%22zombie%5C%22+processes%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> BTW: do your task write a lot on stdout/stderr and/or return huge results ? On Friday, November 4, 2016 at 10:43:34 PM UTC+1, Niphlod wrote: > > well, on unix python docs report that p.terminate() use sigkill, so I > wonder why in your env one works and not the other... > > On Fri</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156567.html">[web2py] Re: scheduler creates "zombie" processes</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161104&o=newest">2016-11-04</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+scheduler+creates+%5C%22zombie%5C%22+processes%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> well, on unix python docs report that p.terminate() use sigkill, so I wonder why in your env one works and not the other... On Friday, November 4, 2016 at 8:57:34 AM UTC+1, Erwn Ltmann wrote: > > BTW: if I use os.kill(p.pid,signal.SIGKILL) instead of p.termiate() > everithing is fine. > > 11-04 </span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156545.html">[web2py] Re: scheduler creates "zombie" processes</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161103&o=newest">2016-11-03</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+scheduler+creates+%5C%22zombie%5C%22+processes%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> Got that. Thanks for explaining your POV. What I was trying to say is that without being able to reproduce, I can only guess. And since the scheduler code in regards of process handling is quite streamlined, there are not a lot of places where a zombie can be created. So, let's guess... Are zom</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156543.html">Re: [web2py] Re: web2py for windows server. IIS or Nginx?</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161103&o=newest">2016-11-03</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+web2py+for+windows+server.+IIS+or+Nginx%5C%3F%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment">tCGI and wonder if > this is a better deployment option? Are you aware of any advantages of one > over the other? > > On Wednesday, November 2, 2016 at 5:55:36 PM UTC-4, Niphlod wrote: >> >> it's from some time ago but should work without issues. I think some >> </span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156540.html">Re: [web2py] .git file in gluon/packages/dal/.git</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161103&o=newest">2016-11-03</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+.git+file+in+gluon%5C%2Fpackages%5C%2Fdal%5C%2F.git%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> ok, now it's clear. probably a packaging error on mdipierro's side. On Thursday, November 3, 2016 at 2:48:45 PM UTC+1, Giles Thomas wrote: > > @Niphlod -- the confusing thing for me is that the .git file is present in > the source download from the web2py website. It makes</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156523.html">Re: [web2py] Re: web2py for windows server. IIS or Nginx?</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161102&o=newest">2016-11-02</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+web2py+for+windows+server.+IIS+or+Nginx%5C%3F%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment">3/deployment-recipes?search=iis#IIS > > On Wednesday, November 2, 2016 at 3:43:37 AM UTC-5, Niphlod wrote: >> >> *nix --> nginx with uwsgi >> windows --> iis with fastcgi >> >> >> BTW: iis is perfectly fine running production envs. And it's NOT </span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156522.html">[web2py] Re: scheduler creates "zombie" processes</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161102&o=newest">2016-11-02</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+scheduler+creates+%5C%22zombie%5C%22+processes%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment">er spawns a single process with a queue 1 element long to communicate over ... that process handles a single task, and then dies. Everything is thrashed and recreated at the next task pick-up. On Wednesday, November 2, 2016 at 5:47:42 PM UTC+1, Erwn Ltmann wrote: > > Hi Niphlod, > > </span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156521.html">[web2py] Re: How to start a scheduler task from a module?</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161102&o=newest">2016-11-02</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+How+to+start+a+scheduler+task+from+a+module%5C%3F%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> tl;dr : it just gets automatically filled with "request.application/request.controller" in a web environment that it is missing in your module. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156520.html">[web2py] Re: How to start a scheduler task from a module?</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161102&o=newest">2016-11-02</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+How+to+start+a+scheduler+task+from+a+module%5C%3F%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment">task("mytask") > > > Now the return value of queue_task is > rtn == {'errors': {'application_name': 'Enter a value'}, 'id': None, > 'uuid': None} > > How can I provide an application_name ? > > 2016-11-02 11:58 G</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156512.html">[web2py] Re: DEADLOCKs between two or more scheduler worker</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161102&o=newest">2016-11-02</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+DEADLOCKs+between+two+or+more+scheduler+worker%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment">ntime rate of 1 for 2. > > Anyway, if I run the worker with my suggested extra condition I could > eliminate the deadlock cases. This works very well because the extra > condition. I am happy :) > > Thx a lot. > Erwn > > On Monday, October 31, 2016 at 3:02:42 PM UTC+1, Nip</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156511.html">Re: [web2py] .git file in gluon/packages/dal/.git</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161102&o=newest">2016-11-02</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+.git+file+in+gluon%5C%2Fpackages%5C%2Fdal%5C%2F.git%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> uhm ... what ? On Tuesday, November 1, 2016 at 7:10:16 PM UTC+1, Richard wrote: > > I agree with you Simone, but should it stay there in the build for pydal > only? > > Richard > > On Tue, Nov 1, 2016 at 1:45 PM, Niphlod > > wrote: > >> it's perfectly </span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156510.html">[web2py] Re: scheduler creates "zombie" processes</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161102&o=newest">2016-11-02</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+scheduler+creates+%5C%22zombie%5C%22+processes%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> I'd say there are a LOT of strange things going on on your system, since you're reporting several different issues that nobody ever faced and all in the last week. zombie processes shouldn't be there unless you killed improperly a worker process. Python can't really do anything about it, and t</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156509.html">[web2py] Re: How to start a scheduler task from a module?</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161102&o=newest">2016-11-02</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+How+to+start+a+scheduler+task+from+a+module%5C%3F%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> if the scheduler is already defined in the db, just use Scheduler(the_uri. migrate=False) . there shouldn't be issues with queuing tasks . On Wednesday, November 2, 2016 at 11:17:00 AM UTC+1, mweissen wrote: > > Thank you, but it did not work, because the module program does not use > the models</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156504.html">Re: [web2py] Re: web2py for windows server. IIS or Nginx?</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161102&o=newest">2016-11-02</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+web2py+for+windows+server.+IIS+or+Nginx%5C%3F%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment">Chiba wrote: >>>>> >>>>> Thank you. I thought the Massimo's comment below and he also >>>>> mentioned somewhere we don't want to support Apache anymore... that's why >>>>> I >>>>> was nervous. I was thinking to </span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156488.html">Re: [web2py] .git file in gluon/packages/dal/.git</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161101&o=newest">2016-11-01</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+.git+file+in+gluon%5C%2Fpackages%5C%2Fdal%5C%2F.git%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> it's perfectly normal as pydal is a subrepo (it's in the readme, too) On Tuesday, November 1, 2016 at 5:43:44 PM UTC+1, Giles Thomas wrote: > > Thanks, Richard. > > Regarding why -- I'm talking about the version that will be installed by > default when someone creates a web2py app on the hostin</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156468.html">[web2py] Re: how to keep mysql connection alive during scheduler task running</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161031&o=newest">2016-10-31</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+how+to+keep+mysql+connection+alive+during+scheduler+task+running%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> there's nothing web2py can do if the database drops the connection without signalling it. If your diagnosis is correct, however, you can circumvent the issue using sync_output < 4 min, just to keep the connection alive. On Sunday, October 30, 2016 at 3:32:02 AM UTC+1, Saint Havy wrote: > > Hi, </span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156467.html">[web2py] Re: DEADLOCKs between two or more scheduler worker</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161031&o=newest">2016-10-31</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+DEADLOCKs+between+two+or+more+scheduler+worker%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment">te: > > Hi, > > thank you for your reply. > > @Pierre: MariaDB (in my case) handled deadlocks automaticly too. Good to > known, I don't have to be worry about that. > > @Niphlod: I tried to beef up my database host. No effects. Another > suggestion is to prevent</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156447.html">[web2py] Re: question about scheduler</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161028&o=newest">2016-10-28</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+question+about+scheduler%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> 4. whatever you want, just avoid having large stdout (it's a general issue in python that can't be easily fixed). one thing is avoiding db pressure on the database... that means avoiding tenths of workers with thousands of tasks . Another is queuing a single task per hour. 5. that's perfectly n</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156441.html">[web2py] Re: DEADLOCKs between two or more scheduler worker</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161027&o=newest">2016-10-27</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+DEADLOCKs+between+two+or+more+scheduler+worker%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> the only thing you can do is either beefing up the database instance (less deadlocks because of faster execution of queries) or lower the db pressure (lower number of workers, higher heartbeat). -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2p</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156440.html">[web2py] Re: tasks hierarchy</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161027&o=newest">2016-10-27</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+tasks+hierarchy%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> hum...how can cat3 be queued if cat3 depends on cat2 being executed ? Or what you wanted to know is how to give a higher priority to cat1 tasks instead of cat2 tasks (i.e. they are not related, it's just that you prefer cat2 remaining in the queue a bit longer if there are cat1 tasks)? In that </span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156439.html">[web2py] Re: tasks hierarchy</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161027&o=newest">2016-10-27</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+tasks+hierarchy%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> BTW: "error coordinating ticker" happening seldomly is not a big issue: for that round no workers were eligible to be tickers (i.e. dispatchers) but the next round will elect one. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Sou</span> </blockquote><br> <h3><span class=subject><a href="/web2py@googlegroups.com/msg156438.html">[web2py] Re: question about scheduler</a></span></h3> <div class="darkgray font13"> <span class="sender pipe"> <span class=date><a href="/search?l=web2py%40googlegroups.com&q=date:20161027&o=newest">2016-10-27</a></span></span> <span class="sender pipe"> <span class=thead><a href="/search?l=web2py%40googlegroups.com&q=subject:%22%5C%5Bweb2py%5C%5D+Re%5C%3A+question+about+scheduler%22&o=newest">Thread</a></span></span> <span class=name><a href="/search?l=web2py%40googlegroups.com&q=from:%22Niphlod%22&o=newest"><B>Niphlod</B></a></span> </div> <blockquote><span class="msgFragment"> 1. they get deleted because in the test app the controller showing all the details just grabs every record in all tables. You don't need (nor want) to clear everything every time you queue something...else it won't be a queue :P 2. the deal is should the first task run alongside the second or th</span> </blockquote><br> <h2> 1 <a href="/search?l=web2py%40googlegroups.com&q=from%3A%22niphlod%22&o=newest&start=100">2</a> <a href="/search?l=web2py%40googlegroups.com&q=from%3A%22niphlod%22&o=newest&start=200">3</a> <a href="/search?l=web2py%40googlegroups.com&q=from%3A%22niphlod%22&o=newest&start=300">4</a> <a href="/search?l=web2py%40googlegroups.com&q=from%3A%22niphlod%22&o=newest&start=400">5</a> <a href="/search?l=web2py%40googlegroups.com&q=from%3A%22niphlod%22&o=newest&start=500">6</a> <a href="/search?l=web2py%40googlegroups.com&q=from%3A%22niphlod%22&o=newest&start=600">7</a> <a href="/search?l=web2py%40googlegroups.com&q=from%3A%22niphlod%22&o=newest&start=700">8</a> <a href="/search?l=web2py%40googlegroups.com&q=from%3A%22niphlod%22&o=newest&start=800">9</a> <a href="/search?l=web2py%40googlegroups.com&q=from%3A%22niphlod%22&o=newest&start=900">10</a> <a href="/search?l=web2py%40googlegroups.com&q=from%3A%22niphlod%22&o=newest&start=100" accesskey="n"> > </a> </h2> </div> <div class="aside" role="complementary"> <div class="logo"> <a href="/"><img src="/logo.png" width=247 height=88 alt="The Mail Archive"></a> </div> <h2> 1 - 100 of 5054 matches</h2> <br> <ul><li><a href="/search?l=web2py%40googlegroups.com&q=from%3A%22niphlod%22&a=1&o=newest">Advanced search</a></li></ul> <form class="overflow" action="/search" method="get"> <input type="hidden" name="l" value="web2py@googlegroups.com"> <label class="hidden" for="q">Search the list</label> <input class="submittext" type="text" id="q" name="q" placeholder="Search web2py" value="from:"niphlod""> <input class="submitbutton" id="submit" type="image" src="/submit.png" alt="Submit"> </form> <div class="nav margintop" id="nav" role="navigation"> <h2 class="hidden"> Site Navigation </h2> <ul class="icons font16"> <li class="icons-home"><a href="/">The Mail Archive home</a></li> <li class="icons-list"> <a href="/web2py@googlegroups.com" title="c" id="c">web2py - all messages</a></li> <li class="icons-about"> <a href="/web2py@googlegroups.com/info.html">web2py - about the list</a></li> <li class="icons-expand"><a href="/search?l=web2py%40googlegroups.com&q=from%3A%22niphlod%22&o=newest&f=1" title="e" id="e">Expand</a></li> </ul> </div> <div class="listlogo margintopdouble"> <h2 class="hidden"> Mail list logo </h2> <a href="/web2py@googlegroups.com"><img src="/web2py@googlegroups.com/logo.png" alt="aims"></a> </div> </div> <div class="footer" role="contentinfo"> <h2 class="hidden"> Footer information </h2> <ul> <li><a href="/">The Mail Archive home</a></li> <li><a href="/faq.html#newlist">Add your mailing list</a></li> <li><a href="/faq.html">FAQ</a></li> <li><a href="/faq.html#support">Support</a></li> <li><a href="/faq.html#privacy">Privacy</a></li> </ul> </div> <script language="javascript" type="text/javascript"> document.onkeydown = NavigateThrough; function NavigateThrough (event) { if (!document.getElementById) return; if (window.event) event = window.event; if (event.target.tagName == 'INPUT') return; if (event.ctrlKey || event.metaKey) return; var link = null; switch (event.keyCode ? event.keyCode : event.which ? event.which : null) { case 69: link = document.getElementById ('e'); break; } if (link && link.href) document.location = link.href; } </script> </body> </html>