doing a new 1.2.15 install on Centos 7, used yum install cacti cacti-spine, initially had a hiccup with permission to /usr/share/cacti/rra, chown apache; installation completed, just setting so far the Cacti host itself, but seeing such errors in log *1
just noticed my cacti host is 'duplicated' as a device, that's not causing harm ?
what did I stuff up? what do I need to do ? (in small steps, please...)
Voytek
All 5 Devices
Local Linux Machine 192.168.1.8 1 7 8 Up 55m 2d:10h:58m 0.04 0.15 0.15 100 %
Cacti 192.168.1.8 2 3 3 Up 55m 2d:10h:58m 0.07 0.36 0.31 100 %
i7W10P 192.168.1.28 3 4 4 Up 50m 1d:16h:44m 0.15 0.66 0.88 100 %
DESKTOP-IPTV 192.168.1.18 4 4 4 Up 50m 14d:19h:0m 0.13 1.16 1.17 100 %
NAS01 192.168.1.2 5 12 19 Up 50m 132d:20h:22m 0.07 2.02 1.88 100 %
saw another forum thread, tried
MariaDB [cacti]> CHECK TABLE `poller_output`;
+---------------------+-------+----------+--------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------+-------+----------+--------------------------------------------------------+
| cacti.poller_output | check | note | The storage engine for the table doesn't support check |
+---------------------+-------+----------+--------------------------------------------------------+
1 row in set (0.00 sec)
MariaDB [cacti]> OPTIMIZE TABLE `poller_output`;
+---------------------+----------+----------+-----------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------+----------+----------+-----------------------------------------------------------+
| cacti.poller_output | optimize | note | The storage engine for the table doesn't support optimize |
+---------------------+----------+----------+-----------------------------------------------------------+
1 row in set (0.00 sec)
Table: poller_output
Space usage
Data 20.9 KiB
Index 0 B
Overhead 20.8 KiB
Effective 20 B
Total 20.9 KiB
Row statistics
Format static
Collation utf8mb4_unicode_ci
Rows 0
Row length 2,134 B
Creation Nov 06, 2021 at 10:33 PM
mysql Ver 15.1 Distrib 5.5.68-MariaDB, for Linux (x86_64) using readline 5.1
Connection id: 384
Current database: cacti
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MariaDB
Server version: 5.5.68-MariaDB MariaDB Server
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 10 hours 32 min 6 sec
Threads: 11 Questions: 241843 Slow queries: 0 Opens: 476 Flush tables: 2 Open tables: 143 Queries per second avg: 6.376
Linux 3.10.0-1160.45.1.el7.x86_64 #1 SMP Wed Oct 13 17:20:51 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux
*1 logs:
-----
11/07/2021 09:00:03 - SYSTEM STATS: Time:1.2440 Method:spine Processes:1 Threads:1 Hosts:5 HostsPerProcess:5 DataSources:34 RRDsProcessed:10
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] Device[Local Linux Machine] DEBUG Falling back to UDP Ping Due to SetUID Issues
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] DEBUG: The Value of Active Threads is 0 for Device ID 2
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] Device[Cacti] HT[1] DEBUG: HOST COMPLETE: About to Exit Device Polling Thread Function
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] Device[Cacti] HT[1] Total Time: 0.052 Seconds
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] ERROR: SQL Failed! Error:'1114', Message:'The table 'poller_output' is full', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (52,'hdd_free','2021-11-07 09:00:02','163110404'),(52,'hdd_used','2021-11-07 09:00:02','24366140'),(53,'hdd_free','2021-11-07 09:00:02','48768044'),(53,'hdd_used','2021-11-07 09:00:02','3635156'),(54,'hdd_free','2021-11-07 09:00:02','831080'),(54,'hdd_used','2021-11-07 09:00:02','207256') ON DUPLICATE KEY UPDATE output=VALUES(output)'
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] Device[Cacti] HT[1] DS[Cacti - Free Space - /dev/sda1] Graphs[Cacti - Disk Space - /dev/sda1] SCRIPT: perl /usr/share/cacti/scripts/query_unix_partitions.pl 'get' 'used' '/dev/sda1', output: 207256
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] Device[Cacti] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] Device[Cacti] HT[1] DS[Cacti - Free Space - /dev/sda1] Graphs[Cacti - Disk Space - /dev/sda1] SCRIPT: perl /usr/share/cacti/scripts/query_unix_partitions.pl 'get' 'available' '/dev/sda1', output: 831080
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] Device[Cacti] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] Device[Cacti] HT[1] DS[Cacti - Free Space - /dev/mapper/centos_wcr-root] Graphs[Cacti - Disk Space - /dev/mapper/centos_wcr-root] SCRIPT: perl /usr/share/cacti/scripts/query_unix_partitions.pl 'get' 'used' '/dev/mapper/centos_wcr-root', output: 3635156
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] Device[Cacti] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] Device[Cacti] HT[1] DS[Cacti - Free Space - /dev/mapper/centos_wcr-root] Graphs[Cacti - Disk Space - /dev/mapper/centos_wcr-root] SCRIPT: perl /usr/share/cacti/scripts/query_unix_partitions.pl 'get' 'available' '/dev/mapper/centos_wcr-root', output: 48768044
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] Device[Cacti] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] Device[Cacti] HT[1] DS[Cacti - Free Space - /dev/mapper/centos_wcr-home] Graphs[Cacti - Disk Space - /dev/mapper/centos_wcr-home] SCRIPT: perl /usr/share/cacti/scripts/query_unix_partitions.pl 'get' 'used' '/dev/mapper/centos_wcr-home', output: 24366140
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30753] ERROR: SQL Failed! Error:'1114', Message:'The table 'poller_output' is full', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (63,'polling_time','2021-11-07 09:00:02','0.072'),(64,'uptime','2021-11-07 09:00:02','1147785397'),(65,'load_1min','2021-11-07 09:00:02','U'),(66,'load_15min','2021-11-07 09:00:02','U'),(67,'load_5min','2021-11-07 09:00:02','U'),(68,'mem_buffers','2021-11-07 09:00:02','U'),(69,'mem_cache','2021-11-07 09:00:02','U'),(70,'mem_free','2021-11-07 09:00:02','U'),(71,'mem_total','2021-11-07 09:00:02','U'),(72,'users','2021-11-07 09:00:02','0'),(73,'proc','2021-11-07 09:00:02','169'),(74,'ssCpuIdle','2021-11-07 09:00:02','U'),(75,'ssCpuSystem','2021-11-07 09:00:02','U'),(76,'ssCpuUser','2021-11-07 09:00:02','U'),(77,'ssSysInterrupts','2021-11-07 09:00:02','U'),(78,'ssSysContext','2021-11-07 09:00:02','U'),(79,'','2021-11-07 09:00:02','reads:0 writes:0'),(80,'','2021-11-07 09:00:02','bytesread:0 byteswritten:0'),(81,'traffic_in','2021-11-07 09:00:02','6589264442459'),(81,'traffic_out','2021-11-07 09:00:02','311854955019') ON DUPLICATE KEY UPDATE output=VALUES(output)'
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] Device[Cacti] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] Device[Cacti] HT[1] DS[Cacti - Free Space - /dev/mapper/centos_wcr-home] Graphs[Cacti - Disk Space - /dev/mapper/centos_wcr-home] SCRIPT: perl /usr/share/cacti/scripts/query_unix_partitions.pl 'get' 'available' '/dev/mapper/centos_wcr-home', output: 163110404
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] Device[Cacti] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] Device[Cacti] HT[1] NOTE: There are '6' Polling Items for this Device
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] Device[Cacti] HT[1] DQ[Unix - Get Mounted Partitions] RECACHE OID: .1.3.6.1.2.1.1.3.0, (assert: 21169462 < output: 21199531)
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] Device[Cacti] HT[1] DQ[Cacti Stats - Data Collector Stats] RECACHE OID: .1.3.6.1.2.1.1.3.0, (assert: 21169462 < output: 21199531)
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] Device[Cacti] HT[1] RECACHE: Processing 2 items in the auto reindex cache for '192.168.1.8'
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] NOTE: Device[Cacti] Updating Full System Information Table
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] Device[Cacti] DEBUG: Entering SNMP Ping
2021/11/07 09:00:02 - SPINE: Poller[Main Poller] PID[30745] DEBUG: In Poller, About to Start Polling of Device for Device ID 2
11/07/2021 08:55:02 - SYSTEM STATS: Time:1.2439 Method:spine Processes:1 Threads:1 Hosts:5 HostsPerProcess:5 DataSources:34 RRDsProcessed:10
2021/11/07 08:55:02 - SPINE: Poller[Main Poller] PID[30657] Device[Local Linux Machine] DEBUG Falling back to UDP Ping Due to SetUID Issues
2021/11/07 08:55:02 - SPINE: Poller[Main Poller] PID[30657] DEBUG: The Value of Active Threads is 0 for Device ID 2
2021/11/07 08:55:02 - SPINE: Poller[Main Poller] PID[30657] Device[Cacti] HT[1] DEBUG: HOST COMPLETE: About to Exit Device Polling Thread Function
2021/11/07 08:55:02 - SPINE: Poller[Main Poller] PID[30657] Device[Cacti] HT[1] Total Time: 0.053 Seconds
2021/11/07 08:55:02 - SPINE: Poller[Main Poller] PID[30657] ERROR: SQL Failed! Error:'1114', Message:'The table 'poller_output' is full', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (52,'hdd_free','2021-11-07 08:55:01','163110404'),(52,'hdd_used','2021-11-07 08:55:01','24366140'),(53,'hdd_free','2021-11-07 08:55:01','48776588'),(53,'hdd_used','2021-11-07 08:55:01','3626636'),(54,'hdd_free','2021-11-07 08:55:01','831080'),(54,'hdd_used','2021-11-07 08:55:01','207256') ON DUPLICATE KEY UPDATE output=VALUES(output)'
2021/11/07 08:55:02 - SPINE: Poller[Main Poller] PID[30657] Device[Cacti] HT[1] DS[Cacti - Free Space - /dev/sda1] Graphs[Cacti - Disk Space - /dev/sda1] SCRIPT: perl /usr/share/cacti/scripts/query_unix_partitions.pl 'get' 'used' '/dev/sda1', output: 207256
2021/11/07 08:55:01 - SPINE: Poller[Main Poller] PID[30657] Device[Cacti] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
2021/11/07 08:55:01 - SPINE: Poller[Main Poller] PID[30657] Device[Cacti] HT[1] DS[Cacti - Free Space - /dev/sda1] Graphs[Cacti - Disk Space - /dev/sda1] SCRIPT: perl /usr/share/cacti/scripts/query_unix_partitions.pl 'get' 'available' '/dev/sda1', output: 831080
2021/11/07 08:55:01 - SPINE: Poller[Main Poller] PID[30657] Device[Cacti] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
2021/11/07 08:55:01 - SPINE: Poller[Main Poller] PID[30657] Device[Cacti] HT[1] DS[Cacti - Free Space - /dev/mapper/centos_wcr-root] Graphs[Cacti - Disk Space - /dev/mapper/centos_wcr-root] SCRIPT: perl /usr/share/cacti/scripts/query_unix_partitions.pl 'get' 'used' '/dev/mapper/centos_wcr-root', output: 3626636
2021/11/07 08:55:01 - SPINE: Poller[Main Poller] PID[30665] ERROR: SQL Failed! Error:'1114', Message:'The table 'poller_output' is full', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (63,'polling_time','2021-11-07 08:55:01','0.07'),(64,'uptime','2021-11-07 08:55:01','1147755329'),(65,'load_1min','2021-11-07 08:55:01','U'),(66,'load_15min','2021-11-07 08:55:01','U'),(67,'load_5min','2021-11-07 08:55:01','U'),(68,'mem_buffers','2021-11-07 08:55:01','U'),(69,'mem_cache','2021-11-07 08:55:01','U'),(70,'mem_free','2021-11-07 08:55:01','U'),(71,'mem_total','2021-11-07 08:55:01','U'),(72,'users','2021-11-07 08:55:01','0'),(73,'proc','2021-11-07 08:55:01','167'),(74,'ssCpuIdle','2021-11-07 08:55:01','U'),(75,'ssCpuSystem','2021-11-07 08:55:01','U'),(76,'ssCpuUser','2021-11-07 08:55:01','U'),(77,'ssSysInterrupts','2021-11-07 08:55:01','U'),(78,'ssSysContext','2021-11-07 08:55:01','U'),(79,'','2021-11-07 08:55:01','reads:0 writes:0'),(80,'','2021-11-07 08:55:01','bytesread:0 byteswritten:0'),(81,'traffic_in','2021-11-07 08:55:01','6589153354303'),(81,'traffic_out','2021-11-07 08:55:01','311850612356') ON DUPLICATE KEY UPDATE output=VALUES(output)'
2021/11/07 08:55:01 - SPINE: Poller[Main Poller] PID[30657] Device[Cacti] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
2021/11/07 08:55:01 - SPINE: Poller[Main Poller] PID[30657] Device[Cacti] HT[1] DS[Cacti - Free Space - /dev/mapper/centos_wcr-root] Graphs[Cacti - Disk Space - /dev/mapper/centos_wcr-root] SCRIPT: perl /usr/share/cacti/scripts/query_unix_partitions.pl 'get' 'available' '/dev/mapper/centos_wcr-root', output: 48776588
2021/11/07 08:55:01 - SPINE: Poller[Main Poller] PID[30657] Device[Cacti] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
2021/11/07 08:55:01 - SPINE: Poller[Main Poller] PID[30657] Device[Cacti] HT[1] DS[Cacti - Free Space - /dev/mapper/centos_wcr-home] Graphs[Cacti - Disk Space - /dev/mapper/centos_wcr-home] SCRIPT: perl /usr/share/cacti/scripts/query_unix_partitions.pl 'get' 'used' '/dev/mapper/centos_wcr-home', output: 24366140
2021/11/07 08:55:01 - SPINE: Poller[Main Poller] PID[30657] Device[Cacti] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
2021/11/07 08:55:01 - SPINE: Poller[Main Poller] PID[30657] Device[Cacti] HT[1] DS[Cacti - Free Space - /dev/mapper/centos_wcr-home] Graphs[Cacti - Disk Space - /dev/mapper/centos_wcr-home] SCRIPT: perl /usr/share/cacti/scripts/query_unix_partitions.pl 'get' 'available' '/dev/mapper/centos_wcr-home', output: 163110404
2021/11/07 08:55:01 - SPINE: Poller[Main Poller] PID[30657] Device[Cacti] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
2021/11/07 08:55:01 - SPINE: Poller[Main Poller] PID[30657] Device[Cacti] HT[1] NOTE: There are '6' Polling Items for this Device
2021/11/07 08:55:01 - SPINE: Poller[Main Poller] PID[30657] Device[Cacti] HT[1] DQ[Unix - Get Mounted Partitions] RECACHE OID: .1.3.6.1.2.1.1.3.0, (assert: 21139480 < output: 21169462)
2021/11/07 08:55:01 - SPINE: Poller[Main Poller] PID[30657] Device[Cacti] HT[1] DQ[Cacti Stats - Data Collector Stats] RECACHE OID: .1.3.6.1.2.1.1.3.0, (assert: 21139480 < output: 21169462)
2021/11/07 08:55:01 - SPINE: Poller[Main Poller] PID[30657] Device[Cacti] HT[1] RECACHE: Processing 2 items in the auto reindex cache for '192.168.1.8'
2021/11/07 08:55:01 - SPINE: Poller[Main Poller] PID[30657] NOTE: Device[Cacti] Updating Full System Information Table
2021/11/07 08:55:01 - SPINE: Poller[Main Poller] PID[30657] Device[Cacti] DEBUG: Entering SNMP Ping
2021/11/07 08:55:01 - SPINE: Poller[Main Poller] PID[30657] DEBUG: In Poller, About to Start Polling of Device for Device ID 2
11/07/2021 08:50:03 - SYSTEM STATS: Time:1.2402 Method:spine Processes:1 Threads:1 Hosts:5 HostsPerProcess:5 DataSources:34 RRDsProcessed:7
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] Device[Local Linux Machine] DEBUG Falling back to UDP Ping Due to SetUID Issues
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] ERROR: SQL Failed! Error:'1114', Message:'The table 'poller_output' is full', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (59,'polling_time','2021-11-07 08:50:02','0.041'),(60,'uptime','2021-11-07 08:50:02','127710429'),(61,'users','2021-11-07 08:50:02','2'),(62,'proc','2021-11-07 08:50:02','146') ON DUPLICATE KEY UPDATE output=VALUES(output)'
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30572] ERROR: SQL Failed! Error:'1114', Message:'The table 'poller_output' is full', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (63,'polling_time','2021-11-07 08:50:02','0.071'),(64,'uptime','2021-11-07 08:50:02','1147725362'),(65,'load_1min','2021-11-07 08:50:02','U'),(66,'load_15min','2021-11-07 08:50:02','U'),(67,'load_5min','2021-11-07 08:50:02','U'),(68,'mem_buffers','2021-11-07 08:50:02','U'),(69,'mem_cache','2021-11-07 08:50:02','U'),(70,'mem_free','2021-11-07 08:50:02','U'),(71,'mem_total','2021-11-07 08:50:02','U'),(72,'users','2021-11-07 08:50:02','0'),(73,'proc','2021-11-07 08:50:02','165'),(74,'ssCpuIdle','2021-11-07 08:50:02','U'),(75,'ssCpuSystem','2021-11-07 08:50:02','U'),(76,'ssCpuUser','2021-11-07 08:50:02','U'),(77,'ssSysInterrupts','2021-11-07 08:50:02','U'),(78,'ssSysContext','2021-11-07 08:50:02','U'),(79,'','2021-11-07 08:50:02','reads:0 writes:0'),(80,'','2021-11-07 08:50:02','bytesread:0 byteswritten:0'),(81,'traffic_in','2021-11-07 08:50:02','6589048763039'),(81,'traffic_out','2021-11-07 08:50:02','311846558487') ON DUPLICATE KEY UPDATE output=VALUES(output)'
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] DEBUG: The Value of Active Threads is 0 for Device ID 2
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] Device[Cacti] HT[1] DEBUG: HOST COMPLETE: About to Exit Device Polling Thread Function
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] Device[Cacti] HT[1] Total Time: 0.065 Seconds
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] Device[Cacti] HT[1] DS[Cacti - Free Space - /dev/sda1] Graphs[Cacti - Disk Space - /dev/sda1] SCRIPT: perl /usr/share/cacti/scripts/query_unix_partitions.pl 'get' 'used' '/dev/sda1', output: 207256
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] Device[Cacti] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] Device[Cacti] HT[1] DS[Cacti - Free Space - /dev/sda1] Graphs[Cacti - Disk Space - /dev/sda1] SCRIPT: perl /usr/share/cacti/scripts/query_unix_partitions.pl 'get' 'available' '/dev/sda1', output: 831080
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] Device[Cacti] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] Device[Cacti] HT[1] DS[Cacti - Free Space - /dev/mapper/centos_wcr-root] Graphs[Cacti - Disk Space - /dev/mapper/centos_wcr-root] SCRIPT: perl /usr/share/cacti/scripts/query_unix_partitions.pl 'get' 'used' '/dev/mapper/centos_wcr-root', output: 3635004
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] Device[Cacti] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] Device[Cacti] HT[1] DS[Cacti - Free Space - /dev/mapper/centos_wcr-root] Graphs[Cacti - Disk Space - /dev/mapper/centos_wcr-root] SCRIPT: perl /usr/share/cacti/scripts/query_unix_partitions.pl 'get' 'available' '/dev/mapper/centos_wcr-root', output: 48768196
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] Device[Cacti] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] Device[Cacti] HT[1] DS[Cacti - Free Space - /dev/mapper/centos_wcr-home] Graphs[Cacti - Disk Space - /dev/mapper/centos_wcr-home] SCRIPT: perl /usr/share/cacti/scripts/query_unix_partitions.pl 'get' 'used' '/dev/mapper/centos_wcr-home', output: 24366140
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] Device[Cacti] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] Device[Cacti] HT[1] DS[Cacti - Free Space - /dev/mapper/centos_wcr-home] Graphs[Cacti - Disk Space - /dev/mapper/centos_wcr-home] SCRIPT: perl /usr/share/cacti/scripts/query_unix_partitions.pl 'get' 'available' '/dev/mapper/centos_wcr-home', output: 163110404
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] Device[Cacti] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] Device[Cacti] HT[1] NOTE: There are '6' Polling Items for this Device
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] Device[Cacti] HT[1] DQ[Unix - Get Mounted Partitions] RECACHE OID: .1.3.6.1.2.1.1.3.0, (assert: 21109526 < output: 21139480)
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] Device[Cacti] HT[1] DQ[Cacti Stats - Data Collector Stats] RECACHE OID: .1.3.6.1.2.1.1.3.0, (assert: 21109526 < output: 21139480)
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] Device[Cacti] HT[1] RECACHE: Processing 2 items in the auto reindex cache for '192.168.1.8'
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] NOTE: Device[Cacti] Updating Full System Information Table
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] Device[Cacti] DEBUG: Entering SNMP Ping
2021/11/07 08:50:02 - SPINE: Poller[Main Poller] PID[30564] DEBUG: In Poller, About to Start Polling of Device for Device ID 2
11/07/2021 08:45:03 - SYSTEM STATS: Time:1.2447 Method:spine Processes:1 Threads:1 Hosts:5 HostsPerProcess:5 DataSources:34 RRDsProcessed:10
2021/11/07 08:45:02 - SPINE: Poller[Main Poller] PID[30249] DEBUG: The Value of Active Threads is 0 for Device ID 2
2021/11/07 08:45:02 - SPINE: Poller[Main Poller] PID[30249] Device[Cacti] HT[1] DEBUG: HOST COMPLETE: About to Exit Device Polling Thread Function
2021/11/07 08:45:02 - SPINE: Poller[Main Poller] PID[30249] Device[Cacti] HT[1] Total Time: 0.057 Seconds
2021/11/07 08:45:02 - SPINE: Poller[Main Poller] PID[30249] ERROR: SQL Failed! Error:'1114', Message:'The table 'poller_output' is full', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (52,'hdd_free','2021-11-07 08:45:02','163110404'),(52,'hdd_used','2021-11-07 08:45:02','24366140'),(53,'hdd_free','2021-11-07 08:45:02','48776540'),(53,'hdd_used','2021-11-07 08:45:02','3626660'),(54,'hdd_free','2021-11-07 08:45:02','831080'),(54,'hdd_used','2021-11-07 08:45:02','207256') ON DUPLICATE KEY UPDATE output=VALUES(output)'
2021/11/07 08:45:02 - SPINE: Poller[Main Poller] PID[30249] Device[Cacti] HT[1] DS[Cacti - Free Space - /dev/sda1] Graphs[Cacti - Disk Space - /dev/sda1] SCRIPT: perl /usr/share/cacti/scripts/query_unix_partitions.pl 'get' 'used' '/dev/sda1', output: 207256
2021/11/07 08:45:02 - SPINE: Poller[Main Poller] PID[30249] Device[Cacti] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
2021/11/07 08:45:02 - SPINE: Poller[Main Poller] PID[30249] Device[Cacti] HT[1] DS[Cacti - Free Space - /dev/sda1] Graphs[Cacti - Disk Space - /dev/sda1] SCRIPT: perl /usr/share/cacti/scripts/query_unix_partitions.pl 'get' 'available' '/dev/sda1', output: 831080
2021/11/07 08:45:02 - SPINE: Poller[Main Poller] PID[30257] ERROR: SQL Failed! Error:'1114', Message:'The table 'poller_output' is full', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (63,'polling_time','2021-11-07 08:45:02','0.07'),(64,'uptime','2021-11-07 08:45:02','1147695396'),(65,'load_1min','2021-11-07 08:45:02','U'),(66,'load_15min','2021-11-07 08:45:02','U'),(67,'load_5min','2021-11-07 08:45:02','U'),(68,'mem_buffers','2021-11-07 08:45:02','U'),(69,'mem_cache','2021-11-07 08:45:02','U'),(70,'mem_free','2021-11-07 08:45:02','U'),(71,'mem_total','2021-11-07 08:45:02','U'),(72,'users','2021-11-07 08:45:02','0'),(73,'proc','2021-11-07 08:45:02','168'),(74,'ssCpuIdle','2021-11-07 08:45:02','U'),(75,'ssCpuSystem','2021-11-07 08:45:02','U'),(76,'ssCpuUser','2021-11-07 08:45:02','U'),(77,'ssSysInterrupts','2021-11-07 08:45:02','U'),(78,'ssSysContext','2021-11-07 08:45:02','U'),(79,'','2021-11-07 08:45:02','reads:0 writes:0'),(80,'','2021-11-07 08:45:02','bytesread:0 byteswritten:0'),(81,'traffic_in','2021-11-07 08:45:02','6588944671438'),(81,'traffic_out','2021-11-07 08:45:02','311842257390') ON DUPLICATE KEY UPDATE output=VALUES(output)'
2
SQL Failed! Error:'1114', 'The table 'poller_output' is full'
Moderators: Developers, Moderators
Who is online
Users browsing this forum: No registered users and 1 guest