Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Resque Mysql2::Error: User has exceeded the 'max_user_connections' resource (current value: 10)

I am running Resque on Heroku, and my database is ClearDB. I am getting this error:

"Mysql2::Error: User 'bdb2aedbee2c38' has exceeded the 'max_user_connections' resource (current value: 10): SHOW FULL FIELDS FROM projects"

That error is coming from my Resque admin of my Heroku app.

How can I figure out how many connections Resque is making to ClearDB?

How can I tell ClearDB to either allow more connections, or tell Resque to create less?

Does "current value: 10" refer to how many connections ClearDB is allowing, or is this how many current connections Resque is trying to make?

Thanks!

like image 390
botbot Avatar asked Mar 22 '23 23:03

botbot


1 Answers

Your application server dynos or Resque workers are consuming more connections than your database plan provides.

You have two options:

  • Scale up your database by upgrading to a higher ClearDB plan (http://dashboard.heroku.com)
  • Scale down your application by reducing the number of dynos/workers (heroku ps:scale command)

The first link when I googled your addons links to the page describing the service and pricing tiers. You are on the free, 10 connection tier.

https://addons.heroku.com/cleardb

like image 123
Winfield Avatar answered Mar 26 '23 04:03

Winfield