Hi,
We are experiencing a database error and cannot find the reason from the error trace at Monitoring. It is a non-repeteable error (it happens randomly) and it triggers a cascade of template errors that finally crash the server.
We need more info about the error, or alternative ways to search for the reason.
This is the first error:
SELECT TOP 1 SUM( [Statv2Session].[Statv2SessionPageviews] ) AS [Pageviews], COUNT( [Statv2Session].[Statv2SessionID] ) AS [Visits], MAX( [Statv2Session].[Statv2SessionLastvisitDate] ) AS [LastVisit] FROM [Statv2Session] WHERE ( [Statv2Session].[Statv2SessionVisitorID] = @p0 ) AND ( [Statv2Session].[Statv2SessionTimestamp] >= @p1 ). System.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 (0x80004005): The wait operation timed out
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, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at Dynamicweb.Data.Database.CreateDataReader(IDbCommand command, CommandBehavior behavior) ClientConnectionId:ba81990b-2f61-4f09-9dbd-480695f8dd66 Error Number:-2,State:0,Class:11
2021-05-19 13:40:03.979: Request headers: [ "Cache-Control", "Connection", "Pragma", "Accept", "Accept-Encoding", "From", "Host", "User-Agent" ]
2021-05-19 13:40:03.979: Request item keys: [ "owin.Environment", "EcomCart:CustomCartContext", "Dynamicweb.Analytics.VisitorCookie", "ExecutionTableMapper", "MS_HttpRequestMessage", "AspSession", "PermissionContextStack", "Dynamicweb.OMC.VisitorEngagementSettings.Config", "Dynamicweb.OMC.VisitContext", "AspSessionIDManagerInitializeRequestCalled", "alternateUrlKey", {}, "DWPAGEVIEW", "Dynamicweb.Environment.Web", "Dynamicweb.Tracking.Tracker" ]
2021-05-19 13:40:03.979: Request form: []
------
And this is one of the cascade errors:
Error executing razor template (Designs/Rapido/_parsed/MyPage.parsed.cshtml) https://myweb.com/Default.aspx?ID=2399&GroupID=GROUP538&ProductID=PROD8432. System.Runtime.InteropServices.COMException (0x800704CD): An operation was attempted on a nonexistent network connection. (Exception from HRESULT: 0x800704CD)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Web.Hosting.IIS7WorkerRequest.PushPromise(String virtualPath, String queryString, String method, NameValueCollection headers)
at System.Web.HttpResponse.PushPromise(String path, String method, NameValueCollection headers)
at Dynamicweb.Rendering.TemplateBase`1.PushPromise(String path)
at CompiledRazorTemplates.Dynamic.RazorEngine_d74ddf3f5d404f89b6020300523e0491.<RenderMasterScriptReferences>b__181_0(TextWriter __razor_helper_writer) in D:\Dynamicweb.net\Solutions\myserver.com\Files\Templates\Designs\Rapido\_parsed\MyPage.parsed.cshtml:line 7106
at RazorEngine.Templating.TemplateWriter.ToString()
at System.Lazy`1.CreateValue()
at System.Lazy`1.LazyInitValue()
at CompiledRazorTemplates.Dynamic.RazorEngine_d74ddf3f5d404f89b6020300523e0491.<>c__DisplayClass3_0.<RenderBlock>b__0(TextWriter __razor_helper_writer) in D:\Dynamicweb.net\Solutions\NetAService\myserver.com\Files\Templates\Designs\Rapido\_parsed\MyPage.parsed.cshtml:line 230
at CompiledRazorTemplates.Dynamic.RazorEngine_d74ddf3f5d404f89b6020300523e0491.<>c__DisplayClass2_0.<RenderBlockList>b__0(TextWriter __razor_helper_writer) in D:\Dynamicweb.net\Solutions\NetAService\myserver.com\Files\Templates\Designs\Rapido\_parsed\MyPage.parsed.cshtml:line 140
at CompiledRazorTemplates.Dynamic.RazorEngine_d74ddf3f5d404f89b6020300523e0491.<>c__DisplayClass3_0.<RenderBlock>b__0(TextWriter __razor_helper_writer) in D:\Dynamicweb.net\Solutions\NetAService\myserver.com\Files\Templates\Designs\Rapido\_parsed\MyPage.parsed.cshtml:line 263
at CompiledRazorTemplates.Dynamic.RazorEngine_d74ddf3f5d404f89b6020300523e0491.<>c__DisplayClass2_0.<RenderBlockList>b__0(TextWriter __razor_helper_writer) in D:\Dynamicweb.net\Solutions\NetAService\myserver.com\Files\Templates\Designs\Rapido\_parsed\MyPage.parsed.cshtml:line 140
at CompiledRazorTemplates.Dynamic.RazorEngine_d74ddf3f5d404f89b6020300523e0491.<>c__DisplayClass3_0.<RenderBlock>b__0(TextWriter __razor_helper_writer) in D:\Dynamicweb.net\Solutions\NetAService\myserver.com\Files\Templates\Designs\Rapido\_parsed\MyPage.parsed.cshtml:line 263
at CompiledRazorTemplates.Dynamic.RazorEngine_d74ddf3f5d404f89b6020300523e0491.<>c__DisplayClass2_0.<RenderBlockList>b__0(TextWriter __razor_helper_writer) in D:\Dynamicweb.net\Solutions\NetAService\myserver.com\Files\Templates\Designs\Rapido\_parsed\MyPage.parsed.cshtml:line 140
at CompiledRazorTemplates.Dynamic.RazorEngine_d74ddf3f5d404f89b6020300523e0491.Execute() in D:\Dynamicweb.net\Solutions\myserver.com\Files\Templates\Designs\Rapido\_parsed\MyPage.parsed.cshtml:line 7562
at RazorEngine.Templating.TemplateBase.RazorEngine.Templating.ITemplate.Run(ExecuteContext context, TextWriter reader)
at RazorEngine.Templating.RazorEngineService.RunCompile(ITemplateKey key, TextWriter writer, Type modelType, Object model, DynamicViewBag viewBag)
at RazorEngine.Templating.RazorEngineServiceExtensions.<>c__DisplayClass16_0.<RunCompile>b__0(TextWriter writer)
at RazorEngine.Templating.RazorEngineServiceExtensions.WithWriter(Action`1 withWriter)
at Dynamicweb.Rendering.Template.RenderRazorTemplate()
2021-05-19 13:40:26.742: Request headers: [ "Cache-Control", "Connection", "Pragma", "Accept", "Accept-Encoding", "From", "Host", "User-Agent" ]
2021-05-19 13:40:26.742: Request item keys: [ "Dynamicweb.Environment.Web", "PagePermissionWithInheritanceFrontend2399", "Master", "Product.UnitStock.49591...", "Product", "Dynamicweb.OMC.VisitorEngagementSettings.Config", "DWPAGEVIEW", "XmlNavigation.GlobalNode2399", "owin.Environment", "Discounts.PROD8432...EUR.ES.SHOP14", "0002B205_LANG1", "Navigation.0.1.99.1.17", "ActiveGroup", "PermissionContextStack", "alternateUrlKey", "Navigation.0.1.5.0.17", "MyLiveIntegrationAddInWebServiceURI", "Ecom.SaveMethodCombos", "Ecom.SaveMethodCustomCombos", "Rendering.Items.ItemRelationListEditor_SocialLinks_2209", {}, "Dynamicweb.OMC.VisitContext", "eCommerce.Price.CachedPrices", "Price.PROD8432..LANG1..EUR.SHOP14", "EcomCart:CustomCartContext", "EcomXmlNavigationItemsForPageId_2399", "Dynamicweb.Analytics.VisitorCookie", "PagePermissionWithInheritanceFrontend2669", "Dynamicweb.Tracking.Tracker", "MS_HttpRequestMessage", "AspSession", "ExecutionTableMapper", "Product.UnitList.49591.languageId", "Rendering.Items.ItemRelationListEditor_CardTypeAndVerifiedPayment_2210", "Price.Collection.SELECT EcomPrices.* FROM EcomPrices WHERE PriceProductID=\u0027PROD8432\u0027 ORDER BY PriceID", "DiscountInfos.PROD8432...EUR.ES.SHOP14", "AspSessionIDManagerInitializeRequestCalled" ]
2021-05-19 13:40:26.742: Request form: []
Regards,
Tomas