Orchard.Alias.Elementation.Updater.AliasHolderUpdater-Alias刷

Question

交叉柱：https://orchard.codeplex.com/discussions/473454

我想首先说，我目前正在从Orchard CMS 1.6迁移到1.7.2。所以它曾经在1.6中工作，但我现在在1.7.2中遇到了问题。

我的两个内容类型在创建项目时出现问题，它们永远无法完成保存，当我检查日志时，我得到的是：

Orchard.Alias.Implementation.Updater.AliasHolderUpdater - Exception during Alias refresh
NHibernate.Exceptions.GenericADOException: could not execute query
[ select aliasrecor0_.Id as Id1829_, aliasrecor0_.Path as Path1829_, aliasrecor0_.RouteValues as RouteVal3_1829_, aliasrecor0_.Source as Source1829_, aliasrecor0_.Action_id as Action5_1829_ from Orchard_Alias_AliasRecord aliasrecor0_ where aliasrecor0_.Id>@p0 order by aliasrecor0_.Id asc ]
  Name:p1 - Value:48
[SQL: select aliasrecor0_.Id as Id1829_, aliasrecor0_.Path as Path1829_, aliasrecor0_.RouteValues as RouteVal3_1829_, aliasrecor0_.Source as Source1829_, aliasrecor0_.Action_id as Action5_1829_ from Orchard_Alias_AliasRecord aliasrecor0_ where aliasrecor0_.Id>@p0 order by aliasrecor0_.Id asc] ---> System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out

当我停止它并查看网站（真正的任何地方）时，它完全被这个错误破坏了：

Exception Details: System.ComponentModel.Win32Exception: The wait operation timed out
[Win32Exception (0x80004005): The wait operation timed out]
[SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]
Line 162:            return criteria
Line 163:                .List<ContentItemVersionRecord>()
Line 164:                .Select(x => ContentManager.Get(x.ContentItemRecord.Id, _versionOptions != null && _versionOptions.IsDraftRequired ? _versionOptions : VersionOptions.VersionRecord(x.Id)))
Source File: d:ProjectsOffice IgniteMain-1.7srcOrchardContentManagementDefaultContentQuery.cs    Line: 162 

我不知道为什么这与那两个CT是孤立的。它们没有带有自定义表或任何东西的部件。

任何信息都将不胜感激。谢谢

Answer 1

我也有同样的错误，但这个问题似乎和我的代码没有直接关系。

我现在找到了两个解决方案：

1.）分类腐败问题https://orchard.codeplex.com/workitem/20411

2.）静态是脏的，在选择静态时默认使用的锁是重的https://serverfault.com/questions/419997/the-wait-operation-timed-out-when-running-sql-server-in-hyper-v