Opened 21 months ago

Closed 21 months ago

Last modified 21 months ago

#34381 closed Bug (fixed)

Postgres tests fail on Windows

Reported by: David Smith Owned by: nobody
Component: Core (Other) Version: 4.1
Severity: Normal Keywords:
Cc: Triage Stage: Accepted
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

Running the test suite using the postgres backend on Windows currently results in the following test failures. I'll attach the full log as well.

These look like isolation issues as running migrations.test_commands.MigrateTests.test_migrate_initial_false on it's own for example passes.

ERROR: test_empty_result_set (postgres_tests.test_aggregates.TestGeneralAggregate.test_empty_result_set) [<object object at 0x00000217E2F6AD60>] (aggregation=(BitXor(F(integer_field)), None))

ERROR: test_migrate_other_database (auth_tests.test_migrations.MultiDBProxyModelAppLabelTests.test_migrate_other_database)

ERROR: test_ops_class (indexes.tests.SchemaIndexesPostgreSQLTests.test_ops_class)

ERROR: test_migrate_fake_split_initial (migrations.test_commands.MigrateTests.test_migrate_fake_split_initial)

ERROR: test_migrate_partially_applied_squashed_migration (migrations.test_commands.MigrateTests.test_migrate_partially_applied_squashed_migration)
Migrating to a squashed migration specified by name should succeed

FAIL: test_add_legacy_name_other_database 

FAIL: test_foreign_data_wrapper (inspectdb.tests.InspectDBTransactionalTests.test_foreign_data_wrapper)

FAIL: test_migrate_fake_initial (migrations.test_commands.MigrateTests.test_migrate_fake_initial)

FAIL: test_migrate_initial_false (migrations.test_commands.MigrateTests.test_migrate_initial_false)

Attachments (2)

postgres log.txt​ (154.7 KB ) - added by David Smith 21 months ago.
Test log using postgresql backend on Windows.
postgres log2.txt​ (12.7 KB ) - added by David Smith 21 months ago.

Download all attachments as: .zip

Change History (10)

by David Smith, 21 months ago

Attachment: postgres log.txt​ added

Test log using postgresql backend on Windows.

comment:1 by Mariusz Felisiak, 21 months ago

Component: Database layer (models, ORM) → Core (Other)
Triage Stage: Unreviewed → Accepted
Type: Uncategorized → Bug

Thanks for the report. I fixed isolation of MigrateTests.test_migrate_fake_initial() in ​PR. Can you check how many failures are left?

comment:2 by GitHub <noreply@…>, 21 months ago

In 61f599ae:

Refs #34381 -- Fixed isolation of MigrateTests.test_migrate_fake_initial().

by David Smith, 21 months ago

Attachment: postgres log2.txt​ added

comment:3 by Mariusz Felisiak, 21 months ago

InspectDBTransactionalTests.test_foreign_data_wrapper crash on Windows was fixed in 798835112d81b852efaae0e067af389c733cd1b3, maybe it's a test regression in db7bb3b64e469fbb5c79e7b5b2fcb890434aa60f 🤔 It's definitely related with os.devnull.

comment:4 by David Smith, 21 months ago

Following 61f599ae I've uploaded a new log showing the three remaining test failures.

indexes.tests.SchemaIndexesPostgreSQLTests.test_ops_class appears to be an isolation issue. The other two fail running those single tests.

I'll try and investigate further.

comment:5 by GitHub <noreply@…>, 21 months ago

In b05dfc28:

Refs #34381, Refs #10929 -- Fixed postgres_tests.test_aggregates.TestGeneralAggretate.test_empty_result_set() on PostgreSQL 14+.

Follow up to 0be8095b254fad65b2480d677ebe6098c41bbad6.

comment:6 by Mariusz Felisiak <felisiak.mariusz@…>, 21 months ago

In 507bc13:

Refs #34381 -- Fixed InspectDBTransactionalTests.test_foreign_data_wrapper() on Windows.

comment:7 by Mariusz Felisiak, 21 months ago

Resolution: → fixed
Status: new → closed

This should be already fixed.

comment:8 by David Smith, 21 months ago

I agree all these test failures are now resolved.

Note: See TracTickets for help on using tickets.
Back to Top