gistfile1.txt

DEBUG:root:The MESSAGE is NOT LOCAL and with id 99c06dda-34a3-4666-aebf-e7de7a6b94cc
/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py:574: SAWarning: Unicode type received non-unicode bind param value.
  processors[key](compiled_params[key])
/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/type_api.py:860: SAWarning: Unicode type received non-unicode bind param value.
  return impl_processor(process_param(value, dialect))
ERROR:frestq.app:Exception on /api/queues/orchestra_performer/ [POST]
Traceback (most recent call last):
  File "/home/eorchestra/venv/local/lib/python2.7/site-packages/flask/app.py", line 1817, in wsgi_app
    response = self.full_dispatch_request()
  File "/home/eorchestra/venv/local/lib/python2.7/site-packages/flask/app.py", line 1477, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/home/eorchestra/venv/local/lib/python2.7/site-packages/flask/app.py", line 1381, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/home/eorchestra/venv/local/lib/python2.7/site-packages/flask/app.py", line 1475, in full_dispatch_request
    rv = self.dispatch_request()
  File "/home/eorchestra/venv/local/lib/python2.7/site-packages/flask/app.py", line 1461, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "build/bdist.linux-x86_64/egg/frestq/api.py", line 119, in post_message
    db.session.commit()
  File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/scoping.py", line 149, in do
    return getattr(self.registry(), name)(*args, **kwargs)
  File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 765, in commit
    self.transaction.commit()
  File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 370, in commit
    self._prepare_impl()
  File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 350, in _prepare_impl
    self.session.flush()
  File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1879, in flush
    self._flush(objects)
  File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1997, in _flush
    transaction.rollback(_capture_exception=True)
  File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 57, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1961, in _flush
    flush_context.execute()
  File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 370, in execute
    rec.execute(self)
  File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 523, in execute
    uow
  File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 64, in save_obj
    mapper, table, insert)
  File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 562, in _emit_insert_statements
    execute(statement, multiparams)
  File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 717, in execute
    return meth(self, multiparams, params)
  File "/home/eorchestra/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/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 814, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 927, in _execute_context
    context)
  File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1076, in _handle_dbapi_exception
    exc_info
  File "/home/eorchestra/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/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 920, in _execute_context
    context)
  File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 425, in do_execute
    cursor.execute(statement, parameters)
IntegrityError: (IntegrityError) insert or update on table "message" violates foreign key constraint "message_task_id_fkey"
DETAIL:  Key (task_id)=(74c0067c-d4d7-4368-8a1a-b9d55c2b4ea3) is not present in table "task".
 'INSERT INTO message (id, sender_url, queue_name, is_received, receiver_url, sender_ssl_cert, receiver_ssl_cert, created_date, action, input_data, output_
status, pingback_date, expiration_date, info_text, task_id) VALUES (%(id)s, %(sender_url)s, %(queue_name)s, %(is_received)s, %(receiver_url)s, %(sender_ssl
_cert)s, %(receiver_ssl_cert)s, %(created_date)s, %(action)s, %(input_data)s, %(output_status)s, %(pingback_date)s, %(expiration_date)s, %(info_text)s, %(t
ask_id)s)' {'receiver_url': 'https://agoravoting-eovm-2:5000/api/queues', 'sender_url': u'https://agoravoting-eovm:5000/api/queues', 'output_status': 200,
'task_id': u'74c0067c-d4d7-4368-8a1a-b9d55c2b4ea3', 'info_text': None, 'expiration_date': None, 'queue_name': u'orchestra_performer', 'pingback_date': None
, 'receiver_ssl_cert': None, 'input_data': '{"is_recurring": false, "threshold_parties": 3, "num_parties": 3, "sessions": [{"stub": "\\n<!-- ATTENTION! WE