# Build 1920 - Deadlock
**URL:** https://www.finalbuilder.com/forums/t/build-1920-deadlock/5819
**Category:** Bugs
**Created:** [April 24, 2013, 10:43am UTC](https://www.finalbuilder.com/forums/t/build-1920-deadlock/5819 "2013-04-24T10:43:53Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@Jenasys](https://www.finalbuilder.com/forums/u/Jenasys)
#### Post date: [April 24, 2013, 10:43am UTC](https://www.finalbuilder.com/forums/t/build-1920-deadlock/5819/1 "2013-04-24T10:43:53Z")
Sorry, something bad happened yesterday in my event log. I'll let you review the reasons behind it.
Build Trigger
Error trigering build. Message: Exception: AggregateException
Message: One or more errors occurred.
Stack Trace:
Exception: GenericADOException
Message: could not execute query
[select build0\_.Id as Id32\_, build0\_.BuildNumber as BuildNum2\_32\_, build0\_.Version as Version32\_, build0\_.Started as Started32\_, build0\_.Finished as Finished32\_, build0\_.Queued as Queued32\_, build0\_.Pinned as Pinned32\_, build0\_.PinComment as PinComment32\_, build0\_.Priority as Priority32\_, build0\_.SummaryState as Summary10\_32\_, build0\_.BuildSuccess as BuildSu11\_32\_, build0\_.OnlyNotifyTriggeringUsers as OnlyNot12\_32\_, build0\_.QuietPeriodLength as QuietPe13\_32\_, build0\_.QuietPeriodExpiry as QuietPe14\_32\_, build0\_.TimeOnQueue as TimeOnQ15\_32\_, build0\_.IsFeatureBranchBuild as IsFeatu16\_32\_, build0\_.UsesDefaultBranch as UsesDef17\_32\_, build0\_.CleanedUp as CleanedUp32\_, build0\_.HasNewChanges as HasNewC19\_32\_, build0\_.Branches as Branches32\_, build0\_.State as State32\_, build0\_.status\_message as status22\_32\_, build0\_.status\_datetime as status23\_32\_, build0\_.ConfigurationVersionId as Configu24\_32\_, build0\_.ConfigurationId as Configu25\_32\_, build0\_.WorkspaceId as Workspa26\_32\_, build0\_.UserId as UserId32\_, build0\_.PinUserId as PinUserId32\_, build0\_.TriggerId as TriggerId32\_, build0\_.VariableNamespaceId as Variabl30\_32\_ from builds\_build build0\_ where build0\_.ConfigurationId=@p0 and build0\_.TriggerId=@p1 and (build0\_.SummaryState=@p2 or build0\_.SummaryState=@p3) and build0\_.QuietPeriodLength\>@p4]
Name:p1 - Value:d946f8da-3ca6-444f-8646-a19400d62206 Name:p2 - Value:9106647b-ea21-49b6-9a33-a1a200b251dc Name:p3 - Value:4 Name:p4 - Value:0 Name:p5 - Value:0
[SQL: select build0\_.Id as Id32\_, build0\_.BuildNumber as BuildNum2\_32\_, build0\_.Version as Version32\_, build0\_.Started as Started32\_, build0\_.Finished as Finished32\_, build0\_.Queued as Queued32\_, build0\_.Pinned as Pinned32\_, build0\_.PinComment as PinComment32\_, build0\_.Priority as Priority32\_, build0\_.SummaryState as Summary10\_32\_, build0\_.BuildSuccess as BuildSu11\_32\_, build0\_.OnlyNotifyTriggeringUsers as OnlyNot12\_32\_, build0\_.QuietPeriodLength as QuietPe13\_32\_, build0\_.QuietPeriodExpiry as QuietPe14\_32\_, build0\_.TimeOnQueue as TimeOnQ15\_32\_, build0\_.IsFeatureBranchBuild as IsFeatu16\_32\_, build0\_.UsesDefaultBranch as UsesDef17\_32\_, build0\_.CleanedUp as CleanedUp32\_, build0\_.HasNewChanges as HasNewC19\_32\_, build0\_.Branches as Branches32\_, build0\_.State as State32\_, build0\_.status\_message as status22\_32\_, build0\_.status\_datetime as status23\_32\_, build0\_.ConfigurationVersionId as Configu24\_32\_, build0\_.ConfigurationId as Configu25\_32\_, build0\_.WorkspaceId as Workspa26\_32\_, build0\_.UserId as UserId32\_, build0\_.PinUserId as PinUserId32\_, build0\_.TriggerId as TriggerId32\_, build0\_.VariableNamespaceId as Variabl30\_32\_ from builds\_build build0\_ where build0\_.ConfigurationId=@p0 and build0\_.TriggerId=@p1 and (build0\_.SummaryState=@p2 or build0\_.SummaryState=@p3) and build0\_.QuietPeriodLength\>@p4]
Stack Trace: at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Hql.Ast.ANTLR.Loader.QueryLoader.List(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.List(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Engine.Query.HQLQueryPlan.PerformList(QueryParameters queryParameters, ISessionImplementor session, IList results)
at NHibernate.Impl.SessionImpl.List(IQueryExpression queryExpression, QueryParameters queryParameters, IList results)
at NHibernate.Impl.AbstractSessionImpl.List(IQueryExpression queryExpression, QueryParameters parameters)
at NHibernate.Impl.ExpressionQueryImpl.List()
at NHibernate.Linq.DefaultQueryProvider.ExecuteQuery(NhLinqExpression nhLinqExpression, IQuery query, NhLinqExpression nhQuery)
at NHibernate.Linq.DefaultQueryProvider.Execute(Expression expression)
at NHibernate.Linq.DefaultQueryProvider.Execute[TResult](Expression expression)
at Remotion.Linq.QueryableBase`1.GetEnumerator()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Continua.Modules.Builds.BuildManager.GetQuietPeriodBuildsForTriggerConfiguration(Trigger trigger)
at Continua.Modules.Builds.Triggers.TriggerController.DoQueueBuild(Guid triggerId, IEnumerable`1 buildChangesets, IApplicationSessionContext session, Boolean onlyNotifyTriggeringUsers)
at Continua.Modules.Builds.Triggers.TriggerController.QueueBuildChangesetBuild(Guid triggerId, ChangesetDTO change, ICoreApplicationContext context, Boolean onlyNotifyTriggeringUsers)
at Continua.Modules.Builds.Triggers.TriggerMessageContext.\<\>c\_\_DisplayClass1.b\_\_0()
at System.Threading.Tasks.Task.Execute()
Exception: SqlException
Message: Transaction (Process ID 60) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
at System.Data.SqlClient.SqlDataReader.Read()
at NHibernate.Driver.NHybridDataReader.Read()
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
---
### Author:  [@Vincent](https://www.finalbuilder.com/forums/u/Vincent)
#### Post date: [April 25, 2013, 2:43am UTC](https://www.finalbuilder.com/forums/t/build-1920-deadlock/5819/2 "2013-04-25T02:43:15Z")
Hmm… sql server how I do love thee… not. We’ve seen deadlock issues before in other areas and have code in place to try and deal with them, but this is the first time I have seen a deadlock in this area. FWIW, we have never seen a deadlock with postgresql. We’ll look into it.