[openstack-qa] Build failed in Jenkins: periodic-tempest-devstack-postgres-vm-full #78

OpenStack Jenkins jenkins at openstack.org
Fri Jan 25 07:13:21 UTC 2013


See <https://jenkins.openstack.org/job/periodic-tempest-devstack-postgres-vm-full/78/>

------------------------------------------
[...truncated 16678 lines...]
    params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute
    cursor.execute(statement, parameters)
ProgrammingError: (ProgrammingError) column "deleted" is of type integer but expression is of type boolean
LINE 1: ...SET vm_state='active', task_state='NULL', deleted=false WHER...
                                                             ^
HINT:  You will need to rewrite or cast the expression.
 'UPDATE instances SET vm_state=%(vm_state)s, task_state=%(task_state)s, deleted=%(deleted)s WHERE instances.uuid = %(uuid_1)s' {'deleted': False, 'vm_state': 'active', 'uuid_1': u'3aa62dee-e6e7-4ffb-8acf-e27e690ad594', 'task_state': 'NULL'}

======================================================================
ERROR: test_create_image_when_vm_eq_resized_task_eq_resize_confirming (tempest.tests.compute.images.test_images_whitebox.ImagesWhiteboxTest)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/opt/stack/new/tempest/tempest/tests/compute/images/test_images_whitebox.py", line 124, in test_create_image_when_vm_eq_resized_task_eq_resize_confirming
    self._test_create_image_409_base("resized", "resize_confirming")
  File "/opt/stack/new/tempest/tempest/tests/compute/images/test_images_whitebox.py", line 80, in _test_create_image_409_base
    self.update_state(self.shared_server['id'], 'active', None)
  File "/opt/stack/new/tempest/tempest/tests/compute/images/test_images_whitebox.py", line 64, in update_state
    self.connection.execute(stmt, autocommit=True)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute
    params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute
    cursor.execute(statement, parameters)
ProgrammingError: (ProgrammingError) column "deleted" is of type integer but expression is of type boolean
LINE 1: ...SET vm_state='active', task_state='NULL', deleted=false WHER...
                                                             ^
HINT:  You will need to rewrite or cast the expression.
 'UPDATE instances SET vm_state=%(vm_state)s, task_state=%(task_state)s, deleted=%(deleted)s WHERE instances.uuid = %(uuid_1)s' {'deleted': False, 'vm_state': 'active', 'uuid_1': u'3aa62dee-e6e7-4ffb-8acf-e27e690ad594', 'task_state': 'NULL'}

======================================================================
ERROR: test_create_image_when_vm_eq_resized_task_eq_resize_finish (tempest.tests.compute.images.test_images_whitebox.ImagesWhiteboxTest)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/opt/stack/new/tempest/tempest/tests/compute/images/test_images_whitebox.py", line 116, in test_create_image_when_vm_eq_resized_task_eq_resize_finish
    self._test_create_image_409_base("resized", "resize_finish")
  File "/opt/stack/new/tempest/tempest/tests/compute/images/test_images_whitebox.py", line 80, in _test_create_image_409_base
    self.update_state(self.shared_server['id'], 'active', None)
  File "/opt/stack/new/tempest/tempest/tests/compute/images/test_images_whitebox.py", line 64, in update_state
    self.connection.execute(stmt, autocommit=True)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute
    params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute
    cursor.execute(statement, parameters)
ProgrammingError: (ProgrammingError) column "deleted" is of type integer but expression is of type boolean
LINE 1: ...SET vm_state='active', task_state='NULL', deleted=false WHER...
                                                             ^
HINT:  You will need to rewrite or cast the expression.
 'UPDATE instances SET vm_state=%(vm_state)s, task_state=%(task_state)s, deleted=%(deleted)s WHERE instances.uuid = %(uuid_1)s' {'deleted': False, 'vm_state': 'active', 'uuid_1': u'3aa62dee-e6e7-4ffb-8acf-e27e690ad594', 'task_state': 'NULL'}

======================================================================
ERROR: test_create_image_when_vm_eq_resized_task_eq_resize_migrated (tempest.tests.compute.images.test_images_whitebox.ImagesWhiteboxTest)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/opt/stack/new/tempest/tempest/tests/compute/images/test_images_whitebox.py", line 112, in test_create_image_when_vm_eq_resized_task_eq_resize_migrated
    self._test_create_image_409_base("resized", "resize_migrated")
  File "/opt/stack/new/tempest/tempest/tests/compute/images/test_images_whitebox.py", line 80, in _test_create_image_409_base
    self.update_state(self.shared_server['id'], 'active', None)
  File "/opt/stack/new/tempest/tempest/tests/compute/images/test_images_whitebox.py", line 64, in update_state
    self.connection.execute(stmt, autocommit=True)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute
    params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute
    cursor.execute(statement, parameters)
ProgrammingError: (ProgrammingError) column "deleted" is of type integer but expression is of type boolean
LINE 1: ...SET vm_state='active', task_state='NULL', deleted=false WHER...
                                                             ^
HINT:  You will need to rewrite or cast the expression.
 'UPDATE instances SET vm_state=%(vm_state)s, task_state=%(task_state)s, deleted=%(deleted)s WHERE instances.uuid = %(uuid_1)s' {'deleted': False, 'vm_state': 'active', 'task_state': 'NULL', 'uuid_1': u'3aa62dee-e6e7-4ffb-8acf-e27e690ad594'}

======================================================================
ERROR: test_create_image_when_vm_eq_resized_task_eq_resize_migrating (tempest.tests.compute.images.test_images_whitebox.ImagesWhiteboxTest)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/opt/stack/new/tempest/tempest/tests/compute/images/test_images_whitebox.py", line 108, in test_create_image_when_vm_eq_resized_task_eq_resize_migrating
    self._test_create_image_409_base("resized", "resize_migrating")
  File "/opt/stack/new/tempest/tempest/tests/compute/images/test_images_whitebox.py", line 80, in _test_create_image_409_base
    self.update_state(self.shared_server['id'], 'active', None)
  File "/opt/stack/new/tempest/tempest/tests/compute/images/test_images_whitebox.py", line 64, in update_state
    self.connection.execute(stmt, autocommit=True)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute
    params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute
    cursor.execute(statement, parameters)
ProgrammingError: (ProgrammingError) column "deleted" is of type integer but expression is of type boolean
LINE 1: ...SET vm_state='active', task_state='NULL', deleted=false WHER...
                                                             ^
HINT:  You will need to rewrite or cast the expression.
 'UPDATE instances SET vm_state=%(vm_state)s, task_state=%(task_state)s, deleted=%(deleted)s WHERE instances.uuid = %(uuid_1)s' {'deleted': False, 'vm_state': 'active', 'task_state': 'NULL', 'uuid_1': u'3aa62dee-e6e7-4ffb-8acf-e27e690ad594'}

======================================================================
ERROR: test_create_image_when_vm_eq_resized_task_eq_resize_prep (tempest.tests.compute.images.test_images_whitebox.ImagesWhiteboxTest)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/opt/stack/new/tempest/tempest/tests/compute/images/test_images_whitebox.py", line 104, in test_create_image_when_vm_eq_resized_task_eq_resize_prep
    self._test_create_image_409_base("resized", "resize_prep")
  File "/opt/stack/new/tempest/tempest/tests/compute/images/test_images_whitebox.py", line 80, in _test_create_image_409_base
    self.update_state(self.shared_server['id'], 'active', None)
  File "/opt/stack/new/tempest/tempest/tests/compute/images/test_images_whitebox.py", line 64, in update_state
    self.connection.execute(stmt, autocommit=True)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute
    params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute
    cursor.execute(statement, parameters)
ProgrammingError: (ProgrammingError) column "deleted" is of type integer but expression is of type boolean
LINE 1: ...SET vm_state='active', task_state='NULL', deleted=false WHER...
                                                             ^
HINT:  You will need to rewrite or cast the expression.
 'UPDATE instances SET vm_state=%(vm_state)s, task_state=%(task_state)s, deleted=%(deleted)s WHERE instances.uuid = %(uuid_1)s' {'deleted': False, 'vm_state': 'active', 'task_state': 'NULL', 'uuid_1': u'3aa62dee-e6e7-4ffb-8acf-e27e690ad594'}

======================================================================
ERROR: test_create_image_when_vm_eq_resized_task_eq_resize_reverting (tempest.tests.compute.images.test_images_whitebox.ImagesWhiteboxTest)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/opt/stack/new/tempest/tempest/tests/compute/images/test_images_whitebox.py", line 120, in test_create_image_when_vm_eq_resized_task_eq_resize_reverting
    self._test_create_image_409_base("resized", "resize_reverting")
  File "/opt/stack/new/tempest/tempest/tests/compute/images/test_images_whitebox.py", line 80, in _test_create_image_409_base
    self.update_state(self.shared_server['id'], 'active', None)
  File "/opt/stack/new/tempest/tempest/tests/compute/images/test_images_whitebox.py", line 64, in update_state
    self.connection.execute(stmt, autocommit=True)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute
    params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute
    cursor.execute(statement, parameters)
ProgrammingError: (ProgrammingError) column "deleted" is of type integer but expression is of type boolean
LINE 1: ...SET vm_state='active', task_state='NULL', deleted=false WHER...
                                                             ^
HINT:  You will need to rewrite or cast the expression.
 'UPDATE instances SET vm_state=%(vm_state)s, task_state=%(task_state)s, deleted=%(deleted)s WHERE instances.uuid = %(uuid_1)s' {'deleted': False, 'vm_state': 'active', 'uuid_1': u'3aa62dee-e6e7-4ffb-8acf-e27e690ad594', 'task_state': 'NULL'}

======================================================================
ERROR: test suite for <class 'tempest.tests.compute.images.test_images_whitebox.ImagesWhiteboxTest'>
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/nose/suite.py", line 227, in run
    self.tearDown()
  File "/usr/lib/python2.7/dist-packages/nose/suite.py", line 350, in tearDown
    self.teardownContext(ancestor)
  File "/usr/lib/python2.7/dist-packages/nose/suite.py", line 366, in teardownContext
    try_run(context, names)
  File "/usr/lib/python2.7/dist-packages/nose/util.py", line 478, in try_run
    return func()
  File "/opt/stack/new/tempest/tempest/tests/compute/images/test_images_whitebox.py", line 42, in tearDownClass
    cls.update_state(server['id'], "active", None)
  File "/opt/stack/new/tempest/tempest/tests/compute/images/test_images_whitebox.py", line 64, in update_state
    self.connection.execute(stmt, autocommit=True)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute
    params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute
    cursor.execute(statement, parameters)
ProgrammingError: (ProgrammingError) column "deleted" is of type integer but expression is of type boolean
LINE 1: ...SET vm_state='active', task_state='NULL', deleted=false WHER...
                                                             ^
HINT:  You will need to rewrite or cast the expression.
 'UPDATE instances SET vm_state=%(vm_state)s, task_state=%(task_state)s, deleted=%(deleted)s WHERE instances.uuid = %(uuid_1)s' {'deleted': False, 'vm_state': 'active', 'uuid_1': u'3aa62dee-e6e7-4ffb-8acf-e27e690ad594', 'task_state': 'NULL'}

----------------------------------------------------------------------
XML: nosetests-full.xml
----------------------------------------------------------------------
Ran 578 tests in 2358.745s

FAILED (SKIP=69, errors=25)
Process leaked file descriptors. See http://wiki.jenkins-ci.org/display/JENKINS/Spawning+processes+from+build for more information
Build step 'Execute shell' marked build as failure
[SCP] Connecting to static.openstack.org
[SCP] Trying to create /srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78
[SCP] Trying to create /srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/devstack-gate-cleanup-host.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/devstack-gate-setup-host.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/devstack-gate-setup-workspace-new.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/devstacklog.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/iptables.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/kern_log.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/localrc.txt'
[SCP] Trying to create /srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/rabbitmq
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/rabbitmq/rabbit at devstack-1359056502-sasl.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/rabbitmq/rabbit at devstack-1359056502.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/rabbitmq/startup_log.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/screen-c-api.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/screen-c-sch.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/screen-c-vol.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/screen-g-api.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/screen-g-reg.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/screen-horizon.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/screen-key.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/screen-n-api.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/screen-n-cond.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/screen-n-cpu.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/screen-n-crt.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/screen-n-net.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/screen-n-obj.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/screen-n-sch.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/screen-swift.txt'
[SCP] Trying to create /srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/sudoers.d
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/sudoers.d/README.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/sudoers.d/cinder-rootwrap.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/sudoers.d/jenkins-sudo-grep.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/sudoers.d/nova-rootwrap.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/sudoers.txt'
[SCP] uploading file: '/srv/static/logs/periodic/periodic-tempest-devstack-postgres-vm-full/78/logs/syslog.txt'
[SCP] Connecting to static.openstack.org
[SCP] Copying console log.



More information about the openstack-qa mailing list