← Back to team overview

yahoo-eng-team team mailing list archive

  1. yahoo-eng-team team
  2. Mailing list archive
  3. Message #15897

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

  Thread Previous • Date Previous • • Thread Next 
Public bug reported:

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"

** Affects: ironic
     Importance: High
         Status: Confirmed

** Affects: nova
     Importance: Critical
         Status: Confirmed


** Tags: db testing

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

** Changed in: nova
   Importance: Undecided => Critical

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

Follow ups

References

  Thread Previous • Date Previous • • Thread Next