Boost Help

[charlesdf23]

I'm having issues with the latest boost, PIA and cacti.

I keep getting errors about overrun's and CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO poller_output_boost

My settings are:
1hr
500000
2000 Data Sources
64000
9999999999
2gb
40 minutes

I have rrdupdate and cache as well.

[charlesdf23]

Here is my boost ouput.


Boost On Demand Updating: Running
Total Data Sources: 137685
Total Boost Records: 1809404
Boost Storage Statistics
Database Engine: MEMORY
Current Boost Table Size: 975 MBytes
Avg Bytes/Record: 545 Bytes
Max Record Length: 30 Bytes
Max Allowed Boost Table Size: 956 MBytes
Estimated Maximum Records: 1838599 Records
Previous Runtime
Last Start Time: 2009-02-27 7:16:44
Last Run Duration: 1117.3391 Seconds
RRD Updates: 1852204
Peak Poller Memory: 46.05 MBytes
Max Poller Memory Allowed: 2048 MBytes
Run Time Configuration
Update Frequency: 1 Hour
Next Start Time: 2009-02-27 8:16:27
Maximum Records: 500000 Records
Maximum Allowed Runtime: 40 Minutes
Boost Server Details
Server Config Status: Enabled
Multiprocess Server: Multiple Process
Update Timeout: 2 Seconds
Server/Port: localhost@9050
Authorized Update Web Servers: 127.0.0.1
RRDtool Binary Used: /usr/bin/rrdupdate
Image Caching
Image Cacing Status: Enabled
Cache Directory: /var/www/html/cache
Cached Files: 0 Files
Cached Files Size: 0 Bytes

[TheWitness]

You are running out of space on the boost table:

Total Boost Records: 1809404
Database Engine: MEMORY
Current Boost Table Size: 975 MBytes
Avg Bytes/Record: 545 Bytes
Max Record Length: 30 Bytes
Max Allowed Boost Table Size: 956 MBytes
Estimated Maximum Records: 1838599 Records

You need to do a few things:

1) Read the documentation!!
2) flush table "php -q poller_boost.php -f"
3) edit my.cnf and increase "max_heap_table_size="to something bigger""
4) restart mysql
5) resize the output column in mysql "alter table poller_output_boost modify column output varchar(100) not null default ''"

TheWitness

[charlesdf23]

1) Read the documentation!!
Where do I find this?

2) flush table "php -q poller_boost.php -f"
done

3) edit my.cnf and increase "max_heap_table_size="to something bigger""
max_heap_table_size = 4G

4) restart mysql
done

5) resize the output column in mysql "alter table poller_output_boost modify column output varchar(100) not null default ''"
I tried this and it doesn't like it.....
ALTER TABLE `poller_output_boost` COLUMN `output` varchar(100) NOT NULL default;


Any ideas?

thanks in advance?

[TheWitness]

you missed the word "MODIFY".

TheWitness

[TheWitness]

Also "DEFAULT '' ";

[TheWitness]

You should have simply copied and pasted my note. I will change to

Code: Select all

ALTER TABLE poller_output_boost MODIFY COLUMN output VARCHAR(100) NOT NULL DEFAULT ''

tag.

[charlesdf23]

That worked!!!

Now we wait....

[charlesdf23]

Hmmm....

Any other ideas?

Code: Select all

02/27/2009 06:14:49 PM - SYSTEM STATS: Time:47.3944 Method:spine Processes:14 Threads:50 Hosts:743 HostsPerProcess:54 DataSources:134869 RRDsProcessed:0
02/27/2009 06:14:49 PM - BOOST SVR: Poller[0] WARNING: Detected Poller Boost Overrun, Possible Boost Poller Crash

[TheWitness]

What's your maximum run time set to? Its a harmless warning, but there to warn you of something possibly wrong.

TheWitness

[charlesdf23]

40 minutes.

Could it be that my max records is too low and the rrd's are updating too quickly?

[TheWitness]

I always let it run no more frequently than once an hour or two. Also, no cron is required.

TheWitness

[charlesdf23]

I ended up blowing everything away and starting over. This time I did not import the sql file and the errors went away.

Now I am getting poller output being emtpy which I will start a new thread for.

Thanks for the help!!

[TheWitness]

Wow pretty drastic, but if it worked ...

TheWitness