yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1644513] Re: (psycopg2.ProgrammingError) column "deleted" is of type integer but expression is of type boolean

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: OpenStack Infra <1644513@xxxxxxxxxxxxxxxxxx>
Date: Mon, 28 Nov 2016 23:44:21 -0000
Reply-to: Bug 1644513 <1644513@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Reviewed:  https://review.openstack.org/403756
Committed: https://git.openstack.org/cgit/openstack/nova/commit/?id=f3a280959a0237fc3b0f3eeaaa3154566f8620c0
Submitter: Jenkins
Branch:    master

commit f3a280959a0237fc3b0f3eeaaa3154566f8620c0
Author: Dan Smith <dansmith@xxxxxxxxxx>
Date:   Mon Nov 28 07:24:21 2016 -0800

    Check deleted flag in Instance.create()
    
    An attempt to create an instance with the deleted flag set will
    not work as intended, especially from instance.create(), which
    can't properly pass the yet-to-be-determined deleted=id protocol.
    
    This makes Instance.create() throw an error like the one for
    being already created, and fixes the one test where we depend
    on this working.
    
    Change-Id: I60d18ca694a2eb7f333c0cf2a898cf8f17eb83dd
    Closes-Bug: #1644513


** Changed in: nova
       Status: In Progress => 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/1644513

Title:
  (psycopg2.ProgrammingError) column "deleted" is of type integer but
  expression is of type boolean

Status in OpenStack Compute (nova):
  Fix Released

Bug description:
  The Telemetry gate is broken with PostgreSQL because of nova-api:

  2016-11-24 09:59:34.431 32192 ERROR oslo_db.sqlalchemy.exc_filters [req-8ed9761f-b699-4c92-8793-7dca7296d63e tempest-TelemetryNotificationAPITest-1553287657 tempest-TelemetryNotificationAPITest-1553287657] DBAPIError exception wrapped from (psycopg2.ProgrammingError) column "deleted" is of type integer but expression is of type boolean
  LINE 1: ...16-11-24T09:59:34.369835'::timestamp, NULL, NULL, false, 'f2...
                                                               ^
  HINT:  You will need to rewrite or cast the expression.
   [SQL: 'INSERT INTO instances (created_at, updated_at, deleted_at, deleted, user_id, project_id, image_ref, kernel_id, ramdisk_id, hostname, launch_index, key_name, key_data, power_state, vm_state, task_state, memory_mb, vcpus, root_gb, ephemeral_gb, ephemeral_key_uuid, host, node, instance_type_id, user_data, reservation_id, launched_at, terminated_at, availability_zone, display_name, display_description, launched_on, locked, locked_by, os_type, architecture, vm_mode, uuid, root_device_name, default_ephemeral_device, default_swap_device, config_drive, access_ip_v4, access_ip_v6, auto_disk_config, progress, shutdown_terminate, disable_terminate, cell_name, cleaned) VALUES (%(created_at)s, %(updated_at)s, %(deleted_at)s, %(deleted)s, %(user_id)s, %(project_id)s, %(image_ref)s, %(kernel_id)s, %(ramdisk_id)s, %(hostname)s, %(launch_index)s, %(key_name)s, %(key_data)s, %(power_state)s, %(vm_state)s, %(task_state)s, %(memory_mb)s, %(vcpus)s, %(root_gb)s, %(ephemeral_gb)s, %(ephemeral_key_uuid)s, %(host)s, %(node)s, %(instance_type_id)s, %(user_data)s, %(reservation_id)s, %(launched_at)s, %(terminated_at)s, %(availability_zone)s, %(display_name)s, %(display_description)s, %(launched_on)s, %(locked)s, %(locked_by)s, %(os_type)s, %(architecture)s, %(vm_mode)s, %(uuid)s, %(root_device_name)s, %(default_ephemeral_device)s, %(default_swap_device)s, %(config_drive)s, %(access_ip_v4)s, %(access_ip_v6)s, %(auto_disk_config)s, %(progress)s, %(shutdown_terminate)s, %(disable_terminate)s, %(cell_name)s, %(cleaned)s) RETURNING instances.id'] [parameters: {'vm_state': u'building', 'availability_zone': None, 'terminated_at': None, 'ramdisk_id': u'52b2ce17-7bbd-42e7-beae-04c68862da89', 'instance_type_id': 11, 'user_data': None, 'cleaned': 0, 'vm_mode': None, 'deleted_at': None, 'reservation_id': u'r-uo48grph', 'disable_terminate': False, 'display_name': u'tempest-ceilometer-instance-28537131', 'uuid': 'd575169b-72d8-431c-a604-7073460c8d45', 'default_swap_device': None, 'hostname': u'tempest-ceilometer-instance-28537131', 'launched_on': None, 'display_description': u'tempest-ceilometer-instance-28537131', 'key_data': None, 'deleted': False, 'power_state': 0, 'default_ephemeral_device': None, 'progress': 0, 'project_id': u'859a6fcd13504baa8032ed210dc49501', 'launched_at': None, 'architecture': None, 'node': None, 'ephemeral_gb': 0, 'access_ip_v6': None, 'access_ip_v4': None, 'kernel_id': u'8e1eaad4-cb0a-4517-95da-cec482d6169c', 'key_name': None, 'updated_at': None, 'host': None, 'root_gb': 0, 'user_id': u'f21c50ce019c40e1af23463735ba2b34', 'task_state': u'scheduling', 'shutdown_terminate': False, 'cell_name': None, 'ephemeral_key_uuid': None, 'locked': False, 'created_at': datetime.datetime(2016, 11, 24, 9, 59, 34, 369835), 'locked_by': None, 'launch_index': 0, 'memory_mb': 64, 'vcpus': 1, 'image_ref': u'7000088e-adda-45ce-8bbc-dbfe4e087941', 'root_device_name': None, 'auto_disk_config': False, 'os_type': None, 'config_drive': u''}]
  2016-11-24 09:59:34.431 32192 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
  2016-11-24 09:59:34.431 32192 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
  2016-11-24 09:59:34.431 32192 ERROR oslo_db.sqlalchemy.exc_filters     context)
  2016-11-24 09:59:34.431 32192 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
  2016-11-24 09:59:34.431 32192 ERROR oslo_db.sqlalchemy.exc_filters     cursor.execute(statement, parameters)
  2016-11-24 09:59:34.431 32192 ERROR oslo_db.sqlalchemy.exc_filters ProgrammingError: column "deleted" is of type integer but expression is of type boolean
  2016-11-24 09:59:34.431 32192 ERROR oslo_db.sqlalchemy.exc_filters LINE 1: ...16-11-24T09:59:34.369835'::timestamp, NULL, NULL, false, 'f2...
  2016-11-24 09:59:34.431 32192 ERROR oslo_db.sqlalchemy.exc_filters                                                              ^
  2016-11-24 09:59:34.431 32192 ERROR oslo_db.sqlalchemy.exc_filters HINT:  You will need to rewrite or cast the expression.
  2016-11-24 09:59:34.431 32192 ERROR oslo_db.sqlalchemy.exc_filters 
  2016-11-24 09:59:34.431 32192 ERROR oslo_db.sqlalchemy.exc_filters 
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions [req-8ed9761f-b699-4c92-8793-7dca7296d63e tempest-TelemetryNotificationAPITest-1553287657 tempest-TelemetryNotificationAPITest-1553287657] Unexpected exception in API method
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions Traceback (most recent call last):
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/opt/stack/new/nova/nova/api/openstack/extensions.py", line 338, in wrapped
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     return f(*args, **kwargs)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/opt/stack/new/nova/nova/api/validation/__init__.py", line 73, in wrapper
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     return func(*args, **kwargs)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/opt/stack/new/nova/nova/api/validation/__init__.py", line 73, in wrapper
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     return func(*args, **kwargs)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/opt/stack/new/nova/nova/api/validation/__init__.py", line 73, in wrapper
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     return func(*args, **kwargs)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/opt/stack/new/nova/nova/api/validation/__init__.py", line 73, in wrapper
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     return func(*args, **kwargs)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/opt/stack/new/nova/nova/api/validation/__init__.py", line 73, in wrapper
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     return func(*args, **kwargs)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/opt/stack/new/nova/nova/api/openstack/compute/servers.py", line 631, in create
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     **create_kwargs)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/opt/stack/new/nova/nova/hooks.py", line 154, in inner
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     rv = f(*args, **kwargs)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/opt/stack/new/nova/nova/compute/api.py", line 1599, in create
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     check_server_group_quota=check_server_group_quota)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/opt/stack/new/nova/nova/compute/api.py", line 1224, in _create_instance
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     instances_to_build)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     self.force_reraise()
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     six.reraise(self.type_, self.value, self.tb)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/opt/stack/new/nova/nova/compute/api.py", line 1213, in _create_instance
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     instance.create()
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/oslo_versionedobjects/base.py", line 226, in wrapper
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     return fn(self, *args, **kwargs)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/opt/stack/new/nova/nova/objects/instance.py", line 540, in create
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     db_inst = db.instance_create(self._context, updates)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/opt/stack/new/nova/nova/db/api.py", line 715, in instance_create
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     return IMPL.instance_create(context, values)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/opt/stack/new/nova/nova/db/sqlalchemy/api.py", line 170, in wrapper
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     return f(*args, **kwargs)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 151, in wrapper
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     ectxt.value = e.inner_exc
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     self.force_reraise()
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     six.reraise(self.type_, self.value, self.tb)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 139, in wrapper
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     return f(*args, **kwargs)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/opt/stack/new/nova/nova/db/sqlalchemy/api.py", line 241, in wrapped
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     return f(context, *args, **kwargs)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/opt/stack/new/nova/nova/db/sqlalchemy/api.py", line 1809, in instance_create
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     ec2_instance_create(context, instance_ref['uuid'])
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/opt/stack/new/nova/nova/db/sqlalchemy/api.py", line 170, in wrapper
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     return f(*args, **kwargs)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/opt/stack/new/nova/nova/db/sqlalchemy/api.py", line 241, in wrapped
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     return f(context, *args, **kwargs)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/opt/stack/new/nova/nova/db/sqlalchemy/api.py", line 6182, in ec2_instance_create
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     ec2_instance_ref.save(context.session)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/models.py", line 48, in save
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     session.flush()
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2080, in flush
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     self._flush(objects)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2198, in _flush
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     transaction.rollback(_capture_exception=True)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     compat.reraise(exc_type, exc_value, exc_tb)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2162, in _flush
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     flush_context.execute()
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     rec.execute(self)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     uow
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 178, in save_obj
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     mapper, table, insert)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 804, in _emit_insert_statements
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     execute(statement, params)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     return meth(self, multiparams, params)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     return connection._execute_clauseelement(self, multiparams, params)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     compiled_sql, distilled_params
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     context)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     util.raise_from_cause(newraise, exc_info)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     reraise(type(exception), exception, tb=exc_tb, cause=cause)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     context)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions     cursor.execute(statement, parameters)
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions DBError: (psycopg2.ProgrammingError) column "deleted" is of type integer but expression is of type boolean
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions LINE 1: ...16-11-24T09:59:34.369835'::timestamp, NULL, NULL, false, 'f2...
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions                                                              ^
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions HINT:  You will need to rewrite or cast the expression.
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions  [SQL: 'INSERT INTO instances (created_at, updated_at, deleted_at, deleted, user_id, project_id, image_ref, kernel_id, ramdisk_id, hostname, launch_index, key_name, key_data, power_state, vm_state, task_state, memory_mb, vcpus, root_gb, ephemeral_gb, ephemeral_key_uuid, host, node, instance_type_id, user_data, reservation_id, launched_at, terminated_at, availability_zone, display_name, display_description, launched_on, locked, locked_by, os_type, architecture, vm_mode, uuid, root_device_name, default_ephemeral_device, default_swap_device, config_drive, access_ip_v4, access_ip_v6, auto_disk_config, progress, shutdown_terminate, disable_terminate, cell_name, cleaned) VALUES (%(created_at)s, %(updated_at)s, %(deleted_at)s, %(deleted)s, %(user_id)s, %(project_id)s, %(image_ref)s, %(kernel_id)s, %(ramdisk_id)s, %(hostname)s, %(launch_index)s, %(key_name)s, %(key_data)s, %(power_state)s, %(vm_state)s, %(task_state)s, %(memory_mb)s, %(vcpus)s, %(root_gb)s, %(ephemeral_gb)s, %(ephemeral_key_uuid)s, %(host)s, %(node)s, %(instance_type_id)s, %(user_data)s, %(reservation_id)s, %(launched_at)s, %(terminated_at)s, %(availability_zone)s, %(display_name)s, %(display_description)s, %(launched_on)s, %(locked)s, %(locked_by)s, %(os_type)s, %(architecture)s, %(vm_mode)s, %(uuid)s, %(root_device_name)s, %(default_ephemeral_device)s, %(default_swap_device)s, %(config_drive)s, %(access_ip_v4)s, %(access_ip_v6)s, %(auto_disk_config)s, %(progress)s, %(shutdown_terminate)s, %(disable_terminate)s, %(cell_name)s, %(cleaned)s) RETURNING instances.id'] [parameters: {'vm_state': u'building', 'availability_zone': None, 'terminated_at': None, 'ramdisk_id': u'52b2ce17-7bbd-42e7-beae-04c68862da89', 'instance_type_id': 11, 'user_data': None, 'cleaned': 0, 'vm_mode': None, 'deleted_at': None, 'reservation_id': u'r-uo48grph', 'disable_terminate': False, 'display_name': u'tempest-ceilometer-instance-28537131', 'uuid': 'd575169b-72d8-431c-a604-7073460c8d45', 'default_swap_device': None, 'hostname': u'tempest-ceilometer-instance-28537131', 'launched_on': None, 'display_description': u'tempest-ceilometer-instance-28537131', 'key_data': None, 'deleted': False, 'power_state': 0, 'default_ephemeral_device': None, 'progress': 0, 'project_id': u'859a6fcd13504baa8032ed210dc49501', 'launched_at': None, 'architecture': None, 'node': None, 'ephemeral_gb': 0, 'access_ip_v6': None, 'access_ip_v4': None, 'kernel_id': u'8e1eaad4-cb0a-4517-95da-cec482d6169c', 'key_name': None, 'updated_at': None, 'host': None, 'root_gb': 0, 'user_id': u'f21c50ce019c40e1af23463735ba2b34', 'task_state': u'scheduling', 'shutdown_terminate': False, 'cell_name': None, 'ephemeral_key_uuid': None, 'locked': False, 'created_at': datetime.datetime(2016, 11, 24, 9, 59, 34, 369835), 'locked_by': None, 'launch_index': 0, 'memory_mb': 64, 'vcpus': 1, 'image_ref': u'7000088e-adda-45ce-8bbc-dbfe4e087941', 'root_device_name': None, 'auto_disk_config': False, 'os_type': None, 'config_drive': u''}]
  2016-11-24 09:59:34.443 32192 ERROR nova.api.openstack.extensions 

  
  Full log at http://logs.openstack.org/34/385934/21/check/gate-ceilometer-dsvm-tempest-plugin-postgresql/a9bbba3/logs/screen-n-api.txt.gz

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

[Bug 1644513] [NEW] (psycopg2.ProgrammingError) column "deleted" is of type integer but expression is of type boolean
From: Julien Danjou, 2016-11-24