yahoo-eng-team team mailing list archive

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

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Julien Danjou <1644513@xxxxxxxxxxxxxxxxxx>
Date: Thu, 24 Nov 2016 10:56:13 -0000
Reply-to: Bug 1644513 <1644513@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

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

** Affects: nova
     Importance: Undecided
         Status: New

-- 
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):
  New

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
Follow ups

[Bug 1644513] Re: (psycopg2.ProgrammingError) column "deleted" is of type integer but expression is of type boolean
From: OpenStack Infra, 2016-11-28