← Back to team overview

yahoo-eng-team team mailing list archive

  1. yahoo-eng-team team
  2. Mailing list archive
  3. Message #10273

[Bug 1285035] [NEW] compute FakeDriver : DBerror invalid input syntax for integer: "1.0"

  Thread Previous • Date Previous • • Thread Next 
Public bug reported:

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}

** Affects: nova
     Importance: Undecided
         Status: New

-- 
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):
  New

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

Follow ups

References

  Thread Previous • Date Previous • • Thread Next