Multiple SQL Row Failed errors and missing data from graphs

[doobie76]

Hi TheWitness

I now get lots of host_id=N, when using either permutation of the change suggested:

11/07/2011 05:30:50 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"select field_value from host_snmp_cache where host_id=N and field_name='hrStorageAllocationUnits' and snmp_index='2'"
11/07/2011 05:30:50 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"select field_value from host_snmp_cache where host_id=N and field_name='hrStorageAllocationUnits' and snmp_index='2'"
11/07/2011 05:30:50 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"select field_value from host_snmp_cache where host_id=N and field_name='hrStorageAllocationUnits' and snmp_index='4'"
11/07/2011 05:30:50 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"select field_value from host_snmp_cache where host_id=N and field_name='hrStorageAllocationUnits' and snmp_index='4'"
11/07/2011 05:30:50 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"select field_value from host_snmp_cache where host_id=N and field_name='hrStorageAllocationUnits' and snmp_index='5'"

Can you offer any help? Where is host_id N coming from?

[TheWitness]

Please update lib/variables.php from SVN. If running PIA, then goto PIA/trunk/lib/variables.php. If not running PIA, goto /branches/0.8.7/lib/variables.php

TheWitness

[doobie76]

I've checked my version of variables.php and with the changes I made its identical to the one in SVN. I'm running on windows so not aware that I can use SVN as you would on linux.

[doobie76]

It looks like I had a datasource for a device called NAS which was just picking up the first letter of the name N. I've deleted that device and recreated it and seems ok now.

Still not entirely sure why it was failing but its sorted now.

Thanks for your help.

Darren

[cjolly3053]

Please update lib/variables.php from SVN. If running PIA, then goto PIA/trunk/lib/variables.php. If not running PIA, goto /branches/0.8.7/lib/variables.php

TheWitness

Do not see the directory PIA??? The top is cacti then goes to archive, branches, and tags... I'm using plugin architecture so looking for this patch. I have removed all plugins and all but three devices that I re-added and getting a lot of the SQL errors.

03/14/2012 08:46:06 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"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=) order by graph_tree.name"
03/14/2012 08:46:06 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
03/14/2012 08:46:06 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT DISTINCT graph_tree_items.local_graph_id, graph_tree_items.host_id FROM graph_tree_items LEFT JOIN graph_templates_graph ON (graph_templates_graph.local_graph_id=graph_tree_items.local_graph_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=) OR (graph_tree_items.host_id=user_auth_perms.item_id AND user_auth_perms.type=3 AND user_auth_perms.user_id=) OR (graph_templates_graph.graph_template_id=user_auth_perms.item_id AND user_auth_perms.type=4 AND user_auth_perms.user_id=)) WHERE graph_tree_items.title='' AND graph_tree_items.graph_tree_id=1 ORDER BY graph_tree_items.order_key"
03/14/2012 08:46:06 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT realm_id FROM user_auth_realm WHERE realm_id=8 AND user_id="
03/14/2012 08:46:06 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM user_auth WHERE id="

[cjolly3053]

Please update lib/variables.php from SVN. If running PIA, then goto PIA/trunk/lib/variables.php. If not running PIA, goto /branches/0.8.7/lib/variables.php

TheWitness

So is the variables.php the same now for PIA and without???? Saw something about changes being merged into the branch for PIA?

[gandalf]

Yes. in current SVN, we migrated PIA to core. So there's no difference any more
R.