MYSQL Too Many Connections error

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

Post Reply
jolramospr
Posts: 32
Joined: Mon Aug 07, 2006 2:32 pm
Location: PR
Contact:

MYSQL Too Many Connections error

Post by jolramospr »

Hello,

I have CactiEZ installed and graphs stops getting data and I see the following messages at the cacti.log file:

[root@cacti etc]# 04/10/2007 09:30:09 AM - CACTID: Poller[0] MYSQL: Connection Failed: Too many connections
04/10/2007 09:30:09 AM - CACTID: Poller[0] FATAL: Cactid Fork process encountered a FATAL error and must exit
04/10/2007 09:30:09 AM - CACTID: Poller[0] MYSQL: Connection Failed: Too many connections
04/10/2007 09:30:09 AM - CACTID: Poller[0] FATAL: Cactid Fork process encountered a FATAL error and must exit
04/10/2007 09:30:34 AM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
04/10/2007 09:30:35 AM - SYSTEM STATS: Time:33.5130 Method:cactid Processes:1 Threads:200 Hosts:95 HostsPerProcess:95 DataS :ources:819 RRDsProcessed:19

:( :o
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:

Post by rony »

Too many threads!!!!

Turn the number of threads down to something more manageable, like 10.
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
jolramospr
Posts: 32
Joined: Mon Aug 07, 2006 2:32 pm
Location: PR
Contact:

Post by jolramospr »

Thanks,

It stops to receive the too many connections error, but instead I see the following:

[root@cacti etc]# 04/10/2007 09:48:08 AM - CMDPHP: Poller[0] Host[131] NOTICE: HOST EVENT: Host Returned from DOWN State:
04/10/2007 09:48:14 AM - CACTID: Poller[0] Host[91] DS[644] WARNING: Result from SNMP not valid. Partial Result: ...
04/10/2007 09:48:14 AM - CACTID: Poller[0] Host[91] DS[644] WARNING: Result from SNMP not valid. Partial Result: ...
04/10/2007 09:49:15 AM - CACTID: Poller[0] Host[132] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP
04/10/2007 09:49:54 AM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
04/10/2007 09:49:54 AM - SYSTEM STATS: Time:292.9889 Method:cactid Processes:1 Threads:10 Hosts:95 HostsPerProcess:95 DataSources:819 RRDsProcessed:388
04/10/2007 09:49:54 AM - WEATHERMAP: Poller[0] Unrecognised config on line 1: <?php
04/10/2007 09:49:54 AM - WEATHERMAP: Poller[0] Unrecognised config on line 3: header("Location:../index.php");
04/10/2007 09:49:54 AM - WEATHERMAP: Poller[0] Unrecognised config on line 5: ?>
04/10/2007 09:49:56 AM - CACTID: Poller[0] ERROR: Cactid Timed Out While Processing Hosts Internal
04/10/2007 09:49:57 AM - THOLD: Poller[0] Checking Thresholds
04/10/2007 09:50:41 AM - CACTID: Poller[0] Host[31] DS[299] WARNING: Result from SNMP not valid. Partial Result: ...
04/10/2007 09:50:41 AM - CACTID: Poller[0] Host[31] DS[299] WARNING: Result from SNMP not valid. Partial Result: ...
04/10/2007 09:50:41 AM - CACTID: Poller[0] Host[26] DS[253] WARNING: Result from SNMP not valid. Partial Result: ...
04/10/2007 09:50:41 AM - CACTID: Poller[0] Host[26] DS[253] WARNING: Result from SNMP not valid. Partial Result: ...
04/10/2007 09:51:10 AM - CACTID: Poller[0] Host[16] DS[947] WARNING: Result from SNMP not valid. Partial Result: ...
04/10/2007 09:51:10 AM - CACTID: Poller[0] Host[16] DS[949] WARNING: Result from SNMP not valid. Partial Result: ...
04/10/2007 09:51:10 AM - CACTID: Poller[0] Host[16] DS[948] WARNING: Result from SNMP not valid. Partial Result: ...
04/10/2007 09:51:10 AM - CACTID: Poller[0] Host[16] DS[947] WARNING: Result from SNMP not valid. Partial Result: ...
04/10/2007 09:51:10 AM - CACTID: Poller[0] Host[16] DS[949] WARNING: Result from SNMP not valid. Partial Result: ...
04/10/2007 09:51:10 AM - CACTID: Poller[0] Host[16] DS[948] WARNING: Result from SNMP not valid. Partial Result: ...
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests