Database Connection Error

Post Reply
mikewaterford
Observer
Observer
Posts: 17
Joined: Tue Sep 26, 2017 7:52 pm
Station model: Davis Vantage Vue
Software: weather Display

Database Connection Error

Post by mikewaterford » Mon Mar 05, 2018 10:27 am

I currently have no connection to the database and am getting this error

Error: Unable to connect to MySQL.
Debugging error number: 1040
Debugging error: Too many connections

I have had this problem before and a reset of the database fixes the issue but i have to contact the host every time it happens which can be a pain.
Has anyone else had this issue and if so how was it resolved??

Regards

User avatar
Fraggboy
Forecaster
Forecaster
Posts: 193
Joined: Wed Sep 27, 2017 2:45 pm
Location: Sunny California
Station model: Bloomsky II + Storm
Software: Bloomsky
Contact:

Re: Database Connection Error

Post by Fraggboy » Mon Mar 05, 2018 7:12 pm

The default number of connections is 151. You need to have your hosting company add (Or yourself) this variable: max_connections+1


mysqld actually permits max_connections+1 clients to connect. The extra connection is reserved for use by accounts that have the SUPER privilege. By granting the SUPER privilege to administrators and not to normal users (who should not need it), an administrator who also has the PROCESS privilege can connect to the server and use SHOW PROCESSLIST to diagnose problems even if the maximum number of unprivileged clients are connected.

Source: https://dev.mysql.com/doc/refman/5.5/en ... tions.html
Image

mikewaterford
Observer
Observer
Posts: 17
Joined: Tue Sep 26, 2017 7:52 pm
Station model: Davis Vantage Vue
Software: weather Display

Re: Database Connection Error

Post by mikewaterford » Tue Mar 06, 2018 7:57 pm

Thanks for the info, i sent the relevant information to my host

Post Reply