nova baremetal node create errors with deleted is of type boolean but expression is of type integer

Asked by vj

nova --baremetal-node-create command returns programming error: column "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)

Question information

Language:
English Edit question
Status:
Answered
For:
OpenStack Compute (nova) Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Jason (zzs) said :
#1

I linked this to the bug #1140294

Can you help with this problem?

Provide an answer of your own, or ask vj for more information if necessary.

To post a message you must log in.