ADO.NET problems in Linux

[HSXDev]

I'm not being able to execute a simple DbConnection.Open() on a docker image running on Debian 10 (buster), i'm receiving the following message:

"Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached."

If i change the dockerfile to run in Ubuntu(bionic) everything works fine until i need to do a bulk insert.

Running in a windows container works just fine.

[roji]

What database exactly are you running against? Can you share your csproj, connection string, etc.?

[roji]

Also, which docker image exactly are you using?

[HSXDev]

Hey Roji, sorry for the late response.

I'm using SQL Server, my connection string is: "<providerName="System.Data.SqlClient" connectionString="Data Source=ServerName;Initial Catalog=DatabaseName;user=UserName;password=Password;MinPoolSize=10;MaxPoolSize=25;Pooling=true;"/>

Unfortunatelly i cannot share my csproj, but the code snippet where the error occurs is something like:

using (IDbConnection dbConnection = new SqlConnection(MyConnStringHere))
{
    dbConnection.Open();
    //everything else that is never reached
}

As for the docker image, i tried using the default docker file:

FROM mcr.microsoft.com/dotnet/core/aspnet:3.0-buster-slim AS base
WORKDIR /app
EXPOSE 80
EXPOSE 443

FROM mcr.microsoft.com/dotnet/core/sdk:3.0-buster AS build
WORKDIR /src
COPY ["Project/Project.csproj", "Project/"]
RUN dotnet restore "Project/Project.csproj"
COPY . .
WORKDIR "/src/Project"
RUN dotnet build "Project.csproj" -c Release -o /app/build

FROM build AS publish
RUN dotnet publish "Project.csproj" -c Release -o /app/publish

FROM base AS final
WORKDIR /app
COPY --from=publish /app/publish .
ENTRYPOINT ["dotnet", "Project.dll"]

When it didnt work i switched to:

FROM mcr.microsoft.com/dotnet/core/aspnet:3.0-bionic AS base
WORKDIR /app
EXPOSE 80
EXPOSE 443

FROM mcr.microsoft.com/dotnet/core/sdk:3.0-bionic AS build
WORKDIR /src
COPY ["Project/Project.csproj", "Project/"]
RUN dotnet restore "Project/Project.csproj"
COPY . .
WORKDIR "/src/Project"
RUN dotnet build "Project.csproj" -c Release -o /app/build

FROM build AS publish
RUN dotnet publish "Project.csproj" -c Release -o /app/publish

FROM base AS final
WORKDIR /app
COPY --from=publish /app/publish .
ENTRYPOINT ["dotnet", "Project.dll"]

Also to no avail.

[cheenamalhotra]

Hi @HSXDev

There are other related reported issues in Linux docker environments, e.g. #201 we'll address them all together.

[sinanbaran]

we solved our problem using mcr.microsoft.com/dotnet/core/aspnet:3.0-bionic

[cheenamalhotra]

Closing as this is similar to #201 and addressed with #577
Please open a new issue with repro if you face this again.