Physical connection is not usable

Fixed in

EPiServer.CMS.Core 11.20.0

Created

Sep 10, 2020

Updated

Oct 08, 2020

State

Closed, Fixed and tested


Description

steps to reproduce:

  1. Create a new database on Azure and connect Alloy site to it
  2. Scale up the database and visit Alloy
    Expected: There is no downtime when scaling up
    Actual: The site is down for some times because of physical connection is closed

Note: When scaling the database, there is a small-time the physical connection is down. If the transaction begins after the physical connection is down, Alloy site will throw error code -1 and we can handle with retry policy. On another hand, the transaction begins right before the physical connection down, it's another problem (see screenshot 2).