Poller Output Table not Empty

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
chiro
Posts: 1
Joined: Wed Feb 17, 2010 7:56 am

Poller Output Table not Empty

Post by chiro »

Hi,
today I noticed that I have some warning in my log file.

Code: Select all

POLLER: Poller[0] WARNING: Poller Output Table not Empty. Issues Found: 2, Data Sources: traffic_in(DS[8]), traffic_in(DS[78]) 
And the graphics associated with this datasources have valuse "nan"

I checked the poller output table in mydatabase and it wasn't empty. Deleted the records for this data sources, but one minute later I am getting the same error and the records in poller output table are back there.

Code: Select all

mysql> select * from poller_output;
+---------------+------------+---------------------+--------------+
| local_data_id | rrd_name   | time                | output       |
+---------------+------------+---------------------+--------------+
|             8 | traffic_in | 2010-03-25 12:04:02 | 109165200849 |
|            78 | traffic_in | 2010-03-25 12:04:02 | 0            |
+---------------+------------+---------------------+--------------+
2 rows in set (0.00 sec)

This datasources and the graphics are created absolutely the same way as the other graphics I am graphing and the rest of them are working fine.

Tried rebuilding the poller cache - no luck
.
What else can I look for to fix this problem?

Cacti Version 0.8.7e on Fedora Core 12
Poller - cmd.php
cron interval - every minute
poller interval - every minute

Thanks for the help
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Please try cli/rebuild_poller_items.php
R.
earnie
Posts: 2
Joined: Tue Mar 02, 2010 4:54 am

How can I try rebuild_poller_items.php ?

Post by earnie »

Hi,

I have same problem with @chiro

But I don't have that file 'rebuild_poller_items.php'

Any help would be appreciated.

earnie

Cacti Version 0.8.7d on Ubuntu Desktop 9.10
Poller - cmd.php
cron interval -5 minute
poller interval - 5 minute
User avatar
TheWitness
Developer
Posts: 17061
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

If you resave the host and the traffic_out do not appear, then there is another problem and you may have to delete and re-create the graphs in question.

The utility that Gandalf provided is simply a way to run the "Repopulate Poller Cache" utility that is available from the "System Utilities" section of the WebUI.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
zez3
Posts: 2
Joined: Mon Mar 06, 2017 6:44 am

Re: Poller Output Table not Empty

Post by zez3 »

hi guys,

I have the same issue with the latest cacti version.
it appeared after the migration 0.8.8_h-1 -> 1.0.0-1

Currently running 1.0.4-1 but the issue is not yet fixed.

MariaDB [cacti]> select * from poller_output;
+---------------+----------+---------------------+-------------------------------+
| local_data_id | rrd_name | time | output |
+---------------+----------+---------------------+-------------------------------+
| 11 | | 2017-03-06 12:46:02 | CPU_temp:42.7 GPU_temp:42.774 |
| 10 | | 2017-03-06 12:46:02 | CPU_temp:42.7 GPU_temp:42.774 |
| 8 | | 2017-03-06 12:46:02 | Inside:22.6 Outside:8.9 |
| 9 | | 2017-03-06 12:46:02 | Inside:22.6 Outside:8.9 |
+---------------+----------+---------------------+-------------------------------+
4 rows in set (0.00 sec)

MariaDB [cacti]> select * from poller_output;
Empty set (0.00 sec)

MariaDB [cacti]> select * from poller_output;
+---------------+----------+---------------------+-------------------------------+
| local_data_id | rrd_name | time | output |
+---------------+----------+---------------------+-------------------------------+
| 11 | | 2017-03-06 12:47:03 | CPU_temp:42.2 GPU_temp:42.236 |
| 10 | | 2017-03-06 12:47:03 | CPU_temp:41.6 GPU_temp:42.236 |
| 9 | | 2017-03-06 12:47:03 | Inside:22.6 Outside:8.8 |
| 8 | | 2017-03-06 12:47:03 | Inside:22.6 Outside:8.8 |
+---------------+----------+---------------------+-------------------------------+
4 rows in set (0.01 sec)

Has anyone a suggestion why is not writing to rra ?
zez3
Posts: 2
Joined: Mon Mar 06, 2017 6:44 am

Re: Poller Output Table not Empty

Post by zez3 »

This issue has been moved to github

https://github.com/Cacti/cacti/issues/389

which at this moment is not yet fixed
Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests