数据库架构比较错误:“版本存储空间不足" [英] DB Schema Compare Error: 'Version store out of memory'

问题描述

以下是我在带有更新3的Visual Studio 2013 Professional中进行架构比较时收到的错误.我正在使用版本2008 R2 DB服务器，并且正在利用SSMS 2014.

Below is an error that I have been receiving while doing a schema compare in Visual Studio 2013 Professional w/ Update 3. I am using version 2008 R2 DB server and I am utilizing SSMS 2014.

此错误持续了几个星期，并且越来越频繁地弹出.所以我重新格式化了我的机器...猜猜是什么..再次设置完所有内容后，我又收到了错误消息！

This error was persistent for a couple weeks continually popping up more and more frequently. So I reformatted my machine... guess what.. once everything was setup again, I received the error again!

请帮助我了解如何解决此问题.谢谢！

Please help me understand what I can do to resolve this issue. Thank you!

Microsoft.Isam.Esent.Interop.EsentVersionStoreOutOfMemoryException
Version store out of memory (cleanup already attempted)

   at Microsoft.Isam.Esent.Interop.Api.Check(Int32 err)
   at Microsoft.Isam.Esent.Interop.Api.JetDelete(JET_SESID sesid, JET_TABLEID tableid)
   at Microsoft.Data.Tools.Schema.SchemaModel.ModelStore.EseResultSet.Delete()
   at Microsoft.Data.Tools.Schema.SchemaModel.ModelStore.EseCommand.<>c__DisplayClass1b2.<DeleteRows>b__1b1(EseResultSet rs)
   at Microsoft.Data.Tools.Schema.SchemaModel.ModelStore.EseCommand.RunQueryImpl(Func1 stopProcessing, Action1 action, Object[] keys)
   at Microsoft.Data.Tools.Schema.SchemaModel.ModelStore.EseCommand.DeleteRows(Object[] keys)
   at Microsoft.Data.Tools.Schema.SchemaModel.ModelStore.CoreDelete(ModelElement element, IList1 elementsToSignal)
   at Microsoft.Data.Tools.Schema.SchemaModel.ModelStore.DeleteElement(ModelElement element, Boolean includeHierarchical)
   at Microsoft.Data.Tools.Schema.SchemaModel.ModelElement.Delete(Boolean deleteHierarchicalChildren)
   at Microsoft.Data.Tools.Schema.SchemaModel.DataSchemaModel.UnloadExternals(String fileName)
   at Microsoft.Data.Tools.Schema.SchemaModel.DataSchemaModel.OnCustomDataRemoved(CustomSchemaData customData)
   at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlSchemaModel.OnCustomDataRemoved(CustomSchemaData customData)
   at Microsoft.Data.Tools.Schema.SchemaModel.DataSchemaModel.RemoveCustomData(CustomSchemaData customData)
   at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlModelBuilder.Clear(CustomSchemaData dataToDelete)
   at Microsoft.Data.Tools.Schema.SchemaModel.ModelBuilder.AddOrUpdate(CustomSchemaData customSchemaData)
   at Microsoft.Data.Tools.Schema.Utilities.Sql.Jobs.ModelBuilderJob.RunImpl()
------ Exception Data --------
Key : error
Value : VersionStoreOutOfMemory

推荐答案

我自己搜索解决方案，但从未在网上找到任何有用的信息.经过一些试验后，我发现一个设置更改，使我可以比较和编译非常顽固的项目.我进入了SqlProj项目的属性，一直到"SQLCLR Build"选项卡，然后单击"Advanced ..."按钮.在输出"部分中，我将调试信息"下拉列表更改为仅pdb".这为我带来了很大的改善，但偶尔还是会发生崩溃.

I've searched for solutions myself and never found anything helpful online. After doing some experimenting I found one setting change that allows me to compare and compile my very stubborn projects. I went into the properties of the SqlProj project, down to the "SQLCLR Build" tab and clicked on the "Advanced..." button. In the Output section I changed the "Debug Info" dropdown to be "pdb-only". That improved it for me quite a bit, but I still get the occasional crash.

这篇关于数据库架构比较错误:“版本存储空间不足"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！