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, %(memor
y_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_ke
y_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, %(mem
ory_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-72d
8-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
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
