2014-02-12 03:20:04.687 3322 ERROR nova.openstack.common.periodic_task [-] Error during ComputeManager.update_available_resource: Remote er
ror: DBError (ProgrammingError) (1064, 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versio
n for the right syntax to use near \': "\'i386\'", u\'baremetal_driver\': "\'nova.virt.baremetal.pxe.PXE\'"})\' at line 1') 'INSERT INTO co
mpute_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_availa
ble_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, 12, 3, 20, 4, 677066), None, None, 0, 5, 1, 2048, 20
, 0, 0, 0, 'baremetal', 1, '31cd3256-111b-49e8-bd78-4dc279ce2ee9', 2048, 20, 0, 0, 'baremetal cpu', None, '192.0.2.3', '[["i386", "baremeta
l", "baremetal"]]', '[]', '[]', None, {u'cpu_arch': u'i386', u'baremetal_driver': u'nova.virt.baremetal.pxe.PXE'})
[u'Traceback (most recent call last):\n', u'  File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/oslo/messaging/_executors/base.
py", line 36, in _dispatch\n    incoming.reply(self.callback(incoming.ctxt, incoming.message))\n', u'  File "/opt/stack/venvs/nova/local/li
b/python2.7/site-packages/oslo/messaging/rpc/dispatcher.py", line 134, in __call__\n    return self._dispatch(endpoint, method, ctxt, args)
\n', u'  File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/oslo/messaging/rpc/dispatcher.py", line 104, in _dispatch\n    resul
t = getattr(endpoint, method)(ctxt, **new_args)\n', u'  File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/nova/conductor/manage
r.py", line 452, in compute_node_create\n    result = self.db.compute_node_create(context, values)\n', u'  File "/opt/stack/venvs/nova/loca
l/lib/python2.7/site-packages/nova/db/api.py", line 213, in compute_node_create\n    return IMPL.compute_node_create(context, values)\n', u
'  File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 110, in wrapper\n    return f(*args, **kw
args)\n', u'  File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 595, in compute_node_create\n
   compute_node_ref.save()\n', u'  File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/nova/openstack/common/db/sqlalchemy/models
.py", line 51, in save\n    session.flush()\n', u'  File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/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 MySQL server version for the right syntax to use near \\\': "\\\'i386\\\'", u\\\
'baremetal_driver\\\': "\\\'nova.virt.baremetal.pxe.PXE\\\'"})\\\' at line 1\') \'INSERT INTO compute_nodes (created_at, updated_at, delete
d_at, deleted, service_id, vcpus, memory_mb, local_gb, vcpus_used, memory_mb_used, local_gb_used, hypervisor_type, hypervisor_version, hype
rvisor_hostname, free_ram_mb, free_disk_gb, current_workload, running_vms, cpu_info, disk_available_least, host_ip, supported_instances, me
trics, 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, 12, 3, 20, 4, 677066), None, None, 0, 5, 1, 2048, 20, 0, 0, 0, \'baremetal\', 1, \'31cd3256-11
1b-49e8-bd78-4dc279ce2ee9\', 2048, 20, 0, 0, \'baremetal cpu\', None, \'192.0.2.3\', \'[["i386", "baremetal", "baremetal"]]\', \'[]\', \'[]
\', None, {u\'cpu_arch\': u\'i386\', u\'baremetal_driver\': u\'nova.virt.baremetal.pxe.PXE\'})\n'].
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task Traceback (most recent call last):
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task   File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/nova
/openstack/common/periodic_task.py", line 182, in run_periodic_tasks
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task     task(self, context)
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task   File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/nova
/compute/manager.py", line 5121, in update_available_resource
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task     rt.update_available_resource(context)
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task   File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/nova
/openstack/common/lockutils.py", line 249, in inner
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task     return f(*args, **kwargs)
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task   File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/nova
/compute/resource_tracker.py", line 353, in update_available_resource
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task     self._sync_compute_node(context, resources)
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task   File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/nova
/compute/resource_tracker.py", line 376, in _sync_compute_node
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task     self._create(context, resources)
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task   File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/nova
/compute/resource_tracker.py", line 392, in _create
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task     values)
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task   File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/nova/conductor/api.py", line 237, in compute_node_create
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task     return self._manager.compute_node_create(context, values)
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task   File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/nova/conductor/rpcapi.py", line 357, in compute_node_create
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task     return cctxt.call(context, 'compute_node_create', values=values)
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task   File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/oslo/messaging/rpc/client.py", line 150, in call
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task     wait_for_reply=True, timeout=timeout)
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task   File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/oslo/messaging/transport.py", line 87, in _send
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task     timeout=timeout)
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task   File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/oslo/messaging/_drivers/amqpdriver.py", line 390, in send
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task     return self._send(target, ctxt, message, wait_for_reply, timeout)
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task   File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/oslo/messaging/_drivers/amqpdriver.py", line 383, in _send
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task     raise result
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task RemoteError: Remote error: DBError (ProgrammingError) (1064, 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \': "\'i386\'", 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, 12, 3, 20, 4, 677066), None, None, 0, 5, 1, 2048, 20, 0, 0, 0, 'baremetal', 1, '31cd3256-111b-49e8-bd78-4dc279ce2ee9', 2048, 20, 0, 0, 'baremetal cpu', None, '192.0.2.3', '[["i386", "baremetal", "baremetal"]]', '[]', '[]', None, {u'cpu_arch': u'i386', u'baremetal_driver': u'nova.virt.baremetal.pxe.PXE'})
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task [u'Traceback (most recent call last):\n', u'  File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/oslo/messaging/_executors/base.py", line 36, in _dispatch\n    incoming.reply(self.callback(incoming.ctxt, incoming.message))\n', u'  File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/oslo/messaging/rpc/dispatcher.py", line 134, in __call__\n    return self._dispatch(endpoint, method, ctxt, args)\n', u'  File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/oslo/messaging/rpc/dispatcher.py", line 104, in _dispatch\n    result = getattr(endpoint, method)(ctxt, **new_args)\n', u'  File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/nova/conductor/manager.py", line 452, in compute_node_create\n    result = self.db.compute_node_create(context, values)\n', u'  File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/nova/db/api.py", line 213, in compute_node_create\n    return IMPL.compute_node_create(context, values)\n', u'  File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 110, in wrapper\n    return f(*args, **kwargs)\n', u'  File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 595, in compute_node_create\n    compute_node_ref.save()\n', u'  File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/nova/openstack/common/db/sqlalchemy/models.py", line 51, in save\n    session.flush()\n', u'  File "/opt/stack/venvs/nova/local/lib/python2.7/site-packages/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 MySQL server version for the right syntax to use near \\\': "\\\'i386\\\'", 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, 12, 3, 20, 4, 677066), None, None, 0, 5, 1, 2048, 20, 0, 0, 0, \'baremetal\', 1, \'31cd3256-111b-49e8-bd78-4dc279ce2ee9\', 2048, 20, 0, 0, \'baremetal cpu\', None, \'192.0.2.3\', \'[["i386", "baremetal", "baremetal"]]\', \'[]\', \'[]\', None, {u\'cpu_arch\': u\'i386\', u\'baremetal_driver\': u\'nova.virt.baremetal.pxe.PXE\'})\n'].
2014-02-12 03:20:04.687 3322 TRACE nova.openstack.common.periodic_task