Re: [web2py] How to perform a DB migration from outside the app where DB is defined?

2023-11-29 Thread Lisandro
need it anymore as I'm going to perform manually database migrations from now on? Thanks in advance! Best regards, Lisandro El martes, 28 de noviembre de 2023 a la(s) 10:06:52 UTC-3, Carlos Correia escribió: > Às 11:34 de 28/11/23, Lisandro escreveu: > > Hey there! > I have se

[web2py] How to perform a DB migration from outside the app where DB is defined?

2023-11-28 Thread Lisandro
because it hits the timeout (a normal timeout set for any http request). Is there any way to perform the database migration from outside the app where the database is defined that doesn't involve using http requests? Thanks in advance! Warm regards, Lisandro -- Resources: - http://web2py.com

[web2py] Error in gluon parse_all_vars(): TypeError: write() argument must be str, not bytes

2023-06-23 Thread Lisandro
ny way I can avoid this ticket errors? Using nginx to add the missing header? Changing web2py source code? What could I do? Thanks in advance! Warm regards, Lisandro -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code)

Re: [web2py] Scheduler error on last stable web2py version 2.24.1

2023-06-22 Thread Lisandro
I've posted an issue <https://github.com/web2py/web2py/issues/2468> and I've already proposed a small fix and made a pull request :) El miércoles, 21 de junio de 2023 a la(s) 11:25:45 UTC-3, Lisandro escribió: > (sorry, I've deleted my previous message because I have more

Re: [web2py] Scheduler error on last stable web2py version 2.24.1

2023-06-21 Thread Lisandro
hould be fixed now. > > https://github.com/web2py/web2py/issues/1999 > > > Il giorno lun 19 giu 2023 alle ore 20:57 Lisandro > ha scritto: > >> I've recently upgraded to web2py Version >> 2.24.1-stable+timestamp.2023.03.23.05.07.17 >> It's running on p

Re: [web2py] Scheduler error on last stable web2py version 2.24.1

2023-06-21 Thread Lisandro
ks. Should I achieve this in a different way? El miércoles, 21 de junio de 2023 a la(s) 07:08:37 UTC-3, Massimiliano escribió: > There was an issue but should be fixed now. > > https://github.com/web2py/web2py/issues/1999 > > > Il giorno lun 19 giu 2023 alle ore 20:57 Lisandro >

[web2py] Scheduler error on last stable web2py version 2.24.1

2023-06-19 Thread Lisandro
time scheduler fails. The database instance has several databases and no error log is reported, everything runs smoothly. It's just the scheduler that reports that error (and after it, it doesn't run anymore). Where else should I look? Any help will be much appreciated. Warm regards, Lisa

[web2py] Re: Error with redis and web2py 2.24.1: Invalid input of type: 'NoneType'. Convert to a bytes, string, int or float first.

2023-05-16 Thread Lisandro
a la(s) 16:18:25 UTC-3, Lisandro escribió: > I see what you mean. I'll investigate why the socket was closed, I presume > it could be a network problem, because the Redis server is separated from > the one where the app resides, they communicate through the local network. > Con

[web2py] Re: Error with redis and web2py 2.24.1: Invalid input of type: 'NoneType'. Convert to a bytes, string, int or float first.

2023-05-10 Thread Lisandro
serves around 60 requests per second and the error only happens 3 or 4 times per day, I will look into the network. Thank you for your time! Best regards, Lisandro El martes, 9 de mayo de 2023 a la(s) 23:22:06 UTC-3, snide...@gmail.com escribió: > On Monday, May 8, 2023 at 6:36:13 AM UT

[web2py] Error with redis and web2py 2.24.1: Invalid input of type: 'NoneType'. Convert to a bytes, string, int or float first.

2023-05-08 Thread Lisandro
Hey there! I recently updated to Web2py Version 2.24.1-stable+timestamp.2023.03.23.05.07.17 It uses python 3.9.14, running in production serving around 60 requests per second, using resources efficiently and running really smoothly :D Since the update, I'm seeing this error sporadically:

[web2py] Re: xmlrpc python3 error

2023-03-20 Thread Lisandro
== request.args(1)).count(): raise HTTP(403) return service() I hope it helps someone. Best regards, Lisandro El domingo, 19 de marzo de 2023 a la(s) 19:56:20 UTC-3, Lisandro escribió: > Hey there! > I'm experiencing the same error after migrating to python3 and web2py > versi

[web2py] Re: xmlrpc python3 error

2023-03-19 Thread Lisandro
Hey there! I'm experiencing the same error after migrating to python3 and web2py version 2.23.1-stable+timestamp.2023.01.31.08.01.46 The traceback is the same, the error is originated when I try to access request.vars: Traceback (most recent call last): File

[web2py] Re: Memory leak using Redis for sessions

2022-08-06 Thread Lisandro
It's not a memory leak. You have to run sessions2trash.py periodically, even if you're using Redis and setting and expiration time for every session: https://groups.google.com/g/web2py/c/IFjr-VQoyAE/m/VoihkT1NAgAJ El lunes, 25 de julio de 2022 a la(s) 18:23:37 UTC-3, Lisandro escribió: >

[web2py] Re: Should I run sessions2trash.py even if I use Redis for sessions and set an expiration time?

2022-08-06 Thread Lisandro
and if you're using Redis and you're setting an expiration time for every session, it doesn't make sense to iterate over all the dataset just to clean "that other stuff". Hope it helps someone :) El martes, 26 de julio de 2022 a la(s) 08:40:04 UTC-3, Lisandro escribió: > Hey t

[web2py] Should I run sessions2trash.py even if I use Redis for sessions and set an expiration time?

2022-07-26 Thread Lisandro
in advance! Warm regards, Lisandro -- 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

[web2py] Memory leak using Redis for sessions

2022-07-25 Thread Lisandro
on't need to run it as I set an expiration time for every session. Let me know what you think, any help will be much appreciated. Thanks! Warm regards, Lisandro -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code

[web2py] Issue with redis sessions

2022-07-04 Thread Lisandro
ot;redis"': redis==2.8.0 What could be the reason of the issue? Thanks in advance! Warm regards, Lisandro. -- 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 Issue

[web2py] Re: Redis: what's the proper way to clear all the cache keys of a given app?

2020-02-29 Thread Lisandro
hink I'll go for subprocess with a command like: $ redis-cli --scan --pattern w2p:cache:appname:* | xargs redis-cli del Any comment or suggestion will be much appreciated. Warm regards, Lisandro. El sábado, 29 de febrero de 2020, 20:19:29 (UTC-3), Lisandro escribió: > > I'm having som

[web2py] Redis: what's the proper way to clear all the cache keys of a given app?

2020-02-29 Thread Lisandro
I'm having some trouble with Redis and I thought some of you could enlighten me :) I have a web2py instance running with several apps. I have a Redis instance working as a cache, with maxmemory set to 20gb and LRU eviction policy. Every application connects to the same Redis instance. One of

[web2py] Re: Is it possible to change the auto-generated key used to cache an specific URL?

2019-10-19 Thread Lisandro
I've opened an issue because I think it could be a bug: https://github.com/web2py/web2py/issues/2266 I'll try to suggest a fix. El viernes, 18 de octubre de 2019, 21:16:17 (UTC-3), Lisandro escribió: > > When using @cache.action in controller functions, the key used for storing > th

[web2py] Is it possible to change the auto-generated key used to cache an specific URL?

2019-10-18 Thread Lisandro
When using @cache.action in controller functions, the key used for storing the content is auto-generated based on the request URL. To be more specific, the key is generated based in *current.request.env.path_info* and *current.response.view:*

[web2py] Re: Error trying to go back to python 2 after testing python 3: TypeError: translate() takes exactly one argument (2 given)

2019-10-11 Thread Lisandro
explicitly set keys and values using str() It's not an elegant solution, but it seems to work for py2 and py3. Anyway, I'll only keep the fix until I'm sure I don't need to go back to py2. Thanks for the help! El viernes, 11 de octubre de 2019, 8:58:40 (UTC-3), Lisandro escribió: > >

[web2py] Re: Error trying to go back to python 2 after testing python 3: TypeError: translate() takes exactly one argument (2 given)

2019-10-11 Thread Lisandro
getting unicode both in py2 and py3 > except py3 does not put the u'' in front of unicode strings because they > are default. > > On Thursday, 10 October 2019 18:05:55 UTC-7, Lisandro wrote: >> >> I've found the issue, it's not web2py related, sorry about that. >> >> My web2

[web2py] Re: Error trying to go back to python 2 after testing python 3: TypeError: translate() takes exactly one argument (2 given)

2019-10-10 Thread Lisandro
at in python 2 reading the .pkl file (that was written with python 3 using protocol=2) returns unicode strings. This doesn't happen in python 3. But i'm not sure what protocol to use. I'll do some more tests and I'll post here whatever solution I can find. Thanks for your time! Regards, Lisandro.

[web2py] Error trying to go back to python 2 after testing python 3: TypeError: translate() takes exactly one argument (2 given)

2019-10-10 Thread Lisandro
): File "/usr/lib64/python2.7/string.py", line 493, in translate return s.translate(table, deletions) TypeError: translate() takes exactly one argument (2 given) I've already flushed redis cache, restarted webserver, cleared browser data... Any other suggestion? Thanks in advan

[web2py] Can't import gluon.contrib.simplejson after migrating to Python 3

2019-10-09 Thread Lisandro
Hi there! I'm using this version of web2py: Version 2.17.1-stable+timestamp.2018.08.06.01.02.56 I recently moved to Python 3 and I've found this issue. When I try to do this: from gluon.contrib import simplejson ... I receive this error: ModuleNotFoundError: No module named 'decoder' This

[web2py] Re: Disable the simultaneous session in the expiration period

2019-08-08 Thread Lisandro
In this thread you will find an interesting conversation about preventing multiple sessions from the same user: https://groups.google.com/forum/#!searchin/web2py/multiple$20login%7Csort:date/web2py/Zz6zvYav4Sw/2xHJ8loVBgAJ I use the approach suggested by Massimo: *"when a user first logs in,

[web2py] Need to know if web2py is setting cookies properly for this specific case

2019-08-08 Thread Lisandro
I have two applications that share the same model. One of the applications runs on top level domain, and the other runs in a subdomain: *test.com*: applications/test *admin.test.com*: applications/test_admin The user logs in from admin.test.com and the cookie needs to be valid also for

[web2py] Re: Encoding problem with a web2py application that implements an XMLRPC webservice

2019-07-17 Thread Lisandro
working smoothly :) Thanks again! Best regards, Lisandro. El sábado, 6 de julio de 2019, 13:23:38 (UTC-3), Alfonso Serra escribió: > > sys.setdefaultencoding will work thorough the server execution process. So > as long it is alive you wont need to call it several times. > > It wil

[web2py] Encoding problem with a web2py application that implements an XMLRPC webservice

2019-07-04 Thread Lisandro
I need to understand if this is a bug or if it is the expected behaviour and I'm doing something wrong. I have two web2py applications. One of them implements an XMLRPC webservice, and the other one consumes it. All the controllers (in both applications) have this first line: # -*- coding:

[web2py] Re: Could this problem in production be related to web2py?

2019-06-07 Thread Lisandro
t > to ensure disk-persistence for them (but not for cached things like search > results). How many sessions are you storing, and how much RAM does it > consume? > > On Thursday, 6 June 2019 20:33:28 UTC+1, Lisandro wrote: >> >> If you're going to add Redis, let me add a

[web2py] Re: Could this problem in production be related to web2py?

2019-06-06 Thread Lisandro
ssues to be on the > lookout for is very helpful. > > On Friday, 24 May 2019 16:26:50 UTC+1, Lisandro wrote: >> >> I've found the root cause of the issue: the guilty was Redis. >> >> This is what was happening: Redis has an option for persistance >> <h

[web2py] How can I check if an application is installed from within routes.py?

2019-06-03 Thread Lisandro
In my production environment, new web2py apps are installed every day. In fact, it is the same app that it is installed several times with a different name. Each installed application corresponds to a website that has its own domain. In the root folder of web2py, I have a file called

[web2py] Re: Could this problem in production be related to web2py?

2019-05-24 Thread Lisandro
reased to expected values, no more timeouts :) I will continue to investigate this issue with Redis in the proper forum. I hope this helps anyone facing the same issue. Thanks for the help! El lunes, 13 de mayo de 2019, 13:49:26 (UTC-3), Lisandro escribió: > > After doing a lot of reading about

[web2py] Re: Could this problem in production be related to web2py?

2019-05-13 Thread Lisandro
safely. What do you think? El jueves, 9 de mayo de 2019, 21:10:57 (UTC-3), Lisandro escribió: > > I've checked my app's code once again and I can confirm that it doesn't > create threads. It only uses subprocess.cal() within functions that are > called in the scheduler environment, I

[web2py] Re: Could this problem in production be related to web2py?

2019-05-09 Thread Lisandro
I've checked my app's code once again and I can confirm that it doesn't create threads. It only uses subprocess.cal() within functions that are called in the scheduler environment, I understand that's the proper way to do it because those calls don't run in uwsgi environment. In the other

[web2py] Re: Could this problem in production be related to web2py?

2019-05-09 Thread Lisandro
Hi Leonel, thank you very much for your time. uWSGI docs confirm what you suggest: *"The emperor should generally not be run with --master, unless master features like advanced logging are specifically needed."* Allow me to make one last question: what do you mean by "create any thread in your

[web2py] Could this problem in production be related to web2py?

2019-05-09 Thread Lisandro
so, but I would like to hear some opinions from the experts :) IMHO the problem could be related to virtualization (remember this is running on a Linode VPS). What do you think? Any comment or suggestion will be much appreciated. Thanks! Best regards, Lisandro. -- Resources: - http://web2py.

[web2py] Re: Is it possible to write a virtual method field that modifies the row?

2019-04-26 Thread Lisandro
Hi Anthony, thank you for your time. I tried the method you suggested, but here is my problem: after calling the method, the row object isn't updated. row = db.person(1) row.change_name('Lisandro') print(row.name) This doesn't print "Lisandro". Instead, it prints the name the person

[web2py] Is it possible to write a virtual method field that modifies the row?

2019-04-26 Thread Lisandro
with the new values. I've tried returning the row object in the method definition function but it doesn't work. I'm wondering, is it even possible to implement something like that? Any comment or suggestion will be much appreciated. Thanks! Warm regards, Lisandro. -- Resources: - http

[web2py] Re: compile_application() not including symlinked views (while it includes symlinked controllers)

2019-04-04 Thread Lisandro
I don't think so, because the symlink has the same permissions (also owner) of the other symlinks that are compiled properly. Anyway, I tried to set 777 permissions but it didn't work. I forgot to mention that *symlinked views are compiled properly when the symlink points directly to a file*,

[web2py] compile_application() not including symlinked views (while it includes symlinked controllers)

2019-04-03 Thread Lisandro
I have an application that uses symlinks for some of its controllers, models and views. Symlinked controllers and models are compiled properly, but something weird happens with symlinked views. For example, this symlinked controller: controllers/test.py --> *symlink to external file* ... is

Re: [web2py] Error: prepared statement «pg8000_statement_0» already exists

2019-01-25 Thread Lisandro
in DAL's constructor. Could I just remove the folder gluon/contrib/pg8000/ to be sure my application will use only psycopg2 and fail if it can't find it? Thank you very much in advance. Regards, Lisandro. El miércoles, 23 de enero de 2019, 10:56:15 (UTC-3), Massimiliano escribió: > > W

Re: [web2py] Error: prepared statement «pg8000_statement_0» already exists

2019-01-23 Thread Lisandro
s available: psycopg2, pymysql, imaplib, sqlite3, pg8000, >> pyodbc, pymongo >> >> >> >> >> On Wed, Jan 23, 2019 at 10:59 AM Lisandro > > wrote: >> >>> Thanks Massimiliano. >>> >>> Apparently psycopg2 is already installed (of

Re: [web2py] Error: prepared statement «pg8000_statement_0» already exists

2019-01-23 Thread Lisandro
El miércoles, 23 de enero de 2019, 6:58:57 (UTC-3), Lisandro escribió: > > Thanks Massimiliano. > > Apparently psycopg2 is already installed (of course it was already > installed, maybe something broke during the packages upgrade). > Something weird is that I see psycopg2 inst

Re: [web2py] Error: prepared statement «pg8000_statement_0» already exists

2019-01-23 Thread Lisandro
nstall psycopg2? Is the standard de facto postgresql > driver. > The pip package should be psycopg2-binary > > On Wed, Jan 23, 2019 at 10:39 AM Lisandro > wrote: > >> Hi there! Yesterday I had a MAJOR downtime and I would need your help to >> understand what happen

[web2py] Error: prepared statement «pg8000_statement_0» already exists

2019-01-23 Thread Lisandro
e bypassed pgbouncer and my application is connecting directly to postgresql. Could you put some lights into this? What can I do to avoid that error and still connect to pgBouncer with web2py 2.16.1? Thank you very much in advance. Regards, Lisandro. -- Resources: - http://web2py.com - http://web2p

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

2019-01-16 Thread Lisandro
reload to avoid any issues). Thanks again! El miércoles, 16 de enero de 2019, 5:35:32 (UTC-3), Dave S escribió: > > > > On Tuesday, January 15, 2019 at 11:31:51 AM UTC-8, Lisandro wrote: >> >> Thank you Leonel, that could be the reason, or at least could be related

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

2019-01-15 Thread Lisandro
rtes, 15 de enero de 2019, 15:34:53 (UTC-3), Leonel Câmara escribió: > > *Lisandro *that problem is appearing when trying to create an environment > to execute the task, where it imports the models from the application. Is > it possible the folder of the application has been removed or mo

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

2019-01-15 Thread Lisandro
That was my first guess, but the task status in those cases was FAILED, not TIMEOUT. I forgot to mention I'm using web2py version 2.16.1-stable+timestamp.2017.11.14.05.54.25 I'll keep monitoring and see if I can add any detail. Thanks! El martes, 15 de enero de 2019, 5:24:56 (UTC-3), Niphlod

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

2019-01-14 Thread Lisandro
I've seeing this for a while now, but I can't figure out why it happens. I have several tasks (around 150) that run once per day (at different hours, maybe some of them run simultaneously). They always run successfully with no problems. However, once every time, one of them fail with this

