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

2023-11-29 Thread Lisandro
_migrate=True? Or I don't 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: &g

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

2023-11-28 Thread Lisandro
rm a GET isn't ideal 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 --

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

2023-06-23 Thread Lisandro
ned, is there any 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 (S

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 beca

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

2023-06-21 Thread Lisandro
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 > ha scritto: > >> I've recently upgraded to web2py Version >> 2.24.1-stable+timestamp.2023.0

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

2023-06-21 Thread Lisandro
scheduled tasks. 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 or

[web2py] Scheduler error on last stable web2py version 2.24.1

2023-06-19 Thread Lisandro
problem at the 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

[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
El miércoles, 10 de mayo de 2023 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

[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
e app 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 

[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: *redi

[web2py] Re: xmlrpc python3 error

2023-03-20 Thread Lisandro
if not db(db.clients.token == 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 migratin

[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 "/home/limon/medios/gluon/restricted

[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 escrib

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

2022-08-06 Thread Lisandro
ates over all the stored sessions, 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

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

2022-07-26 Thread Lisandro
p? 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 Issues) --- You received this message because you are subscribed to

[web2py] Memory leak using Redis for sessions

2022-07-25 Thread Lisandro
s/default/chapter/29/13?search=cache#Sessions-in-Redis> right, I don'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 (Do

[web2py] Issue with redis sessions

2022-07-04 Thread Lisandro
d this is what I see when I run 'pip freeze | grep "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)

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

2020-02-29 Thread Lisandro
cache of an application: I think 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

[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 t

[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 storin

[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:* https://github.com/web2py/web2py/blob/1ce316609a7a70c

[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
y, what I do is to create a new dictionary where I 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

[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
> Also in your json example you are 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&

[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
.load(open('domains_apps.pkl', 'rb')) >>> print(r) {*u*'prod.com': *u*'prod', *u*'test.com': *u*'test'} Notice that in python 2 reading the .pkl file (that was written with python 3 using protocol=2) returns unicode strings. This

[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
map, LegalChars): 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 suggesti

[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 i

[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, stor

[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 test.co

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

2019-07-17 Thread Lisandro
8') inside my routes.py. It's 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 ca

[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: utf-

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

2019-06-07 Thread Lisandro
improvement, but I'd want > 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'r

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

2019-06-06 Thread Lisandro
ng about issues 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 &g

[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 "domains_a

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

2019-05-24 Thread Lisandro
esponse times have decreased 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 doi

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

2019-05-13 Thread Lisandro
nk I can enable threads 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 >

[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 hand,

[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
in web2py? I personally don't think 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, Li

[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

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

2019-04-26 Thread Lisandro
is updated 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, Lisandr

[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*, f

[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 pro

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

2019-01-25 Thread Lisandro
've not seen an option for that 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 (UT

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

2019-01-23 Thread Lisandro
rivers 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

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

2019-01-23 Thread Lisandro
y lost. 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 psy

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

2019-01-23 Thread Lisandro
you tried to install 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

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

2019-01-23 Thread Lisandro
postgresql.log. Right now I've 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:

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

2019-01-16 Thread Lisandro
y (I use uwsgi chain 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

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

2019-01-15 Thread Lisandro
pplication? El martes, 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 ha

[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 e

[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 trace

[web2py] Re: Unexplicable error, any thoughts?

2018-11-30 Thread Lisandro
created. Any other comment 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 cont

[web2py] Unexplicable error, any thoughts?

2018-11-30 Thread Lisandro
ssible 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 ver

[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ó: > > appr

[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&#x

[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 scheduler t

[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
nd we 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
edios/applications/redonline/', '/var/www/medios/applications/lmdiario/', '/var/www/medios/applications/ahoracasilda_panel/', '/var/www/medios/applications/castellanosprueba_panel/', '/var/www/medios/applications/diariocordoba/', '/var/www/medi

[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] in

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

2018-09-04 Thread Lisandro
s.BASE.applications which is a string 'ALL' is being passed >> without being converted to a list of all applications. >> > > Doesn't look like routers.BASE.applications is set in routes.py, but it > appears that somehow in the context of the scheduler, the d

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

2018-09-03 Thread Lisandro
ning ~600 apps (that is, 600 copies of the same app). Do you see something odd here? In the meantime, I'll verify that all the apps referened in "domains_apps" file are in deed installed apps. El lunes, 3 de septiembre de 2018, 11:40:22 (UTC-3), Anthony escribió: > > What do

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

2018-09-03 Thread Lisandro
0] in self.controllers or self.args[0] in applications: TypeError: '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. >

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

2018-09-02 Thread Lisandro
se, as the message says > : > > 'in ' requires string as left operand, 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

[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 this

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

2018-08-13 Thread Lisandro
uler If you need to check 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/1

[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 conten

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

2018-08-06 Thread Lisandro
g some weird post. 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:4

[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 == '1').update(current_state='1')

[web2py] Re: auto save feature

2018-07-20 Thread Lisandro
set a timeout 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 d

[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 rea

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

2018-07-19 Thread Lisandro
t a log line there, though I don't know 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 whic

[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 eve

[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 e

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

2018-07-12 Thread Lisandro
t's inefficient, and I would have to add that extra select in every single 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

[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
e junio de 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

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

2018-06-06 Thread Lisandro
10 seconds, maybe that should bring 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/issue

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

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

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

2018-05-03 Thread Lisandro
.07). I already have 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,

[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 adapte

[web2py] Re: web2py, PostgreSQL and exclusive locks

2018-05-02 Thread Lisandro
n() run by web2py? 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. &g

[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
g migrations to false. may be you are doing more database IO > than you should > > On Friday, 6 April 2018 09:41:09 UTC-5, Lisandro wrote: >> >> Hi Anthony, again, thank you very much for your time, I really appreciate >> it. >> >> El jueves, 5 de abril de 2018,

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

2018-04-21 Thread Lisandro
ock=True parameter passed to the RedisSession object*" Considering that, and giving 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?

[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

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

2018-04-20 Thread Lisandro
;s not my case, so I'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 escri

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

2018-04-20 Thread Lisandro
p:important-messages-3:__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 d

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

2018-04-20 Thread Lisandro
why it worked with a new account, that is because 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

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

2018-04-19 Thread Lisandro
r identical calls work properly (and they are all identical, 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 s

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

2018-04-16 Thread Lisandro
d I'll try to leave the account there to do some tests. 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? > >

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

2018-04-16 Thread Lisandro
ection 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
x27;m not sure 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 201

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

2018-04-08 Thread Lisandro
ll the session keys. I've tried a similar code to the one showed above, 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

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

2018-04-06 Thread Lisandro
r message here 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&#x

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

2018-04-06 Thread Lisandro
cquires an access share lock on the involved tables, so this > should be happening on all requests. However, access share locks do not > conflict with each other, so I don't think these locks are necessarily the > source of your problem. > > Anthony > > On Thursday, Apri

[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
nt. Today we just had 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 wrot

  1   2   3   4   >