.NET Framework execution was aborted. Another query caused the AppDomain db.dbo[runtime].4 to be unloaded

Question

I have a SQL CLR Function (written in c#.net) that I'm trying to debug. I attach visual studio to the sqlserver process and begin stepping through, but it keeps crashing and ending with the following error message:

.NET Framework execution was aborted. Another query caused the AppDomain DatabaseName.dbo[runtime].4 to be unloaded.

(The number after DatabaseName.dbo[runtime] changes - increments on each crash)

It sometimes even crashes the sql server process & stops the service.

The function works absolutely fine with no errors when I'm not debugging. This only happens when I'm debugging.

Does anyone have any idea what could be causing this?

Thanks

Also it's SQL Server 2008 and Visual Studo 2008 I'm working with. — tuseau
– tuseau, Commented Sep 14, 2011 at 15:04
Could it be a different process calling your CLR SP? SQL might have to terminate your debugging process to run the SP again. — Chuck
– Chuck, Commented Jul 22, 2015 at 17:37

milivojeviCH · Accepted Answer · 2020-08-28 04:38:39Z

0

I had exactly the same message today - for me, the reason was the change in the 'max server memory' configuration while the SSIS load was running.

What might have helped here is an extract from the SQL Server Log:

answered Aug 28, 2020 at 4:38

milivojeviCH

1,62815 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

.NET Framework execution was aborted. Another query caused the AppDomain db.dbo[runtime].4 to be unloaded

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related