2013-11-05 07:44:17.1856 Unhandled exception occurred in Better CMS host application.
Failed to load a CMS page. System.Web.HttpException (0x80004005): Failed to load a CMS page. ---> NHibernate.Exceptions.GenericADOException: Failed to execute multi query[SQL: select page0_.Id as Id310, layout1_.Id as Id241, layoutregi2_.Id as Id262, region3_.Id as Id363, accessrule5_.Id as Id144, page0_.Version as Version310, page0_.IsDeleted as IsDeleted310, page0_.CreatedOn as CreatedOn310, page0_.ModifiedOn as ModifiedOn310, page0_.DeletedOn as DeletedOn310, page0_.CreatedByUser as CreatedB7_310, page0_.ModifiedByUser as Modified8_310, page0_.DeletedByUser as DeletedB9_310, page0_.PageUrl as PageUrl310, page0_.PageUrlHash as PageUrl11_310, page0_.Title as Title310, page0_.Status as Status310, page0_.PublishedOn as Publish14_310, page0_.MetaTitle as MetaTitle310, page0_.MetaKeywords as MetaKey16_310, page0_.MetaDescription as MetaDes17_310, page0_.LayoutId as LayoutId310, page01.Description as Descript2_330, page01.CustomJS as CustomJS330, page01.CustomCss as CustomCss330, page01.UseCanonicalUrl as UseCanon5_330, page01.UseNoFollow as UseNoFol6_330, page01.UseNoIndex as UseNoIndex330, page01.NodeCountInSitemap as NodeCoun8_330, page01.IsArchived as IsArchived330, page01.CategoryId as CategoryId330, page01.ImageId as ImageId330, page01.SecondaryImageId as Seconda12_330, page01.FeaturedImageId as Feature13_330, page02.ActivationDate as Activati2_340, page02.ExpirationDate as Expirati3_340, page02.AuthorId as AuthorId340, case when page02.Id is not null then 2 when page01.Id is not null then 1 when page0_.Id is not null then 0 end as clazz0, layout1_.Version as Version241, layout1_.IsDeleted as IsDeleted241, layout1_.CreatedOn as CreatedOn241, layout1_.ModifiedOn as ModifiedOn241, layout1_.DeletedOn as DeletedOn241, layout1_.CreatedByUser as CreatedB7_241, layout1_.ModifiedByUser as Modified8_241, layout1_.DeletedByUser as DeletedB9_241, layout1_.Name as Name241, layout1_.LayoutPath as LayoutPath241, layout1_.PreviewUrl as PreviewUrl241, layout1_.ModuleId as ModuleId241, layoutregi2_.Version as Version262, layoutregi2_.IsDeleted as IsDeleted262, layoutregi2_.CreatedOn as CreatedOn262, layoutregi2_.ModifiedOn as ModifiedOn262, layoutregi2_.DeletedOn as DeletedOn262, layoutregi2_.CreatedByUser as CreatedB7_262, layoutregi2_.ModifiedByUser as Modified8_262, layoutregi2_.DeletedByUser as DeletedB9_262, layoutregi2_.Description as Descrip10_262, layoutregi2_.LayoutId as LayoutId262, layoutregi2_.RegionId as RegionId262, layoutregi2_.LayoutId as LayoutId0, layoutregi2_.Id as Id0, region3_.Version as Version363, region3_.IsDeleted as IsDeleted363, region3_.CreatedOn as CreatedOn363, region3_.ModifiedOn as ModifiedOn363, region3_.DeletedOn as DeletedOn363, region3_.CreatedByUser as CreatedB7_363, region3_.ModifiedByUser as Modified8_363, region3_.DeletedByUser as DeletedB9_363, region3_.RegionIdentifier as RegionI10_363, accessrule5_.Version as Version144, accessrule5_.IsDeleted as IsDeleted144, accessrule5_.CreatedOn as CreatedOn144, accessrule5_.ModifiedOn as ModifiedOn144, accessrule5_.DeletedOn as DeletedOn144, accessrule5_.CreatedByUser as CreatedB7_144, accessrule5_.ModifiedByUser as Modified8_144, accessrule5_.DeletedByUser as DeletedB9_144, accessrule5_.[Identity] as column10_144, accessrule5_.AccessLevel as AccessL11_144, accessrule5_.IsForRole as IsForRole144, accessrule4_.PageId as PageId1, accessrule4_.AccessRuleId as AccessRu2_1__ from bcmsroot.Pages page0 left outer join bcms_pages.Pages page01 on page0_.Id=page01.Id left outer join bcms_blog.BlogPosts page02 on page0_.Id=page02.Id left outer join bcmsroot.Layouts layout1 on page0.LayoutId=layout1.Id left outer join bcmsroot.LayoutRegions layoutregi2 on layout1.Id=layoutregi2.LayoutId and (layoutregi2_.IsDeleted = 0) left outer join bcmsroot.Regions region3 on layoutregi2.RegionId=region3.Id left outer join bcmsroot.PageAccessRules accessrule4 on page0.Id=accessrule4.PageId left outer join bcmsroot.AccessRules accessrule5 on accessrule4.AccessRuleId=accessrule5.Id where not (page0.IsDeleted=1) and not (page0.IsDeleted=1) and page0.PageUrlHash=?;
select pageconten0.Id as Id290, content3_.Id as Id161, contentopt4_.Id as Id222, history5_.Id as Id163, options6_.Id as Id304, pageconten0_.Version as Version290, pageconten0_.IsDeleted as IsDeleted290, pageconten0_.CreatedOn as CreatedOn290, pageconten0_.ModifiedOn as ModifiedOn290, pageconten0_.DeletedOn as DeletedOn290, pageconten0_.CreatedByUser as CreatedB7_290, pageconten0_.ModifiedByUser as Modified8_290, pageconten0_.DeletedByUser as DeletedB9_290, pageconten0_.[Order] as column10_290, pageconten0_.RegionId as RegionId290, pageconten0_.ContentId as ContentId290, pageconten0_.PageId as PageId290, content3_.Version as Version161, content3_.IsDeleted as IsDeleted161, content3_.CreatedOn as CreatedOn161, content3_.ModifiedOn as ModifiedOn161, content3_.DeletedOn as DeletedOn161, content3_.CreatedByUser as CreatedB7_161, content3_.ModifiedByUser as Modified8_161, content3_.DeletedByUser as DeletedB9_161, content3_.Name as Name161, content3_.PreviewUrl as PreviewUrl161, content3_.Status as Status161, content3_.PublishedByUser as Publish13_161, content3_.PublishedOn as Publish14_161, content3_.OriginalId as OriginalId161, content31.ActivationDate as Activati2_171, content31.ExpirationDate as Expirati3_171, content31.Html as Html171, content31.CustomCss as CustomCss171, content31.UseCustomCss as UseCusto6_171, content31.CustomJs as CustomJs171, content31.UseCustomJs as UseCusto8_171, content31.EditInSourceMode as EditInSo9_171, content33.CategoryId as CategoryId191, content34.Html as Html201, content34.UseHtml as UseHtml201, content34.CustomCss as CustomCss201, content34.UseCustomCss as UseCusto5_201, content34.CustomJs as CustomJs201, content34.UseCustomJs as UseCusto7_201, content34.EditInSourceMode as EditInSo8_201, content35.Url as Url211, case when content32.Id is not null then 2 when content34.Id is not null then 4 when content35.Id is not null then 5 when content31.Id is not null then 1 when content33.Id is not null then 3 when content3_.Id is not null then 0 end as clazz1, contentopt4_.Version as Version222, contentopt4_.IsDeleted as IsDeleted222, contentopt4_.CreatedOn as CreatedOn222, contentopt4_.ModifiedOn as ModifiedOn222, contentopt4_.DeletedOn as DeletedOn222, contentopt4_.CreatedByUser as CreatedB7_222, contentopt4_.ModifiedByUser as Modified8_222, contentopt4_.DeletedByUser as DeletedB9_222, contentopt4_.[Key] as column10_222, contentopt4_.Type as Type222, contentopt4_.DefaultValue as Default12_222, contentopt4_.IsDeletable as IsDelet13_222, contentopt4_.ContentId as ContentId222, contentopt4_.CustomOptionId as CustomO15_222, contentopt4_.ContentId as ContentId0, contentopt4_.Id as Id0, history5_.Version as Version163, history5_.IsDeleted as IsDeleted163, history5_.CreatedOn as CreatedOn163, history5_.ModifiedOn as ModifiedOn163, history5_.DeletedOn as DeletedOn163, history5_.CreatedByUser as CreatedB7_163, history5_.ModifiedByUser as Modified8_163, history5_.DeletedByUser as DeletedB9_163, history5_.Name as Name163, history5_.PreviewUrl as PreviewUrl163, history5_.Status as Status163, history5_.PublishedByUser as Publish13_163, history5_.PublishedOn as Publish14_163, history5_.OriginalId as OriginalId163, history51.ActivationDate as Activati2_173, history51.ExpirationDate as Expirati3_173, history51.Html as Html173, history51.CustomCss as CustomCss173, history51.UseCustomCss as UseCusto6_173, history51.CustomJs as CustomJs173, history51.UseCustomJs as UseCusto8_173, history51.EditInSourceMode as EditInSo9_173, history53.CategoryId as CategoryId193, history54.Html as Html203, history54.UseHtml as UseHtml203, history54.CustomCss as CustomCss203, history54.UseCustomCss as UseCusto5_203, history54.CustomJs as CustomJs203, history54.UseCustomJs as UseCusto7_203, history54.EditInSourceMode as EditInSo8_203, history55.Url as Url213, case when history52.Id is not null then 2 when history54.Id is not null then 4 when history55.Id is not null then 5 when history51.Id is not null then 1 when history53.Id is not null then 3 when history5_.Id is not null then 0 end as clazz3, history5_.OriginalId as OriginalId1_, history5.Id as Id1, options6_.Version as Version304, options6_.IsDeleted as IsDeleted304, options6_.CreatedOn as CreatedOn304, options6_.ModifiedOn as ModifiedOn304, options6_.DeletedOn as DeletedOn304, options6_.CreatedByUser as CreatedB7_304, options6_.ModifiedByUser as Modified8_304, options6_.DeletedByUser as DeletedB9_304, options6_.[Key] as column10_304, options6_.Type as Type304, options6_.Value as Value304, options6_.PageContentId as PageCon13_304, options6_.CustomOptionId as CustomO14_304, options6_.PageContentId as PageCon13_2, options6_.Id as Id2__ from bcmsroot.PageContents pageconten0 inner join bcmsroot.Pages page1 on pageconten0.PageId=page1.Id inner join bcmsroot.Contents content2 on pageconten0.ContentId=content2.Id left outer join bcmsroot.Contents content3 on pageconten0.ContentId=content3.Id left outer join bcms_pages.HtmlContents content31 on content3_.Id=content31.Id left outer join bcms_blog.BlogPostContents content32 on content3_.Id=content32.Id left outer join bcms_root.Widgets content33 on content3_.Id=content33.Id left outer join bcms_pages.HtmlContentWidgets content34 on content3_.Id=content34.Id left outer join bcms_pages.ServerControlWidgets content35 on content3_.Id=content35.Id left outer join bcmsroot.ContentOptions contentopt4 on content3.Id=contentopt4.ContentId and (contentopt4_.IsDeleted = 0) left outer join bcmsroot.Contents history5 on content3.Id=history5.OriginalId and (history5_.IsDeleted = 0) left outer join bcms_pages.HtmlContents history51 on history5_.Id=history51.Id left outer join bcms_blog.BlogPostContents history52 on history5_.Id=history52.Id left outer join bcms_root.Widgets history53 on history5_.Id=history53.Id left outer join bcms_pages.HtmlContentWidgets history54 on history5_.Id=history54.Id left outer join bcms_pages.ServerControlWidgets history55 on history5_.Id=history55.Id left outer join bcmsroot.PageContentOptions options6 on pageconten0.Id=options6.PageContentId and (options6.IsDeleted = 0) where not (pageconten0.IsDeleted=1) and page1.PageUrlHash=? and (content2.Status=? or content2.Status=?) and not (pageconten0.IsDeleted=1) and not (content2.IsDeleted=1) and not (page1.IsDeleted=1);
] ---> System.Data.SqlClient.SqlException: Transaction (Process ID 752) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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.TryHasMoreRows(Boolean& moreRows)
at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
at System.Data.SqlClient.SqlDataReader.TryNextResult(Boolean& more)
at System.Data.SqlClient.SqlDataReader.NextResult()
at NHibernate.Driver.NHybridDataReader.NextResult()
at NHibernate.Driver.BatcherDataReaderWrapper.NextResult()
at NHibernate.Impl.MultiQueryImpl.DoList()
--- End of inner exception stack trace ---
at NHibernate.Impl.MultiQueryImpl.DoList()
at NHibernate.Impl.MultiQueryImpl.ListIgnoreQueryCache()
at NHibernate.Impl.MultiQueryImpl.List()
at NHibernate.Impl.FutureQueryBatch.GetResultsFrom(IMultiQuery multiApproach)
at NHibernate.Impl.FutureBatch2.GetResults() at NHibernate.Impl.FutureBatch2.get_Results()
at NHibernate.Impl.FutureBatch2.GetCurrentResult[TResult](Int32 currentIndex) at NHibernate.Impl.FutureBatch2.<>cDisplayClass41.<GetEnumerator>b__3() at NHibernate.Impl.DelayedEnumerator1.d0.MoveNext()
at System.Collections.Generic.List1..ctor(IEnumerable1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) at BetterCms.Module.Root.Commands.GetPageToRender.GetPageToRenderCommand.Execute(GetPageToRenderRequest request) at BetterCms.Module.Root.Controllers.CmsController.GetRequestModel(String virtualPath) at BetterCms.Module.Root.Controllers.CmsController.Index() at BetterCms.Module.Root.Controllers.CmsController.Index() at lambda_method(Closure , ControllerBase , Object[] ) at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary2 parameters) at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass42.<BeginInvokeSynchronousActionMethod>b__41() at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass81.b_7(IAsyncResult )
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass37.<>cDisplayClass39.b33()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass4f.b49()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass37.b36(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult1.End() at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass25.<>c__DisplayClass2a.<BeginInvokeAction>b__20() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass25.<BeginInvokeAction>b__22(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult1.End()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult)
at System.Web.Mvc.Controller.<>cDisplayClass1d.b18(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.<>cDisplayClass4.b3(IAsyncResult ar)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult1.End() at System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult1.End()
at System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult)
at System.Web.Mvc.Controller.System.Web.Mvc.Async.IAsyncController.EndExecute(IAsyncResult asyncResult)
at System.Web.Mvc.MvcHandler.<>cDisplayClass8.b3(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.<>cDisplayClass4.b3(IAsyncResult ar)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult1.End() at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) at System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) Failed to execute multi query[SQL: select page0_.Id as Id31_0_, layout1_.Id as Id24_1_, layoutregi2_.Id as Id26_2_, region3_.Id as Id36_3_, accessrule5_.Id as Id14_4_, page0_.Version as Version31_0_, page0_.IsDeleted as IsDeleted31_0_, page0_.CreatedOn as CreatedOn31_0_, page0_.ModifiedOn as ModifiedOn31_0_, page0_.DeletedOn as DeletedOn31_0_, page0_.CreatedByUser as CreatedB7_31_0_, page0_.ModifiedByUser as Modified8_31_0_, page0_.DeletedByUser as DeletedB9_31_0_, page0_.PageUrl as PageUrl31_0_, page0_.PageUrlHash as PageUrl11_31_0_, page0_.Title as Title31_0_, page0_.Status as Status31_0_, page0_.PublishedOn as Publish14_31_0_, page0_.MetaTitle as MetaTitle31_0_, page0_.MetaKeywords as MetaKey16_31_0_, page0_.MetaDescription as MetaDes17_31_0_, page0_.LayoutId as LayoutId31_0_, page0_1_.Description as Descript2_33_0_, page0_1_.CustomJS as CustomJS33_0_, page0_1_.CustomCss as CustomCss33_0_, page0_1_.UseCanonicalUrl as UseCanon5_33_0_, page0_1_.UseNoFollow as UseNoFol6_33_0_, page0_1_.UseNoIndex as UseNoIndex33_0_, page0_1_.NodeCountInSitemap as NodeCoun8_33_0_, page0_1_.IsArchived as IsArchived33_0_, page0_1_.CategoryId as CategoryId33_0_, page0_1_.ImageId as ImageId33_0_, page0_1_.SecondaryImageId as Seconda12_33_0_, page0_1_.FeaturedImageId as Feature13_33_0_, page0_2_.ActivationDate as Activati2_34_0_, page0_2_.ExpirationDate as Expirati3_34_0_, page0_2_.AuthorId as AuthorId34_0_, case when page0_2_.Id is not null then 2 when page0_1_.Id is not null then 1 when page0_.Id is not null then 0 end as clazz_0_, layout1_.Version as Version24_1_, layout1_.IsDeleted as IsDeleted24_1_, layout1_.CreatedOn as CreatedOn24_1_, layout1_.ModifiedOn as ModifiedOn24_1_, layout1_.DeletedOn as DeletedOn24_1_, layout1_.CreatedByUser as CreatedB7_24_1_, layout1_.ModifiedByUser as Modified8_24_1_, layout1_.DeletedByUser as DeletedB9_24_1_, layout1_.Name as Name24_1_, layout1_.LayoutPath as LayoutPath24_1_, layout1_.PreviewUrl as PreviewUrl24_1_, layout1_.ModuleId as ModuleId24_1_, layoutregi2_.Version as Version26_2_, layoutregi2_.IsDeleted as IsDeleted26_2_, layoutregi2_.CreatedOn as CreatedOn26_2_, layoutregi2_.ModifiedOn as ModifiedOn26_2_, layoutregi2_.DeletedOn as DeletedOn26_2_, layoutregi2_.CreatedByUser as CreatedB7_26_2_, layoutregi2_.ModifiedByUser as Modified8_26_2_, layoutregi2_.DeletedByUser as DeletedB9_26_2_, layoutregi2_.Description as Descrip10_26_2_, layoutregi2_.LayoutId as LayoutId26_2_, layoutregi2_.RegionId as RegionId26_2_, layoutregi2_.LayoutId as LayoutId0__, layoutregi2_.Id as Id0__, region3_.Version as Version36_3_, region3_.IsDeleted as IsDeleted36_3_, region3_.CreatedOn as CreatedOn36_3_, region3_.ModifiedOn as ModifiedOn36_3_, region3_.DeletedOn as DeletedOn36_3_, region3_.CreatedByUser as CreatedB7_36_3_, region3_.ModifiedByUser as Modified8_36_3_, region3_.DeletedByUser as DeletedB9_36_3_, region3_.RegionIdentifier as RegionI10_36_3_, accessrule5_.Version as Version14_4_, accessrule5_.IsDeleted as IsDeleted14_4_, accessrule5_.CreatedOn as CreatedOn14_4_, accessrule5_.ModifiedOn as ModifiedOn14_4_, accessrule5_.DeletedOn as DeletedOn14_4_, accessrule5_.CreatedByUser as CreatedB7_14_4_, accessrule5_.ModifiedByUser as Modified8_14_4_, accessrule5_.DeletedByUser as DeletedB9_14_4_, accessrule5_.[Identity] as column10_14_4_, accessrule5_.AccessLevel as AccessL11_14_4_, accessrule5_.IsForRole as IsForRole14_4_, accessrule4_.PageId as PageId1__, accessrule4_.AccessRuleId as AccessRu2_1__ from bcms_root.Pages page0_ left outer join bcms_pages.Pages page0_1_ on page0_.Id=page0_1_.Id left outer join bcms_blog.BlogPosts page0_2_ on page0_.Id=page0_2_.Id left outer join bcms_root.Layouts layout1_ on page0_.LayoutId=layout1_.Id left outer join bcms_root.LayoutRegions layoutregi2_ on layout1_.Id=layoutregi2_.LayoutId and (layoutregi2_.IsDeleted = 0) left outer join bcms_root.Regions region3_ on layoutregi2_.RegionId=region3_.Id left outer join bcms_root.PageAccessRules accessrule4_ on page0_.Id=accessrule4_.PageId left outer join bcms_root.AccessRules accessrule5_ on accessrule4_.AccessRuleId=accessrule5_.Id where not (page0_.IsDeleted=1) and not (page0_.IsDeleted=1) and page0_.PageUrlHash=?; select pageconten0_.Id as Id29_0_, content3_.Id as Id16_1_, contentopt4_.Id as Id22_2_, history5_.Id as Id16_3_, options6_.Id as Id30_4_, pageconten0_.Version as Version29_0_, pageconten0_.IsDeleted as IsDeleted29_0_, pageconten0_.CreatedOn as CreatedOn29_0_, pageconten0_.ModifiedOn as ModifiedOn29_0_, pageconten0_.DeletedOn as DeletedOn29_0_, pageconten0_.CreatedByUser as CreatedB7_29_0_, pageconten0_.ModifiedByUser as Modified8_29_0_, pageconten0_.DeletedByUser as DeletedB9_29_0_, pageconten0_.[Order] as column10_29_0_, pageconten0_.RegionId as RegionId29_0_, pageconten0_.ContentId as ContentId29_0_, pageconten0_.PageId as PageId29_0_, content3_.Version as Version16_1_, content3_.IsDeleted as IsDeleted16_1_, content3_.CreatedOn as CreatedOn16_1_, content3_.ModifiedOn as ModifiedOn16_1_, content3_.DeletedOn as DeletedOn16_1_, content3_.CreatedByUser as CreatedB7_16_1_, content3_.ModifiedByUser as Modified8_16_1_, content3_.DeletedByUser as DeletedB9_16_1_, content3_.Name as Name16_1_, content3_.PreviewUrl as PreviewUrl16_1_, content3_.Status as Status16_1_, content3_.PublishedByUser as Publish13_16_1_, content3_.PublishedOn as Publish14_16_1_, content3_.OriginalId as OriginalId16_1_, content3_1_.ActivationDate as Activati2_17_1_, content3_1_.ExpirationDate as Expirati3_17_1_, content3_1_.Html as Html17_1_, content3_1_.CustomCss as CustomCss17_1_, content3_1_.UseCustomCss as UseCusto6_17_1_, content3_1_.CustomJs as CustomJs17_1_, content3_1_.UseCustomJs as UseCusto8_17_1_, content3_1_.EditInSourceMode as EditInSo9_17_1_, content3_3_.CategoryId as CategoryId19_1_, content3_4_.Html as Html20_1_, content3_4_.UseHtml as UseHtml20_1_, content3_4_.CustomCss as CustomCss20_1_, content3_4_.UseCustomCss as UseCusto5_20_1_, content3_4_.CustomJs as CustomJs20_1_, content3_4_.UseCustomJs as UseCusto7_20_1_, content3_4_.EditInSourceMode as EditInSo8_20_1_, content3_5_.Url as Url21_1_, case when content3_2_.Id is not null then 2 when content3_4_.Id is not null then 4 when content3_5_.Id is not null then 5 when content3_1_.Id is not null then 1 when content3_3_.Id is not null then 3 when content3_.Id is not null then 0 end as clazz_1_, contentopt4_.Version as Version22_2_, contentopt4_.IsDeleted as IsDeleted22_2_, contentopt4_.CreatedOn as CreatedOn22_2_, contentopt4_.ModifiedOn as ModifiedOn22_2_, contentopt4_.DeletedOn as DeletedOn22_2_, contentopt4_.CreatedByUser as CreatedB7_22_2_, contentopt4_.ModifiedByUser as Modified8_22_2_, contentopt4_.DeletedByUser as DeletedB9_22_2_, contentopt4_.[Key] as column10_22_2_, contentopt4_.Type as Type22_2_, contentopt4_.DefaultValue as Default12_22_2_, contentopt4_.IsDeletable as IsDelet13_22_2_, contentopt4_.ContentId as ContentId22_2_, contentopt4_.CustomOptionId as CustomO15_22_2_, contentopt4_.ContentId as ContentId0__, contentopt4_.Id as Id0__, history5_.Version as Version16_3_, history5_.IsDeleted as IsDeleted16_3_, history5_.CreatedOn as CreatedOn16_3_, history5_.ModifiedOn as ModifiedOn16_3_, history5_.DeletedOn as DeletedOn16_3_, history5_.CreatedByUser as CreatedB7_16_3_, history5_.ModifiedByUser as Modified8_16_3_, history5_.DeletedByUser as DeletedB9_16_3_, history5_.Name as Name16_3_, history5_.PreviewUrl as PreviewUrl16_3_, history5_.Status as Status16_3_, history5_.PublishedByUser as Publish13_16_3_, history5_.PublishedOn as Publish14_16_3_, history5_.OriginalId as OriginalId16_3_, history5_1_.ActivationDate as Activati2_17_3_, history5_1_.ExpirationDate as Expirati3_17_3_, history5_1_.Html as Html17_3_, history5_1_.CustomCss as CustomCss17_3_, history5_1_.UseCustomCss as UseCusto6_17_3_, history5_1_.CustomJs as CustomJs17_3_, history5_1_.UseCustomJs as UseCusto8_17_3_, history5_1_.EditInSourceMode as EditInSo9_17_3_, history5_3_.CategoryId as CategoryId19_3_, history5_4_.Html as Html20_3_, history5_4_.UseHtml as UseHtml20_3_, history5_4_.CustomCss as CustomCss20_3_, history5_4_.UseCustomCss as UseCusto5_20_3_, history5_4_.CustomJs as CustomJs20_3_, history5_4_.UseCustomJs as UseCusto7_20_3_, history5_4_.EditInSourceMode as EditInSo8_20_3_, history5_5_.Url as Url21_3_, case when history5_2_.Id is not null then 2 when history5_4_.Id is not null then 4 when history5_5_.Id is not null then 5 when history5_1_.Id is not null then 1 when history5_3_.Id is not null then 3 when history5_.Id is not null then 0 end as clazz_3_, history5_.OriginalId as OriginalId1__, history5_.Id as Id1__, options6_.Version as Version30_4_, options6_.IsDeleted as IsDeleted30_4_, options6_.CreatedOn as CreatedOn30_4_, options6_.ModifiedOn as ModifiedOn30_4_, options6_.DeletedOn as DeletedOn30_4_, options6_.CreatedByUser as CreatedB7_30_4_, options6_.ModifiedByUser as Modified8_30_4_, options6_.DeletedByUser as DeletedB9_30_4_, options6_.[Key] as column10_30_4_, options6_.Type as Type30_4_, options6_.Value as Value30_4_, options6_.PageContentId as PageCon13_30_4_, options6_.CustomOptionId as CustomO14_30_4_, options6_.PageContentId as PageCon13_2__, options6_.Id as Id2__ from bcms_root.PageContents pageconten0_ inner join bcms_root.Pages page1_ on pageconten0_.PageId=page1_.Id inner join bcms_root.Contents content2_ on pageconten0_.ContentId=content2_.Id left outer join bcms_root.Contents content3_ on pageconten0_.ContentId=content3_.Id left outer join bcms_pages.HtmlContents content3_1_ on content3_.Id=content3_1_.Id left outer join bcms_blog.BlogPostContents content3_2_ on content3_.Id=content3_2_.Id left outer join bcms_root.Widgets content3_3_ on content3_.Id=content3_3_.Id left outer join bcms_pages.HtmlContentWidgets content3_4_ on content3_.Id=content3_4_.Id left outer join bcms_pages.ServerControlWidgets content3_5_ on content3_.Id=content3_5_.Id left outer join bcms_root.ContentOptions contentopt4_ on content3_.Id=contentopt4_.ContentId and (contentopt4_.IsDeleted = 0) left outer join bcms_root.Contents history5_ on content3_.Id=history5_.OriginalId and (history5_.IsDeleted = 0) left outer join bcms_pages.HtmlContents history5_1_ on history5_.Id=history5_1_.Id left outer join bcms_blog.BlogPostContents history5_2_ on history5_.Id=history5_2_.Id left outer join bcms_root.Widgets history5_3_ on history5_.Id=history5_3_.Id left outer join bcms_pages.HtmlContentWidgets history5_4_ on history5_.Id=history5_4_.Id left outer join bcms_pages.ServerControlWidgets history5_5_ on history5_.Id=history5_5_.Id left outer join bcms_root.PageContentOptions options6_ on pageconten0_.Id=options6_.PageContentId and (options6_.IsDeleted = 0) where not (pageconten0_.IsDeleted=1) and page1_.PageUrlHash=? and (content2_.Status=? or content2_.Status=?) and not (pageconten0_.IsDeleted=1) and not (content2_.IsDeleted=1) and not (page1_.IsDeleted=1); ] NHibernate.Exceptions.GenericADOException: Failed to execute multi query[SQL: select page0_.Id as Id31_0_, layout1_.Id as Id24_1_, layoutregi2_.Id as Id26_2_, region3_.Id as Id36_3_, accessrule5_.Id as Id14_4_, page0_.Version as Version31_0_, page0_.IsDeleted as IsDeleted31_0_, page0_.CreatedOn as CreatedOn31_0_, page0_.ModifiedOn as ModifiedOn31_0_, page0_.DeletedOn as DeletedOn31_0_, page0_.CreatedByUser as CreatedB7_31_0_, page0_.ModifiedByUser as Modified8_31_0_, page0_.DeletedByUser as DeletedB9_31_0_, page0_.PageUrl as PageUrl31_0_, page0_.PageUrlHash as PageUrl11_31_0_, page0_.Title as Title31_0_, page0_.Status as Status31_0_, page0_.PublishedOn as Publish14_31_0_, page0_.MetaTitle as MetaTitle31_0_, page0_.MetaKeywords as MetaKey16_31_0_, page0_.MetaDescription as MetaDes17_31_0_, page0_.LayoutId as LayoutId31_0_, page0_1_.Description as Descript2_33_0_, page0_1_.CustomJS as CustomJS33_0_, page0_1_.CustomCss as CustomCss33_0_, page0_1_.UseCanonicalUrl as UseCanon5_33_0_, page0_1_.UseNoFollow as UseNoFol6_33_0_, page0_1_.UseNoIndex as UseNoIndex33_0_, page0_1_.NodeCountInSitemap as NodeCoun8_33_0_, page0_1_.IsArchived as IsArchived33_0_, page0_1_.CategoryId as CategoryId33_0_, page0_1_.ImageId as ImageId33_0_, page0_1_.SecondaryImageId as Seconda12_33_0_, page0_1_.FeaturedImageId as Feature13_33_0_, page0_2_.ActivationDate as Activati2_34_0_, page0_2_.ExpirationDate as Expirati3_34_0_, page0_2_.AuthorId as AuthorId34_0_, case when page0_2_.Id is not null then 2 when page0_1_.Id is not null then 1 when page0_.Id is not null then 0 end as clazz_0_, layout1_.Version as Version24_1_, layout1_.IsDeleted as IsDeleted24_1_, layout1_.CreatedOn as CreatedOn24_1_, layout1_.ModifiedOn as ModifiedOn24_1_, layout1_.DeletedOn as DeletedOn24_1_, layout1_.CreatedByUser as CreatedB7_24_1_, layout1_.ModifiedByUser as Modified8_24_1_, layout1_.DeletedByUser as DeletedB9_24_1_, layout1_.Name as Name24_1_, layout1_.LayoutPath as LayoutPath24_1_, layout1_.PreviewUrl as PreviewUrl24_1_, layout1_.ModuleId as ModuleId24_1_, layoutregi2_.Version as Version26_2_, layoutregi2_.IsDeleted as IsDeleted26_2_, layoutregi2_.CreatedOn as CreatedOn26_2_, layoutregi2_.ModifiedOn as ModifiedOn26_2_, layoutregi2_.DeletedOn as DeletedOn26_2_, layoutregi2_.CreatedByUser as CreatedB7_26_2_, layoutregi2_.ModifiedByUser as Modified8_26_2_, layoutregi2_.DeletedByUser as DeletedB9_26_2_, layoutregi2_.Description as Descrip10_26_2_, layoutregi2_.LayoutId as LayoutId26_2_, layoutregi2_.RegionId as RegionId26_2_, layoutregi2_.LayoutId as LayoutId0__, layoutregi2_.Id as Id0__, region3_.Version as Version36_3_, region3_.IsDeleted as IsDeleted36_3_, region3_.CreatedOn as CreatedOn36_3_, region3_.ModifiedOn as ModifiedOn36_3_, region3_.DeletedOn as DeletedOn36_3_, region3_.CreatedByUser as CreatedB7_36_3_, region3_.ModifiedByUser as Modified8_36_3_, region3_.DeletedByUser as DeletedB9_36_3_, region3_.RegionIdentifier as RegionI10_36_3_, accessrule5_.Version as Version14_4_, accessrule5_.IsDeleted as IsDeleted14_4_, accessrule5_.CreatedOn as CreatedOn14_4_, accessrule5_.ModifiedOn as ModifiedOn14_4_, accessrule5_.DeletedOn as DeletedOn14_4_, accessrule5_.CreatedByUser as CreatedB7_14_4_, accessrule5_.ModifiedByUser as Modified8_14_4_, accessrule5_.DeletedByUser as DeletedB9_14_4_, accessrule5_.[Identity] as column10_14_4_, accessrule5_.AccessLevel as AccessL11_14_4_, accessrule5_.IsForRole as IsForRole14_4_, accessrule4_.PageId as PageId1__, accessrule4_.AccessRuleId as AccessRu2_1__ from bcms_root.Pages page0_ left outer join bcms_pages.Pages page0_1_ on page0_.Id=page0_1_.Id left outer join bcms_blog.BlogPosts page0_2_ on page0_.Id=page0_2_.Id left outer join bcms_root.Layouts layout1_ on page0_.LayoutId=layout1_.Id left outer join bcms_root.LayoutRegions layoutregi2_ on layout1_.Id=layoutregi2_.LayoutId and (layoutregi2_.IsDeleted = 0) left outer join bcms_root.Regions region3_ on layoutregi2_.RegionId=region3_.Id left outer join bcms_root.PageAccessRules accessrule4_ on page0_.Id=accessrule4_.PageId left outer join bcms_root.AccessRules accessrule5_ on accessrule4_.AccessRuleId=accessrule5_.Id where not (page0_.IsDeleted=1) and not (page0_.IsDeleted=1) and page0_.PageUrlHash=?; select pageconten0_.Id as Id29_0_, content3_.Id as Id16_1_, contentopt4_.Id as Id22_2_, history5_.Id as Id16_3_, options6_.Id as Id30_4_, pageconten0_.Version as Version29_0_, pageconten0_.IsDeleted as IsDeleted29_0_, pageconten0_.CreatedOn as CreatedOn29_0_, pageconten0_.ModifiedOn as ModifiedOn29_0_, pageconten0_.DeletedOn as DeletedOn29_0_, pageconten0_.CreatedByUser as CreatedB7_29_0_, pageconten0_.ModifiedByUser as Modified8_29_0_, pageconten0_.DeletedByUser as DeletedB9_29_0_, pageconten0_.[Order] as column10_29_0_, pageconten0_.RegionId as RegionId29_0_, pageconten0_.ContentId as ContentId29_0_, pageconten0_.PageId as PageId29_0_, content3_.Version as Version16_1_, content3_.IsDeleted as IsDeleted16_1_, content3_.CreatedOn as CreatedOn16_1_, content3_.ModifiedOn as ModifiedOn16_1_, content3_.DeletedOn as DeletedOn16_1_, content3_.CreatedByUser as CreatedB7_16_1_, content3_.ModifiedByUser as Modified8_16_1_, content3_.DeletedByUser as DeletedB9_16_1_, content3_.Name as Name16_1_, content3_.PreviewUrl as PreviewUrl16_1_, content3_.Status as Status16_1_, content3_.PublishedByUser as Publish13_16_1_, content3_.PublishedOn as Publish14_16_1_, content3_.OriginalId as OriginalId16_1_, content3_1_.ActivationDate as Activati2_17_1_, content3_1_.ExpirationDate as Expirati3_17_1_, content3_1_.Html as Html17_1_, content3_1_.CustomCss as CustomCss17_1_, content3_1_.UseCustomCss as UseCusto6_17_1_, content3_1_.CustomJs as CustomJs17_1_, content3_1_.UseCustomJs as UseCusto8_17_1_, content3_1_.EditInSourceMode as EditInSo9_17_1_, content3_3_.CategoryId as CategoryId19_1_, content3_4_.Html as Html20_1_, content3_4_.UseHtml as UseHtml20_1_, content3_4_.CustomCss as CustomCss20_1_, content3_4_.UseCustomCss as UseCusto5_20_1_, content3_4_.CustomJs as CustomJs20_1_, content3_4_.UseCustomJs as UseCusto7_20_1_, content3_4_.EditInSourceMode as EditInSo8_20_1_, content3_5_.Url as Url21_1_, case when content3_2_.Id is not null then 2 when content3_4_.Id is not null then 4 when content3_5_.Id is not null then 5 when content3_1_.Id is not null then 1 when content3_3_.Id is not null then 3 when content3_.Id is not null then 0 end as clazz_1_, contentopt4_.Version as Version22_2_, contentopt4_.IsDeleted as IsDeleted22_2_, contentopt4_.CreatedOn as CreatedOn22_2_, contentopt4_.ModifiedOn as ModifiedOn22_2_, contentopt4_.DeletedOn as DeletedOn22_2_, contentopt4_.CreatedByUser as CreatedB7_22_2_, contentopt4_.ModifiedByUser as Modified8_22_2_, contentopt4_.DeletedByUser as DeletedB9_22_2_, contentopt4_.[Key] as column10_22_2_, contentopt4_.Type as Type22_2_, contentopt4_.DefaultValue as Default12_22_2_, contentopt4_.IsDeletable as IsDelet13_22_2_, contentopt4_.ContentId as ContentId22_2_, contentopt4_.CustomOptionId as CustomO15_22_2_, contentopt4_.ContentId as ContentId0__, contentopt4_.Id as Id0__, history5_.Version as Version16_3_, history5_.IsDeleted as IsDeleted16_3_, history5_.CreatedOn as CreatedOn16_3_, history5_.ModifiedOn as ModifiedOn16_3_, history5_.DeletedOn as DeletedOn16_3_, history5_.CreatedByUser as CreatedB7_16_3_, history5_.ModifiedByUser as Modified8_16_3_, history5_.DeletedByUser as DeletedB9_16_3_, history5_.Name as Name16_3_, history5_.PreviewUrl as PreviewUrl16_3_, history5_.Status as Status16_3_, history5_.PublishedByUser as Publish13_16_3_, history5_.PublishedOn as Publish14_16_3_, history5_.OriginalId as OriginalId16_3_, history5_1_.ActivationDate as Activati2_17_3_, history5_1_.ExpirationDate as Expirati3_17_3_, history5_1_.Html as Html17_3_, history5_1_.CustomCss as CustomCss17_3_, history5_1_.UseCustomCss as UseCusto6_17_3_, history5_1_.CustomJs as CustomJs17_3_, history5_1_.UseCustomJs as UseCusto8_17_3_, history5_1_.EditInSourceMode as EditInSo9_17_3_, history5_3_.CategoryId as CategoryId19_3_, history5_4_.Html as Html20_3_, history5_4_.UseHtml as UseHtml20_3_, history5_4_.CustomCss as CustomCss20_3_, history5_4_.UseCustomCss as UseCusto5_20_3_, history5_4_.CustomJs as CustomJs20_3_, history5_4_.UseCustomJs as UseCusto7_20_3_, history5_4_.EditInSourceMode as EditInSo8_20_3_, history5_5_.Url as Url21_3_, case when history5_2_.Id is not null then 2 when history5_4_.Id is not null then 4 when history5_5_.Id is not null then 5 when history5_1_.Id is not null then 1 when history5_3_.Id is not null then 3 when history5_.Id is not null then 0 end as clazz_3_, history5_.OriginalId as OriginalId1__, history5_.Id as Id1__, options6_.Version as Version30_4_, options6_.IsDeleted as IsDeleted30_4_, options6_.CreatedOn as CreatedOn30_4_, options6_.ModifiedOn as ModifiedOn30_4_, options6_.DeletedOn as DeletedOn30_4_, options6_.CreatedByUser as CreatedB7_30_4_, options6_.ModifiedByUser as Modified8_30_4_, options6_.DeletedByUser as DeletedB9_30_4_, options6_.[Key] as column10_30_4_, options6_.Type as Type30_4_, options6_.Value as Value30_4_, options6_.PageContentId as PageCon13_30_4_, options6_.CustomOptionId as CustomO14_30_4_, options6_.PageContentId as PageCon13_2__, options6_.Id as Id2__ from bcms_root.PageContents pageconten0_ inner join bcms_root.Pages page1_ on pageconten0_.PageId=page1_.Id inner join bcms_root.Contents content2_ on pageconten0_.ContentId=content2_.Id left outer join bcms_root.Contents content3_ on pageconten0_.ContentId=content3_.Id left outer join bcms_pages.HtmlContents content3_1_ on content3_.Id=content3_1_.Id left outer join bcms_blog.BlogPostContents content3_2_ on content3_.Id=content3_2_.Id left outer join bcms_root.Widgets content3_3_ on content3_.Id=content3_3_.Id left outer join bcms_pages.HtmlContentWidgets content3_4_ on content3_.Id=content3_4_.Id left outer join bcms_pages.ServerControlWidgets content3_5_ on content3_.Id=content3_5_.Id left outer join bcms_root.ContentOptions contentopt4_ on content3_.Id=contentopt4_.ContentId and (contentopt4_.IsDeleted = 0) left outer join bcms_root.Contents history5_ on content3_.Id=history5_.OriginalId and (history5_.IsDeleted = 0) left outer join bcms_pages.HtmlContents history5_1_ on history5_.Id=history5_1_.Id left outer join bcms_blog.BlogPostContents history5_2_ on history5_.Id=history5_2_.Id left outer join bcms_root.Widgets history5_3_ on history5_.Id=history5_3_.Id left outer join bcms_pages.HtmlContentWidgets history5_4_ on history5_.Id=history5_4_.Id left outer join bcms_pages.ServerControlWidgets history5_5_ on history5_.Id=history5_5_.Id left outer join bcms_root.PageContentOptions options6_ on pageconten0_.Id=options6_.PageContentId and (options6_.IsDeleted = 0) where not (pageconten0_.IsDeleted=1) and page1_.PageUrlHash=? and (content2_.Status=? or content2_.Status=?) and not (pageconten0_.IsDeleted=1) and not (content2_.IsDeleted=1) and not (page1_.IsDeleted=1); ] ---> System.Data.SqlClient.SqlException: Transaction (Process ID 752) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at NHibernate.Driver.NHybridDataReader.NextResult() at NHibernate.Driver.BatcherDataReaderWrapper.NextResult() at NHibernate.Impl.MultiQueryImpl.DoList() --- End of inner exception stack trace --- at NHibernate.Impl.MultiQueryImpl.DoList() at NHibernate.Impl.MultiQueryImpl.ListIgnoreQueryCache() at NHibernate.Impl.MultiQueryImpl.List() at NHibernate.Impl.FutureQueryBatch.GetResultsFrom(IMultiQuery multiApproach) at NHibernate.Impl.FutureBatch2.GetResults()
at NHibernate.Impl.FutureBatch2.get_Results() at NHibernate.Impl.FutureBatch2.GetCurrentResult[TResult](Int32 currentIndex)
at NHibernate.Impl.FutureBatch2.<>c__DisplayClass41.b__3()
at NHibernate.Impl.DelayedEnumerator1.<get_Enumerable>d__0.MoveNext() at System.Collections.Generic.List1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source)
at BetterCms.Module.Root.Commands.GetPageToRender.GetPageToRenderCommand.Execute(GetPageToRenderRequest request)
at BetterCms.Module.Root.Controllers.CmsController.GetRequestModel(String virtualPath)
at BetterCms.Module.Root.Controllers.CmsController.Index()
Transaction (Process ID 752) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. System.Data.SqlClient.SqlException (0x80131904): Transaction (Process ID 752) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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.TryHasMoreRows(Boolean& moreRows)
at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
at System.Data.SqlClient.SqlDataReader.TryNextResult(Boolean& more)
at System.Data.SqlClient.SqlDataReader.NextResult()
at NHibernate.Driver.NHybridDataReader.NextResult()
at NHibernate.Driver.BatcherDataReaderWrapper.NextResult()
at NHibernate.Impl.MultiQueryImpl.DoList()
ClientConnectionId:d450e8ec-8409-494b-a9bc-c38621550bfc
ghost
commented
10 years ago
2013-11-05 07:44:17.1856 Unhandled exception occurred in Better CMS host application. Failed to load a CMS page. System.Web.HttpException (0x80004005): Failed to load a CMS page. ---> NHibernate.Exceptions.GenericADOException: Failed to execute multi query[SQL: select page0_.Id as Id310, layout1_.Id as Id241, layoutregi2_.Id as Id262, region3_.Id as Id363, accessrule5_.Id as Id144, page0_.Version as Version310, page0_.IsDeleted as IsDeleted310, page0_.CreatedOn as CreatedOn310, page0_.ModifiedOn as ModifiedOn310, page0_.DeletedOn as DeletedOn310, page0_.CreatedByUser as CreatedB7_310, page0_.ModifiedByUser as Modified8_310, page0_.DeletedByUser as DeletedB9_310, page0_.PageUrl as PageUrl310, page0_.PageUrlHash as PageUrl11_310, page0_.Title as Title310, page0_.Status as Status310, page0_.PublishedOn as Publish14_310, page0_.MetaTitle as MetaTitle310, page0_.MetaKeywords as MetaKey16_310, page0_.MetaDescription as MetaDes17_310, page0_.LayoutId as LayoutId310, page01.Description as Descript2_330, page01.CustomJS as CustomJS330, page01.CustomCss as CustomCss330, page01.UseCanonicalUrl as UseCanon5_330, page01.UseNoFollow as UseNoFol6_330, page01.UseNoIndex as UseNoIndex330, page01.NodeCountInSitemap as NodeCoun8_330, page01.IsArchived as IsArchived330, page01.CategoryId as CategoryId330, page01.ImageId as ImageId330, page01.SecondaryImageId as Seconda12_330, page01.FeaturedImageId as Feature13_330, page02.ActivationDate as Activati2_340, page02.ExpirationDate as Expirati3_340, page02.AuthorId as AuthorId340, case when page02.Id is not null then 2 when page01.Id is not null then 1 when page0_.Id is not null then 0 end as clazz0, layout1_.Version as Version241, layout1_.IsDeleted as IsDeleted241, layout1_.CreatedOn as CreatedOn241, layout1_.ModifiedOn as ModifiedOn241, layout1_.DeletedOn as DeletedOn241, layout1_.CreatedByUser as CreatedB7_241, layout1_.ModifiedByUser as Modified8_241, layout1_.DeletedByUser as DeletedB9_241, layout1_.Name as Name241, layout1_.LayoutPath as LayoutPath241, layout1_.PreviewUrl as PreviewUrl241, layout1_.ModuleId as ModuleId241, layoutregi2_.Version as Version262, layoutregi2_.IsDeleted as IsDeleted262, layoutregi2_.CreatedOn as CreatedOn262, layoutregi2_.ModifiedOn as ModifiedOn262, layoutregi2_.DeletedOn as DeletedOn262, layoutregi2_.CreatedByUser as CreatedB7_262, layoutregi2_.ModifiedByUser as Modified8_262, layoutregi2_.DeletedByUser as DeletedB9_262, layoutregi2_.Description as Descrip10_262, layoutregi2_.LayoutId as LayoutId262, layoutregi2_.RegionId as RegionId262, layoutregi2_.LayoutId as LayoutId0, layoutregi2_.Id as Id0, region3_.Version as Version363, region3_.IsDeleted as IsDeleted363, region3_.CreatedOn as CreatedOn363, region3_.ModifiedOn as ModifiedOn363, region3_.DeletedOn as DeletedOn363, region3_.CreatedByUser as CreatedB7_363, region3_.ModifiedByUser as Modified8_363, region3_.DeletedByUser as DeletedB9_363, region3_.RegionIdentifier as RegionI10_363, accessrule5_.Version as Version144, accessrule5_.IsDeleted as IsDeleted144, accessrule5_.CreatedOn as CreatedOn144, accessrule5_.ModifiedOn as ModifiedOn144, accessrule5_.DeletedOn as DeletedOn144, accessrule5_.CreatedByUser as CreatedB7_144, accessrule5_.ModifiedByUser as Modified8_144, accessrule5_.DeletedByUser as DeletedB9_144, accessrule5_.[Identity] as column10_144, accessrule5_.AccessLevel as AccessL11_144, accessrule5_.IsForRole as IsForRole144, accessrule4_.PageId as PageId1, accessrule4_.AccessRuleId as AccessRu2_1__ from bcmsroot.Pages page0 left outer join bcms_pages.Pages page01 on page0_.Id=page01.Id left outer join bcms_blog.BlogPosts page02 on page0_.Id=page02.Id left outer join bcmsroot.Layouts layout1 on page0.LayoutId=layout1.Id left outer join bcmsroot.LayoutRegions layoutregi2 on layout1.Id=layoutregi2.LayoutId and (layoutregi2_.IsDeleted = 0) left outer join bcmsroot.Regions region3 on layoutregi2.RegionId=region3.Id left outer join bcmsroot.PageAccessRules accessrule4 on page0.Id=accessrule4.PageId left outer join bcmsroot.AccessRules accessrule5 on accessrule4.AccessRuleId=accessrule5.Id where not (page0.IsDeleted=1) and not (page0.IsDeleted=1) and page0.PageUrlHash=?; select pageconten0.Id as Id290, content3_.Id as Id161, contentopt4_.Id as Id222, history5_.Id as Id163, options6_.Id as Id304, pageconten0_.Version as Version290, pageconten0_.IsDeleted as IsDeleted290, pageconten0_.CreatedOn as CreatedOn290, pageconten0_.ModifiedOn as ModifiedOn290, pageconten0_.DeletedOn as DeletedOn290, pageconten0_.CreatedByUser as CreatedB7_290, pageconten0_.ModifiedByUser as Modified8_290, pageconten0_.DeletedByUser as DeletedB9_290, pageconten0_.[Order] as column10_290, pageconten0_.RegionId as RegionId290, pageconten0_.ContentId as ContentId290, pageconten0_.PageId as PageId290, content3_.Version as Version161, content3_.IsDeleted as IsDeleted161, content3_.CreatedOn as CreatedOn161, content3_.ModifiedOn as ModifiedOn161, content3_.DeletedOn as DeletedOn161, content3_.CreatedByUser as CreatedB7_161, content3_.ModifiedByUser as Modified8_161, content3_.DeletedByUser as DeletedB9_161, content3_.Name as Name161, content3_.PreviewUrl as PreviewUrl161, content3_.Status as Status161, content3_.PublishedByUser as Publish13_161, content3_.PublishedOn as Publish14_161, content3_.OriginalId as OriginalId161, content31.ActivationDate as Activati2_171, content31.ExpirationDate as Expirati3_171, content31.Html as Html171, content31.CustomCss as CustomCss171, content31.UseCustomCss as UseCusto6_171, content31.CustomJs as CustomJs171, content31.UseCustomJs as UseCusto8_171, content31.EditInSourceMode as EditInSo9_171, content33.CategoryId as CategoryId191, content34.Html as Html201, content34.UseHtml as UseHtml201, content34.CustomCss as CustomCss201, content34.UseCustomCss as UseCusto5_201, content34.CustomJs as CustomJs201, content34.UseCustomJs as UseCusto7_201, content34.EditInSourceMode as EditInSo8_201, content35.Url as Url211, case when content32.Id is not null then 2 when content34.Id is not null then 4 when content35.Id is not null then 5 when content31.Id is not null then 1 when content33.Id is not null then 3 when content3_.Id is not null then 0 end as clazz1, contentopt4_.Version as Version222, contentopt4_.IsDeleted as IsDeleted222, contentopt4_.CreatedOn as CreatedOn222, contentopt4_.ModifiedOn as ModifiedOn222, contentopt4_.DeletedOn as DeletedOn222, contentopt4_.CreatedByUser as CreatedB7_222, contentopt4_.ModifiedByUser as Modified8_222, contentopt4_.DeletedByUser as DeletedB9_222, contentopt4_.[Key] as column10_222, contentopt4_.Type as Type222, contentopt4_.DefaultValue as Default12_222, contentopt4_.IsDeletable as IsDelet13_222, contentopt4_.ContentId as ContentId222, contentopt4_.CustomOptionId as CustomO15_222, contentopt4_.ContentId as ContentId0, contentopt4_.Id as Id0, history5_.Version as Version163, history5_.IsDeleted as IsDeleted163, history5_.CreatedOn as CreatedOn163, history5_.ModifiedOn as ModifiedOn163, history5_.DeletedOn as DeletedOn163, history5_.CreatedByUser as CreatedB7_163, history5_.ModifiedByUser as Modified8_163, history5_.DeletedByUser as DeletedB9_163, history5_.Name as Name163, history5_.PreviewUrl as PreviewUrl163, history5_.Status as Status163, history5_.PublishedByUser as Publish13_163, history5_.PublishedOn as Publish14_163, history5_.OriginalId as OriginalId163, history51.ActivationDate as Activati2_173, history51.ExpirationDate as Expirati3_173, history51.Html as Html173, history51.CustomCss as CustomCss173, history51.UseCustomCss as UseCusto6_173, history51.CustomJs as CustomJs173, history51.UseCustomJs as UseCusto8_173, history51.EditInSourceMode as EditInSo9_173, history53.CategoryId as CategoryId193, history54.Html as Html203, history54.UseHtml as UseHtml203, history54.CustomCss as CustomCss203, history54.UseCustomCss as UseCusto5_203, history54.CustomJs as CustomJs203, history54.UseCustomJs as UseCusto7_203, history54.EditInSourceMode as EditInSo8_203, history55.Url as Url213, case when history52.Id is not null then 2 when history54.Id is not null then 4 when history55.Id is not null then 5 when history51.Id is not null then 1 when history53.Id is not null then 3 when history5_.Id is not null then 0 end as clazz3, history5_.OriginalId as OriginalId1_, history5.Id as Id1, options6_.Version as Version304, options6_.IsDeleted as IsDeleted304, options6_.CreatedOn as CreatedOn304, options6_.ModifiedOn as ModifiedOn304, options6_.DeletedOn as DeletedOn304, options6_.CreatedByUser as CreatedB7_304, options6_.ModifiedByUser as Modified8_304, options6_.DeletedByUser as DeletedB9_304, options6_.[Key] as column10_304, options6_.Type as Type304, options6_.Value as Value304, options6_.PageContentId as PageCon13_304, options6_.CustomOptionId as CustomO14_304, options6_.PageContentId as PageCon13_2, options6_.Id as Id2__ from bcmsroot.PageContents pageconten0 inner join bcmsroot.Pages page1 on pageconten0.PageId=page1.Id inner join bcmsroot.Contents content2 on pageconten0.ContentId=content2.Id left outer join bcmsroot.Contents content3 on pageconten0.ContentId=content3.Id left outer join bcms_pages.HtmlContents content31 on content3_.Id=content31.Id left outer join bcms_blog.BlogPostContents content32 on content3_.Id=content32.Id left outer join bcms_root.Widgets content33 on content3_.Id=content33.Id left outer join bcms_pages.HtmlContentWidgets content34 on content3_.Id=content34.Id left outer join bcms_pages.ServerControlWidgets content35 on content3_.Id=content35.Id left outer join bcmsroot.ContentOptions contentopt4 on content3.Id=contentopt4.ContentId and (contentopt4_.IsDeleted = 0) left outer join bcmsroot.Contents history5 on content3.Id=history5.OriginalId and (history5_.IsDeleted = 0) left outer join bcms_pages.HtmlContents history51 on history5_.Id=history51.Id left outer join bcms_blog.BlogPostContents history52 on history5_.Id=history52.Id left outer join bcms_root.Widgets history53 on history5_.Id=history53.Id left outer join bcms_pages.HtmlContentWidgets history54 on history5_.Id=history54.Id left outer join bcms_pages.ServerControlWidgets history55 on history5_.Id=history55.Id left outer join bcmsroot.PageContentOptions options6 on pageconten0.Id=options6.PageContentId and (options6.IsDeleted = 0) where not (pageconten0.IsDeleted=1) and page1.PageUrlHash=? and (content2.Status=? or content2.Status=?) and not (pageconten0.IsDeleted=1) and not (content2.IsDeleted=1) and not (page1.IsDeleted=1); ] ---> System.Data.SqlClient.SqlException: Transaction (Process ID 752) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Actiond0.MoveNext()
at System.Collections.Generic.Listb_7(IAsyncResult )
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c DisplayClass37.<>cDisplayClass39.b 33()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass4f.b 49()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass37.b 36(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultb 18(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.<>cDisplayClass4.b 3(IAsyncResult ar)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultb 3(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.<>cDisplayClass4.b 3(IAsyncResult ar)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultb__3()
at NHibernate.Impl.DelayedEnumerator
1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at NHibernate.Driver.NHybridDataReader.NextResult() at NHibernate.Driver.BatcherDataReaderWrapper.NextResult() at NHibernate.Impl.MultiQueryImpl.DoList() --- End of inner exception stack trace --- at NHibernate.Impl.MultiQueryImpl.DoList() at NHibernate.Impl.MultiQueryImpl.ListIgnoreQueryCache() at NHibernate.Impl.MultiQueryImpl.List() at NHibernate.Impl.FutureQueryBatch.GetResultsFrom(IMultiQuery multiApproach) at NHibernate.Impl.FutureBatch2.GetResults() at NHibernate.Impl.FutureBatch2.get_Results() at NHibernate.Impl.FutureBatch2.GetCurrentResult[TResult](Int32 currentIndex) at NHibernate.Impl.FutureBatch2.<>cDisplayClass41.<GetEnumerator>b__3() at NHibernate.Impl.DelayedEnumerator1.1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) at BetterCms.Module.Root.Commands.GetPageToRender.GetPageToRenderCommand.Execute(GetPageToRenderRequest request) at BetterCms.Module.Root.Controllers.CmsController.GetRequestModel(String virtualPath) at BetterCms.Module.Root.Controllers.CmsController.Index() at BetterCms.Module.Root.Controllers.CmsController.Index() at lambda_method(Closure , ControllerBase , Object[] ) at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary2 parameters) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary2 parameters) at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass42.<BeginInvokeSynchronousActionMethod>b__41() at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass81.1.End() at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass25.<>c__DisplayClass2a.<BeginInvokeAction>b__20() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass25.<BeginInvokeAction>b__22(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult1.End() at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) at System.Web.Mvc.Controller.<>cDisplayClass1d.1.End() at System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult1.End() at System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) at System.Web.Mvc.Controller.System.Web.Mvc.Async.IAsyncController.EndExecute(IAsyncResult asyncResult) at System.Web.Mvc.MvcHandler.<>cDisplayClass8.1.End() at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) at System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) Failed to execute multi query[SQL: select page0_.Id as Id31_0_, layout1_.Id as Id24_1_, layoutregi2_.Id as Id26_2_, region3_.Id as Id36_3_, accessrule5_.Id as Id14_4_, page0_.Version as Version31_0_, page0_.IsDeleted as IsDeleted31_0_, page0_.CreatedOn as CreatedOn31_0_, page0_.ModifiedOn as ModifiedOn31_0_, page0_.DeletedOn as DeletedOn31_0_, page0_.CreatedByUser as CreatedB7_31_0_, page0_.ModifiedByUser as Modified8_31_0_, page0_.DeletedByUser as DeletedB9_31_0_, page0_.PageUrl as PageUrl31_0_, page0_.PageUrlHash as PageUrl11_31_0_, page0_.Title as Title31_0_, page0_.Status as Status31_0_, page0_.PublishedOn as Publish14_31_0_, page0_.MetaTitle as MetaTitle31_0_, page0_.MetaKeywords as MetaKey16_31_0_, page0_.MetaDescription as MetaDes17_31_0_, page0_.LayoutId as LayoutId31_0_, page0_1_.Description as Descript2_33_0_, page0_1_.CustomJS as CustomJS33_0_, page0_1_.CustomCss as CustomCss33_0_, page0_1_.UseCanonicalUrl as UseCanon5_33_0_, page0_1_.UseNoFollow as UseNoFol6_33_0_, page0_1_.UseNoIndex as UseNoIndex33_0_, page0_1_.NodeCountInSitemap as NodeCoun8_33_0_, page0_1_.IsArchived as IsArchived33_0_, page0_1_.CategoryId as CategoryId33_0_, page0_1_.ImageId as ImageId33_0_, page0_1_.SecondaryImageId as Seconda12_33_0_, page0_1_.FeaturedImageId as Feature13_33_0_, page0_2_.ActivationDate as Activati2_34_0_, page0_2_.ExpirationDate as Expirati3_34_0_, page0_2_.AuthorId as AuthorId34_0_, case when page0_2_.Id is not null then 2 when page0_1_.Id is not null then 1 when page0_.Id is not null then 0 end as clazz_0_, layout1_.Version as Version24_1_, layout1_.IsDeleted as IsDeleted24_1_, layout1_.CreatedOn as CreatedOn24_1_, layout1_.ModifiedOn as ModifiedOn24_1_, layout1_.DeletedOn as DeletedOn24_1_, layout1_.CreatedByUser as CreatedB7_24_1_, layout1_.ModifiedByUser as Modified8_24_1_, layout1_.DeletedByUser as DeletedB9_24_1_, layout1_.Name as Name24_1_, layout1_.LayoutPath as LayoutPath24_1_, layout1_.PreviewUrl as PreviewUrl24_1_, layout1_.ModuleId as ModuleId24_1_, layoutregi2_.Version as Version26_2_, layoutregi2_.IsDeleted as IsDeleted26_2_, layoutregi2_.CreatedOn as CreatedOn26_2_, layoutregi2_.ModifiedOn as ModifiedOn26_2_, layoutregi2_.DeletedOn as DeletedOn26_2_, layoutregi2_.CreatedByUser as CreatedB7_26_2_, layoutregi2_.ModifiedByUser as Modified8_26_2_, layoutregi2_.DeletedByUser as DeletedB9_26_2_, layoutregi2_.Description as Descrip10_26_2_, layoutregi2_.LayoutId as LayoutId26_2_, layoutregi2_.RegionId as RegionId26_2_, layoutregi2_.LayoutId as LayoutId0__, layoutregi2_.Id as Id0__, region3_.Version as Version36_3_, region3_.IsDeleted as IsDeleted36_3_, region3_.CreatedOn as CreatedOn36_3_, region3_.ModifiedOn as ModifiedOn36_3_, region3_.DeletedOn as DeletedOn36_3_, region3_.CreatedByUser as CreatedB7_36_3_, region3_.ModifiedByUser as Modified8_36_3_, region3_.DeletedByUser as DeletedB9_36_3_, region3_.RegionIdentifier as RegionI10_36_3_, accessrule5_.Version as Version14_4_, accessrule5_.IsDeleted as IsDeleted14_4_, accessrule5_.CreatedOn as CreatedOn14_4_, accessrule5_.ModifiedOn as ModifiedOn14_4_, accessrule5_.DeletedOn as DeletedOn14_4_, accessrule5_.CreatedByUser as CreatedB7_14_4_, accessrule5_.ModifiedByUser as Modified8_14_4_, accessrule5_.DeletedByUser as DeletedB9_14_4_, accessrule5_.[Identity] as column10_14_4_, accessrule5_.AccessLevel as AccessL11_14_4_, accessrule5_.IsForRole as IsForRole14_4_, accessrule4_.PageId as PageId1__, accessrule4_.AccessRuleId as AccessRu2_1__ from bcms_root.Pages page0_ left outer join bcms_pages.Pages page0_1_ on page0_.Id=page0_1_.Id left outer join bcms_blog.BlogPosts page0_2_ on page0_.Id=page0_2_.Id left outer join bcms_root.Layouts layout1_ on page0_.LayoutId=layout1_.Id left outer join bcms_root.LayoutRegions layoutregi2_ on layout1_.Id=layoutregi2_.LayoutId and (layoutregi2_.IsDeleted = 0) left outer join bcms_root.Regions region3_ on layoutregi2_.RegionId=region3_.Id left outer join bcms_root.PageAccessRules accessrule4_ on page0_.Id=accessrule4_.PageId left outer join bcms_root.AccessRules accessrule5_ on accessrule4_.AccessRuleId=accessrule5_.Id where not (page0_.IsDeleted=1) and not (page0_.IsDeleted=1) and page0_.PageUrlHash=?; select pageconten0_.Id as Id29_0_, content3_.Id as Id16_1_, contentopt4_.Id as Id22_2_, history5_.Id as Id16_3_, options6_.Id as Id30_4_, pageconten0_.Version as Version29_0_, pageconten0_.IsDeleted as IsDeleted29_0_, pageconten0_.CreatedOn as CreatedOn29_0_, pageconten0_.ModifiedOn as ModifiedOn29_0_, pageconten0_.DeletedOn as DeletedOn29_0_, pageconten0_.CreatedByUser as CreatedB7_29_0_, pageconten0_.ModifiedByUser as Modified8_29_0_, pageconten0_.DeletedByUser as DeletedB9_29_0_, pageconten0_.[Order] as column10_29_0_, pageconten0_.RegionId as RegionId29_0_, pageconten0_.ContentId as ContentId29_0_, pageconten0_.PageId as PageId29_0_, content3_.Version as Version16_1_, content3_.IsDeleted as IsDeleted16_1_, content3_.CreatedOn as CreatedOn16_1_, content3_.ModifiedOn as ModifiedOn16_1_, content3_.DeletedOn as DeletedOn16_1_, content3_.CreatedByUser as CreatedB7_16_1_, content3_.ModifiedByUser as Modified8_16_1_, content3_.DeletedByUser as DeletedB9_16_1_, content3_.Name as Name16_1_, content3_.PreviewUrl as PreviewUrl16_1_, content3_.Status as Status16_1_, content3_.PublishedByUser as Publish13_16_1_, content3_.PublishedOn as Publish14_16_1_, content3_.OriginalId as OriginalId16_1_, content3_1_.ActivationDate as Activati2_17_1_, content3_1_.ExpirationDate as Expirati3_17_1_, content3_1_.Html as Html17_1_, content3_1_.CustomCss as CustomCss17_1_, content3_1_.UseCustomCss as UseCusto6_17_1_, content3_1_.CustomJs as CustomJs17_1_, content3_1_.UseCustomJs as UseCusto8_17_1_, content3_1_.EditInSourceMode as EditInSo9_17_1_, content3_3_.CategoryId as CategoryId19_1_, content3_4_.Html as Html20_1_, content3_4_.UseHtml as UseHtml20_1_, content3_4_.CustomCss as CustomCss20_1_, content3_4_.UseCustomCss as UseCusto5_20_1_, content3_4_.CustomJs as CustomJs20_1_, content3_4_.UseCustomJs as UseCusto7_20_1_, content3_4_.EditInSourceMode as EditInSo8_20_1_, content3_5_.Url as Url21_1_, case when content3_2_.Id is not null then 2 when content3_4_.Id is not null then 4 when content3_5_.Id is not null then 5 when content3_1_.Id is not null then 1 when content3_3_.Id is not null then 3 when content3_.Id is not null then 0 end as clazz_1_, contentopt4_.Version as Version22_2_, contentopt4_.IsDeleted as IsDeleted22_2_, contentopt4_.CreatedOn as CreatedOn22_2_, contentopt4_.ModifiedOn as ModifiedOn22_2_, contentopt4_.DeletedOn as DeletedOn22_2_, contentopt4_.CreatedByUser as CreatedB7_22_2_, contentopt4_.ModifiedByUser as Modified8_22_2_, contentopt4_.DeletedByUser as DeletedB9_22_2_, contentopt4_.[Key] as column10_22_2_, contentopt4_.Type as Type22_2_, contentopt4_.DefaultValue as Default12_22_2_, contentopt4_.IsDeletable as IsDelet13_22_2_, contentopt4_.ContentId as ContentId22_2_, contentopt4_.CustomOptionId as CustomO15_22_2_, contentopt4_.ContentId as ContentId0__, contentopt4_.Id as Id0__, history5_.Version as Version16_3_, history5_.IsDeleted as IsDeleted16_3_, history5_.CreatedOn as CreatedOn16_3_, history5_.ModifiedOn as ModifiedOn16_3_, history5_.DeletedOn as DeletedOn16_3_, history5_.CreatedByUser as CreatedB7_16_3_, history5_.ModifiedByUser as Modified8_16_3_, history5_.DeletedByUser as DeletedB9_16_3_, history5_.Name as Name16_3_, history5_.PreviewUrl as PreviewUrl16_3_, history5_.Status as Status16_3_, history5_.PublishedByUser as Publish13_16_3_, history5_.PublishedOn as Publish14_16_3_, history5_.OriginalId as OriginalId16_3_, history5_1_.ActivationDate as Activati2_17_3_, history5_1_.ExpirationDate as Expirati3_17_3_, history5_1_.Html as Html17_3_, history5_1_.CustomCss as CustomCss17_3_, history5_1_.UseCustomCss as UseCusto6_17_3_, history5_1_.CustomJs as CustomJs17_3_, history5_1_.UseCustomJs as UseCusto8_17_3_, history5_1_.EditInSourceMode as EditInSo9_17_3_, history5_3_.CategoryId as CategoryId19_3_, history5_4_.Html as Html20_3_, history5_4_.UseHtml as UseHtml20_3_, history5_4_.CustomCss as CustomCss20_3_, history5_4_.UseCustomCss as UseCusto5_20_3_, history5_4_.CustomJs as CustomJs20_3_, history5_4_.UseCustomJs as UseCusto7_20_3_, history5_4_.EditInSourceMode as EditInSo8_20_3_, history5_5_.Url as Url21_3_, case when history5_2_.Id is not null then 2 when history5_4_.Id is not null then 4 when history5_5_.Id is not null then 5 when history5_1_.Id is not null then 1 when history5_3_.Id is not null then 3 when history5_.Id is not null then 0 end as clazz_3_, history5_.OriginalId as OriginalId1__, history5_.Id as Id1__, options6_.Version as Version30_4_, options6_.IsDeleted as IsDeleted30_4_, options6_.CreatedOn as CreatedOn30_4_, options6_.ModifiedOn as ModifiedOn30_4_, options6_.DeletedOn as DeletedOn30_4_, options6_.CreatedByUser as CreatedB7_30_4_, options6_.ModifiedByUser as Modified8_30_4_, options6_.DeletedByUser as DeletedB9_30_4_, options6_.[Key] as column10_30_4_, options6_.Type as Type30_4_, options6_.Value as Value30_4_, options6_.PageContentId as PageCon13_30_4_, options6_.CustomOptionId as CustomO14_30_4_, options6_.PageContentId as PageCon13_2__, options6_.Id as Id2__ from bcms_root.PageContents pageconten0_ inner join bcms_root.Pages page1_ on pageconten0_.PageId=page1_.Id inner join bcms_root.Contents content2_ on pageconten0_.ContentId=content2_.Id left outer join bcms_root.Contents content3_ on pageconten0_.ContentId=content3_.Id left outer join bcms_pages.HtmlContents content3_1_ on content3_.Id=content3_1_.Id left outer join bcms_blog.BlogPostContents content3_2_ on content3_.Id=content3_2_.Id left outer join bcms_root.Widgets content3_3_ on content3_.Id=content3_3_.Id left outer join bcms_pages.HtmlContentWidgets content3_4_ on content3_.Id=content3_4_.Id left outer join bcms_pages.ServerControlWidgets content3_5_ on content3_.Id=content3_5_.Id left outer join bcms_root.ContentOptions contentopt4_ on content3_.Id=contentopt4_.ContentId and (contentopt4_.IsDeleted = 0) left outer join bcms_root.Contents history5_ on content3_.Id=history5_.OriginalId and (history5_.IsDeleted = 0) left outer join bcms_pages.HtmlContents history5_1_ on history5_.Id=history5_1_.Id left outer join bcms_blog.BlogPostContents history5_2_ on history5_.Id=history5_2_.Id left outer join bcms_root.Widgets history5_3_ on history5_.Id=history5_3_.Id left outer join bcms_pages.HtmlContentWidgets history5_4_ on history5_.Id=history5_4_.Id left outer join bcms_pages.ServerControlWidgets history5_5_ on history5_.Id=history5_5_.Id left outer join bcms_root.PageContentOptions options6_ on pageconten0_.Id=options6_.PageContentId and (options6_.IsDeleted = 0) where not (pageconten0_.IsDeleted=1) and page1_.PageUrlHash=? and (content2_.Status=? or content2_.Status=?) and not (pageconten0_.IsDeleted=1) and not (content2_.IsDeleted=1) and not (page1_.IsDeleted=1); ] NHibernate.Exceptions.GenericADOException: Failed to execute multi query[SQL: select page0_.Id as Id31_0_, layout1_.Id as Id24_1_, layoutregi2_.Id as Id26_2_, region3_.Id as Id36_3_, accessrule5_.Id as Id14_4_, page0_.Version as Version31_0_, page0_.IsDeleted as IsDeleted31_0_, page0_.CreatedOn as CreatedOn31_0_, page0_.ModifiedOn as ModifiedOn31_0_, page0_.DeletedOn as DeletedOn31_0_, page0_.CreatedByUser as CreatedB7_31_0_, page0_.ModifiedByUser as Modified8_31_0_, page0_.DeletedByUser as DeletedB9_31_0_, page0_.PageUrl as PageUrl31_0_, page0_.PageUrlHash as PageUrl11_31_0_, page0_.Title as Title31_0_, page0_.Status as Status31_0_, page0_.PublishedOn as Publish14_31_0_, page0_.MetaTitle as MetaTitle31_0_, page0_.MetaKeywords as MetaKey16_31_0_, page0_.MetaDescription as MetaDes17_31_0_, page0_.LayoutId as LayoutId31_0_, page0_1_.Description as Descript2_33_0_, page0_1_.CustomJS as CustomJS33_0_, page0_1_.CustomCss as CustomCss33_0_, page0_1_.UseCanonicalUrl as UseCanon5_33_0_, page0_1_.UseNoFollow as UseNoFol6_33_0_, page0_1_.UseNoIndex as UseNoIndex33_0_, page0_1_.NodeCountInSitemap as NodeCoun8_33_0_, page0_1_.IsArchived as IsArchived33_0_, page0_1_.CategoryId as CategoryId33_0_, page0_1_.ImageId as ImageId33_0_, page0_1_.SecondaryImageId as Seconda12_33_0_, page0_1_.FeaturedImageId as Feature13_33_0_, page0_2_.ActivationDate as Activati2_34_0_, page0_2_.ExpirationDate as Expirati3_34_0_, page0_2_.AuthorId as AuthorId34_0_, case when page0_2_.Id is not null then 2 when page0_1_.Id is not null then 1 when page0_.Id is not null then 0 end as clazz_0_, layout1_.Version as Version24_1_, layout1_.IsDeleted as IsDeleted24_1_, layout1_.CreatedOn as CreatedOn24_1_, layout1_.ModifiedOn as ModifiedOn24_1_, layout1_.DeletedOn as DeletedOn24_1_, layout1_.CreatedByUser as CreatedB7_24_1_, layout1_.ModifiedByUser as Modified8_24_1_, layout1_.DeletedByUser as DeletedB9_24_1_, layout1_.Name as Name24_1_, layout1_.LayoutPath as LayoutPath24_1_, layout1_.PreviewUrl as PreviewUrl24_1_, layout1_.ModuleId as ModuleId24_1_, layoutregi2_.Version as Version26_2_, layoutregi2_.IsDeleted as IsDeleted26_2_, layoutregi2_.CreatedOn as CreatedOn26_2_, layoutregi2_.ModifiedOn as ModifiedOn26_2_, layoutregi2_.DeletedOn as DeletedOn26_2_, layoutregi2_.CreatedByUser as CreatedB7_26_2_, layoutregi2_.ModifiedByUser as Modified8_26_2_, layoutregi2_.DeletedByUser as DeletedB9_26_2_, layoutregi2_.Description as Descrip10_26_2_, layoutregi2_.LayoutId as LayoutId26_2_, layoutregi2_.RegionId as RegionId26_2_, layoutregi2_.LayoutId as LayoutId0__, layoutregi2_.Id as Id0__, region3_.Version as Version36_3_, region3_.IsDeleted as IsDeleted36_3_, region3_.CreatedOn as CreatedOn36_3_, region3_.ModifiedOn as ModifiedOn36_3_, region3_.DeletedOn as DeletedOn36_3_, region3_.CreatedByUser as CreatedB7_36_3_, region3_.ModifiedByUser as Modified8_36_3_, region3_.DeletedByUser as DeletedB9_36_3_, region3_.RegionIdentifier as RegionI10_36_3_, accessrule5_.Version as Version14_4_, accessrule5_.IsDeleted as IsDeleted14_4_, accessrule5_.CreatedOn as CreatedOn14_4_, accessrule5_.ModifiedOn as ModifiedOn14_4_, accessrule5_.DeletedOn as DeletedOn14_4_, accessrule5_.CreatedByUser as CreatedB7_14_4_, accessrule5_.ModifiedByUser as Modified8_14_4_, accessrule5_.DeletedByUser as DeletedB9_14_4_, accessrule5_.[Identity] as column10_14_4_, accessrule5_.AccessLevel as AccessL11_14_4_, accessrule5_.IsForRole as IsForRole14_4_, accessrule4_.PageId as PageId1__, accessrule4_.AccessRuleId as AccessRu2_1__ from bcms_root.Pages page0_ left outer join bcms_pages.Pages page0_1_ on page0_.Id=page0_1_.Id left outer join bcms_blog.BlogPosts page0_2_ on page0_.Id=page0_2_.Id left outer join bcms_root.Layouts layout1_ on page0_.LayoutId=layout1_.Id left outer join bcms_root.LayoutRegions layoutregi2_ on layout1_.Id=layoutregi2_.LayoutId and (layoutregi2_.IsDeleted = 0) left outer join bcms_root.Regions region3_ on layoutregi2_.RegionId=region3_.Id left outer join bcms_root.PageAccessRules accessrule4_ on page0_.Id=accessrule4_.PageId left outer join bcms_root.AccessRules accessrule5_ on accessrule4_.AccessRuleId=accessrule5_.Id where not (page0_.IsDeleted=1) and not (page0_.IsDeleted=1) and page0_.PageUrlHash=?; select pageconten0_.Id as Id29_0_, content3_.Id as Id16_1_, contentopt4_.Id as Id22_2_, history5_.Id as Id16_3_, options6_.Id as Id30_4_, pageconten0_.Version as Version29_0_, pageconten0_.IsDeleted as IsDeleted29_0_, pageconten0_.CreatedOn as CreatedOn29_0_, pageconten0_.ModifiedOn as ModifiedOn29_0_, pageconten0_.DeletedOn as DeletedOn29_0_, pageconten0_.CreatedByUser as CreatedB7_29_0_, pageconten0_.ModifiedByUser as Modified8_29_0_, pageconten0_.DeletedByUser as DeletedB9_29_0_, pageconten0_.[Order] as column10_29_0_, pageconten0_.RegionId as RegionId29_0_, pageconten0_.ContentId as ContentId29_0_, pageconten0_.PageId as PageId29_0_, content3_.Version as Version16_1_, content3_.IsDeleted as IsDeleted16_1_, content3_.CreatedOn as CreatedOn16_1_, content3_.ModifiedOn as ModifiedOn16_1_, content3_.DeletedOn as DeletedOn16_1_, content3_.CreatedByUser as CreatedB7_16_1_, content3_.ModifiedByUser as Modified8_16_1_, content3_.DeletedByUser as DeletedB9_16_1_, content3_.Name as Name16_1_, content3_.PreviewUrl as PreviewUrl16_1_, content3_.Status as Status16_1_, content3_.PublishedByUser as Publish13_16_1_, content3_.PublishedOn as Publish14_16_1_, content3_.OriginalId as OriginalId16_1_, content3_1_.ActivationDate as Activati2_17_1_, content3_1_.ExpirationDate as Expirati3_17_1_, content3_1_.Html as Html17_1_, content3_1_.CustomCss as CustomCss17_1_, content3_1_.UseCustomCss as UseCusto6_17_1_, content3_1_.CustomJs as CustomJs17_1_, content3_1_.UseCustomJs as UseCusto8_17_1_, content3_1_.EditInSourceMode as EditInSo9_17_1_, content3_3_.CategoryId as CategoryId19_1_, content3_4_.Html as Html20_1_, content3_4_.UseHtml as UseHtml20_1_, content3_4_.CustomCss as CustomCss20_1_, content3_4_.UseCustomCss as UseCusto5_20_1_, content3_4_.CustomJs as CustomJs20_1_, content3_4_.UseCustomJs as UseCusto7_20_1_, content3_4_.EditInSourceMode as EditInSo8_20_1_, content3_5_.Url as Url21_1_, case when content3_2_.Id is not null then 2 when content3_4_.Id is not null then 4 when content3_5_.Id is not null then 5 when content3_1_.Id is not null then 1 when content3_3_.Id is not null then 3 when content3_.Id is not null then 0 end as clazz_1_, contentopt4_.Version as Version22_2_, contentopt4_.IsDeleted as IsDeleted22_2_, contentopt4_.CreatedOn as CreatedOn22_2_, contentopt4_.ModifiedOn as ModifiedOn22_2_, contentopt4_.DeletedOn as DeletedOn22_2_, contentopt4_.CreatedByUser as CreatedB7_22_2_, contentopt4_.ModifiedByUser as Modified8_22_2_, contentopt4_.DeletedByUser as DeletedB9_22_2_, contentopt4_.[Key] as column10_22_2_, contentopt4_.Type as Type22_2_, contentopt4_.DefaultValue as Default12_22_2_, contentopt4_.IsDeletable as IsDelet13_22_2_, contentopt4_.ContentId as ContentId22_2_, contentopt4_.CustomOptionId as CustomO15_22_2_, contentopt4_.ContentId as ContentId0__, contentopt4_.Id as Id0__, history5_.Version as Version16_3_, history5_.IsDeleted as IsDeleted16_3_, history5_.CreatedOn as CreatedOn16_3_, history5_.ModifiedOn as ModifiedOn16_3_, history5_.DeletedOn as DeletedOn16_3_, history5_.CreatedByUser as CreatedB7_16_3_, history5_.ModifiedByUser as Modified8_16_3_, history5_.DeletedByUser as DeletedB9_16_3_, history5_.Name as Name16_3_, history5_.PreviewUrl as PreviewUrl16_3_, history5_.Status as Status16_3_, history5_.PublishedByUser as Publish13_16_3_, history5_.PublishedOn as Publish14_16_3_, history5_.OriginalId as OriginalId16_3_, history5_1_.ActivationDate as Activati2_17_3_, history5_1_.ExpirationDate as Expirati3_17_3_, history5_1_.Html as Html17_3_, history5_1_.CustomCss as CustomCss17_3_, history5_1_.UseCustomCss as UseCusto6_17_3_, history5_1_.CustomJs as CustomJs17_3_, history5_1_.UseCustomJs as UseCusto8_17_3_, history5_1_.EditInSourceMode as EditInSo9_17_3_, history5_3_.CategoryId as CategoryId19_3_, history5_4_.Html as Html20_3_, history5_4_.UseHtml as UseHtml20_3_, history5_4_.CustomCss as CustomCss20_3_, history5_4_.UseCustomCss as UseCusto5_20_3_, history5_4_.CustomJs as CustomJs20_3_, history5_4_.UseCustomJs as UseCusto7_20_3_, history5_4_.EditInSourceMode as EditInSo8_20_3_, history5_5_.Url as Url21_3_, case when history5_2_.Id is not null then 2 when history5_4_.Id is not null then 4 when history5_5_.Id is not null then 5 when history5_1_.Id is not null then 1 when history5_3_.Id is not null then 3 when history5_.Id is not null then 0 end as clazz_3_, history5_.OriginalId as OriginalId1__, history5_.Id as Id1__, options6_.Version as Version30_4_, options6_.IsDeleted as IsDeleted30_4_, options6_.CreatedOn as CreatedOn30_4_, options6_.ModifiedOn as ModifiedOn30_4_, options6_.DeletedOn as DeletedOn30_4_, options6_.CreatedByUser as CreatedB7_30_4_, options6_.ModifiedByUser as Modified8_30_4_, options6_.DeletedByUser as DeletedB9_30_4_, options6_.[Key] as column10_30_4_, options6_.Type as Type30_4_, options6_.Value as Value30_4_, options6_.PageContentId as PageCon13_30_4_, options6_.CustomOptionId as CustomO14_30_4_, options6_.PageContentId as PageCon13_2__, options6_.Id as Id2__ from bcms_root.PageContents pageconten0_ inner join bcms_root.Pages page1_ on pageconten0_.PageId=page1_.Id inner join bcms_root.Contents content2_ on pageconten0_.ContentId=content2_.Id left outer join bcms_root.Contents content3_ on pageconten0_.ContentId=content3_.Id left outer join bcms_pages.HtmlContents content3_1_ on content3_.Id=content3_1_.Id left outer join bcms_blog.BlogPostContents content3_2_ on content3_.Id=content3_2_.Id left outer join bcms_root.Widgets content3_3_ on content3_.Id=content3_3_.Id left outer join bcms_pages.HtmlContentWidgets content3_4_ on content3_.Id=content3_4_.Id left outer join bcms_pages.ServerControlWidgets content3_5_ on content3_.Id=content3_5_.Id left outer join bcms_root.ContentOptions contentopt4_ on content3_.Id=contentopt4_.ContentId and (contentopt4_.IsDeleted = 0) left outer join bcms_root.Contents history5_ on content3_.Id=history5_.OriginalId and (history5_.IsDeleted = 0) left outer join bcms_pages.HtmlContents history5_1_ on history5_.Id=history5_1_.Id left outer join bcms_blog.BlogPostContents history5_2_ on history5_.Id=history5_2_.Id left outer join bcms_root.Widgets history5_3_ on history5_.Id=history5_3_.Id left outer join bcms_pages.HtmlContentWidgets history5_4_ on history5_.Id=history5_4_.Id left outer join bcms_pages.ServerControlWidgets history5_5_ on history5_.Id=history5_5_.Id left outer join bcms_root.PageContentOptions options6_ on pageconten0_.Id=options6_.PageContentId and (options6_.IsDeleted = 0) where not (pageconten0_.IsDeleted=1) and page1_.PageUrlHash=? and (content2_.Status=? or content2_.Status=?) and not (pageconten0_.IsDeleted=1) and not (content2_.IsDeleted=1) and not (page1_.IsDeleted=1); ] ---> System.Data.SqlClient.SqlException: Transaction (Process ID 752) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at NHibernate.Driver.NHybridDataReader.NextResult() at NHibernate.Driver.BatcherDataReaderWrapper.NextResult() at NHibernate.Impl.MultiQueryImpl.DoList() --- End of inner exception stack trace --- at NHibernate.Impl.MultiQueryImpl.DoList() at NHibernate.Impl.MultiQueryImpl.ListIgnoreQueryCache() at NHibernate.Impl.MultiQueryImpl.List() at NHibernate.Impl.FutureQueryBatch.GetResultsFrom(IMultiQuery multiApproach) at NHibernate.Impl.FutureBatch2.GetResults() at NHibernate.Impl.FutureBatch2.get_Results() at NHibernate.Impl.FutureBatch2.GetCurrentResult[TResult](Int32 currentIndex) at NHibernate.Impl.FutureBatch2.<>c__DisplayClass41.1.<get_Enumerable>d__0.MoveNext() at System.Collections.Generic.List1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) at BetterCms.Module.Root.Commands.GetPageToRender.GetPageToRenderCommand.Execute(GetPageToRenderRequest request) at BetterCms.Module.Root.Controllers.CmsController.GetRequestModel(String virtualPath) at BetterCms.Module.Root.Controllers.CmsController.Index() Transaction (Process ID 752) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. System.Data.SqlClient.SqlException (0x80131904): Transaction (Process ID 752) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at NHibernate.Driver.NHybridDataReader.NextResult() at NHibernate.Driver.BatcherDataReaderWrapper.NextResult() at NHibernate.Impl.MultiQueryImpl.DoList() ClientConnectionId:d450e8ec-8409-494b-a9bc-c38621550bfc