Gaps in all cacti's graphs

[Nadou21]

Hi all,

After adding about 900 devices to cacti, I notices bigs on all the graphs of those devices:


From the logs I keep getting those messages:
2021.06.28 14:37:14 - POLLER: Poller[Main Poller] Maximum runtime of 58 seconds exceeded. Exiting.

From the stats you can see that I have 6 processes and 60 threads, which was working fine before.
2021.06.28 14:35:27 - SYSTEM STATS: Time:85.7673 Method:spine Processes:6 Threads:60 Hosts:947 HostsPerProcess:158 DataSources:25198 RRDsProcessed:12042

Also I get another error messages:


After seeing another issues in the forum, I found that this type of errors is due to the max number of connections of mysql server.
well I Found that I have currently 800 used connections and 21000 max connections. So I don't see where this error coming from.

Can someone help me how to solve this. I Think maybe my spine is not well configured for this amount of graphs.

Here's the cnfiguration:

Code: Select all

cacti-spine/bin # ./spine -R -S -V 5
DEBUG: The log_destination variable is 4 (STDOUT)
DEBUG: The path_php variable is /usr/bin/php
DEBUG: The availability_method variable is 1
DEBUG: The ping_recovery_count variable is 3
DEBUG: The ping_failure_count variable is 2
DEBUG: The ping_method variable is 3
DEBUG: The ping_retries variable is 3
DEBUG: The ping_timeout variable is 400
DEBUG: The snmp_retries variable is 3
DEBUG: The log_perror variable is 1
DEBUG: The log_pwarn variable is 1
DEBUG: The boost_redirect variable is 0
DEBUG: The boost_rrd_update_enable variable is 0
DEBUG: The log_pstats variable is 1
DEBUG: The threads variable is 60
DEBUG: The polling interval is 60 seconds
DEBUG: The number of concurrent processes is 12
DEBUG: The script timeout is 120
DEBUG: The selective_device_debug variable is
DEBUG: The spine_log_level variable is 2
DEBUG: The number of php script servers to run is 6
DEBUG: StartDevice='-1', EndDevice='-1', TotalPHPScripts='1
DEBUG: The PHP Script Server is Required
DEBUG: The Maximum SNMP OID Get Size is 50

[cigamit]

max_user_connections is a different variable than max_connections. I would double check that one also.

[Nadou21]

max_user_connections is a different variable than max_connections. I would double check that one also.

Thank's for the reply. Indeed that was the source of the problem, in fact :
max_connections: defines the limit of all the connections to the server
max_user_connections: defines the limit of connection per login.

And because of the devices attempt to connect at the same time that might have caused the problem so I changed this parameter to 2000 which solved the issue.