yahoo-eng-team team mailing list archive

[Devananda van der Veen <1328997@xxxxxxxxxxxxxxxxxx>]

Adding Ironic since we inherited the db migration test code from Nova,
and while it turns out that we're not testing db migrations in the gate
due to a misconfiguration, if we were to enable them, we'd face the same
race conditions in our unit tests.

** Tags added: db

** Also affects: ironic
   Importance: Undecided
       Status: New

** Changed in: ironic
   Importance: Undecided => High

** Changed in: ironic
       Status: New => Confirmed

-- 
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/1328997

Title:
  Unit test failure: openstack_citest" is being accessed by other
  users\nDETAIL:  There are 1 other session(s) using the database.

Status in OpenStack Bare Metal Provisioning Service (Ironic):
  Confirmed
Status in OpenStack Compute (Nova):
  Confirmed

Bug description:
  We are periodically seeing this nova unit test failure in our CI
  system:

  openstack_citest" is being accessed by other users\nDETAIL:  There are
  1 other session(s) using the database.

  http://logs.openstack.org/76/98376/1/gate/gate-nova-
  python27/d2a0593/console.html

  
  2014-06-11 06:26:40.002 | FAIL: nova.tests.db.test_migrations.TestNovaMigrations.test_postgresql_opportunistically
  2014-06-11 06:26:40.002 | tags: worker-6
  2014-06-11 06:26:40.003 | ----------------------------------------------------------------------
  2014-06-11 06:26:40.003 | Empty attachments:
  2014-06-11 06:26:40.003 |   pythonlogging:''
  2014-06-11 06:26:40.003 |   stderr
  2014-06-11 06:26:40.003 |   stdout
  2014-06-11 06:26:40.003 | 
  2014-06-11 06:26:40.004 | Traceback (most recent call last):
  2014-06-11 06:26:40.004 |   File "nova/tests/db/test_migrations.py", line 139, in test_postgresql_opportunistically
  2014-06-11 06:26:40.004 |     self._test_postgresql_opportunistically()
  2014-06-11 06:26:40.004 |   File "nova/tests/db/test_migrations.py", line 428, in _test_postgresql_opportunistically
  2014-06-11 06:26:40.004 |     self._reset_database(database)
  2014-06-11 06:26:40.004 |   File "nova/tests/db/test_migrations.py", line 335, in _reset_database
  2014-06-11 06:26:40.004 |     self._reset_pg(conn_pieces)
  2014-06-11 06:26:40.005 |   File "nova/openstack/common/lockutils.py", line 249, in inner
  2014-06-11 06:26:40.005 |     return f(*args, **kwargs)
  2014-06-11 06:26:40.005 |   File "nova/tests/db/test_migrations.py", line 244, in _reset_pg
  2014-06-11 06:26:40.005 |     self.execute_cmd(droptable)
  2014-06-11 06:26:40.005 |   File "nova/tests/db/test_migrations.py", line 227, in execute_cmd
  2014-06-11 06:26:40.005 |     "Failed to run: %s\n%s" % (cmd, output))
  2014-06-11 06:26:40.005 |   File "/home/jenkins/workspace/gate-nova-python27/.tox/py27/local/lib/python2.7/site-packages/testtools/testcase.py", line 321, in assertEqual
  2014-06-11 06:26:40.006 |     self.assertThat(observed, matcher, message)
  2014-06-11 06:26:40.006 |   File "/home/jenkins/workspace/gate-nova-python27/.tox/py27/local/lib/python2.7/site-packages/testtools/testcase.py", line 406, in assertThat
  2014-06-11 06:26:40.006 |     raise mismatch_error
  2014-06-11 06:26:40.006 | MismatchError: !=:
  2014-06-11 06:26:40.006 | reference = ''
  2014-06-11 06:26:40.006 | actual    = '''\
  2014-06-11 06:26:40.007 | Unexpected error while running command.
  2014-06-11 06:26:40.007 | Command: psql -w -U openstack_citest -h localhost -c 'drop database if exists openstack_citest;' -d template1
  2014-06-11 06:26:40.007 | Exit code: 1
  2014-06-11 06:26:40.007 | Stdout: ''
  2014-06-11 06:26:40.007 | Stderr: 'ERROR:  database "openstack_citest" is being accessed by other users\\nDETAIL:  There are 1 other session(s) using the database.\\n\''''
  2014-06-11 06:26:40.007 | : Failed to run: psql -w -U openstack_citest -h localhost -c 'drop database if exists openstack_citest;' -d template1

  
  elastic-search query: message:"Stderr: \'ERROR:  database \"openstack_citest\" is being accessed by other users\\nDETAIL:  There are 1 other session(s) using the database.\\n\'" AND project:"openstack/nova"

To manage notifications about this bug go to:
https://bugs.launchpad.net/ironic/+bug/1328997/+subscriptions