Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By AshleyF73 on
Hi,
I was working on my site overnight which was fine, but this morning when I try to access it I am getting the following error messages stopping the site from running.
PDOException: SQLSTATE[HY000] [1040] Too many connections in lock_may_be_available() (line 165 of /home/sites/domain/path/includes/lock.inc).
Aargh, please help.
Thanks,
Ashley
Comments
Weird, the moment I posted
Weird, the moment I posted this it came back to life. As anybody experienced this before?
just had it now
Yeah i just had the same thing happen. hopefully it moves on soon. I think its because something wasn't loading since my internet is crap and i kept reloading the page so it overloaded. i guess it will just pass.
this is a mysql error - it
this is a mysql error - it means that your site has breached the max allowed consecutive mysql connections.
If you are on a shared hots it could be global setting - if you have access you can up it.
http://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html
[mysqld]
set-variable=max_connections=250
It could be script that is opening connections and not closing them afterwards. Hard to say.