Server Error in '/' Application.

Transaction (Process ID 150) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Transaction (Process ID 150) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Source Error:


Line 3650:                var dr = db.Reader(select);
Line 3651:
Line 3652:                while (dr.Read())
Line 3653:                {
Line 3654:                    if (lastProduct == null || lastProduct.P_Id != Convert.ToInt32(dr["P_Id"]))

Source File: C:\clcdesq\cci\DAO\ProductDAO.custom.cs    Line: 3652

Stack Trace:


[SqlException (0x80131904): Transaction (Process ID 150) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +212
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +81
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +631
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4411
   System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) +240
   System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) +267
   System.Data.SqlClient.SqlDataReader.Read() +30
   cci.DAO.ProductDAO.GetProductsListFull(QuerySelect select) in C:\clcdesq\cci\DAO\ProductDAO.custom.cs:3652
   cci.DAO.ProductDAO.GetProductListPublicForNode_Recursive_Subset(ProductListForNodeRequest request, Int32 rowStart, Int32 rowEnd, String sortBy) in C:\clcdesq\cci\DAO\ProductDAO.custom.cs:4394
   public_site.Products.UserControls.DynamicControls.UCRProductsFromOneOrMoreNodes_WithCarousel.BindProductCarousel(Conf_UcProductsFromNodeCarouselModule config) in C:\clcdesq\public_site\Products\UserControls\DynamicControls\UCRProductsFromOneOrMoreNodes_WithCarousel.ascx.cs:35
   public_site.Products.UserControls.DynamicControls.UCRProductsFromOneOrMoreNodes_WithCarousel.Page_Load(Object sender, EventArgs e) in C:\clcdesq\public_site\Products\UserControls\DynamicControls\UCRProductsFromOneOrMoreNodes_WithCarousel.ascx.cs:30
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +85
   System.Web.UI.Control.OnLoad(EventArgs e) +79
   System.Web.UI.Control.LoadRecursive() +130
   System.Web.UI.Control.LoadRecursive() +200
   System.Web.UI.Control.LoadRecursive() +200
   System.Web.UI.Control.LoadRecursive() +200
   System.Web.UI.Control.LoadRecursive() +200
   System.Web.UI.Control.LoadRecursive() +200
   System.Web.UI.Control.LoadRecursive() +200
   System.Web.UI.Control.LoadRecursive() +200
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2850


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4700.0