I'd need to test it again, but when I added excel-like exports my users
were downloading ~50mb of files without hiccups (MSSQL though).....
*lost connection during query* seems to point the finger towards mysql not
shipping data fast enough than web2py not fast enough to handle its
serialization..... did you try raising the timeout in the driver (or
requesting less data) ?
On Friday, March 15, 2013 3:19:11 PM UTC+1, Jonathan Lundell wrote:
>
> On 15 Mar 2013, at 6:45 AM, Jonathan Lundell <jlun...@pobox.com<javascript:>>
> wrote:
>
> I'm trying to export a largish (270K records) MySQL table via the grid or
> administrative export-csv functions. In both cases, I get an error after a
> fairly long wait; I'm assuming it's a connection timeout.
>
> Traceback (most recent call last):
> File "/home/wupadmin/.virtualenvs/watchup/watchup/web2py/gluon/main.py",
> line 523, in wsgibase
> BaseAdapter.close_all_instances('commit')
> File "/home/wupadmin/.virtualenvs/watchup/watchup/web2py/gluon/dal.py",
> line 447, in close_all_instances
> getattr(instance, action)()
> File "/home/wupadmin/.virtualenvs/watchup/watchup/web2py/gluon/dal.py",
> line 1430, in commit
> return self.connection.commit()
> File
> "/home/wupadmin/.virtualenvs/watchup/watchup/web2py/gluon/contrib/pymysql/connections.py",
> line 562, in commit
> self.errorhandler(None, exc, value)
> File
> "/home/wupadmin/.virtualenvs/watchup/watchup/web2py/gluon/contrib/pymysql/connections.py",
> line 184, in defaulterrorhandler
> raise errorclass, errorvalue
> OperationalError: (2013, 'Lost connection to MySQL server during query')
>
>
>
> Should I just increase a timeout value somewhere (and if so, where?), or
> is there a better way to do this? FWIW, a gzipped mysqldump of the entire
> database is only 22MB, so we're not talking ridiculously large files here.
>
>
> FWIW: this is a fairly conventional setup, running RHEL6 on a Rackspace
> cloud server, with MySQL on a separate virtual machine.
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
