Boost - SQL error

[acornu]

Hi,

I'm getting the error message bellow once in a while, any idea why?

05/28/2009 08:30:29 AM - SYSTEM BOOST STATS: Time:14.4393 RRDUpdates:39779
05/28/2009 08:30:15 AM - SYSTEM STATS: Time:13.9968 Method:spine Processes:6 Threads:32 Hosts:234 HostsPerProcess:39 DataSources:6741 RRDsProcessed:0
05/28/2009 08:25:15 AM - SYSTEM STATS: Time:14.0590 Method:spine Processes:6 Threads:32 Hosts:234 HostsPerProcess:39 DataSources:6741 RRDsProcessed:0
05/28/2009 08:20:15 AM - SYSTEM STATS: Time:13.3969 Method:spine Processes:6 Threads:32 Hosts:234 HostsPerProcess:39 DataSources:6741 RRDsProcessed:0
05/28/2009 08:15:14 AM - SYSTEM STATS: Time:13.3363 Method:spine Processes:6 Threads:32 Hosts:234 HostsPerProcess:39 DataSources:6741 RRDsProcessed:0
05/28/2009 08:10:15 AM - SYSTEM STATS: Time:13.4437 Method:spine Processes:6 Threads:32 Hosts:234 HostsPerProcess:39 DataSources:6741 RRDsProcessed:0
05/28/2009 08:07:30 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SHOW TABLES LIKE '%boost%'"
05/28/2009 08:05:14 AM - SYSTEM STATS: Time:13.3397 Method:spine Processes:6 Threads:32 Hosts:234 HostsPerProcess:39 DataSources:6741 RRDsProcessed:0

thanks in advance..

[kingdbag]

Did you follow all of the steps in the README for boost? You might not have the 2 tables boost requires to run poller_output_boost and poller_output_boost_processes.

Below is what will create those tables for you.

1) You must first choose your RRD update cache database format. There are
two options:

- Memory Resident (MySQL 5.x and Above)
- MyISAM (All Supported MySQL Versions)

The benefit of the Memory Resident impmenentation is that database
exchanges will be very fast and will not delay the system. However,
if your system is rebooted between major update cycles, you can loose
some graph data.

The MyISAM version will increase MySQL load during polling, but does
store the information in a lossless (well almost anyway) format.

IMPORTANT: If you plan on using a memory resident database format,
make sure you set the mysql environment variable "max_heap_table_size"
large enough to accomodate all of your records, else, you will loose
data. This environment must go into either your my.cnf or my.ini file.

To install either format, you must follow the instructions below:

mysql -u <user> -p cacti < "my_chosen_format.sql"

Options here are as follows:

boost_sql_memory.sql, boost_sql_myisam.sql

Note: if you choose the memory table option, you may want to limit the
size of the output field to your maximum output length from all polled
items as MySQL varchar(512) take 512 bytes of memory even if your output
is simply a 'U'.

[acornu]

yes, I do have both those tables.. Boost is showing

mysql> show tables like "%boost%";
+-------------------------------+
| Tables_in_cacti (%boost%) |
+-------------------------------+
| poller_output_boost |
| poller_output_boost_processes |
+-------------------------------+
2 rows in set (0.00 sec)


The error message listed, I only have once in a while, not at every poll, maybe a few times a day. Looks like it's causing holes in the graphs when that happens.

One more thing, is it normal that I see RRDsProcessed:0, and showing processed only when Boost kicks in every 30min?

[TheWitness]

This is a message that the server has gone away. I suggest you convert both poller_output and poller_output_boost to memory tables and/or increase the number of connections to the database. I suspect it is the former.

TheWitness