Microsoft.Data.SqlClient.SNI.x64.dll crashes when using multiple AppDomains in IIS Express and IIS Server

[MojoDK]

Describe the bug

In my .NetFramework 4.8 web app, I "Start Wihout Debugging" and everything works fine, bu when I rebuild the project, I get the errror below. I have to "Start Without Debugging" again, to make the website work again (and then it crashes againg when rebuilding etc).

From event viewer (sorry it is in Danish):

Program.
Application Error
Event ID 1000

Navn på program med fejl: iisexpress.exe, version: 10.0.22377.1000, tidsstempel: 0x8db0c0a2
Navn på modul med fejl: Microsoft.Data.SqlClient.SNI.x64.dll, version: 4.0.0.0, tidsstempel: 0x61953095
Undtagelseskode: 0xc0000409
Forskydning med fejl 0x000000000001c80c
Proces-id 0xff14
Programmets starttidspunkt 0x01d7e767da588b02
Programsti: C:\Program Files\IIS Express\iisexpress.exe
Modulsti: C:\Users\mora\AppData\Local\Temp\Temporary ASP.NET Files\vs\1453ae1f\938c099f\assembly\dl3\7084a998\0061005c_e1dcd701\Microsoft.Data.SqlClient.SNI.x64.dll
Rapport-id: a6347776-fe45-45b4-a202-d971b9ac10a9
Fuldt navn på program med fejl:
Relativt program-id for program med fejl:

Exception message:
None 

Stack trace:
None

To reproduce

Include a complete code listing (or project/solution) that we can run to reproduce the issue.

Partial code listings, or multiple fragments of code, will slow down our response or cause us to push the issue back to you to provide code to reproduce the issue.

I can't reproduce with a new project.

Expected behavior

Not crashing iisexpress.exe and let me build and refresh the website.

Further technical details

Microsoft.Data.SqlClient version: 4.0.0.0
.NET target: Framework 4.8
SQL Server version: Sql Server 2019
Operating system: Windows 11 Pro x64

Additional context
Add any other context about the problem here.

[JRahnama]

@MojoDK have you tried to manually copy paste the required dll and see if that works?

[MojoDK]

@JRahnama the "Microsoft.Data.SqlClient.SNI.x64.dll" is already in the bin folder - if I copy (overwrite) it with another "Microsoft.Data.SqlClient.SNI.x64.dll" file, the error is the same.

[JRahnama]

@MojoDK are you able to reproduce the issue with a simple newly created application? or can you provide a repro please?

[leonmeijer]

We're having the same issue. For us it happens in an application with multiple app domains. When the second app domain loads and begins doing a database function, the application crashes hard with no stack trace in Visual Studio. We have the same error codes in Event Viewer. Downgrading to v3 resolved it for now.

[jaymonson]

We are having the same issue. It is intermittent but at times can occur frequently. When it occurs we get the following crashstack:

Faulting application name: w3wp.exe, version: 10.0.17763.1, time stamp: 0xcfdb13d8
Faulting module name: Microsoft.Data.SqlClient.SNI.x64.dll, version: 4.0.0.0, time stamp: 0x61953095
Exception code: 0xc0000409
Fault offset: 0x000000000001c80c
Faulting process id: 0x228c
Faulting application start time: 0x01d7f3989332762e
Faulting application path: c:\windows\system32\inetsrv\w3wp.exe
Faulting module path: C:\inetpub\wwwroot\C2SWeb\C2SWebAdministrator\bin\Microsoft.Data.SqlClient.SNI.x64.dll
Report Id: 3b4dba21-3703-43ee-9ad7-fdd3c0b15863
Faulting package full name:
Faulting package-relative application ID:

I have not yet experienced the crash while in Visual Studio with debugger attached. I have seen the
crash on a Server 2019 with SQL 2019 and also on a Server 2019 with SQL 2017.

[JRahnama]

@leonmeijer and @jaymonson are you on Windows 11 as well and the issue does not happen when downgrading to Microsoft.Data.SqlClient v3?

[jaymonson]

