Cacti graph stop poller until rebuild poller cache

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

Post Reply
areast
Cacti User
Posts: 105
Joined: Wed Oct 29, 2014 5:08 am

Cacti graph stop poller until rebuild poller cache

Post by areast »

Hi all

Does anyone experience the cacti graph suddenly stop polling until manually "Rebuild poller cache"?
After upgrade to 0.8.8c with 2008R2 64bits, my cacti work fine already few monthly.
And now this few week are suddenly stop polling until manually "Rebuild poller cache"
The missing graph happen to all my graph

Below are log which I turn on debug mode and manually "Rebuild poller cache"

Filter Error log
04/16/2015 11:36:36 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'145', SQL:"UPDATE thold_data SET tcheck = 0'
04/16/2015 11:36:36 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"SELECT * FROM thold_data WHERE thold_enabled = 'on' AND tcheck = 1"
04/16/2015 11:30:52 AM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
04/16/2015 11:29:04 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'2006', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.0.117.13', '167802125', '', '3', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1429154944)'
Attachments
Untitled.png
Untitled.png (28.36 KiB) Viewed 3448 times
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Re: Cacti graph stop poller until rebuild poller cache

Post by BSOD2600 »

MySQL error 145 is crashed tables. run \cacti\cli\repair_database.php
santoshmhaske1
Posts: 5
Joined: Thu Oct 08, 2015 2:46 pm

Re: Cacti graph stop poller until rebuild poller cache

Post by santoshmhaske1 »

I am too facing the same problem. In same week it happened two time.
Polling stop for all devices/graphs and have to do rebuild poller cache to start it.

Does anyone have permanent solution for this problem?

Thanks.
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Re: Cacti graph stop poller until rebuild poller cache

Post by BSOD2600 »

santoshmhaske1:
if you're going to hijack others threads, at least follow the existing recommendations.
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests