yahoo-eng-team team mailing list archive

[Russell Bryant <1285035@xxxxxxxxxxxxxxxxxx>]

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

** Changed in: nova
    Milestone: None => juno-2

-- 
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/1285035

Title:
  compute FakeDriver : DBerror invalid input syntax for integer: "1.0"

Status in OpenStack Compute (Nova):
  Fix Released

Bug description:
  by setting nova.conf:
  compute_driver = fake.FakeDriver

  
  I got  this error on conductor when nova-compute  update_available_resource :
  2014-02-26 08:48:04.631 ERROR oslo.messaging.rpc.dispatcher [-] Exception during message handling: (DataError) invalid input syntax for integer: "1.0"
  LINE 1: ...6T07:48:04.627618'::timestamp, hypervisor_version='1.0' WHER...
                                                               ^
   'UPDATE compute_nodes SET updated_at=%(updated_at)s, hypervisor_version=%(hypervisor_version)s WHERE compute_nodes.id = %(compute_nodes_id)s' {'hypervisor_version': u'1.0', 'updated_at': datetime.datetime(2014, 2, 26, 7, 48, 4, 627618), 'compute_nodes_id': 1}
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher Traceback (most recent call last):
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher   File "/home/croisets/stack/oslo.messaging/oslo/messaging/rpc/dispatcher.py", line 133, in _dispatch_and_reply
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher     incoming.message))
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher   File "/home/croisets/stack/oslo.messaging/oslo/messaging/rpc/dispatcher.py", line 176, in _dispatch
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher     return self._do_dispatch(endpoint, method, ctxt, args)
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher   File "/home/croisets/stack/oslo.messaging/oslo/messaging/rpc/dispatcher.py", line 122, in _do_dispatch
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher     result = getattr(endpoint, method)(ctxt, **new_args)
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher   File "/home/croisets/stack/nova/nova/conductor/manager.py", line 466, in compute_node_update
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher     result = self.db.compute_node_update(context, node['id'], values)
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher   File "/home/croisets/stack/nova/nova/db/api.py", line 228, in compute_node_update
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher     return IMPL.compute_node_update(context, compute_id, values)
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher   File "/home/croisets/stack/nova/nova/db/sqlalchemy/api.py", line 110, in wrapper
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher     return f(*args, **kwargs)
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher   File "/home/croisets/stack/nova/nova/db/sqlalchemy/api.py", line 166, in wrapped
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher     return f(*args, **kwargs)
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher   File "/home/croisets/stack/nova/nova/db/sqlalchemy/api.py", line 614, in compute_node_update
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher     compute_ref.update(values)
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 456, in __exit__
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher     self.commit()
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 368, in commit
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher     self._prepare_impl()
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 347, in _prepare_impl
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher     self.session.flush()
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher   File "/home/croisets/stack/nova/nova/openstack/common/db/sqlalchemy/session.py", line 616, in _wrap
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher     raise exception.DBError(e)
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher DBError: (DataError) invalid input syntax for integer: "1.0"
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher LINE 1: ...6T07:48:04.627618'::timestamp, hypervisor_version='1.0' WHER...
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher                                                              ^
  2014-02-26 08:48:04.631 TRACE oslo.messaging.rpc.dispatcher  'UPDATE compute_nodes SET updated_at=%(updated_at)s, hypervisor_version=%(hypervisor_version)s WHERE compute_nodes.id = %(compute_nodes_id)s' {'hypervisor_version': u'1.0', 'updated_at': datetime.datetime(2014, 
  2, 26, 7, 48, 4, 627618), 'compute_nodes_id': 1}

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