search

alfonsodg / demo-web2py

Apache License 2.0
0 stars 0 forks source link

timeout errors in shell #54

Closed alfonsodg closed 10 years ago

alfonsodg commented 10 years ago

From richar...@gmail.com on September 23, 2009 20:06:30

I am getting timeout errors in the shell, which should apparently should only happen for the web interface: http://groups.google.com/group/web2py/browse_thread/thread/927a6efcabe1c67c An example:

$ python web2py.py --import_models --no-cron --shell=myapp

fp = open('dump.sql', 'wb') db.export_to_csv_file(fp)

Traceback (most recent call last): File "", line 1, in File "/home/web2py/gluon/sql.py", line 1056, in export_to_csv_file self(self[table].id > 0).select().export_to_csv_file(ofile) File "/home/web2py/gluon/sql.py", line 2212, in select r = response(query) File "/home/web2py/gluon/sql.py", line 2207, in response self._db._execute(query) File "/home/web2py/gluon/sql.py", line 770, in self._execute = lambda _a, _b: self._cursor.execute(_a, _b) ProgrammingError: canceling statement due to statement timeout

Original issue: http://code.google.com/p/web2py/issues/detail?id=55

alfonsodg commented 10 years ago

From massimod...@gmail.com on October 26, 2009 06:40:36

What kind of database. This may be a sqlite timeout. Perhaps we can increase it.

alfonsodg commented 10 years ago

From richar...@gmail.com on October 26, 2009 15:53:17

I believe it was postgres

alfonsodg commented 10 years ago

From massimod...@gmail.com on November 28, 2009 20:52:30

I could use some help debugging this. I do not know what the database session timeouts.

Status: Accepted

alfonsodg commented 10 years ago

From massimod...@gmail.com on January 24, 2010 11:02:19

Any news? Technically this is an error originiated from the database, not from web2py.

Status: Started

alfonsodg commented 10 years ago

From richar...@gmail.com on January 24, 2010 14:29:47

Maybe it can't be fixed then. My Postgres SQL took about a minute to complete, but I often (though not always) got interrupted by that timeout.

alfonsodg commented 10 years ago

From massimod...@gmail.com on January 24, 2010 14:39:00

Perhaps this help. http://www.linuxquestions.org/questions/linux-software-2/timeout-after-30s-apachephppostgresql-102261/ http://forum.webfaction.com/viewtopic.php?id=1276 I am closing the ticket because this is clearly not a web2py specific issue.

Status: Invalid