After rrd migration graph is not recording values

Problem

After the rrd migration for some reasons some graphs are not recording values:

In the cmc.log you may see that kind of messages:

2022-04-06 13:24:41 [4] [client 1] Error accessing RRD: No DS called '12' in '/opt/omd/sites/mysite/var/check_mk/rrd/schiller/Interface_eth1-02.45.rrd'
2022-04-06 13:24:41 [4] [client 1] Error accessing RRD: No DS called '6' in '/opt/omd/sites/mysite/var/check_mk/rrd/schiller/Interface_eth1-02.45.rrd'
2022-04-06 13:24:41 [4] [client 1] Error accessing RRD: No DS called '5' in '/opt/omd/sites/mysite/var/check_mk/rrd/schiller/Interface_eth1-02.45.rrd'
2022-04-06 13:24:41 [4] [client 1] Error accessing RRD: No DS called '11' in '/opt/omd/sites/mysite/var/check_mk/rrd/schiller/Interface_eth1-02.45.rrd'

Solution

In order to automate those steps, you can get a script from Checkmk Support

Change to the rrd directory
Click to expand Expand source
```
OMD[mysite]:~$ cd var/check_mk/rrd/<HOSTNAME>
```

How many metrics are stored in the .info file?

Click to expand

OMD[mysite]:~/var/check_mk/rrd/myhost.txt$ cat Interface_2.info 
HOST myhost
SERVICE Interface eth0
METRICS outqlen;in;out;inerr;inmcast;inbcast;inucast;innucast;indisc;outerr;outmcast;outbcast;outucast;outnucast;outdisc

15 Metrics are stored here

How many datasources do we have in the .rrd file?

Click to expand

OMD[test]:~/var/check_mk/rrd/kirchner_check_mk_agent_output.txt$ rrdtool info Interface_2.rrd |grep "last_ds"
ds[1].last_ds = "U"
ds[2].last_ds = "U"
ds[3].last_ds = "U"
ds[4].last_ds = "0"
ds[7].last_ds = "U"
ds[8].last_ds = "U"
ds[9].last_ds = "U"
ds[10].last_ds = "U"
ds[13].last_ds = "U"
ds[14].last_ds = "U"
ds[15].last_ds = "U"

--> 11 Datasources are stored. As described in the cmc.log, the DS 5,6,11 and 12 are missing

So here we have a mismatch of the amount of metrics in the .info (15 Metrics ) file and the amount of Datasources (11 DS) in the .rrd file
We need to create the missing DS into the rrd file.

Before continuing here, please note that we do not provide support for any broken .rrd file. Please be careful and do a backup of that files beforehand.
1. Stop the site
  Click to expand Expand source
```
OMD[mysite]:~$ omd stop
```
2. Create the 4 missing datasources
  Expand source
```
rrdtool tune Interface_2.rrd DS:5:GAUGE:8460:0:U
rrdtool tune Interface_2.rrd DS:6:GAUGE:8460:0:U
rrdtool tune Interface_2.rrd DS:11:GAUGE:8460:0:U
rrdtool tune Interface_2.rrd DS:12:GAUGE:8460:0:U
```
  More information about the command could be found here: https://oss.oetiker.ch/rrdtool/doc/rrdtune.en.html
3. Start the site
  Click to expand Expand source
```
OMD[mysite]:~$ omd start
```

Problem

Solution

Related articles

Filter by label