Polling Errors (also spaces in graphs)

[fing8733]

This is a new install of Cacti on Debian. Version is 8.6.0i installed via apt-get and it was working great. Yesterday I installed the plugin architecture and I let it sit overnight. I think I was getting the errors in the log before but I am can't confirm that. Anyone have any suggestions?

[gandalf]

Change your number of concurrent processes and see if the problem goes away.
Reinhard

[TheWitness]

Could be a damaged table. Try running the following. Create a file in the cacti directory with the following. Then run that file.

TheWitness

Code: Select all

<?php
/* do NOT run this script through a web browser */
if (!isset($_SERVER["argv"][0]) || isset($_SERVER['REQUEST_METHOD'])  || isset($_SERVER['REMOTE_ADDR'])) {
	die("<br><strong>This script is only meant to run at the command line.</strong>");
}

$no_http_headers = true;

include(dirname(__FILE__) . "./include/config.php");

echo "Repairing All Cacti Database Tables\n";

$tables = db_fetch_assoc("SHOW TABLES FROM " . $database_default);

if (sizeof($tables)) {
	foreach($tables AS $table) {
		echo "Repairing Table -> '" . $table['Tables_in_' . $database_default] . "'";
		$status = db_execute("REPAIR TABLE " . $table['Tables_in_' . $database_default] . " USE_FRM");
		echo ($status == 0 ? " Failed" : " Successful") . "\n";
	}
}
?>

[larry26]

I am having a similar issue... these are the errors I am getting

system information...


Name : cacti
Version : 0.8.6j

CentOS release 4.4 (Final)
2.6.9-42.ELsmp

PHP 4.3.9 (cgi) (built: May 10 2007 05:19:09)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies

mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i686) using readline 4.3

RRDtool 1.2.18

cacti.log

05/18/2007 05:07:21 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
05/18/2007 05:07:21 PM - SYSTEM STATS: Time:292.7284 Method:cmd.php Processes:1 Threads:N/A Hosts:4 HostsPerProcess:4 DataSources:61 RRDsProcessed:0

running php poller.php i get

Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
.
.
.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
PHP Warning: pclose(): 45 is not a valid stream resource in /var/www/cacti/lib/rrd.php on line 48


I ran the script by TheWitness but still not working, not displaying any graphs, just the graph description

[larry26]

I checked out another post, applied the patches and It is resolved now. Thanks

[ikemeyer]

larry, what were the patches? I am experiencing a similar problem.