Spine: MySQL server has gone away

xefil · Post by **xefil** » Wed May 10, 2017 3:49 am

Hello to all,

I'm having a problem with my new server. I'm trying to update from 0.8.8a to 1.1.6.
The update process seems gone well, but cannot confirm because the poller won't work.
I'm getting this issue:

Code: Select all

SPINE: Poller[1] ERROR: SQL Failed! Error:'2006', Message:'MySQL server has gone away', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES ...

Here some system infos:

CentOS 7.3.1611
Cacti 1.1.6
Spine 1.1.6 (stable and devel tested as well):

Code: Select all

[root@cacti /data/spine]# ldd ./spine
        linux-vdso.so.1 =>  (0x00007ffcca5cf000)
        libssl.so.10 => /lib64/libssl.so.10 (0x00007f28f1618000)
        libnetsnmp.so.31 => /lib64/libnetsnmp.so.31 (0x00007f28f1316000)
        libmysqlclient.so.18 => /lib64/libmysqlclient.so.18 (0x00007f28f0d71000)
        libcrypto.so.10 => /lib64/libcrypto.so.10 (0x00007f28f0987000)
        libz.so.1 => /lib64/libz.so.1 (0x00007f28f0771000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f28f0554000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f28f0252000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f28efe91000)
        libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007f28efc42000)
        libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007f28ef95b000)
        libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007f28ef757000)
        libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007f28ef524000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f28ef320000)
        libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007f28ef017000)
        /lib64/ld-linux-x86-64.so.2 (0x00007f28f1892000)
        libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007f28eee07000)
        libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007f28eec03000)
        libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f28ee9e9000)
        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f28ee7d2000)
        libselinux.so.1 => /lib64/libselinux.so.1 (0x00007f28ee5ab000)
        libpcre.so.1 => /lib64/libpcre.so.1 (0x00007f28ee349000)

Maximum Concurrent Poller Processes: 1
Maximum Threads per Process: 8
Number of PHP Script Servers: 6

MySQL Server MariaDB: MariaDB-shared-10.1.23-1.el7.centos.x86_64 MariaDB-client-10.1.23-1.el7.centos.x86_64 MariaDB-server-10.1.23-1.el7.centos.x86_64 MariaDB-common-10.1.23-1.el7.centos.x86_64 MariaDB-devel-10.1.23-1.el7.centos.x86_64

Code: Select all

MariaDB [(none)]> select @@version;
+-----------------+
| @@version       |
+-----------------+
| 10.1.23-MariaDB |
+-----------------+
1 row in set (0.00 sec)
MariaDB [(none)]> show variables like 'max_allowed_packet';
+--------------------+----------+
| Variable_name      | Value    |
+--------------------+----------+
| max_allowed_packet | 33554432 |
+--------------------+----------+
1 row in set (0.00 sec)

MariaDB [(none)]> show variables like 'wait_timeout';      
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout  | 28800 |
+---------------+-------+
1 row in set (0.00 sec)

MariaDB [(none)]>

All deledencies during setup (MySQL suggestions) are satisfied.

Suggestions?
Way to debug?

Thanks,

Simon

Osiris · Post by **Osiris** » Wed May 10, 2017 4:50 am

Max connections? Have you run from commandline?

./spine -R -V 3 -S

xefil · Post by **xefil** » Wed May 10, 2017 5:00 am

Osiris wrote:Max connections? Have you run from commandline?

./spine -R -V 3 -S

Code: Select all

MariaDB [(none)]> show status like '%Max_used_connections%';
+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| Max_used_connections | 353   |
+----------------------+-------+
1 row in set (0.00 sec)

MariaDB [(none)]> show variables like 'max_connections';  
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 500   |
+-----------------+-------+
1 row in set (0.00 sec)

About cli execution, alreay done, but cannot find someting interesting, expect ending with:

Code: Select all

# ./spine -R -V 3 -S
(...)
FATAL: MySQL Error:'2006', Message:'MySQL server has gone away' [9, Bad file descriptor] (Spine thread)

xefil · Post by **xefil** » Wed May 10, 2017 7:55 am

I've tried logging the queries on the SQL server and checking constantly with 'show processlist' the status of the server.
MySQL server (seems) never died.

Ideas?

Thanks, Simon

xefil · Post by **xefil** » Thu May 11, 2017 9:13 am

Hello,

Nobody can help ?

I'm trying to update a single host as well, no errors, but the rrd are not updated

Why?

Code: Select all

[root@cacti /data/spine]# ./spine -V 10 -S -f 10 -l 10 
SPINE: Using spine config file [spine.conf]
2017-05-11 16:09:51 - SPINE: Poller[1] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'path_webroot''
2017-05-11 16:09:51 - SPINE: Poller[1] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'path_cactilog''
2017-05-11 16:09:51 - SPINE: Poller[1] DEBUG: The path_php_server variable is /data/cacti/script_server.php
2017-05-11 16:09:51 - SPINE: Poller[1] DEBUG: The path_cactilog variable is /opt/cacti/log/cacti.log
DEBUG: The log_destination variable is 4 (STDOUT)
DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'path_php_binary
DEBUG: The path_php variable is /usr/bin/php
DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'availability_method
DEBUG: The availability_method variable is 3
DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'ping_recovery_count
DEBUG: The ping_recovery_count variable is 3
DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'ping_failure_count
DEBUG: The ping_failure_count variable is 2
DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'ping_method
DEBUG: The ping_method variable is 1
DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'ping_retries
DEBUG: The ping_retries variable is 1
DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'ping_timeout
DEBUG: The ping_timeout variable is 2500
DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'snmp_retries
DEBUG: The snmp_retries variable is 3
DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'log_perror
DEBUG: The log_perror variable is 1
DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'log_pwarn
DEBUG: The log_pwarn variable is 1
DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'boost_redirect
DEBUG: The boost_redirect variable is 0
DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'log_pstats
DEBUG: The log_pstats variable is 1
DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'max_threads
DEBUG: The threads variable is 8
DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'poller_interval
DEBUG: The polling interval is 300 seconds
DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'concurrent_processes
DEBUG: The number of concurrent processes is 1
DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'script_timeout
DEBUG: The script timeout is 10
DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'selective_device_debug
DEBUG: The selective_device_debug variable is
DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'spine_log_level
DEBUG: The spine_log_level variable is 0
DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'php_servers
DEBUG: The number of php script servers to run is 6
DEVDBG: SQL:'SELECT action FROM poller_item WHERE action=2 AND host_id BETWEEN 10 AND 10 LIMIT 1
DEBUG: StartDevice='10', EndDevice='10', TotalPHPScripts='0
DEBUG: The PHP Script Server is Not Required
DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'max_get_size
DEBUG: The Maximum SNMP OID Get Size is 10
DEVDBG: SQL:'SET SESSION sql_mode = (SELECT REPLACE(@@sql_mode,'NO_ZERO_DATE', ''))
DEVDBG: SQL:'SET SESSION sql_mode = (SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY', ''))
SPINE: Version 1.1.6 starting
DEBUG: Spine is running asroot.
SPINE: Initializing Net-SNMP API
DEBUG: Issues with SNMP Header Version information, assuming old version of Net-SNMP.
SPINE: Initializing PHP Script Server(s)
DEVDBG: SQL:'SHOW COLUMNS FROM host LIKE 'poller_id
DEVDBG: SQL:'SHOW COLUMNS FROM host LIKE 'device_threads
NOTE: Spine will support multithread device polling.
DEVDBG: SQL:'SELECT id, device_threads FROM host WHERE disabled='' AND id BETWEEN 10 AND 10 AND host.poller_id=1 ORDER BY id
DEVDBG: SQL:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 98315, NOW(), '0000-00-00 00:00:00')
DEBUG: Initial Value of Active Threads is 0
DEBUG: Valid Thread to be Created
SPINE: Active Threads is 1, Pending is 1
DEBUG: In Poller, About to Start Polling of Device for Device ID 10
DEVDBG: SQL:'SET SESSION sql_mode = (SELECT REPLACE(@@sql_mode,'NO_ZERO_DATE', ''))
DEVDBG: SQL:'SET SESSION sql_mode = (SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY', ''))
DEVDBG: SQL:'SELECT id, hostname, snmp_community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, snmp_engine_id, snmp_port, snmp_timeout, max_oids, availability_method, ping_method, ping_port, ping_timeout, ping_retries, status, status_event_count, status_fail_date, status_rec_date, status_last_error, min_time, max_time, cur_time, avg_time, total_polls, failed_polls, availability, snmp_sysUptimeInstance, snmp_sysDescr, snmp_sysObjectID, snmp_sysContact, snmp_sysName, snmp_sysLocation FROM host WHERE id=10
Device[10] DEBUG: Entering ICMP Ping
Device[10] DEBUG: ICMP Device Alive, Try Count:1, Time:1.6429 ms
Device[10] PING: Result ICMP: Device is Alive
DEVDBG: SQL:'UPDATE host SET status='3', status_event_count='0', status_fail_date='2017-05-07 03:25:00', status_rec_date='2016-12-03 14:10:00', status_last_error='ICMP: Ping timed out', min_time='0.012940', max_time='399.662020', cur_time='1.642940', avg_time='2.908719', total_polls='1042152', failed_polls='2238', availability='99.7853', snmp_sysDescr='',  snmp_sysObjectID='', snmp_sysUpTimeInstance='0',  snmp_sysContact='', snmp_sysName='', snmp_sysLocation='' WHERE id='10
DEVDBG: SQL:'SELECT data_query_id, action, op, assert_value, arg1 FROM poller_reindex WHERE host_id=10
Device[10] TH[1] RECACHE: Processing 1 items in the auto reindex cache for 'MY-HOST
Device[10] TH[1] Recache DataQuery[1] OID: .1.3.6.1.2.1.1.3.0, output: 21795237
DEVDBG: SQL:'UPDATE poller_reindex SET assert_value='21795237' WHERE host_id='10' AND data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0
DEVDBG: SQL:'SELECT snmp_port, count(snmp_port) FROM poller_item WHERE host_id=10 AND rrd_next_step < 0 AND poller_id=1 GROUP BY snmp_port
DEVDBG: SQL:'SELECT action, hostname, snmp_community, snmp_version, snmp_username, snmp_password, rrd_name, rrd_path, arg1, arg2, arg3, local_data_id, rrd_num, snmp_port, snmp_timeout, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, snmp_engine_id  FROM poller_item WHERE host_id=10 AND rrd_next_step <=0 AND poller_id=1 ORDER by snmp_port
Device[10] TH[1] NOTE: There are '54' Polling Items for this Device
Device[10] TH[1] DS[6792] SNMP: v2: MY-HOST, dsname: traffic_out, oid: .1.3.6.1.2.1.31.1.1.1.10.497, value: 919996137
Device[10] TH[1] DS[6792] SNMP: v2: MY-HOST, dsname: traffic_in, oid: .1.3.6.1.2.1.31.1.1.1.6.497, value: 97109086
Device[10] TH[1] DS[6791] SNMP: v2: MY-HOST, dsname: traffic_out, oid: .1.3.6.1.2.1.31.1.1.1.10.496, value: 53114814846
Device[10] TH[1] DS[6791] SNMP: v2: MY-HOST, dsname: traffic_in, oid: .1.3.6.1.2.1.31.1.1.1.6.496, value: 105863156371
Device[10] TH[1] DS[3430] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.7.7, value: 0
Device[10] TH[1] DS[3429] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.6.7, value: 11
Device[10] TH[1] DS[3428] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.7.6, value: 0
Device[10] TH[1] DS[3427] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.7.5, value: 0
Device[10] TH[1] DS[3426] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.7.4, value: 18
Device[10] TH[1] DS[3424] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.7.2, value: 15
Device[10] TH[1] DS[3423] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.7.1, value: 25
Device[10] TH[1] DS[3422] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.7.0, value: 15
Device[10] TH[1] DS[3421] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.6.6, value: 0
Device[10] TH[1] DS[3420] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.6.5, value: 0
Device[10] TH[1] DS[3419] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.6.4, value: 0
Device[10] TH[1] DS[3418] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.6.3, value: 0
Device[10] TH[1] DS[3417] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.6.2, value: 0
Device[10] TH[1] DS[3416] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.6.1, value: 0
Device[10] TH[1] DS[3415] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.6.0, value: 0
Device[10] TH[1] DS[3397] SNMP: v2: MY-HOST, dsname: 5min_cpu, oid: .1.3.6.1.4.1.9.2.1.58.0, value: 15
Device[10] DEBUG: The NIFTY POPEN returned the following File Descriptor 7
Device[10] TH[1] DS[3244] SCRIPT: /data/cacti/scripts/ak_as.sh 'MY-HOST', output: tot:0 pstn:0
Device[10] TH[1] DS[3396] SNMP: v2: MY-HOST, dsname: 1min_cpu, oid: .1.3.6.1.4.1.9.2.1.57.0, value: 14
Device[10] TH[1] DS[3395] SNMP: v2: MY-HOST, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1019, value: U
Device[10] TH[1] DS[3395] SNMP: v2: MY-HOST, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1019, value: U
Device[10] TH[1] DS[3394] SNMP: v2: MY-HOST, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1018, value: 869084023
Device[10] TH[1] DS[3394] SNMP: v2: MY-HOST, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1018, value: 28620688
Device[10] TH[1] DS[3393] SNMP: v2: MY-HOST, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1017, value: U
Device[10] TH[1] DS[3393] SNMP: v2: MY-HOST, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1017, value: U
Device[10] TH[1] DS[3392] SNMP: v2: MY-HOST, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1016, value: 1533495082
Device[10] TH[1] DS[3392] SNMP: v2: MY-HOST, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1016, value: 1493594413
Device[10] TH[1] DS[437] SNMP: v2: MY-HOST, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.298, value: 0
Device[10] TH[1] DS[437] SNMP: v2: MY-HOST, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.298, value: 0
Device[10] TH[1] DS[436] SNMP: v2: MY-HOST, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.289, value: 0
Device[10] TH[1] DS[436] SNMP: v2: MY-HOST, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.289, value: 0
Device[10] TH[1] DS[416] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.1.4, value: U
Device[10] TH[1] DS[415] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.1.3, value: U
Device[10] TH[1] DS[414] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.1.2, value: U
Device[10] TH[1] DS[413] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.1.1, value: U
Device[10] TH[1] DS[412] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.1.0, value: U
Device[10] TH[1] DS[411] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.0.11, value: U
Device[10] TH[1] DS[410] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.0.10, value: U
Device[10] TH[1] DS[409] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.0.7, value: U
Device[10] TH[1] DS[408] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.0.6, value: U
Device[10] TH[1] DS[406] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.0.5, value: U
Device[10] TH[1] DS[405] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.0.4, value: U
Device[10] TH[1] DS[404] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.0.3, value: U
Device[10] TH[1] DS[403] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.0.2, value: U
Device[10] TH[1] DS[160] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.0.9, value: U
Device[10] TH[1] DS[159] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.0.8, value: U
Device[10] TH[1] DS[152] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.0.1, value: U
Device[10] TH[1] DS[151] SNMP: v2: MY-HOST, dsname: actchan, oid: .1.3.6.1.4.1.9.10.19.1.1.9.1.3.0.0, value: U
Device[10] TH[1] DS[46] SNMP: v2: MY-HOST, dsname: outlet, oid: .1.3.6.1.4.1.9.9.13.1.3.1.3.4, value: U
Device[10] TH[1] DS[45] SNMP: v2: MY-HOST, dsname: inlet, oid: .1.3.6.1.4.1.9.9.13.1.3.1.3.1, value: 23
Device[10] TH[1] DS[44] SNMP: v2: MY-HOST, dsname: memory, oid: .1.3.6.1.4.1.9.2.1.8.0, value: 200274336
DEVDBG: SQL:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (6792,'traffic_out','2017-05-11 16:09:51','919996137'),(6792,'traffic_in','2017-05-11 16:09:51','97109086'),(6791,'traffic_out','2017-05-11 16:09:51','53114814846'),(6791,'traffic_in','2017-05-11 16:09:51','105863156371'),(3430,'actchan','2017-05-11 16:09:51','0'),(3429,'actchan','2017-05-11 16:09:51','11'),(3428,'actchan','2017-05-11 16:09:51','0'),(3427,'actchan','2017-05-11 16:09:51','0'),(3426,'actchan','2017-05-11 16:09:51','18'),(3424,'actchan','2017-05-11 16:09:51','15'),(3423,'actchan','2017-05-11 16:09:51','25'),(3422,'actchan','2017-05-11 16:09:51','15'),(3421,'actchan','2017-05-11 16:09:51','0'),(3420,'actchan','2017-05-11 16:09:51','0'),(3419,'actchan','2017-05-11 16:09:51','0'),(3418,'actchan','2017-05-11 16:09:51','0'),(3417,'actchan','2017-05-11 16:09:51','0'),(3416,'actchan','2017-05-11 16:09:51','0'),(3415,'actchan','2017-05-11 16:09:51','0'),(3397,'5min_cpu','2017-05-11 16:09:51','15'),(3396,'1min_cpu','2017-05-11 16:0
DEVDBG: SQL:'UPDATE poller_item SET rrd_next_step=IF((rrd_next_step-300)>=0, (rrd_next_step-300), (rrd_step-300)) WHERE host_id=10 AND poller_id=1
Device[10] TH[1] Total Time:  0.52 Seconds
DEVDBG: SQL:'UPDATE host SET polling_time=1494511791.845 - 1494511791.329 WHERE id=10
Device[10] TH[1] DEBUG: HOST COMPLETE: About to Exit Device Polling Thread Function
DEBUG: The Value of Active Threads is 0 for Device ID 10
POLLR: Active Threads is 0, Pending is 0
SPINE: The Final Value of Threads is 0
DEVDBG: SQL:'REPLACE INTO settings (name,value) VALUES ('date',NOW())
DEVDBG: SQL:'UPDATE poller_time SET end_time=NOW() WHERE poller_id=1 AND pid=98315
DEBUG: Thread Cleanup Complete
DEBUG: PHP Script Server Pipes Closed
DEBUG: Allocated Variable Memory Freed
DEBUG: MYSQL Free & Close Completed
DEBUG: Net-SNMP Close Completed
Time: 1.1545 s, Threads: 8, Devices: 1

I'm noticing the table poller_output gets populated, but the data is not committed into the rrd files.

Why?

Thanks!

Simon

Osiris · Post by **Osiris** » Mon May 15, 2017 1:26 am

The spine process is a child of the poller.php process which is responsible for RRDfile population. This is well documented in the manual.

Cacti

Spine: MySQL server has gone away

Spine: MySQL server has gone away

Re: Spine: MySQL server has gone away

Re: Spine: MySQL server has gone away

Re: Spine: MySQL server has gone away

Re: Spine: MySQL server has gone away

Re: Spine: MySQL server has gone away

Who is online