SQL CI - Out of Memory exception during validation

stephen.weistra

Hello,

I have a RG SQL CI Build step in my Team City configuration with the following parameters:
A relative source controlled database folder.
A specified SQL Server, with specific authentication and a named temporary database.

It is important to note I have unlinked all static data from my database source control. There is no static data mentioned in the build log when the step fails.

I am experiencing the following Out of Memory exception with the SQL CI Build step of a Team City configuration:

...
[Step 8/9] sqlCI.exe -- Red Gate's SQL Continuous Integration v2.0.1.382
[12:29:56][Step 8/9]
[12:29:56][Step 8/9] Verifying license (54s)
[12:30:55][Step 8/9] Emptying temporary database (1m:17s)
[12:32:12][Step 8/9] Validating database state (10m:23s)
[12:32:12][Validating database state] STARTING: Validating database state
[12:32:12][Validating database state] Starting: D:TeamCityuildAgentpluginssqlci-teamcity-agentassetsSCSQLCompare.exe /include="Identical" /include="StaticData" /scripts1="D:TeamCityuildAgent empuildTmp
qweft1e.vwqdbstate" /server2="AWESOMEDBSERVER" /database2="AWESOMEDB" /username2="awesome_user" /password2=****** /synchronize /options="default,UseMigrationsV2"
[12:32:47][Validating database state] Automation License: activated, edition: standard, serial number: MY_SECRET_SERIAL_NO
[12:32:47][Validating database state] SQL Compare Command Line V11.0.0.184
[12:32:47][Validating database state] ==============================================================================
[12:32:47][Validating database state] Copyright c Red Gate Software Ltd 1999-2014
[12:32:47][Validating database state]
[12:33:03][Validating database state] Registering data sources
...
//

---

// Example Output that has been obfuscated due to company policy...
//

---

[12:33:55][Validating database state] Function [dbo].[fn_SOMEFUNCTION] >>
[12:33:55][Validating database state] Role db_accessadmin == ==
[12:33:55][Validating database state] Role db_backupoperator == ==
[12:33:55][Validating database state] Role db_datareader <> <>
[12:33:55][Validating database state] Role db_datawriter <> <>
[12:33:55][Validating database state] Role db_ddladmin == ==
[12:33:55][Validating database state] Role db_denydatareader == ==
[12:33:55][Validating database state] Role db_denydatawriter == ==
[12:33:55][Validating database state] Role db_owner <> <>
[12:33:55][Validating database state] Role db_securityadmin == ==
[12:33:55][Validating database state] Role public == ==
[12:33:55][Validating database state] Role sp_executor >>
[12:33:55][Validating database state] User SOMEUSER_reports >>
[12:33:55][Validating database state] User SOMEUSER_Support >>
[12:33:55][Validating database state] User SOMEUSER_user >>
[12:33:55][Validating database state] DdlTrigger SOMEDDLTRIGGER >>
[12:33:55][Validating database state] Schema INFORMATION_SCHEMA == ==
[12:33:55][Validating database state] Schema Log >>
[12:33:55][Validating database state] Schema Reporting >>
[12:33:55][Validating database state] Schema db_accessadmin == ==
[12:33:55][Validating database state] Schema db_backupoperator == ==
[12:33:55][Validating database state] Schema db_datareader == ==
[12:33:55][Validating database state] Schema db_datawriter == ==
[12:33:55][Validating database state] Schema db_ddladmin == ==
[12:33:55][Validating database state] Schema db_denydatareader == ==
[12:33:55][Validating database state] Schema db_denydatawriter == ==
[12:33:55][Validating database state] Schema db_owner == ==
[12:33:55][Validating database state] Schema db_securityadmin == ==
[12:33:55][Validating database state] Schema dbo == ==
[12:33:55][Validating database state] Schema guest == ==
[12:33:55][Validating database state] Schema sys == ==
[12:33:55][Validating database state]

---

[12:42:10][Validating database state] Unexpected error: Exception of type 'System.OutOfMemoryException' was thrown.
[12:42:10][Validating database state] Exception of type 'System.OutOfMemoryException' was thrown.
[12:42:10][Validating database state] System.OutOfMemoryException
[12:42:10][Validating database state] at System.String.ConcatArray(String[] values, Int32 totalLength)
[12:42:10][Validating database state] at System.String.Concat(Object[] args)
[12:42:10][Validating database state] at #H3Zc.#hRZc.#83Zc(FileInfo #93Zc, #hRZc& #zNSb)
[12:42:10][Validating database state] at #H3Zc.#hRZc.#73Zc(DirectoryInfo #Ltk, #hRZc& #zNSb)
[12:42:10][Validating database state] at #8rg.#HWC.#CTXc(Options #5OPb, String #yIc)
[12:42:10][Validating database state] at #8rg.#HWC.#Jt0c(Options #5OPb, Database #RHc)
[12:42:10][Validating database state] at RedGate.SQLCompare.Engine.Table.#shh(#szg #dXrc, Options #5OPb)
[12:42:10][Validating database state] at #8rg.#ht0c.#shh(#esg #8Urc, Options #5OPb, #szg #dXrc)
[12:42:10][Validating database state] at #8rg.#QC0c.#shh(#esg #8Urc, Options #5OPb)
[12:42:10][Validating database state] at #8rg.#1rPb.#shh(#esg #8Urc, Options #5OPb)
[12:42:10][Validating database state] at #i9G.#r9G.#JaH(String #0Sr, #esg #qdk)
[12:42:10][Validating database state] at #i9G.#r9G.#JaH(Difference #2dP)
[12:42:10][Validating database state] at #i9G.#r9G.#JaH(#lO3 #BcZ, #lO3 #CcZ, #XrPb #vfX)
[12:42:10][Validating database state] at RedGate.SQLCompare.CommandLine.CommandLineCompareEngineExecutor.#maH(Boolean #S0Tc)
[12:42:10][Validating database state] at #i9G.#j9G.#maH(Boolean #S0Tc)
[12:42:10][Validating database state] at RedGate.SQLCompare.CommandLine.CommandProcessor.#wcmb()
[12:42:10][Validating database state] at RedGate.SQLToolsCommandLine.CommandProcessor.#ZjD()
[12:42:10][Validating database state] at RedGate.SQLToolsCommandLine.CommandProcessor.#kcmb()
[12:42:10][Validating database state] at RedGate.SQLCompare.CommandLine.CommandProcessor.#kcmb()
[12:42:10][Validating database state] at RedGate.SQLToolsCommandLine.CommandProcessor.Run()
[12:42:10][Validating database state] at RedGate.SQLCompare.CommandLine.Startup.Main(String[] args)
[12:42:36][Validating database state] ##teamcity[buildStatus status='FAILURE' text='Validating database state failed with error: SQLCompare failed with exit code 70: see output above for more information, or for generic information about this exit code, see: [url=http://www.red-gate.com/sqlCI/ExitCodes/SQLCompare']http://www.red-gate.com/sqlCI/ExitCodes/SQLCompare'[/url]]
[12:42:36][Validating database state] FINISHED WITH ERROR: Validating database state
[12:42:37][Step 8/9] ##teamcity[buildStatus status='FAILURE' text='Running SQLCompare failed with error: SQLCompare failed with exit code 70: see output above for more information, or for generic information about this exit code, see: [url=http://www.red-gate.com/sqlCI/ExitCodes/SQLCompare']http://www.red-gate.com/sqlCI/ExitCodes/SQLCompare'[/url]]
[12:42:37]Process exited with code 32
[12:42:38][Step 8/9] Step Create package: DC Tracker database (Red Gate SQL CI Build) failed

Thanks,
Stephen Weistra