This error is returned by the MySQL server since you are running out of connections. The reason would be that you are not closing the connections that you have open.
You have to change ‘max_connections’ to increase total permitted connections.
Please note, once the respective value is passed to the ‘max_connections’ variable, ensure that the server is restarted for the changes to come into effect.
Thanks – through that might be the problem, it is unrealistic; it is already a big site, so the max_concurrent connections is large anyway.
The main thrust of the question though, is how to force a query to stoop – hitting the ‘stop query’ just returned the error and I had no way out of things.
Can you please check the currently open connections. You may execute the below statement to find the currently opened connections,
“SHOW STATUS WHERE `variable_name` = ‘Threads_connected’;” and you may also execute “SHOW PROCESSLIST” to verify the number of currently opened connections.