Boost 3.0 Released

[zorrosam]

Guys,

after the upgrade to 3.0 ver my test installation is broken.

This is the error of my cacti.log

04/21/2010 05:50:38 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1163', SQL:"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', `output` text NOT NULL, PRIMARY KEY (`local_data_id`,`rrd_name`,`time`), KEY `time_local_data_id` (`time`,`local_data_id`)) ENGINE=MEMORY DEFAULT CHARSET=latin1'
04/21/2010 05:50:38 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT local_data_id, UNIX_TIMESTAMP(time) AS time, rrd_name, output FROM rcaston ORDER BY local_data_id ASC, time ASC, rrd_name ASC "
04/21/2010 05:50:38 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"INSERT INTO `rcaston` SELECT * FROM poller_output_boost WHERE time<='2010-04-21 16:50:03' AND local_data_id BETWEEN 5 AND 254'
04/21/2010 05:50:38 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1163', SQL:"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', `output` text NOT NULL, PRIMARY KEY (`local_data_id`,`rrd_name`,`time`), KEY `time_local_data_id` (`time`,`local_data_id`)) ENGINE=MEMORY DEFAULT CHARSET=latin1'
04/21/2010 05:50:38 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT local_data_id, UNIX_TIMESTAMP(time) AS time, rrd_name, output FROM rcaston ORDER BY local_data_id ASC, time ASC, rrd_name ASC "

furthermore i'd like to obtain a procedure for configure correctly on my most important cacti installation (all my DSL NETWORK).

Today the server is overloaded and works with spine.

Please help me.

zorro!

[TheWitness]

Please move away from text fields. Use varchar(xxx) instead. Also, if you read the MySQL manual, this things become a bit more self evident.

TheWitness

[TheWitness]

3.1 is released. However, the issue with the use of Text Fields remains. If you are using MySQL 4--, you should upgrade to MySQL 5.x and change the "output" column in the poller_output table to varchar(XX). That will resolve your issue.

TheWitness

[X-dark]

Turn of Balance Processes plus 60 ss timeout is bad.

TheWitness

Can you be more specific ?

[TheWitness]

A timeout of 60 seconds is very bad, and will cause the poller to stall.

TheWitness

[X-dark]

A timeout of 60 seconds is very bad, and will cause the poller to stall.

TheWitness

OK. So there no problem using Balance Processes option with Boost and direct population of poller_output_boost ?

[TheWitness]

There were some problems reported earlier in the deployment, but they were a bit of corner cases.

TheWitness

[X-dark]

OK. Thanks.