Errors in Log When Viewing Graphs with Boost

deu439356 · Post by **deu439356** » Thu Oct 16, 2008 8:39 am

Whenever someone views graphs in Cacti, I get the following errors"

10/16/2008 08:33:33 AM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
10/16/2008 08:33:32 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/16/2008 08:33:32 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/16/2008 08:33:32 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/16/2008 08:33:32 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/16/2008 08:33:32 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"

The data on the graphs seems to be correct and the system doesn't seem to be affected. If graphs are NOT being viewed, then we don't get any errors. I was told the 2006 error was mysql dropping the connection, but I have checked the logs and that doesn't seem to be the problem. Does any one know how to correct the problem or what to look for? I am running 8.7b with the latest SVN of Boost.

Post by **gandalf** » Thu Oct 16, 2008 10:17 am

Moving to Plugins because it's a boost thingy
Reinhard

deu439356 · Post by **deu439356** » Thu Oct 16, 2008 10:20 am

Post by **TheWitness** » Fri Oct 17, 2008 6:26 am

Looks like MySQL is crashing. Check the MySQL log and see if you have a more recent version of MySQL available.

TheWitness

deu439356 · Post by **deu439356** » Fri Oct 17, 2008 7:48 am

Is there something we should be looking for specifically? I have checked the logs and haven't found anything related to a broken connection or the poller_output_boost_processes table. We are running mysql 5.0.45.

Post by **TheWitness** » Fri Oct 17, 2008 11:40 am

Segmentation faults, core files, etc.

TheWitness

deu439356 · Post by **deu439356** » Fri Oct 17, 2008 1:10 pm

We didn't find any core dumps or segmenation fault errors. In fact there are no errors in our mysql.err log. Any other suggestions?

Post by **TheWitness** » Fri Oct 17, 2008 4:06 pm

Don't run the boost server for now.

TheWitness

deu439356 · Post by **deu439356** » Tue Oct 21, 2008 3:49 pm

OK. Is there a guide on how to set up my box to take over for the boost server?

Post by **TheWitness** » Tue Oct 21, 2008 7:45 pm

Easiest thing to do is simply have the Apache server perform the updates and don't use boost server.

TheWitness

deu439356 · Post by **deu439356** » Thu Oct 23, 2008 7:40 am

How do I go about setting up the Apache Server?

deu439356 · Post by **deu439356** » Mon Nov 24, 2008 11:47 am

Does anyone know how to set up the apache server to perform the updates instead of the boost server? Also, is the apache server faster than the boost server?

gthe · Post by **gthe** » Tue Dec 02, 2008 3:41 pm

deu439356 wrote:Whenever someone views graphs in Cacti, I get the following errors"

10/16/2008 08:33:33 AM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
10/16/2008 08:33:32 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/16/2008 08:33:32 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/16/2008 08:33:32 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/16/2008 08:33:32 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/16/2008 08:33:32 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"

The data on the graphs seems to be correct and the system doesn't seem to be affected. If graphs are NOT being viewed, then we don't get any errors. I was told the 2006 error was mysql dropping the connection, but I have checked the logs and that doesn't seem to be the problem. Does any one know how to correct the problem or what to look for? I am running 8.7b with the latest SVN of Boost.

I have this errors only when in system more than one boost_server.php are running.
May be add in boost_server function to check - if they are already running ?

Post by **TheWitness** » Tue Dec 02, 2008 5:55 pm

The right way to do the boost_server.php is making it an inittab process. There is a post somewhere on how to do that. However, if you lookup that error number in the MySQL manual, it means that the MySQL server is down.

TheWitness

Post by **TheWitness** » Wed Dec 03, 2008 11:18 am

Boost 2.0 is official. Please Check it Out Here:

http://forums.cacti.net/viewtopic.php?p=150337#150337

Regards,

TheWitness

Cacti

Errors in Log When Viewing Graphs with Boost

Errors in Log When Viewing Graphs with Boost

Re: Errors in Log When Viewing Graphs with Boost

Who is online