通过 Powershell 脚本部署 SSDT 项目:版本存储内存不足错误 [英] Deploying SSDT project through Powershell Script: Version store out of memory error

问题描述

希望有人能够就这里可能发生的事情提出建议.我正在尝试通过 Powershell 脚本直接在 SQL Server 本身上运行 SSDT 部署.

Hoping someone may be able to advise what might be happening here. I am attempting to run an SSDT deployment via a Powershell script directly on the SQL Server its-self.

SQL 版本:2012(目前无法升级)

SQL Version: 2012 (upgrade not possible at the moment)

确切的错误:

System.Management.Automation.MethodInvocationException:异常使用3"参数调用GenerateDeployScript":版本存储内存不足(已尝试清理)"Microsoft.Isam.Esent.Interop.EsentVersionStoreOutOfMemoryException:版本存储内存不足(已尝试清理)

System.Management.Automation.MethodInvocationException: Exception calling "GenerateDeployScript" with "3" argument(s): "Version store out of memory (cleanup already attempted)" Microsoft.Isam.Esent.Interop.EsentVersionStoreOutOfMemoryException: Version store out of memory (cleanup already attempted)

我在网络上的所有研究都有通过 MSBuild 发生这种情况的解决方案，但是我无处可应用此过程的修复程序，因为它发生在构建过程之外.

All my research on the web has solutions for when this occurs through MSBuild, however I have no-where to apply the fix for this process as it happens outside of the build process.

谁能建议如何防止这种情况发生?谢谢:)

Can anyone advise how one might prevent this from occuring? Thanks :)

推荐答案

尝试使用 MSBuild 参数 /p:CmdLineInMemoryStorage=true 进行构建.这似乎为其他遇到此问题的人解决了同样的问题.

Try building with the MSBuild argument /p:CmdLineInMemoryStorage=true. This seems to have fixed this same issue for others running into this problem.

我已经在我的 Azure DevOps Pipeline 版本中为一个数据库进程实施了修复程序，该进程也随机出现了此错误，到目前为止它似乎正在工作.

I have implemented the fix in my Azure DevOps Pipeline build for a database process that has also randomly had this error, and so far it seems to be working.

另见:

SO 问题:DB 模式比较错误:'版本存储内存不足'

这篇关于通过 Powershell 脚本部署 SSDT 项目:版本存储内存不足错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！