[CI Failure] Flaky: AzureSqlPrincipalReconciliationTests fail because SqlServerContainerFixture cannot bind port 1433 (address already in use)
- Dominant language
- C#
- Stars
- 6.3k
- Forks
- 991
- Avg merge
- 2d 15h
- Merged PRs (30d)
- 196
Description
## Build Information
Build: https://github.com/microsoft/aspire/actions/runs/31019606526
Build error leg or test failing: Tests / Hosting.Azure / Hosting.Azure (ubuntu-latest) / `Aspire.Hosting.Azure.Tests.AzureSqlPrincipalReconciliationTests`
Pull request: #19007
## Error Message
```
Class fixture type 'Aspire.Hosting.Azure.Tests.SqlServerContainerFixture' threw in InitializeAsync
---- Docker.DotNet.DockerApiException : Docker API responded with status code=InternalServerError, response={"message":"failed to set up container networking: driver failed programming external connectivity on endpoint ...: failed to bind host port for 0.0.0.0::172.17.0.3:1433/tcp: address already in use"}
at Aspire.Hosting.Azure.Tests.SqlServerContainerFixture.InitializeAsync() in SqlServerContainerFixture.cs:line 28
```
## Description
Flaky: AzureSqlPrincipalReconciliationTests fail because SqlServerContainerFixture cannot bind port 1433 (address already in use)
**Type**: flaky-test
## Occurrences
| Date | Build | Job | PR |
|------|-------|-----|----|
| 2026-08-05 | [31019606526](https://github.com/microsoft/aspire/actions/runs/31019606526) | Tests / Hosting.Azure / Hosting.Azure (ubuntu-latest) | #19007 |
| 2026-08-05 | [31047577163](https://github.com/microsoft/aspire/actions/runs/31047577163) | Tests / Hosting-1 / Hosting-1 (windows-latest) | #18850 |
| 2026-08-20 | [32403422458](https://github.com/microsoft/aspire/actions/runs/32403422458) | Tests / Hosting.Azure / Hosting.Azure (ubuntu-latest) | #19238 |
| 2026-09-02 | [33578521517](https://github.com/microsoft/aspire/actions/runs/33578521517) | Tests / Hosting.GitHub.Models / Hosting.GitHub.Models (windows-latest) | #19670 |
| 2026-09-10 | [34433050282](https://github.com/microsoft/aspire/actions/runs/34433050282) | Tests / No-package tests (regular, Aspire.Cli.Tests, Cli, Cli, tests/Aspire.Cli.Tests/Aspire.Cli.Tests.cs... / Cli (macos-latest) | #19682 |
| 2026-09-17 | [35166494293](https://github.com/microsoft/aspire/actions/runs/35166494293) | Tests / No-package tests (regular, Aspire.Hosting.Azure.Tests, Hosting.Azure, Hosting.Azure, tests/Aspire... / Hosting.Azure (ubuntu-latest) | #20046 |
Contributor guide
Research direction
Start by reading SqlServerContainerFixture.InitializeAsync at line 28 and running Aspire.Hosting.Azure.Tests.AzureSqlPrincipalReconciliationTests. Compare the repeated failures across the listed CI jobs; done means the fixture or test no longer fails because host port 1433 is already in use.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure, csharp, docker
- Domain
- ci-cd, databases, testing
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 48/100