Hi, I have not tried it on Windows 11. I have seen it on 2 different Server 2019 systems. I have not yet tried the downgrade to v3 as that would not be an option for us as we try to stay with the latest/greatest/current versions as much as possible. But I can try the downgrade when I get a chance. Thanks, Jay From: Javad ***@***.***> Sent: Tuesday, January 11, 2022 11:40 AM To: dotnet/SqlClient ***@***.***> Cc: Jay Monson ***@***.***>; Mention ***@***.***> Subject: Re: [dotnet/SqlClient] Microsoft.Data.SqlClient.SNI.x64.dll crashes iisexpress (Issue #1418) [External email: Use caution! Do not open attachments or click on links from unknown senders or unexpected emails.] @leonmeijer<https://protect-us.mimecast.com/s/A8_qCADAYoIZZ0zyC8JsII?domain=github.com> and @jaymonson<https://protect-us.mimecast.com/s/TdOzCBBQYpuDDqOQCNwC37?domain=github.com> are you on Windows 11 as well and the issue does not happen when downgrading to Microsoft.Data.SqlClient v3? — Reply to this email directly, view it on GitHub<https://protect-us.mimecast.com/s/GxVlCzp9w5IGGDAlu4ZO0k?domain=github.com>, or unsubscribe<https://protect-us.mimecast.com/s/KrkNCDkPVrfoopk2cZ5AoD?domain=github.com>. Triage notifications on the go with GitHub Mobile for iOS<https://protect-us.mimecast.com/s/n8-nCERGVvullyNrcZYkBb?domain=apps.apple.com> or Android<https://protect-us.mimecast.com/s/GJy0CG6gVxsBBnQxu0Mf_g?domain=play.google.com>. You are receiving this because you were mentioned.Message ID: ***@***.***>

[tdhintz]

The @jaymonson issue occurs on a redirect. It didn't happen on the latest System.Data.SqlClient, but it does on Microsoft.Data.SqlClient. It feels like it is losing some sort of thread context.

[leonmeijer]

I have the issue with v4 on Server 2016, 2022, Windows 10 and 11. Tried with SQL Server 2016. Happens with and without Visual Studio. Does not happen with v3 Outlook voor Android<https://aka.ms/AAb9ysg> downloaden

…

________________________________ From: Hintz ***@***.***> Sent: Tuesday, January 11, 2022 7:26:58 PM To: dotnet/SqlClient ***@***.***> Cc: Leon Meijer ***@***.***>; Mention ***@***.***> Subject: Re: [dotnet/SqlClient] Microsoft.Data.SqlClient.SNI.x64.dll crashes iisexpress (Issue #1418) The @jaymonson<https://github.com/jaymonson> issue occurs on a redirect. It didn't happen on the latest System.Data.SqlClient, but it does on Microsoft.Data.SqlClient. It feels like it is losing some sort of thread context. — Reply to this email directly, view it on GitHub<#1418 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AA6N3SY3BYFYWDBRJWOURYTUVRY7FANCNFSM5JG3OPHQ>. Triage notifications on the go with GitHub Mobile for iOS<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. You are receiving this because you were mentioned.Message ID: ***@***.***>

[tdhintz]

For the record, our test environments are typically Encryption true, certificates trusted.

[waf]

Also seeing this, on Windows 10, .NET Framework with Encrypt=False. It's not just IISExpress; it's also crashing w3wp.exe (as @jaymonson's earlier log showed).

Happening for all members of our development team. When debugging from Visual Studio the first time after building it crashes; after crashing once it then starts OK on subsequent debug launches until the next build.

Event Log Entry

Faulting application name: w3wp.exe, version: 10.0.19041.1, time stamp: 0x58c67bf3
Faulting module name: Microsoft.Data.SqlClient.SNI.x64.dll, version: 4.0.0.0, time stamp: 0x61953095
Exception code: 0xc0000409
Fault offset: 0x000000000001c80c
Faulting process id: 0x6f7c
Faulting application start time: 0x01d8091b05a21bbc
Faulting application path: c:\windows\system32\inetsrv\w3wp.exe
Faulting module path: C:\Projects\web\lib\Microsoft.Data.SqlClient.SNI.x64.dll
Report Id: 6e33d06d-be0e-4496-b5dd-f82c5285eb01
Faulting package full name: 
Faulting package-relative application ID: 

[agclark27]

We're observing the same crashes of w3wp.exe with the same exception code and fault offset in Microsoft.Data.SqlClient.SNI.x64.dll. We checked all of our Splunk logs, and the issue wasn't present when we were on 3.x, but it immediately began appearing with 4.0.0 and remains present in 4.0.1.

[JRahnama]

@waf and @agclark27 is it happening with a fresh build application even? Can you make a minimal repro with the issue happening and send it to us?