id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
22420	Postgresql connections not being dropped between tests?	Matthew Fisher	nobody	"I'm on Django 1.6.2, and ever since we switched to using psql for our database, we have been hitting an issue with running the test suite. I haven't been able to figure out why this occurs. Logs follow below.

{{{
$ make coverage
coverage run manage.py test --noinput api web
Creating test database for alias 'default'...
...............................................
----------------------------------------------------------------------
Ran 47 tests in 12.388s

OK
Destroying test database for alias 'default'...
Traceback (most recent call last):
  File ""manage.py"", line 13, in <module>
    execute_from_command_line(sys.argv)
  File ""/Users/bacongobbler/venv/lib/python2.7/site-packages/django/core/management/__init__.py"", line 399, in execute_from_command_line
    utility.execute()
  File ""/Users/bacongobbler/venv/lib/python2.7/site-packages/django/core/management/__init__.py"", line 392, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File ""/Users/bacongobbler/venv/lib/python2.7/site-packages/django/core/management/commands/test.py"", line 50, in run_from_argv
    super(Command, self).run_from_argv(argv)
  File ""/Users/bacongobbler/venv/lib/python2.7/site-packages/django/core/management/base.py"", line 242, in run_from_argv
    self.execute(*args, **options.__dict__)
  File ""/Users/bacongobbler/venv/lib/python2.7/site-packages/django/core/management/commands/test.py"", line 71, in execute
    super(Command, self).execute(*args, **options)
  File ""/Users/bacongobbler/venv/lib/python2.7/site-packages/django/core/management/base.py"", line 285, in execute
    output = self.handle(*args, **options)
  File ""/Users/bacongobbler/venv/lib/python2.7/site-packages/south/management/commands/test.py"", line 8, in handle
    super(Command, self).handle(*args, **kwargs)
  File ""/Users/bacongobbler/venv/lib/python2.7/site-packages/django/core/management/commands/test.py"", line 88, in handle
    failures = test_runner.run_tests(test_labels)
  File ""/Users/bacongobbler/git/github.com/opdemand/deis/controller/api/tests/__init__.py"", line 41, in run_tests
    test_labels, extra_tests, **kwargs)
  File ""/Users/bacongobbler/venv/lib/python2.7/site-packages/django/test/runner.py"", line 147, in run_tests
    self.teardown_databases(old_config)
  File ""/Users/bacongobbler/venv/lib/python2.7/site-packages/django/test/runner.py"", line 122, in teardown_databases
    connection.creation.destroy_test_db(old_name, self.verbosity)
  File ""/Users/bacongobbler/venv/lib/python2.7/site-packages/django/db/backends/creation.py"", line 443, in destroy_test_db
    new_connection.creation._destroy_test_db(test_database_name, verbosity)
  File ""/Users/bacongobbler/venv/lib/python2.7/site-packages/django/db/backends/creation.py"", line 457, in _destroy_test_db
    % self.connection.ops.quote_name(test_database_name))
  File ""/Users/bacongobbler/venv/lib/python2.7/site-packages/django/db/backends/util.py"", line 53, in execute
    return self.cursor.execute(sql, params)
  File ""/Users/bacongobbler/venv/lib/python2.7/site-packages/django/db/utils.py"", line 99, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File ""/Users/bacongobbler/venv/lib/python2.7/site-packages/django/db/backends/util.py"", line 51, in execute
    return self.cursor.execute(sql)
OperationalError: database ""test_deis"" is being accessed by other users
DETAIL:  There is 1 other session using the database.

make: *** [coverage] Error 1
}}}

To me, it looks like Django is trying to destroy the temporary test database, but there are some connections still left over from the previous test suite run, which prevents the database from being dropped."	Bug	closed	Testing framework	3.0	Normal	needsinfo		Rich Rauenzahn Peter Ashford	Unreviewed	0	0	0	0	0	0