Hello,
I'm having "Connection timed out" to mysql server.
I'm creating a sheet from some queries. The function is in a module, and
running it from console.
Sometimes, it goes OK, but sometimes I get the error (see below).
I'm using EC2 and the database is in RDS.
Thanks for any help...
Marcello
-----
Traceback (most recent call last):
File "/home/tecno2/web2py/gluon/shell.py", line 206, in run
execfile(startfile, _env)
File "applications/segundarj/private/diario.py", line 2, in <module>
planilha.roda(True)
File "applications/segundarj/modules/planilha.py", line 64, in roda
print "aba: %s, total: %s" % (aba,processos.count())
File "/home/tecno2/web2py/gluon/dal.py", line 7573, in count
return self.db._adapter.count(self.query,distinct)
File "/home/tecno2/web2py/gluon/dal.py", line 1339, in count
self.execute(self._count(query, distinct))
File "/home/tecno2/web2py/gluon/dal.py", line 1392, in execute
return self.log_execute(*a, **b)
File "/home/tecno2/web2py/gluon/dal.py", line 1386, in log_execute
ret = self.cursor.execute(*a, **b)
File "/home/tecno2/web2py/gluon/contrib/pymysql/cursors.py", line 108, in
execute
self.errorhandler(self, exc, value)
File "/home/tecno2/web2py/gluon/contrib/pymysql/connections.py", line
182, in defaulterrorhandler
raise Error(errorclass, errorvalue)
Error: (<class 'socket.error'>, error(110, 'Connection timed out'))
Traceback (most recent call last):
File "web2py.py", line 20, in <module>
gluon.widget.start(cron=True)
File "/home/tecno2/web2py/gluon/widget.py", line 868, in start
import_models=options.import_models, startfile=options.run)
File "/home/tecno2/web2py/gluon/shell.py", line 210, in run
if import_models: BaseAdapter.close_all_instances('rollback')
File "/home/tecno2/web2py/gluon/dal.py", line 432, in close_all_instances
getattr(instance, action)()
File "/home/tecno2/web2py/gluon/dal.py", line 1357, in rollback
return self.connection.rollback()
File "/home/tecno2/web2py/gluon/contrib/pymysql/connections.py", line
571, in rollback
self.errorhandler(None, exc, value)
File "/home/tecno2/web2py/gluon/contrib/pymysql/connections.py", line
182, in defaulterrorhandler
raise Error(errorclass, errorvalue)
gluon.contrib.pymysql.err.Error: (<class 'socket.error'>, error(32, 'Broken
pipe'))
