Bug #104664 Have enough connection but still getting Host 'x.x.x.x' blocked because of many
Submitted: 19 Aug 2021 8:21 Modified: 24 Aug 2021 11:54
Reporter: Kamran Shahid Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:8.0.21 OS:Linux
Assigned to: CPU Architecture:Any

[19 Aug 2021 8:21] Kamran Shahid
Description:
I am using .net core 3.1 with mysql connector 8.0.21. In mysql i have max_connection around 3000 and max_user_connection as 0 (unlimited)

In my connection pools setting in various application my total connection reserved are around 2800. Still sometime i am getting this above error occasionally. Any idea what could be the problem.

In my application there are two implementation for db access. one is dapper and other is old vanilla ado.net implementation

How to repeat:
as given in description
[24 Aug 2021 11:29] Kamran Shahid
It is found out by third party security application (nagios) telnetiing

https://stackoverflow.com/questions/68836869/have-enough-connection-but-still-getting-host...

Please close this bug
[24 Aug 2021 11:54] MySQL Verification Team
Hello Kamran Shahid,

Thank you for confirming.
Closing the report for now.

Regards,
Ashwini Patil