Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Havana baremetal failure during instance launch

Working on getting a havana bare metal install with single controller/compute node controlling a bare metal node.

Saw that the instance creation was failing with "No valid host found" error.

On further analysis of the logs it is seen that the addition of the compute_node info in the db is failing. 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\')

Any pointers on how to address this?

Thanks