Middle Tier error question

[wjstarck]

I am getting the following error in the Middle Tier

Code: Select all

An unhandled exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in OpenDentBusiness.dll
Additional information: Host 'DESKTOP-01EAGQM' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

On methods like this:

Code: Select all

		public static DataTable RefreshCache(long anestheticRecordNum) {
			//No need to check RemotingRole; Calls GetTableRemotelyIfNeeded().
            string command = "SELECT * FROM anesthmedsgiven WHERE AnestheticRecordNum ='" + anestheticRecordNum + "'"+ " ORDER BY DoseTimeStamp DESC"; //most recent at top of list
			DataTable table=Cache.GetTableRemotelyIfNeeded(MethodBase.GetCurrentMethod(),command);
			table.TableName="AnesthMedsGiven";
			FillCache(table);
			return table;
		}

I don't think this is related to MySQL because I still get the error even after a mysqladmin flush-hosts.

This code block was written quite a few years ago. Is it wrong now?

[cmcgehee]

We see this MySQL error every so often for various offices. Our solution is to add:

max_connect_errors=999999999

to your my.ini file and restart MySQL.

[wjstarck]

I tried that, but still get the error.

[cmcgehee]

What version of MySQL are you using? If it's >= 5.6, can you run this query and show the results?
select * from performance_schema.host_cache

[wjstarck]

I was on 5.5 but just installed 5.6 and still get the error

That query returns no results

[wjstarck]

I just looked in there again after a few more tries and now I have:

Code: Select all

-<RECORDS>


-<RECORD>

<IP>115.230.124.21</IP>

<HOST/>

<HOST_VALIDATED>YES</HOST_VALIDATED>

<SUM_CONNECT_ERRORS>0</SUM_CONNECT_ERRORS>

<COUNT_HOST_BLOCKED_ERRORS>0</COUNT_HOST_BLOCKED_ERRORS>

<COUNT_NAMEINFO_TRANSIENT_ERRORS>0</COUNT_NAMEINFO_TRANSIENT_ERRORS>

<COUNT_NAMEINFO_PERMANENT_ERRORS>1</COUNT_NAMEINFO_PERMANENT_ERRORS>

<COUNT_FORMAT_ERRORS>0</COUNT_FORMAT_ERRORS>

<COUNT_ADDRINFO_TRANSIENT_ERRORS>0</COUNT_ADDRINFO_TRANSIENT_ERRORS>

<COUNT_ADDRINFO_PERMANENT_ERRORS>0</COUNT_ADDRINFO_PERMANENT_ERRORS>

<COUNT_FCRDNS_ERRORS>0</COUNT_FCRDNS_ERRORS>

<COUNT_HOST_ACL_ERRORS>1</COUNT_HOST_ACL_ERRORS>

<COUNT_NO_AUTH_PLUGIN_ERRORS>0</COUNT_NO_AUTH_PLUGIN_ERRORS>

<COUNT_AUTH_PLUGIN_ERRORS>0</COUNT_AUTH_PLUGIN_ERRORS>

<COUNT_HANDSHAKE_ERRORS>0</COUNT_HANDSHAKE_ERRORS>

<COUNT_PROXY_USER_ERRORS>0</COUNT_PROXY_USER_ERRORS>

<COUNT_PROXY_USER_ACL_ERRORS>0</COUNT_PROXY_USER_ACL_ERRORS>

<COUNT_AUTHENTICATION_ERRORS>0</COUNT_AUTHENTICATION_ERRORS>

<COUNT_SSL_ERRORS>0</COUNT_SSL_ERRORS>

<COUNT_MAX_USER_CONNECTIONS_ERRORS>0</COUNT_MAX_USER_CONNECTIONS_ERRORS>

<COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS>0</COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS>

<COUNT_DEFAULT_DATABASE_ERRORS>0</COUNT_DEFAULT_DATABASE_ERRORS>

<COUNT_INIT_CONNECT_ERRORS>0</COUNT_INIT_CONNECT_ERRORS>

<COUNT_LOCAL_ERRORS>0</COUNT_LOCAL_ERRORS>

<COUNT_UNKNOWN_ERRORS>0</COUNT_UNKNOWN_ERRORS>

<FIRST_SEEN>27/1/2020 19:34:32</FIRST_SEEN>

<LAST_SEEN>27/1/2020 19:34:32</LAST_SEEN>

<FIRST_ERROR_SEEN>27/1/2020 19:34:32</FIRST_ERROR_SEEN>

<LAST_ERROR_SEEN>27/1/2020 19:34:32</LAST_ERROR_SEEN>

</RECORD>

</RECORDS>

[cmcgehee]

Can you post the result of this query:
SHOW VARIABLES LIKE 'max_connect_errors'

[wjstarck]

That shows MaxConnectErrors set to 999999999

[cmcgehee]

I don't have any further ideas without remote connecting to your environment. I would recommend calling support next.

[wjstarck]

OK

Thanks