Hi all.
We caught ORA-01000: maximum open cursors exceeded.
1. We use C# EF Oracle.EntityFrameworkCore 2.18.0-beta3
2. We use DbContextPool:
...
.AddDbContextPool<ClientsDbContext>(dbConfig => dbConfig.UseOracle(
_configuration.GetConnectionString("ClientsDb"),
options => options.EnableOracleRetryOnKnownFailure(3, TimeSpan.FromSeconds(3))))
...
3. We Inject our DbContext as scoped object. So its disposed correctly each request - we checked it.
4. We use common EF operations - add, update etc, nothing special
5. The exception appears after about 2 weeks continuous service job. After the restart our service works fine. And after another 2 weeks the same exception appears again
Our suspicions - may be connections are not closed correctly inside the library? Can you recommend something to avoid this problem.
Thanks in advance