Ask Your Question

Havana baremetal failure during instance launch

asked 2014-02-15 07:42:32 -0500

opstkusr gravatar image

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, ''" '[["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/", line 36, in _dispatch\n incoming.reply(self.callback(incoming.ctxt, incoming.message))\n', u' File "/opt/stack/oslo.messaging/oslo/messaging/rpc/", line 134, in __call__\n return self._dispatch(endpoint, method, ctxt, args)\n', u' File "/opt/stack/oslo.messaging/oslo/messaging/rpc/", line 104, in _dispatch\n result = getattr(endpoint, method)(ctxt, *new_args)\n', u' File "/opt/stack/nova/nova/conductor/", line 452, in compute_node_create\n result = self.db.compute_node_create(context, values)\n', u' File "/opt/stack/nova/nova/db/", line 213, in compute_node_create\n return IMPL.compute_node_create(context, values)\n', u' File "/opt/stack/nova/nova/db/sqlalchemy/", line 110, in wrapper\n return f(args, **kwargs)\n', u' File "/opt/stack/nova/nova/db/sqlalchemy/", line 595, in compute_node_create\n\n', u' File "/opt/stack/nova/nova/openstack/common/db/sqlalchemy/", line 51, in save\n session.flush()\n', u' File "/opt/stack/nova/nova/openstack/common/db/sqlalchemy/", 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?


edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted

answered 2014-02-27 22:32:10 -0500

xu-haiwei gravatar image

I am afraid you haven't create the baremetal database, you should check that first.

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


Asked: 2014-02-15 07:42:32 -0500

Seen: 120 times

Last updated: Feb 27 '14