PostgreSQL with pgAdmin container fails to start in .NET 8 Aspire project

[SarperMakas]

Environment

• .NET8
• Aspire.Hosting.PostgreSQL Version 8.2.
• Linux environment (Linux Mint)
• Docker installed and running

Description

When starting my Aspire application with PostgreSQL and pgAdmin, I'm receiving a Docker container creation error. The pgAdmin container fails to start but postgres container runs without problem.

fail: Aspire.Hosting.Dcp.dcpctrl.ContainerReconciler[0]
      could not create the container    {"Container": {"name":"db-pgadmin-cnuhjytg"}, "Reconciliation": 6, "error": "docker command 'CreateContainer' returned with non-zero exit code 1: command output: Stdout: '' Stderr: 'Error response from daemon: invalid mount config for type \"bind\": bind source path does not exist: /tmp/tmpWlMhYF.tmp\n'"}

Code

The relevant code in my Program.cs in the AppHost project:

var builder = DistributedApplication.CreateBuilder(args);

var db = builder.AddPostgres("db").WithPgAdmin();

var graduatesdb = db.AddDatabase("Graduates");

var apiService = builder.AddProject<Projects.Graduates_ApiService>("apiservice").WithReference(graduatesdb);

builder.AddProject<Projects.Graduates_Web>("webfrontend")
    .WithExternalHttpEndpoints()
    .WithReference(apiService);

builder.Build().Run();

How can I properly configure the pgAdmin container in an Aspire project to avoid this error?

[davidfowl]

What version of docker?

cc @karolz-ms @danegsta

[SarperMakas]

Docker version 28.0.4, build b8034c0
Also I'm using Linux Mint 22

[karolz-ms]

@SarperMakas can you try with Aspire 9.1? Aspire 8.x is out of support.

[SarperMakas]

I switched to .NET 9 and now I'm getting a different error but it's also docker related:

fail: Aspire.Hosting.Dcp.dcpctrl.ContainerReconciler[0]
     could not create the container    {"Container": {"name":"db-pgadmin-nuxfujfp"}, "Reconciliation": 7, "error": "object not found\ncontainer not found\ndocker command 'CreateContainer' returned with non-zero exit code 1: command output: Stdout: '' Stderr: ''"}

[danegsta]

Somehow .NET is failing to create the required temp path for the pgadmin config or Docker is failing to read the path. What Linux distro are you running? I’m wondering if this could be an selinux permission issue…

In Aspire 9.2 this issue should go away on its own as we’re switching to using docker cp to write the necessary pgadmin config file instead of using a bind mount.

[SarperMakas]

I'm using Linux Mint 22. I switched to .NET 9 and now I'm getting a different error but it's also docker related:

fail: Aspire.Hosting.Dcp.dcpctrl.ContainerReconciler[0]
      could not create the container    {"Container": {"name":"db-pgadmin-nuxfujfp"}, "Reconciliation": 7, "error": "object not found\ncontainer not found\ndocker command 'CreateContainer' returned with non-zero exit code 1: command output: Stdout: '' Stderr: ''"}

[danegsta]

It seems that your Docker install may not be in a fully healthy state if it’s failing to create the actual container.

If I’m not mistaken, Linux Mint is based on Ubuntu; does it support snap package installs? If you did install Docker via snap (vs the Docker apt feed), we’ve seen a large number of issues with the Docker snap install over in the Docker extension for VSCode so that could be what’s happening here too.

[SarperMakas]

Yes Linux Mint is based on Ubuntu but I didn't install from snap packages.

I followed this documentation: https://docs.docker.com/engine/install/ubuntu/#install-using-the-repository

[SarperMakas]

Using .NET 9 throws another error instead of this.

fail: Aspire.Hosting.Dcp.dcpctrl.ContainerReconciler[0] could not create the container {"Container": {"name":"db-pgadmin-vmhkcwxq"}, "Reconciliation": 6, "error": "object not found\ncontainer not found\ndocker command 'CreateContainer' returned with non-zero exit code 1: command output: Stdout: '' Stderr: ''"}

Changing my distro worked for me. I changed linux mint to arch linux.