All nova services throw same error while start the service
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 ...
Have you run "nova-manage db sync" ?
No. I am using mysql in the nova. not a sqlite
You are missing table nova.services. Something was done wrong during setup.
yes i checked in the mysql nova database, its not there. db sync is needed or not in this case.
I would try drop&create from scratch :-