大家有没有遇到过这样的问题,怎么解决的
一个.net core 3.1 的webapi应用,里面有连接sqlserver数据库的操作
在window平台运行正常
发布到centos7直接运行也正常
发布到centos7的docker容器之后就连接超时:
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.

centos版本:centos-release-7-7.1908.0.el7.centos.x86_64

Docker版本:Docker version 19.03.8, build afacb8b

以下是测试的Controller

namespace WebApplication3.Controllers
{
    [ApiController]
    [Route("[controller]")]
    public class TestController : ControllerBase
    {
        [HttpGet]
        public string Get()
        {
            String connsql = "server=127.0.0.1,1433;database=test;uid=sa;password=123456;"; 
            try
            {
                using (SqlConnection conn = new SqlConnection())
                {
                    conn.ConnectionString = connsql;
                    conn.Open(); 
                    String sql = "select * from test"; 
                    SqlDataAdapter myda = new SqlDataAdapter(sql, conn); 
                    DataTable dt = new DataTable(); 
                    myda.Fill(dt); 
                    conn.Close(); 
                    return dt.Rows[0][1].ToString();
                }
            }
            catch (Exception ex)
            {
                return "错误信息：" + ex.Message;
            }
        }
    }
}

以下是Dockerfile文件

FROM mcr.microsoft.com/dotnet/core/aspnet:3.1-buster-slim AS base
WORKDIR /app
EXPOSE 80
COPY . .
ENTRYPOINT ["dotnet", "WebApplication3.dll"]