首页 新闻 会员 周边

Oracle连接数据库超时

0
悬赏园豆:5 [待解决问题]

Net5 WebApi项目
使用Oracle.ManageDataAccess.Core 版本号3.21.110

"oracle":"data source=192.168.1.1/his;password=12345;user id=app;Pooling = true;Max Pool Size = 200;Min Pool Size = 10;Connection Timeout=200;Validate connection=true",

但是报错提示:
racle.ManagedDataAccess.Client.OracleException (0x80004005): Pooled connection request timed out
at OracleInternal.ConnectionPool.PoolManager3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch) at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch) at OracleInternal.ConnectionPool.OracleConnectionDispenser3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, OracleConnection connRefForCriteria)
at Oracle.ManagedDataAccess.Client.OracleConnection.Open()
at HS.GS.MI.Platfom.Api.Startup.<ConfigureServices>b__4_2(IServiceProvider x)
at ResolveService(ILEmitResolverBuilderRuntimeContext , ServiceProviderEngineScope )
at ResolveService(ILEmitResolverBuilderRuntimeContext , ServiceProviderEngineScope )
at ResolveService(ILEmitResolverBuilderRuntimeContext , ServiceProviderEngineScope )
at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.GetService(IServiceProvider sp, Type type, Type requiredBy, Boolean isDefaultParameterRequired)
at lambda_method985(Closure , IServiceProvider , Object[] )
at Microsoft.AspNetCore.Mvc.Controllers.ControllerFactoryProvider.<>c__DisplayClass5_0.<CreateControllerFactory>g__CreateController|0(ControllerContext controllerContext)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
--- End of stack trace from previous location ---
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextResourceFilter>g__Awaited|24_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeFilterPipelineAsync()
--- End of stack trace from previous location ---
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker)
at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)
at StackExchange.Profiling.MiniProfilerMiddleware.Invoke(HttpContext context) in C:\projects\dotnet\src\MiniProfiler.AspNetCore\MiniProfilerMiddleware.cs:line 121
at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
at HS.MI.Platform.Api.MiddleWares.ApiHeadeAuthentiactionMiddlware.InvokeAsync(HttpContext context)
at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
at HS.MI.Platfom.Api.MiddleWares.CustomExceptionMiddleware.InvokeAsync(HttpContext context)

有没有超级大神帮忙看一下是什么原因,有些服务器合适的,就2个服务器偶尔会出状况,提示这个超时了

矜持先森么么哒的主页 矜持先森么么哒 | 初学一级 | 园豆:0
提问于:2023-08-10 16:58
< >
分享
所有回答(2)
0
dudu | 园豆:30948 (高人七级) | 2023-08-10 18:00
0

经常超时还是偶尔

tea2007 | 园豆:1 (初学一级) | 2023-08-11 15:50

好像是EFCore把连接池耗尽了,但是目前还没有找到解决方法,还得在查查

支持(0) 反对(0) 矜持先森么么哒 | 园豆:0 (初学一级) | 2023-08-18 08:47
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册