0

My last build failed with this error message:

       Executing script cache:clear [KO]
        [KO]
       Script cache:clear returned with error code 255
       !!  
       !!  In ExceptionConverter.php line 117:
       !!                                                                                 
       !!    An exception occurred in the driver: SQLSTATE[HY000] [1226] User 'xxxxxxxx  
       !!    xxxxx' has exceeded the 'max_user_connections' resource (current value: 15)  

And when I try to connect to my database via CLI,

mysql -u xxxxxxxxxx -pxxxxxxxx -h us-cdbr-east-xxx.cleardb.com

I am getting this error message:

ERROR 1040 (HY000): Too many connections

The problem is that the dashboard of the database says : No connections are currently established to the database. Therefore, I guess that a hidden process might be running.

Do you have an idea on how to fix this issue? I have already restarted all the dynos but it didn't have any effect. Is restarting the dynos and restarting the app the same? I also read that I should stop background workers, but I have no clue on how to do this...

eric
  • 11
  • 2
  • The problem apparently solved itself. After one night, I was able to connect to the database and then do a new build. The site was still unavailable for more than 15 hours, which is very annoying. I found some information on how to get out of this situation with Postgres: `heroku ps:kill` but I didn't find anything to do the same with ClearDB. Feel free to leave me a comment if you have a clue. – eric Dec 14 '22 at 22:11

0 Answers0