[Openstack] the question about nova.sqlite

Li, Rujun rujun.li at intel.com
Mon Jul 17 12:18:06 UTC 2017


Hi all

I have followed the director on the page https://docs.openstack.org/ocata/install-guide-ubuntu/nova-verify.html but when inputting command nova-manage cell_v2 discover_hosts, it shows that there is no table called "computer_nodes" in my "nova" database.
I delete the /var/lib/nova/nova.sqlite and then "nova-manage db sync", then I check the nova database, it shows that I have such a table.
But when I run the command, it seems that the nova.sqlite will always be created, and the error occur again
Here is the output:
DBNonExistentTable: (sqlite3.OperationalError) no such table: compute_nodes [SQL: u'SELECT cn.created_at, cn.updated_at, cn.deleted_at, cn.deleted, cn.id, cn.service_id, cn.host, cn.uuid, cn.vcpus, cn.memory_mb, cn.local_gb, cn.vcpus_used, cn.memory_mb_used, cn.local_gb_used, cn.hypervisor_type, cn.hypervisor_version, cn.hypervisor_hostname, cn.free_ram_mb, cn.free_disk_gb, cn.current_workload, cn.running_vms, cn.cpu_info, cn.disk_available_least, cn.host_ip, cn.supported_instances, cn.metrics, cn.pci_stats, cn.extra_resources, cn.stats, cn.numa_topology, cn.ram_allocation_ratio, cn.cpu_allocation_ratio, cn.disk_allocation_ratio \nFROM compute_nodes AS cn \nWHERE cn.deleted = ? ORDER BY cn.id ASC'] [parameters: (0,)]

I have checked that all the settings in the configuration file is the same as in the director.

Best Wishes,
Rujun, Li

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20170717/4d7bdad5/attachment.html>


More information about the Openstack mailing list