Full traceback of the error from the engine log: 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters [-] DBAPIError exception wrapped from (pymysql.err.ProgrammingError) (1064, u"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}, processed=1 WHERE task_executions_v2.id = 'e4bb9204-7706-47c6-a742-b29d964c01' at line 1") [SQL: u'UPDATE task_executions_v2 SET updated_at=%(updated_at)s, state=%(state)s, state_info=%(state_info)s, processed=%(processed)s WHERE task_executions_v2.id = %(task_executions_v2_id)s'] [parameters: {'state_info': {}, 'state': 'ERROR', 'processed': 1, 'updated_at': datetime.datetime(2016, 11, 28, 9, 43, 2, 283039), 'task_executions_v2_id': u'e4bb9204-7706-47c6-a742-b29d964c01c3'}] 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last): 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters context) 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters) 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in execute 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters result = self._query(query) 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters conn.query(q) 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 841, in query 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered) 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1029, in _read_query_result 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters result.read() 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1312, in read 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters first_packet = self.connection._read_packet() 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 991, in _read_packet 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters packet.check_error() 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters err.raise_mysql_exception(self._data) 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters raise errorclass(errno, errval) 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters ProgrammingError: (1064, u"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}, processed=1 WHERE task_executions_v2.id = 'e4bb9204-7706-47c6-a742-b29d964c01' at line 1") 2016-11-28 09:43:02.283 19586 ERROR oslo_db.sqlalchemy.exc_filters 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server [-] Exception during message handling 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server Traceback (most recent call last): 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/oslo_messaging/rpc/server.py", line 155, in _process_incoming 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server res = self.dispatcher.dispatch(message) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py", line 225, in dispatch 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server return self._do_dispatch(endpoint, method, ctxt, args) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py", line 195, in _do_dispatch 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server result = func(ctxt, **new_args) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/mistral/engine/rpc_backend/rpc.py", line 203, in on_action_complete 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server return self._engine.on_action_complete(action_ex_id, result, wf_action) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/mistral/engine/action_queue.py", line 70, in decorate 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server res = func(*args, **kw) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/mistral/utils/__init__.py", line 118, in _logged 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server return func(*args, **kw) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/osprofiler/profiler.py", line 154, in wrapper 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server return f(*args, **kwargs) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/mistral/engine/default_engine.py", line 122, in on_action_complete 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server action_handler.on_action_complete(action_ex, result) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/osprofiler/profiler.py", line 154, in wrapper 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server return f(*args, **kwargs) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/mistral/engine/action_handler.py", line 54, in on_action_complete 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server task_handler.schedule_on_action_complete(action_ex) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/mistral/engine/task_handler.py", line 360, in schedule_on_action_complete 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server _on_action_complete(action_ex) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/osprofiler/profiler.py", line 154, in wrapper 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server return f(*args, **kwargs) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/mistral/engine/task_handler.py", line 105, in _on_action_complete 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server task.on_action_complete(action_ex) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/osprofiler/profiler.py", line 154, in wrapper 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server return f(*args, **kwargs) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/mistral/engine/tasks.py", line 265, in on_action_complete 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server self.complete(state, state_info) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/osprofiler/profiler.py", line 154, in wrapper 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server return f(*args, **kwargs) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/mistral/engine/tasks.py", line 193, in complete 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server dispatcher.dispatch_workflow_commands(self.wf_ex, cmds) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/osprofiler/profiler.py", line 154, in wrapper 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server return f(*args, **kwargs) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/mistral/engine/dispatcher.py", line 94, in dispatch_workflow_commands 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server task_handler.run_task(cmd) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/osprofiler/profiler.py", line 154, in wrapper 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server return f(*args, **kwargs) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/mistral/engine/task_handler.py", line 58, in run_task 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server task.run() 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/osprofiler/profiler.py", line 154, in wrapper 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server return f(*args, **kwargs) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/mistral/engine/tasks.py", line 270, in run 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server self._run_new() 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/mistral/engine/tasks.py", line 280, in _run_new 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server self._create_task_execution() 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/mistral/engine/tasks.py", line 231, in _create_task_execution 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server self.task_ex = db_api.create_task_execution(values) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/mistral/db/v2/api.py", line 324, in create_task_execution 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server return IMPL.create_task_execution(values) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/mistral/db/sqlalchemy/base.py", line 118, in _within_session 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server result = func(*args, **kw) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/mistral/db/v2/sqlalchemy/api.py", line 886, in create_task_execution 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server task_ex.save(session=session) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/models.py", line 48, in save 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server session.flush() 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2027, in flush 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server self._flush(objects) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2145, in _flush 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server transaction.rollback(_capture_exception=True) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__ 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server compat.reraise(exc_type, exc_value, exc_tb) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2109, in _flush 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server flush_context.execute() 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server rec.execute(self) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server uow 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 170, in save_obj 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server mapper, table, update) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 706, in _emit_update_statements 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server execute(statement, multiparams) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server return meth(self, multiparams, params) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server return connection._execute_clauseelement(self, multiparams, params) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server compiled_sql, distilled_params 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server context) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server util.raise_from_cause(newraise, exc_info) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server reraise(type(exception), exception, tb=exc_tb) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server context) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server cursor.execute(statement, parameters) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in execute 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server result = self._query(query) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server conn.query(q) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 841, in query 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server self._affected_rows = self._read_query_result(unbuffered=unbuffered) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1029, in _read_query_result 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server result.read() 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1312, in read 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server first_packet = self.connection._read_packet() 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 991, in _read_packet 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server packet.check_error() 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server err.raise_mysql_exception(self._data) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server raise errorclass(errno, errval) 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server DBError: (pymysql.err.ProgrammingError) (1064, u"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}, processed=1 WHERE task_executions_v2.id = 'e4bb9204-7706-47c6-a742-b29d964c01' at line 1") [SQL: u'UPDATE task_executions_v2 SET updated_at=%(updated_at)s, state=%(state)s, state_info=%(state_info)s, processed=%(processed)s WHERE task_executions_v2.id = %(task_executions_v2_id)s'] [parameters: {'state_info': {}, 'state': 'ERROR', 'processed': 1, 'updated_at': datetime.datetime(2016, 11, 28, 9, 43, 2, 283039), 'task_executions_v2_id': u'e4bb9204-7706-47c6-a742-b29d964c01c3'}] 2016-11-28 09:43:02.286 19586 ERROR oslo_messaging.rpc.server