Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Sun Apr 30, 2017 1:58 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 14 posts ] 
Author Message
 Post subject: my graph stop to update - RT works fine - RRD process = 0
PostPosted: Wed Mar 02, 2016 8:59 am 
Offline
Cacti User

Joined: Thu Mar 29, 2012 2:19 am
Posts: 69
Hi,
suddenly my graphs stop updating.
when I use RT on the same graph, it works great, but my graphs are not being updated.
I've rebuild my poller cash - no success on graph update.
I can also see that NO RRD is processed: spine Processes:256 Threads:400 Hosts:230 HostsPerProcess:1 DataSources:210300 RRDsProcessed:0

my last log lines:
03/02/2016 03:50:13 PM - SPINE: Poller[0] Host[366] ERROR: Problems parsing Multi SNMP OID! (oid: .1.3.6.1.2.1.31.1.1.1.6.0), Set MAX_OIDS to 1 for this host to isolate bad OID
03/02/2016 03:50:13 PM - SPINE: Poller[0] Host[366] ERROR: Problems parsing Multi SNMP OID! (oid: .1.3.6.1.2.1.31.1.1.1.10.0), Set MAX_OIDS to 1 for this host to isolate bad OID
03/02/2016 03:50:13 PM - SPINE: Poller[0] Host[118] TH[1] DS[58229] WARNING: SNMP timeout detected [500 ms], ignoring host '192.168.174.60'
03/02/2016 03:50:13 PM - SPINE: Poller[0] Host[118] TH[1] DS[58229] WARNING: SNMP timeout detected [500 ms], ignoring host '192.168.174.60'
03/02/2016 03:50:13 PM - SPINE: Poller[0] Host[118] TH[1] DS[58228] WARNING: SNMP timeout detected [500 ms], ignoring host '192.168.174.60'
03/02/2016 03:50:13 PM - SPINE: Poller[0] Host[118] TH[1] DS[58228] WARNING: SNMP timeout detected [500 ms], ignoring host '192.168.174.60'
03/02/2016 03:50:13 PM - SPINE: Poller[0] Host[118] TH[1] DS[58227] WARNING: SNMP timeout detected [500 ms], ignoring host '192.168.174.60'
03/02/2016 03:50:13 PM - SPINE: Poller[0] Host[118] TH[1] DS[58227] WARNING: SNMP timeout detected [500 ms], ignoring host '192.168.174.60'
03/02/2016 03:50:13 PM - SPINE: Poller[0] Host[118] TH[1] DS[58226] WARNING: SNMP timeout detected [500 ms], ignoring host '192.168.174.60'
03/02/2016 03:50:13 PM - SPINE: Poller[0] Host[118] TH[1] DS[58226] WARNING: SNMP timeout detected [500 ms], ignoring host '192.168.174.60'
03/02/2016 03:50:14 PM - SPINE: Poller[0] Host[118] TH[1] DS[58225] WARNING: SNMP timeout detected [500 ms], ignoring host '192.168.174.60'
03/02/2016 03:50:14 PM - SPINE: Poller[0] Host[118] TH[1] DS[58225] WARNING: SNMP timeout detected [500 ms], ignoring host '192.168.174.60'
03/02/2016 03:50:14 PM - SPINE: Poller[0] Host[118] TH[1] DS[58224] WARNING: SNMP timeout detected [500 ms], ignoring host '192.168.174.60'
03/02/2016 03:50:24 PM - SPINE: Poller[0] Host[74] TH[1] DS[14277] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:50:24 PM - SPINE: Poller[0] Host[74] TH[1] DS[14277] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:50:24 PM - SPINE: Poller[0] Host[74] TH[1] DS[14276] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:50:24 PM - SPINE: Poller[0] Host[74] TH[1] DS[14276] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:50:24 PM - SPINE: Poller[0] Host[74] TH[1] DS[14275] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:50:24 PM - SPINE: Poller[0] Host[74] TH[1] DS[14275] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:50:24 PM - SPINE: Poller[0] Host[74] TH[1] DS[14274] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:50:24 PM - SPINE: Poller[0] Host[74] TH[1] DS[14274] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:50:24 PM - SPINE: Poller[0] Host[74] TH[1] DS[14273] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:50:24 PM - SPINE: Poller[0] Host[74] TH[1] DS[14273] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:50:45 PM - SPINE: Poller[0] Host[74] TH[1] DS[14272] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:51:09 PM - SYSTEM STATS: Time:67.3403 Method:spine Processes:256 Threads:400 Hosts:230 HostsPerProcess:1 DataSources:210300 RRDsProcessed:0
03/02/2016 03:55:01 PM - POLLER: Poller[0] WARNING: Poller Output Table not Empty. Issues Found: 2, Data Sources: traffic_out(DS[14272]), traffic_out(DS[58224])
03/02/2016 03:55:11 PM - SPINE: Poller[0] Host[366] ERROR: Problems parsing Multi SNMP OID! (oid: .1.3.6.1.2.1.31.1.1.1.6.0), Set MAX_OIDS to 1 for this host to isolate bad OID
03/02/2016 03:55:11 PM - SPINE: Poller[0] Host[366] ERROR: Problems parsing Multi SNMP OID! (oid: .1.3.6.1.2.1.31.1.1.1.10.0), Set MAX_OIDS to 1 for this host to isolate bad OID
03/02/2016 03:55:24 PM - SPINE: Poller[0] Host[74] TH[1] DS[14277] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:55:24 PM - SPINE: Poller[0] Host[74] TH[1] DS[14277] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:55:24 PM - SPINE: Poller[0] Host[74] TH[1] DS[14276] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:55:24 PM - SPINE: Poller[0] Host[74] TH[1] DS[14276] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:55:24 PM - SPINE: Poller[0] Host[74] TH[1] DS[14275] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:55:24 PM - SPINE: Poller[0] Host[74] TH[1] DS[14275] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:55:24 PM - SPINE: Poller[0] Host[74] TH[1] DS[14274] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:55:24 PM - SPINE: Poller[0] Host[74] TH[1] DS[14274] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:55:24 PM - SPINE: Poller[0] Host[74] TH[1] DS[14273] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:55:24 PM - SPINE: Poller[0] Host[74] TH[1] DS[14273] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:55:44 PM - SPINE: Poller[0] Host[74] TH[1] DS[14272] WARNING: SNMP timeout detected [5000 ms], ignoring host '192.168.175.7'
03/02/2016 03:56:00 PM - SYSTEM STATS: Time:59.0880 Method:spine Processes:256 Threads:400 Hosts:230 HostsPerProcess:1 DataSources:210300 RRDsProcessed:0

