锁定资源陷入僵局 [英] deadlocked on lock resources
问题描述
我定期收到死锁错误消息（下面），这似乎与另一个使用 进行产品加载的进程重合。 ImportXml（）：
Hi, I'm getting a deadlock error message (below) on a regular basis, it seems to coincide with another process doing a product load using ImportXml() :
即。 ： 
i.e. :
    xmlImportOptions.Operation = ImportOperation.ValidateAndImport
&NBSP;&NBSP;&NBSP; xmlImportOptions.ErrorThreshold = Integer.MaxValue <无线电通信/>
&NBSP;&NBSP;&NBSP; xmlImportOptions.OverwriteRelationships =假
&NBSP;&NBSP;&NBSP; xmlImportOptions = ImportMode.Incremental
xmlImportOptions.Operation = ImportOperation.ValidateAndImport
xmlImportOptions.ErrorThreshold = Integer.MaxValue
xmlImportOptions.OverwriteRelationships = False
xmlImportOptions=ImportMode.Incremental
&NBSP;&NBSP ;&NBSP; CatalogContext.ImportXml（xmlImportOptions，文件名）
CatalogContext.ImportXml(xmlImportOptions, filename)
你有什么建议
&NBSP;
----
异常信息：
例外类型：Microsoft.CommerceServer.Catalog.CatalogDatabaseException
例外消息：搜索失败。
Exception information:
Exception type: Microsoft.CommerceServer.Catalog.CatalogDatabaseException
Exception message: Search failed.
内部异常信息（级别1）：
异常类型：System.Data.SqlClient.SqlException
异常消息：事务（进程ID 72）在锁资源上与另一个进程死锁，并被选为死锁牺牲品。重新运行该交易。
8X [snip]
堆栈跟踪： 在Microsoft.CommerceServer.Catalog.Internal.CommonHelpers.Search（CatalogExecutionContext executionContext，StringCollection catalogsToSearchCollection，String sqlClause，String ftsPhrase，String advancedFtsPhrase，
String language，CatalogSearchOptions searchOptions，InventoryOptions inventoryOptions，JoinTableInformation joinTableInformation，String categoryClause，Boolean recursive， Int32& totalRecords，Boolean returnTotalRecords）
在Microsoft.CommerceServer.Catalog.Internal.CommonHelpers.Search（CatalogExecutionContext executionContext，StringCollection catalogsToSearchCollection，String sqlClause，String ftsPhrase，String advancedFtsPhrase，String language，CatalogSearchOptions
searchOptions，InventoryOptions inventoryOptions，JoinTableInformation joinTableInformation，String categoryClause，Boolean recursive）
在Microsoft.CommerceServer.Catalog.Internal.CatalogContext.Search（CatalogExecutionContext catalogExecutionContext，StringCollection catalogsToSearch，字符串sqlClause，字符串ftsPhrase，字符串advancedftsPhrase，String语言，CatalogSearchOptions
searchOptions，InventoryOptions inventoryOptions，JoinTableInformation joinTableInformation，字符串categoryClause，布尔递归）
在Microsoft.CommerceServer.Catalog.Internal.CatalogSearch.Search（Int32& totalRecords，Boolean returnTotalRecords）
在Microsoft.CommerceServer.Catalog.Internal.CatalogServerContextBase.Search（CatalogSearchParameters catalogSearchParameters，CatalogSearchOptions searchOptions，InventoryOptions inventoryOptions，JoinTableInformation joinTableInformation）
&NBSP;&NBSP;在Microsoft.CommerceServer.Catalog.CatalogSearch.Search（）
Inner exception information (level 1):
Exception type: System.Data.SqlClient.SqlException
Exception message: Transaction (Process ID 72) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
8X[snip]
Stack trace: at Microsoft.CommerceServer.Catalog.Internal.CommonHelpers.Search(CatalogExecutionContext executionContext, StringCollection catalogsToSearchCollection, String sqlClause, String ftsPhrase, String advancedFtsPhrase,
String language, CatalogSearchOptions searchOptions, InventoryOptions inventoryOptions, JoinTableInformation joinTableInformation, String categoryClause, Boolean recursive, Int32& totalRecords, Boolean returnTotalRecords)
at Microsoft.CommerceServer.Catalog.Internal.CommonHelpers.Search(CatalogExecutionContext executionContext, StringCollection catalogsToSearchCollection, String sqlClause, String ftsPhrase, String advancedFtsPhrase, String language, CatalogSearchOptions
searchOptions, InventoryOptions inventoryOptions, JoinTableInformation joinTableInformation, String categoryClause, Boolean recursive)
at Microsoft.CommerceServer.Catalog.Internal.CatalogContext.Search(CatalogExecutionContext catalogExecutionContext, StringCollection catalogsToSearch, String sqlClause, String ftsPhrase, String advancedftsPhrase, String language, CatalogSearchOptions
searchOptions, InventoryOptions inventoryOptions, JoinTableInformation joinTableInformation, String categoryClause, Boolean recursive)
at Microsoft.CommerceServer.Catalog.Internal.CatalogSearch.Search(Int32& totalRecords, Boolean returnTotalRecords)
at Microsoft.CommerceServer.Catalog.Internal.CatalogServerContextBase.Search(CatalogSearchParameters catalogSearchParameters, CatalogSearchOptions searchOptions, InventoryOptions inventoryOptions, JoinTableInformation joinTableInformation)
at Microsoft.CommerceServer.Catalog.CatalogSearch.Search()
推荐答案
您是否尝试上传多个目录？您为TransactionMode提供的价值是多少？当您选择 - "NonTransactional"时，可以检查是否会出现相同的错误吗？作为交易模式？
Are you trying to upload multiple catalogs? What is the value you have given for TransactionMode? Can you check whether you get same error when you select -"NonTransactional" as transaction mode?
这篇关于锁定资源陷入僵局的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
