Boost 1.7 issues after about 4 hours

[boulan]

I posted this over at cactiusers.net, but thought I'd put it up here in case anyone else has seen the same thing. I just restarted mysql and the errors in the cacti.log have stopped, but so far nothing in the graphs.

Hello, I just got boost installed on a reasonably large cacti installation - about 40,000 oids for now, increasing to around two or three times that. Boost appeared to work great (40,000 oids in about 15 seconds!) for a few hours and then I started gettings error messages like the one below. Anyone have any idea on this?

The end result is that graphs contain no data as of about 5:00 PM or so today, and I installed this around 1:30 PM today with an RRD update interval of 2hrs

Cacti 0.8.7
php 5.2.5
MySQL 5.0.45
Boost 1.7

I used 'boost_sql_memory.sql'
my.cnf has:
max_heap_table_size = 1G
key_buffer = 384M

php.ini has:
memory_limit = 256M


11/13/2007 08:30:16 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO poller_output_boost (local_data_id, rrd_name, time, output) VALUES ('14592','traffic_out','2007-11-13 20:30:04','16705899'), ('14592','traffic_in','2007-11-13 20:30:04','4558022030242'), ('14591','traffic_out','2007-11-13 20:30:04','5696'), ('14591','traffic_in','2007-11-13 20:30:04','U'), ('14590','traffic_out','2007-11-13 20:30:04','8725168703726'), ('13317','traffic_out','2007-11-13 20:30:03','0'), ('13317','traffic_in','2007-11-13 20:30:03','0'), ('13316','traffic_out','2007-11-13 20:30:03','U'), ('13316','traffic_in','2007-11-13 20:30:03','U'), ('13315','traffic_out','2007-11-13 20:30:03','0'), ('13315','traffic_in','2007-11-13 20:30:03','68230652534478'), ('13314','traffic_out','2007-11-13 20:30:03','0'), ('13314','traffic_in','2007-11-13 20:30:03','0'), ('13313','traffic_out','2007-11-13 20:30:03','0'), ('13313','traffic_in','2007-11-13 20:30:03','0'), ('13312','traffic_out','2007-11-13 20:30:03','0'), ('13312','traffic_in','2007-11-13 20:30:03','0'), ('13311','traffic_out','2007-11-13 20:30:03','U'), ('13311','traffic_in','2007-11-13 20:30:03','U'), ('13310','traffic_out','2007-11-13 20:30:03','207449390787389'), ('13310','traffic_in','2007-11-13 20:30:03','532'), ('13309','traffic_out','2007-11-13 20:30:03','0'), ('13309','traffic_in','2007-11-13 20:30:03','0'), ('13308','traffic_out','2007-11-13 20:30:03','0'), ('13308','traffic_in','2007-11-13 20:30:03','4054698'), ('13307','traffic_out','2007-11-13 20:30:03','0'), ('13307','traffic_in','2007-11-13 20:30:03','128483664'), ('13306','traffic_out','2007-11-13 20:30:03','U'), ('13306','traffic_in','2007-11-13 20:30:03','U'), ('13305','traffic_out','2007-11-13 20:30:03','0'), ('13305','traffic_in','2007-11-13 20:30:03','163678687567383'), ('13304','traffic_out','2007-11-13 20:30:03','378350386'), ('13304','traffic_in','2007-11-13 20:30:03','162730776346143'), ('13303','traffic_out','2007-11-13 20:30:03','378352302'), ('13303','traffic_in','2007-11-13 20:30:03','0'), ('13302','traffic_out','2007-11-13 20:30:03','0'), ('13302','traffic_in','2007-11-13 20:30:03','316348466767380'), ('13301','traffic_out','2007-11-13 20:30:03','U'), ('13301','traffic_in','2007-11-13 20:30:03','U'), ('13300','traffic_out','2007-11-13 20:30:03','597768'), ('13300','traffic_in','2007-11-13 20:30:03','795433470950942'), ('13299','traffic_out','2007-11-13 20:30:03','600456'), ('13299','traffic_in','2007-11-13 20:30:03','785676834760255'), ('13298','traffic_out','2007-11-13 20:30:03','601352'), ('13298','traffic_in','2007-11-13 20:30:03','725257930082758'), ('13297','traffic_out','2007-11-13 20:30:03','603208'), ('13297','traffic_in','2007-11-13 20:30:03','632735704006546'), ('13296','traffic_out','2007-11-13 20:30:03','U'), ('13296','traffic_in','2007-11-13 20:30:03','U') ON DUPLICATE KEY UPDATE output=VALUES(output)'

[boulan]

Graphs are working again after the MySQL restart. Any ideas as to what might cause this problem?

[boulan]

Problem came back after about the same amount of time. I'm guessing that the mysql DB is filling up or something similar.

[TheWitness]

Please edit poller.php and change the "$cron_interval" from what it is being set to to a new value of "300".

Then, you should likely PM me so that I can see what is going on.

TheWitness

[boulan]

Alright, I've changed that.. I think the issue is that the boost_rrdupdate is never running and the database (which I did in memory) is filling up - I gave it 1G.