Some data sources (RRD files) aren't created by poller

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
stefanbrudny
Cacti User
Posts: 130
Joined: Thu Jan 19, 2012 11:52 am

Some data sources (RRD files) aren't created by poller

Post by stefanbrudny »

Hi,
Caci is configured correctly and all automation works. My cron poller is set to 5 minutes, while in cacti I have spine interval one minute and cron option set to 5 minutest
I have (had) 6k devices in the system, but only 3 enabled (I removed now all just in case). For some reasons for mane graphs at each device I am getting:

Code: Select all

Failed to open data file, poller may have not run yet.
So I debug:
* hosts are reindexed and proper number of interfaces can be seen when reindexing with debug
Screenshot_20220629_235549.png
Screenshot_20220629_235549.png (2.65 KiB) Viewed 1564 times
So I check the data sources, all good:
Screenshot_20220629_235718.png
Screenshot_20220629_235718.png (237.53 KiB) Viewed 1564 times
But when I check details I can see no graphs:
Screenshot_20220629_235549.png
Screenshot_20220629_235549.png (2.65 KiB) Viewed 1564 times
Going back to device poller cache and it is missing items, repopulating gives nothing (hell, no all of the sudden there are more data sources, but still some rrd files are missing and get never created)
Screenshot_20220630_000435.png
Screenshot_20220630_000435.png (260.22 KiB) Viewed 1564 times
Isn't it like there should always be same amount of rrd files and data sources? it isn't:
Screenshot_20220630_000813.png
Screenshot_20220630_000813.png (124.7 KiB) Viewed 1564 times

I can also clarly see that in debug log for the device that spine do not ask for the missing data sources.

I can troubleshoot logs and see:
Screenshot_20220630_000813.png
Screenshot_20220630_000813.png (124.7 KiB) Viewed 1564 times
So missing RRD, going to debug data source:
Attachments
Screenshot_20220629_235854.png
Screenshot_20220629_235854.png (154.54 KiB) Viewed 1564 times
Last edited by stefanbrudny on Wed Jun 29, 2022 5:57 pm, edited 1 time in total.
Top
stefanbrudny
Cacti User
Posts: 130
Joined: Thu Jan 19, 2012 11:52 am

Re: Some data sources aren't created

Post by stefanbrudny »

So I debug data source, all is proposed for creating RRD seems fine:
Screenshot_20220630_004111.png
Screenshot_20220630_004111.png (307.63 KiB) Viewed 1562 times
Data source gets created, so obviously I tried this with all data sources, and voila, worked.
Screenshot_20220630_005552.png
Screenshot_20220630_005552.png (538.62 KiB) Viewed 1562 times
But isn't this supposed to be created automatically? how to retrigger rrd creation? Isn't this bug or its just my misconfiguration?
Top
User avatar
TheWitness
Developer
Posts: 17062
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Re: Some data sources (RRD files) aren't created by poller

Post by TheWitness »

There are three ways to create the RRDfiles:

1) During polling
2) During boost runs (if using boost)
3) When you go to view a graph

So, this goes back to the poller, is it running? Is boost enabled? How does the Cacti.log look?

Also, with the device i/o graphs, they will write a temp file in /tmp/cacti/* that maintains old data. At the time I wrote them, it seemed like the right way to go. In hindsight, I should have created a temporary table for them. But so long as you know about the directory location, and only run your poller as the cactid user, then you won't have problems there.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
User avatar
TheWitness
Developer
Posts: 17062
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Re: Some data sources (RRD files) aren't created by poller

Post by TheWitness »

Lastly

Code: Select all

cd /var/www/html/cacti
chown -R apache:apache rra
I wonder if your default umask is too restrictive for the apache account and the directories that are created have a restrictive permission mask. Check that too.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
stefanbrudny
Cacti User
Posts: 130
Joined: Thu Jan 19, 2012 11:52 am

Re: Some data sources (RRD files) aren't created by poller

Post by stefanbrudny »

Permissions should be fine, been there, also changed user www-data shell to bash to simulate creation of rrds properly.
Host in question is name kuroo anf its local server, the increased rrds are from the other host which is sometimes turned on or off, therefore data sources number couldb e larger. This second host suffers same situation.


1. cacti.log looks perfect, poller is running fine:

Code: Select all

 2022-06-30 02:04:03 - SYSTEM INTROPAGE STATS: Time:0.35, Checks:15, Details:15, Trends:10
2022-06-30 02:04:02 - SYSTEM SYSLOG STATS: Time:0.05 Deletes:0 Incoming:2 Removes:2 XFers:0 Alerts:3 Alarms:0 Reports:0
2022-06-30 02:04:02 - SYSTEM THOLD STATS: Time:0.0117 Tholds:0 TotalDevices:2 DownDevices:0 NewDownDevices:0
2022-06-30 02:04:02 - SYSTEM STATS: Time:1.2588 Method:spine Processes:8 Threads:100 Hosts:2 HostsPerProcess:1 DataSources:668 RRDsProcessed:0
2022-06-30 02:03:02 - SYSTEM INTROPAGE STATS: Time:0.23, Checks:0, Details:0, Trends:10
2022-06-30 02:03:02 - SYSTEM SYSLOG STATS: Time:0.05 Deletes:0 Incoming:0 Removes:0 XFers:0 Alerts:3 Alarms:0 Reports:0
2022-06-30 02:03:02 - SYSTEM THOLD STATS: Time:0.0056 Tholds:0 TotalDevices:2 DownDevices:0 NewDownDevices:0
2022-06-30 02:03:02 - SYSTEM STATS: Time:1.2614 Method:spine Processes:8 Threads:100 Hosts:2 HostsPerProcess:1 DataSources:668 RRDsProcessed:0
2022-06-30 02:02:02 - SYSTEM INTROPAGE STATS: Time:0.25, Checks:0, Details:0, Trends:10
2022-06-30 02:02:02 - SYSTEM SYSLOG STATS: Time:0.06 Deletes:0 Incoming:0 Removes:0 XFers:0 Alerts:3 Alarms:0 Reports:0
2022-06-30 02:02:02 - SYSTEM THOLD STATS: Time:0.0060 Tholds:0 TotalDevices:2 DownDevices:0 NewDownDevices:0
2022-06-30 02:02:02 - SYSTEM STATS: Time:1.2649 Method:spine Processes:8 Threads:100 Hosts:2 HostsPerProcess:1 DataSources:668 RRDsProcessed:0
2022-06-30 02:01:02 - SYSTEM INTROPAGE STATS: Time:0.22, Checks:0, Details:0, Trends:10
2022-06-30 02:01:02 - SYSTEM SYSLOG STATS: Time:0.05 Deletes:0 Incoming:0 Removes:0 XFers:0 Alerts:3 Alarms:0 Reports:0
2022-06-30 02:01:02 - SYSTEM THOLD STATS: Time:0.0084 Tholds:0 TotalDevices:2 DownDevices:0 NewDownDevices:0
2022-06-30 02:01:02 - SYSTEM STATS: Time:1.2579 Method:spine Processes:8 Threads:100 Hosts:2 HostsPerProcess:1 DataSources:668 RRDsProcessed:0
2022-06-30 02:00:03 - SYSTEM INTROPAGE STATS: Time:0.28, Checks:2, Details:2, Trends:10
2022-06-30 02:00:02 - SYSTEM SYSLOG STATS: Time:0.05 Deletes:0 Incoming:6 Removes:6 XFers:0 Alerts:3 Alarms:0 Reports:0
2022-06-30 02:00:02 - SYSTEM THOLD STATS: Time:0.0077 Tholds:0 TotalDevices:2 DownDevices:0 NewDownDevices:0
2022-06-30 02:00:02 - SYSTEM STATS: Time:1.2850 Method:spine Processes:8 Threads:100 Hosts:2 HostsPerProcess:1 DataSources:668 RRDsProcessed:0
2022-06-30 02:00:01 - POLLER: Poller[Main Poller] PID[846248] WARNING: Data Template 'AAA Live Internet Devices' is impacted by lack of complete information
2022-06-30 02:00:01 - POLLER: Poller[Main Poller] PID[846248] WARNING: There are 18 Data Sources not returning all data leaving rows in the poller output table. Details to follow.
2022-06-30 02:00:01 - SYSTEM WARNING: Primary Admin account notifications disabled! Unable to send administrative Email.
2022-06-30 02:00:01 - POLLER: Poller[Main Poller] PID[846248] WARNING: Poller Output Table not Empty. Issues: 24, ...................some ips from disabled device here................, Additional Issues Remain. Only showing first 20
2022-06-30 01:59:05 - SYSTEM BOOST STATS: Time:2.22 RRDUpdates:4920
2022-06-30 01:59:03 - SYSTEM BOOST STATS: Time:0.17 ProcessNumber:5 RRDUpdates:903
2022-06-30 01:59:03 - SYSTEM BOOST STATS: Time:0.18 ProcessNumber:3 RRDUpdates:983
2022-06-30 01:59:03 - SYSTEM BOOST STATS: Time:0.20 ProcessNumber:2 RRDUpdates:959
2022-06-30 01:59:03 - SYSTEM BOOST STATS: Time:0.19 ProcessNumber:1 RRDUpdates:1113
2022-06-30 01:59:03 - SYSTEM BOOST STATS: Time:0.17 ProcessNumber:4 RRDUpdates:962
2022-06-30 01:59:03 - SYSTEM INTROPAGE STATS: Time:0.43, Checks:2, Details:2, Trends:10
2022-06-30 01:59:03 - SYSTEM SYSLOG STATS: Time:0.07 Deletes:0 Incoming:2 Removes:2 XFers:0 Alerts:3 Alarms:0 Reports:0
2022-06-30 01:59:03 - SYSTEM THOLD STATS: Time:0.0096 Tholds:0 TotalDevices:2 DownDevices:0 NewDownDevices:0
2022-06-30 01:59:02 - SYSTEM STATS: Time:1.2608 Method:spine Processes:8 Threads:100 Hosts:2 HostsPerProcess:1 DataSources:668 RRDsProcessed:0
2022-06-30 01:58:03 - SYSTEM INTROPAGE STATS: Time:0.72, Checks:16, Details:16, Trends:10
2022-06-30 01:58:03 - SYSTEM SYSLOG STATS: Time:0.04 Deletes:0 Incoming:0 Removes:0 XFers:0 Alerts:3 Alarms:0 Reports:0
2022-06-30 01:58:03 - SYSTEM THOLD STATS: Time:0.0070 Tholds:0 TotalDevices:2 DownDevices:0 NewDownDevices:0
2022-06-30 01:58:02 - SYSTEM STATS: Time:1.2724 Method:spine Processes:8 Threads:100 Hosts:2 HostsPerProcess:1 DataSources:668 RRDsProcessed:0
2022-06-30 01:57:18 - AUTH LOGIN: User 'js' authenticated
2022-06-30 01:57:03 - SYSTEM INTROPAGE STATS: Time:0.33, Checks:2, Details:2, Trends:10
2022-06-30 01:57:03 - SYSTEM SYSLOG STATS: Time:0.05 Deletes:0 Incoming:0 Removes:0 XFers:0 Alerts:3 Alarms:0 Reports:0
2022-06-30 01:57:03 - SYSTEM THOLD STATS: Time:0.0085 Tholds:0 TotalDevices:2 DownDevices:0 NewDownDevices:0
2022-06-30 01:57:02 - SYSTEM STATS: Time:1.2607 Method:spine Processes:8 Threads:100 Hosts:2 HostsPerProcess:1 DataSources:668 RRDsProcessed:0
2022-06-30 01:56:03 - SYSTEM INTROPAGE STATS: Time:0.22, Checks:0, Details:0, Trends:10
2022-06-30 01:56:03 - SYSTEM SYSLOG STATS: Time:0.05 Deletes:0 Incoming:0 Removes:0 XFers:0 Alerts:3 Alarms:0 Reports:0
2022-06-30 01:56:02 - SYSTEM THOLD STATS: Time:0.0060 Tholds:0 TotalDevices:1 DownDevices:0 NewDownDevices:0
2022-06-30 01:56:02 - SYSTEM STATS: Time:1.1544 Method:spine Processes:8 Threads:100 Hosts:1 HostsPerProcess:1 DataSources:668 RRDsProcessed:0
2022-06-30 01:55:03 - SYSTEM INTROPAGE STATS: Time:0.2, Checks:0, Details:0, Trends:10
2022-06-30 01:55:03 - SYSTEM SYSLOG STATS: Time:0.05 Deletes:0 Incoming:6 Removes:6 XFers:0 Alerts:3 Alarms:0 Reports:0
2022-06-30 01:55:02 - SYSTEM THOLD STATS: Time:0.0071 Tholds:0 TotalDevices:1 DownDevices:0 NewDownDevices:0
2022-06-30 01:55:02 - SYSTEM STATS: Time:1.1680 Method:spine Processes:8 Threads:100 Hosts:1 HostsPerProcess:1 DataSources:668 RRDsProcessed:0
2. Yes, boost is on. I could try stopping it, acually I tried, but not very systematically.

3. hmmm didn't know that.


So let me simulate one more time - removing all logs, removing device graphs, running automate rules on device gives me following debug log:

Code: Select all

2022-06-30 02:11:03 - SYSTEM INTROPAGE STATS: Time:0.21, Checks:0, Details:0, Trends:10
2022-06-30 02:11:03 - SYSTEM SYSLOG STATS: Time:0.05 Deletes:0 Incoming:0 Removes:0 XFers:0 Alerts:3 Alarms:0 Reports:0
2022-06-30 02:11:03 - SYSTEM THOLD STATS: Time:0.0062 Tholds:0 TotalDevices:1 DownDevices:0 NewDownDevices:0
2022-06-30 02:11:03 - SYSTEM STATS: Time:2.1266 Method:spine Processes:8 Threads:100 Hosts:1 HostsPerProcess:1 DataSources:670 RRDsProcessed:0
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075681421056] DEBUG: Device[kuroo] HT[7] DEBUG: HOST COMPLETE: About to Exit Device Polling Thread Function
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075681421056] Device[kuroo] HT[7] Total Time: 0.03 Seconds
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075689813760] DEBUG: Device[kuroo] HT[6] DEBUG: HOST COMPLETE: About to Exit Device Polling Thread Function
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075689813760] Device[kuroo] HT[6] Total Time: 0.031 Seconds
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075681421056] Device[kuroo] HT[7] DS[kuroo - Load Average - 5 Minute] Graphs[kuroo - Load Average] TT[0.73] SNMP: v2: 192.168.1.23, dsname: load_5min, oid: .1.3.6.1.4.1.2021.10.1.3.2, value: 1.07
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075681421056] Device[kuroo] HT[7] DS[kuroo - CPU - Idle] Graphs[kuroo - CPU Utilization] TT[0.71] SNMP: v2: 192.168.1.23, dsname: ssCpuIdle, oid: .1.3.6.1.4.1.2021.11.11.0, value: 90
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075681421056] Device[kuroo] HT[7] DS[kuroo - CPU - System] Graphs[kuroo - CPU Utilization] TT[0.67] SNMP: v2: 192.168.1.23, dsname: ssCpuSystem, oid: .1.3.6.1.4.1.2021.11.10.0, value: 2
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075681421056] Device[kuroo] HT[7] DS[kuroo - CPU - User] Graphs[kuroo - CPU Utilization] TT[0.60] SNMP: v2: 192.168.1.23, dsname: ssCpuUser, oid: .1.3.6.1.4.1.2021.11.9.0, value: 6
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075689813760] Device[kuroo] HT[6] DS[kuroo - Load Average - 5 Minute] Graphs[kuroo - Load Average] TT[0.45] SNMP: v2: 192.168.1.23, dsname: load_5min, oid: .1.3.6.1.4.1.2021.10.1.3.2, value: 1.07
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075689813760] Device[kuroo] HT[6] DS[kuroo - CPU - Idle] Graphs[kuroo - CPU Utilization] TT[0.41] SNMP: v2: 192.168.1.23, dsname: ssCpuIdle, oid: .1.3.6.1.4.1.2021.11.11.0, value: 90
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075689813760] Device[kuroo] HT[6] DS[kuroo - CPU - System] Graphs[kuroo - CPU Utilization] TT[0.38] SNMP: v2: 192.168.1.23, dsname: ssCpuSystem, oid: .1.3.6.1.4.1.2021.11.10.0, value: 2
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075689813760] Device[kuroo] HT[6] DS[kuroo - CPU - User] Graphs[kuroo - CPU Utilization] TT[0.36] SNMP: v2: 192.168.1.23, dsname: ssCpuUser, oid: .1.3.6.1.4.1.2021.11.9.0, value: 6
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075190974208] DEBUG: Device[kuroo] HT[9] DEBUG: HOST COMPLETE: About to Exit Device Polling Thread Function
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075190974208] Device[kuroo] HT[9] Total Time: 0.024 Seconds
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075689813760] Device[kuroo] HT[6] NOTE: There are '4' Polling Items for this Device
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075681421056] Device[kuroo] HT[7] NOTE: There are '4' Polling Items for this Device
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075673028352] DEBUG: Device[kuroo] HT[8] DEBUG: HOST COMPLETE: About to Exit Device Polling Thread Function
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075673028352] Device[kuroo] HT[8] Total Time: 0.027 Seconds
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075698206464] DEBUG: Device[kuroo] HT[5] DEBUG: HOST COMPLETE: About to Exit Device Polling Thread Function
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075190974208] Device[kuroo] HT[9] DQ[AVS - SNMP - Interface Statistics] RECACHE OID: .1.3.6.1.2.1.2.1.0, (assert: 8 = output: 8)
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075723384576] DEBUG: Device[kuroo] HT[1] DEBUG: HOST COMPLETE: About to Exit Device Polling Thread Function
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075698206464] Device[kuroo] HT[5] Total Time: 0.028 Seconds
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075723384576] Device[kuroo] HT[1] Total Time: 0.034 Seconds
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075673028352] Device[kuroo] HT[8] DS[kuroo - Load Average - 15 Minute] Graphs[kuroo - Load Average] TT[0.89] SNMP: v2: 192.168.1.23, dsname: load_15min, oid: .1.3.6.1.4.1.2021.10.1.3.3, value: 1.13
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075673028352] Device[kuroo] HT[8] DS[kuroo - Load Average - 5 Minute] Graphs[kuroo - Load Average] TT[0.83] SNMP: v2: 192.168.1.23, dsname: load_5min, oid: .1.3.6.1.4.1.2021.10.1.3.2, value: 1.07
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075673028352] Device[kuroo] HT[8] DS[kuroo - CPU - Idle] Graphs[kuroo - CPU Utilization] TT[0.78] SNMP: v2: 192.168.1.23, dsname: ssCpuIdle, oid: .1.3.6.1.4.1.2021.11.11.0, value: 90
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075673028352] Device[kuroo] HT[8] DS[kuroo - CPU - System] Graphs[kuroo - CPU Utilization] TT[0.74] SNMP: v2: 192.168.1.23, dsname: ssCpuSystem, oid: .1.3.6.1.4.1.2021.11.10.0, value: 2
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075190974208] Device[kuroo] HT[9] DQ[Net-SNMP - Get Device I/O] RECACHE OID COUNT: .1.3.6.1.4.1.2021.13.15.1.1.1, output: 28
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075681421056] Device[kuroo] HT[7] DQ[AVS - SNMP - Interface Statistics] RECACHE OID: .1.3.6.1.2.1.2.1.0, (assert: 8 = output: 8)
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075048363776] DEBUG: Device[kuroo] HT[10] DEBUG: HOST COMPLETE: About to Exit Device Polling Thread Function
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075048363776] Device[kuroo] HT[10] Total Time: 0.022 Seconds
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075689813760] Device[kuroo] HT[6] DQ[AVS - SNMP - Interface Statistics] RECACHE OID: .1.3.6.1.2.1.2.1.0, (assert: 8 = output: 8)
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075698206464] Device[kuroo] HT[5] DS[kuroo - Load Average - 5 Minute] Graphs[kuroo - Load Average] TT[0.74] SNMP: v2: 192.168.1.23, dsname: load_5min, oid: .1.3.6.1.4.1.2021.10.1.3.2, value: 1.07
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075698206464] Device[kuroo] HT[5] DS[kuroo - CPU - Idle] Graphs[kuroo - CPU Utilization] TT[0.72] SNMP: v2: 192.168.1.23, dsname: ssCpuIdle, oid: .1.3.6.1.4.1.2021.11.11.0, value: 90
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075698206464] Device[kuroo] HT[5] DS[kuroo - CPU - System] Graphs[kuroo - CPU Utilization] TT[0.70] SNMP: v2: 192.168.1.23, dsname: ssCpuSystem, oid: .1.3.6.1.4.1.2021.11.10.0, value: 2
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075698206464] Device[kuroo] HT[5] DS[kuroo - CPU - User] Graphs[kuroo - CPU Utilization] TT[0.67] SNMP: v2: 192.168.1.23, dsname: ssCpuUser, oid: .1.3.6.1.4.1.2021.11.9.0, value: 6
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075681421056] Device[kuroo] HT[7] DQ[Net-SNMP - Get Device I/O] RECACHE OID COUNT: .1.3.6.1.4.1.2021.13.15.1.1.1, output: 28
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075673028352] Device[kuroo] HT[8] NOTE: There are '4' Polling Items for this Device
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075689813760] Device[kuroo] HT[6] DQ[Net-SNMP - Get Device I/O] RECACHE OID COUNT: .1.3.6.1.4.1.2021.13.15.1.1.1, output: 28
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075723384576] Device[kuroo] HT[1] DS[kuroo - CPU - Idle] Graphs[kuroo - CPU Utilization] TT[4.74] SNMP: v2: 192.168.1.23, dsname: ssCpuIdle, oid: .1.3.6.1.4.1.2021.11.11.0, value: 90
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075723384576] Device[kuroo] HT[1] DS[kuroo - Load Average - 5 Minute] Graphs[kuroo - Load Average] TT[4.71] SNMP: v2: 192.168.1.23, dsname: load_5min, oid: .1.3.6.1.4.1.2021.10.1.3.2, value: 1.07
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075723384576] Device[kuroo] HT[1] DS[kuroo - Load Average - 15 Minute] Graphs[kuroo - Load Average] TT[4.67] SNMP: v2: 192.168.1.23, dsname: load_15min, oid: .1.3.6.1.4.1.2021.10.1.3.3, value: 1.13
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075698206464] Device[kuroo] HT[5] NOTE: There are '4' Polling Items for this Device
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075723384576] Device[kuroo] HT[1] DS[kuroo - Load Average - 1 Minute] Graphs[kuroo - Load Average] TT[4.61] SNMP: v2: 192.168.1.23, dsname: load_1min, oid: .1.3.6.1.4.1.2021.10.1.3.1, value: 1.04
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075673028352] Device[kuroo] HT[8] DQ[AVS - SNMP - Interface Statistics] RECACHE OID: .1.3.6.1.2.1.2.1.0, (assert: 8 = output: 8)
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075698206464] Device[kuroo] HT[5] DQ[AVS - SNMP - Interface Statistics] RECACHE OID: .1.3.6.1.2.1.2.1.0, (assert: 8 = output: 8)
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075673028352] Device[kuroo] HT[8] DQ[Net-SNMP - Get Device I/O] RECACHE OID COUNT: .1.3.6.1.4.1.2021.13.15.1.1.1, output: 28
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075698206464] Device[kuroo] HT[5] DQ[Net-SNMP - Get Device I/O] RECACHE OID COUNT: .1.3.6.1.4.1.2021.13.15.1.1.1, output: 28
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075048363776] Device[kuroo] HT[10] DQ[AVS - SNMP - Interface Statistics] RECACHE OID: .1.3.6.1.2.1.2.1.0, (assert: 8 = output: 8)
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075048363776] Device[kuroo] HT[10] DQ[Net-SNMP - Get Device I/O] RECACHE OID COUNT: .1.3.6.1.4.1.2021.13.15.1.1.1, output: 28
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075706599168] DEBUG: Device[kuroo] HT[4] DEBUG: HOST COMPLETE: About to Exit Device Polling Thread Function
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075706599168] Device[kuroo] HT[4] Total Time: 0.028 Seconds
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075706599168] Device[kuroo] HT[4] DS[kuroo - Load Average - 5 Minute] Graphs[kuroo - Load Average] TT[0.62] SNMP: v2: 192.168.1.23, dsname: load_5min, oid: .1.3.6.1.4.1.2021.10.1.3.2, value: 1.07
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075706599168] Device[kuroo] HT[4] DS[kuroo - CPU - Idle] Graphs[kuroo - CPU Utilization] TT[0.59] SNMP: v2: 192.168.1.23, dsname: ssCpuIdle, oid: .1.3.6.1.4.1.2021.11.11.0, value: 90
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075706599168] Device[kuroo] HT[4] DS[kuroo - CPU - System] Graphs[kuroo - CPU Utilization] TT[0.53] SNMP: v2: 192.168.1.23, dsname: ssCpuSystem, oid: .1.3.6.1.4.1.2021.11.10.0, value: 2
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075706599168] Device[kuroo] HT[4] DS[kuroo - CPU - User] Graphs[kuroo - CPU Utilization] TT[0.48] SNMP: v2: 192.168.1.23, dsname: ssCpuUser, oid: .1.3.6.1.4.1.2021.11.9.0, value: 6
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075714991872] DEBUG: Device[kuroo] HT[3] DEBUG: HOST COMPLETE: About to Exit Device Polling Thread Function
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075714991872] Device[kuroo] HT[3] Total Time: 0.028 Seconds
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075706599168] Device[kuroo] HT[4] NOTE: There are '4' Polling Items for this Device
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075731777280] DEBUG: Device[kuroo] HT[2] DEBUG: HOST COMPLETE: About to Exit Device Polling Thread Function
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075706599168] Device[kuroo] HT[4] DQ[AVS - SNMP - Interface Statistics] RECACHE OID: .1.3.6.1.2.1.2.1.0, (assert: 8 = output: 8)
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075731777280] Device[kuroo] HT[2] Total Time: 0.028 Seconds
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075723384576] Device[kuroo] HT[1] NOTE: There are '4' Polling Items for this Device
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075706599168] Device[kuroo] HT[4] DQ[Net-SNMP - Get Device I/O] RECACHE OID COUNT: .1.3.6.1.4.1.2021.13.15.1.1.1, output: 28
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075731777280] Device[kuroo] HT[2] DS[kuroo - Device I/O -nvme0n1p1] Graphs[kuroo - Device I/O - Reads/Writes nvme0n1p1] TT[1.37] SNMP: v2: 192.168.1.23, dsname: Device_Writes, oid: .1.3.6.1.4.1.2021.13.15.1.1.6.10, value: 2
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075714991872] Device[kuroo] HT[3] DS[kuroo - Device I/O -nvme0n1p3] Graphs[kuroo - Device I/O - Reads/Writes nvme0n1p3] TT[1.35] SNMP: v2: 192.168.1.23, dsname: Device_Writes, oid: .1.3.6.1.4.1.2021.13.15.1.1.6.12, value: 100843
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075714991872] Device[kuroo] HT[3] DS[kuroo - Device I/O -nvme0n1p3] Graphs[kuroo - Device I/O - Reads/Writes nvme0n1p3] TT[1.32] SNMP: v2: 192.168.1.23, dsname: Device_Reads, oid: .1.3.6.1.4.1.2021.13.15.1.1.5.12, value: 88008
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075731777280] Device[kuroo] HT[2] DS[kuroo - Device I/O -nvme0n1p1] Graphs[kuroo - Device I/O - Reads/Writes nvme0n1p1] TT[1.32] SNMP: v2: 192.168.1.23, dsname: Device_Reads, oid: .1.3.6.1.4.1.2021.13.15.1.1.5.10, value: 1355
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075714991872] Device[kuroo] HT[3] DS[kuroo - Device I/O -nvme0n1p2] Graphs[kuroo - Device I/O - Reads/Writes nvme0n1p2] TT[1.28] SNMP: v2: 192.168.1.23, dsname: Device_Writes, oid: .1.3.6.1.4.1.2021.13.15.1.1.6.11, value: 954040
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075731777280] Device[kuroo] HT[2] DS[kuroo - CPU - User] Graphs[kuroo - CPU Utilization] TT[1.28] SNMP: v2: 192.168.1.23, dsname: ssCpuUser, oid: .1.3.6.1.4.1.2021.11.9.0, value: 6
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075714991872] Device[kuroo] HT[3] DS[kuroo - Device I/O -nvme0n1p2] Graphs[kuroo - Device I/O - Reads/Writes nvme0n1p2] TT[1.22] SNMP: v2: 192.168.1.23, dsname: Device_Reads, oid: .1.3.6.1.4.1.2021.13.15.1.1.5.11, value: 978634
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075731777280] Device[kuroo] HT[2] DS[kuroo - CPU - System] Graphs[kuroo - CPU Utilization] TT[1.18] SNMP: v2: 192.168.1.23, dsname: ssCpuSystem, oid: .1.3.6.1.4.1.2021.11.10.0, value: 2
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075723384576] Device[kuroo] HT[1] DQ[AVS - SNMP - Interface Statistics] RECACHE OID: .1.3.6.1.2.1.2.1.0, (assert: 8 = output: 8)
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075714991872] Device[kuroo] HT[3] NOTE: There are '4' Polling Items for this Device
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075731777280] Device[kuroo] HT[2] NOTE: There are '4' Polling Items for this Device
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075723384576] Device[kuroo] HT[1] DQ[Net-SNMP - Get Device I/O] RECACHE OID COUNT: .1.3.6.1.4.1.2021.13.15.1.1.1, output: 28
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075731777280] Device[kuroo] HT[2] DQ[AVS - SNMP - Interface Statistics] RECACHE OID: .1.3.6.1.2.1.2.1.0, (assert: 8 = output: 8)
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075714991872] Device[kuroo] HT[3] DQ[AVS - SNMP - Interface Statistics] RECACHE OID: .1.3.6.1.2.1.2.1.0, (assert: 8 = output: 8)
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075731777280] Device[kuroo] HT[2] DQ[Net-SNMP - Get Device I/O] RECACHE OID COUNT: .1.3.6.1.4.1.2021.13.15.1.1.1, output: 28
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075714991872] Device[kuroo] HT[3] DQ[Net-SNMP - Get Device I/O] RECACHE OID COUNT: .1.3.6.1.4.1.2021.13.15.1.1.1, output: 28
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075673028352] DEBUG: walk starts at OID .1.3.6.1.4.1.2021.13.15.1.1.1
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075673028352] DEBUG: Device[kuroo] HT[8] RECACHE: Processing 2 items in the auto reindex cache for '192.168.1.23'
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075698206464] DEBUG: walk starts at OID .1.3.6.1.4.1.2021.13.15.1.1.1
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075698206464] DEBUG: Device[kuroo] HT[5] RECACHE: Processing 2 items in the auto reindex cache for '192.168.1.23'
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075048363776] DEBUG: walk starts at OID .1.3.6.1.4.1.2021.13.15.1.1.1
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075048363776] DEBUG: Device[kuroo] HT[10] RECACHE: Processing 2 items in the auto reindex cache for '192.168.1.23'
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075190974208] DEBUG: walk starts at OID .1.3.6.1.4.1.2021.13.15.1.1.1
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075190974208] DEBUG: Device[kuroo] HT[9] RECACHE: Processing 2 items in the auto reindex cache for '192.168.1.23'
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075048363776] Device[kuroo] DEBUG: Entering SNMP Ping
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075048363776] DEBUG: Device[kuroo] HT[10] In Poller, About to Start Polling
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075190974208] Device[kuroo] DEBUG: Entering SNMP Ping
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075673028352] Device[kuroo] DEBUG: Entering SNMP Ping
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075698206464] Device[kuroo] DEBUG: Entering SNMP Ping
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075681421056] DEBUG: walk starts at OID .1.3.6.1.4.1.2021.13.15.1.1.1
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075681421056] DEBUG: Device[kuroo] HT[7] RECACHE: Processing 2 items in the auto reindex cache for '192.168.1.23'
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075190974208] DEBUG: Device[kuroo] HT[9] In Poller, About to Start Polling
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075689813760] DEBUG: walk starts at OID .1.3.6.1.4.1.2021.13.15.1.1.1
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075689813760] DEBUG: Device[kuroo] HT[6] RECACHE: Processing 2 items in the auto reindex cache for '192.168.1.23'
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075681421056] Device[kuroo] DEBUG: Entering SNMP Ping
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075723384576] DEBUG: walk starts at OID .1.3.6.1.4.1.2021.13.15.1.1.1
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075723384576] DEBUG: Device[kuroo] HT[1] RECACHE: Processing 2 items in the auto reindex cache for '192.168.1.23'
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075673028352] DEBUG: Device[kuroo] HT[8] In Poller, About to Start Polling
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075698206464] DEBUG: Device[kuroo] HT[5] In Poller, About to Start Polling
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075689813760] Device[kuroo] DEBUG: Entering SNMP Ping
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075681421056] DEBUG: Device[kuroo] HT[7] In Poller, About to Start Polling
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075706599168] DEBUG: walk starts at OID .1.3.6.1.4.1.2021.13.15.1.1.1
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075706599168] DEBUG: Device[kuroo] HT[4] RECACHE: Processing 2 items in the auto reindex cache for '192.168.1.23'
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075706599168] Device[kuroo] DEBUG: Entering SNMP Ping
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075689813760] DEBUG: Device[kuroo] HT[6] In Poller, About to Start Polling
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075714991872] DEBUG: walk starts at OID .1.3.6.1.4.1.2021.13.15.1.1.1
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075714991872] DEBUG: Device[kuroo] HT[3] RECACHE: Processing 2 items in the auto reindex cache for '192.168.1.23'
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075714991872] Device[kuroo] DEBUG: Entering SNMP Ping
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075706599168] DEBUG: Device[kuroo] HT[4] In Poller, About to Start Polling
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075731777280] DEBUG: walk starts at OID .1.3.6.1.4.1.2021.13.15.1.1.1
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075731777280] DEBUG: Device[kuroo] HT[2] RECACHE: Processing 2 items in the auto reindex cache for '192.168.1.23'
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075723384576] Device[kuroo] Updating Full System Information Table
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075714991872] DEBUG: Device[kuroo] HT[3] In Poller, About to Start Polling
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075731777280] Device[kuroo] DEBUG: Entering SNMP Ping
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075723384576] Device[kuroo] DEBUG: Entering SNMP Ping
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075731777280] DEBUG: Device[kuroo] HT[2] In Poller, About to Start Polling
2022-06-30 02:11:01 - SPINE: Poller[Main Poller] PID[849329] PT[140075723384576] DEBUG: Device[kuroo] HT[1] In Poller, About to Start Polling
2022-06-30 02:10:47 - AUTOM8 NOTE: Graph Added - Device[kuroo], Graph[kuroo - Traffic - br0 - 192.168.1.23 ], DS[kuroo - Traffic - 192.168.1.23/br0] Graphs[kuroo - Traffic - br0 - 192.168.1.23 ], Rule[AVS - Create interface statistics NOT FOR HOSTS]
2022-06-30 02:10:47 - AUTOM8 NOTE: [PID: 835271] create_graph_node() Graph[kuroo - Traffic - br0 - 192.168.1.23 ] Tree Item - Added - id: (157341)
2022-06-30 02:10:47 - CMDPHP ERROR: Suggested value column error. Column name for Data Template ID 197 is not a compatible field name for tables data_template_data and data_template_rrd. Please correct this suggested value mapping
2022-06-30 02:10:47 - AUTOM8 NOTE: Graph Added - Device[kuroo], Graph[kuroo - Device I/O - Bytes Read/Written nvme0n1], DS[kuroo - Device I/O -nvme0n1] Graphs[kuroo - Device I/O - Bytes Read/Written nvme0n1], Rule[AVS - Create I/O statistics - bytes read / written]
2022-06-30 02:10:47 - AUTOM8 NOTE: Graph Added - Device[kuroo], Graph[kuroo - Device I/O - Bytes Read/Written nvme0n1p5], DS[kuroo - Device I/O -nvme0n1p5] Graphs[kuroo - Device I/O - Bytes Read/Written nvme0n1p5], Rule[AVS - Create I/O statistics - bytes read / written]
2022-06-30 02:10:46 - AUTOM8 NOTE: Graph Added - Device[kuroo], Graph[kuroo - Device I/O - Bytes Read/Written nvme0n1p4], DS[kuroo - Device I/O -nvme0n1p4] Graphs[kuroo - Device I/O - Bytes Read/Written nvme0n1p4], Rule[AVS - Create I/O statistics - bytes read / written]
2022-06-30 02:10:46 - AUTOM8 NOTE: Graph Added - Device[kuroo], Graph[kuroo - Device I/O - Bytes Read/Written nvme0n1p3], DS[kuroo - Device I/O -nvme0n1p3] Graphs[kuroo - Device I/O - Bytes Read/Written nvme0n1p3], Rule[AVS - Create I/O statistics - bytes read / written]
2022-06-30 02:10:46 - AUTOM8 NOTE: Graph Added - Device[kuroo], Graph[kuroo - Device I/O - Bytes Read/Written nvme0n1p2], DS[kuroo - Device I/O -nvme0n1p2] Graphs[kuroo - Device I/O - Bytes Read/Written nvme0n1p2], Rule[AVS - Create I/O statistics - bytes read / written]
2022-06-30 02:10:46 - AUTOM8 NOTE: Graph Added - Device[kuroo], Graph[kuroo - Device I/O - Bytes Read/Written nvme0n1p1], DS[kuroo - Device I/O -nvme0n1p1] Graphs[kuroo - Device I/O - Bytes Read/Written nvme0n1p1], Rule[AVS - Create I/O statistics - bytes read / written]
2022-06-30 02:10:46 - AUTOM8 NOTE: Graph Added - Device[kuroo], Graph[kuroo - Device I/O - Reads/Writes nvme0n1], DS[kuroo - Device I/O -nvme0n1] Graphs[kuroo - Device I/O - Reads/Writes nvme0n1], Rule[AVS - Create I/O statistics]
2022-06-30 02:10:46 - AUTOM8 NOTE: Graph Added - Device[kuroo], Graph[kuroo - Device I/O - Reads/Writes nvme0n1p5], DS[kuroo - Device I/O -nvme0n1p5] Graphs[kuroo - Device I/O - Reads/Writes nvme0n1p5], Rule[AVS - Create I/O statistics]
2022-06-30 02:10:45 - AUTOM8 NOTE: Graph Added - Device[kuroo], Graph[kuroo - Device I/O - Reads/Writes nvme0n1p4], DS[kuroo - Device I/O -nvme0n1p4] Graphs[kuroo - Device I/O - Reads/Writes nvme0n1p4], Rule[AVS - Create I/O statistics]
2022-06-30 02:10:45 - AUTOM8 NOTE: Graph Added - Device[kuroo], Graph[kuroo - Device I/O - Reads/Writes nvme0n1p3], DS[kuroo - Device I/O -nvme0n1p3] Graphs[kuroo - Device I/O - Reads/Writes nvme0n1p3], Rule[AVS - Create I/O statistics]
2022-06-30 02:10:45 - AUTOM8 NOTE: Graph Added - Device[kuroo], Graph[kuroo - Device I/O - Reads/Writes nvme0n1p2], DS[kuroo - Device I/O -nvme0n1p2] Graphs[kuroo - Device I/O - Reads/Writes nvme0n1p2], Rule[AVS - Create I/O statistics]
2022-06-30 02:10:45 - AUTOM8 NOTE: Graph Added - Device[kuroo], Graph[kuroo - Device I/O - Reads/Writes nvme0n1p1], DS[kuroo - Device I/O -nvme0n1p1] Graphs[kuroo - Device I/O - Reads/Writes nvme0n1p1], Rule[AVS - Create I/O statistics]
2022-06-30 02:10:45 - AUTOM8 NOTE: Graph Added - Device[kuroo], Graph[kuroo - Traffic], DS[kuroo - Traffic - |query_ifName| - |query_ifIP| ] Graphs[kuroo - Traffic]
2022-06-30 02:10:45 - AUTOM8 NOTE: [PID: 835271] create_graph_node() Graph[kuroo - Traffic] Tree Item - Added - id: (157340)
2022-06-30 02:10:45 - AUTOM8 NOTE: Data Check Succeeded for - Device[kuroo], GT[AVS - Interface - Traffic (bits/sec, 95th) HW]
2022-06-30 02:10:45 - AUTOM8 NOTE: Graph Added - Device[kuroo], Graph[kuroo - CPU Utilization], DS[kuroo - CPU - Idle, kuroo - CPU - System, kuroo - CPU - User] Graphs[kuroo - CPU Utilization]
2022-06-30 02:10:44 - AUTOM8 NOTE: Data Check Succeeded for - Device[kuroo], GT[Net-SNMP - CPU Utilization]
2022-06-30 02:10:44 - AUTOM8 NOTE: Graph Added - Device[kuroo], Graph[kuroo - Load Average], DS[kuroo - Load Average - 1 Minute, kuroo - Load Average - 15 Minute, kuroo - Load Average - 5 Minute] Graphs[kuroo - Load Average]
2022-06-30 02:10:44 - AUTOM8 NOTE: Data Check Succeeded for - Device[kuroo], GT[Net-SNMP - Load Average]
2022-06-30 02:10:21 - WEBUI NOTE: Cacti Log file /var/www/html/log/cacti.log, Removed by user js
2022-06-30 02:10:21 - WEBUI NOTE: Cacti Log Cleared from Web Management Interface.
This replicates the issue. What is interesting, is that realtime polls data correctly - there is no rrd for the graph on mousover, but its pure realtime presentation.

Screenshot_20220630_021420.png
Screenshot_20220630_021420.png (231.91 KiB) Viewed 1558 times
Top
User avatar
TheWitness
Developer
Posts: 17062
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Re: Some data sources (RRD files) aren't created by poller

Post by TheWitness »

I have a sneaking suspicion this has something to do with structured paths and boost. Have to replicate it on my side.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
User avatar
TheWitness
Developer
Posts: 17062
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Re: Some data sources (RRD files) aren't created by poller

Post by TheWitness »

I was able to remove the file with boost records missing, then review the Graph that was hosting it and the file was properly automatically created. Now I'll delete the whole device directory and try again.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
User avatar
TheWitness
Developer
Posts: 17062
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Re: Some data sources (RRD files) aren't created by poller

Post by TheWitness »

Reproduced. By doing that...
Attachments
Reproduced.png
Reproduced.png (201.34 KiB) Viewed 1555 times
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
User avatar
TheWitness
Developer
Posts: 17062
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Re: Some data sources (RRD files) aren't created by poller

Post by TheWitness »

Need a GitHub bug of course. Fixing now.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
User avatar
TheWitness
Developer
Posts: 17062
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Re: Some data sources (RRD files) aren't created by poller

Post by TheWitness »

Okay, that's fixed in the 1.2.x branch. Thanks for reporting. Fix is here: https://github.com/Cacti/cacti/issues/4850
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
stefanbrudny
Cacti User
Posts: 130
Joined: Thu Jan 19, 2012 11:52 am

Re: Some data sources (RRD files) aren't created by poller

Post by stefanbrudny »

btw, some screens have been incorrect in previuos posts... (duplicates and incorrect, it was ~ 3:00am, excuse me)

I've done the upgrade but effect is exactly the same (except fix for #4850, below). My perception:
1. Poller runs fine, detects 15 graph, 19 data sources, in devices table presents the numbers fine
2. no data sources are yet created upon poller ending its job, as expected
3. by visiting graphs preview I get rrds created, but only 6 out of expected 18 - this is NOT as it should be
4. poller cache has 32 entires, 23 RRDs are expected, only 6 do exist, 9 graphs do show
Failed to open data file, poller may have not run yet.
5. Debug of data sources is similar as on 1.2.21, but data sources not created seem to be different every time I recreate them / device. It kinda looks that SNMP GETs issued to remote device are also fine, but I would have to spend more time if err here is suspected.

Screenshot_20220630_221934.png
Screenshot_20220630_221934.png (495.81 KiB) Viewed 1533 times
Boost debug log:

Code: Select all

DEBUG: Checking if Boost is ready to run.
DEBUG: Last Runtime was 2022-06-30 22:11:05 (1656619865).
DEBUG: Next Runtime is 2022-06-30 22:41:05 (1656621665).
DEBUG: Records Found:1841, Max Threshold:1000000.
DEBUG: Checking if Boost is ready to run.
DEBUG: Last Runtime was 2022-06-30 22:11:05 (1656619865).
DEBUG: Next Runtime is 2022-06-30 22:41:05 (1656621665).
DEBUG: Records Found:1841, Max Threshold:1000000.
DEBUG: Time to Run Boost, Force Run is false.
DEBUG: Parallel Process Setup Begins.
DEBUG: Data Sources:30, Concurrent Processes:5
DEBUG: Parallel Process Setup Complete.  Ready to spawn children.
DEBUG: About to launch 5 processes.
DEBUG: Launching Boost Process Number 1
Total[0.1359] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: /var/www/html/poller_boost.php --child=1 --debug]
DEBUG: Launching Boost Process Number 2
Total[0.1375] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: /var/www/html/poller_boost.php --child=2 --debug]
DEBUG: Launching Boost Process Number 3
Total[0.1391] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: /var/www/html/poller_boost.php --child=3 --debug]
DEBUG: Launching Boost Process Number 4
Total[0.1406] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: /var/www/html/poller_boost.php --child=4 --debug]
DEBUG: Launching Boost Process Number 5
Total[0.1425] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: /var/www/html/poller_boost.php --child=5 --debug]
DEBUG: Processing RRRtool Output for Boost Process 2
DEBUG: Processing RRRtool Output for Boost Process 1
DEBUG: Processes:2, TotalRows:8
DEBUG: Processing RRRtool Output for Boost Process 4
DEBUG: Processing 1 of 1 for Boost Process 2
DEBUG: Processes:1, TotalRows:18
DEBUG: Processes:4, TotalRows:25
DEBUG: Processing 1 of 1 for Boost Process 1
DEBUG: Processing 1 of 1 for Boost Process 4
DEBUG: Processing RRRtool Output for Boost Process 3
DEBUG: Processes:3, TotalRows:14
DEBUG: Updating Local Data Id:'218883', Template:traffic_in:traffic_out, Output:1656619861:U:U
DEBUG: Processing RRRtool Output for Boost Process 5
DEBUG: Processing 1 of 1 for Boost Process 3
DEBUG: Updating Local Data Id:'218964', Template:traffic_in:traffic_out, Output:1656619321:U:U 1656619622:U:U
OK u:0.01 s:0.00 r:0.02
OK u:0.01 s:0.00 r:0.01
DEBUG: Updating Local Data Id:'219082', Template:traffic_in:traffic_out, Output:1656619201:U:U 1656619261:U:U 1656619502:U:U 1656619562:U:U 1656619801:U:U 1656619861:U:U
DEBUG: Updating Local Data Id:'218908', Template:traffic_in:traffic_out, Output:1656619861:U:U
OK u:0.01 s:0.00 r:0.02
DEBUG: Updating Local Data Id:'218856', Template:traffic_in:traffic_out, Output:1656619801:U:U
OK u:0.00 s:0.00 r:0.02
DEBUG: Updating Local Data Id:'218928', Template:traffic_in:traffic_out, Output:1656619861:U:U
DEBUG: Updating Local Data Id:'219083', Template:traffic_in:traffic_out, Output:1656619261:U:U 1656619562:U:U 1656619622:U:U 1656619861:U:U
OK u:0.01 s:0.00 r:0.01
OK u:0.01 s:0.00 r:0.01
OK u:0.01 s:0.00 r:0.02
DEBUG: Updating Local Data Id:'218857', Template:traffic_in:traffic_out, Output:1656619201:U:U 1656619261:U:U 1656619502:U:U 1656619562:U:U 1656619861:U:U
OK u:0.00 s:0.00 r:0.02
DEBUG: Updating Local Data Id:'219084', Template:traffic_in:traffic_out, Output:1656619321:U:U 1656619381:U:U 1656619622:U:U 1656619682:U:U
DEBUG: Updating Local Data Id:'218933', Template:traffic_in:traffic_out, Output:1656619562:U:U 1656619622:U:U 1656619861:U:U
DEBUG: Updating Local Data Id:'218858', Template:traffic_in:traffic_out, Output:1656619321:U:U
DEBUG: Updating Local Data Id:'218947', Template:traffic_in:traffic_out, Output:1656619201:U:U
DEBUG: Updating Local Data Id:'219085', Template:traffic_in:traffic_out, Output:1656619381:U:U 1656619441:U:U 1656619682:U:U 1656619742:U:U
OK u:0.00 s:0.00 r:0.02
DEBUG: Updating Local Data Id:'218950', Template:traffic_in:traffic_out, Output:1656619742:U:U
DEBUG: Updating Local Data Id:'219086', Template:traffic_in:traffic_out, Output:1656619201:U:U 1656619441:U:U 1656619502:U:U 1656619742:U:U 1656619801:U:U
DEBUG: Updating Local Data Id:'218859', Template:traffic_in:traffic_out, Output:1656619321:U:U 1656619381:U:U 1656619682:U:U
OK u:0.01 s:0.00 r:0.02
OK u:0.01 s:0.00 r:0.02
OK u:0.01 s:0.00 r:0.01
OK u:0.01 s:0.00 r:0.02
OK u:0.01 s:0.00 r:0.01
OK u:0.01 s:0.00 r:0.01
OK u:0.00 s:0.00 r:0.02
DEBUG: Processes:5, TotalRows:12
DEBUG: Updating Local Data Id:'218860', Template:traffic_in:traffic_out, Output:1656619441:U:U 1656619742:U:U
OK u:0.00 s:0.00 r:0.02
DEBUG: Processing 1 of 1 for Boost Process 5
DEBUG: Processing Complete for Boost Process 2.  It took 2 passed to complete.
DEBUG: Processing Complete for Boost Process 4.  It took 2 passed to complete.
DEBUG: Updating Local Data Id:'218882', Template:traffic_in:traffic_out, Output:1656619201:U:U 1656619261:U:U 1656619502:U:U 1656619562:U:U 1656619801:U:U 1656619861:U:U
OK u:0.00 s:0.00 r:0.02
DEBUG: Processing Complete for Boost Process 1.  It took 2 passed to complete.
2022-06-30 22:42:02 - SYSTEM BOOST STATS: Time:0.04 ProcessNumber:2 RRDUpdates:8
2022-06-30 22:42:02 - SYSTEM BOOST STATS: Time:0.04 ProcessNumber:4 RRDUpdates:25
2022-06-30 22:42:02 - SYSTEM BOOST STATS: Time:0.04 ProcessNumber:1 RRDUpdates:18
DEBUG: Updating Local Data Id:'218951', Template:traffic_in:traffic_out, Output:1656619801:U:U
OK u:0.00 s:0.01 r:0.01
DEBUG: Updating Local Data Id:'218952', Template:traffic_in:traffic_out, Output:1656619562:U:U 1656619861:U:U
OK u:0.00 s:0.01 r:0.01
DEBUG: Updating Local Data Id:'218953', Template:traffic_in:traffic_out, Output:1656619261:U:U 1656619321:U:U 1656619562:U:U 1656619861:U:U
OK u:0.00 s:0.01 r:0.01
DEBUG: Updating Local Data Id:'219692', Template:Device_Reads:Device_Writes, Output:1656621721:1355:2
OK u:0.00 s:0.01 r:0.01
DEBUG: Updating Local Data Id:'218956', Template:traffic_in:traffic_out, Output:1656619201:U:U 1656619502:U:U 1656619801:U:U
OK u:0.00 s:0.01 r:0.01
DEBUG: Updating Local Data Id:'219693', Template:Device_Reads:Device_Writes, Output:1656621721:1040705:1234401
OK u:0.00 s:0.01 r:0.01
DEBUG: Updating Local Data Id:'218958', Template:traffic_in:traffic_out, Output:1656619261:U:U
DEBUG: Updating Local Data Id:'219694', Template:Device_Reads:Device_Writes, Output:1656621721:117970:100903
OK u:0.00 s:0.01 r:0.02
DEBUG: Updating Local Data Id:'218959', Template:traffic_in:traffic_out, Output:1656619381:U:U 1656619622:U:U 1656619682:U:U
OK u:0.00 s:0.01 r:0.01
OK u:0.00 s:0.01 r:0.02
DEBUG: Updating Local Data Id:'219695', Template:Device_Reads:Device_Writes, Output:1656621721:254866:9599829
OK u:0.00 s:0.01 r:0.01
DEBUG: Updating Local Data Id:'219696', Template:Device_Reads:Device_Writes, Output:1656621721:157:31
OK u:0.00 s:0.01 r:0.02
DEBUG: Updating Local Data Id:'219697', Template:Device_Reads:Device_Writes, Output:1656621721:1415208:10935166
DEBUG: Processing Complete for Boost Process 3.  It took 2 passed to complete.
OK u:0.00 s:0.01 r:0.02
DEBUG: Processing Complete for Boost Process 5.  It took 2 passed to complete.
2022-06-30 22:42:02 - SYSTEM BOOST STATS: Time:0.04 ProcessNumber:3 RRDUpdates:14
2022-06-30 22:42:02 - SYSTEM BOOST STATS: Time:0.03 ProcessNumber:5 RRDUpdates:12
2022-06-30 22:42:04 - SYSTEM BOOST STATS: Time:2.12 RRDUpdates:77
DEBUG: Checking if Boost is ready to run.
DEBUG: Last Runtime was 2022-06-30 22:42:02 (1656621722).                                                                                                                                                   DEBUG: Next Runtime is 2022-06-30 23:12:02 (1656623522).                                                                                                                                                    DEBUG: Records Found:1841, Max Threshold:1000000.

Still same error (note, that this is somewhat different to what you are reproducing)
Screenshot_20220630_224620.png
Screenshot_20220630_224620.png (212.54 KiB) Viewed 1533 times
I also tested removing all rra paths manually, boost will recreate paths only to a limited number of some rrds at boosts next run ( fix for #4850 confirmed). Original issue persist.

What else shall I check? Shall I copy the vm and provide access so its easier to debug? I'd prefer to not waste your time, lets use some of mine.
Top
User avatar
TheWitness
Developer
Posts: 17062
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Re: Some data sources (RRD files) aren't created by poller

Post by TheWitness »

Run this query for the problem host(s);

Code: Select all

select rrd_step, rrd_next_step, count(*) from poller_item group by rrd_step, rrd_next_step;
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
stefanbrudny
Cacti User
Posts: 130
Joined: Thu Jan 19, 2012 11:52 am

Re: Some data sources (RRD files) aren't created by poller

Post by stefanbrudny »

Code: Select all

mysql> select rrd_step, rrd_next_step, count(*) from poller_item group by rrd_step, rrd_next_step;
+----------+---------------+----------+
| rrd_step | rrd_next_step | count(*) |
+----------+---------------+----------+
|      300 |            60 |      320 |
|      300 |           120 |      318 |
|      300 |           180 |      318 |
|      300 |           240 |      316 |
|      300 |             0 |      320 |
|       60 |             0 |       32 |
+----------+---------------+----------+
6 rows in set (0.00 sec)

mysql> select rrd_step, rrd_next_step, count(*) from poller_item group by rrd_step, rrd_next_step;
+----------+---------------+----------+
| rrd_step | rrd_next_step | count(*) |
+----------+---------------+----------+
|      300 |            60 |      320 |
|      300 |           120 |      318 |
|      300 |           180 |      318 |
|      300 |           240 |      316 |
|      300 |             0 |      320 |
|       60 |             0 |       32 |
+----------+---------------+----------+
6 rows in set (0.01 sec)

mysql> select rrd_step, rrd_next_step, count(*) from poller_item group by rrd_step, rrd_next_step;
+----------+---------------+----------+
| rrd_step | rrd_next_step | count(*) |
+----------+---------------+----------+
|      300 |            60 |      320 |
|      300 |           120 |      318 |
|      300 |           180 |      318 |
|      300 |           240 |      316 |
|      300 |             0 |      320 |
|       60 |             0 |       32 |
+----------+---------------+----------+
Top
User avatar
TheWitness
Developer
Posts: 17062
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Re: Some data sources (RRD files) aren't created by poller

Post by TheWitness »

Screen shot of your Console > Configure > Settings > Poller page. Just the top section.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
User avatar
TheWitness
Developer
Posts: 17062
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Re: Some data sources (RRD files) aren't created by poller

Post by TheWitness »

Another Query to run:

Code: Select all

select pi.rrd_step, pi.rrd_next_step, data_source_profile_id, count(*) 
from poller_item as pi 
inner join data_template_data AS dtd 
on dtd.local_data_id=pi.local_data_id 
group by pi.rrd_step, pi.rrd_next_step, data_source_profile_id;
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
Post Reply

Return to “Help: General”

Who is online

Users browsing this forum: No registered users and 2 guests