SqlException: Transaction (Process ID 293) 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, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Solutionists.Helpers.Data.Data.ExecuteDataSet(String sql, IEnumerable`1 sqlParameters, String connectionString, Int32 timeout) in e:\Teamcity\BuildAgent\work\d87221c32a21c9f4\Data.cs:line 524 at PrettyGirl.Domain.Repositories.Product.PrettyGirlCategoryProductRepository.GetCategoryProducts(Int32 categoryId, Int32 siteId) in c:\TeamCity\buildAgent\work\cf5ffcc1eae2d4ca\PrettyGirl\PrettyGirl.Domain\Repositories\Product\PrettyGirlCategoryProductRepository.cs:line 123 at PrettyGirl.Domain.Repositories.Product.PrettyGirlCategoryProductRepository.GetCategoryProductProductListResult(Int32 categoryId, Int32 siteId, Int32 currencyId, Boolean supportColourImages) in c:\TeamCity\buildAgent\work\cf5ffcc1eae2d4ca\PrettyGirl\PrettyGirl.Domain\Repositories\Product\PrettyGirlCategoryProductRepository.cs:line 156 at PrettyGirl.Domain.Repositories.Product.PrettyGirlCategoryProductRepository.<>c__DisplayClassd.b__c() in c:\TeamCity\buildAgent\work\cf5ffcc1eae2d4ca\PrettyGirl\PrettyGirl.Domain\Repositories\Product\PrettyGirlCategoryProductRepository.cs:line 151 at PrettyGirl.Infrastructure.Services.InMemoryCacheService.GetWithPolicy[T](String key, CacheItemPolicy policy, Func`1 method, String cacheGroup) in c:\TeamCity\buildAgent\work\cf5ffcc1eae2d4ca\PrettyGirl\PrettyGirl.Infrastructure\Services\InMemoryCacheService.cs:line 55 at PrettyGirl.Infrastructure.Services.InMemoryCacheService.Get[T](String key, CacheItemPolicy policy, Func`1 method, String cacheGroup) in c:\TeamCity\buildAgent\work\cf5ffcc1eae2d4ca\PrettyGirl\PrettyGirl.Infrastructure\Services\InMemoryCacheService.cs:line 65 at PrettyGirl.Infrastructure.Services.InMemoryCacheService.Get[T](String key, TimeSpan ts, Func`1 method, String cacheGroup) in c:\TeamCity\buildAgent\work\cf5ffcc1eae2d4ca\PrettyGirl\PrettyGirl.Infrastructure\Services\InMemoryCacheService.cs:line 41 at PrettyGirl.Infrastructure.Services.InMemoryCacheService.Get[T](String key, Nullable`1 timespan, String regionName, Func`1 method) in c:\TeamCity\buildAgent\work\cf5ffcc1eae2d4ca\PrettyGirl\PrettyGirl.Infrastructure\Services\InMemoryCacheService.cs:line 174 at PrettyGirl.Domain.Repositories.Product.PrettyGirlCategoryProductRepository.RetrieveProductDetails(Int32 categoryId, Int32 siteId, Int32 currencyId, Boolean supportColourImages) in c:\TeamCity\buildAgent\work\cf5ffcc1eae2d4ca\PrettyGirl\PrettyGirl.Domain\Repositories\Product\PrettyGirlCategoryProductRepository.cs:line 151 at PrettyGirl.Domain.Web.Services.PrettyGirlProductListCacheDomainService.GetCategoryListingProducts(Int32 categoryId, Int32 siteId, Int32 currencyId) in c:\TeamCity\buildAgent\work\cf5ffcc1eae2d4ca\PrettyGirl.Domain.Web\Services\PrettyGirlProductListCacheDomainService.cs:line 94 at PrettyGirl.UI.Controllers.ProductListController.ListV2(CategoryListingParametersViewModel requestViewModel) in c:\TeamCity\buildAgent\work\cf5ffcc1eae2d4ca\PrettyGirl\PrettyGirl.UI\Controllers\ProductListController.cs:line 98 at lambda_method(Closure , ControllerBase , Object[] ) at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) at System.Web.Mvc.Async.AsyncControllerActionInvoker.b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.b__3d() at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.b__3f() at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.b__1c() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.b__1e(IAsyncResult asyncResult)