[web2py] Re: Unexplicable error, any thoughts?

2018-11-30 Thread Lisandro
nt is very welcome. Regards, Lisandro. El viernes, 30 de noviembre de 2018, 16:26:20 (UTC-3), Dave S escribió: > > > > On Friday, November 30, 2018 at 10:54:14 AM UTC-8, Val K wrote: >> >> It seems that something deletes the record while your controller is >> ru

[web2py] Unexplicable error, any thoughts?

2018-11-30 Thread Lisandro
that the problem to happen in the way it was described, I just Iet it go. The thread where we talked about it is this: https://groups.google.com/forum/#!searchin/web2py/lisandro%7Csort:date/web2py/gdmTww_jrkA/IXzu5Ns3CQAJ Anyway, now I'm running web2py 2.17.1 and I'm facing a very similar issue. In fact

[web2py] Re: Is it possible to share cache between two differente web2py applications?

2018-11-26 Thread Lisandro
Thanks Massimo! I've recently noted that the fix I did was incomplete. I've sent a new pull request with the new code: https://github.com/web2py/web2py/pull/2059 Regards, Lisandro. El domingo, 18 de noviembre de 2018, 16:06:37 (UTC-3), Massimo Di Pierro escribió: > > ap

[web2py] Re: Is it possible to share cache between two differente web2py applications?

2018-11-14 Thread Lisandro
I've created a pull request to achieve this: https://github.com/web2py/web2py/pull/2055 If it's not accepted (which is totally ok with me), I would like to know if I have some other alternative. Thanks! El lunes, 23 de enero de 2017, 17:29:22 (UTC-3), Lisandro escribió: > > I'm using Redi

[web2py] Re: Scheduler task (defined inside a module) won't run new code even after restarting uWSGI

2018-10-12 Thread Lisandro
Sorry, my bad. I realised that I had to restart scheduler workers, not uWSGI workers. So I restarted the scheduler workers and it worked. Sorry for the bother! El viernes, 12 de octubre de 2018, 12:04:40 (UTC-3), Lisandro escribió: > > I'm facing a weird issue: I have a schedule

[web2py] Scheduler task (defined inside a module) won't run new code even after restarting uWSGI

2018-10-12 Thread Lisandro
I'm facing a weird issue: I have a scheduler task that is defined inside a module. At the same time, that function calls another function that is defined in **another** module. I had to make some changes to the last module, so I restarted uWSGI, but the task is still running with the old code

[web2py] Re: How many apps can a web2py instance handle?

2018-09-18 Thread Lisandro
have been slowly expanding (right now we run about 300 websites). We owe part of our success to web2py and its great community, so I take the opportunity to thank you all once again! Best regards, Lisandro. El martes, 18 de septiembre de 2018, 13:22:42 (UTC-3), Leonel Câmara escribió

[web2py] How many apps can a web2py instance handle?

