yahoo-eng-team team mailing list archive

[Matt Riedemann <mriedem.os@xxxxxxxxx>]

It looks like the database migrations weren't run. See:

nova-manage api_db sync
nova-manage db sync

** Changed in: nova
       Status: New => Invalid

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1693059

Title:
  Error: Systemd start for openstack-nova-scheduler failed!

Status in OpenStack Compute (nova):
  Invalid

Bug description:
  following is the logs seeing on nova-scheduler.log:
  2017-05-23 20:47:25.208 21042 WARNING oslo_reports.guru_meditation_report [-] Guru meditation now registers SIGUSR1 and SIGUSR2 by default for backward compatibility. SIGUSR1 will no longer be registered in a future release, so please use SIGUSR2 to generate reports.
  2017-05-23 20:47:25.210 21042 INFO oslo_service.periodic_task [-] Skipping periodic task _discover_hosts_in_cells because its interval is negative
  2017-05-23 20:47:25.394 21042 CRITICAL nova [req-a14bbad7-1070-4595-b762-7fef5f394465 - - - - -] ProgrammingError: (pymysql.err.ProgrammingError) (1146, u"Table 'nova.aggregates' doesn't exist") [SQL: u'SELECT aggregates.created_at AS aggregates_created_at, aggregates.updated_at AS aggregates_updated_at, aggregates.deleted_at AS aggregates_deleted_at, aggregates.deleted AS aggregates_deleted, aggregates.id AS aggregates_id, aggregates.uuid AS aggregates_uuid, aggregates.name AS aggregates_name, aggregate_hosts_1.created_at AS aggregate_hosts_1_created_at, aggregate_hosts_1.updated_at AS aggregate_hosts_1_updated_at, aggregate_hosts_1.deleted_at AS aggregate_hosts_1_deleted_at, aggregate_hosts_1.deleted AS aggregate_hosts_1_deleted, aggregate_hosts_1.id AS aggregate_hosts_1_id, aggregate_hosts_1.host AS aggregate_hosts_1_host, aggregate_hosts_1.aggregate_id AS aggregate_hosts_1_aggregate_id, aggregate_metadata_1.created_at AS aggregate_metadata_1_created_at, aggregate_metadata_1.updated_at AS aggregate_metadata_1_updated_at, aggregate_metadata_1.deleted_at AS aggregate_metadata_1_deleted_at, aggregate_metadata_1.deleted AS aggregate_metadata_1_deleted, aggregate_metadata_1.id AS aggregate_metadata_1_id, aggregate_metadata_1.`key` AS aggregate_metadata_1_key, aggregate_metadata_1.value AS aggregate_metadata_1_value, aggregate_metadata_1.aggregate_id AS aggregate_metadata_1_aggregate_id \nFROM aggregates LEFT OUTER JOIN aggregate_hosts AS aggregate_hosts_1 ON aggregates.id = aggregate_hosts_1.aggregate_id AND aggregate_hosts_1.deleted = %(deleted_1)s AND aggregates.deleted = %(deleted_2)s LEFT OUTER JOIN aggregate_metadata AS aggregate_metadata_1 ON aggregates.id = aggregate_metadata_1.aggregate_id AND aggregate_metadata_1.deleted = %(deleted_3)s AND aggregates.deleted = %(deleted_4)s \nWHERE aggregates.deleted = %(deleted_5)s'] [parameters: {u'deleted_5': 0, u'deleted_4': 0, u'deleted_3': 0, u'deleted_2': 0, u'deleted_1': 0}]
  2017-05-23 20:47:25.394 21042 ERROR nova Traceback (most recent call last):
  2017-05-23 20:47:25.394 21042 ERROR nova   File "/usr/bin/nova-scheduler", line 10, in <module>
  2017-05-23 20:47:25.394 21042 ERROR nova     sys.exit(main())
  2017-05-23 20:47:25.394 21042 ERROR nova   File "/usr/lib/python2.7/site-packages/nova/cmd/scheduler.py", line 44, in main
  2017-05-23 20:47:25.394 21042 ERROR nova     topic=CONF.scheduler_topic)
  2017-05-23 20:47:25.394 21042 ERROR nova   File "/usr/lib/python2.7/site-packages/nova/service.py", line 241, in create
  2017-05-23 20:47:25.394 21042 ERROR nova     periodic_interval_max=periodic_interval_max)
  2017-05-23 20:47:25.394 21042 ERROR nova   File "/usr/lib/python2.7/site-packages/nova/service.py", line 117, in __init__
  2017-05-23 20:47:25.394 21042 ERROR nova     self.manager = manager_class(host=self.host, *args, **kwargs)
  2017-05-23 20:47:25.394 21042 ERROR nova   File "/usr/lib/python2.7/site-packages/nova/scheduler/manager.py", line 57, in __init__
  "nova-scheduler-stackpack.log" 32650L, 4774686C
  2017-05-23 21:08:36.300 39408 ERROR nova   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2751, in _execute_and_instances
  2017-05-23 21:08:36.300 39408 ERROR nova     result = conn.execute(querycontext.statement, self._params)
  2017-05-23 21:08:36.300 39408 ERROR nova   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
  2017-05-23 21:08:36.300 39408 ERROR nova     return meth(self, multiparams, params)
  2017-05-23 21:08:36.300 39408 ERROR nova   File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
  2017-05-23 21:08:36.300 39408 ERROR nova     return connection._execute_clauseelement(self, multiparams, params)
  2017-05-23 21:08:36.300 39408 ERROR nova   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
  2017-05-23 21:08:36.300 39408 ERROR nova     compiled_sql, distilled_params
  2017-05-23 21:08:36.300 39408 ERROR nova   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
  2017-05-23 21:08:36.300 39408 ERROR nova     context)
  2017-05-23 21:08:36.300 39408 ERROR nova   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
  2017-05-23 21:08:36.300 39408 ERROR nova     util.raise_from_cause(newraise, exc_info)
  2017-05-23 21:08:36.300 39408 ERROR nova   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
  2017-05-23 21:08:36.300 39408 ERROR nova     reraise(type(exception), exception, tb=exc_tb)
  2017-05-23 21:08:36.300 39408 ERROR nova   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
  2017-05-23 21:08:36.300 39408 ERROR nova     context)
  2017-05-23 21:08:36.300 39408 ERROR nova   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
  2017-05-23 21:08:36.300 39408 ERROR nova     cursor.execute(statement, parameters)
  2017-05-23 21:08:36.300 39408 ERROR nova   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in execute
  2017-05-23 21:08:36.300 39408 ERROR nova     result = self._query(query)
  2017-05-23 21:08:36.300 39408 ERROR nova   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query
  2017-05-23 21:08:36.300 39408 ERROR nova     conn.query(q)
  2017-05-23 21:08:36.300 39408 ERROR nova   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 841, in query
  2017-05-23 21:08:36.300 39408 ERROR nova     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  2017-05-23 21:08:36.300 39408 ERROR nova   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1029, in _read_query_result
  2017-05-23 21:08:36.300 39408 ERROR nova     result.read()
  2017-05-23 21:08:36.300 39408 ERROR nova   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1312, in read
  2017-05-23 21:08:36.300 39408 ERROR nova     first_packet = self.connection._read_packet()
  2017-05-23 21:08:36.300 39408 ERROR nova   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 991, in _read_packet
  2017-05-23 21:08:36.300 39408 ERROR nova     packet.check_error()
  2017-05-23 21:08:36.300 39408 ERROR nova   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error
  2017-05-23 21:08:36.300 39408 ERROR nova     err.raise_mysql_exception(self._data)
  2017-05-23 21:08:36.300 39408 ERROR nova   File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
  2017-05-23 21:08:36.300 39408 ERROR nova     raise errorclass(errno, errval)
  2017-05-23 21:08:36.300 39408 ERROR nova ProgrammingError: (pymysql.err.ProgrammingError) (1146, u"Table 'nova.aggregates' doesn't exist") [SQL: u'SELECT aggregates.created_at AS aggregates_created_at, aggregates.updated_at AS aggregates_updated_at, aggregates.deleted_at AS aggregates_deleted_at, aggregates.deleted AS aggregates_deleted, aggregates.id AS aggregates_id, aggregates.uuid AS aggregates_uuid, aggregates.name AS aggregates_name, aggregate_hosts_1.created_at AS aggregate_hosts_1_created_at, aggregate_hosts_1.updated_at AS aggregate_hosts_1_updated_at, aggregate_hosts_1.deleted_at AS aggregate_hosts_1_deleted_at, aggregate_hosts_1.deleted AS aggregate_hosts_1_deleted, aggregate_hosts_1.id AS aggregate_hosts_1_id, aggregate_hosts_1.host AS aggregate_hosts_1_host, aggregate_hosts_1.aggregate_id AS aggregate_hosts_1_aggregate_id, aggregate_metadata_1.created_at AS aggregate_metadata_1_created_at, aggregate_metadata_1.updated_at AS aggregate_metadata_1_updated_at, aggregate_metadata_1.deleted_at AS aggregate_metadata_1_deleted_at, aggregate_metadata_1.deleted AS aggregate_metadata_1_deleted, aggregate_metadata_1.id AS aggregate_metadata_1_id, aggregate_metadata_1.`key` AS aggregate_metadata_1_key, aggregate_metadata_1.value AS aggregate_metadata_1_value, aggregate_metadata_1.aggregate_id AS aggregate_metadata_1_aggregate_id \nFROM aggregates LEFT OUTER JOIN aggregate_hosts AS aggregate_hosts_1 ON aggregates.id = aggregate_hosts_1.aggregate_id AND aggregate_hosts_1.deleted = %(deleted_1)s AND aggregates.deleted = %(deleted_2)s LEFT OUTER JOIN aggregate_metadata AS aggregate_metadata_1 ON aggregates.id = aggregate_metadata_1.aggregate_id AND aggregate_metadata_1.deleted = %(deleted_3)s AND aggregates.deleted = %(deleted_4)s \nWHERE aggregates.deleted = %(deleted_5)s'] [parameters: {u'deleted_5': 0, u'deleted_4': 0, u'deleted_3': 0, u'deleted_2': 0, u'deleted_1': 0}]
  2017-05-23 21:08:36.300 39408 ERROR nova

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1693059/+subscriptions