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
31752	Intermittent test failure on Windows with PostgreSQL	Carlton Gibson	Carlton Gibson	"[https://forum.djangoproject.com/t/gsoc-2020-parallel-test-runner/2528/17 Reported by Ahmad on the forum], there's an intermittent test failure with Windows+Postgres. 

{{{
(django) PS C:\Users\carlt\src\django\tests> python .\runtests.py --settings=test_postgres m2m_through.tests.M2mThroughTests
Testing against Django installed in 'c:\users\carlt\src\django\django'
Creating test database for alias 'default'...
System check identified no issues (0 silenced).
.....................F...................
======================================================================
FAIL: test_order_by_relational_field_through_model (m2m_through.tests.M2mThroughTests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""C:\Users\carlt\src\django\tests\m2m_through\tests.py"", line 247, in test_order_by_relational_field_through_model
    [self.jim, self.bob]
AssertionError: Sequences differ: <QuerySet [<Person: Person object (1)>, <Person: Person object (2)>]> != [<Person: Person object (2)>, <Person: Person object (1)>]

First differing element 0:
<Person: Person object (1)>
<Person: Person object (2)>

- <QuerySet [<Person: Person object (1)>, <Person: Person object (2)>]>
? ----------                         ^                            ^   -

+ [<Person: Person object (2)>, <Person: Person object (1)>]
?                          ^                            ^


----------------------------------------------------------------------
Ran 41 tests in 0.264s

FAILED (failures=1)
Destroying test database for alias 'default'...
}}}

Looks like a non-deterministic ordering problem. 

Reproduced at 615e32162ff646db3456b90fb4eaaecc33dd3e4e.
"	Bug	closed	Database layer (models, ORM)	dev	Normal	fixed	Tests, Windows	Ahmad A. Hussein	Accepted	1	0	0	0	0	0