← Back to team overview

yahoo-eng-team team mailing list archive

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

[Bug 1393633] [NEW] test_postgresql_opportunistically fails with "database "openstack_citest" is being accessed by other users"

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

Looks like this was previously fixed under bug 1328997 but this is back:

http://logs.openstack.org/72/135072/1/check/gate-nova-
python27/ba44ca9/console.html#_2014-11-17_22_51_24_244

2014-11-17 22:51:24.244 | Captured traceback:
2014-11-17 22:51:24.244 | ~~~~~~~~~~~~~~~~~~~
2014-11-17 22:51:24.244 |     Traceback (most recent call last):
2014-11-17 22:51:24.244 |       File "nova/tests/unit/db/test_migrations.py", line 138, in test_postgresql_opportunistically
2014-11-17 22:51:24.245 |         self._test_postgresql_opportunistically()
2014-11-17 22:51:24.245 |       File "nova/tests/unit/db/test_migrations.py", line 429, in _test_postgresql_opportunistically
2014-11-17 22:51:24.245 |         self._reset_database(database)
2014-11-17 22:51:24.245 |       File "nova/tests/unit/db/test_migrations.py", line 336, in _reset_database
2014-11-17 22:51:24.245 |         self._reset_pg(conn_pieces)
2014-11-17 22:51:24.245 |       File "/home/jenkins/workspace/gate-nova-python27/.tox/py27/local/lib/python2.7/site-packages/oslo/concurrency/lockutils.py", line 311, in inner
2014-11-17 22:51:24.245 |         return f(*args, **kwargs)
2014-11-17 22:51:24.245 |       File "nova/tests/unit/db/test_migrations.py", line 245, in _reset_pg
2014-11-17 22:51:24.245 |         self.execute_cmd(droptable)
2014-11-17 22:51:24.245 |       File "nova/tests/unit/db/test_migrations.py", line 228, in execute_cmd
2014-11-17 22:51:24.245 |         "Failed to run: %s\n%s" % (cmd, output))
2014-11-17 22:51:24.246 |       File "/home/jenkins/workspace/gate-nova-python27/.tox/py27/local/lib/python2.7/site-packages/testtools/testcase.py", line 348, in assertEqual
2014-11-17 22:51:24.246 |         self.assertThat(observed, matcher, message)
2014-11-17 22:51:24.246 |       File "/home/jenkins/workspace/gate-nova-python27/.tox/py27/local/lib/python2.7/site-packages/testtools/testcase.py", line 433, in assertThat
2014-11-17 22:51:24.246 |         raise mismatch_error
2014-11-17 22:51:24.246 |     MismatchError: !=:
2014-11-17 22:51:24.246 |     reference = ''
2014-11-17 22:51:24.246 |     actual    = u'''\
2014-11-17 22:51:24.246 |     Unexpected error while running command.
2014-11-17 22:51:24.246 |     Command: psql -w -U openstack_citest -h localhost -c 'drop database if exists openstack_citest;' -d postgres
2014-11-17 22:51:24.246 |     Exit code: 1
2014-11-17 22:51:24.246 |     Stdout: u''
2014-11-17 22:51:24.247 |     Stderr: u'ERROR:  database "openstack_citest" is being accessed by other users\\nDETAIL:  There is 1 other session using the database.\\n\''''
2014-11-17 22:51:24.247 |     : Failed to run: psql -w -U openstack_citest -h localhost -c 'drop database if exists openstack_citest;' -d postgres
2014-11-17 22:51:24.247 |     Unexpected error while running command.
2014-11-17 22:51:24.247 |     Command: psql -w -U openstack_citest -h localhost -c 'drop database if exists openstack_citest;' -d postgres
2014-11-17 22:51:24.247 |     Exit code: 1
2014-11-17 22:51:24.247 |     Stdout: u''
2014-11-17 22:51:24.247 |     Stderr: u'ERROR:  database "openstack_citest" is being accessed by other users\nDETAIL:  There is 1 other session using the database.\n'
2014-11-17 22:51:24.247 |     Traceback (most recent call last):
2014-11-17 22:51:24.247 |     _StringException: Empty attachments:
2014-11-17 22:51:24.247 |       pythonlogging:''
2014-11-17 22:51:24.247 |       stderr
2014-11-17 22:51:24.248 |       stdout


http://logstash.openstack.org/#eyJzZWFyY2giOiJtZXNzYWdlOlwiQ29tbWFuZDogcHNxbCAtdyAtVSBvcGVuc3RhY2tfY2l0ZXN0IC1oIGxvY2FsaG9zdCAtYyAnZHJvcCBkYXRhYmFzZSBpZiBleGlzdHMgb3BlbnN0YWNrX2NpdGVzdDsnIC1kIHBvc3RncmVzXCIgQU5EIHRhZ3M6XCJjb25zb2xlXCIgQU5EIGJ1aWxkX25hbWU6XCJnYXRlLW5vdmEtcHl0aG9uMjdcIiIsImZpZWxkcyI6W10sIm9mZnNldCI6MCwidGltZWZyYW1lIjoiNjA0ODAwIiwiZ3JhcGhtb2RlIjoiY291bnQiLCJ0aW1lIjp7InVzZXJfaW50ZXJ2YWwiOjB9LCJzdGFtcCI6MTQxNjI3NTg1MDI4MSwibW9kZSI6IiIsImFuYWx5emVfZmllbGQiOiIifQ==

516 hits in 7 days, check and gate, all failures.

** Affects: nova
     Importance: High
         Status: Confirmed

** Affects: oslo.db
     Importance: Undecided
         Status: New


** Tags: db postgresql testing

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

** Changed in: nova
       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/1393633

