[SOLVED] following docs.cacti.net/node/54 -> poller_items

[thomasw]

Hello,

I try to setup graphs which hold 5-min polling results for 125 days. I followed exactly the instructions on the page http://docs.cacti.net/node/54. the result is that the entries in the table poller_item are being not created. If I insert the entries manually into the table poller_item the rrd-files are being created at next poller-time and the graphing starts.

Does anybody notice the same behaviour, when following the mentioned document?
I`m using cacti 0.8.7a with both of the official patches and no plugins installed.

any help is highly welcome!

thanks in advance,

best regards,

tom

[msylvain]

What append with this request :

Code: Select all

 select * from data_template_data,data_input,data_local 
    where data_template_data.data_input_id=data_input.id
        and data_local.id=data_template_data.local_data_id
        and data_local.host_id = XX;

where XX is your your id device.
The result of this kind of request is used to fill in the poller_item table.

Maybe having a look at the update_poller_cache() funtion, in the lib/utility.php file would help...

[thomasw]

Hi,

the query returns the wanted result:

10998 10925 10935 49 2 NULL |host_description| - Traffic myswitch3-2 - Traffic NULL on NULL 300 NULL 2 bf566c869ac6443b0c75d1c32b5a350e Get SNMP Data (Indexed) 3 10935 49 97 1 50
10997 10925 10934 49 2 NULL |host_description| - Traffic myswitch3-2 - Traffic NULL on NULL 300 NULL 2 bf566c869ac6443b0c75d1c32b5a350e Get SNMP Data (Indexed) 3 10934 49 97 1 49

but the entries into the table poller_item are not being created.

even the update poller_cache does not help...
Any Ideas?

thanks in advance,

tom

[gandalf]

Hello,

I try to setup graphs which hold 5-min polling results for 125 days. I followed exactly the instructions on the page http://docs.cacti.net/node/54. the result is that the entries in the table poller_item are being not created. If I insert the entries manually into the table poller_item the rrd-files are being created at next poller-time and the graphing starts.

Does anybody notice the same behaviour, when following the mentioned document?
I`m using cacti 0.8.7a with both of the official patches and no plugins installed.

any help is highly welcome!

thanks in advance,

best regards,

tom

Please decribe in more detail, which steps you've run and which settings were used. Post at least the full rra table
Reinhard

[thomasw]

Hello,

my rra table looks like:

########################################################################
mysql> select * from rra;
+----+----------------------------------+------------------------------------+----------------+-------+-------+----------+
| id | hash | name | x_files_factor | steps | rows | timespan |
+----+----------------------------------+------------------------------------+----------------+-------+-------+----------+
| 1 | c21df5178e5c955013591239eb0afd46 | Daily (5 Minute Average) | 0.5 | 1 | 600 | 86400 |
| 2 | 0d9c0af8b8acdc7807943937b3208e29 | Weekly (30 Minute Average) | 0.5 | 6 | 700 | 604800 |
| 3 | 6fc2d038fb42950138b0ce3e9874cc60 | Monthly (2 Hour Average) | 0.5 | 24 | 775 | 2678400 |
| 4 | e36f3adb9f152adfa5dc50fd2b23337e | Yearly (1 Day Average) | 0.5 | 288 | 797 | 33053184 |
| 5 | 283ea2bf1634d92ce081ec82a634f513 | Hourly (1 Minute Average) | 0.5 | 1 | 500 | 14400 |
| 6 | ae055bcf3a448f23fec02de845f504dc | Custom (125 Days, no average, 5min) | 0.5 | 1 | 36000 | 10800000 |
+----+----------------------------------+------------------------------------+----------------+-------+-------+----------+
6 rows in set (0.00 sec)
######################################################################

what I have done:

1. created rra based on my calculation
=> 12 datapoints per hour, 24 hours a day, 125 days => 36000 rows
=> 3600 sec / hour * 24 hours a day * 125 days => 10800000 timespan

2. created a data template based on interface traffic

3. created a graph template based on an existing one

4. added the newly defined Graph Template to the data query "SNMP Interface - Statistics"

5. created new graphs

6. received output on top of the page
+ Created graph: sw3-2@Gi0/1#Host:nach rzfco
+ Created graph: sw3-2@Gi0/2#Host:nach rzfco

So far everything was working as expected. But the graphs are never being created.
a database query of poller_item showed up, that there are no entries in the table. So I inserted them manually into the table. After that the poller created the wanted rrd files and graphing starts.

How can I track / trace down the situation?
any help is highly welcome!

if you need more information please let me know.

thanks,

tom

[gandalf]

########################################################################
mysql> select * from rra;
+----+----------------------------------+------------------------------------+----------------+-------+-------+----------+
| id | hash | name | x_files_factor | steps | rows | timespan |
+----+----------------------------------+------------------------------------+----------------+-------+-------+----------+
| 6 | ae055bcf3a448f23fec02de845f504dc | Custom (125 Days, no average, 5min) | 0.5 | 1 | 36000 | 10800000 |
+----+----------------------------------+------------------------------------+----------------+-------+-------+----------+
######################################################################

what I have done:

1. created rra based on my calculation
=> 12 datapoints per hour, 24 hours a day, 125 days => 36000 rows
=> 3600 sec / hour * 24 hours a day * 125 days => 10800000 timespan

fine

2. created a data template based on interface traffic

Please post a screenshot of the Data Template -> RRA relation. And visit Data Sources, select the failing one, swicth to DEBUG and attach that output as well
Reinhard

[thomasw]

Hello,

please find the wanted screenshots attached at this post.

Is it correct that the Data Source Fields -> Data Source Path is empty, but the rrdtool create statement has the full path to the file?

thanks in advance,

best regards,

tom

ps: if you need more information please let me know

[gandalf]

Is it correct that the Data Source Fields -> Data Source Path is empty, but the rrdtool create statement has the full path to the file?

That's weird and not to be understood as a feature. I wonder what cacti.log shows when a new data source of this type is to be created. Does it show the rrdtool create with full path like DEBUg or does it show nothing?
Please select a second RRA at the DAta Template level (one including consolidation, e.g. the weekly/monthly/yearly one) and retry. Please post same information as above for this try.
If I will have to reproduce, it will take until weekend.
Reinhard

[thomasw]

Hi,

sorry for the late reply, but I was off of work for a couple of days because of karneval.

the cacti.log shows nothing about graph-creation, mostly poller output as far as I can see.

I tried another datasource (one which is already included into cacti, based on interface - traffic) the path to the rrd file is in the datasource-fields -> data source path included. field show the following value:

- (<path_rra>/hostname_traffic_in_10692.rrd)

Attached I have a screenshot of the data source based on cacti predefined including consolidation and a screenshot of the rra relation.

hope you can find out whats the cause of the issue.

thanks in advance,

best regards,

tom

[gandalf]

Would you mind posting your db? Please answer via pm and I'll give my email@
Reinhard

[thomasw]

Hello,

the entries in the table poller_item are getting created now!

I missed to "check the checkboxes" in the data-queries -> SNMP int - stats -> Associated Data Templates section. Attached you find a screenshot of my failure...

@gandalf:
thank you very much for your assistance!
may you enhance the documentation (howto define a very big rra without data loss) to not forget to check the checkboxes? thank you!

best regards,

tom

[gandalf]

Thank you for the pointers.
The missing item is described in the HowTo for creating data queries. I was not aware, that it should be mention in the doc you pointed me to. Will have to verify and add a comment
Reinhard