"openstack compute service list" still seaching for resulat and nothing displayed

asked 2018-11-22 08:34:28 -0500

najeh gravatar image

updated 2018-11-22 09:16:05 -0500

When i tried this command on the controller node" openstack compute service list" nothing is listed for me the process still searching for result

And the command "nova-status upgrade check " display these errors

File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py", line 54, in cache ret = fn(self, con, args, *kw) File "/usr/lib/python2.7/dist-packages/sqlalchemy/dialects/mysql/base.py", line 2172, in _setup_parser full_name=full_name)

File "/usr/lib/python2.7/dist-packages/sqlalchemy/dialects/mysql/base.py", line 2267, in _show_create_table raise exc.NoSuchTableError(full_name)

NoSuchTableError: compute_nodes

the /var/log/nova/nova-consoleauth.log file show these errors:

MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION _check_effective_sql_mode /usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py:308 2018-11-22 12:34:19.089 1971 ERROR oslo_service.service [req-1f8ba796-dfb2-443c-ae7a-3febc6e9e95f - - - - -] Error starting thread.: ProgrammingError: (pymysql.err.ProgrammingError) (1146, u"Table 'nova.services' doesn't exist") [SQL: u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.disabled_reason AS services_disabled_reason, services.last_seen_up AS services_last_seen_up, services.forced_down AS services_forced_down, services.version AS services_version \nFROM services \nWHERE services.deleted = %(deleted_1)s AND services.host = %(host_1)s AND services.binary= %(binary_1)s \n LIMIT %(param_1)s'] [parameters: {u'host_1': 'Controller', u'param_1': 1, u'deleted_1': 0, u'binary_1': 'nova-consoleauth'}] (Background on this error at: http://sqlalche.me/e/f405) 2018-11-22 12:34:19.089 1971 ERROR oslo_service.service Traceback (most recent call last): 2018-11-22 12:34:19.089 1971 ERROR oslo_service.service File "/usr/lib/python2.7/dist-packages/oslo_service/service.py", line 794, in run_service 2018-11-22 12:34:19.089 1971 ERROR oslo_service.service service.start() 2018-11-22 12:34:19.089 1971 ERROR oslo_service.service File "/usr/lib/python2.7/dist-packages/nova/service.py", line 166, in start 2018-11-22 12:34:19.089 1971 ERROR oslo_service.service ctxt, self.host, self.binary) 2018-11-22 12:34:19.089 1971 ERROR oslo_service.service File "/usr/lib/python2.7/dist-packages/oslo_versionedobjects/base.py", line 184, in wrapper 2018-11-22 12:34:19.089 1971 ERROR oslo_service.service result = fn(cls, context, args, *kwargs) 2018-11-22 12:34:19.089 1971 ERROR oslo_service.service File "/usr/lib/python2.7/dist-packages/nova/objects/service.py", line 329, in get_by_host_and_binary 2018-11-22 12:34:19.089 1971 ERROR oslo_service.service host, binary) 2018-11-22 12:34:19.089 1971 ERROR oslo_service.service File "/usr/lib/python2.7/dist-packages/nova/db/api.py", line 127, in service_get_by_host_and_binary 2018-11-22 12:34:19.089 1971 ERROR oslo_service.service return IMPL.service_get_by_host_and_binary(context, host, binary) 2018-11-22 12:34:19.089 1971 ERROR oslo_service.service File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 253, in wrapped 2018-11-22 12:34:19.089 1971 ERROR oslo_service.service return f(context, args, *kwargs) 2018-11-22 12:34:19.089 1971 ERROR oslo_service.service File "/usr/lib/python2 ... (more)

edit retag flag offensive close merge delete