Boost 1.7 Error Writing to DB

[generic_user]

I recently upgraded to 8.7a
I had to upgrade the boost plugin as a result. I am now getting errors with the boost piece and the application will not allow me to turn it off.

Here is the majority of errors I am getting....

ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO poller_output_boost
11/29/2007 09:42:35 AM - BOOST SVR: Poller[0] ERROR: Detected Poller Boost Abend, Contact support

When it does seem to be working I am getting this error....

11/29/2007 10:48:29 AM - SYSTEM BOOST STATS: Time:3627.0780 RRDUpdates:5181120
11/29/2007 10:48:29 AM - CMDPHP: Poller[0] FATAL: RRD On Demand Updater Exceeded Runtime Limits!!!
11/29/2007 10:46:33 AM - SYSTEM STATS: Time:92.7521 Method:spine Processes:12 Threads:24 Hosts:1167 HostsPerProcess:98 DataSources:19962 RRDsProcessed:0

I believe this is the reason I have gaps in my graphs (All Machines)

Here is my information from the support tab....

General Information
Date Fri, 30 Nov 2007 08:41:06 -0500
Cacti Version 0.8.7a
Cacti OS win32
SNMP Version net-snmp
RRDTool Version RRDTool 1.2.x
Hosts 1166
Graphs 12590
Data Sources SNMP: 1428
SNMP Query: 1404
Script Query - Script Server: 10190
Total: 13022
Poller Information
Interval 300
Type spine
Items Action[0]: 4227
Action[2]: 15735
Total: 19962
Concurrent Processes 12
Max Threads 24
PHP Servers 2
Script Timeout 5
Max OID 40
Last Run Statistics Time:82.5629 Method:spine Processes:12 Threads:24 Hosts:1167 HostsPerProcess:98 DataSources:19962 RRDsProcessed:0
PHP Information
PHP Version 5.2.5
PHP OS WINNT
PHP uname Windows NT 5.2 build 3790
PHP SNMP Installed
max_execution_time 45
memory_limit 1024M
MySQL Table Information
Name Rows Engine Collation Check Status
cdef 34 MyISAM latin1_swedish_ci OK
cdef_items 86 MyISAM latin1_swedish_ci OK
colors 107 MyISAM latin1_swedish_ci OK
data_input 30 MyISAM latin1_swedish_ci OK
data_input_data 54155 MyISAM latin1_swedish_ci OK
data_input_fields 268 MyISAM latin1_swedish_ci OK
data_local 13023 MyISAM latin1_swedish_ci OK
data_template 89 MyISAM latin1_swedish_ci OK
data_template_data 13112 MyISAM latin1_swedish_ci OK
data_template_data_rra 52455 MyISAM latin1_swedish_ci OK
data_template_rrd 20522 MyISAM latin1_swedish_ci OK
graph_local 12590 MyISAM latin1_swedish_ci OK
graph_template_input 261 MyISAM latin1_swedish_ci OK
graph_template_input_defs 922 MyISAM latin1_swedish_ci OK
graph_templates 70 MyISAM latin1_swedish_ci OK
graph_templates_gprint 7 MyISAM latin1_swedish_ci OK
graph_templates_graph 12660 MyISAM latin1_swedish_ci OK
graph_templates_item 80242 MyISAM latin1_swedish_ci OK
graph_tree 3 MyISAM latin1_swedish_ci OK
graph_tree_items 1537 MyISAM latin1_swedish_ci OK
host 1166 MyISAM latin1_swedish_ci OK
host_graph 1268 MyISAM latin1_swedish_ci OK
host_snmp_cache 46721 MyISAM latin1_swedish_ci OK
host_snmp_query 3515 MyISAM latin1_swedish_ci OK
host_template 10 MyISAM latin1_swedish_ci OK
host_template_graph 28 MyISAM latin1_swedish_ci OK
host_template_snmp_query 25 MyISAM latin1_swedish_ci OK
plugin_discover_hosts 0 MyISAM latin1_swedish_ci OK
plugin_discover_template 1 MyISAM latin1_swedish_ci OK
poller 0 MyISAM latin1_swedish_ci OK
poller_command 0 MyISAM latin1_swedish_ci OK
poller_item 19962 MyISAM latin1_swedish_ci OK
poller_output 112 MyISAM latin1_swedish_ci OK
poller_output_boost 29975 MEMORY latin1_swedish_ci The storage engine for the table doesn't support check
poller_output_boost_processes 0 MEMORY latin1_swedish_ci The storage engine for the table doesn't support check
poller_reindex 3513 MyISAM latin1_swedish_ci OK
poller_time 6 MyISAM latin1_swedish_ci OK
reportit_measurands 0 MyISAM latin1_swedish_ci OK
reportit_reports 0 MyISAM latin1_swedish_ci OK
reportit_rvars 0 MyISAM latin1_swedish_ci OK
reportit_templates 0 MyISAM latin1_swedish_ci OK
reportit_variables 0 MyISAM latin1_swedish_ci OK
rra 5 MyISAM latin1_swedish_ci OK
rra_cf 18 MyISAM latin1_swedish_ci OK
settings 140 MyISAM latin1_swedish_ci OK
settings_graphs 58 MyISAM latin1_swedish_ci OK
settings_tree 0 MyISAM latin1_swedish_ci OK
snmp_query 13 MyISAM latin1_swedish_ci OK
snmp_query_graph 26 MyISAM latin1_swedish_ci OK
snmp_query_graph_rrd 51 MyISAM latin1_swedish_ci OK
snmp_query_graph_rrd_sv 67 MyISAM latin1_swedish_ci OK
snmp_query_graph_sv 48 MyISAM latin1_swedish_ci OK
user_auth 29 MyISAM latin1_swedish_ci OK
user_auth_perms 0 MyISAM latin1_swedish_ci OK
user_auth_realm 70 MyISAM latin1_swedish_ci OK
user_log 248 MyISAM latin1_swedish_ci OK
version 1 MyISAM latin1_swedish_ci OK

