Steps to reproduce:
1) Add this commit to the Fuel master node: https://review.openstack.org/#/c/370080/, which helps to add default graphs sequence.
2) Execute 'ln -sf /etc/puppet/modules /etc/fuel/graphs/deploy'
3) ./upload-default-sequence.sh
Actual results:
Script is failed:
[root@nailgun files]# ./upload-default-sequence.sh
Deployment graph was successfully uploaded.
500 Server Error: Internal Server Error for url: http://10.109.0.2:8000/api/v1/releases/2/deployment_graphs/deploy (Unexpected exception, please check logs)
From separate run:
[root@nailgun ~]# fuel2 graph upload -r2 -t deploy -d /etc/fuel/graphs/deploy
500 Server Error: Internal Server Error for url: http://10.109.0.2:8000/api/v1/releases/2/deployment_graphs/deploy (Unexpected exception, please check logs)
From /var/log/nailgun/app.log:
2016-12-09 09:58:03.270 ERROR [7f77247fa880] (deployment_graph) POST failed: (psycopg2.IntegrityError) duplicate key value violates unique constraint "_task_name_deployment_graph_id_uc"
DETAIL: Key (deployment_graph_id, task_name)=(13, pre_deployment_start) already exists.
[SQL: 'INSERT INTO deployment_graph_tasks (deployment_graph_id, task_name, version, condition, type, groups, tasks, roles, reexecute_on, refresh_on, required_for, requires, cross_depended_by, cross_depends, parameters, _custom) VALUES (%(deployment_graph_id)s, %(task_name)s, %(version)s, %(condition)s, %(type)s, %(groups)s, %(tasks)s, %(roles)s, %(reexecute_on)s, %(refresh_on)s, %(required_for)s, %(requires)s, %(cross_depended_by)s, %(cross_depends)s, %(parameters)s, %(_custom)s) RETURNING deployment_graph_tasks.id'] [parameters: {'reexecute_on': [], 'tasks': [], 'groups': [], 'roles': [], 'type': u'stage', 'cross_depended_by': '[]', 'refresh_on': [], 'required_for': [], 'version': '1.0.0', 'task_name': u'pre_deployment_start', 'deployment_graph_id': 13, 'parameters': '{}', 'requires': [], 'cross_depends': '[]', 'condition': None, '_custom': '{}'}]
Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/nailgun/api/v1/handlers/deployment_graph.py", line 96, in POST
data, obj, graph_type=graph_type)
File "/usr/lib/python2.7/site-packages/nailgun/objects/deployment_graph.py", line 179, in create_for_model
graph = cls.create(data)
File "/usr/lib/python2.7/site-packages/nailgun/objects/deployment_graph.py", line 124, in create
db().flush()
File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2019, in flush
self._flush(objects)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2137, in _flush
transaction.rollback(_capture_exception=True)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2101, in _flush
flush_context.execute()
File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute
rec.execute(self)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute
uow
File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj
mapper, table, insert)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 800, in _emit_insert_statements
execute(statement, params)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
cursor.execute(statement, parameters)
IntegrityError: (psycopg2.IntegrityError) duplicate key value violates unique constraint "_task_name_deployment_graph_id_uc"
DETAIL: Key (deployment_graph_id, task_name)=(13, pre_deployment_start) already exists
Reproducibility:
Reproducible on 9.2 snapshot #604.
Additional information:
These patches are required for upload-default-sequence.sh, I've added manually before launching of script:
https://review.openstack.org/#/c/370076/
https://review.openstack.org/#/c/370082/
https://review.openstack.org/#/c/370085/
This bug appears during verification of bug https:/