Ask Your Question
1

All nova services throw same error while start the service

asked 2014-07-06 05:11:12 -0500

rajcoumar gravatar image

updated 2014-07-06 06:04:52 -0500

I am Working on Openstack Havana Installations. I installed Keystone, Cinder, Glance, nova-novncproxy, novnc, nova-api, nova-ajax-console-proxy, nova-cert, nova-conductor, nova-consoleauth nova-doc nova-scheduler and python-novaclient in one Virtual machine (Ubuntu 12.04 server ).

I installed nova-compute-kvm, nova-network and nova-api-metadata in the KVM machine. While starting the services I got common errors in all the service logs.

nova-scheduler log,

   2014-07-06 13:30:38.612 22579 ERROR nova.openstack.common.threadgroup [-] (ProgrammingError) (1146, "Table 'nova.services' doesn't exist") '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.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 \nFROM services \nWHERE services.deleted = %s AND services.host = %s AND services.`binary` = %s \n LIMIT %s' (0, 'osservices', 'nova-scheduler', 1)

nova-cert log,

   2014-07-06 13:32:01.263 22654 ERROR nova.openstack.common.threadgroup [-] (ProgrammingError) (1146, "Table 'nova.services' doesn't exist") '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.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 \nFROM services \nWHERE services.deleted = %s AND services.host = %s AND services.`binary` = %s \n LIMIT %s' (0, 'osservices', 'nova-cert', 1)

2014-07-06 13:32:01.263 22654 TRACE nova.openstack.common.threadgroup Traceback (most recent call last):

nova-conductor log,

  2014-07-06 13:32:52.371 22706 ERROR nova.openstack.common.threadgroup [-] (ProgrammingError) (1146, "Table 'nova.services' doesn't exist") '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.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 \nFROM services \nWHERE services.deleted = %s AND services.host = %s AND services.`binary` = %s \n LIMIT %s' (0, 'osservices', 'nova-conductor', 1)

nova-consoleauth log,

  2014-07-06 13:33:33.769 22756 ERROR nova.openstack.common.threadgroup [-] (ProgrammingError) (1146, "Table 'nova.services' doesn't exist") '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.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 \nFROM services \nWHERE services.deleted = %s AND services.host = %s AND services.`binary` = %s \n LIMIT %s' (0, 'osservices', 'nova-consoleauth', 1)

nova-network logs,

2014-07-06 15:37:22.158 7756 TRACE nova.openstack.common.threadgroup ProgrammingError: (ProgrammingError) (1146, "Table 'nova.networks' doesn't exist") 'SELECT networks.created_at AS networks_created_at, networks.updated_at AS networks_updated_at, networks.deleted_at AS networks_deleted_at, networks.deleted AS networks_deleted, networks.id AS networks_id, networks.label AS networks_label, networks.injected AS networks_injected, networks.cidr AS networks_cidr, networks.cidr_v6 AS networks_cidr_v6, networks.multi_host AS networks_multi_host, networks.gateway_v6 AS networks_gateway_v6, networks.netmask_v6 AS networks_netmask_v6, networks.netmask AS networks_netmask, networks.bridge AS networks_bridge, networks.bridge_interface AS ...
(more)
edit retag flag offensive close merge delete

Comments

Have you run "nova-manage db sync" ?

dbaxps gravatar imagedbaxps ( 2014-07-06 05:37:13 -0500 )edit

No. I am using mysql in the nova. not a sqlite

rajcoumar gravatar imagerajcoumar ( 2014-07-06 06:00:44 -0500 )edit

You are missing table nova.services. Something was done wrong during setup.

MariaDB [nova]> select * from services ;
+---------------------+---------------------+------------+----+-----------------------+------------------+-------------+--------------+----------+---------+-----------------+
| created_at          | updated_at          | deleted_at | id | host                  | binary           | topic       | report_count | disabled | deleted | disabled_reason |
+---------------------+---------------------+------------+----+-----------------------+------------------+-------------+--------------+----------+---------+-----------------+
| 2014-06-23 07:35:49 | 2014-07-06 11:09:31 | NULL       |  1 | icehouse1.localdomain | nova-consoleauth | consoleauth |        68882 |        0 |       0 | NULL            |
| 2014-06-23 07:35:49 | 2014-07-06 11:09:31 | NULL       |  2 | icehouse1.localdomain | nova-scheduler   | scheduler   |        68881 |        0 |       0 | NULL            |
| 2014-06-23 07:35:50 | 2014-07-06 11:09:30 | NULL       |  3 | icehouse1.localdomain | nova-conductor   | conductor   |        68898 |        0 |       0 | NULL            |
| 2014-06-23 07:36:05 | 2014-07-06 11:09:31 | NULL       |  4 | icehouse1.localdomain | nova-cert        | cert        |        68881 |        0 |       0 | NULL            |
| 2014-06-23 07:38:59 | 2014-07-06 11:09:26 | NULL       |  5 | icehouse2.localdomain | nova-compute     | compute     |        68750 |        0 |       0 | NULL            |
+---------------------+---------------------+------------+----+-----------------------+------------------+-------------+--------------+----------+---------+-----------------+
5 rows in set (0.00 sec)
dbaxps gravatar imagedbaxps ( 2014-07-06 06:12:03 -0500 )edit

yes i checked in the mysql nova database, its not there. db sync is needed or not in this case.

rajcoumar gravatar imagerajcoumar ( 2014-07-06 06:16:31 -0500 )edit
1

I would try drop&create from scratch :-

 mysql> create database nova;
    mysql> create user 'nova'@'localhost' identified by 'nova';
    mysql> create user 'nova'@'%' identified by 'nova';
    mysql> grant all on nova.* to 'nova'@'%';

    Then configure nova to use the DB and install the schema:

    $> echo '--sql_connection=mysql://nova:nova@localhost/nova' | sudo tee -a /etc/nova/nova.conf
    $> sudo nova-manage db sync
dbaxps gravatar imagedbaxps ( 2014-07-06 06:42:34 -0500 )edit

1 answer

Sort by ยป oldest newest most voted
1

answered 2015-01-27 00:55:44 -0500

Nova mange db_sync needs to be run. It has nothing to do with mysql or sqllite . db sync will create the tables and schema.

You need to make sure all services are stopped before you run db_sync.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2014-07-06 05:11:12 -0500

Seen: 1,804 times

Last updated: Jan 27 '15