PHP Module Information
bcmath
--------------------------------------------------------------------------------

BCMath support enabled


calendar
--------------------------------------------------------------------------------

Calendar support enabled


com_dotnet
--------------------------------------------------------------------------------

COM support enabled
DCOM support disabled
.Net support enabled

Directive Local Value Master Value
com.allow_dcom 0 0
com.autoregister_casesensitive 1 1
com.autoregister_typelib 0 0
com.autoregister_verbose 0 0
com.code_page no value no value
com.typelib_file no value no value


ctype
--------------------------------------------------------------------------------

ctype functions enabled


date
--------------------------------------------------------------------------------

date/time support enabled
"Olson" Timezone Database Version 2007.9
Timezone Database internal
Default timezone America/New_York

Directive Local Value Master Value
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.583333 90.583333
date.sunset_zenith 90.583333 90.583333
date.timezone no value no value


dom
--------------------------------------------------------------------------------

DOM/XML enabled
DOM/XML API Version 20031129
libxml Version 2.6.26
HTML Support enabled
XPath Support enabled
XPointer Support enabled
Schema Support enabled
RelaxNG Support enabled


filter
--------------------------------------------------------------------------------

Input Validation and Filtering enabled
Revision $Revision: 1.52.2.39 $

Directive Local Value Master Value
filter.default unsafe_raw unsafe_raw
filter.default_flags no value no value


ftp
--------------------------------------------------------------------------------

FTP support enabled


hash
--------------------------------------------------------------------------------

hash support enabled
Hashing Engines md2 md4 md5 sha1 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru gost adler32 crc32 crc32b haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5


iconv
--------------------------------------------------------------------------------

iconv support enabled
iconv implementation "libiconv"
iconv library version 1.9

Directive Local Value Master Value
iconv.input_encoding ISO-8859-1 ISO-8859-1
iconv.internal_encoding ISO-8859-1 ISO-8859-1
iconv.output_encoding ISO-8859-1 ISO-8859-1


ISAPI
--------------------------------------------------------------------------------

