Errors in Log When Viewing Graphs with Boost

deu439356 · Joined: 13 Aug 2008 Posts: 45

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.

gandalf · Posted: Thu Oct 16, 2008 10:17 am Post subject:

Moving to Plugins because it's a boost thingy
Reinhard

deu439356 · Joined: 13 Aug 2008 Posts: 45

TheWitness · Posted: Fri Oct 17, 2008 6:26 am Post subject:

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

TheWitness

deu439356 · Joined: 13 Aug 2008 Posts: 45

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.

TheWitness · Posted: Fri Oct 17, 2008 11:40 am Post subject:

Segmentation faults, core files, etc.

TheWitness

deu439356 · Joined: 13 Aug 2008 Posts: 45

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?

TheWitness · Posted: Fri Oct 17, 2008 4:06 pm Post subject:

Don't run the boost server for now.

TheWitness

deu439356 · Joined: 13 Aug 2008 Posts: 45

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

TheWitness · Posted: Tue Oct 21, 2008 7:45 pm Post subject:

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

TheWitness

deu439356 · Joined: 13 Aug 2008 Posts: 45

How do I go about setting up the Apache Server?

deu439356 · Joined: 13 Aug 2008 Posts: 45

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 · Cacti User Joined: 29 Jul 2006 Posts: 113 Location: RU

TheWitness · Posted: Tue Dec 02, 2008 5:55 pm Post subject:

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

TheWitness · Posted: Wed Dec 03, 2008 11:18 am Post subject:

Boost 2.0 is official. Please Check it Out Here:

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

Regards,

TheWitness