Advertisement
Guest User

Untitled

a guest
Dec 22nd, 2014
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.37 KB | None | 0 0
  1. Exception in thread Thread-2:
  2. Traceback (most recent call last):
  3. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
  4. context)
  5. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/default.py", line 436, in do_execute
  6. cursor.execute(statement, parameters)
  7. File "/usr/local/lib/python3.4/dist-packages/MySQLdb/cursors.py", line 219, in execute
  8. self.errorhandler(self, exc, value)
  9. File "/usr/local/lib/python3.4/dist-packages/MySQLdb/connections.py", line 38, in defaulterrorhandler
  10. raise errorvalue
  11. File "/usr/local/lib/python3.4/dist-packages/MySQLdb/cursors.py", line 205, in execute
  12. r = self._query(query)
  13. File "/usr/local/lib/python3.4/dist-packages/MySQLdb/cursors.py", line 372, in _query
  14. rowcount = self._do_query(q)
  15. File "/usr/local/lib/python3.4/dist-packages/MySQLdb/cursors.py", line 336, in _do_query
  16. db.query(q)
  17. File "/usr/local/lib/python3.4/dist-packages/MySQLdb/connections.py", line 282, in query
  18. _mysql.connection.query(self, query)
  19. _mysql_exceptions.OperationalError: (2013, 'Lost connection to MySQL server during query')
  20.  
  21. The above exception was the direct cause of the following exception:
  22.  
  23. Traceback (most recent call last):
  24. File "/home/koby/hg/datascience/redshift_etl/extract.py", line 132, in run
  25. clickmeta = extractor.extract_clickmeta()
  26. File "/home/koby/hg/datascience/redshift_etl/extract.py", line 68, in extract_clickmeta
  27. return tables.TableRecord(self.mysql, self.app_id, 'clickmeta', filename, self.timeframe)
  28. File "/home/koby/hg/datascience/redshift_etl/tables.py", line 15, in __init__
  29. self.job_id = self.initiate_sql_log()
  30. File "/home/koby/hg/datascience/redshift_etl/tables.py", line 41, in initiate_sql_log
  31. date_end=self.timeframe.end
  32. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/base.py", line 729, in execute
  33. return meth(self, multiparams, params)
  34. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/sql/elements.py", line 322, in _execute_on_connection
  35. return connection._execute_clauseelement(self, multiparams, params)
  36. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/base.py", line 826, in _execute_clauseelement
  37. compiled_sql, distilled_params
  38. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
  39. context)
  40. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/base.py", line 1159, in _handle_dbapi_exception
  41. exc_info
  42. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/util/compat.py", line 188, in raise_from_cause
  43. reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
  44. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/util/compat.py", line 181, in reraise
  45. raise value.with_traceback(tb)
  46. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
  47. context)
  48. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/default.py", line 436, in do_execute
  49. cursor.execute(statement, parameters)
  50. File "/usr/local/lib/python3.4/dist-packages/MySQLdb/cursors.py", line 219, in execute
  51. self.errorhandler(self, exc, value)
  52. File "/usr/local/lib/python3.4/dist-packages/MySQLdb/connections.py", line 38, in defaulterrorhandler
  53. raise errorvalue
  54. File "/usr/local/lib/python3.4/dist-packages/MySQLdb/cursors.py", line 205, in execute
  55. r = self._query(query)
  56. File "/usr/local/lib/python3.4/dist-packages/MySQLdb/cursors.py", line 372, in _query
  57. rowcount = self._do_query(q)
  58. File "/usr/local/lib/python3.4/dist-packages/MySQLdb/cursors.py", line 336, in _do_query
  59. db.query(q)
  60. File "/usr/local/lib/python3.4/dist-packages/MySQLdb/connections.py", line 282, in query
  61. _mysql.connection.query(self, query)
  62. sqlalchemy.exc.OperationalError: (OperationalError) (2013, 'Lost connection to MySQL server during query') b'INSERT INTO ******removed
  63.  
  64. During handling of the above exception, another exception occurred:
  65.  
  66. Traceback (most recent call last):
  67. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/strategies.py", line 90, in connect
  68. return dialect.connect(*cargs, **cparams)
  69. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/default.py", line 377, in connect
  70. return self.dbapi.connect(*cargs, **cparams)
  71. File "/usr/local/lib/python3.4/dist-packages/MySQLdb/__init__.py", line 81, in Connect
  72. return Connection(*args, **kwargs)
  73. File "/usr/local/lib/python3.4/dist-packages/MySQLdb/connections.py", line 206, in __init__
  74. super(Connection, self).__init__(*args, **kwargs2)
  75. _mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'IP_ADDRESS' (110)")
  76.  
  77. The above exception was the direct cause of the following exception:
  78.  
  79. Traceback (most recent call last):
  80. File "/usr/lib/python3.4/threading.py", line 920, in _bootstrap_inner
  81. self.run()
  82. File "/home/koby/hg/datascience/redshift_etl/extract.py", line 135, in run
  83. clickmeta = extractor.extract_clickmeta()
  84. File "/home/koby/hg/datascience/redshift_etl/extract.py", line 57, in extract_clickmeta
  85. mycxn = self.engine.connect()
  86. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/base.py", line 1778, in connect
  87. return self._connection_cls(self, **kwargs)
  88. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/base.py", line 60, in __init__
  89. self.__connection = connection or engine.raw_connection()
  90. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/base.py", line 1847, in raw_connection
  91. return self.pool.unique_connection()
  92. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/pool.py", line 280, in unique_connection
  93. return _ConnectionFairy._checkout(self)
  94. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/pool.py", line 644, in _checkout
  95. fairy = _ConnectionRecord.checkout(pool)
  96. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/pool.py", line 442, in checkout
  97. dbapi_connection = rec.get_connection()
  98. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/pool.py", line 506, in get_connection
  99. self.connection = self.__connect()
  100. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/pool.py", line 538, in __connect
  101. connection = self.__pool._creator()
  102. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/strategies.py", line 96, in connect
  103. connection_invalidated=invalidated
  104. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/util/compat.py", line 188, in raise_from_cause
  105. reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
  106. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/util/compat.py", line 181, in reraise
  107. raise value.with_traceback(tb)
  108. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/strategies.py", line 90, in connect
  109. return dialect.connect(*cargs, **cparams)
  110. File "/usr/local/lib/python3.4/dist-packages/sqlalchemy/engine/default.py", line 377, in connect
  111. return self.dbapi.connect(*cargs, **cparams)
  112. File "/usr/local/lib/python3.4/dist-packages/MySQLdb/__init__.py", line 81, in Connect
  113. return Connection(*args, **kwargs)
  114. File "/usr/local/lib/python3.4/dist-packages/MySQLdb/connections.py", line 206, in __init__
  115. super(Connection, self).__init__(*args, **kwargs2)
  116. 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