Urgent | RRD Files are not updating

[abhisekp34]

php -q poller_boost.php --force

this is giving too much ERROR.. as it depends on other php files.

So could you please suggest, how to update full cacti folder from branch 1.2.x from github.

Please help to suggest. as I am very new to Cacti.

[abhisekp34]

does below command required to run on crond Cacti 1.2.18 release.

*/5 * * * * cactiuser /usr/bin/php /var/www/html/cacti/poller.php > /dev/null 2>&1

[abhisekp34]

Getting below ERRORs cacti_stderr.log file.

Any idea .. how to Resolve ?


FATAL: Connection Failed, Error:'1040', Message:'Too many connections'
Database: Connection Failed: Error:'1040', Message:'Too many connections'
Database: Connection Failed: Error:'1040', Message:'Too many connections'
Database: Connection Failed: Error:'1040', Message:'Too many connections'
FATAL: Connection Failed, Error:'1040', Message:'Too many connections'
Database: Connection Failed: Error:'1040', Message:'Too many connections'
Database: Connection Failed: Error:'1040', Message:'Too many connections'
Database: Connection Failed: Error:'1040', Message:'Too many connections'
FATAL: Connection Failed, Error:'1040', Message:'Too many connections'
Database: Connection Failed: Error:'1040', Message:'Too many connections'
Database: Connection Failed: Error:'1040', Message:'Too many connections'
FATAL: Connection Failed, Error:'1040', Message:'Too many connections'
Database: Connection Failed: Error:'1040', Message:'Too many connections'
Database: Connection Failed: Error:'1040', Message:'Too many connections'
FATAL: Connection Failed, Error:'1040', Message:'Too many connections'
Database: Connection Failed: Error:'1040', Message:'Too many connections'
Database: Connection Failed: Error:'1040', Message:'Too many connections'
FATAL: Connection Failed, Error:'1040', Message:'Too many connections'
Database: Connection Failed: Error:'1040', Message:'Too many connections'
Database: Connection Failed: Error:'1040', Message:'Too many connections'
Database: Connection Failed: Error:'1040', Message:'Too many connections'
FATAL: Connection Failed, Error:'1040', Message:'Too many connections'
Database: Connection Failed: Error:'1040', Message:'Too many connections'
Database: Connection Failed: Error:'1040', Message:'Too many connections'
FATAL: Connection Failed, Error:'1040', Message:'Too many connections'
Database: Connection Failed: Error:'1040', Message:'Too many connections'
Database: Connection Failed: Error:'1040', Message:'Too many connections'
FATAL: Connection Failed, Error:'1040', Message:'Too many connections'

[cigamit]

After the crash, did you reboot your server? You may have some poller processes stuck that are still trying to access mysql. Otherwise you are going to need to google how to increase the amount of mysql connections.

[abhisekp34]

Is it required to Reboot Server if any DB crash happened ?

Will Reboot impact functionality of Cacti ?

[Osiris]

Rebooting is the last thing you want to do. Only time you should ever reboot would be for bios updates or mandatory kernel patches when they can't be made live. I've known cacti servers to stay up years.

[cigamit]

In normal cases rebooting is the last thing you want to do, but when you are dealing is someone who doesn't know how to debug linux processes well (for instance if there are lots of stuck poller processes because mysql died) then it can help clears things up.

[Osiris]

Too many connections. Increase the max_connections variable and restart MySQL. Remember only like 2 processes and 10-20 threads even with thousands of hosts.