cacti stop polling/generating graphs for new host

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

Moderators: Developers, Moderators

Post Reply
peppermint
Cacti User
Posts: 58
Joined: Fri May 11, 2007 1:11 pm
Location: NY

Post by peppermint »

Since the orginal 0.8.7a spine has buffer flow issue now, I tried the nightly source spine with comma being removed (although there was a :Result from SNMP not valid. Partial Result issue with it)

here is the "-V result":
#spine -V 5 76 76
SPINE: Using spine config file [/etc/spine.conf]
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_webroot''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_cactilog''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The path_php_server variable is /var/www/cacti/script_server.php
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The path_cactilog variable is /var/www/cacti/log/cacti.log
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_destination''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The log_destination variable is 1 (FILE)
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_php_binary''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The path_php variable is /usr/bin/php
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'availability_method''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The availability_method variable is 2
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_recovery_count''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The ping_recovery_count variable is 3
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_failure_count''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The ping_failure_count variable is 2
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_method''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The ping_method variable is 2
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_retries''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The ping_retries variable is 1
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_timeout''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The ping_timeout variable is 400
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_perror''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The log_perror variable is 1
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_pwarn''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The log_pwarn variable is 1
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_pstats''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The log_pstats variable is 1
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'max_threads''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The threads variable is 1
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'poller_interval''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The polling interval is 60 seconds
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'concurrent_processes''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The number of concurrent processes is 1
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'script_timeout''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The script timeout is 25
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'php_servers''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The number of php script servers to run is 1
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT action FROM poller_item WHERE action=2 AND host_id BETWEEN 76 AND 76 LIMIT 1'
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: StartHost='76', EndHost='76', TotalPHPScripts='0'
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The PHP Script Server is Not Required
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'max_get_size''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The Maximum SNMP OID Get Size is 10
04/15/2008 10:09:31 AM - SPINE: Poller[0] Version 0.8.7 starting
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: MySQL is Thread Safe!
04/15/2008 10:09:31 AM - SPINE: Poller[0] SPINE: Initializing Net-SNMP API
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SNMP Header Version is 5.3.1
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SNMP Library Version is 5.3.1
04/15/2008 10:09:31 AM - SPINE: Poller[0] SPINE: Initializing PHP Script Server(s)
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT id FROM host WHERE disabled='' AND id BETWEEN 76 AND 76 ORDER BY id'
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: Initial Value of Active Threads is 0
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT snmp_port, count(snmp_port) FROM poller_item WHERE host_id=0 AND rrd_next_step < 0 GROUP BY snmp_port'
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: 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 FROM poller_item WHERE host_id=0 and rrd_next_step <=0 ORDER by snmp_port'
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd_next_step=rrd_next_step-60 WHERE host_id=0'
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd_next_step=rrd_step-60 WHERE rrd_next_step < 0 and host_id=0'
04/15/2008 10:09:31 AM - SPINE: Poller[0] Host[0] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 0
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT id, hostname, snmp_community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, 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 FROM host WHERE id=76'
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: UDP Ping return_code was -1, errno was 111, total_time was 522.1367
04/15/2008 10:09:31 AM - SPINE: Poller[0] Host[76] PING: Result UDP: Host is Alive
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE host SET status='3', status_event_count='0', status_fail_date='0000-00-00 00:00:00', status_rec_date='0000-00-00 00:00:00', status_last_error='', min_time='0.393150', max_time='55.160000', cur_time='0.522140', avg_time='0.635898', total_polls='2182', failed_polls='0', availability='100.0000' WHERE id='76''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT data_query_id, action, op, assert_value, arg1 FROM poller_reindex WHERE host_id=76'
04/15/2008 10:09:31 AM - SPINE: Poller[0] Host[76] RECACHE: Processing 2 items in the auto reindex cache for 'dc003.xxx.com'
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_reindex SET assert_value='U' WHERE host_id='76' AND data_query_id='15' and arg1='.1.3.6.1.2.1.1.3.0''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_reindex SET assert_value='U' WHERE host_id='76' AND data_query_id='21' and arg1='.1.3.6.1.2.1.1.3.0''
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT snmp_port, count(snmp_port) FROM poller_item WHERE host_id=76 AND rrd_next_step < 0 GROUP BY snmp_port'
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: 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
FROM poller_item WHERE host_id=76 and rrd_next_step <=0 ORDER by snmp_port'
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd_next_step=rrd_next_step-60 WHERE host_id=76'
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd_next_step=rrd_step-60 WHERE rrd_next_step < 0 and host_id=76'
04/15/2008 10:09:31 AM - SPINE: Poller[0] Host[76] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 0
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'replace into settings (name,value) values ('date',NOW())'
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())'
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: Thread Cleanup Complete
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: PHP Script Server Pipes Closed
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: Allocated Variable Memory Freed
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: MYSQL Free & Close Completed
04/15/2008 10:09:31 AM - SPINE: Poller[0] Time: 0.0802 s, Threads: 1, Hosts: 2