my configuration is:

General Information
Date Wed, 02 Mar 2016 15:52:02 +0200
Cacti Version 0.8.8a
Cacti OS unix
SNMP Version NET-SNMP version: 5.5
RRDTool Version RRDTool 1.3.x
Hosts 298
Graphs 112806
Data Sources SNMP: 4
SNMP Query: 112731
Script Query: 72
Total: 112807
Poller Information
Interval 300
Type SPINE 0.8.8a Copyright 2002-2012 by The Cacti Group
Items Action[0]: 210300
Total: 210300
Concurrent Processes 256
Max Threads 400
PHP Servers 4
Script Timeout 5
Max OID 50
Last Run Statistics Time:58.3573 Method:spine Processes:256 Threads:400 Hosts:230 HostsPerProcess:1 DataSources:210300 RRDsProcessed:0


Top
 Profile  
 
 Post subject: Re: my graph stop to update - RT works fine - RRD process =
PostPosted: Thu Mar 03, 2016 12:53 am 
Offline
Cacti User
User avatar

Joined: Wed Feb 03, 2016 3:38 pm
Posts: 261
Can you try to empty the poller cache with the script in /cli?

If you run it in debug mode you should get a line that says something like:

/usr/bin/rrdtool -update --allthegraphsettings

Can you run that from cli and see if it updates?

Any errors in mysql log? and httpd log?

Also you can run poller.php and spine -V 7 from cli.


Top
 Profile  
 
 Post subject: Re: my graph stop to update - RT works fine - RRD process =
PostPosted: Thu Mar 03, 2016 2:23 am 
Offline
Cacti User

Joined: Thu Mar 29, 2012 2:19 am
Posts: 69
I'm new with this.
empty the poller cache - should I run"rebuild_poller_cache.php" script

after that shold I run "/usr/bin/rrdtool -update --allthegraphsettings"?

than watch the logs?


Top
 Profile  
 
 Post subject: Re: my graph stop to update - RT works fine - RRD process =
PostPosted: Thu Mar 03, 2016 9:41 am 
Offline
Cacti User
User avatar

Joined: Wed Feb 03, 2016 3:38 pm
Posts: 261
amitayb wrote:
I'm new with this.
empty the poller cache - should I run"rebuild_poller_cache.php" script

after that shold I run "/usr/bin/rrdtool -update --allthegraphsettings"?

than watch the logs?


Yes run the script. If its in VMware take a backup before you change anything.

After that you will first set the log to debug/high then look for a statement in the log which shows something like:

"/usr/bin/rrdtool -update --allthegraphsettings"?*

Then you run that command from the cli.

*--allthegraphsettings will be a long string of settings.


Top
 Profile  
 
 Post subject: Re: my graph stop to update - RT works fine - RRD process =
PostPosted: Thu Mar 03, 2016 10:16 am 
Offline
Cacti User

Joined: Thu Mar 29, 2012 2:19 am
Posts: 69
Thanks for making it clear.
I'll update on sunday


Top
 Profile  
 
 Post subject: Re: my graph stop to update - RT works fine - RRD process =
PostPosted: Tue Mar 14, 2017 6:45 pm 
Offline

Joined: Tue Mar 14, 2017 4:59 pm
Posts: 12
i have same issue rrd files are not updating and i have run clear buffer cache script as well multiple times..but still my rrd files are not updating ..


Top
 Profile  
 
 Post subject: Re: my graph stop to update - RT works fine - RRD process =
PostPosted: Wed Mar 15, 2017 2:56 am 
Offline
Cacti User

Joined: Thu Mar 29, 2012 2:19 am
Posts: 69
Hi,
is your real time works ok?
try change permission to RRA folder, make it 777 and try
last, use debug log level for 1 cycle. than grep it according to your rrd name


Top
 Profile  
 
 Post subject: Re: my graph stop to update - RT works fine - RRD process =
PostPosted: Wed Mar 15, 2017 7:35 am 
Offline

Joined: Tue Mar 14, 2017 4:59 pm
Posts: 12
Hello,


Yes real time are working...but its not single rrd which is not working ..its all graphs which are showing NAN values and permission is already 777 for rra....Please advice further...


Top
 Profile  
 
 Post subject: Re: my graph stop to update - RT works fine - RRD process =
PostPosted: Wed Mar 15, 2017 9:43 am 
Offline
Cacti User

Joined: Thu Mar 29, 2012 2:19 am
Posts: 69
can you post relevant debug log?


Top
 Profile  
 
 Post subject: Re: my graph stop to update - RT works fine - RRD process =
PostPosted: Wed Mar 15, 2017 10:36 am 
Offline

Joined: Tue Mar 14, 2017 4:59 pm
Posts: 12
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM plugin_realms"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'aggregate' AND file = 'aggregate_templates.php,aggregate_templates_items.php,color_templates.php,color_templates_items.php'"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'rrdclean' AND file = 'rrdcleaner.php,rrdmove.php'"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_settings'"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'valid_host_fields'"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_form'"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'auth_alternate_realms'"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='229' and user_auth_realm.realm_id='7'"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM plugin_realms"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'aggregate' AND file = 'aggregate_templates.php,aggregate_templates_items.php,color_templates.php,color_templates_items.php'"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'rrdclean' AND file = 'rrdcleaner.php,rrdmove.php'"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_graph_header'"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from user_auth where id=229"

03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where realm_id=8 and user_id=229"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_title'"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_graph_refresh'"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_head'"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_graph_header_tabs'"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'draw_navigation_text'"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=229"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_trees from user_auth where id=229"

03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=229) where user_auth_perms.user_id is null order by graph_tree.name"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_hosts from user_auth where id=229"

03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree_items.id, graph_tree_items.title, graph_tree_items.order_key, graph_tree_items.host_id, graph_tree_items.host_grouping_type, host.description as hostname from graph_tree_items left join host on (host.id=graph_tree_items.host_id) left join user_auth_perms on (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=229) where graph_tree_items.graph_tree_id=2 and !(user_auth_perms.user_id is not null and graph_tree_items.host_id > 0) and graph_tree_items.local_graph_id = 0 order by graph_tree_items.order_key"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree_items.id, graph_tree_items.title, graph_tree_items.order_key, graph_tree_items.host_id, graph_tree_items.host_grouping_type, host.description as hostname from graph_tree_items left join host on (host.id=graph_tree_items.host_id) left join user_auth_perms on (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=229) where graph_tree_items.graph_tree_id=4 and !(user_auth_perms.user_id is not null and graph_tree_items.host_id > 0) and graph_tree_items.local_graph_id = 0 order by graph_tree_items.order_key"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree_items.id, graph_tree_items.title, graph_tree_items.order_key, graph_tree_items.host_id, graph_tree_items.host_grouping_type, host.description as hostname from graph_tree_items left join host on (host.id=graph_tree_items.host_id) left join user_auth_perms on (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=229) where graph_tree_items.graph_tree_id=3 and !(user_auth_perms.user_id is not null and graph_tree_items.host_id > 0) and graph_tree_items.local_graph_id = 0 order by graph_tree_items.order_key"
03/15/2017 11:26:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree_items.id, graph_tree_items.title, graph_tree_items.order_key, graph_tree_items.host_id, graph_tree_items.host_grouping_type, host.description as hostname from graph_tree_items left join host on (host.id=graph_tree_items.host_id) left join user_auth_perms on (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=229) where graph_tree_items.graph_tree_id=5 and !(user_auth_perms.user_id is not null and graph_tree_items.host_id > 0) and graph_tree_items.local_graph_id = 0 order by graph_tree_items.order_key"
03/15/2017 11:26:07 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=229) where user_auth_perms.user_id is null order by graph_tree.name"
03/15/2017 11:26:07 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from graph_tree where id=1"
03/15/2017 11:26:07 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from graph_tree where id=1"
03/15/2017 11:26:07 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_trees from user_auth where id=229"

03/15/2017 11:26:07 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_id from user_auth_perms where user_id=229 and type=2 and item_id=2"
03/15/2017 11:26:07 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
03/15/2017 11:26:07 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM plugin_realms"
03/15/2017 11:26:07 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'aggregate' AND file = 'aggregate_templates.php,aggregate_templates_items.php,color_templates.php,color_templates_items.php'"
03/15/2017 11:26:07 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'rrdclean' AND file = 'rrdcleaner.php,rrdmove.php'"
03/15/2017 11:26:07 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select order_key,title,host_id,host_grouping_type from graph_tree_items where id=0"

03/15/2017 11:26:07 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select title,local_graph_id,host_id from graph_tree_items where id=0"

03/15/2017 11:26:07 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select name from graph_tree where id=1"
03/15/2017 11:26:07 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree_items.id, graph_tree_items.title, graph_tree_items.local_graph_id, graph_tree_items.rra_id, graph_tree_items.order_key, graph_templates_graph.title_cache as title_cache from (graph_tree_items,graph_local) left join graph_templates_graph on (graph_tree_items.local_graph_id=graph_templates_graph.local_graph_id and graph_tree_items.local_graph_id>0) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=229) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=229) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=229)) where graph_tree_items.graph_tree_id=1 and graph_local.id=graph_templates_graph.local_graph_id and graph_tree_items.order_key like '___000000000000000000000000000000000000000000000000000000000000000000000000000000000000000' and graph_tree_items.local_graph_id>0 and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) group by graph_tree_items.id order by graph_tree_items.order_key"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM plugin_realms"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'aggregate' AND file = 'aggregate_templates.php,aggregate_templates_items.php,color_templates.php,color_templates_items.php'"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'rrdclean' AND file = 'rrdcleaner.php,rrdmove.php'"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_settings'"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'valid_host_fields'"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_form'"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'auth_alternate_realms'"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='229' and user_auth_realm.realm_id='7'"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM plugin_realms"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'aggregate' AND file = 'aggregate_templates.php,aggregate_templates_items.php,color_templates.php,color_templates_items.php'"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'rrdclean' AND file = 'rrdcleaner.php,rrdmove.php'"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_graph_header'"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from user_auth where id=229"

03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where realm_id=8 and user_id=229"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_title'"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_graph_refresh'"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_head'"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_graph_header_tabs'"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'draw_navigation_text'"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=229"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_trees from user_auth where id=229"

03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=229) where user_auth_perms.user_id is null order by graph_tree.name"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_hosts from user_auth where id=229"

