graph creates with data source but not in poller cache

[falchion]

Ok, I've been digging on this for the better part of 2 days, but can't figgure it out on my own.

Cacti 0.8.7g with patches as of Dec 5th 2010

I've been through the debugging howto, no joy.

I've created a script_query, tested from the command line: all good

I create the data query, create the data template, create a graph template, associate the graph template with the data query: all good

I add the data query to the host, query works, verbose looks good.

I create the graph, and create works. Graph exists, data source exists, debug on them look snormal, except that the rrd does not exist for the graph.

Looking at the poller cache, the data source does not show up, even after rebuilding the poller cache.

Can't find any errors in any log.

There's the summary, I'll cut/paste some details shortly.

I should mention that the same host has many other graphs working fine.

Thanks for any/all help!

Steve

[falchion]

Here's the data query verbose...

Data Query Debug Information
+ Running data query [16].
+ Found type = '4 '[script query].
+ Found data query XML file at '/usr/local/cacti-0.8.7g/resource/script_queries/tsm_scratch.xml'
+ XML file parsed ok.
+ Executing script for list of indexes 'perl /usr/local/cacti-0.8.7g/scripts/tsm_scratch_tapes.pl tsmprd001 index'
+ Executing script query 'perl /usr/local/cacti-0.8.7g/scripts/tsm_scratch_tapes.pl tsmprd001 query server'
+ Found item [server='tsmprd001'] index: tsmprd001
+ Executing script query 'perl /usr/local/cacti-0.8.7g/scripts/tsm_scratch_tapes.pl tsmprd001 query lib1'
+ Found item [lib1='LIB_3584'] index: tsmprd001
+ Executing script query 'perl /usr/local/cacti-0.8.7g/scripts/tsm_scratch_tapes.pl tsmprd001 query lib2'
+ Found item [lib2='WDC_LIB1'] index: tsmprd001
+ Executing script query 'perl /usr/local/cacti-0.8.7g/scripts/tsm_scratch_tapes.pl tsmprd001 query lib3'
+ Found item [lib3='none'] index: tsmprd001
+ Executing script query 'perl /usr/local/cacti-0.8.7g/scripts/tsm_scratch_tapes.pl tsmprd001 query lib4'
+ Found item [lib4='none'] index: tsmprd001
+ Found data query XML file at '/usr/local/cacti-0.8.7g/resource/script_queries/tsm_scratch.xml'
+ Found data query XML file at '/usr/local/cacti-0.8.7g/resource/script_queries/tsm_scratch.xml'
+ Found data query XML file at '/usr/local/cacti-0.8.7g/resource/script_queries/tsm_scratch.xml'

[gandalf]

When adding the graph template to the data query, did you check the boxes for "Associated Data Templates"?
R.

[falchion]

Thanks for the quick holiday-season response

Indeed, I did check those checkboxes. I'll post a couple screenshots of the relevant parts in a few minutes

[falchion]

Here's the screenshots of the Data Query, Data Template and Graph Template.

Steve

[falchion]

And here's the graph creation, graph debug, data source debug and relevant section of the poller cache.

Steve

[gandalf]

Here's the screenshots of the Data Query, Data Template and Graph Template.

Steve

Please check the index fields of the data template and retry
R.

[falchion]

Ah, I think I misunderstood you previously. I think now that you are referring to the "Custom Data" section at the bottom of the Data Template?

I checked those, saved it, deleted the old graph and data source, re-created the graph (and by extension the data source) and still no entry in the poller cache.

Do I need to remove the data template from the data query and re-add it? I'll try that as well...

Steve

[falchion]

ok removed the associated graph template from the data query after checking the "Custom" index fields, added it back in, and then remove the data query from the device and added it back in, then created the graph and exactly the same situation. I happened to notice that the line I check to create the graph does not get greyed out like the rest do after the graph is created, not sure if that info helps at all.

Steve

[gandalf]

Ah, I think I misunderstood you previously.

No you didn't. But you answered to my satisfaction.

I think now that you are referring to the "Custom Data" section at the bottom of the Data Template?

yes
R.

[gandalf]

ok removed the associated graph template from the data query after checking the "Custom" index fields, added it back in, and then remove the data query from the device and added it back in, then created the graph and exactly the same situation. I happened to notice that the line I check to create the graph does not get greyed out like the rest do after the graph is created, not sure if that info helps at all.

Both infos are telling the same story.
Please export the Data Query and post it along with the resource XML and perl script
R.

[falchion]

Here they are. My apologies for the rough and largely uncommented code

Hmmm.. it does not want to let me upload the resource xml, so I'll paste it in here.

Steve


