topic Re: Anyone getting the error "The app domain ... was unloaded due to memory pressure and could not be found" in Geodatabase Questions

Anyone getting the error "The app domain ... was unloaded due to memory pressure and could not be found"

AaronCohen — Tue, 19 Jul 2016 13:25:11 GMT

Several months ago we upgraded SQL Server to 2014 on Win2012. Geodb is at 10.2.2 still.

Since the upgrade, we see performance degrade over about a 2 week period to the point of having to restart the DB server.

The SQL logs show an increasing number of error statements as shown in the title. Example: on day 10 after a restart I get one unloaded error and it repeats over 5 days, then I get 3 errors on day 16, then 40 on day 17 and finally 3500 on roughly the 18-21st day. At this point the server is paralyzed across the whole instance and needs to be restarted.

This ESRI tech article refers to a Microsoft memory error but gives no details.

Error: The app domain with specified version id (%d) was unloaded due to memory pressure and could not be found

Before we drop $$ on Microsoft, does anyone have a similar experience?

Best I can tell it seems to deal with spatial data types, CLR and memory.

ESRI confirmed that CLR is not required for ArcGIS to work with SQL Server.

Any help is appreciated

TIA

Re: Anyone getting the error "The app domain ... was unloaded due to memory pressure and could not be found"

George_Thompson — Tue, 19 Jul 2016 14:08:35 GMT

Hi Aaron,

What is the memory limits that you have set within SQL Server?

What is the memory utilization of the machine that SQL Server is installed on?

Is ArcGIS for Server also on the same machine as SQL Server?

How much memory on the Win2012 machine? Is it a VM or physical machine?

Re: Anyone getting the error "The app domain ... was unloaded due to memory pressure and could not be found"

AaronCohen — Wed, 20 Jul 2016 20:23:51 GMT

Hi George

The machine has 16GB of RAM - 8 of that for the DB.

Total memory used sits about 60% with the SQL service being the only thing consuming CPU at roughly8-10%

The machine is virtual and only has SQL on it.

Have you had this error yourself?

Re: Anyone getting the error "The app domain ... was unloaded due to memory pressure and could not be found"

George_Thompson — Fri, 22 Jul 2016 12:20:54 GMT

I have seen the error before, usually has to do with something on the SQL Server side and not the ArcGIS side. This would fall under tuning of the RDBMS.

How much memory is the SQL Server service using? You mention that you have set the MAX limit for SQL Server to 8GB and the service is using 60% of the overall memory. That service may be out of memory and needs to be increased in the SQL Server settings.

Can you provide similar screenshots?

Re: Anyone getting the error "The app domain ... was unloaded due to memory pressure and could not be found"

AaronCohen — Mon, 25 Jul 2016 13:26:18 GMT

Here they are. Thoughts?

Re: Anyone getting the error "The app domain ... was unloaded due to memory pressure and could not be found"

George_Thompson — Mon, 25 Jul 2016 14:39:10 GMT

Nope, it looks good. I would imagine that it would be using more memory than that.

Other than that I am out of ideas.

Re: Anyone getting the error "The app domain ... was unloaded due to memory pressure and could not be found"

AaronCohen — Mon, 25 Jul 2016 15:33:37 GMT

George, thanks for the support.

We will continue to monitor and hopefully post results.

Re: Anyone getting the error "The app domain ... was unloaded due to memory pressure and could not be found"

TomDowd — Tue, 27 Sep 2016 12:09:32 GMT

Hi Aaron,

We are experiencing a similar issue in SQL Server 2014. I was wondering if you found a solution. Thanks

Re: Anyone getting the error "The app domain ... was unloaded due to memory pressure and could not be found"

AaronCohen — Thu, 06 Oct 2016 14:20:37 GMT

Sorry for not posting a solution.

Long story short - ESRIs KB says to call Microsoft. That costs money. We didn't do that.

The undocumented solution was to install the highest SQL 2014 service pack available.

It turned into a comedy of errors but the end result was a solution.

This MS page shows all the current SP's for the different versions SQL 2014.

https://support.microsoft.com/en-us/kb/2936603

We are on SQL Server 2014 SP1 CU7 Build version 12.0.4459.0

I have had only 3 UNLOADDED ... errors since the we patched to CU7 and "normal" performance has returned

