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

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