Boost 1.6 errors - CMDPHP: Poller[0] ERROR: SQL Assoc

[limahl]

Hi all,

I'm running the latest posted version of Cacti and spine on a Fedora 9 system with PI 2.2 and Boost 1.6. Boost on-demand is turned on. MySQL is 5.0.51a

The issue is that when I go and bring up a segment of the tree to view a series of graphs, the server bogs right down to a crawl as it tries to process the request and display each graph. The graphs can take anywheres from 15-30 seconds to come up (painful when you're looking for the 30th graph on the page). During that time, if you look at the error log, you see a bunch of these (wth the top line being the last one after the process of pulling up the graphs completes):

09/09/2008 06:51:54 AM - BOOST: Poller[0] ERROR: Timeout detected. Boost server is down. Contact support immediately!!
09/09/2008 06:51:54 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
09/09/2008 06:51:54 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
09/09/2008 06:51:54 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
09/09/2008 06:51:54 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
(lots more errors of the same message inserted here)



The boost server is indeed running though (I can telnet to it and it response happily).

I have tried to pull the 1.7 code down from SVN, but for whatever reason when I try to execute the code, nothing happens. I get no errors, nothing. It just exits out.


Any thoughts? I have 2 servers running Cacti, Spine, Boost and both are having the same issue.

Thanks in advance.

[TheWitness]

From the MySQL Manual

Error: 2006 (CR_SERVER_GONE_ERROR)

Message: MySQL server has gone away

MySQL is crashing. You likely are not able to create a large enough memory table due to a MySQL setting. Try the following:

Code: Select all

mysql cacti
alter table poller_output_boost engine=myisam;

Make sure you are running MySQL 5.x

TheWitness

[limahl]

From the MySQL Manual

Error: 2006 (CR_SERVER_GONE_ERROR)

Message: MySQL server has gone away

MySQL is crashing. You likely are not able to create a large enough memory table due to a MySQL setting. Try the following:

Code: Select all

mysql cacti
alter table poller_output_boost engine=myisam;

Make sure you are running MySQL 5.x

TheWitness

I'm afraid that didn't help. I'm running 5.0.51 under FC9. Is there a memory setting in the my.cnf I should bump from the standard defaults?