[web2py] Re: Scheduler Replacement

2018-11-28 Thread Boris Aramis Aguilar Rodríguez
Thanks for your answer!, I'm a poor worker. lol. Really, really thanks, I'm tempted to take the road of doing some "interface" code to emulate the same functionality the scheduler currently does but using mrq.io library/framework as a backend... that to avoid changing the current code within

[web2py] Scheduler Replacement

2018-11-21 Thread Boris Aramis Aguilar Rodríguez
TL;DR : Do you guys know or has experience with an alternative scheduler to web2py's one that you would recommend? we use features such as scheduling tasks at a specific time, repetitions, timeouts, and check the task current state. Any further comments, advice and experience is really

[web2py] Re: Issues with Scheduler (suddenly multiple tickers appear)

2017-10-10 Thread Boris Aramis Aguilar Rodríguez
d not commits itself to be a ticker.. anyways issue is open now: https://github.com/web2py/web2py/issues/1787 El miércoles, 4 de octubre de 2017, 8:49:22 (UTC-6), Boris Aramis Aguilar Rodríguez escribió: > > Hi, I've been recently using lots of tasks scheduled on a server so I had > t

[web2py] Issues with Scheduler (suddenly multiple tickers appear)

2017-10-04 Thread Boris Aramis Aguilar Rodríguez
Hi, I've been recently using lots of tasks scheduled on a server so I had to use several workers to deal with the queue, currently I'm using 45 workers. Somewhere between 12 hours after starting the 45 workers, suddenly tasks start accumulating in the queue and workers are alive (they report a

Re: [web2py] Re: web2py scheduler with huge output or return values always timeout (even if the task finishes)

2016-02-29 Thread Boris Aramis Aguilar Rodríguez
cts the docs, and even if the bugreport has the 128k statement, the > docs don't report it let me try. > > On Monday, February 29, 2016 at 9:14:41 PM UTC+1, Boris Aramis Aguilar > Rodríguez wrote: >> >> It happends not only while printing but also when returning values on a &

Re: [web2py] Re: web2py scheduler with huge output or return values always timeout (even if the task finishes)

2016-02-29 Thread Boris Aramis Aguilar Rodríguez
ut it. > > On Monday, February 29, 2016 at 7:41:41 PM UTC+1, Boris Aramis Aguilar > Rodríguez wrote: >> >> Hi, there is an issue driving me crazy with the web2py scheduler: >> >> If you return something that has a huge size then it will always timeout; >> even

[web2py] web2py scheduler with huge output or return values always timeout (even if the task finishes)

2016-02-29 Thread Boris Aramis Aguilar Rodríguez
Hi, there is an issue driving me crazy with the web2py scheduler: If you return something that has a huge size then it will always timeout; even if the scheduler task correctly finishes. Let me explain with an example: def small_test(): s = 's'*1256018 another_s = s #print s

[web2py] Using basic auth (email username) seems not to be working

2015-12-11 Thread Boris Aramis Aguilar Rodríguez
Currently I'm trying to create a service for my application as follows: auth.settings.allow_basic_login = True @auth.requires_login() def test(): from gluon.serializers import json return json((auth.user, 'hello')) But I've tried to do authentication using the browser as follows:

[web2py] Scheduler Tasks show TICKER: error assigningt task (0) and task never start

2015-10-30 Thread Boris Aramis Aguilar Rodríguez
Hi I've just re-started my scheduler and suddenly it didn't worked, so i ran it on a shell with debug and the following errors appeared: http://pastebin.com/M7sQE3sR Im unsure of this errors, i've checked that the scheduler databases are actually defined (I can access them from appadmin) but

[web2py] Re: Scheduler Tasks show TICKER: error assigningt task (0) and task never start

2015-10-30 Thread Boris Aramis Aguilar Rodríguez
Since like two months ago Oracle. El viernes, 30 de octubre de 2015, 10:27:58 (UTC-6), Niphlod escribió: > > what backend are you using ? > > On Friday, October 30, 2015 at 4:36:09 PM UTC+1, Boris Aramis Aguilar > Rodríguez wrote: >> >> Hi >> >> I've ju

[web2py] Re: Scheduler Tasks show TICKER: error assigningt task (0) and task never start

2015-10-30 Thread Boris Aramis Aguilar Rodríguez
Sorry, this is FIXED; it was a self-introduced bug by overriding insert code within DAL's broken Oracle implementation. Thanks for your time! El viernes, 30 de octubre de 2015, 10:45:02 (UTC-6), Boris Aramis Aguilar Rodríguez escribió: > > Since like two months ago Oracle. > > El vi

[web2py] Re: Oracle CLOB/text insert adapter issues

2015-08-05 Thread Boris Aramis Aguilar Rodríguez
,ip_vpn,route_table,destinations) VALUES (NULL,6,:FOO,:BAR) cursor.execute(sss, FOO=p, BAR=p) El lunes, 3 de agosto de 2015, 9:51:16 (UTC-6), Boris Aramis Aguilar Rodríguez escribió: Hi, I've been currently working with Oracle as a database backend, I have found one issue that I highly

