it's strange then that I received the timeout error in the shell. Is this a bug, or is there another possible cause?
On Sep 15, 12:07 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > No timeout does not apply to the shell. > > On Sep 14, 6:56 pm, Richard <richar...@gmail.com> wrote: > > > I was in the shell (hence the ">>>") when I received this error. > > Does --timeout=TIMEOUT also apply to the shell? > > > Richard > > > On Sep 15, 12:10 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > You can can increase timeout (web2py.py -h) or, better, use the shell > > > > python web2py.py -S yourapp -M > > > > >>> db.export_to_csv_file(open('/path/to/file.csv','wb')) > > > > On Sep 14, 3:02 am, Richard <richar...@gmail.com> wrote: > > > > > hello, > > > > > I was trying out the export recipe in ch 6.8 of the manual and > > > > received a timeout error: > > > > > >>> fp = open('20090914.db', 'wb') > > > > >>> db.export_to_csv_file(fp) > > > > > Traceback (most recent call last): > > > > File "<console>", line 1, in <module> > > > > 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 <lambda> > > > > self._execute = lambda *a, **b: self._cursor.execute(*a, **b) > > > > ProgrammingError: canceling statement due to statement timeout > > > > > The database is quite big so I guess that is causing the timeout. Is > > > > there a way to export large databases with web2py? > > > > > Richard > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---