CMS 12 site crash due to SQL timeout error when working in CMS edit mode

  • Updated
Description

The CMS 12 site crash repeatedly when deployed to on-premise Linux server. This error occurs constantly:

Failed to Read cacheKey = 'EP:HashedContentVersion:2015208586'
Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
---> System.ComponentModel.Win32Exception (258): Unknown error 258
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

 

Resolution

Because ASP Net Core on Linux only sets ThreadPool.MaxThreads = 8 by default. The CMS edit mode needs much more than that to load resources and assets.

The issue can be fixed by configuring NetCore runtime as described here: https://docs.microsoft.com/en-us/dotnet/core/runtime-config/threading#maximum-threads.

Note for clarity: this does not apply to our DxP Linux app services (CMS 12 .NET Core sites).