ASP.NET Core Web API controller method throws 'transient failure'

Question

Using Entity Framework 6 in an ASP.NET Core Web API.

I have the following controller:

[Route("[controller]/[action]")]
[ApiController]
public class ContactController : ControllerBase
{
    FalconDataContext _context;

    public ContactController(FalconDataContext context)
    {
        _context = context;
    }

    [HttpGet]
    public async Task<ActionResult<IEnumerable<ContactModel>>> GetAllContacts()
    {
        var contacts = await _context.Contacts.ToListAsync();
        return Ok(contacts);
    }
}

When I run this in Swagger I get

An exception has been raised that is likely due to a transient failure. Consider enabling transient error resiliency by adding 'EnableRetryOnFailure' to the 'UseSqlServer' call

on the call to DbContext.

This just started happening. It was working a few day ago. What is this and how do I solve it?

did you configure you dbcontext properly in program.cs

n___dv
– n___dv

2025-04-18 12:53:16 +00:00
Commented Apr 18 at 12:53 — n___dv
– n___dv, Commented Apr 18 at 12:53
user Scope base di for db context in program cs

n___dv
– n___dv

2025-04-18 12:53:55 +00:00
Commented Apr 18 at 12:53 — n___dv
– n___dv, Commented Apr 18 at 12:53

Weber K. · Accepted Answer · 2025-04-18 18:31:02Z

0

When the Controller try to connect to database, some error ocurred. Probrably retry is already enabled and the connection is succesful in second attempt, then it shows there was a transient failure.

Maybe there is a problem with your connection to your db instance. You need to track and diagnose where is the failure (network, authentication, and so on).

Some examples: First connection try a TLS version not allowed, next connection is ok.

Azure instance shutdowns after some idle time to reduce costs and restarts when needed, then second connection is ok.

You need to diagnose your setup to solve.

edited Apr 18 at 18:31

answered Apr 18 at 1:55

Weber K.

8427 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

CoderForHire Apr 18 at 2:44

OK so I just created a simple test API trying to connect to the same data, and it fails with the same message

Weber K. Apr 18 at 12:54

You need to track and diagnose the connection between application pool and your database. Another API probrably will have the same problem as it will be hosted in the same environment. Check the application logs and the database.logs.

Weber K. Apr 18 at 13:42

If these logs won't help then check event viewer.

Collectives™ on Stack Overflow

ASP.NET Core Web API controller method throws 'transient failure'

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related