yahoo-eng-team team mailing list archive

Thread
Date

[Bug 1140294] Re: nova baremetal node create error:column deleted is of type boolean but expression is integer

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>
Date: Wed, 20 Mar 2013 16:13:21 -0000
Reply-to: Bug 1140294 <1140294@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx

** Changed in: nova
       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/1140294

Title:
  nova baremetal node create error:column deleted is of type boolean but
  expression is integer

Status in OpenStack Compute (Nova):
  Fix Released

Bug description:
  nova --baremetal-node-create command returns programming error: olumn "deleted" is of type boolean but expression is of type integer
  (using postgres db)

  2012-10-01 03:44:04.563 5070 TRACE nova.api.openstack   File "/usr/local/lib/python2.7/dist-packages/nova-2013.1.g3-py2.7.egg/nova/openstack/common/db/sqlalchemy/session.py", line 424, in _wrap
  2012-10-01 03:44:04.563 5070 TRACE nova.api.openstack     raise DBError(e)
  2012-10-01 03:44:04.563 5070 TRACE nova.api.openstack DBError: (ProgrammingError) column "deleted" is of type boolean but expression is of type integer
  2012-10-01 03:44:04.563 5070 TRACE nova.api.openstack LINE 1: ...12-10-01T10:44:04.558009'::timestamp, NULL, NULL, 0, '110d95...
  2012-10-01 03:44:04.563 5070 TRACE nova.api.openstack                                                              ^
  2012-10-01 03:44:04.563 5070 TRACE nova.api.openstack HINT:  You will need to rewrite or cast the expression.
  2012-10-01 03:44:04.563 5070 TRACE nova.api.openstack  'INSERT INTO bm_nodes (created_at, updated_at, deleted_at, deleted, uuid, service_host, instance_uuid, instance_name, cpus, memory_mb, local_gb, pm_address, pm_user, pm_password, prov_mac_address, registration_status, task_state, prov_vlan_id, terminal_port, image_path, pxe_config_path, deploy_key, root_mb, swap_mb) VALUES (%(created_at)s, %(updated_at)s, %(deleted_at)s, %(deleted)s, %(uuid)s, %(service_host)s, %(instance_uuid)s, %(instance_name)s, %(cpus)s, %(memory_mb)s, %(local_gb)s, %(pm_address)s, %(pm_user)s, %(pm_password)s, %(prov_mac_address)s, %(registration_status)s, %(task_state)s, %(prov_vlan_id)s, %(terminal_port)s, %(image_path)s, %(pxe_config_path)s, %(deploy_key)s, %(root_mb)s, %(swap_mb)s)

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