Open TungKJ opened 2 years ago
@TungKJ we will look into this and will get back to you soon.
There was a PR opened yesterday #1766 that may address this issue. The build from that PR can be found here . Could you try it out and see if this fixes the issue?
using the attached package, the app still hangs
Thanks for checking @TungKJ. We'll have to further investigate the deadlock issue.
Describe the bug
SqlCommand ExecuteReaderAsync hangs when Column Encryption is enabled and the worker usage of Azure DB is 100% In the EventSource trace, there is an SqlError, but the app doesn't doesn't receive the exception. The error message in the trace is "SqlError.ctor | ERR | Info Number 10928, Error State 1, Error Class 20, Error Message 'Resource ID : 1. The request limit for the database is 60 and has been reached. See 'https://docs.microsoft.com/azure/azure-sql/database/resource-limits-logical-server' for assistance.', Procedure '', Line Number 1"
If using ExecuteReader instead of ExecuteReaderAsync, Column Encryption disabled, or the stored procedure without any parameters, the app works fine.
To reproduce
stored procedure
test code: TestProject.zip
EventSource trace
Expected behavior
Sql Command should receive an exception and should not hang
Further technical details
Microsoft.Data.SqlClient version: 5.0.0 .NET target: Core 6.0 SQL Server version: Azure DB Operating system: Windows
Additional context