Some graphs empty while other ok for the same host.

[polityk]

Cacti 0.8.8b
Spine 0.8.8b

I am trying to debug why for one host there are graphs which are ok and some of them stopped graphing.
All of them are Interface statistics: errors/discards, non-unicast traffic, interface traffic.
While errors and non-unicast are ok traffic graphs are not graphing.
This happens only for one host...

Running spine for this host and looking into output i can see:
SPINE: Poller[0] Host[544] TH[2] NOTE: There are '14' Polling Items for this Host

(...)

11/11/2013 11:27:10 AM - SPINE: Poller[0] Host[544] TH[2] DS[3441] SNMP: v1: 10.0.1.1, dsname: discards_in, oid: .1.3.6.1.2.1.2.2.1.13.23, value: 24179
11/11/2013 11:27:10 AM - SPINE: Poller[0] Host[544] TH[2] DS[3441] SNMP: v1: 10.0.1.1, dsname: discards_out, oid: .1.3.6.1.2.1.2.2.1.19.23, value: 0
11/11/2013 11:27:10 AM - SPINE: Poller[0] Host[544] TH[2] DS[3442] SNMP: v1: 10.0.1.1, dsname: nonunicast_in, oid: .1.3.6.1.2.1.2.2.1.12.2, value: 216700
11/11/2013 11:27:10 AM - SPINE: Poller[0] Host[544] TH[2] DS[3442] SNMP: v1: 10.0.1.1, dsname: nonunicast_out, oid: .1.3.6.1.2.1.2.2.1.18.2, value: 3885162
11/11/2013 11:27:10 AM - SPINE: Poller[0] Host[544] TH[2] DS[3443] SNMP: v1: 10.0.1.1, dsname: nonunicast_in, oid: .1.3.6.1.2.1.2.2.1.12.3, value: 367565
11/11/2013 11:27:10 AM - SPINE: Poller[0] Host[544] TH[2] DS[3443] SNMP: v1: 10.0.1.1, dsname: nonunicast_out, oid: .1.3.6.1.2.1.2.2.1.18.3, value: 3630694
11/11/2013 11:27:10 AM - SPINE: Poller[0] Host[544] TH[2] DS[3444] SNMP: v1: 10.0.1.1, dsname: nonunicast_in, oid: .1.3.6.1.2.1.2.2.1.12.23, value: 36847
11/11/2013 11:27:10 AM - SPINE: Poller[0] Host[544] TH[2] DS[3444] SNMP: v1: 10.0.1.1, dsname: nonunicast_out, oid: .1.3.6.1.2.1.2.2.1.18.23, value: 8638693
11/11/2013 11:27:10 AM - SPINE: Poller[0] Host[544] TH[2] DS[3445] SNMP: v1: 10.0.1.1, dsname: nonunicast_in, oid: .1.3.6.1.2.1.2.2.1.12.24, value: 21262054
11/11/2013 11:27:10 AM - SPINE: Poller[0] Host[544] TH[2] DS[3445] SNMP: v1: 10.0.1.1, dsname: nonunicast_out, oid: .1.3.6.1.2.1.2.2.1.18.24, value: 1182842
11/11/2013 11:27:10 AM - SPINE: Poller[0] Host[544] TH[2] DS[3446] SNMP: v1: 10.0.1.1, dsname: nonunicast_in, oid: .1.3.6.1.2.1.2.2.1.12.25, value: 2481765
11/11/2013 11:27:10 AM - SPINE: Poller[0] Host[544] TH[2] DS[3446] SNMP: v1: 10.0.1.1, dsname: nonunicast_out, oid: .1.3.6.1.2.1.2.2.1.18.25, value: 3743234
11/11/2013 11:27:10 AM - SPINE: Poller[0] Host[544] TH[2] DS[3447] SNMP: v1: 10.0.1.1, dsname: nonunicast_in, oid: .1.3.6.1.2.1.2.2.1.12.31, value: 882850
11/11/2013 11:27:10 AM - SPINE: Poller[0] Host[544] TH[2] DS[3447] SNMP: v1: 10.0.1.1, dsname: nonunicast_out, oid: .1.3.6.1.2.1.2.2.1.18.31, value: 30693127

Now the main questions:
All nonunicast and errors are polled correctly, but what about traffic?
Where to look for an answer why only 14 polling items are found for this host? (looking into host DS: should be 21)

p.s.
I have probably broken something somewhere, but i would rather fix it than re create hosts or graphs....

[polityk]

Well, somehow i have managed to find out what was wrong...
If someone bumps into it here is the answer:
Fooling around with database does sometimes get messy

2 things (see attached image):
1) unchecked in data queries
2) both DS items set to the same ifInOctes/ifInOctes not ifInOctes/ifOutOctes


This happened somehow 'by itself ' when i was moving DB and editing some DB fields.... so be carefull