yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1195139] Re: vmware: error trying to store hypervisor_version as string in using postgresql

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Adam Gandelman <1195139@xxxxxxxxxxxxxxxxxx>
Date: Thu, 03 Apr 2014 19:27:58 -0000
Reply-to: Bug 1195139 <1195139@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
** Changed in: nova/havana
       Status: Fix Committed => Fix Released

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

Title:
  vmware: error trying to store hypervisor_version as string in using
  postgresql

Status in OpenStack Compute (Nova):
  Fix Released
Status in OpenStack Compute (nova) havana series:
  Fix Released
Status in The OpenStack VMwareAPI subTeam:
  Fix Released

Bug description:
  Hi,

  I am trying to use VMware hypervisor ESXi 5.0.0 as a compute resource
  in OpenStack 2013.1.1. The driver being used is
  "•vmwareapi.VMwareVCDriver". The vCenter is contains a single cluster
  (two nodes) running ESXi version 5.0.

  In the compute node, I am seeing the below error

  2013-06-26 17:45:27.532 10253 AUDIT nova.compute.resource_tracker [-] Free ram (MB): 146933
  2013-06-26 17:45:27.532 10253 AUDIT nova.compute.resource_tracker [-] Free disk (GB): 55808
  2013-06-26 17:45:27.533 10253 AUDIT nova.compute.resource_tracker [-] Free VCPUS: 24
  2013-06-26 17:45:27.533 10253 DEBUG nova.openstack.common.rpc.amqp [-] Making synchronous call on conductor ... multicall /usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/amqp.py:583
  2013-06-26 17:45:27.534 10253 DEBUG nova.openstack.common.rpc.amqp [-] MSG_ID is ece63342e4254910be13ee92b948ace6 multicall /usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/amqp.py:586
  2013-06-26 17:45:27.534 10253 DEBUG nova.openstack.common.rpc.amqp [-] UNIQUE_ID is c85fb461be22468b846368a6b8608ac2. _add_unique_id /usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/amqp.py:337
  2013-06-26 17:45:27.566 10253 DEBUG nova.openstack.common.rpc.amqp [-] Making synchronous call on conductor ... multicall /usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/amqp.py:583
  2013-06-26 17:45:27.567 10253 DEBUG nova.openstack.common.rpc.amqp [-] MSG_ID is 3f5d065d1c8a4989b4d36415d45abe8b multicall /usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/amqp.py:586
  2013-06-26 17:45:27.567 10253 DEBUG nova.openstack.common.rpc.amqp [-] UNIQUE_ID is 1421bebfd9744271be63dcef74551c93. _add_unique_id /usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/amqp.py:337
  2013-06-26 17:45:27.597 10253 CRITICAL nova [-] Remote error: DBError (DataError) invalid input syntax for integer: "5.0.0"
  LINE 1: ..., 7, 24, 147445, 55808, 0, 512, 0, 'VMware ESXi', '5.0.0', '...
                                                               ^
   'INSERT INTO compute_nodes (created_at, updated_at, deleted_at, deleted, service_id, vcpus, memory_mb, local_gb, vcpus_used, memory_mb_used, local_gb_used, hypervisor_type, hypervisor_version, hypervisor_hostname, free_ram_mb, free_disk_gb, current_workload, running_vms, cpu_info, disk_available_least) VALUES (%(created_at)s, %(updated_at)s, %(deleted_at)s, %(deleted)s, %(service_id)s, %(vcpus)s, %(memory_mb)s, %(local_gb)s, %(vcpus_used)s, %(memory_mb_used)s, %(local_gb_used)s, %(hypervisor_type)s, %(hypervisor_version)s, %(hypervisor_hostname)s, %(free_ram_mb)s, %(free_disk_gb)s, %(current_workload)s, %(running_vms)s, %(cpu_info)s, %(disk_available_least)s) RETURNING compute_nodes.id' {'local_gb': 55808, 'vcpus_used': 0, 'deleted': 0, 'hypervisor_type': u'VMware ESXi', 'created_at': datetime.datetime(2013, 6, 26, 12, 15, 34, 804731), 'local_gb_used': 0, 'updated_at': None, 'hypervisor_hostname': u'10.100.10.42', 'memory_mb': 147445, 'current_workload': 0, 'vcpus': 24, 'free_ram_mb': 146933, 'running_vms': 0, 'free_disk_gb': 55808, 'service_id': 7, 'hypervisor_version': u'5.0.0', 'disk_available_least': None, 'deleted_at': None, 'cpu_info': u'{"model": "Intel(R) Xeon(R) CPU           L5640  @ 2.27GHz", "vendor": "HP", "topology": {"cores": 12, "threads": 24, "sockets": 2}}', 'memory_mb_used': 512}
  [u'Traceback (most recent call last):\n', u'  File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/amqp.py", line 430, in _process_data\n    rval = self.proxy.dispatch(ctxt, version, method, **args)\n', u'  File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/dispatcher.py", line 133, in dispatch\n    return getattr(proxyobj, method)(ctxt, **kwargs)\n', u'  File "/usr/lib/python2.7/dist-packages/nova/conductor/manager.py", line 350, in compute_node_create\n    result = self.db.compute_node_create(context, values)\n', u'  File "/usr/lib/python2.7/dist-packages/nova/db/api.py", line 192, in compute_node_create\n    return IMPL.compute_node_create(context, values)\n', u'  File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 96, in wrapper\n    return f(*args, **kwargs)\n', u'  File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 498, in compute_node_create\n    compute_node_ref.save()\n', u'  File "/usr/lib/python2.7/dist-packages/nova/openstack/common/db/sqlalchemy/models.py", line 54, in save\n    session.flush()\n', u'  File "/usr/lib/python2.7/dist-packages/nova/openstack/common/db/sqlalchemy/session.py", line 437, in _wrap\n    raise exception.DBError(e)\n', u'DBError: (DataError) invalid input syntax for integer: "5.0.0"\nLINE 1: ..., 7, 24, 147445, 55808, 0, 512, 0, \'VMware ESXi\', \'5.0.0\', \'...\n                                                             ^\n \'INSERT INTO compute_nodes (created_at, updated_at, deleted_at, deleted, service_id, vcpus, memory_mb, local_gb, vcpus_used, memory_mb_used, local_gb_used, hypervisor_type, hypervisor_version, hypervisor_hostname, free_ram_mb, free_disk_gb, current_workload, running_vms, cpu_info, disk_available_least) VALUES (%(created_at)s, %(updated_at)s, %(deleted_at)s, %(deleted)s, %(service_id)s, %(vcpus)s, %(memory_mb)s, %(local_gb)s, %(vcpus_used)s, %(memory_mb_used)s, %(local_gb_used)s, %(hypervisor_type)s, %(hypervisor_version)s, %(hypervisor_hostname)s, %(free_ram_mb)s, %(free_disk_gb)s, %(current_workload)s, %(running_vms)s, %(cpu_info)s, %(disk_available_least)s) RETURNING compute_nodes.id\' {\'local_gb\': 55808, \'vcpus_used\': 0, \'deleted\': 0, \'hypervisor_type\': u\'VMware ESXi\', \'created_at\': datetime.datetime(2013, 6, 26, 12, 15, 34, 804731), \'local_gb_used\': 0, \'updated_at\': None, \'hypervisor_hostname\': u\'10.100.10.42\', \'memory_mb\': 147445, \'current_workload\': 0, \'vcpus\': 24, \'free_ram_mb\': 146933, \'running_vms\': 0, \'free_disk_gb\': 55808, \'service_id\': 7, \'hypervisor_version\': u\'5.0.0\', \'disk_available_least\': None, \'deleted_at\': None, \'cpu_info\': u\'{"model": "Intel(R) Xeon(R) CPU           L5640  @ 2.27GHz", "vendor": "HP", "topology": {"cores": 12, "threads": 24, "sockets": 2}}\', \'memory_mb_used\': 512}\n'].
  2013-06-26 17:45:27.597 10253 TRACE nova Traceback (most recent call last):
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/bin/nova-compute", line 85, in <module>
  2013-06-26 17:45:27.597 10253 TRACE nova     service.wait()
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/service.py", line 689, in wait
  2013-06-26 17:45:27.597 10253 TRACE nova     _launcher.wait()
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/service.py", line 209, in wait
  2013-06-26 17:45:27.597 10253 TRACE nova     super(ServiceLauncher, self).wait()
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/service.py", line 179, in wait
  2013-06-26 17:45:27.597 10253 TRACE nova     service.wait()
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/eventlet/greenthread.py", line 168, in wait
  2013-06-26 17:45:27.597 10253 TRACE nova     return self._exit_event.wait()
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/eventlet/event.py", line 116, in wait
  2013-06-26 17:45:27.597 10253 TRACE nova     return hubs.get_hub().switch()
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/eventlet/hubs/hub.py", line 187, in switch
  2013-06-26 17:45:27.597 10253 TRACE nova     return self.greenlet.switch()
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/eventlet/greenthread.py", line 194, in main
  2013-06-26 17:45:27.597 10253 TRACE nova     result = function(*args, **kwargs)
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/service.py", line 147, in run_server
  2013-06-26 17:45:27.597 10253 TRACE nova     server.start()
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/service.py", line 446, in start
  2013-06-26 17:45:27.597 10253 TRACE nova     self.manager.pre_start_hook(rpc_connection=self.conn)
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/compute/manager.py", line 612, in pre_start_hook
  2013-06-26 17:45:27.597 10253 TRACE nova     self.update_available_resource(nova.context.get_admin_context())
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/compute/manager.py", line 3877, in update_available_resource
  2013-06-26 17:45:27.597 10253 TRACE nova     rt.update_available_resource(context)
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/openstack/common/lockutils.py", line 242, in inner
  2013-06-26 17:45:27.597 10253 TRACE nova     retval = f(*args, **kwargs)
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/compute/resource_tracker.py", line 272, in update_available_resource
  2013-06-26 17:45:27.597 10253 TRACE nova     self._sync_compute_node(context, resources)
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/compute/resource_tracker.py", line 293, in _sync_compute_node
  2013-06-26 17:45:27.597 10253 TRACE nova     self._create(context, resources)
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/compute/resource_tracker.py", line 293, in _sync_compute_node
  2013-06-26 17:45:27.597 10253 TRACE nova     self._create(context, resources)
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/compute/resource_tracker.py", line 307, in _create
  2013-06-26 17:45:27.597 10253 TRACE nova     values)
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/conductor/api.py", line 617, in compute_node_create
  2013-06-26 17:45:27.597 10253 TRACE nova     return self.conductor_rpcapi.compute_node_create(context, values)
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/conductor/rpcapi.py", line 349, in compute_node_create
  2013-06-26 17:45:27.597 10253 TRACE nova     return self.call(context, msg, version='1.33')
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/proxy.py", line 80, in call
  2013-06-26 17:45:27.597 10253 TRACE nova     return rpc.call(context, self._get_topic(topic), msg, timeout)
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/__init__.py", line 140, in call
  2013-06-26 17:45:27.597 10253 TRACE nova     return _get_impl().call(CONF, context, topic, msg, timeout)
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/impl_kombu.py", line 798, in call
  2013-06-26 17:45:27.597 10253 TRACE nova     rpc_amqp.get_connection_pool(conf, Connection))
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/amqp.py", line 612, in call
  2013-06-26 17:45:27.597 10253 TRACE nova     rv = list(rv)
  2013-06-26 17:45:27.597 10253 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/amqp.py", line 561, in __iter__
  2013-06-26 17:45:27.597 10253 TRACE nova     raise result
  2013-06-26 17:45:27.597 10253 TRACE nova RemoteError: Remote error: DBError (DataError) invalid input syntax for integer: "5.0.0"
  2013-06-26 17:45:27.597 10253 TRACE nova LINE 1: ..., 7, 24, 147445, 55808, 0, 512, 0, 'VMware ESXi', '5.0.0', '...
  2013-06-26 17:45:27.597 10253 TRACE nova                                                              ^
  2013-06-26 17:45:27.597 10253 TRACE nova  'INSERT INTO compute_nodes (created_at, updated_at, deleted_at, deleted, service_id, vcpus, memory_mb, local_gb, vcpus_used, memory_mb_used, local_gb_used, hypervisor_type, hypervisor_version, hypervisor_hostname, free_ram_mb, free_disk_gb, current_workload, running_vms, cpu_info, disk_available_least) VALUES (%(created_at)s, %(updated_at)s, %(deleted_at)s, %(deleted)s, %(service_id)s, %(vcpus)s, %(memory_mb)s, %(local_gb)s, %(vcpus_used)s, %(memory_mb_used)s, %(local_gb_used)s, %(hypervisor_type)s, %(hypervisor_version)s, %(hypervisor_hostname)s, %(free_ram_mb)s, %(free_disk_gb)s, %(current_workload)s, %(running_vms)s, %(cpu_info)s, %(disk_available_least)s) RETURNING compute_nodes.id' {'local_gb': 55808, 'vcpus_used': 0, 'deleted': 0, 'hypervisor_type': u'VMware ESXi', 'created_at': datetime.datetime(2013, 6, 26, 12, 15, 34, 804731), 'local_gb_used': 0, 'updated_at': None, 'hypervisor_hostname': u'10.100.10.42', 'memory_mb': 147445, 'current_workload': 0, 'vcpus': 24, 'free_ram_mb': 146933, 'running_vms': 0, 'free_disk_gb': 55808, 'service_id': 7, 'hypervisor_version': u'5.0.0', 'disk_available_least': None, 'deleted_at': None, 'cpu_info': u'{"model": "Intel(R) Xeon(R) CPU           L5640  @ 2.27GHz", "vendor": "HP", "topology": {"cores": 12, "threads": 24, "sockets": 2}}', 'memory_mb_used': 512}
  2013-06-26 17:45:27.597 10253 TRACE nova [u'Traceback (most recent call last):\n', u'  File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/amqp.py", line 430, in _process_data\n    rval = self.proxy.dispatch(ctxt, version, method, **args)\n', u'  File "/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/dispatcher.py", line 133, in dispatch\n    return getattr(proxyobj, method)(ctxt, **kwargs)\n', u'  File "/usr/lib/python2.7/dist-packages/nova/conductor/manager.py", line 350, in compute_node_create\n    result = self.db.compute_node_create(context, values)\n', u'  File "/usr/lib/python2.7/dist-packages/nova/db/api.py", line 192, in compute_node_create\n    return IMPL.compute_node_create(context, values)\n', u'  File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 96, in wrapper\n    return f(*args, **kwargs)\n', u'  File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 498, in compute_node_create\n    compute_node_ref.save()\n', u'  File "/usr/lib/python2.7/dist-packages/nova/openstack/common/db/sqlalchemy/models.py", line 54, in save\n    session.flush()\n', u'  File "/usr/lib/python2.7/dist-packages/nova/openstack/common/db/sqlalchemy/session.py", line 437, in _wrap\n    raise exception.DBError(e)\n', u'DBError: (DataError) invalid input syntax for integer: "5.0.0"\nLINE 1: ..., 7, 24, 147445, 55808, 0, 512, 0, \'VMware ESXi\', \'5.0.0\', \'...\n                                                             ^\n \'INSERT INTO compute_nodes (created_at, updated_at, deleted_at, deleted, service_id, vcpus, memory_mb, local_gb, vcpus_used, memory_mb_used, local_gb_used, hypervisor_type, hypervisor_version, hypervisor_hostname, free_ram_mb, free_disk_gb, current_workload, running_vms, cpu_info, disk_available_least) VALUES (%(created_at)s, %(updated_at)s, %(deleted_at)s, %(deleted)s, %(service_id)s, %(vcpus)s, %(memory_mb)s, %(local_gb)s, %(vcpus_used)s, %(memory_mb_used)s, %(local_gb_used)s, %(hypervisor_type)s, %(hypervisor_version)s, %(hypervisor_hostname)s, %(free_ram_mb)s, %(free_disk_gb)s, %(current_workload)s, %(running_vms)s, %(cpu_info)s, %(disk_available_least)s) RETURNING compute_nodes.id\' {\'local_gb\': 55808, \'vcpus_used\': 0, \'deleted\': 0, \'hypervisor_type\': u\'VMware ESXi\', \'created_at\': datetime.datetime(2013, 6, 26, 12, 15, 34, 804731), \'local_gb_used\': 0, \'updated_at\': None, \'hypervisor_hostname\': u\'10.100.10.42\', \'memory_mb\': 147445, \'current_workload\': 0, \'vcpus\': 24, \'free_ram_mb\': 146933, \'running_vms\': 0, \'free_disk_gb\': 55808, \'service_id\': 7, \'hypervisor_version\': u\'5.0.0\', \'disk_available_least\': None, \'deleted_at\': None, \'cpu_info\': u\'{"model": "Intel(R) Xeon(R) CPU           L5640  @ 2.27GHz", "vendor": "HP", "topology": {"cores": 12, "threads": 24, "sockets": 2}}\', \'memory_mb_used\': 512}\n'].
  2013-06-26 17:45:27.597 10253 TRACE nova

  
  Is this a bug with OpenStack?

  Thank you,
  Pragadees

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