Azure Pipeline DB Build Fails Randomly with EsentVersionStoreOutOfMemoryException: Version store out of memory

Question

We have an Azure DevOps Pipeline build for our SSDT DACPAC projects, set to run on Continuous Integration. It has been running for a few years, and we've periodically and randomly seen the following error failing the build:

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.JetUpdate(JET_SESID sesid, JET_TABLEID tableid, Byte[] bookmark, Int32 bookmarkSize, Int32& actualBookmarkSize)
   at Microsoft.Isam.Esent.Interop.Update.Save(Byte[] bookmark, Int32 bookmarkSize, Int32& actualBookmarkSize)
   ...

Our fix until now has been to just re-queue a new build. 99% of the time that would resolve the problem. Until today. Now I queued a new CI build 3 times in a row and every time it failed with the same exception. The project builds locally so just some issue with the Pipeline build process.

Is there some fix we can put into our MSBuild Pipeline build process to remove this error?

score 0 · Answer 1 · answered May 22 '19 at 20:59

0

Use “/p:Storage=File” which will use less memory

answered May 22 '19 at 20:59

Ed Elliott

6,666
17
32

score 0 · Accepted Answer · answered May 22 '19 at 21:05

Adding /p:CmdLineInMemoryStorage=true to the MSBuild arguments for the Pipeline build task resolved this issue for me. So far.

I found uncovered many references for similar errors and fixes, but none exactly having to do specifically with Azure DevOps Pipeline builds for SSDT.

See:

Azure Pipeline DB Build Fails Randomly with EsentVersionStoreOutOfMemoryException: Version store out of memory

2 Answers2