Nova compute Remote error: OperationalError

asked 2016-02-12 03:40:27 -0500

adhi gravatar image

Hi, anyone can help me with this error on my openstack Kilo nova-compute ?

 2016-02-12 16:31:02.638 1499 ERROR nova.openstack.common.periodic_task [req-670f8955-ec22-4a75-b2e3-fbd5688758d0 - - - - -] Error during ComputeManager._poll_bandwidth_usage: Remote error: OperationalError (OperationalError) (1292, "Incorrect datetime value: '2016-02-01T00:00:00Z' for column 'start_period' at row 1") 'INSERT INTO bw_usage_cache (created_at, updated_at, deleted_at, deleted, uuid, mac, start_period, last_refreshed, bw_in, bw_out, last_ctr_in, last_ctr_out) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)' (datetime.datetime(2016, 2, 12, 9, 31, 2, 632714), None, None, 0, 'b5fa1e47-5998-44d4-a527-973e66cec5d3', 'fa:16:3e:af:b0:5b', u'2016-02-01T00:00:00Z', u'2016-02-12T09:31:02Z', 0, 0, 500006, 81034)
[u'Traceback (most recent call last):\n', u'  File "/usr/lib/python2.7/dist-packages/nova/conductor/", line 422, in _object_dispatch\n    return getattr(target, method)(*args, **kwargs)\n', u'  File "/usr/lib/python2.7/dist-packages/nova/objects/", line 956, in wrapper\n    return fn(obj, *args, **kwargs)\n', u'  File "/usr/lib/python2.7/dist-packages/nova/objects/", line 208, in wrapper\n    return fn(self, *args, **kwargs)\n', u'  File "/usr/lib/python2.7/dist-packages/nova/objects/", line 63, in create\n    update_cells=update_cells)\n', u'  File "/usr/lib/python2.7/dist-packages/nova/db/", line 1676, in bw_usage_update\n    bw_out, last_ctr_in, last_ctr_out, last_refreshed=last_refreshed)\n', u'  File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/", line 233, in wrapper\n    return f(*args, **kwargs)\n', u'  File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/", line 271, in wrapped\n    return f(*args, **kwargs)\n', u'  File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/", line 5167, in bw_usage_update\n\n', u'  File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/", line 82, in save\n    super(NovaBase, self).save(session=session)\n', u'  File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/", line 48, in save\n    session.flush()\n', u'  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/", line 1919, in flush\n    self._flush(objects)\n', u'  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/", line 2037, in _flush\n    transaction.rollback(_capture_exception=True)\n', u'  File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/", line 60, in __exit__\n    compat.reraise(exc_type, exc_value, exc_tb)\n', u'  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/", line 2001, in _flush\n    flush_context.execute()\n', u'  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/", line 372, in execute\n    rec.execute(self)\n', u'  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/", line 526, in execute\n    uow\n', u'  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/", line 65, in save_obj\n    mapper, table, insert)\n', u'  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/", line 602, in _emit_insert_statements\n    execute(statement, params)\n', u'  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/ ...
edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted

answered 2016-02-12 12:21:48 -0500

pjb gravatar image

updated 2016-02-12 12:22:08 -0500

Check whether your chrony/NTP server(controller) and the client (compute) are in sync or not. Run the following command in your controller and compute nodes.

# date
edit flag offensive delete link more


It's running and sync

root@kilcomp3:~# chronyc sources
210 Number of sources = 1
MS Name/IP address         Stratum Poll Reach LastRx Last sample
^* kilcon            3   6   377   125    +20us[  +39us] +/-   50ms

root@kilcomp3:~# date
Mon Mar 14 11:02:21 WIB 2016
adhi gravatar imageadhi ( 2016-03-13 23:08:36 -0500 )edit

Hi, It seems it is a known bug in Liberty. Follow the below link: bug

pjb gravatar imagepjb ( 2016-03-14 03:40:45 -0500 )edit

does it also affect in kilo release ? because those error appear on Kilo

adhi gravatar imageadhi ( 2016-03-16 22:58:24 -0500 )edit

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower


Asked: 2016-02-12 03:40:27 -0500

Seen: 282 times

Last updated: Feb 12 '16