Issues with data source profiles after Cacti upgrade

[dma_k]

Dear all,

I have noticed that there are several profiles with the same name created. Did it happen during the Cacti upgrade? Probably it would be less confusion if profiles would be sequentially numbered, what do you think?

Code: Select all

MariaDB [cacti_db]> select * from data_source_profiles;
+----+----------------------------------+-------------------+-------+-----------+----------------+---------+
| id | hash                             | name              | step  | heartbeat | x_files_factor | default |
+----+----------------------------------+-------------------+-------+-----------+----------------+---------+
|  1 | 5b16ea2d688c2f856abfb5c8657a4ca8 | Upgrade Profile 1 |   300 |       600 |            0.5 |         |
|  2 | eb2335a9e4151b5fbf203404924e799f | Upgrade Profile 1 | 21600 |     86400 |            0.5 |         |
|  3 | 326f7748d7c3e0686fa1faf24d882db0 | Upgrade Profile 1 |   300 |       600 |            0.5 |         |
|  4 | ad1ce76d6fe32afd4959dc264d57d473 | Upgrade Profile 1 |   300 |     86400 |            0.5 |         |
+----+----------------------------------+-------------------+-------+-----------+----------------+---------+

Next I have noticed that polling interval (= step) which in previous Cacti versions was given as number input, cannot be mapped to existing values in drop-down list, which is showing "Every 10 seconds" (first option) in my case and that is not correct for value 21600 (6 hours). My suggestion would be that if the value cannot be mapped to none in the list, then display "unknown", or show the value in seconds.

cacti_1.png (7.86 KiB) Viewed 3845 times

How can I recover in this case? Given data source profile is already used, hence is read-only.

Another question is about the creation of data source profile. No matter what settings are set, UI displays "0 KBytes per Data Sources". Should that value be dynamically changed to reflect the settings? That would be more informative.

cacti_2.png (13.13 KiB) Viewed 3845 times

Also noticed that the drop-down list for consolidation functions is too small so that it creates an impression that there is only one function in the list (probably this is browser bug, I am testing with Firefox):

cacti_3.png (15.49 KiB) Viewed 3834 times

I am using Cacti 1.2.16.

Thanks for the feedback!

[TheWitness]

Looks like an old version. You fail to state what version you are using.

[dma_k]

I am using Cacti 1.2.16 (updated the top post as well).

[jinju]

Is this issue resolved? I'm also having the same issue. The graph template moved to different data source profile. Any idea how to resolved it without affecting the graph. Currently graph templates are there in id 1 and 3. I want to move it to id 2.

MariaDB [cacti]> select * from data_source_profiles;
+----+----------------------------------+-------------------+------+-----------+----------------+---------+
| id | hash | name | step | heartbeat | x_files_factor | default |
+----+----------------------------------+-------------------+------+-----------+----------------+---------+
| 1 | 34ed3e32747a9a405fc164e83a03c4cb | Upgrade Profile 1 | 60 | 120 | 0.5 | |
| 2 | e6c117ad7f5f6a101bae6866dadaf1d9 | Upgrade Profile 1 | 60 | 120 | 0.5 | |
| 3 | e44c8f41fadc88bf882c40852f438dbd | Upgrade Profile 1 | 300 | 600 | 0.5 | |
+----+----------------------------------+-------------------+------+-----------+----------------+---------+

Any idea, how to resolve it.

[dma_k]

+----+----------------------------------+-------------------+------+-----------+----------------+---------+
| id | hash | name | step | heartbeat | x_files_factor | default |
+----+----------------------------------+-------------------+------+-----------+----------------+---------+
| 1 | 34ed3e32747a9a405fc164e83a03c4cb | Upgrade Profile 1 | 60 | 120 | 0.5 | |
| 2 | e6c117ad7f5f6a101bae6866dadaf1d9 | Upgrade Profile 1 | 60 | 120 | 0.5 | |
| 3 | e44c8f41fadc88bf882c40852f438dbd | Upgrade Profile 1 | 300 | 600 | 0.5 | |
+----+----------------------------------+-------------------+------+-----------+----------------+---------+
Any idea, how to resolve it.

My advice would be: try fixing that directly in the database. I suspect that if your step/heartbeat is not the one "supported" by Cacti, they could be eventually overwritten with some unexpected values.

[jinju]

Thanks for your suggestion.
I have created another data source profile and moved the template to it. Then splicerrd used to recreate the graph. That's how I overcame the issue.

[rabadie]

I have years of data that I cannot lose and I am in the same boat with the data source warnings and multiple profiles. I looked at cli\splice_rrd and I am not sure it's the best way to go about this. Any ideas where to look next would be greatly appreciated. I have over 200 affected RRD files.

[jinju]

I did the below method to overcome the issue. But its a tedious work. If someone have an idea to simplify it, please suggest. It is appreciate.

#php -q splice_rrd.php --oldrrd=/var/lib/cacti/rra/old-rrd_1274.rrd \
--newrrd=/var/lib/cacti/rra/new-rrd_1618.rrd \
--finrrd=/var/lib/cacti/rra/new-rrd_1618-1.rrd

#mv new-rrd_1618-1.rrd new-rrd_1618.rrd