| Bug #114357 | Unable to Connect to Any of the Specified MySQL Hosts | ||
|---|---|---|---|
| Submitted: | 14 Mar 2024 17:38 | Modified: | 18 Jun 13:59 |
| Reporter: | Mahesnwar Deveraj | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | Connector / NET | Severity: | S2 (Serious) |
| Version: | 8.3.0 | OS: | Windows |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | Opening Multiple Cuncurrent Connections, Unable to Connect to Any of the Specified MySQL Hosts | ||
[15 Mar 2024 8:16]
Mahesnwar Deveraj
Am adding the simple code to duplicate the issue
Public Shared Function pustest(ByVal busid As Integer) As String
Dim d As New pustest_Delegate(AddressOf pustest1)
Dim R As IAsyncResult = Nothing
R = d.BeginInvoke(busid, Nothing, Nothing)
End Function
Private Delegate Sub pustest_Delegate(ByVal busid As Integer)
Private Shared Function pustest1(ByVal busid As Integer) As String
Dim con As MySqlConnection
Dim str As String = "insert into tblins(bid, dte) values('" & busid & "','" & dbnow(0).DB_yyyyMMdd_HHmmss & "')"
con = dcon1(myConfig.DB)
dbcommand(str, con)
Dim sd As String = busid
con.Close()
End Function
Calling Part:
Dim ik As Integer = 1
While ik < 15000
pustest(ik)
Response.Write("<br>" & dbnow(0).DS_ddMMMyyyy_hhmm_tt & " - " & ik & " - " & sval & "<br>")
ik = ik + 1
End While
[25 Mar 2024 12:54]
MySQL Verification Team
Hello Mahesnwar Deveraj, Thank you for the bug report. Verified as described. Regards, Ashwini Patil
[25 Mar 2024 17:13]
Mahesnwar Deveraj
So its a bug?. Any idea when this will be fixed?
[18 Jun 13:59]
Mahesnwar Deveraj
Hi, Is this issue fixed in any latest version?
Description: Hi, I have been using MYSQL NET connector 1.7 for a long time, Recently i upgraded my project with MYSQL 8.0.35 and connector with MYSQL 8.3.0. Every thing works fine except opening multiple connections in threaded environment gives "Unable to Connect to Any of the Specified MySQL Hosts" after 12 threads. The flow was simple . Open the connection Process Close the connection The above code will be called in loop for multiple time and in multi threading environment. The same code works very well in old connector with out a single issue. The only fix was to set pooling = True , But when using pooling also i can see all the connections where waiting to open in a queue and then perform the operation one by one. How to repeat: Use MYSQL NET 8.0 or above to connect , Do some simple DB operations in a function and call it in Multi threading loop. Then you will get "Unable to Connect to Any of the Specified MySQL Hosts"