Baremetal instance launch fails with "no valid host found" error [closed]

asked 2014-02-14 12:34:21 -0500

anonymous user

Anonymous

updated 2014-02-14 12:57:47 -0500

I am using devstack for an openstack with bar metal installation.

The instance launch fails with "No valid host"

From the nova compute log i see the following: 2014-02-14 13:15:17.913 ^[[01;31mERROR nova.openstack.common.periodic_task [^[[00;36m-^[[01;31m] ^[[01;35m^[[01;31mError during ComputeManager.update_available_resource: Remote error: DBError (ProgrammingError) (1064, 'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \': "\'x86_64\'", u\'baremetal_driver\': "\'nova.virt.baremetal.pxe.PXE\'"})\' at line 1') 'INSERT INTO compute_nodes (created_at, updated_at, deleted_at, deleted, service_id, vcpus, memory_mb, local_gb, vcpus_used, memory_mb_used, local_gb_used, hypervisor_type, hypervisor_version, hypervisor_hostname, free_ram_mb, free_disk_gb, current_workload, running_vms, cpu_info, disk_available_least, host_ip, supported_instances, metrics, pci_stats, extra_resources, stats) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)' (datetime.datetime(2014, 2, 14, 18, 15, 17, 906482), None, None, 0, 7, 12, 16384, 769, 0, 0, 0, 'baremetal', 1, '0fc943ed-09a6-4b68-a5c9-93a3ea8aa6ab', 16384, 769, 0, 0, 'baremetal cpu', None, ''10.0.1.4" '[["x86_64", "baremetal", "baremetal"]]', '[]', '[]', None, {u'cpu_arch': u'x86_64', u'baremetal_driver': u'nova.virt.baremetal.pxe.PXE'}) [u'Traceback (most recent call last):\n', u' File "/opt/stack/oslo.messaging/oslo/messaging/_executors/base.py", line 36, in _dispatch\n incoming.reply(self.callback(incoming.ctxt, incoming.message))\n', u' File "/opt/stack/oslo.messaging/oslo/messaging/rpc/dispatcher.py", line 134, in __call__\n return self._dispatch(endpoint, method, ctxt, args)\n', u' File "/opt/stack/oslo.messaging/oslo/messaging/rpc/dispatcher.py", line 104, in _dispatch\n result = getattr(endpoint, method)(ctxt, *new_args)\n', u' File "/opt/stack/nova/nova/conductor/manager.py", line 452, in compute_node_create\n result = self.db.compute_node_create(context, values)\n', u' File "/opt/stack/nova/nova/db/api.py", line 213, in compute_node_create\n return IMPL.compute_node_create(context, values)\n', u' File "/opt/stack/nova/nova/db/sqlalchemy/api.py", line 110, in wrapper\n return f(args, **kwargs)\n', u' File "/opt/stack/nova/nova/db/sqlalchemy/api.py", line 595, in compute_node_create\n compute_node_ref.save()\n', u' File "/opt/stack/nova/nova/openstack/common/db/sqlalchemy/models.py", line 51, in save\n session.flush()\n', u' File "/opt/stack/nova/nova/openstack/common/db/sqlalchemy/session.py", line 616, in _wrap\n raise exception.DBError(e)\n', u'DBError: (ProgrammingError) (1064, \'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \\': "\\'x86_64\\'", u\\'baremetal_driver\\': "\\'nova.virt.baremetal.pxe.PXE\\'"})\\' at line 1\') \'INSERT INTO compute_nodes (created_at, updated_at, deleted_at, deleted, service_id, vcpus, memory_mb, local_gb, vcpus_used, memory_mb_used, local_gb_used, hypervisor_type, hypervisor_version, hypervisor_hostname, free_ram_mb, free_disk_gb, current_workload, running_vms, cpu_info, disk_available_least, host_ip, supported_instances, metrics, pci_stats, extra_resources, stats) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)\' (datetime.datetime(2014, 2, 14, 18, 15, 17 ... (more)

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by opstkusr
close date 2014-02-15 08:28:39.463358

Comments

I am using devstack and havana for this.The entry gets added in bm_node but addition to compute_nodes in nova db fails. Would really appreciate any help on this.

opstkusr gravatar imageopstkusr ( 2014-02-14 16:31:47 -0500 )edit