locked
Keep getting this message yesterday only "The underlying provider failed on Open. The wait operation timed out." using Entity Framework RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I have a SQL Azure database and a web app. Both are in US West datacenter.

    I count the number of rows in a table every 15 minutes and no other apps use this database.

    Everything "usually" works fine but there is an ~12 hours period yesterday I kept getting this error:

    "The underlying provider failed on Open. The wait operation timed out."

    And around 5pm PST yesterday, everything worked fine again. I didn't do anything because I didn't know what I can do.

    In my Entity Framework code, I already added retry logic, i.e: SqlAzureExecutionStrategy

    Does anyone have the same issue before?

    Is there any way to prevent this problem happening again?

    Thanks!

    Thursday, June 11, 2015 6:43 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi ThunderDC,

     There was a partial service interruption  with SQL Database service in the WestUS region. The issue has been mitigated.
     Below is the Description for the Azure Service Dashboard : http://azure.microsoft.com/en-us/status/#history
     
     "SQL Database - West US - Partial Service Interruption
      From 17:40 to 22:42 on 10 Jun 2015 UTC a very small subset of customers using SQL V12 Databases in West US may have encountered intermittent connectivity errors. Engineering teams have deployed a mitigation and normal service connectivity has been restored. "
      
     If you need to know more about this downtime, you can contact support by creating a support ticket.
      
    Regards,
    Nithin Rathnakar

    Friday, June 12, 2015 7:28 AM