Missing interface graph

[drookie]

Hi.

How can I fix missing interface graph ?

Graph type is Interface Stats//Bits/sec, it's marked as it's being graphed in 'Create graphs' page for this particular host (it's grey and I'm not allowed to check it), but it's missing from graph list, and I definitely cannot find its datasource. So I'm unable to delete it and recreate.

I'm using cacti 0.8.7e/php 4.4.7/rrdtool 1.3.7 on a Solaris 10 x86.
Thanks.

[Deviloper]

Are you sure you selected the correct "graph type" in the "create graph for this host" page?

I would try to reindex (reload data query) the device or for a more detailed look try "verbose query" in the device overview.

If this do not succeed, I would recommend to delete the device and reimport the whole device into cacti.

[drookie]

a) You seem to completely misunderstand me.
b) You propose harmful and completely incompetent solution.

[drookie]

And correct and non-harmful solution is to delete the corresponding row with the appropriate snmp id and host id from data_local.

[gandalf]

a) You seem to completely misunderstand me.
b) You propose harmful and completely incompetent solution.

I do not agree with your judgement. IMHO, the pointers are correct
R.

[gandalf]

And correct and non-harmful solution is to delete the corresponding row with the appropriate snmp id and host id from data_local.

The way it "should work" is to identify the related data source and delete that. Then, you will be able to again create a new graph from the device, just as usual.
Unfortunately, you told us that you can't find that data source.
This leaves us with several options. The most straightforward approach was presented above.
You may as well search for any SQL error that applies while trying to find the data source in question.
The last and most complex way would be to manually retry the database search that cacti performs. This either requires online access to your system or a full mysqldump of your tables
R.

[drookie]

Yup, thanks for the complete explanation.

It was obvious for me too that some error happened and graph wasn't created then it was for the first time, but losing accumulated history for a dozen of other datasources is not the acceptable way, imo.

PS I think, it would be great if product of such complexity as cacti would have a self-check tool, that will provide some integrity and consistency checks on a database and physically existing ds/rras.

[gandalf]

but losing accumulated history for a dozen of other datasources is not the acceptable way, imo.

Quite understandable.

PS I think, it would be great if product of such complexity as cacti would have a self-check tool, that will provide some integrity and consistency checks on a database and physically existing ds/rras.

Correct. Unfortunately, "stale (in your eyes)" data sources are fine from "our" point of view. It's perfectly fine for us to have a "single" data source who's "original graph" has been deleted. It may still happen, that the data source is used in e.g. an aggregate or the like.
That's why we offer to delete or not to delete the data source when deleting a graph. That leaves you with the decision what you want to achieve.
But your approach perhaps leads to a new, useful plugin (sth very similar to RRDClean): A plugin may check for data sources not used by any graph. And it may then offer to operate, e.g. delete, those data sources. That still leaves the decisions to you.
R.