Error: User已超过“max_user_connections”资源(当前值:10)

时间:2022-10-02 20:19:54

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

我在Heroku上运行Resque,我的数据库是ClearDB。我得到了这个错误:

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

“Mysql2::错误:用户的bdb2aedbee2c38”已经超过了“max_user_connections”的资源(当前值:10):显示来自项目的完整字段。

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

这个错误来自我的Heroku应用的管理员Resque。

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

我怎么知道Resque有多少连接到ClearDB?

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

我如何告诉ClearDB允许更多的连接,或者告诉Resque创建更少的连接?

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

“当前值:10”是指ClearDB允许的连接数量,还是这是Resque尝试建立的当前连接数量?

Thanks!

谢谢!

1 个解决方案

#1


4  

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

您的应用服务器dynos或Resque工作人员消耗的连接比您的数据库计划提供的要多。

You have two options:

你有两个选择:

  • Scale up your database by upgrading to a higher ClearDB plan (http://dashboard.heroku.com)
  • 通过升级到更高的ClearDB计划来扩展数据库(http://dashboard.heroku.com)
  • Scale down your application by reducing the number of dynos/workers (heroku ps:scale command)
  • 通过减少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.

第一个链接,当我谷歌你的插件链接到描述服务和定价层的页面。你在免费的,10连接层。

https://addons.heroku.com/cleardb

https://addons.heroku.com/cleardb

#1


4  

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

您的应用服务器dynos或Resque工作人员消耗的连接比您的数据库计划提供的要多。

You have two options:

你有两个选择:

  • Scale up your database by upgrading to a higher ClearDB plan (http://dashboard.heroku.com)
  • 通过升级到更高的ClearDB计划来扩展数据库(http://dashboard.heroku.com)
  • Scale down your application by reducing the number of dynos/workers (heroku ps:scale command)
  • 通过减少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.

第一个链接,当我谷歌你的插件链接到描述服务和定价层的页面。你在免费的,10连接层。

https://addons.heroku.com/cleardb

https://addons.heroku.com/cleardb