CereusReporting PHP crash

General discussion about Plugins for Cacti

Moderators: Moderators, Developers

Post Reply
Author
Message
Atreides
Cacti User
Posts: 151
Joined: Mon May 31, 2010 9:26 am

CereusReporting PHP crash

#1 Post by Atreides » Sat Nov 02, 2019 7:58 am

Hello,
I'm trying to install CereusReporting plugin and it seems that is crashing PHP badly :
Cacti Version 1.3.0 - Dev 79f29cd @ 2019-09-28
CereusReporting : 3.01.32

2019/11/02 14:40:09 - SPINE: Poller[1] PID[12754] FATAL: Connection Failed, Error:'1040', Message:'Too many connections' (Spine thread)
2019/11/02 14:40:10 - PHPSVR ERROR: Input Expected, Script Server Terminating
2019/11/02 14:40:10 - PHPSVR ERROR: Input Expected, Script Server Terminating
2019/11/02 14:40:10 - PHPSVR ERROR: Input Expected, Script Server Terminating
2019/11/02 14:40:10 - PHPSVR ERROR: Input Expected, Script Server Terminating
2019/11/02 14:40:10 - PHPSVR ERROR: Input Expected, Script Server Terminating
2019/11/02 14:45:00 - POLLER: Poller[1] Maximum runtime of 298 seconds exceeded. Exiting.
2019/11/02 14:45:00 - SYSTEM WARNING: Primary Admin account notifications disabled! Unable to send administrative Email.
2019/11/02 14:45:00 - SNMPAGENT WARNING: No notification receivers configured for event: cactiNotifyPollerRuntimeExceeding (CACTI-MIB), severity: high
2019/11/02 14:45:00 - SYSTEM STATS: Time:298.6635 Method:spine Processes:5 Threads:10 Hosts:237 HostsPerProcess:48 DataSources:4572 RRDsProcessed:0
2019/11/02 14:45:02 - SYSTEM THOLD STATS: Time:0.6538 Tholds:163 TotalDevices:237 DownDevices:7 NewDownDevices:0
2019/11/02 14:45:02 - POLLER: Poller[1] WARNING: There are 1 processes detected as overrunning a polling cycle, please investigate
2019/11/02 14:45:02 - SYSTEM WARNING: Primary Admin account notifications disabled! Unable to send administrative Email.
2019/11/02 14:45:02 - POLLER: Poller[1] WARNING: Poller Output Table not Empty. Issues: 4, DS[2646, 2650, 3214, 3365]
2019/11/02 14:45:02 - SYSTEM WARNING: Primary Admin account notifications disabled! Unable to send administrative Email.
2019/11/02 14:45:02 - SYSTEM MONITOR STATS: Time:0.0185 Reboots:0 DownDevices:0 Notifications:0 Purges:1
2019/11/02 14:45:02 - SYSTEM WEBSEER STATS: Total Time:0.047, Service Checks:1, Servers:0
2019/11/02 14:45:03 - SYSTEM SYSLOG STATS:Time:0.15 Deletes:0 Incoming:0 Removes:0 XFers:2 Alerts:3 Alarms:0 Reports:0
2019/11/02 14:45:09 - SPINE: Poller[1] PID[18166] FATAL: Connection Failed, Error:'1040', Message:'Too many connections' (Spine thread)
2019/11/02 14:45:09 - SPINE: Poller[1] PID[18166] FATAL: Connection Failed, Error:'1040', Message:'Too many connections' (Spine thread)
2019/11/02 14:45:09 - PHPSVR ERROR: Input Expected, Script Server Terminating
2019/11/02 14:45:09 - PHPSVR ERROR: Input Expected, Script Server Terminating
2019/11/02 14:45:09 - PHPSVR ERROR: Input Expected, Script Server Terminating
2019/11/02 14:45:09 - PHPSVR ERROR: Input Expected, Script Server Terminating
2019/11/02 14:45:09 - PHPSVR ERROR: Input Expected, Script Server Terminating

Atreides
Cacti User
Posts: 151
Joined: Mon May 31, 2010 9:26 am

Re: CereusReporting PHP crash

#2 Post by Atreides » Sat Nov 02, 2019 1:04 pm

Error post.

netniV
Cacti Guru User
Posts: 3132
Joined: Sun Aug 27, 2017 12:05 am

Re: CereusReporting PHP crash

#3 Post by netniV » Mon Nov 04, 2019 9:59 am

Your error is with MySQL. You are generating too many SQL connections concurrently to the database so its rejecting new ones.

Atreides
Cacti User
Posts: 151
Joined: Mon May 31, 2010 9:26 am

Re: CereusReporting PHP crash

#4 Post by Atreides » Tue Nov 05, 2019 2:50 am

And this happens only when I try to install CereusReporting plugin. Any idee why? Or where to look for issues?

LE: I changed spine poller proc/thread from 5/10 to 1/10 and increased mysql max connection to 500. Seems that did the trick, thank you for the hint netniV. Can be closed.

Post Reply