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

  • Question

  • 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?


    Thursday, June 11, 2015 6:43 PM


  • 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.
    Nithin Rathnakar

    Friday, June 12, 2015 7:28 AM