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
my graph stop to update - RT works fine - RRD process = 0
Moderators: Developers, Moderators
Re: my graph stop to update - RT works fine - RRD process =
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.
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.
Re: my graph stop to update - RT works fine - RRD process =
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?
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?
Re: my graph stop to update - RT works fine - RRD process =
Yes run the script. If its in VMware take a backup before you change anything.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?
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.
Re: my graph stop to update - RT works fine - RRD process =
Thanks for making it clear.
I'll update on sunday
I'll update on sunday
Re: my graph stop to update - RT works fine - RRD process =
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 ..
Re: my graph stop to update - RT works fine - RRD process =
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
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
Re: my graph stop to update - RT works fine - RRD process =
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...
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...
Re: my graph stop to update - RT works fine - RRD process =
can you post relevant debug log?
Re: my graph stop to update - RT works fine - RRD process =
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"
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"
Re: my graph stop to update - RT works fine - RRD process =
you have post sql log
in order to help you, try to grep the log according to the relevant RRD or host
in order to help you, try to grep the log according to the relevant RRD or host
Re: my graph stop to update - RT works fine - RRD process =
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
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
Re: my graph stop to update - RT works fine - RRD process =
What version of PHP are you running?
Re: my graph stop to update - RT works fine - RRD process =
/opt/php-5.2/bin/php 
Who is online
Users browsing this forum: No registered users and 1 guest