Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Exception in thread Thread-2:
- Traceback (most recent call last):
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
- context)
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/default.py", line 436, in do_execute
- cursor.execute(statement, parameters)
- File "/usr/local/lib/python3.4/dist-packages/MySQLdb/cursors.py", line 219, in execute
- self.errorhandler(self, exc, value)
- File "/usr/local/lib/python3.4/dist-packages/MySQLdb/connections.py", line 38, in defaulterrorhandler
- raise errorvalue
- File "/usr/local/lib/python3.4/dist-packages/MySQLdb/cursors.py", line 205, in execute
- r = self._query(query)
- File "/usr/local/lib/python3.4/dist-packages/MySQLdb/cursors.py", line 372, in _query
- rowcount = self._do_query(q)
- File "/usr/local/lib/python3.4/dist-packages/MySQLdb/cursors.py", line 336, in _do_query
- db.query(q)
- File "/usr/local/lib/python3.4/dist-packages/MySQLdb/connections.py", line 282, in query
- _mysql.connection.query(self, query)
- _mysql_exceptions.OperationalError: (2013, 'Lost connection to MySQL server during query')
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "/home/koby/hg/datascience/redshift_etl/extract.py", line 132, in run
- clickmeta = extractor.extract_clickmeta()
- File "/home/koby/hg/datascience/redshift_etl/extract.py", line 68, in extract_clickmeta
- return tables.TableRecord(self.mysql, self.app_id, 'clickmeta', filename, self.timeframe)
- File "/home/koby/hg/datascience/redshift_etl/tables.py", line 15, in __init__
- self.job_id = self.initiate_sql_log()
- File "/home/koby/hg/datascience/redshift_etl/tables.py", line 41, in initiate_sql_log
- date_end=self.timeframe.end
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/base.py", line 729, in execute
- return meth(self, multiparams, params)
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/sql/elements.py", line 322, in _execute_on_connection
- return connection._execute_clauseelement(self, multiparams, params)
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/base.py", line 826, in _execute_clauseelement
- compiled_sql, distilled_params
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
- context)
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/base.py", line 1159, in _handle_dbapi_exception
- exc_info
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/util/compat.py", line 188, in raise_from_cause
- reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/util/compat.py", line 181, in reraise
- raise value.with_traceback(tb)
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
- context)
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/default.py", line 436, in do_execute
- cursor.execute(statement, parameters)
- File "/usr/local/lib/python3.4/dist-packages/MySQLdb/cursors.py", line 219, in execute
- self.errorhandler(self, exc, value)
- File "/usr/local/lib/python3.4/dist-packages/MySQLdb/connections.py", line 38, in defaulterrorhandler
- raise errorvalue
- File "/usr/local/lib/python3.4/dist-packages/MySQLdb/cursors.py", line 205, in execute
- r = self._query(query)
- File "/usr/local/lib/python3.4/dist-packages/MySQLdb/cursors.py", line 372, in _query
- rowcount = self._do_query(q)
- File "/usr/local/lib/python3.4/dist-packages/MySQLdb/cursors.py", line 336, in _do_query
- db.query(q)
- File "/usr/local/lib/python3.4/dist-packages/MySQLdb/connections.py", line 282, in query
- _mysql.connection.query(self, query)
- sqlalchemy.exc.OperationalError: (OperationalError) (2013, 'Lost connection to MySQL server during query') b'INSERT INTO ******removed
- During handling of the above exception, another exception occurred:
- Traceback (most recent call last):
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/strategies.py", line 90, in connect
- return dialect.connect(*cargs, **cparams)
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/default.py", line 377, in connect
- return self.dbapi.connect(*cargs, **cparams)
- File "/usr/local/lib/python3.4/dist-packages/MySQLdb/__init__.py", line 81, in Connect
- return Connection(*args, **kwargs)
- File "/usr/local/lib/python3.4/dist-packages/MySQLdb/connections.py", line 206, in __init__
- super(Connection, self).__init__(*args, **kwargs2)
- _mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'IP_ADDRESS' (110)")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "/usr/lib/python3.4/threading.py", line 920, in _bootstrap_inner
- self.run()
- File "/home/koby/hg/datascience/redshift_etl/extract.py", line 135, in run
- clickmeta = extractor.extract_clickmeta()
- File "/home/koby/hg/datascience/redshift_etl/extract.py", line 57, in extract_clickmeta
- mycxn = self.engine.connect()
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/base.py", line 1778, in connect
- return self._connection_cls(self, **kwargs)
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/base.py", line 60, in __init__
- self.__connection = connection or engine.raw_connection()
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/base.py", line 1847, in raw_connection
- return self.pool.unique_connection()
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/pool.py", line 280, in unique_connection
- return _ConnectionFairy._checkout(self)
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/pool.py", line 644, in _checkout
- fairy = _ConnectionRecord.checkout(pool)
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/pool.py", line 442, in checkout
- dbapi_connection = rec.get_connection()
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/pool.py", line 506, in get_connection
- self.connection = self.__connect()
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/pool.py", line 538, in __connect
- connection = self.__pool._creator()
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/strategies.py", line 96, in connect
- connection_invalidated=invalidated
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/util/compat.py", line 188, in raise_from_cause
- reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/util/compat.py", line 181, in reraise
- raise value.with_traceback(tb)
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/strategies.py", line 90, in connect
- return dialect.connect(*cargs, **cparams)
- File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/default.py", line 377, in connect
- return self.dbapi.connect(*cargs, **cparams)
- File "/usr/local/lib/python3.4/dist-packages/MySQLdb/__init__.py", line 81, in Connect
- return Connection(*args, **kwargs)
- File "/usr/local/lib/python3.4/dist-packages/MySQLdb/connections.py", line 206, in __init__
- super(Connection, self).__init__(*args, **kwargs2)
- sqlalchemy.exc.OperationalError: (OperationalError) (2003, "Can't connect to MySQL server on 'IP_ADDRESS' (110)") None None
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement