Aggregate graph does not show other percentiles #5555
Comments
|
Yea, I'm grumbling about this. The it can be included, but the logic is tricky. It only works in a few cases, specifically when you are totaling all data sources. |
* Aggregate graph does not show other percentiles
|
So, update |
TheWitness
added
resolved
* Additional QA to cover HRULES and Special Comments
* Aggregate graph does not show other percentiles
* Additional QA to cover HRULES and Special Comments
|
I did one minor QA to also handle the hrules as well. |
|
Hello, I made the adjustments to the lines and nothing, then I replaced the file and nothing. Version 1.2.25
Debug here |
|
Simple graph here OK
Debug here |
|
So, are you saying it's working on some aggregates and not others? |
not only in simple graphs, aggregates do not work |
|
Now I'm confused. Do you have any aggregates that after you resave either the aggregate or aggregate template that are working? Also, what happens when you create a new aggregate graph? |
I have an aggregation template that uses the same template as normal graphs, but normal graphs work and aggregates do not use the same template |
|
Template agreggate after change bugged
template normal graph ok |
|
To create the aggregate I use the same graph template which is
|
|
ROLLBACK api_aggregate.php and see agregate template for info
|
|
Yea, that modified aggregate was a yikes moment. I'll dig in later today. |
I am very grateful for the help, this has been bothering me a lot because I need the percentiles of the aggregates. |
|
Can you please screen capture your Aggregate Template. I need the "Aggregate Template Settings" section. Thanks. I'm still finding the Aggregates a little buggy, though I was not able to reproduce your issue. |
Here
|
|
Here Graph simple too if need |
|
Okay, tested on my side. I have a few updates to commit yet.
|
You can place the IN and OUT separately in the aggregates like in the simple graphs because adding the in and out is wrong |
|
Well, that's a very interesting development. |
|
Is it possible to send the dump? |
I tried to remove the database dump but I can't remove the confidential information. Do I need a specific table? |
|
One thing you can do is edit the sql file and then search for confidential information. If you edit in VIM, you can replace as follows: vim mydump.sql
# Assume you are searching to replace "ABC" with something else
:%s/ABC/randomsomething/g
# That above command replaces everything in the file that matches "ABC" with the string "randomsomething"Just keep doing that until all the 'confidential' stuff is gone. |
|
Another approach is just use sed sed -i 's/ABC/somethingrandom/g' mydump.sql |
|
Things confidential can be considered: ip addresses, snmp communities, site names, hostnames, and even interface names. I only have interest in the situation. I don't care about the rest. |
|
The other route is this. When you view an aggregate graph, you find in the address bar and id like in the case below, it's select task_item_id, value, text_format from graph_templates_item where local_graph_id=1032;Then, fix them, and run the command again as above. Send the output from each to the ticket. |
|
Here is my example: MariaDB [cacti]> select task_item_id, value, text_format from graph_templates_item where local_graph_id=1032; +--------------+--------------------------------------+----------------------------------------------------+
| task_item_id | value | text_format |
+--------------+--------------------------------------+----------------------------------------------------+
| 2268 | | |
| 2270 | | |
| 2264 | | |
| 2272 | | |
| 2274 | | |
| 2276 | | |
| 2278 | | |
| 2266 | | |
| 2280 | | |
| 2282 | | |
| 2269 | | |
| 2271 | | |
| 2265 | | |
| 2273 | | |
| 2275 | | |
| 2277 | | |
| 2279 | | |
| 2267 | | |
| 2281 | | |
| 2283 | | |
| 123 | | Total Inbound |
| 123 | | Current: |
| 123 | | Average: |
| 123 | | Maximum: |
| 124 | | Total Outbound |
| 124 | | Current: |
| 124 | | Average: |
| 124 | | Maximum: |
| 0 | | |
| 123 | |95:bits:0:aggregate_current_peak:2| | 95th Percentile |
| 123 | | (|95:bits:6:aggregate_current_peak:2| mbit in+out) |
| 123 | |98:bits:0:aggregate_current_peak:2| | 98th Percentile |
| 123 | | (|98:bits:6:aggregate_current_peak:2| mbit in+out) |
+--------------+--------------------------------------+----------------------------------------------------+
33 rows in set (0.001 sec) |
|
This is the result of the aggregated graph of 75 interfaces that does not cause problems and always works |
|
This is the other one that I removed from the unit to work |
|
This is from a new chart that is still working without updating the template |
|
Thanks for that. There is an error in your template. Look at the screen shot below. 66 is in, 67 is out.
|
|
It's your Graph Template. |
|
can help check here ?
|
|
You must first:
Still waiting on the dump. |
|
Good morning. Here is what I identified. 1 with 4 interfaces 1 with 10 interfaces 1 with 20 interfaces |
|
AWAYS WORK DONT WORK DONT WORK |
|
I believe it has something to do with the number of interfaces |
|
|
|
New test with 30 interfaces also stopped working, only the one with 20 interfaces that works anyway |
|
The only way I'll be able to go further on this is to have a db dump. |
|
Ope! I just reproduced it in my local environment! |
|
Okay, it's fixed now. Just re-save the Template once updated. Thanks for your patience. |
|
I've logged this enhancement as well. |
|
Woohoo Thank you very much for your patience and I really appreciate your effort.
|
I have a graph template that is applied to all graphs and aggregates, however when I create the normal graphs I can see the 95th and 99th ones but in the aggregates I cannot see this data as shown in the screenshots below
Normal graph
Agregate graph
Here model graph for aggregate
The text was updated successfully, but these errors were encountered: