perfSONAR User Q&A and Other Discussion

[Jason Zurawski <>]

Hey Zhi-Wei/Kevin;

This is just a guess - but maybe mysql needs to have a repair done?  Some 
forums I read on the cacti web site seem to indicate that is a good first 
thing to try:

> mysqlcheck -u aaa -p --auto-repair --optimize --all-databases


Let us know if that has any positive impact;

Thanks;

-jason

On Apr 10, 2014, at 7:25 PM, Zhi-Wei Lu 
<>
 wrote:

> Hi all,
>  
> We recently update our system to the latest perfSonar version using “yum 
> update” last week and rebooted system.   We noticed that today that our 
> cacti environment failed since our last reboot.
>  
> There are tons of error message such as the following in the log file:
>  
> 04/10/2014 03:02:37 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, 
> Error:'1146', SQL:"SELECT 1 AS id, ph.name, ph.file, ph.function  FROM 
> plugin_hooks AS ph  LEFT JOIN plugin_config AS pc  ON pc.directory=ph.name  
> WHERE ph.status = 1 AND hook = 'config_arrays'  AND ph.name IN ('settings', 
> 'boost', 'dsstats')  UNION  SELECT pc.id, ph.name, ph.file, ph.function  
> FROM plugin_hooks AS ph  LEFT JOIN plugin_config AS pc  ON 
> pc.directory=ph.name  WHERE ph.status = 1 AND hook = 'config_arrays'  AND 
> ph.name NOT IN ('settings', 'boost', 'dsstats')  ORDER BY id ASC"
>  
> Upon investigating the issue, we noticed that
> /opt/perfsonar_ps/toolkit/web/root/admin/cacti/cacti.sql
> has all the definitions of the missing SQL tables, but our current 
> /var/lib/mysql/cacti does not have the proper table.
>  
> Apparently, this current version if cacti is different from the previous 
> version from the perfSonar packages, what is the proper way to upgrade the 
> mysql cacti database to be consistent with the current version. We would 
> like to keep our previous data if it is possible.
>  
> Thank you very much for your help.
>  
> Zhi-Wei Lu
> IET-CR-Network Operations Center
> University of California, Davis
> (530) 752-0155