It's not being polled, is it?

Exect same symptoms happened on my 32bit test envrionment...
Thanks!

Pepper
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT id, hostname, snmp_community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, 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 FROM host WHERE id=76'
04/15/2008 10:09:31 AM - SPINE: Poller[0] DEBUG: UDP Ping return_code was -1, errno was 111, total_time was 522.1367
04/15/2008 10:09:31 AM - SPINE: Poller[0] Host[76] PING: Result UDP: Host is Alive
It is polled, but no polling items found. Don't know why, ATM
Reinhard
Top
peppermint
Cacti User
Posts: 58
Joined: Fri May 11, 2007 1:11 pm
Location: NY

Post by peppermint »

That query returns:

| id | hostname | snmp_community | snmp_version | snmp_username | snmp_password | snmp_auth_protocol | snmp_priv_passphrase | snmp_priv_protocol | snmp_context | 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 |
+----+----------------------------+----------------+--------------+---------------+---------------+--------------------+----------------------+--------------------+--------------+-----------+--------------+----------+---------------------+-------------+-----------+--------------+--------------+--------+--------------------+---------------------+---------------------+-------------------+----------+----------+----------+----------+-------------+--------------+--------------+
| 76 | dc003.xxx.com | public | 0 | cacti | xxxxxxxx | MD5 | Nandemoii | DES | NULL | 161 | 500 | 10 | 3 | 2 | 22 | 400 | 1 | 3 | 0 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | NULL | 0.39315 | 55.16000 | 0.49000 | 0.62576 | 3776 | 0 | 100.00000 |

Wondering why spine could not retrieve it.

Pepper
Top
Xaanix
Posts: 17
Joined: Tue Nov 06, 2007 4:52 pm

Post by Xaanix »

I seem to be having the same issue. I noticed that in the logs that peppermint posted, the host had 'no availability detection' selected. I tried the same and received the same behavior. I have another thread I started a week ago which i think is related to this one (moderators: merge threads maybe?)

Was this issue ever resolved?

My suspciion is that Spine REQUIRES SNMP to always be turned on, Using ICMP only or 'NO availability checking' will trigger this behavior.

I have yet another firewall request submitted to allow SNMP to pass through.... I'll post the results in a few days..
Top
User avatar
TFC
Cacti Pro User
Posts: 739
Joined: Wed Apr 09, 2003 2:17 am
Location: Izmir/Turkey

Post by TFC »

Hi,
I install new template.
But i cannot popoulate graph about new added host.
here is debug output:

11/23/2009 12:10:05 PM - SPINE: Poller[0] Host[5] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
11/23/2009 12:10:05 PM - SPINE: Poller[0] Host[5] NOTE: There are '1' Polling Items for this Host
11/23/2009 12:10:05 PM - SPINE: Poller[0] Host[5] PING Result: UDP: Ping timed out
11/23/2009 12:10:05 PM - SPINE: Poller[0] Host[5] DEBUG: UDP Timeout, Try Count:3, Time:500.8869 ms
11/23/2009 12:10:05 PM - SPINE: Poller[0] Host[5] DEBUG: UDP Timeout, Try Count:2, Time:500.9881 ms
11/23/2009 12:10:04 PM - SPINE: Poller[0] Host[5] DEBUG: UDP Timeout, Try Count:1, Time:500.6819 ms
11/23/2009 12:06:35 PM - SPINE: Poller[0] Host[5] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
11/23/2009 12:06:35 PM - SPINE: Poller[0] Host[5] NOTE: There are '1' Polling Items for this Host
11/23/2009 12:06:33 PM - SPINE: Poller[0] Host[5] RECACHE: Processing 4 items in the auto reindex cache for '10.1.1.36'
11/23/2009 12:06:33 PM - SPINE: Poller[0] Host[5] PING: Result ICMP: Host is Alive
11/23/2009 12:06:33 PM - SPINE: Poller[0] Host[5] DEBUG: ICMP Host Alive, Try Count:1, Time:33.5891 ms
11/23/2009 12:05:04 PM - SPINE: Poller[0] Host[5] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
11/23/2009 12:05:04 PM - SPINE: Poller[0] Host[5] NOTE: There are '1' Polling Items for this Host
11/23/2009 12:05:04 PM - SPINE: Poller[0] Host[5] PING Result: UDP: Ping timed out
11/23/2009 12:05:04 PM - SPINE: Poller[0] Host[5] DEBUG: UDP Timeout, Try Count:3, Time:501.0559 ms
11/23/2009 12:05:04 PM - SPINE: Poller[0] Host[5] DEBUG: UDP Timeout, Try Count:2, Time:500.9469 ms
11/23/2009 12:05:03 PM - SPINE: Poller[0] Host[5] DEBUG: UDP Timeout, Try Count:1, Time:500.3931 ms
And here is the spine verbosity 5 output:
root@cacti:/usr/local/spine/bin# ./spine --verbosity=5 5 5
SPINE: Using spine config file [../etc/spine.conf]
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The path_php_server variable is /var/www/script_server.php
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The path_cactilog variable is /var/www/log/cacti.log
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The log_destination variable is 1 (FILE)
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The path_php variable is /usr/bin/php
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The availability_method variable is 2
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The ping_recovery_count variable is 3
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The ping_failure_count variable is 2
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The ping_method variable is 2
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The ping_retries variable is 1
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The ping_timeout variable is 400
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The snmp_retries variable is 3
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The log_perror variable is 1
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The log_pwarn variable is 1
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The boost_redirect variable is 0
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The log_pstats variable is 0
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The threads variable is 1
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The polling interval is 300 seconds
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The number of concurrent processes is 1
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The script timeout is 25
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The number of php script servers to run is 1
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: StartHost='5', EndHost='5', TotalPHPScripts='0'
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The PHP Script Server is Not Required
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The Maximum SNMP OID Get Size is 10
11/23/2009 12:06:33 PM - SPINE: Poller[0] Version 0.8.7e starting
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: MySQL is Thread Safe!
11/23/2009 12:06:33 PM - SPINE: Poller[0] SPINE: Initializing Net-SNMP API
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: SNMP Header Version is 5.4.1
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: SNMP Library Version is 5.4.1
11/23/2009 12:06:33 PM - SPINE: Poller[0] SPINE: Initializing PHP Script Server(s)
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: Initial Value of Active Threads is 0
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
11/23/2009 12:06:33 PM - SPINE: Poller[0] Host[0] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 0
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
11/23/2009 12:06:33 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
11/23/2009 12:06:33 PM - SPINE: Poller[0] Host[5] DEBUG: ICMP Host Alive, Try Count:1, Time:33.5891 ms
11/23/2009 12:06:33 PM - SPINE: Poller[0] Host[5] PING: Result ICMP: Host is Alive
11/23/2009 12:06:33 PM - SPINE: Poller[0] Host[5] RECACHE: Processing 4 items in the auto reindex cache for '10.1.1.36'
11/23/2009 12:06:35 PM - SPINE: Poller[0] Host[5] NOTE: There are '1' Polling Items for this Host
11/23/2009 12:06:35 PM - SPINE: Poller[0] Host[5] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
11/23/2009 12:06:35 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 0
11/23/2009 12:06:35 PM - SPINE: Poller[0] DEBUG: Thread Cleanup Complete
11/23/2009 12:06:35 PM - SPINE: Poller[0] DEBUG: PHP Script Server Pipes Closed
11/23/2009 12:06:35 PM - SPINE: Poller[0] DEBUG: Allocated Variable Memory Freed
11/23/2009 12:06:35 PM - SPINE: Poller[0] DEBUG: MYSQL Free & Close Completed
11/23/2009 12:06:35 PM - SPINE: Poller[0] Time: 2.2694 s, Threads: 1, Hosts: 2
Here is the sql output:
mysql> 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 FROM poller_item WHERE host_id=5 and rrd_next_step <=0 ORDER by snmp_port
-> ;
+--------+-----------+----------------+--------------+---------------+---------------+----------+-------------------------------------+-------------------------------------------+------+------+---------------+---------+-----------+--------------+--------------------+----------------------+--------------------+--------------+
| 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 |
+--------+-----------+----------------+--------------+---------------+---------------+----------+-------------------------------------+-------------------------------------------+------+------+---------------+---------+-----------+--------------+--------------------+----------------------+--------------------+--------------+
| 1 | 10.1.1.36 | Btg.2055 | 2 | | | cpu_load | /var/www/rra/feyim1_cpu_load_21.rrd | perl /var/www/scripts/nt_cpu.pl 10.1.1.36 | | | 21 | 1 | 161 | 500 | | | | |
+--------+-----------+----------------+--------------+---------------+---------------+----------+-------------------------------------+-------------------------------------------+------+------+---------------+---------+-----------+--------------+--------------------+----------------------+--------------------+--------------+
1 row in set (0.00 sec)
What is the problem?
Top
Post Reply

Return to “Help: General”

Who is online

Users browsing this forum: No registered users and 1 guest