[web2py] Bug on DAL OracleAdapter

2015-08-05 Thread Boris Aramis Aguilar Rodríguez
Steps to reproduce: db.define_table('atable', Field('longtext', 'text'))#this makes longtext to be a clob in oracle database for i in range(1, 100): db.atable.insert(longtext=str(i)) rows = db(db.atable.id0).select() for r in rows: print r.longtext #this fails with the following exception

[web2py] Oracle CLOB/text insert adapter issues

2015-08-03 Thread Boris Aramis Aguilar Rodríguez
Hi, I've been currently working with Oracle as a database backend, I have found one issue that I highly suspect has to do with the DAL Adapter; when you use web2py text fields they get mapped into CLOB with oracle database backend (as you can see on the OracleAdapter code) the issue is dealing

[web2py] Re: Oracle CLOB/text insert adapter issues

2015-08-03 Thread Boris Aramis Aguilar Rodríguez
,:BAR) cursor.execute(sss, FOO=p, BAR=p) El lunes, 3 de agosto de 2015, 9:51:16 (UTC-6), Boris Aramis Aguilar Rodríguez escribió: Hi, I've been currently working with Oracle as a database backend, I have found one issue that I highly suspect has to do with the DAL Adapter; when you use

[web2py] Oracle SQL/DAL Bug Issue on Alter Table

2015-07-01 Thread Boris Aramis Aguilar Rodríguez
Hi all, I'm currently working on web2py with an Oracle Database backend (Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production) but I'm having an issue with the generated Oracle command for altering a table. I had a table definition as follows (in web2py):

[web2py] Re: DB2 database issue with Clob types

2015-05-04 Thread Boris Aramis Aguilar Rodríguez
should provide us more info... which web2py type are you using that is mapped to CLOB field? web2py/pyodbc version Paolo On Friday, April 24, 2015 at 6:17:53 PM UTC+2, Boris Aramis Aguilar Rodríguez wrote: class pyodbc.Error' ('ODBC data type -99 is not supported. Cannot read column LDTEXT

[web2py] Re: DB2 database issue with Clob types

2015-05-04 Thread Boris Aramis Aguilar Rodríguez
=USER;pwd=PASSWORD;port=50005;LONGDATACOMPAT=1;LOBMAXCOLUMNSIZE=10485875', migrate=False, pool_size=0, attempts=1) I'm so happy :) El lunes, 4 de mayo de 2015, 10:56:49 (UTC-6), Boris Aramis Aguilar Rodríguez escribió: Hi, web2py data type is text; I see in this post: https

[web2py] DB2 database issue with Clob types

2015-04-24 Thread Boris Aramis Aguilar Rodríguez
class pyodbc.Error' ('ODBC data type -99 is not supported. Cannot read column LDTEXT.', 'HY000') Hi, Im currently accesing a DB2 database (readonly) that is used by another application, my connection string is as follows: db_tivoli =

[web2py] LOAD component, timeout and passing variables / arguments

2015-02-16 Thread Boris Aramis Aguilar Rodríguez
Hi, currently I'm using LOAD and components on a project. The problem is that when using a timeout for auto-reloading the component then the current view state is lost, let me explain: 1. A controller called performance_matrix.py has a method index(); that method receives request.vars and

Re: [web2py] Re: dal retrieve one element from auth_user results in exception when none found

2014-02-04 Thread Boris Aramis Aguilar Rodríguez
Everything is fine... it was a mistake on my behalf sorry :S it seems that i pulled some pre-compiled pyc stuff from a partner im working with that made some weird side effects; now all .pyc files are in my gitignore :) Thanks! Boris Aramis Aguilar Rodríguez Technology Projects Entrepreneur