MOS 9.2
Attempt to delete the env in fuel:
receiverd.log contains the following traceback
2018-10-16 12:29:32.764 ERROR [7f9029472740] (receiverd) Message consume failed: <kombu.transport.pyamqp.Message object at 0x4754050>
Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/nailgun/rpc/receiverd.py", line 54, in consume_msg
callback(**body["args"])
File "/usr/lib/python2.7/site-packages/nailgun/rpc/receiver.py", line 211, in remove_cluster_resp
objects.Cluster.delete(cluster)
File "/usr/lib/python2.7/site-packages/nailgun/objects/cluster.py", line 277, in delete
fire_callback_on_cluster_delete(instance)
File "/usr/lib/python2.7/site-packages/nailgun/extensions/manager.py", line 125, in fire_callback_on_cluster_delete
extension.on_cluster_delete(cluster)
File "/usr/lib/python2.7/site-packages/cluster_upgrade/extension.py", line 50, in on_cluster_delete
relations.UpgradeRelationObject.delete_relation(cluster.id)
File "/usr/lib/python2.7/site-packages/cluster_upgrade/objects/relations.py", line 35, in delete_relation
cls._query_cluster_relations(cluster_id).delete()
File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 3048, in delete
delete_op.exec_()
File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 1127, in exec_
self._do_exec()
File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 1311, in _do_exec
mapper=self.mapper)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 1034, in execute
bind, close_with_result=True).execute(clause, params or {})
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)
ProgrammingError: (psycopg2.ProgrammingError) relation "cluster_upgrade_relations" does not exist
LINE 1: DELETE FROM cluster_upgrade_relations WHERE cluster_upgrade_...
^
[SQL: 'DELETE FROM cluster_upgrade_relations WHERE cluster_upgrade_relations.orig_cluster_id = %(orig_cluster_id_1)s OR cluster_upgrade_relations.seed_cluster_id = %(seed_cluster_id_1)s'] [parameters: {'orig_clu
ster_id_1': 37, 'seed_cluster_id_1': 37}]
Will share the snapshot and logs shortly
From logs and the traceback I see that there is fuel-nailgun- extension- cluster- upgrade installed and seems it was installed either before the upgrading to 9.2 or it's just incompatible with 9.2 DB schema. In either case this extension is not supported on 9.2 and should be removed. After removal it should work fine. If after removal it still doesn't work, feel free to re-open the bug.