yahoo-eng-team team mailing list archive

[Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>]

** Changed in: nova
       Status: Fix Committed => Fix Released

** Changed in: nova
    Milestone: None => liberty-1

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1442795

Title:
  Incorrect datetime value in bw_usage_update

Status in OpenStack Compute (Nova):
  Fix Released

Bug description:
  2015-04-10 06:25:20.134 15041 TRACE nova.openstack.common.periodic_task File "/opt/rackstack/rackstack.228.7/nova/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 442, in do_execute
  2015-04-10 06:25:20.134 15041 TRACE nova.openstack.common.periodic_task cursor.execute(statement, parameters)
  2015-04-10 06:25:20.134 15041 TRACE nova.openstack.common.periodic_task File "/opt/rackstack/rackstack.228.7/nova/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
  2015-04-10 06:25:20.134 15041 TRACE nova.openstack.common.periodic_task self.errorhandler(self, exc, value)
  2015-04-10 06:25:20.134 15041 TRACE nova.openstack.common.periodic_task File "/opt/rackstack/rackstack.228.7/nova/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
  2015-04-10 06:25:20.134 15041 TRACE nova.openstack.common.periodic_task raise errorclass, errorvalue
  2015-04-10 06:25:20.134 15041 TRACE nova.openstack.common.periodic_task OperationalError: (OperationalError) (1292, "Incorrect datetime value: '2015-04-10T00: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(2015, 4, 10, 6, 25, 20, 129368), None, None, 0, '2176064f-0ae1-45a6-9142-d1b80255ff67', 'FE:ED:FA:00:17:CD', '2015-04-10T00:00:00Z', '2015-04-10T06:25:20Z', 0, 0, 2654, 2284)
  2015-04-10 06:25:20.134 15041 TRACE nova.openstack.common.periodic_task

  The serialize_args wrapper for objects.BandwidthUsage().create() is
  converting the datetime to a string which mysql doesn't like.

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1442795/+subscriptions