Boost Plugin v1.6 Released

[dagonet]

Hello,
how do I get rid of these messages:
"ERROR: illegal attempt to update using time 1188129001 when last update time is 1188129001 (minimum one second step)"

Greetings
Dagonet

[TheWitness]

You should backoff if this is an old version. There must be some issue.

Is this a new install?

Larry

[dagonet]

You should backoff if this is an old version. There must be some issue.

Is this a new install?

Larry

I used version 1.6. I did a reinstall and delete the tables in the database and recreated them with the sql script supplied.
But still no success. The rras stop updating immediatly after activating the boost plugin.
In the log I see those messages:

08/27/2007 04:22:25 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "CREATE TEMPORARY TABLE `rcaston` ( `local_data_id` mediumint(8) unsigned NOT NULL default '0', `rrd_name` varchar(19) NOT NULL default '', `time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`local_data_id`,`rrd_name`,`time`)) ENGINE=MEMORY"

Regards
Dagonet

[TheWitness]

What version of MySQL. To disable, you must remove the entry from config.php?

If version 4.x of mysql, you must upgrade to 5.x. To continue to use Boost. Not supporting MySQL 4.x.

TheWitness

[gninja]

At a new company, setting up a cacti instance so I can migrate them off of cricket. Grabbed newest cacti/cactid/pluginarch/boost, a couple days ago.

Had some issues getting php and apache and freebsd 6.1 working nicely, but it's up now.

Only, boost is broken.

Boost server's disabled entirely for now, if I turn on on-demand updating, the graphs stop updating, and if I run:

# sudo -u www php ./poller_boost.php -f -d

I get an unending spew of:

ERROR: illegal attempt to update using time 1188522300 when last update time is 1188522300 (minimum one second step)
ERROR: illegal attempt to update using time 1188522300 when last update time is 1188522300 (minimum one second step)
ERROR: illegal attempt to update using time 1188522300 when last update time is 1188522300 (minimum one second step)

I've got 19 data sources, and <100 boost records right now. Mysql heap settings look fine, permissions on everything look good...

cacti-0.8.6j, cactid-0.8.6i, plugin-arch 1.1, boost 1.6, freebsd 6.1, apache 2.2.4, php 5.2.3

[TheWitness]

disable the plugin entirely by removing from config.php

[gninja]

No advice as to what might be wrong? This isn't a production server yet, but once it is, I'll be putting a lot more load onto it than a boost-free server can handle...

[TheWitness]

My guess is that #1, the `rcaston` temporary table is not being created as it must, or you have two boost processes running at the same time, causing the `rcaston` table not to be created for that reason. This does not make sense as it is supposed to be "HIDDEN" between sessions. Maybe it's a persistent connection issue.

I'll look at the code a little more. The changes were pretty esoteric.

Larry

[driden91]

hy

i have a question :

I use cacti in my enterprise for monitor 240 hosts actually, but my poller spend between 80 and 95 seconds for 5,35k datasources and 3.58k RRD's.

I think that it is too long no ?

so i want use boost plugins , it's a good idea ?

i use cacti 0.8.6j and mysql5 and php5 and weathermap plugin it's compatible ?

it's very dangerous for the stability to cacti ?


sorry for my english

[leonardo_gyn]

My personal experiences showed that getting cactid running is somehow simple and it usually lowers a lot your polling processes times.

I have experienced boost plugin which is a AWESOME piece of software. But in almost all cases, only changing cmd.php to cactid seems to get things in 'acceptable' situations.

Anyway, i do not have VERY big networks to monitor. In that cases, certainly boost would do it's job.

But if you're running in 90 seconds, maybe cactid will get that to 45-50 ..... try it !

[driden91]

i use cactid already

[leonardo_gyn]

As i understood, boost will NOT change the polling process. The major improvements by boost is that it lowers down the I/O, basically with some hard caching of polling results for later (or periodically) RRD updates.

Instead of RRD updating every polling process as normal cmd.php/cactid does, boost cames to get those updates smarter and done only sometimes.

I dont think boost will make big difference on running times ..... it can make a great difference if your machine is suffering from I/O problems and, in that case, reducing I/O needs by the polling process will make things run faster.

But if I/O is not a major problem for your cacti machine, i dont think boost will lower that time too much ....

As you already run cactid, i would try to get some more threads and watch for the runtime !!

[driden91]

that's my I/O
i'use a SAS disk 10k



in average 5 people are connecting at the same time and the pictures
are often long has wiewing

[changsung]

Normaly poller_output_boost table is full of data but now the table is empty.

I was having probelm with high CPU utilization on boost_server so I shut is off and restart. All the RRD is beeing update in normal way.

- Boost Server Status

telnet localhost 9050
Trying 127.0.0.1...
Connected to localhost (127.0.0.1).
Escape character is '^]'.
2007:09:26 16:04:43 - Host Connected '127.0.0.1'
2007:09:26 16:04:43 - Host Validated '127.0.0.1'
status
2007:09:26 16:04:51 - Server Status OK '127.0.0.1'
Server Status OKConnection closed by foreign host.


- Cacti log file

09/26/2007 04:05:14 PM - SYSTEM STATS: Time:13.5479 Method:cactid Processes:2 Threads:64 Hosts:128 HostsPerProcess:64 DataSources:2550 RRDsProcessed:1880


- Boost server is running
# ps -ef | grep php

root 3766 25481 0 16:06 pts/3 00:00:00 grep php
root 15512 25481 0 Sep25 pts/3 00:00:00 /usr/bin/php -q /bb/pm/cacti/cur/plugins/boost/boost_server.php

#

- Boost setting - from settings table

boost_rrd_update_enable on
boost_rrd_update_system_enable on boost_rrd_update_base_time 12:00am
boost_rrd_update_interval 10
boost_rrd_update_max_records 1000000
boost_rrd_update_max_records_per_select 50000
boost_mysql_string_length 512000
boost_rrd_update_string_length 8192 boost_rrd_update_max_runtime 600
boost_server_enable on boost_server_effective_user root
boost_server_multiprocess 0
boost_path_rrdupdate /usr/bin/rrdupdate
boost_server_hostname localhost
boost_server_listen_port 9050
boost_server_timeout 2 boost_server_clients 127.0.0.1
boost_png_cache_enable on
boost_png_cache_directory /cacti/img-cache
boost_prev_base_time 2007-09-26 0:00:00
boost_last_run_time 2007-09-26 16:07:15
boost_next_run_time - 2007-09-26 16:17:15
boost_poller_status - complete - end time:2007-09-2616:07:15
stats_boost - Time:0.0151 RRDUpdates:0


Please help me trouble shoot this.

[TheWitness]

It's not clear what your problem is.