Skip to content

Instantly share code, notes, and snippets.

@takano32
Created December 1, 2009 08:55
Show Gist options
  • Select an option

  • Save takano32/246171 to your computer and use it in GitHub Desktop.

Select an option

Save takano32/246171 to your computer and use it in GitHub Desktop.
Server Error in '/' Application.
Transaction (Process ID 336) 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 336) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): Transaction (Process ID 336) 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) +1948826
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4844747
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlDataReader.HasMoreRows() +157
System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +197
System.Data.SqlClient.SqlDataReader.Read() +9
NHibernate.Driver.NHybridDataReader.Read() +14
NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +571
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +70
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +165
[ADOException: could not execute query
[ SELECT this_.Id as Id13_0_, this_.Status as Status13_0_, this_.Shop_id as Shop3_13_0_, this_.Donate_id as Donate4_13_0_, this_.Branding_id as Branding5_13_0_, this_.ActivityUpdated as Activity6_13_0_, this_.AdDefinition_id as AdDefini7_13_0_, this_.OverlayUrl as OverlayUrl13_0_, this_.UrlName as UrlName13_0_, this_.Description as Descrip10_13_0_, this_.ExampleUrl as ExampleUrl13_0_, this_.TweetFormat as TweetFo12_13_0_, this_.SupporterCount as Support13_13_0_, this_.Creator as Creator13_0_, this_.UserId as UserId13_0_, this_.FacebookUserId as Faceboo16_13_0_, this_.Url as Url13_0_, this_.IsFeatured as IsFeatured13_0_, this_.ActivityAccount_id as Activit19_13_0_, this_.RssUrl as RssUrl13_0_, this_.LastSupported as LastSup21_13_0_, this_.AmazonProductsSet as AmazonP22_13_0_, this_.DisplayInSearchResults as Display23_13_0_, this_.DisplayInCategoriesAndTags as Display24_13_0_, this_.IsCustomized as IsCusto25_13_0_, this_.IsFacebookEnabled as IsFaceb26_13_0_, this_.Title as Title13_0_, this_.DateCreated as DateCre28_13_0_ FROM [Cause] this_ WHERE this_.UrlName = ? ]
Positional parameters: #0>santa-hat
[SQL: SELECT this_.Id as Id13_0_, this_.Status as Status13_0_, this_.Shop_id as Shop3_13_0_, this_.Donate_id as Donate4_13_0_, this_.Branding_id as Branding5_13_0_, this_.ActivityUpdated as Activity6_13_0_, this_.AdDefinition_id as AdDefini7_13_0_, this_.OverlayUrl as OverlayUrl13_0_, this_.UrlName as UrlName13_0_, this_.Description as Descrip10_13_0_, this_.ExampleUrl as ExampleUrl13_0_, this_.TweetFormat as TweetFo12_13_0_, this_.SupporterCount as Support13_13_0_, this_.Creator as Creator13_0_, this_.UserId as UserId13_0_, this_.FacebookUserId as Faceboo16_13_0_, this_.Url as Url13_0_, this_.IsFeatured as IsFeatured13_0_, this_.ActivityAccount_id as Activit19_13_0_, this_.RssUrl as RssUrl13_0_, this_.LastSupported as LastSup21_13_0_, this_.AmazonProductsSet as AmazonP22_13_0_, this_.DisplayInSearchResults as Display23_13_0_, this_.DisplayInCategoriesAndTags as Display24_13_0_, this_.IsCustomized as IsCusto25_13_0_, this_.IsFacebookEnabled as IsFaceb26_13_0_, this_.Title as Title13_0_, this_.DateCreated as DateCre28_13_0_ FROM [Cause] this_ WHERE this_.UrlName = ?]]
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +259
NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +18
NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) +81
NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) +334
NHibernate.Impl.CriteriaImpl.List(IList results) +41
NHibernate.Impl.CriteriaImpl.List() +60
NHibernate.Linq.Visitors.ImmediateResultsVisitor`1.GetElementList(MethodCallExpression call, Int32 count) +158
NHibernate.Linq.Visitors.ImmediateResultsVisitor`1.HandleFirstOrDefaultCall(MethodCallExpression call) +16
NHibernate.Linq.Visitors.ImmediateResultsVisitor`1.VisitMethodCall(MethodCallExpression call) +368
NHibernate.Linq.Visitors.ExpressionVisitor.Visit(Expression exp) +341
NHibernate.Linq.Visitors.NHibernateExpressionVisitor.Visit(Expression exp) +204
NHibernate.Linq.Visitors.ImmediateResultsVisitor`1.GetResults(MethodCallExpression expr) +12
NHibernate.Linq.Visitors.RootVisitor.HandleImmediateResultsCall(MethodCallExpression call) +174
NHibernate.Linq.Visitors.RootVisitor.VisitMethodCall(MethodCallExpression expr) +686
NHibernate.Linq.Visitors.ExpressionVisitor.Visit(Expression exp) +341
NHibernate.Linq.Visitors.NHibernateExpressionVisitor.Visit(Expression exp) +204
NHibernate.Linq.Visitors.NHibernateQueryTranslator.Translate(Expression expression, QueryOptions queryOptions) +85
NHibernate.Linq.NHibernateQueryProvider.Execute(Expression expression) +216
NHibernate.Linq.QueryProvider.System.Linq.IQueryProvider.Execute(Expression expression) +29
System.Linq.Queryable.FirstOrDefault(IQueryable`1 source) +269
Twibbon.Services.CauseService.FindByUrlName(String urlName) in D:\Development\Twibbon\trunk\Twibbon.Services\Domain\CauseService.cs:56
Twibbon.Web.Controllers.CauseController.Join(String urlName, String leagueUrlName, Nullable`1 jobId) in D:\Development\Twibbon\trunk\Twibbon.Web\Controllers\CauseController.cs:324
lambda_method(ExecutionScope , ControllerBase , Object[] ) +196
System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) +17
System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +178
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +24
System.Web.Mvc.<>c__DisplayClassa.<InvokeActionMethodWithFilters>b__7() +52
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +254
System.Web.Mvc.<>c__DisplayClassc.<InvokeActionMethodWithFilters>b__9() +19
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +192
System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) +399
System.Web.Mvc.Controller.ExecuteCore() +126
System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) +27
System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext) +7
System.Web.Mvc.MvcHandler.ProcessRequest(HttpContextBase httpContext) +151
System.Web.Mvc.MvcHandler.ProcessRequest(HttpContext httpContext) +57
System.Web.Mvc.MvcHandler.System.Web.IHttpHandler.ProcessRequest(HttpContext httpContext) +7
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +181
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75
Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment