Ask Your Question
0

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

asked 2013-03-02 18:42:09 -0500

vijayrg gravatar image

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)

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
0

answered 2013-03-02 20:16:34 -0500

zzs gravatar image

I linked this to the bug #1140294

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2013-03-02 18:42:09 -0500

Seen: 57 times

Last updated: Mar 02 '13