1

After updating our Dotnet API from dotnet 6 to 8 the connection-attemps on AWS RDS increased significantly (see attached picture).

The API is running in a docker-container. We use a MYSQL RDS instance t4g-large the engine version is 8.0.mysql_aurora.3.04.3

The API uses the Pomelo adapter. This was not changed or touched at all. The context is injected as supposed to. (services.AddDbContext<T>)

The issue happened on three deployed applications all using MYSQL-Instances. The update only included the framework update and some nuget package updates in regards to dotnet-8.

AWS RDS Log

I also tried using the services.AddDbContextPool which helped a bit but not as much as I hoped.

Improve this question
5
  • This is not a programming problem. There's nothing we can do about it programmatically. It should be a bug report on the product's site. Commented Oct 6 at 12:35
  • who exactly you mean by we? With product site you are talking about aws or pomelo? Commented Oct 8 at 11:53
  • "we" is the Stack Overflow community. As for the product site, I'd first try the creator of the Pomelo adapter. See if anything similar was reported there. Commented Oct 8 at 11:57
  • Assuming prod-ncs is your existing EF (core?) 6 API DB and ncs-1 is your EF Core 8 API DB, there appears to be a near exact doubling of connections... Are you sure you don't have a possible double-execution? (2 APIs hitting the same DB, or 2x test execution?) Commented Oct 8 at 23:21
  • Pomelo didnt have any issues regarding this so far thats why i was a little confused. thats why I added a question here - Gert. @Stepe Py - so prod-ncs is the regional cluster; prod-ncs-1 is the writer instance; prod-ncs-2 is the reader instance. So there are of course xyz apis a backgroundworker hitting on the same db, but they are of course not using the same db-context. everyone creates their own context which is totally fine - and it was like this before so.. Commented Oct 9 at 19:28
Related questions
2
AWS Lambda: Dotnet 6 API takes 15s intermittently to connect to RDS after a deployment
0
Solving connectivity issues to AWS with MariaDB on RDS from local machine
0
How to Create AWS Aurora MySQL Serverless v1 Database
Load 4 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.