Solved the issue,
For future reference, my script server data query inputs (|query_*|), for some
hosts, didn't have unique indexes.
update_data_query_sort_cache -> get_ordered_index_type_list -> " /* fields that
contain duplicate or empty values are not suitable to index off of */"
Since there were duplicates in all "|query_|" variables none was returned.
I wasn't aware that those (just variables!) must be unique, for me the
combination of two input fields was unique so I've added the combination of
those two input fields as another query input field (otherwise unused at all in
data sources or graph title names).
-----Original Message-----
From: Nitzan Zaifman
Sent: Thursday, July 09, 2015 11:44 AM
To: Support requests/questions about cacti
Subject: Re: [cacti-user] Cacti data sources and graphs not created (complex)
Well great to see this list so active. The forums aren't, is thereanywhere to
get someone's ear?...
I'm almost 100% positive that it's a real Cacti issue either in Cacti itself or
the database (definition). How can I check this? Logs? PHP file? Etc.
There are many hosts that this dataquery script doesn't work on - the
commonality is those hosts return 150 items 75 rows results.
There are hosts were it works and the same query returns 8 items, 4 rows there.
(results count difference is correct, it depends on the job of those hosts).
I believe this is the only difference.
Eagerly awaiting reply...
-----Original Message-----
From: Nitzan Zaifman
Sent: Tuesday, July 07, 2015 9:39 AM
To: Support requests/questions about cacti
Subject: Re: [cacti-user] Cacti data sources and graphs not created (complex)
Well, the screenshot attachments didn't work...
I hope my description is good enough...
-----Original Message-----
From: Nitzan Zaifman
Sent: Tuesday, July 07, 2015 9:20 AM
To: Support requests/questions about cacti
Subject: [cacti-user] Cacti data sources and graphs not created (complex)
Hi,
General / summary:
One of my data queries doesn't work. It's a new one but the same one works on
one host and not on another (actually doesn't work on a couple of others tried).
>From initial (as far as I could) analysis - the data query does not create the
>graph and data sources correctly on the effected host(/hosts) and rrd is not
>created (nor does poller ever retrieves the data).
********************************************************************************
How do I see a log of a new graph creation (from device -> data query), not the
poller events (that aren't, there are none).
********************************************************************************
Specific:
I've took example of two hosts: "Peach" and "Orange", both trying to add the
same generated data queries (from script server) graphs.
It all works well as expected in "Orange", but does not in "Peach"
I've included everything in screenshots (those are temporary internal lab
servers so I don't mind) so you'd get the full picture.
The two differences I can see tell between the two are:
1. "Peach"'s (not working) MVSnew dataquery is significantly larger (150
items, 75 rows) vs. "Orange"'s one (8 items, 4 rows).
2. Peach has a lot of script server data queires, about 65, vs. very
little on Orange.
Attachments:
General:
DataQueriesMvsnew.PNG - shows MVSnew dataquery configuration with its
associated graph templates "Active" and "Rate".
DataQueriesMvsnewActive.PNG - shows for example "Active" datasource to graph
mapping.
Peach (not working example):
CreatingANewGraphPeach.PNG - shows that indeed the data query works as expected
and I get my variables ("MVS name" and "service").
PROBLEM-CreatingANewGraphPeachProblem.PNG - the new graph was not created
correctly and did not resolve variables.
PROBLEM-NotCreatedDatasourcePeachOrange.PNG - the datasource was not created
correctly, btw the rrd file did not create at all
PROBLEM-NotCreatedPollerCacheEnteriesPeach.PNG - poller cache was not created
for this new graph (Cacti's log only shows poller events, where do I see
creation problems?)
Orange (working example):
CreatingANewGraphOrange.PNG - with the same exact MVSnew data query, I've
created a graph on another host, Orange (here "Rate" example)
CreatingANewGraphOrangeWORKS.PNG - graph created correctly and resolved
variable names.
CreatedDatasourceOrange.PNG - datasource created correctly (including rrd file
which was never generated in "Peach") CreatedPollerCacheEnteriesOrange.PNG -
relevant poller cache created correctly.
------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that you need
to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
_______________________________________________
cacti-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/cacti-user
------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that you need
to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
_______________________________________________
cacti-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/cacti-user
------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
_______________________________________________
cacti-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/cacti-user
