|
felici
New User
Joined: Sun Sep 21, 2008 7:56 pm
Posts: 1
|
 CactiEZ stopped working Howdy - Running the last CactiEZ, cacti 0.8.7b, been running for while in production, then graphs stopped being made... logs complain about CMDPHP Poller Errors ...
09/21/2008 07:30:02 PM - SYSTEM STATS: Time:0.0122 Method:spine Processes:1 Threads:30 Hosts:0 HostsPerProcess:0 DataSources:984 RRDsProcessed:0
09/21/2008 07:30:02 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1194', SQL:"select id from host where disabled = '' order by id"
09/21/2008 07:28:36 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1194', SQL:"select graph_tree_items.title, graph_tree_items.order_key, graph_tree_items.host_id, graph_tree_items.host_grouping_type, host.id, host.description, host.status, host.hostname, host.cur_time, host.status_rec_date, host.status_fail_date, host.availability from graph_tree_items left join host on (host.id=graph_tree_items.host_id) where graph_tree_items.graph_tree_id=2 and ((host.disabled = '' and host.monitor = 'on') or (title != '')) and graph_tree_items.local_graph_id = 0 order by graph_tree_items.order_key"
09/21/2008 07:28:36 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1194', SQL:"select graph_tree_items.title, graph_tree_items.order_key, graph_tree_items.host_id, graph_tree_items.host_grouping_type, host.id, host.description, host.status, host.hostname, host.cur_time, host.status_rec_date, host.status_fail_date, host.availability from graph_tree_items left join host on (host.id=graph_tree_items.host_id) where graph_tree_items.graph_tree_id=2 and ((host.disabled = '' and host.monitor = 'on') or (title != ''))and host.status < 2 and host.id > 0 and graph_tree_items.local_graph_id = 0 order by graph_tree_items.order_key"
09/21/2008 07:28:24 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1194', SQL:"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=1) 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"
09/21/2008 07:26:59 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1194', SQL:"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=1) 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"
09/21/2008 07:26:59 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1194', SQL:"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=1) 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"
I found some references to some patches regarding problems like this, did not know 1) if they are already applied in cactiez, and 2) how to apply in the production cactiez, since the install source tree as installed is not present...
Any suggestions on what to try next sincerely, appreciated...
|