Title:
  test_postgresql_opportunistically fails with "database
  "openstack_citest" is being accessed by other users"

Status in OpenStack Compute (Nova):
  Confirmed
Status in Oslo Database library:
  New

Bug description:
  Looks like this was previously fixed under bug 1328997 but this is
  back:

  http://logs.openstack.org/72/135072/1/check/gate-nova-
  python27/ba44ca9/console.html#_2014-11-17_22_51_24_244

  2014-11-17 22:51:24.244 | Captured traceback:
  2014-11-17 22:51:24.244 | ~~~~~~~~~~~~~~~~~~~
  2014-11-17 22:51:24.244 |     Traceback (most recent call last):
  2014-11-17 22:51:24.244 |       File "nova/tests/unit/db/test_migrations.py", line 138, in test_postgresql_opportunistically
  2014-11-17 22:51:24.245 |         self._test_postgresql_opportunistically()
  2014-11-17 22:51:24.245 |       File "nova/tests/unit/db/test_migrations.py", line 429, in _test_postgresql_opportunistically
  2014-11-17 22:51:24.245 |         self._reset_database(database)
  2014-11-17 22:51:24.245 |       File "nova/tests/unit/db/test_migrations.py", line 336, in _reset_database
  2014-11-17 22:51:24.245 |         self._reset_pg(conn_pieces)
  2014-11-17 22:51:24.245 |       File "/home/jenkins/workspace/gate-nova-python27/.tox/py27/local/lib/python2.7/site-packages/oslo/concurrency/lockutils.py", line 311, in inner
  2014-11-17 22:51:24.245 |         return f(*args, **kwargs)
  2014-11-17 22:51:24.245 |       File "nova/tests/unit/db/test_migrations.py", line 245, in _reset_pg
  2014-11-17 22:51:24.245 |         self.execute_cmd(droptable)
  2014-11-17 22:51:24.245 |       File "nova/tests/unit/db/test_migrations.py", line 228, in execute_cmd
  2014-11-17 22:51:24.245 |         "Failed to run: %s\n%s" % (cmd, output))
  2014-11-17 22:51:24.246 |       File "/home/jenkins/workspace/gate-nova-python27/.tox/py27/local/lib/python2.7/site-packages/testtools/testcase.py", line 348, in assertEqual
  2014-11-17 22:51:24.246 |         self.assertThat(observed, matcher, message)
  2014-11-17 22:51:24.246 |       File "/home/jenkins/workspace/gate-nova-python27/.tox/py27/local/lib/python2.7/site-packages/testtools/testcase.py", line 433, in assertThat
  2014-11-17 22:51:24.246 |         raise mismatch_error
  2014-11-17 22:51:24.246 |     MismatchError: !=:
  2014-11-17 22:51:24.246 |     reference = ''
  2014-11-17 22:51:24.246 |     actual    = u'''\
  2014-11-17 22:51:24.246 |     Unexpected error while running command.
  2014-11-17 22:51:24.246 |     Command: psql -w -U openstack_citest -h localhost -c 'drop database if exists openstack_citest;' -d postgres
  2014-11-17 22:51:24.246 |     Exit code: 1
  2014-11-17 22:51:24.246 |     Stdout: u''
  2014-11-17 22:51:24.247 |     Stderr: u'ERROR:  database "openstack_citest" is being accessed by other users\\nDETAIL:  There is 1 other session using the database.\\n\''''
  2014-11-17 22:51:24.247 |     : Failed to run: psql -w -U openstack_citest -h localhost -c 'drop database if exists openstack_citest;' -d postgres
  2014-11-17 22:51:24.247 |     Unexpected error while running command.
  2014-11-17 22:51:24.247 |     Command: psql -w -U openstack_citest -h localhost -c 'drop database if exists openstack_citest;' -d postgres
  2014-11-17 22:51:24.247 |     Exit code: 1
  2014-11-17 22:51:24.247 |     Stdout: u''
  2014-11-17 22:51:24.247 |     Stderr: u'ERROR:  database "openstack_citest" is being accessed by other users\nDETAIL:  There is 1 other session using the database.\n'
  2014-11-17 22:51:24.247 |     Traceback (most recent call last):
  2014-11-17 22:51:24.247 |     _StringException: Empty attachments:
  2014-11-17 22:51:24.247 |       pythonlogging:''
  2014-11-17 22:51:24.247 |       stderr
  2014-11-17 22:51:24.248 |       stdout

  
  http://logstash.openstack.org/#eyJzZWFyY2giOiJtZXNzYWdlOlwiQ29tbWFuZDogcHNxbCAtdyAtVSBvcGVuc3RhY2tfY2l0ZXN0IC1oIGxvY2FsaG9zdCAtYyAnZHJvcCBkYXRhYmFzZSBpZiBleGlzdHMgb3BlbnN0YWNrX2NpdGVzdDsnIC1kIHBvc3RncmVzXCIgQU5EIHRhZ3M6XCJjb25zb2xlXCIgQU5EIGJ1aWxkX25hbWU6XCJnYXRlLW5vdmEtcHl0aG9uMjdcIiIsImZpZWxkcyI6W10sIm9mZnNldCI6MCwidGltZWZyYW1lIjoiNjA0ODAwIiwiZ3JhcGhtb2RlIjoiY291bnQiLCJ0aW1lIjp7InVzZXJfaW50ZXJ2YWwiOjB9LCJzdGFtcCI6MTQxNjI3NTg1MDI4MSwibW9kZSI6IiIsImFuYWx5emVfZmllbGQiOiIifQ==

  516 hits in 7 days, check and gate, all failures.

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

Follow ups

References

  Thread Previous • Date Previous • • Thread Next