Skip to content

Instantly share code, notes, and snippets.

@mosquito
Created August 7, 2014 15:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mosquito/6be6020a5cc8fcd23ff1 to your computer and use it in GitHub Desktop.
Save mosquito/6be6020a5cc8fcd23ff1 to your computer and use it in GitHub Desktop.
15:42:27 default: mcnm.tasks.bulkload.load_offers(3667) (85d06d55-f47b-437d-bbf2-e52a65668583)
15:42:28 Getting knaker/knaker_bro.7z from ftp
15:42:29 Got knaker/knaker_bro.7z from ftp (380985 bytes)
15:42:29 task#3667: can't get file
Traceback (most recent call last):
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/mcnm/tasks/bulkload.py", line 83, in load_offers
file_path = task.bulkload_source.s3_upload()
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/mcnm/models/bulkloads.py", line 100, in s3_upload
dest_dir='%s/bulkload' % self.partner.slug,
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 233, in __get__
return self.impl.get(instance_state(instance), dict_)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 579, in get
value = self.callable_(state, passive)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 506, in _load_for_state
return self._emit_lazyload(session, state, ident_key, passive)
File "<string>", line 1, in <lambda>
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 550, in _emit_lazyload
return loading.load_on_ident(q, ident_key)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 230, in load_on_ident
return q.one()
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2361, in one
ret = list(self)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2404, in __iter__
return self._execute_and_instances(context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2419, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 720, in execute
return meth(self, multiparams, params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 317, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 817, in _execute_clauseelement
compiled_sql, distilled_params
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 947, in _execute_context
context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1108, in _handle_dbapi_exception
exc_info
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 185, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 940, in _execute_context
context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 435, in do_execute
cursor.execute(statement, parameters)
ProgrammingError: (ProgrammingError) column partners.user_id does not exist
LINE 1: ... AS partners_phone, partners.fax AS partners_fax, partners.u...
^
'SELECT partners.id AS partners_id, partners.created_at AS partners_created_at, partners.updated_at AS partners_updated_at, partners.name AS partners_name, partners.description AS partners_description, partners.slug AS partners_slug, partners.subdomain AS partners_subdomain, partners.logo_url AS partners_logo_url, partners.phone AS partners_phone, partners.fax AS partners_fax, partners.user_id AS partners_user_id, partners.manager_id AS partners_manager_id, partners.state_id AS partners_state_id, partners._acl_object_id AS partners__acl_object_id \nFROM partners \nWHERE partners.id = %(param_1)s' {'param_1': 7}
15:42:30 task#3667: retry 1
15:42:30 Getting knaker/knaker_bro.7z from ftp
15:42:31 Got knaker/knaker_bro.7z from ftp (380985 bytes)
15:42:31 task#3667: can't get file
Traceback (most recent call last):
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/mcnm/tasks/bulkload.py", line 83, in load_offers
file_path = task.bulkload_source.s3_upload()
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/mcnm/models/bulkloads.py", line 100, in s3_upload
dest_dir='%s/bulkload' % self.partner.slug,
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 233, in __get__
return self.impl.get(instance_state(instance), dict_)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 579, in get
value = self.callable_(state, passive)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 506, in _load_for_state
return self._emit_lazyload(session, state, ident_key, passive)
File "<string>", line 1, in <lambda>
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 550, in _emit_lazyload
return loading.load_on_ident(q, ident_key)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 230, in load_on_ident
return q.one()
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2361, in one
ret = list(self)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2404, in __iter__
return self._execute_and_instances(context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2419, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 720, in execute
return meth(self, multiparams, params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 317, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 817, in _execute_clauseelement
compiled_sql, distilled_params
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 947, in _execute_context
context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1108, in _handle_dbapi_exception
exc_info
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 185, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 940, in _execute_context
context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 435, in do_execute
cursor.execute(statement, parameters)
InternalError: (InternalError) current transaction is aborted, commands ignored until end of transaction block
'SELECT partners.id AS partners_id, partners.created_at AS partners_created_at, partners.updated_at AS partners_updated_at, partners.name AS partners_name, partners.description AS partners_description, partners.slug AS partners_slug, partners.subdomain AS partners_subdomain, partners.logo_url AS partners_logo_url, partners.phone AS partners_phone, partners.fax AS partners_fax, partners.user_id AS partners_user_id, partners.manager_id AS partners_manager_id, partners.state_id AS partners_state_id, partners._acl_object_id AS partners__acl_object_id \nFROM partners \nWHERE partners.id = %(param_1)s' {'param_1': 7}
15:42:35 task#3667: retry 2
15:42:36 Getting knaker/knaker_bro.7z from ftp
15:42:37 Got knaker/knaker_bro.7z from ftp (380985 bytes)
15:42:37 task#3667: can't get file
Traceback (most recent call last):
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/mcnm/tasks/bulkload.py", line 83, in load_offers
file_path = task.bulkload_source.s3_upload()
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/mcnm/models/bulkloads.py", line 100, in s3_upload
dest_dir='%s/bulkload' % self.partner.slug,
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 233, in __get__
return self.impl.get(instance_state(instance), dict_)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 579, in get
value = self.callable_(state, passive)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 506, in _load_for_state
return self._emit_lazyload(session, state, ident_key, passive)
File "<string>", line 1, in <lambda>
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 550, in _emit_lazyload
return loading.load_on_ident(q, ident_key)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 230, in load_on_ident
return q.one()
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2361, in one
ret = list(self)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2404, in __iter__
return self._execute_and_instances(context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2419, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 720, in execute
return meth(self, multiparams, params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 317, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 817, in _execute_clauseelement
compiled_sql, distilled_params
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 947, in _execute_context
context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1108, in _handle_dbapi_exception
exc_info
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 185, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 940, in _execute_context
context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 435, in do_execute
cursor.execute(statement, parameters)
InternalError: (InternalError) current transaction is aborted, commands ignored until end of transaction block
'SELECT partners.id AS partners_id, partners.created_at AS partners_created_at, partners.updated_at AS partners_updated_at, partners.name AS partners_name, partners.description AS partners_description, partners.slug AS partners_slug, partners.subdomain AS partners_subdomain, partners.logo_url AS partners_logo_url, partners.phone AS partners_phone, partners.fax AS partners_fax, partners.user_id AS partners_user_id, partners.manager_id AS partners_manager_id, partners.state_id AS partners_state_id, partners._acl_object_id AS partners__acl_object_id \nFROM partners \nWHERE partners.id = %(param_1)s' {'param_1': 7}
15:42:40 task#3667: retry 3
15:42:41 Getting knaker/knaker_bro.7z from ftp
15:42:42 Got knaker/knaker_bro.7z from ftp (380985 bytes)
15:42:42 task#3667: can't get file
Traceback (most recent call last):
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/mcnm/tasks/bulkload.py", line 83, in load_offers
file_path = task.bulkload_source.s3_upload()
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/mcnm/models/bulkloads.py", line 100, in s3_upload
dest_dir='%s/bulkload' % self.partner.slug,
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 233, in __get__
return self.impl.get(instance_state(instance), dict_)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 579, in get
value = self.callable_(state, passive)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 506, in _load_for_state
return self._emit_lazyload(session, state, ident_key, passive)
File "<string>", line 1, in <lambda>
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 550, in _emit_lazyload
return loading.load_on_ident(q, ident_key)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 230, in load_on_ident
return q.one()
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2361, in one
ret = list(self)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2404, in __iter__
return self._execute_and_instances(context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2419, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 720, in execute
return meth(self, multiparams, params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 317, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 817, in _execute_clauseelement
compiled_sql, distilled_params
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 947, in _execute_context
context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1108, in _handle_dbapi_exception
exc_info
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 185, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 940, in _execute_context
context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 435, in do_execute
cursor.execute(statement, parameters)
InternalError: (InternalError) current transaction is aborted, commands ignored until end of transaction block
'SELECT partners.id AS partners_id, partners.created_at AS partners_created_at, partners.updated_at AS partners_updated_at, partners.name AS partners_name, partners.description AS partners_description, partners.slug AS partners_slug, partners.subdomain AS partners_subdomain, partners.logo_url AS partners_logo_url, partners.phone AS partners_phone, partners.fax AS partners_fax, partners.user_id AS partners_user_id, partners.manager_id AS partners_manager_id, partners.state_id AS partners_state_id, partners._acl_object_id AS partners__acl_object_id \nFROM partners \nWHERE partners.id = %(param_1)s' {'param_1': 7}
15:42:46 task#3667: retry 4
15:42:46 Getting knaker/knaker_bro.7z from ftp
15:42:47 Got knaker/knaker_bro.7z from ftp (380985 bytes)
15:42:47 task#3667: can't get file
Traceback (most recent call last):
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/mcnm/tasks/bulkload.py", line 83, in load_offers
file_path = task.bulkload_source.s3_upload()
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/mcnm/models/bulkloads.py", line 100, in s3_upload
dest_dir='%s/bulkload' % self.partner.slug,
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 233, in __get__
return self.impl.get(instance_state(instance), dict_)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 579, in get
value = self.callable_(state, passive)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 506, in _load_for_state
return self._emit_lazyload(session, state, ident_key, passive)
File "<string>", line 1, in <lambda>
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 550, in _emit_lazyload
return loading.load_on_ident(q, ident_key)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 230, in load_on_ident
return q.one()
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2361, in one
ret = list(self)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2404, in __iter__
return self._execute_and_instances(context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2419, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 720, in execute
return meth(self, multiparams, params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 317, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 817, in _execute_clauseelement
compiled_sql, distilled_params
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 947, in _execute_context
context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1108, in _handle_dbapi_exception
exc_info
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 185, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 940, in _execute_context
context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 435, in do_execute
cursor.execute(statement, parameters)
InternalError: (InternalError) current transaction is aborted, commands ignored until end of transaction block
'SELECT partners.id AS partners_id, partners.created_at AS partners_created_at, partners.updated_at AS partners_updated_at, partners.name AS partners_name, partners.description AS partners_description, partners.slug AS partners_slug, partners.subdomain AS partners_subdomain, partners.logo_url AS partners_logo_url, partners.phone AS partners_phone, partners.fax AS partners_fax, partners.user_id AS partners_user_id, partners.manager_id AS partners_manager_id, partners.state_id AS partners_state_id, partners._acl_object_id AS partners__acl_object_id \nFROM partners \nWHERE partners.id = %(param_1)s' {'param_1': 7}
15:42:49 task#3667: retry 5
15:42:50 Getting knaker/knaker_bro.7z from ftp
15:42:51 Got knaker/knaker_bro.7z from ftp (380985 bytes)
15:42:51 task#3667: can't get file
Traceback (most recent call last):
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/mcnm/tasks/bulkload.py", line 83, in load_offers
file_path = task.bulkload_source.s3_upload()
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/mcnm/models/bulkloads.py", line 100, in s3_upload
dest_dir='%s/bulkload' % self.partner.slug,
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 233, in __get__
return self.impl.get(instance_state(instance), dict_)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 579, in get
value = self.callable_(state, passive)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 506, in _load_for_state
return self._emit_lazyload(session, state, ident_key, passive)
File "<string>", line 1, in <lambda>
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 550, in _emit_lazyload
return loading.load_on_ident(q, ident_key)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 230, in load_on_ident
return q.one()
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2361, in one
ret = list(self)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2404, in __iter__
return self._execute_and_instances(context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2419, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 720, in execute
return meth(self, multiparams, params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 317, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 817, in _execute_clauseelement
compiled_sql, distilled_params
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 947, in _execute_context
context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1108, in _handle_dbapi_exception
exc_info
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 185, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 940, in _execute_context
context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 435, in do_execute
cursor.execute(statement, parameters)
InternalError: (InternalError) current transaction is aborted, commands ignored until end of transaction block
'SELECT partners.id AS partners_id, partners.created_at AS partners_created_at, partners.updated_at AS partners_updated_at, partners.name AS partners_name, partners.description AS partners_description, partners.slug AS partners_slug, partners.subdomain AS partners_subdomain, partners.logo_url AS partners_logo_url, partners.phone AS partners_phone, partners.fax AS partners_fax, partners.user_id AS partners_user_id, partners.manager_id AS partners_manager_id, partners.state_id AS partners_state_id, partners._acl_object_id AS partners__acl_object_id \nFROM partners \nWHERE partners.id = %(param_1)s' {'param_1': 7}
15:42:56 task#3667: retry 6
15:42:56 Getting knaker/knaker_bro.7z from ftp
15:42:57 Got knaker/knaker_bro.7z from ftp (380985 bytes)
15:42:57 task#3667: can't get file
Traceback (most recent call last):
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/mcnm/tasks/bulkload.py", line 83, in load_offers
file_path = task.bulkload_source.s3_upload()
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/mcnm/models/bulkloads.py", line 100, in s3_upload
dest_dir='%s/bulkload' % self.partner.slug,
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 233, in __get__
return self.impl.get(instance_state(instance), dict_)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 579, in get
value = self.callable_(state, passive)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 506, in _load_for_state
return self._emit_lazyload(session, state, ident_key, passive)
File "<string>", line 1, in <lambda>
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 550, in _emit_lazyload
return loading.load_on_ident(q, ident_key)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 230, in load_on_ident
return q.one()
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2361, in one
ret = list(self)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2404, in __iter__
return self._execute_and_instances(context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2419, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 720, in execute
return meth(self, multiparams, params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 317, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 817, in _execute_clauseelement
compiled_sql, distilled_params
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 947, in _execute_context
context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1108, in _handle_dbapi_exception
exc_info
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 185, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 940, in _execute_context
context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 435, in do_execute
cursor.execute(statement, parameters)
InternalError: (InternalError) current transaction is aborted, commands ignored until end of transaction block
'SELECT partners.id AS partners_id, partners.created_at AS partners_created_at, partners.updated_at AS partners_updated_at, partners.name AS partners_name, partners.description AS partners_description, partners.slug AS partners_slug, partners.subdomain AS partners_subdomain, partners.logo_url AS partners_logo_url, partners.phone AS partners_phone, partners.fax AS partners_fax, partners.user_id AS partners_user_id, partners.manager_id AS partners_manager_id, partners.state_id AS partners_state_id, partners._acl_object_id AS partners__acl_object_id \nFROM partners \nWHERE partners.id = %(param_1)s' {'param_1': 7}
15:43:00 task#3667: retry 7
15:43:01 Getting knaker/knaker_bro.7z from ftp
15:43:02 Got knaker/knaker_bro.7z from ftp (380985 bytes)
15:43:02 task#3667: can't get file
Traceback (most recent call last):
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/mcnm/tasks/bulkload.py", line 83, in load_offers
file_path = task.bulkload_source.s3_upload()
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/mcnm/models/bulkloads.py", line 100, in s3_upload
dest_dir='%s/bulkload' % self.partner.slug,
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 233, in __get__
return self.impl.get(instance_state(instance), dict_)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 579, in get
value = self.callable_(state, passive)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 506, in _load_for_state
return self._emit_lazyload(session, state, ident_key, passive)
File "<string>", line 1, in <lambda>
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 550, in _emit_lazyload
return loading.load_on_ident(q, ident_key)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 230, in load_on_ident
return q.one()
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2361, in one
ret = list(self)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2404, in __iter__
return self._execute_and_instances(context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2419, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 720, in execute
return meth(self, multiparams, params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 317, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 817, in _execute_clauseelement
compiled_sql, distilled_params
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 947, in _execute_context
context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1108, in _handle_dbapi_exception
exc_info
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 185, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 940, in _execute_context
context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 435, in do_execute
cursor.execute(statement, parameters)
InternalError: (InternalError) current transaction is aborted, commands ignored until end of transaction block
'SELECT partners.id AS partners_id, partners.created_at AS partners_created_at, partners.updated_at AS partners_updated_at, partners.name AS partners_name, partners.description AS partners_description, partners.slug AS partners_slug, partners.subdomain AS partners_subdomain, partners.logo_url AS partners_logo_url, partners.phone AS partners_phone, partners.fax AS partners_fax, partners.user_id AS partners_user_id, partners.manager_id AS partners_manager_id, partners.state_id AS partners_state_id, partners._acl_object_id AS partners__acl_object_id \nFROM partners \nWHERE partners.id = %(param_1)s' {'param_1': 7}
15:43:07 task#3667: retry 8
15:43:07 Getting knaker/knaker_bro.7z from ftp
15:43:08 Got knaker/knaker_bro.7z from ftp (380985 bytes)
15:43:08 task#3667: can't get file
Traceback (most recent call last):
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/mcnm/tasks/bulkload.py", line 83, in load_offers
file_path = task.bulkload_source.s3_upload()
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/mcnm/models/bulkloads.py", line 100, in s3_upload
dest_dir='%s/bulkload' % self.partner.slug,
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 233, in __get__
return self.impl.get(instance_state(instance), dict_)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 579, in get
value = self.callable_(state, passive)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 506, in _load_for_state
return self._emit_lazyload(session, state, ident_key, passive)
File "<string>", line 1, in <lambda>
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 550, in _emit_lazyload
return loading.load_on_ident(q, ident_key)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 230, in load_on_ident
return q.one()
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2361, in one
ret = list(self)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2404, in __iter__
return self._execute_and_instances(context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2419, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 720, in execute
return meth(self, multiparams, params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 317, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 817, in _execute_clauseelement
compiled_sql, distilled_params
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 947, in _execute_context
context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1108, in _handle_dbapi_exception
exc_info
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 185, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 940, in _execute_context
context)
File "/home/mcnmrq/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 435, in do_execute
cursor.execute(statement, parameters)
InternalError: (InternalError) current transaction is aborted, commands ignored until end of transaction block
'SELECT partners.id AS partners_id, partners.created_at AS partners_created_at, partners.updated_at AS partners_updated_at, partners.name AS partners_name, partners.description AS partners_description, partners.slug AS partners_slug, partners.subdomain AS partners_subdomain, partners.logo_url AS partners_logo_url, partners.phone AS partners_phone, partners.fax AS partners_fax, partners.user_id AS partners_user_id, partners.manager_id AS partners_manager_id, partners.state_id AS partners_state_id, partners._acl_object_id AS partners__acl_object_id \nFROM partners \nWHERE partners.id = %(param_1)s' {'param_1': 7}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment