Non device based Data Sources not being polled

[holm-informatik]

Describe the bug

Somewhere between 1.2.16 and 1.2.20, non device based data sources (Device: None) stopped being polled (no data collected and does not show up in the poller cache). It worked in 1.2.16 and older, it does not seem to work after upgrading to 1.2.20 (and 1.2.21).

Rebuilding the poller cache (tested web and cli) does not help.

Cacti is running on Debian 11, php 7.4

[TheWitness]

Hmm, do they exist in the poller cache? Can you confirm?

[holm-informatik]

No, they do not.

[TheWitness]

I have to setup a reproduce environment.

[TheWitness]

Run this. I just set one up and it worked perfectly:

SELECT * FROM data_local WHERE host_id = 0;

[TheWitness]

Also the following;

SELECT COUNT(*) FROM poller_item WHERE host_id = 0;

[holm-informatik]

SELECT * FROM data_local WHERE host_id = 0;

id	data_template_id	host_id	snmp_query_id	snmp_index	orphan
262	56	0	0	0
428	56	0	0	0
483	56	0	0	0
887	56	0	0	0

SELECT COUNT(*) FROM poller_item WHERE host_id = 0;

COUNT(*)
 4

[holm-informatik]

Tbh, I would not be surprised if there is som database corruption going on (been thru many updates). However, it worked in 1.2.16 and if I assign one of the affected data sources to a host, it works.

[TheWitness]

Is that them though? They are in the poller cache.

[holm-informatik]

Yes, it's them.

It would seem so but they are not present when looking in Console > Utilities > View Poller Cache and I get no data UNLESS I assign the Data Source to a device (so I assume that there is no problem with the data source itself).

[TheWitness]

Run this and show me the output:

./spine -R -V 5 -S -f 0 -l 0

Maybe it's spine.

[holm-informatik]

No, I'm not using spine...

[TheWitness]

cmd.php is similar

php -q cmd.php --debug --first=0 --last=0 --poller=1