Forums

exceeded the 'max_user_connections' resource

I'm connecting to a MySQL database in pythonanywhere via MySQL Workbench and am getting exceeded the 'max_user_connections' resource error.

When I log into pythonanywhere website and look at the dashboard and console list, there aren't any consoles running and no processes listed for the database and CPU is at 0%, yet I keep running into this error.

Even though there are no other consoles running, if I try to create a new MySQL console on the website, I get the same error.

I haven't encountered this before, is this something systemic with pythonanywhere right now or is there somewhere else I can look to kill existing connections?

Thanks!

On the "Consoles" page, the "Running processes" table only shows running console processes (and, for legacy reasons, those relating to Jupyter/IPython notebooks). Code that is running as part of scheduled/always-on tasks has a separate process list, on the "Tasks" page, and (unfortunately) there's no listing for website processes.

Right now I can see only three connections to your MySQL database instance; two from consoles and one from a scheduled task. My guess is that some of the rogue ones that were causing problems earlier have timed out. Unfortunately that means I can't say where those were coming from, but if it happens again, perhaps you can look at the task processes and see if there's something running there that should not be?

delete