03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree_items.id, graph_tree_items.title, graph_tree_items.order_key, graph_tree_items.host_id, graph_tree_items.host_grouping_type, host.description as hostname from graph_tree_items left join host on (host.id=graph_tree_items.host_id) left join user_auth_perms on (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=229) where graph_tree_items.graph_tree_id=2 and !(user_auth_perms.user_id is not null and graph_tree_items.host_id > 0) and graph_tree_items.local_graph_id = 0 order by graph_tree_items.order_key"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree_items.id, graph_tree_items.title, graph_tree_items.order_key, graph_tree_items.host_id, graph_tree_items.host_grouping_type, host.description as hostname from graph_tree_items left join host on (host.id=graph_tree_items.host_id) left join user_auth_perms on (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=229) where graph_tree_items.graph_tree_id=4 and !(user_auth_perms.user_id is not null and graph_tree_items.host_id > 0) and graph_tree_items.local_graph_id = 0 order by graph_tree_items.order_key"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree_items.id, graph_tree_items.title, graph_tree_items.order_key, graph_tree_items.host_id, graph_tree_items.host_grouping_type, host.description as hostname from graph_tree_items left join host on (host.id=graph_tree_items.host_id) left join user_auth_perms on (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=229) where graph_tree_items.graph_tree_id=3 and !(user_auth_perms.user_id is not null and graph_tree_items.host_id > 0) and graph_tree_items.local_graph_id = 0 order by graph_tree_items.order_key"
03/15/2017 11:31:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree_items.id, graph_tree_items.title, graph_tree_items.order_key, graph_tree_items.host_id, graph_tree_items.host_grouping_type, host.description as hostname from graph_tree_items left join host on (host.id=graph_tree_items.host_id) left join user_auth_perms on (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=229) where graph_tree_items.graph_tree_id=5 and !(user_auth_perms.user_id is not null and graph_tree_items.host_id > 0) and graph_tree_items.local_graph_id = 0 order by graph_tree_items.order_key"
03/15/2017 11:31:11 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=229) where user_auth_perms.user_id is null order by graph_tree.name"
03/15/2017 11:31:11 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from graph_tree where id=1"
03/15/2017 11:31:11 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from graph_tree where id=1"
03/15/2017 11:31:11 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_trees from user_auth where id=229"

03/15/2017 11:31:11 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_id from user_auth_perms where user_id=229 and type=2 and item_id=2"
03/15/2017 11:31:11 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
03/15/2017 11:31:11 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM plugin_realms"
03/15/2017 11:31:11 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'aggregate' AND file = 'aggregate_templates.php,aggregate_templates_items.php,color_templates.php,color_templates_items.php'"
03/15/2017 11:31:11 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'rrdclean' AND file = 'rrdcleaner.php,rrdmove.php'"
03/15/2017 11:31:11 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select order_key,title,host_id,host_grouping_type from graph_tree_items where id=0"

03/15/2017 11:31:11 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select title,local_graph_id,host_id from graph_tree_items where id=0"

03/15/2017 11:31:11 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select name from graph_tree where id=1"
03/15/2017 11:31:11 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree_items.id, graph_tree_items.title, graph_tree_items.local_graph_id, graph_tree_items.rra_id, graph_tree_items.order_key, graph_templates_graph.title_cache as title_cache from (graph_tree_items,graph_local) left join graph_templates_graph on (graph_tree_items.local_graph_id=graph_templates_graph.local_graph_id and graph_tree_items.local_graph_id>0) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=229) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=229) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=229)) where graph_tree_items.graph_tree_id=1 and graph_local.id=graph_templates_graph.local_graph_id and graph_tree_items.order_key like '___000000000000000000000000000000000000000000000000000000000000000000000000000000000000000' and graph_tree_items.local_graph_id>0 and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) group by graph_tree_items.id order by graph_tree_items.order_key"


Top
 Profile  
 
 Post subject: Re: my graph stop to update - RT works fine - RRD process =
PostPosted: Wed Mar 15, 2017 12:08 pm 
Offline
Cacti User

Joined: Thu Mar 29, 2012 2:19 am
Posts: 69
you have post sql log
in order to help you, try to grep the log according to the relevant RRD or host


Top
 Profile  
 
 Post subject: Re: my graph stop to update - RT works fine - RRD process =
PostPosted: Wed Mar 15, 2017 1:08 pm 
Offline

Joined: Tue Mar 14, 2017 4:59 pm
Posts: 12
Not even the single rrd is updating....realtime is working ..i think poller.php is amso not completing..

PHP Deprecated: Function split() is deprecated in /u/cacti-0.8.7b/plugins/boost/poller_boost.php on line 253
PHP Deprecated: Function split() is deprecated in /u/cacti-0.8.7b/plugins/boost/poller_boost.php on line 169
03/15/2017 12:15:01 AM - SYSTEM BOOST STATS: Time:0.0189 RRDUpdates:0


Top
 Profile  
 
 Post subject: Re: my graph stop to update - RT works fine - RRD process =
PostPosted: Mon Mar 20, 2017 12:39 am 
Offline
Developer

Joined: Thu Apr 07, 2005 3:29 pm
Posts: 2523
Location: B/CS Texas
What version of PHP are you running?

_________________
CactiEZ CD


Top
 Profile  
 
 Post subject: Re: my graph stop to update - RT works fine - RRD process =
PostPosted: Mon Mar 20, 2017 9:27 am 
Offline

Joined: Tue Mar 14, 2017 4:59 pm
Posts: 12
/opt/php-5.2/bin/php :o


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 14 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: Google Adsense [Bot], Yahoo [Bot] and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group