2018-09-18 Thread Lisandro
it made me wonder, is there a theoretical limit? Could the number of installed apps affect performance at a signifficant level? Thank you very much in advance. Best regards, Lisandro. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (S

[web2py] Re: Can't understand this error in gluon/rewrite.py

2018-09-06 Thread Lisandro
I've modified gluon/rewrite.py to log functions and controllers: if self.args: try: mylog = open('mylog.txt', 'a') mylog.write('%s %s\n' % (self.functions, self.controllers)) mylog.close() except: pass if self.args[0] in self.functions or self.args[0]

[web2py] Re: Can't understand this error in gluon/rewrite.py

2018-09-04 Thread Lisandro
SE.applications is set in routes.py, but it > appears that somehow in the context of the scheduler, the default value of > 'ALL' is not getting converted to a list of apps. It's hard to track down > exactly where things are going wrong. > > Lisandro, maybe confirm the value of rou

[web2py] Re: Can't understand this error in gluon/rewrite.py

2018-09-03 Thread Lisandro
ned in "domains_apps" file are in deed installed apps. El lunes, 3 de septiembre de 2018, 11:40:22 (UTC-3), Anthony escribió: > > What does your routes.py file look like? > > On Monday, September 3, 2018 at 10:25:22 AM UTC-4, Lisandro wrote: >> >> This problem is

[web2py] Re: Can't understand this error in gluon/rewrite.py

2018-09-03 Thread Lisandro
eError: 'in ' requires stringas left operand, not long I'm a bit lost. Where else should I look? El lunes, 3 de septiembre de 2018, 1:45:49 (UTC-3), Lisandro escribió: > > Thanks for that fast response. > If the cause of the problem is passing "contenido.id" as int, the

[web2py] Re: Can't understand this error in gluon/rewrite.py

2018-09-02 Thread Lisandro
not long > > You can do args=['%s' % contenido.id, or args=[str(contenido.id), > > > Dont know why in others installed apps works, is really weird > > > > El lunes, 3 de septiembre de 2018, 0:54:32 (UTC-3), Lisandro escribió: >> >> I have the same app ins

[web2py] Can't understand this error in gluon/rewrite.py

2018-09-02 Thread Lisandro
I have the same app installed several times within a web2py instance (running version 2.16.1-stable+timestamp.2017.11.14.05.54.25). In some of them, this sentence: URL(c='default', f=f, args=[contenido.id, contenido.slug], extension='', scheme=True, host=current.CONFIG.dominio) ... throws

[web2py] Re: Why is scheduler creating so many files at /var/spool/postfix/maildrop?

2018-08-13 Thread Lisandro
the status of the service, run: sudo systemctl status scheduler If you need to enable the service to run on startup, run: sudo systemctl enable scheduler Thank you very much Dave for your time! Best regards, Lisandro. [1] http://web2py.com/books/default/chapter/29/13/deployment-recipes#Start

[web2py] Re: Why is scheduler creating so many files at /var/spool/postfix/maildrop?

2018-08-13 Thread Lisandro
b2py.py -K webmedios >/dev/null 2>&1 That did the trick, and those files are not created anymore. Thank you for your help! Best regards, Lisandro. El viernes, 10 de agosto de 2018, 19:52:30 (UTC-3), Dave S escribió: > > > > On Thursday, August 9, 2018 at 3:56:33 PM UTC-7

[web2py] Why is scheduler creating so many files at /var/spool/postfix/maildrop?

2018-08-09 Thread Lisandro
I've found that my production server has a lot of files in /var/spool/postfix/maildrop. I don't use postfix at all, however that folder is full of files. All the files follow the same name format, like this: 2B8431690D, 5712AE68F, 73CF062660, 73C02183A9, 5706512838, 2B7E413705. The file

[web2py] Re: Bot sends bad POST and triggers ValueError: Invalid boundary in multipart form: ''

2018-08-06 Thread Lisandro
. If it happens again, I'll try to collect more info. Thanks for caring! El domingo, 5 de agosto de 2018, 22:29:01 (UTC-3), Massimo Di Pierro escribió: > > Can you show an example of the body of the post that causes the problem? > > On Tuesday, 17 July 2018 06:43:35 UTC-7, Lisandro wro

[web2py] Re: Update row When run a controller

2018-07-26 Thread Lisandro
You've defined the field as "current_state" (notice the lowercase), but you're trying to update the field "Current_State" (notice the camel case). You need to replace this: db(db.Exp_Logs_Perm.id == '1').update(Current_State='1') with this db(db.Exp_Logs_Perm.id ==

[web2py] Re: auto save feature

2018-07-20 Thread Lisandro
imeout in javascript <https://www.w3schools.com/jsref/met_win_settimeout.asp> (let's say, 5 seconds) to send an http POST with the values of all the fields. Then, each time an input value changes, reset the timeout. That is a simple autosave mechanism. Regards, Lisandro El domingo, 15 de j

[web2py] Re: row.update_record() leaves row as None (only sometimes)

2018-07-19 Thread Lisandro
Thanks Leonel. I'm using PostgreSQL, so if that case isn't possible, then I think the problem could be in the second line, where the code retrieves the record using row.id: row.update_record(**data) row = db.content[row.id] # the problem could be here row.update_tsv() Remember yesterday I

[web2py] Re: row.update_record() leaves row as None (only sometimes)

2018-07-19 Thread Lisandro
exactly what to log. El jueves, 19 de julio de 2018, 10:56:55 (UTC-3), Anthony escribió: > > On Thursday, July 19, 2018 at 4:26:09 AM UTC-4, Lisandro wrote: >> >> Well, I owe you an apology, because I got confused regarding which app >> was throwing the error and wh

[web2py] Bot sends bad POST and triggers ValueError: Invalid boundary in multipart form: ''

2018-07-17 Thread Lisandro
Hi there! I'm just reporting this situation in case it's a bug, I'm not sure. I have a public webpage (no login required), and from time to time I see this error: ValueError: Invalid boundary in multipart form: '' The error is produced by a bot that sends a bad POST to an URL that doesn't

[web2py] Re: row.update_record() leaves row as None (only sometimes)

2018-07-17 Thread Lisandro
I don't think the code for update_tsv() is related, because the traceback shows that the error is produced even before looking for that method. I mean, the error says that the "row" object is None, therefor I think it would throw error calling any method. But anyway, in case it helps to figure

[web2py] Re: row.update_record() leaves row as None (only sometimes)

2018-07-12 Thread Lisandro
Thank you Leonel for your time. The code I showed is a bit simplified. I do some validation in deed (to requests.vars and request.args). Even though, if there is a problem with request.vars (for example, if request.vars.age is a string that is not a digit), the update_record would throw some

[web2py] row.update_record() leaves row as None (only sometimes)

2018-07-12 Thread Lisandro
line where my app calls .update_record(), obviously that's ugly and I've discarded the solution. So, what could be causing the error? Any help or comment will be much appreciated. I'm using last stable version of web2py (2.16.1-stable+timestamp.2017.11.14.05.54.25) Best regards, Lisandro

[web2py] Re: Using @cache.action with Redis takes 10 seconds to return a simple HTTP 503 or 404

2018-06-06 Thread Lisandro
ithub.com/web2py/web2py/commit/ea5ea6a30759a2c825f23381540dc396cbc475b7 > . > > Anthony > > On Wednesday, June 6, 2018 at 9:16:57 AM UTC-4, Lisandro wrote: >> >> Quick update: *apparently the problem doesn't happen using >> RedisCache(with_lock=False

[web2py] Re: Using @cache.action with Redis takes 10 seconds to return a simple HTTP 503 or 404

2018-06-06 Thread Lisandro
2018, 9:45:55 (UTC-3), Lisandro escribió: > > Hi there! I recently upgraded my production environment to web2py 2.16.1, > and I'm facing an old issue that was apparently solved. > In my applications I use @cache.action to cache public pages, and as I use > Redis for cache

[web2py] Using @cache.action with Redis takes 10 seconds to return a simple HTTP 503 or 404

2018-06-06 Thread Lisandro
in some clue about what's happening. Any suggestion? Thanks in advance! Regards, Lisandro -- 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: Web2py locks row at auth_user and web2py_session_* tables and doesn't unlock them

2018-06-04 Thread Lisandro
with this, considering that the problem could be solved just upgrading web2py and Redis. We also have just moved our production deployment to CentOS 7 for better stability. Once again, I deeply thank all of you for your time and your constant willingness to help! Best regards, Lisandro. El

[web2py] Re: Web2py locks row at auth_user and web2py_session_* tables and doesn't unlock them

2018-05-03 Thread Lisandro
plans to upgrade. But before, could I manually update only gluon/contrib/redis_*.py files? In your opinion, does that test worthwhile? Does it make any sense? El viernes, 20 de abril de 2018, 8:28:28 (UTC-3), Lisandro escribió: > > Sorry to bother you again with this, but I think I've

[web2py] Re: web2py, PostgreSQL and exclusive locks

2018-05-03 Thread Lisandro
Please ignore that last message of mine. The hanging problem was produced by an issue with the redis_cache.py adapter failing to write a cache key. El miércoles, 2 de mayo de 2018, 17:08:38 (UTC-3), Lisandro escribió: > > Well, I've commented out the line of the postgresql adapter of

[web2py] Re: web2py, PostgreSQL and exclusive locks

2018-05-02 Thread Lisandro
El miércoles, 2 de mayo de 2018, 16:09:31 (UTC-3), Lisandro escribió: > > Hi there, sorry to bother in this old post. > > I'm having a problem regarding standard_conforming_strings. > Today my app experienced a problem with Redis going out of memory. > After the problem was

[web2py] Re: web2py, PostgreSQL and exclusive locks

2018-05-02 Thread Lisandro
Hi there, sorry to bother in this old post. I'm having a problem regarding standard_conforming_strings. Today my app experienced a problem with Redis going out of memory. After the problem was fixed, all my websites started to work normally, except four of them (of a total of 260 websites). For

[web2py] Re: Request with login privileges hangs for a specific user account, how to debug it?

2018-04-24 Thread Lisandro
s 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, thank you very much for your time, I really appreciate >> it. >> >> El jueves, 5 de abril de 2018, 17:52:36 (UTC-

[web2py] Re: Web2py locks row at auth_user and web2py_session_* tables and doesn't unlock them

2018-04-21 Thread Lisandro
ving that until now I stored the sessions in the db, I guess that it won't hurt to use RedisSession(..., with_lock=False), as it would remain being the same that before (regarding the lock), right? Anyway, let me know if there is some additional test that I can do to figure out why the ap

[web2py] Re: Web2py locks row at auth_user and web2py_session_* tables and doesn't unlock them

2018-04-21 Thread Lisandro
icant. Having seen this, I'll keep using Redis this way: RedisCache(..., with_lock=True) RedisSession(..., with_lock=False) Thank you very much Anthony for your help. Regards, Lisandro. PS: I would like to change this thread subject to something more appropiate, but I'm not allowed to do it. Sorr

[web2py] Re: Web2py locks row at auth_user and web2py_session_* tables and doesn't unlock them

2018-04-20 Thread Lisandro
'm tempted to change it to False, but I'm not sure about the decision. If you have any experience or suggestion about that, I'll appreciate you comment about it. Thanks again. Regards, Lisandro. El viernes, 20 de abril de 2018, 12:19:11 (UTC-3), Anthony escribió: > > On Friday, April 20,

[web2py] Re: Web2py locks row at auth_user and web2py_session_* tables and doesn't unlock them

2018-04-20 Thread Lisandro
lock". > > Anthony > > On Friday, April 20, 2018 at 7:28:28 AM UTC-4, Lisandro wrote: >> >> Sorry to bother you again with this, but I think I've found the problem. >> *The problem is apparently with Redis integration. *It had nothing to do >> with connections,

[web2py] Re: Web2py locks row at auth_user and web2py_session_* tables and doesn't unlock them

2018-04-20 Thread Lisandro
the new account had a different auth.user.id, so the key to store in redis was different). Could this be a bug in the redis_cache.py integration? Maybe I should open a new thread about this, right? El jueves, 19 de abril de 2018, 10:27:46 (UTC-3), Lisandro escribió: > > Hi there, >

[web2py] Re: Web2py locks row at auth_user and web2py_session_* tables and doesn't unlock them

2018-04-19 Thread Lisandro
ntical, just calls to connect to the webservice). - Just in case, I've checked that my nginx configuration isn't applying requests limits to my server IP or something like that, but no warning or error regarding this is showed in the nginx error.log - Also, just in case, I checked my pgBounce

[web2py] Re: Web2py locks row at auth_user and web2py_session_* tables and doesn't unlock them

2018-04-16 Thread Lisandro
. Thank you very much for your time! El lunes, 16 de abril de 2018, 17:31:47 (UTC-3), Anthony escribió: > > Where is the database server running? Is it possible there are occasional > network problems connecting to it? > > Anthony > > On Monday, April 16, 2018 at 3:15:54 PM

[web2py] Re: Web2py locks row at auth_user and web2py_session_* tables and doesn't unlock them

2018-04-16 Thread Lisandro
connection unexpectedly This probably means the server terminated abnormally before or while processing the request. Could this indicate that for some reason web2py is failing to store the session? Or could it still be that a deadlock in my app code is producing this error? El viern

Re: [web2py] How to retrieve info about sessions when they are stored in Redis?

2018-04-15 Thread Lisandro
why the deleted keys remain in Redis with a negative TTL, but I presume this is because redis server would be doing some automatically cleaning once every time, deleting definitively those keys with negative TTL. Thanks again! Regards, Lisandro. El miércoles, 11 de abril de 2018, 13:49:25 (UT

[web2py] How to retrieve info about sessions when they are stored in Redis?

2018-04-08 Thread Lisandro
e, replacing this: prefix = 'w2p:sess:%s' % application cache_set = 'w2p:sess:%s:id_idx' % application But that doesn't work. Is it possible to achieve what I want? Any suggestion will be much appreciated. Regards, Lisandro. -- Resources: - http://web2py.com - http://web2py.com/book (Documenta

[web2py] Re: Web2py locks row at auth_user and web2py_session_* tables and doesn't unlock them

2018-04-06 Thread Lisandro
if I find something that could signal the root cause of the issue. Thank you very much for your help! El viernes, 6 de abril de 2018, 16:05:13 (UTC-3), Anthony escribió: > > On Friday, April 6, 2018 at 10:58:56 AM UTC-4, Lisandro wrote: >> >> Yes, in fact, I've been runni

[web2py] Re: Web2py locks row at auth_user and web2py_session_* tables and doesn't unlock them

2018-04-06 Thread Lisandro
ly the > source of your problem. > > Anthony > > On Thursday, April 5, 2018 at 10:58:07 AM UTC-4, Lisandro wrote: >> >> Hi there! This is somehow related to this other topic [1], which I have >> closed because I've found some new evidence and I though it would be bette

[web2py] Re: Request with login privileges hangs for a specific user account, how to debug it?

2018-04-06 Thread Lisandro
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

[web2py] Re: Request with login privileges hangs for a specific user account, how to debug it?

2018-04-05 Thread Lisandro
d two more of those cases. This is the new topic I posted: https://groups.google.com/forum/#!topic/web2py/E9jrmf5E-B4 Regards, Lisandro. El jueves, 5 de abril de 2018, 12:55:26 (UTC-3), Anthony escribió: > > On Tuesday, April 3, 2018 at 8:43:31 AM UTC-4, Lisandro wrote: >> &

  1   2   3   4   >