Server Variable Value
CONTENT_LENGTH 0
PATH_TRANSLATED c:\inetpub\wwwroot\cacti\utilities.php
QUERY_STRING action=view_tech
REMOTE_ADDR 10.22.75.97
REMOTE_HOST 10.22.75.97
REQUEST_METHOD GET
SERVER_NAME uschperfrpt01
SERVER_PORT 443
SERVER_PROTOCOL HTTP/1.1
SERVER_SOFTWARE Microsoft-IIS/6.0
APPL_MD_PATH /LM/W3SVC/1/ROOT
APPL_PHYSICAL_PATH c:\inetpub\wwwroot\
INSTANCE_ID 1
INSTANCE_META_PATH /LM/W3SVC/1
URL /cacti/utilities.php
ALL_HTTP HTTP_CONNECTION:Keep-AliveHTTP_ACCEPT:image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*HTTP_ACCEPT_ENCODING:gzip, deflateHTTP_ACCEPT_LANGUAGE:en-usHTTP_COOKIE:Cacti=d41364620c284f4f748e728e44bea370; clickedFoldert2=1%5E2%5E3%5E4%5E; highlightedTreeviewLinkt2=4HTTP_HOST:uschperfrpt01HTTP_REFERER:https://uschperfrpt01/cacti/utilities.p ... ozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727)HTTP_UA_CPU:x86
HTTPS on
SCRIPT_NAME /cacti/utilities.php
CERT_KEYSIZE 128
CERT_SECRETKEYSIZE 1024
CERT_SERVER_ISSUER E=cssadmin@officedepot.com, C=US, S=FL, L=Delray, O=ODCORP, OU=NA, CN=Office Depot Enterprise NA-CA-2
CERT_SERVER_SUBJECT C=US, S=FL, L=Delray Beach, O="Office Depot, Inc.", OU=IT, CN=uschperfrpt01
HTTPS_KEYSIZE 128
HTTPS_SECRETKEYSIZE 1024
HTTPS_SERVER_ISSUER E=cssadmin@officedepot.com, C=US, S=FL, L=Delray, O=ODCORP, OU=NA, CN=Office Depot Enterprise NA-CA-2
HTTPS_SERVER_SUBJECT C=US, S=FL, L=Delray Beach, O="Office Depot, Inc.", OU=IT, CN=uschperfrpt01
SERVER_PORT_SECURE 1


json
--------------------------------------------------------------------------------

json support enabled
json version 1.2.1


ldap
--------------------------------------------------------------------------------

LDAP Support enabled
RCS Version $Id: ldap.c,v 1.161.2.3.2.3 2007/01/05 15:06:55 iliaa Exp $
Total Links 0/unlimited
API Version 2004
Vendor Name OpenLDAP
Vendor Version 0


libxml
--------------------------------------------------------------------------------

libXML support active
libXML Version 2.6.26
libXML streams enabled


mysql
--------------------------------------------------------------------------------

MySQL Support enabled
Active Persistent Links 1
Active Links 1
Client API version 5.0.22

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off


odbc
--------------------------------------------------------------------------------

ODBC Support enabled
Active Persistent Links 0
Active Links 0
ODBC library Win32

Directive Local Value Master Value
odbc.allow_persistent On On
odbc.check_persistent On On
odbc.default_db no value no value
odbc.default_pw no value no value
odbc.default_user no value no value
odbc.defaultbinmode return as is return as is
odbc.defaultlrl return up to 4096 bytes return up to 4096 bytes
odbc.max_links Unlimited Unlimited
odbc.max_persistent Unlimited Unlimited


pcre
--------------------------------------------------------------------------------

PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 7.3 2007-08-28

Directive Local Value Master Value
pcre.backtrack_limit 100000 100000
pcre.recursion_limit 100000 100000


Reflection
--------------------------------------------------------------------------------

Reflection enabled
Version $Id: php_reflection.c,v 1.164.2.33.2.47 2007/10/28 13:47:14 iliaa Exp $


session
--------------------------------------------------------------------------------

Session Support enabled
Registered save handlers files user
Registered serializer handlers php php_binary wddx

Directive Local Value Master Value
session.auto_start Off Off
session.bug_compat_42 On On
session.bug_compat_warn On On
session.cache_expire 180 180
session.cache_limiter nocache nocache
session.cookie_domain no value no value
session.cookie_httponly Off Off
session.cookie_lifetime 0 0
session.cookie_path / /
session.cookie_secure Off Off
session.entropy_file no value no value
session.entropy_length 0 0
session.gc_divisor 100 100
session.gc_maxlifetime 1440 1440
session.gc_probability 1 1
session.hash_bits_per_character 4 4
session.hash_function 0 0
session.name Cacti PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path C:\PHP\sessiondata C:\PHP\sessiondata
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies Off Off
session.use_trans_sid 0 0


SimpleXML
--------------------------------------------------------------------------------

Simplexml support enabled
Revision $Revision: 1.151.2.22.2.35 $
Schema support enabled


snmp
--------------------------------------------------------------------------------

UCD-SNMP Support enabled
UCD-SNMP Version ucd-snmp-4.2.3


sockets
--------------------------------------------------------------------------------

Sockets Support enabled


SPL
--------------------------------------------------------------------------------

SPL support enabled
Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RegexIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException


standard
--------------------------------------------------------------------------------

Regex Library Bundled library enabled
Dynamic Library Support enabled
Internal Sendmail Support for Windows enabled

Directive Local Value Master Value
assert.active 1 1
assert.bail 0 0
assert.callback no value no value
assert.quiet_eval 0 0
assert.warning 1 1
auto_detect_line_endings 0 0
default_socket_timeout 60 60
safe_mode_allowed_env_vars PHP_ PHP_
safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH
url_rewriter.tags a=href,area=href,frame=src,input=src,form=,fieldset= a=href,area=href,frame=src,input=src,form=,fieldset=
user_agent no value no value


tokenizer
--------------------------------------------------------------------------------

Tokenizer Support enabled


wddx
--------------------------------------------------------------------------------

WDDX Support enabled
WDDX Session Serializer enabled


xml
--------------------------------------------------------------------------------

XML Support active
XML Namespace Support active
libxml2 Version 2.6.26


xmlreader
--------------------------------------------------------------------------------

XMLReader enabled


xmlwriter
--------------------------------------------------------------------------------

XMLWriter enabled


Zend Optimizer
--------------------------------------------------------------------------------

Optimization Pass 1 enabled
Optimization Pass 2 enabled
Optimization Pass 3 enabled
Optimization Pass 4 enabled
Optimization Pass 9 enabled
Zend Loader enabled
License Path no value
Obfuscation level 3


zlib
--------------------------------------------------------------------------------

ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.3
Linked Version 1.2.3

Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value


Additional Modules
Module Name

[generic_user]

11/30/2007 09:01:59 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 ('9619','cpu','2007-11-30 09:01:49','0'), ('9618','cpu','2007-11-30 09:01:49','0'), ('9617','cpu','2007-11-30 09:01:49','0'), ('9616','cpu','2007-11-30 09:01:49','0'), ('9615','proc','2007-11-30 09:01:49','57'), ('9353','hdd_used','2007-11-30 09:01:41','4292476928'), ('9353','hdd_total','2007-11-30 09:01:41','5758255104'), ('9352','hdd_used','2007-11-30 09:01:41','6103513104380'), ('9352','hdd_total','2007-11-30 09:01:41','8502827220990'), ('9351','hdd_used','2007-11-30 09:01:41','19760263168'), ('9351','hdd_total','2007-11-30 09:01:41','106278416384'), ('9350','hdd_used','2007-11-30 09:01:41','0'), ('9348','hdd_used','2007-11-30 09:01:41','154530844672'), ('9350','hdd_total','2007-11-30 09:01:41','0'), ('9348','hdd_total','2007-11-30 09:01:41','214548082688'), ('9347','hdd_used','2007-11-30 09:01:41','12122882048'), ('9347','hdd_total','2007-11-30 09:01:41','70860664832'), ('9346','hdd_used','2007-11-30 09:01:41','8441303040'), ('9346','hdd_total','2007-11-30 09:01:41','70860664832'), ('9345','hdd_used','2007-11-30 09:01:41','7150170112'), ('9345','hdd_total','2007-11-30 09:01:41','23822495744'), ('9344','hdd_used','2007-11-30 09:01:41','10731704320'), ('9344','hdd_total','2007-11-30 09:01:41','12583890944'), ('9342','traffic_out','2007-11-30 09:01:41','3816477324'), ('9342','traffic_in','2007-11-30 09:01:41','2483610270'), ('9341','traffic_out','2007-11-30 09:01:41','1491948213'), ('9341','traffic_in','2007-11-30 09:01:41','1720278753'), ('9339','cpu','2007-11-30 09:01:41','76'), ('9338','cpu','2007-11-30 09:01:41','79'), ('9337','cpu','2007-11-30 09:01:41','76'), ('9336','cpu','2007-11-30 09:01:41','73'), ('9335','cpu','2007-11-30 09:01:41','74'), ('9334','cpu','2007-11-30 09:01:41','75'), ('9333','proc','2007-11-30 09:01:41','85') ON DUPLICATE KEY UPDATE output=VALUES(output)'

[TheWitness]

1.7 does no work. You must use the SVN copy and then Cron the poller_boost.php -f every X minutes to empy the cache. Been too busy to fix it to date.

TheWitness

[generic_user]

Thanks. Will do.

[frdrk]

Is poller_boost supposed to empty the poller_output_boost table, ie the "Current Boost Table Size" should be zero? Or am I missing something here?

Mine doesnt, anyway.. so the boost table fills up quickly and it stops graphing. I'm using newest SVN trunk.