Hi All,
I’ve had a production instance of Stackstorm running for quite a while untouched, and I have gone to try
and run a Mistral workflow on it, and I am getting a failure with the following error.
{
"traceback": " File \"/opt/stackstorm/st2/lib/python2.7/site-packages/st2actions/container/base.py\", line 127, in _do_run
(status, result, context) = runner.run(action_params)
File \"/opt/stackstorm/st2/lib/python2.7/site-packages/retrying.py\", line 49, in wrapped_f
return Retrying(*dargs, **dkw).call(f, *args, **kw)
File \"/opt/stackstorm/st2/lib/python2.7/site-packages/retrying.py\", line 206, in call
return attempt.get(self._wrap_exception)
File \"/opt/stackstorm/st2/lib/python2.7/site-packages/retrying.py\", line 247, in get
six.reraise(self.value[0], self.value[1], self.value[2])
File \"/opt/stackstorm/st2/lib/python2.7/site-packages/retrying.py\", line 200, in call\n attempt = Attempt(fn(*args, **kwargs), attempt_number, False)
File \"/opt/stackstorm/runners/mistral_v2/mistral_v2/mistral_v2.py\", line 247, in run
result = self.start_workflow(action_parameters=action_parameters)
File \"/opt/stackstorm/runners/mistral_v2/mistral_v2/mistral_v2.py\", line 253, in start_workflow
self._client.workflows.list()\n File \"/opt/stackstorm/st2/lib/python2.7/site-packages/mistralclient/api/v2/workflows.py\", line 102, in list
response_key='workflows',
File \"/opt/stackstorm/st2/lib/python2.7/site-packages/mistralclient/api/base.py\", line 125, in _list\n self._raise_api_exception(resp)
File \"/opt/stackstorm/st2/lib/python2.7/site-packages/mistralclient/api/base.py\", line 160, in _raise_api_exception
error_message=error_data)
",
"error": "(psycopg2.ProgrammingError) column workflow_definitions_v2.namespace does not exist
LINE 1: ...2.is_system AS workflow_definitions_v2_is_system, workflow_d...
^
[SQL: 'SELECT workflow_definitions_v2.scope AS workflow_definitions_v2_scope, workflow_definitions_v2.project_id AS workflow_definitions_v2_project_id, workflow_definitions_v2.created_at AS workflow_definitions_v2_created_at, workflow_definitions_v2.updated_at AS workflow_definitions_v2_updated_at, workflow_definitions_v2.id AS workflow_definitions_v2_id, workflow_definitions_v2.name AS workflow_definitions_v2_name, workflow_definitions_v2.definition AS workflow_definitions_v2_definition, workflow_definitions_v2.spec AS workflow_definitions_v2_spec, workflow_definitions_v2.tags AS workflow_definitions_v2_tags, workflow_definitions_v2.is_system AS workflow_definitions_v2_is_system, workflow_definitions_v2.namespace AS workflow_definitions_v2_namespace \
FROM workflow_definitions_v2 \
WHERE workflow_definitions_v2.project_id = %(project_id_1)s OR workflow_definitions_v2.scope = %(scope_1)s ORDER BY workflow_definitions_v2.created_at ASC'] [parameters: {'project_id_1': '<default-project>', 'scope_1': 'public'}] (Background on this error at: http://sqlalche.me/e/f405)"
}
I understand the error, however I am not sure how solve. I can’t seem to connect to the database using the password that is set in /etc/mistral/mistral.conf, but all the services appear to come up and run OK.
Also, it is worth noting:
-
I am not sure if mistral workflows have ever worked on this server - I’ve never run them on there before.
-
If this can’t be resolved, I can always uninstall everything (st2, postgres, mongo, etc) and start from scratch