** 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

-- 
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help   : https://help.launchpad.net/ListHelp

Reply via email to