<interface>
<name>Get TSM Library Scratch Tapes</name>
<description>QUeries the number of available scratch tapes in the first 4 TSM tapelibraries found.</description>
<script_path>perl |path_cacti|/scripts/tsm_scratch_tapes.pl</script_path>
<arg_prepend>|host_hostname|</arg_prepend>
<arg_index>index</arg_index>
<arg_query>query</arg_query>
<arg_get>get</arg_get>
<arg_num_indexes>num_indexes</arg_num_indexes>
<output_delimeter>:</output_delimeter>
<index_order>server,lib1,lib2,lib3,lib4</index_order>
<index_order_type>alphabetic</index_order_type>
<index_title_format>|chosen_order_field|</index_title_format>

<fields>
<server>
<name>Device Name</name>
<direction>input</direction>
<query_name>server</query_name>
</server>
<lib1>
<name>Library #1 name</name>
<direction>input</direction>
<query_name>lib1</query_name>
</lib1>
<lib2>
<name>Library #2 name</name>
<direction>input</direction>
<query_name>lib2</query_name>
</lib2>
<lib3>
<name>Library #3 name</name>
<direction>input</direction>
<query_name>lib3</query_name>
</lib3>
<lib4>
<name>Library #4 name</name>
<direction>input</direction>
<query_name>lib4</query_name>
</lib4>

<scratch1>
<name>Scratch tapes in Library #1</name>
<direction>output</direction>
<query_name>scratch1</query_name>
</scratch1>
<scratch2>
<name>Scratch tapes in Library #2</name>
<direction>output</direction>
<query_name>scratch2</query_name>
</scratch2>
<scratch3>
<name>Scratch tapes in Library #3</name>
<direction>output</direction>
<query_name>scratch3</query_name>
</scratch3>
<scratch4>
<name>Scratch tapes in Library #4</name>
<direction>output</direction>
<query_name>scratch4</query_name>
</scratch4>
</fields>
</interface>

[gandalf]

As I have no tsm server at hand, please provide output of the index, query and get commands when running from cli. I will have to patch the script file to get similar results.
And next, I need results from "System Utilities -> View SNMP Cache", when filtering for host and data query in question. I don't need exact data, so for security reasons you may modify data.
R.

[falchion]

Here's the perl script output (all possible outputs for one host)


bash-4.1# ./tsm_scratch_tapes.pl tsmprd001 index
tsmprd001
bash-4.1# ./tsm_scratch_tapes.pl tsmprd001 query server
tsmprd001:tsmprd001
bash-4.1# ./tsm_scratch_tapes.pl tsmprd001 query lib1
tsmprd001:LIB_3584
bash-4.1# ./tsm_scratch_tapes.pl tsmprd001 query scratch1
tsmprd001:174
bash-4.1# ./tsm_scratch_tapes.pl tsmprd001 query lib2
tsmprd001:WDC_LIB1
bash-4.1# ./tsm_scratch_tapes.pl tsmprd001 query scratch2
tsmprd001:1056
bash-4.1# ./tsm_scratch_tapes.pl tsmprd001 query lib3
tsmprd001:none
bash-4.1# ./tsm_scratch_tapes.pl tsmprd001 query scratch3
tsmprd001:0
bash-4.1# ./tsm_scratch_tapes.pl tsmprd001 query lib4
tsmprd001:none
bash-4.1# ./tsm_scratch_tapes.pl tsmprd001 query scratch4
tsmprd001:0
bash-4.1# ./tsm_scratch_tapes.pl tsmprd001 get server
tsmprd001bash-4.1# ./tsm_scratch_tapes.pl tsmprd001 get lib1
LIB_3584bash-4.1# ./tsm_scratch_tapes.pl tsmprd001 get scratch1
174bash-4.1# ./tsm_scratch_tapes.pl tsmprd001 get lib2
WDC_LIB1bash-4.1# ./tsm_scratch_tapes.pl tsmprd001 get scratch2
1056bash-4.1# ./tsm_scratch_tapes.pl tsmprd001 get lib3
nonebash-4.1# ./tsm_scratch_tapes.pl tsmprd001 get scratch3
0bash-4.1# ./tsm_scratch_tapes.pl tsmprd001 get lib4
nonebash-4.1# ./tsm_scratch_tapes.pl tsmprd001 get scratch4
0bash-4.1#

[falchion]

And here's the SNMP cache...


Host: Primary TSM Server (WPG) , SNMP Query: tsm_scratch_tapes_DQ
Index: tsmprd001 , Field Name: lib4 , Field Value: none
OID:
Host: Primary TSM Server (WPG) , SNMP Query: tsm_scratch_tapes_DQ
Index: tsmprd001 , Field Name: lib3 , Field Value: none
OID:
Host: Primary TSM Server (WPG) , SNMP Query: tsm_scratch_tapes_DQ
Index: tsmprd001 , Field Name: lib2 , Field Value: WDC_LIB1
OID:
Host: Primary TSM Server (WPG) , SNMP Query: tsm_scratch_tapes_DQ
Index: tsmprd001 , Field Name: lib1 , Field Value: LIB_3584
OID:
Host: Primary TSM Server (WPG) , SNMP Query: tsm_scratch_tapes_DQ
Index: tsmprd001 , Field Name: server , Field Value: tsmprd001
OID: