﻿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
12395	Full suite test failures after r11863	Karen Tracey	nobody	"r11863 seems to have introduced something into the fixtures_regress test that makes the database unflushable on most backends, resulting in failures of subsequent tests that attempt to flush the database.  Example from MySQL/InnoDB (MyISAM also fails) when attempting to run the fixtures_regress and m2m_through_regress tests:

{{{
No fixtures found.
Doctest: regressiontests.fixtures_regress.models.__test__.API_TESTS ... ok
Doctest: regressiontests.m2m_through_regress.models.__test__.API_TESTS ... Error: Database test_Playground couldn't be flushed. Possible reasons:
      * The database isn't running or isn't configured correctly.
      * At least one of the expected database tables doesn't exist.
      * The SQL was invalid.
    Hint: Look at the output of 'django-admin.py sqlflush'. That's the SQL this command wasn't able to run.
    The full error: (1146, ""Table 'test_Playground.fixtures_regress_circle1' doesn't exist"")
FAIL

======================================================================
FAIL: Doctest: regressiontests.m2m_through_regress.models.__test__.API_TESTS
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/home/kmt/django/trunk/django/test/_doctest.py"", line 2180, in runTest
    raise self.failureException(self.format_failure(new.getvalue()))
AssertionError: Failed doctest test for regressiontests.m2m_through_regress.models.__test__.API_TESTS
  File ""/home/kmt/django/trunk/tests/regressiontests/m2m_through_regress/models.py"", line unknown line number, in API_TESTS

----------------------------------------------------------------------
File ""/home/kmt/django/trunk/tests/regressiontests/m2m_through_regress/models.py"", line ?, in regressiontests.m2m_through_regress.models.__test__.API_TESTS
Failed example:
    management.call_command('flush', verbosity=0, interactive=False)
Exception raised:
    Traceback (most recent call last):
      File ""/home/kmt/django/trunk/django/test/_doctest.py"", line 1267, in __run
        compileflags, 1) in test.globs
      File ""<doctest regressiontests.m2m_through_regress.models.__test__.API_TESTS[36]>"", line 1, in <module>
        management.call_command('flush', verbosity=0, interactive=False)
      File ""/home/kmt/django/trunk/django/core/management/__init__.py"", line 166, in call_command
        return klass.execute(*args, **defaults)
      File ""/home/kmt/django/trunk/django/core/management/base.py"", line 234, in execute
        sys.exit(1)
    SystemExit: 1


----------------------------------------------------------------------
Ran 2 tests in 2.325s

FAILED (failures=1)
Destroying test database...

}}}

Another subsequent tests that fails when running the full suite is serializers_regress.

Postgres also fails with a similar message, plus another: 

{{{
Doctest: regressiontests.fixtures_regress.models.__test__.API_TESTS ... ok
Doctest: regressiontests.m2m_through_regress.models.__test__.API_TESTS ... Error: Database test_postgres couldn't be flushed. Possible reasons:
      * The database isn't running or isn't configured correctly.
      * At least one of the expected database tables doesn't exist.
      * The SQL was invalid.
    Hint: Look at the output of 'django-admin.py sqlflush'. That's the SQL this command wasn't able to run.
    The full error: relation ""fixtures_regress_circle1_id_seq"" does not exist

FAIL

======================================================================
FAIL: Doctest: regressiontests.m2m_through_regress.models.__test__.API_TESTS
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/home/kmt/django/trunk/django/test/_doctest.py"", line 2180, in runTest
    raise self.failureException(self.format_failure(new.getvalue()))
AssertionError: Failed doctest test for regressiontests.m2m_through_regress.models.__test__.API_TESTS
  File ""/home/kmt/django/trunk/tests/regressiontests/m2m_through_regress/models.py"", line unknown line number, in API_TESTS

----------------------------------------------------------------------
File ""/home/kmt/django/trunk/tests/regressiontests/m2m_through_regress/models.py"", line ?, in regressiontests.m2m_through_regress.models.__test__.API_TESTS
Failed example:
    management.call_command('flush', verbosity=0, interactive=False)
Exception raised:
    Traceback (most recent call last):
      File ""/home/kmt/django/trunk/django/test/_doctest.py"", line 1267, in __run
        compileflags, 1) in test.globs
      File ""<doctest regressiontests.m2m_through_regress.models.__test__.API_TESTS[36]>"", line 1, in <module>
        management.call_command('flush', verbosity=0, interactive=False)
      File ""/home/kmt/django/trunk/django/core/management/__init__.py"", line 166, in call_command
        return klass.execute(*args, **defaults)
      File ""/home/kmt/django/trunk/django/core/management/base.py"", line 234, in execute
        sys.exit(1)
    SystemExit: 1
----------------------------------------------------------------------
File ""/home/kmt/django/trunk/tests/regressiontests/m2m_through_regress/models.py"", line ?, in regressiontests.m2m_through_regress.models.__test__.API_TESTS
Failed example:
    management.call_command('dumpdata', 'm2m_through_regress', format='json')
Expected:
    [{""pk"": 1, ""model"": ""m2m_through_regress.usermembership"", ""fields"": {""price"": 100, ""group"": 1, ""user"": 1}}, {""pk"": 1, ""model"": ""m2m_through_regress.person"", ""fields"": {""name"": ""Guido""}}, {""pk"": 1, ""model"": ""m2m_through_regress.group"", ""fields"": {""name"": ""Python Core Group""}}]
Got:
    [{""pk"": 2, ""model"": ""m2m_through_regress.membership"", ""fields"": {""person"": 1, ""price"": 100, ""group"": 2}}, {""pk"": 4, ""model"": ""m2m_through_regress.membership"", ""fields"": {""person"": 3, ""price"": 100, ""group"": 3}}, {""pk"": 5, ""model"": ""m2m_through_regress.membership"", ""fields"": {""person"": 4, ""price"": 50, ""group"": 3}}, {""pk"": 6, ""model"": ""m2m_through_regress.membership"", ""fields"": {""person"": 3, ""price"": 50, ""group"": 4}}, {""pk"": 1, ""model"": ""m2m_through_regress.usermembership"", ""fields"": {""price"": 100, ""group"": 1, ""user"": 1}}, {""pk"": 3, ""model"": ""m2m_through_regress.person"", ""fields"": {""name"": ""Bob""}}, {""pk"": 4, ""model"": ""m2m_through_regress.person"", ""fields"": {""name"": ""Jim""}}, {""pk"": 1, ""model"": ""m2m_through_regress.person"", ""fields"": {""name"": ""Guido""}}, {""pk"": 2, ""model"": ""m2m_through_regress.group"", ""fields"": {""name"": ""Roll""}}, {""pk"": 3, ""model"": ""m2m_through_regress.group"", ""fields"": {""name"": ""Rock""}}, {""pk"": 4, ""model"": ""m2m_through_regress.group"", ""fields"": {""name"": ""Roll""}}, {""pk"": 1, ""model"": ""m2m_through_regress.group"", ""fields"": {""name"": ""Python Core Group""}}]


----------------------------------------------------------------------
Ran 2 tests in 10.751s

FAILED (failures=1)
Destroying test database...

}}}

Oracle also fails, sqlite is blithely unperturbed by whatever is bothering the other DBs.

In all cases that fail with r11863 or higher, r11862 works."		closed	Uncategorized	dev		fixed			Unreviewed	0	0	0	0	0	0
