'Re: [cacti-user] Cacti data sources and graphs not created (complex)'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       cacti-user
Subject:    Re: [cacti-user] Cacti data sources and graphs not created	(complex)
From:       Nitzan Zaifman <nitzanz () algotec ! co ! il>
Date:       2015-07-12 12:57:20
Message-ID: BA28910A07AA9A48A7B570A67A6E9CA1BD98C469 () RAVEN ! algotec ! co ! il
[Download RAW message or body]

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
cacti-user@lists.sourceforge.net
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
cacti-user@lists.sourceforge.net
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
cacti-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/cacti-user


[prev in list] [next in list] [prev in thread] [next in thread]
Configure | About | News | Add a list | Sponsored by KoreLogic