Whether you are at the base install or SP1 or SP2 you want to install the highest/latest CU.

Hope this helps.

P.S. - always make a backup!!!

Re: Anyone getting the error "The app domain ... was unloaded due to memory pressure and could not be found"

AaronCohen — Thu, 06 Oct 2016 14:25:35 GMT

ESRI does not list SP1 or SP2 yet as supported so go with the base install to stay compliant.

Here is there list

Standard/Enterprise editions

Microsoft SQL Server 2014 (64-bit)

http://desktop.arcgis.com/en/arcmap/10.3/get-started/system-requirements/database-requirements-sqlserver.htm

Re: Anyone getting the error "The app domain ... was unloaded due to memory pressure and could not be found"

George_Thompson — Thu, 06 Oct 2016 14:43:29 GMT

Hi acmadison and tdowd,

As for the supported version of SQL Server 2014, support starts at the base version of 2014. Just cause no service packs are listed does not mean that they are not supported.

Non-certification of an environment does not necessarily mean it is not supported. That environment is supported if it meets or exceeds the base build environment and that environment is known to not fail. Environments that are known to not work are usually documented on the product support page as soon as that information is available.

Supported Environment Policy

So patching to the latest update is supported unless otherwise noted.

Hope this helps clear up the supported policy.

Re: Anyone getting the error "The app domain ... was unloaded due to memory pressure and could not be found"

TomDowd — Thu, 06 Oct 2016 14:56:56 GMT

Thank you!

Re: Anyone getting the error "The app domain ... was unloaded due to memory pressure and could not be found"

AaronCohen — Tue, 11 Oct 2016 19:00:14 GMT

Hey George

So as of today (10/11/2016) the supported RDBMS page says this:

So are these the "base builds" referred to in the policy?

I would surmise then that loading SQL 2012 SP1 is the "supported" "base build" of the software and that

loading pre SP1 would be problematic which is exactly what seemed to be the issue we were experiencing.

When my problem began the requirements page did not include SP1, leading myself to believe I should not be loading up SP1 or SP2. (even though that was the solution to the problem)

In other words, we should look at the Reqs. page as the lowest level and anything above it is OK to install?

So if MS put out SP3 tomorrow it would be good to load from ESRI's perspective?

I always used this page as the ceiling and its seems now it is the floor for installed version determination.

Am I understanding correctly?

BTW - thanks for engaging on the topic.

Re: Anyone getting the error "The app domain ... was unloaded due to memory pressure and could not be found"

George_Thompson — Tue, 11 Oct 2016 19:14:00 GMT

Hi Aaron,

Yes, based on your description I would say you are correct. As long as the SQL server version (build) matches what is listed (as the minium or "base build") you should be good. I do know that changes to that page are made when warranted for a specific RDBMS.

I always ran the following SQL Server query:

select @@version

This would give me the full build information and then compared it to this site for the "English" translation (i.e 11.0.3000.0 = SQL Server 2012 SP1)

Microsoft SQL Server Version List or the MS page: https://support.microsoft.com/en-us/kb/321185

Hope this helps and I am glad to help clear up any confusion on this subject as I know it can be confusing.

Re: Anyone getting the error "The app domain ... was unloaded due to memory pressure and could not be found"

AaronCohen — Tue, 11 Oct 2016 19:21:52 GMT

Mind blowing.

I have operated for years under the belief not to exceed the versions listed because they were not "supported."

You know what would help. Presenting the info like you do on the OS page with a Min/Max format.

Then no grey area. !?

Re: Anyone getting the error "The app domain ... was unloaded due to memory pressure and could not be found"

George_Thompson — Wed, 12 Oct 2016 11:30:05 GMT

I see where you are coming from, but we list the "base" supported version and anticipate that all the updates after that version work as well. So as long as you are at the "base" version you should be good in terms of support.

It would be almost impossible for any company to test their software against all the versions/updates for other RDBMS's let alone other O/S's that are supported.

I am glad that I was able to clear up some confusion.

Re: Anyone getting the error "The app domain ... was unloaded due to memory pressure and could not be found"

baohuachu3 — Mon, 27 Nov 2017 08:38:23 GMT

Hi all,

In my replica I try to let the data in one replica smaller, that means select fewer layers in one replica and then the problem may not appear.