the 4.2 VPS often shows timeout in log.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
System.Data.SqlClient.SqlException (0x80131904): 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 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues)
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues)
at Microsoft.EntityFrameworkCore.Query.QueryMethodProvider._FastQuery[TEntity](RelationalQueryContext relationalQueryContext, ShaperCommandContext shaperCommandContext, Func`3 materializer, Type contextType, IDiagnosticsLogger`1 logger)+MoveNext()
at Nop.Services.Localization.LocalizationService.ResourceValuesToDictionary(IEnumerable`1 locales)
at Nop.Services.Localization.LocalizationService.<>c__DisplayClass22_0.<GetAllResourceValues>b__0()
at EasyCaching.InMemory.DefaultInMemoryCachingProvider.BaseGet[T](String cacheKey, Func`1 dataRetriever, TimeSpan expiration)
at EasyCaching.Core.EasyCachingAbstractProvider.Get[T](String cacheKey, Func`1 dataRetriever, TimeSpan expiration)
at Nop.Core.Caching.MemoryCacheManager.Get[T](String key, Func`1 acquire, Nullable`1 cacheTime) in /home/maple/nopCommerce-release-4.20/src/Libraries/Nop.Core/Caching/MemoryCacheManager.cs:line 42
at Nop.Services.Localization.LocalizationService.GetAllResourceValues(Int32 languageId, Nullable`1 loadPublicLocales)
at Nop.Services.Localization.LocalizationService.GetResource(String resourceKey, Int32 languageId, Boolean logIfNotFound, String defaultValue, Boolean returnEmptyIfNotFound)
at Nop.Web.Areas.Admin.Factories.CommonModelFactory.PrepareStoreUrlWarningModel(IList`1 models)
at Nop.Web.Areas.Admin.Factories.CommonModelFactory.PrepareSystemWarningModels()
at Nop.Web.Areas.Admin.Controllers.HomeController.Index()
... ...
under Nopcommerce 4.3
There is insufficient system memory in resource pool 'internal' to run this query.
System.Data.SqlClient.SqlException (0x80131904): There is insufficient system memory in resource pool 'internal' to run this query.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite, String methodName)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at LinqToDB.Data.DataConnection.ExecuteNonQuery()
at LinqToDB.Linq.QueryRunner.NonQueryQuery(Query query, IDataContext dataContext, Expression expr, Object[] parameters)
at LinqToDB.Linq.QueryRunner.<>c__DisplayClass29_0.<SetNonQueryQuery>b__0(IDataContext db, Expression expr, Object[] ps)
at LinqToDB.Linq.QueryRunner.Update`1.Query(IDataContext dataContext, T obj, String tableName, String databaseName, String schemaName)
at Nop.Data.BaseDataProvider.UpdateEntity[TEntity](TEntity entity) in D:\nopCommerce_4.30\src\Libraries\Nop.Data\BaseDataProvider.cs:line 152
at Nop.Services.Customers.CustomerService.UpdateCustomer(Customer customer) in D:\nopCommerce_4.30\src\Libraries\Nop.Services\Customers\CustomerService.cs:line 609