[RESOLVED] Boost 3.0 DB Error

[Jason.S]

Hello,


I just updated from boost 2.1 to 3.0 today and I am now getting this error.

Code: Select all

02/19/2010 04:03:00 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO `rcaston` SELECT * FROM poller_output_boost WHERE time<='2010-02-19 16:02:59' AND local_data_id BETWEEN 19 AND 3568'

With boost on, I am getting gaps in my graphs......most likely due to this error. Before the upgrade, it was working fine. I am also having problems install plug-ins, but I am not sure if these two problems are related.

[TheWitness]

You are having larger problems than you think. This is not so much a boost problem.

1114 (ER_RECORD_FILE_FULL)

InnoDB has run out of free space in the tablespace. You should reconfigure the tablespace to add a new data file

TheWitness

[pheezy]

I appear to be having the same issue, however my innodb is set to autoextend:

Code: Select all

innodb_data_home_dir = /data/mysql/s1000
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=2
innodb_buffer_pool_size=1G
innodb_data_file_path = ibdata1:100M:autoextend
innodb_log_group_home_dir = /data/mysql/s1000

Here's the output from Boost:

Code: Select all

Boost On Demand Updating:	Never Run
Total Data Sources:	5341
Total Boost Records:	237625
Boost Storage Statistics
Database Engine:	MEMORY
Current Boost Table Size:	236 MBytes
Avg Bytes/Record:	1 KBytes
Max Record Length:	307 Bytes
Max Allowed Boost Table Size:	234 MBytes
Estimated Maximum Records:	237553 Records
Runtime Statistics
Last Start Time:	2010-03-01 9:37:57
Last Run Duration:	0 seconds (0% of update frequency)
RRD Updates:	
Peak Poller Memory:	N/A
Detailed Runtime Timers:	N/A
Max Poller Memory Allowed:	1024 MBytes
Run Time Configuration
Update Frequency:	30 Minutes
Next Start Time:	2010-03-01 10:07:57
Maximum Records:	1000000 Records
Maximum Allowed Runtime:	20 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/cacti/boost/images
Cached Files:	12 Files
Cached Files Size:	219 KBytes

Code: Select all

03/01/2010 09:55:44 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO poller_output_boost (local_data_id, rrd_name, time, output) VALUES ('3983','','2010-03-01 09:55:04','FreeSpaceInPagingFiles:Connection refused'), ('3994','','2010-03-01 09:55:02','FreeSpaceInPagingFiles:Connection refused'), ('7368','','2010-03-01 09:55:02','wmi_stats.pl STAT HOSTNAME USER PASSWORD'), ('3986','','2010-03-01 09:55:05','FreeSpaceInPagingFiles:Connection refused'), ('5643','','2010-03-01 09:55:20','FreeSpaceInPagingFiles:Connection refused'), ('3988','','2010-03-01 09:55:31','FreeSpaceInPagingFiles:Connection refused'), ('3982','','2010-03-01 09:55:03','FreeSpaceInPagingFiles:Connection refused'), ('3996','','2010-03-01 09:55:26','FreeSpaceInPagingFiles:Connection refused'), ('3981','','2010-03-01 09:55:02','FreeSpaceInPagingFiles:Connection refused'), ('3980','','2010-03-01 09:55:39','FreeSpaceInPagingFiles:Connection refused'), ('5152','','2010-03-01 09:55:32','FreeSpaceInPagingFiles:Connection refused'), ('6309','','2010-03-01 09:55:30','FreeSpaceInPagingFiles:Connection refused'), ('3992','','2010-03-01 09:55:36','FreeSpaceInPagingFiles:Connection refused'), ('6346','','2010-03-01 09:55:30','FreeSpaceInPagingFiles:Connection refused'), ('8411','','2010-03-01 09:55:23','FreeSpaceInPagingFiles:Connection refused'), ('3987','','2010-03-01 09:55:13','FreeSpaceInPagingFiles:Connection refused'), ('6978','','2010-03-01 09:55:04','FreeSpaceInPagingFiles:Connection refused'), ('3995','','2010-03-01 09:55:22','FreeSpaceInPagingFiles:Connection refused'), ('5114','','2010-03-01 09:55:31','FreeSpaceInPagingFiles:Connection refused'), ('3978','','2010-03-01 09:55:37','FreeSpaceInPagingFiles:Connection refused'), ('3979','','2010-03-01 09:55:38','FreeSpaceInPagingFiles:Connection refused'), ('3993','','2010-03-01 09:55:30','FreeSpaceInPagingFiles:Connection refused'), ('3991','','2010-03-01 09:55:36','FreeSpaceInPagingFiles:Connection refused'), ('3989','','2010-03-01 09:55:21','FreeSpaceInPagingFiles:Connection refused'), ('6827','traffic_out','2010-03-01 09:55:43','3686771494'), ('6827','traffic_in','2010-03-01 09:55:43','830587607'), ('6826','traffic_out','2010-03-01 09:55:43','2887760427'), ('6826','traffic_in','2010-03-01 09:55:43','2799050906'), ('7355','','2010-03-01 09:55:39','AvgDiskReadQueueLength:0 AvgDiskWriteQueueLength:0 AvgDiskQueueLength:0') ON DUPLICATE KEY UPDATE output=VALUES(output)

[TheWitness]

Don't use INNODB for Boost. Big mistake. Either MyISAM (fixed format) or Memory.

TheWitness