boost_server.php consumes 99% cpu

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

dagonet
Cacti User
Posts: 90
Joined: Sat Oct 29, 2005 4:05 pm
Location: Wuerzburg

boost_server.php consumes 99% cpu

Post by dagonet »

Hi folks,
I have a problem with the boost plugin, especially with the boost_server:
when the boost_server runs and nobody accesses the cacti website everything's allright.
But if I access cacti after some 8h the boost_server consumes 99% cpu time and I see in the cacti logfile a lot of errors:
ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"

When this occures I have to stop and start the boost_server and everything is fine. Afterthat I can access the cacti website without any problems.

Regards
Dagonet
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Are you running the server in multiprocess mode?
Reinhard
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

What version of the boost server. There are two out. Also, please answer Reinhard's question. What is PHP memory set to?

Thanks,

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
dagonet
Cacti User
Posts: 90
Joined: Sat Oct 29, 2005 4:05 pm
Location: Wuerzburg

Post by dagonet »

Hi,
@Reinhard: no
@Witness: boost plugin 1.1 and so the provided boost server,
php memory is set to 64 MBytes.

regards
Dagonet
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

Looks like an Infinite loop. Let me see about the code. I'll check back to this post when I have more details as to "why" this may be happening.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

Err, wait. Can you see if you have this table?

poller_output_boost_processes

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

So, this is what you need to do:

1) Start the boost server and redirect your STDOUT and STDERR to a file. Watch that file and post what you find.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
dagonet
Cacti User
Posts: 90
Joined: Sat Oct 29, 2005 4:05 pm
Location: Wuerzburg

Post by dagonet »

TheWitness wrote:So, this is what you need to do:

1) Start the boost server and redirect your STDOUT and STDERR to a file. Watch that file and post what you find.

TheWitness
Hi,
here is the output of that file:
2007:02:21 19:38:07 - Host Connected '127.0.0.1'
2007:02:21 19:38:07 - Host Validated '127.0.0.1'
2007:02:21 19:38:07 - RRD Command 'update /usr/local/daten/www/htdocs/cacti/rra/localhost_cpu_system_18.rrd --template cpu_system 1172082002:585596 1172082302:585826 1172082602:586065 1172082901:586297'
2007:02:21 19:38:07 - Host Connected '127.0.0.1'
2007:02:21 19:38:07 - Host Validated '127.0.0.1'
PHP Warning: session_start(): Cannot find save handler mm in /usr/local/daten/www/htdocs/cacti/include/config.php on line 140
2007:02:21 19:38:07 - RRD Command 'update /usr/local/daten/www/htdocs/cacti/rra/localhost_load_1min_20.rrd --template load_1min 1172082002:0.00 1172082302:0.01 1172082602:0.00 1172082901:0.00'
PHP Warning: session_start(): Cannot find save handler mm in /usr/local/daten/www/htdocs/cacti/include/config.php on line 140
2007:02:21 19:38:17 - Host Connected '127.0.0.1'
2007:02:21 19:38:17 - Host Validated '127.0.0.1'
02/21/2007 07:38:17 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
2007:02:21 19:38:17 - Host Connected '127.0.0.1'
2007:02:21 19:38:17 - Host Validated '127.0.0.1'
02/21/2007 07:38:17 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
2007:02:21 19:38:17 - RRD Command 'update /usr/local/daten/www/htdocs/cacti/rra/localhost_cpu_user_19.rrd --template cpu_user 1172082002:17043921 1172082302:17044618 1172082602:17045308 1172082901:17046059'
PHP Warning: session_start(): Cannot find save handler mm in /usr/local/daten/www/htdocs/cacti/include/config.php on line 140
2007:02:21 19:38:17 - RRD Command 'update /usr/local/daten/www/htdocs/cacti/rra/localhost_load_5min_22.rrd --template load_5min 1172082002:0.02 1172082302:0.01 1172082602:0.00 1172082901:0.00'
PHP Warning: session_start(): Cannot find save handler mm in /usr/local/daten/www/htdocs/cacti/include/config.php on line 140
2007:02:21 19:38:27 - Host Connected '127.0.0.1'
2007:02:21 19:38:27 - Host Validated '127.0.0.1'
02/21/2007 07:38:27 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
2007:02:21 19:38:27 - Host Connected '127.0.0.1'
2007:02:21 19:38:27 - Host Validated '127.0.0.1'
02/21/2007 07:38:27 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
2007:02:21 19:38:27 - RRD Command 'update /usr/local/daten/www/htdocs/cacti/rra/localhost_cpu_nice_17.rrd --template cpu_nice 1172082002:8257 1172082302:8257 1172082602:8257 1172082901:8257'
PHP Warning: session_start(): Cannot find save handler mm in /usr/local/daten/www/htdocs/cacti/include/config.php on line 140
2007:02:21 19:38:27 - RRD Command 'update /usr/local/daten/www/htdocs/cacti/rra/localhost_load_15min_21.rrd --template load_15min 1172082002:0.03 1172082302:0.00 1172082602:0.00 1172082901:0.00'
PHP Warning: session_start(): Cannot find save handler mm in /usr/local/daten/www/htdocs/cacti/include/config.php on line 140
02/21/2007 07:38:37 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
02/21/2007 07:38:37 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
2007:02:21 19:38:38 - Host Connected '127.0.0.1'
2007:02:21 19:38:38 - Host Validated '127.0.0.1'
2007:02:21 19:38:38 - RRD Command 'update /usr/local/daten/www/htdocs/cacti/rra/localhost_mem_free_25.rrd --template mem_free 1172082002:44732 1172082302:67312 1172082602:58584 1172082901:53772'
PHP Warning: session_start(): Cannot find save handler mm in /usr/local/daten/www/htdocs/cacti/include/config.php on line 140
2007:02:21 19:38:39 - Host Connected '127.0.0.1'
2007:02:21 19:38:39 - Host Validated '127.0.0.1'
2007:02:21 19:38:39 - RRD Command 'update /usr/local/daten/www/htdocs/cacti/rra/strato_server_proc_77.rrd --template proc 1172082002:122 1172082302:118 1172082602:128 1172082901:126'
PHP Warning: session_start(): Cannot find save handler mm in /usr/local/daten/www/htdocs/cacti/include/config.php on line 140
2007:02:21 19:38:48 - Host Connected '127.0.0.1'
2007:02:21 19:38:48 - Host Validated '127.0.0.1'
02/21/2007 07:38:48 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
2007:02:21 19:38:48 - RRD Command 'update /usr/local/daten/www/htdocs/cacti/rra/localhost_mem_buffers_23.rrd --template mem_buffers 1172082002:31636 1172082302:32496 1172082602:37240 1172082901:44264'
PHP Warning: session_start(): Cannot find save handler mm in /usr/local/daten/www/htdocs/cacti/include/config.php on line 140
02/21/2007 07:38:49 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
2007:02:21 19:38:50 - Host Connected '127.0.0.1'
2007:02:21 19:38:50 - Host Validated '127.0.0.1'
2007:02:21 19:38:50 - RRD Command 'update /usr/local/daten/www/htdocs/cacti/rra/hetzner_suse_10_1_cpu_289.rrd --template cpu 1172082002:1 1172082302:2 1172082602:1 1172082901:6'
PHP Warning: session_start(): Cannot find save handler mm in /usr/local/daten/www/htdocs/cacti/include/config.php on line 140
2007:02:21 19:38:58 - Host Connected '127.0.0.1'
2007:02:21 19:38:58 - Host Validated '127.0.0.1'
02/21/2007 07:38:58 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
2007:02:21 19:38:58 - RRD Command 'update /usr/local/daten/www/htdocs/cacti/rra/localhost_mem_cache_24.rrd --template mem_cache 1172082002:453340 1172082302:433068 1172082602:436524 1172082901:422744'
PHP Warning: session_start(): Cannot find save handler mm in /usr/local/daten/www/htdocs/cacti/include/config.php on line 140
02/21/2007 07:39:00 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
02/21/2007 07:39:08 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'

Broken connection is as of my view not correct. I did a telnet to port 9050 and got a "Server Status Ok" reply.
And btw. I have the table poller_output_boost_processe.

regards
Dagonet
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

Dagonet,

Please add "boost_server.php" to your array $no_http_header_files in "include/config.php" and see if the MM warning messages go away.

As far as the server broken connections are concerned, I will have to investigate and see if the updates process is forcibly disconnecting without a close request.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
dagonet
Cacti User
Posts: 90
Joined: Sat Oct 29, 2005 4:05 pm
Location: Wuerzburg

Post by dagonet »

Ok, I added "boost_server.php" to your array $no_http_header_files in "include/config.php". The MM warnings disappeared.

Regards
Dagonet
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

Cool. Let me know if that fixes it. I have updated SVN with a more appropriate patch. Awaiting peer review from Cigamit.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
dagonet
Cacti User
Posts: 90
Joined: Sat Oct 29, 2005 4:05 pm
Location: Wuerzburg

Post by dagonet »

Unfortunately the problem is not solved.
Right now the boost_server consumes 99% cpu and in the cactilog I have massive entries of this kind:
03/09/2007 08:18:50 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
03/09/2007 08:18:50 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
03/09/2007 08:18:50 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
03/09/2007 08:18:50 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
03/09/2007 08:18:50 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
03/09/2007 08:18:50 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
03/09/2007 08:18:50 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"

As well as connection broken errors in the logfile.

Dagonet
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Please check, if the table mentioned is in place. With latest boost, it should
Reinhard
dagonet
Cacti User
Posts: 90
Joined: Sat Oct 29, 2005 4:05 pm
Location: Wuerzburg

Post by dagonet »

gandalf wrote:Please check, if the table mentioned is in place. With latest boost, it should
Reinhard
Hi Reinhard,
the table is definitely in place.

Dagonet
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

This is odd, the only way you would get a failure is if the table is damaged. Have you run a repair please.

TheWitnesss
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests