The table 'poller_output_boost' is full

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

Post Reply
antokapo
Posts: 48
Joined: Fri Nov 20, 2015 4:06 am

The table 'poller_output_boost' is full

Post by antokapo »

Hi

We 're experiencing nightly holes in graphs, because of poller_output_boost became full for a couple of hours.

Follows our conf. and boost status :


General Information
Date Tue, 07 Mar 2017 11:26:49 +0100
Cacti Version 0.8.8b
Cacti OS unix
SNMP Version NET-SNMP version: 5.4.3
RRDTool Version RRDTool 1.4.x
Hosts 1554
Graphs 41046
Data Sources Script/Command: 5
SNMP: 2318
SNMP Query: 117528
Script Query - Script Server: 239
Total: 120090
Poller Information
Interval 300
Type SPINE 0.8.8b Copyright 2002-2013 by The Cacti Group
Items Action[0]: 227306
Action[1]: 5
Action[2]: 359
Total: 227670
Concurrent Processes 8
Max Threads 5
PHP Servers 8
Script Timeout 180
Max OID 4
Last Run Statistics Time:35.5913 Method:spine Processes:8 Threads:5 Hosts:1506 HostsPerProcess:189 DataSources:227670 RRDsProcessed:0
PHP Information
PHP Version 5.3.10-1ubuntu3.24
PHP OS Linux
PHP uname Linux netmonitor 3.13.0-96-generic #143~precise1-Ubuntu SMP Tue Aug 30 14:38:06 UTC 2016 x86_64
PHP SNMP Installed
max_execution_time 300
memory_limit 2560M

**************************************************************

Current Boost Status
Boost On Demand Updating: Idle
Total Data Sources: 227670
Pending Boost Records: 226141
Archived Boost Records: 0
Total Boost Records: 226141
Boost Storage Statistics
Database Engine: MEMORY
Current Boost Tables Size: 119 MBytes
Avg Bytes/Record: 552 Bytes
Max Record Length: 30 Bytes
Max Allowed Boost Table Size: 2 GBytes
Estimated Maximum Records: 3441965 Records
Runtime Statistics
Last Start Time: 2017-03-07 11:20:38
Last Run Duration: 1 minutes 57 seconds (3% of update frequency)
RRD Updates: 903926
Peak Poller Memory: 46.51 MBytes
Detailed Runtime Timers: RRDUpdates:903926 TotalTime:117 get_records:19.01 results_cycle:95.34 rrd_filename_and_template:55.17 rrd_lastupdate:6.28 rrdupdate:8.11 delete:1.07 timer_overhead:~9
Max Poller Memory Allowed: 3072 MBytes
Run Time Configuration
Update Frequency: 1 Hour
Next Start Time: 2017-03-07 12:20:38
Maximum Records: 800000 Records
Maximum Allowed Runtime: 20 Minutes
Boost Server Details
Server Config Status: Disabled
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/rrdtool
Image Caching
Image Caching Status: Enabled
Cache Directory: /var/www/cacti/images/cache
Cached Files: 311 Files
Cached Files Size: 8 MBytes

I'm not sure about optimal settings of mysql db ..

Any hint will be appreciated

Thanks

Regards

Antonello
antokapo
Posts: 48
Joined: Fri Nov 20, 2015 4:06 am

Re: The table 'poller_output_boost' is full

Post by antokapo »

Hi increased the tmp_table_size and max_heap size of the underlying Maria DB database to 4 GB !! , but
tonight we have holes in graphs and poller_output_boost full condition.

I suspect some bug or misconfiguration.

Here my CACTI server configuration :


Technical Support
General Information
Date Fri, 10 Mar 2017 10:10:21 +0100
Cacti Version 0.8.8b
Cacti OS unix
SNMP Version NET-SNMP version: 5.4.3
RRDTool Version RRDTool 1.4.x
Hosts 1556
Graphs 41057
Data Sources Script/Command: 5
SNMP: 2320
SNMP Query: 117553
Script Query - Script Server: 239
Total: 120117
Poller Information
Interval 300
Type SPINE 0.8.8b Copyright 2002-2013 by The Cacti Group
Items Action[0]: 227356
Action[1]: 5
Action[2]: 359
Total: 227720
Concurrent Processes 8
Max Threads 5
PHP Servers 8
Script Timeout 180
Max OID 4
Last Run Statistics Time:45.3413 Method:spine Processes:8 Threads:5 Hosts:1508 HostsPerProcess:189 DataSources:227720 RRDsProcessed:0
PHP Information
PHP Version 5.3.10-1ubuntu3.24
PHP OS Linux
PHP uname Linux netmonitor 3.13.0-96-generic #143~precise1-Ubuntu SMP Tue Aug 30 14:38:06 UTC 2016 x86_64
PHP SNMP Installed
max_execution_time 300
memory_limit 2560M
MySQL Table Information
Name Rows Engine Collation
cdef 57 MyISAM latin1_swedish_ci
cdef_items 80 MyISAM latin1_swedish_ci
colors 104 MyISAM latin1_swedish_ci
data_input 13 MyISAM latin1_swedish_ci
data_input_data 1895533 MyISAM latin1_swedish_ci
data_input_fields 51 MyISAM latin1_swedish_ci
data_local 120118 MyISAM latin1_swedish_ci
data_template 107 MyISAM latin1_swedish_ci
data_template_data 120225 MyISAM latin1_swedish_ci
data_template_data_rra 645626 MyISAM latin1_swedish_ci
data_template_rrd 316168 MyISAM latin1_swedish_ci
graph_local 41057 MyISAM latin1_swedish_ci
graph_template_input 134 MyISAM latin1_swedish_ci
graph_template_input_defs 442 MyISAM latin1_swedish_ci
graph_templates 52 MyISAM latin1_swedish_ci
graph_templates_gprint 7 MyISAM latin1_swedish_ci
graph_templates_graph 41109 MyISAM latin1_swedish_ci
graph_templates_item 987558 MyISAM latin1_swedish_ci
graph_tree 45 MyISAM latin1_swedish_ci
graph_tree_items 1549 MyISAM latin1_swedish_ci
host 1556 MyISAM latin1_swedish_ci
host_graph 1872 MyISAM latin1_swedish_ci
host_snmp_cache 3930178 MyISAM latin1_swedish_ci
host_snmp_query 1612 MyISAM latin1_swedish_ci
host_template 13 MyISAM latin1_swedish_ci
host_template_graph 20 MyISAM latin1_swedish_ci
host_template_snmp_query 25 MyISAM latin1_swedish_ci
plugin_aggregate_color_template_items 44 MyISAM latin1_swedish_ci
plugin_aggregate_color_templates 4 MyISAM latin1_swedish_ci
plugin_aggregate_graph_templates 1 MyISAM latin1_swedish_ci
plugin_aggregate_graph_templates_graph 1 MyISAM latin1_swedish_ci
plugin_aggregate_graph_templates_item 25 MyISAM latin1_swedish_ci
plugin_aggregate_graphs 13 MyISAM latin1_swedish_ci
plugin_aggregate_graphs_graph_item 375 MyISAM latin1_swedish_ci
plugin_aggregate_graphs_items 62 MyISAM latin1_swedish_ci
plugin_autom8_aggregate_rule_items 0 MyISAM latin1_swedish_ci
plugin_autom8_aggregate_rules 0 MyISAM latin1_swedish_ci
plugin_autom8_graph_rule_items 30 MyISAM latin1_swedish_ci
plugin_autom8_graph_rules 7 MyISAM latin1_swedish_ci
plugin_autom8_match_rule_items 20 MyISAM latin1_swedish_ci
plugin_autom8_tree_rule_items 4 MyISAM latin1_swedish_ci
plugin_autom8_tree_rules 2 MyISAM latin1_swedish_ci
plugin_config 7 MyISAM latin1_swedish_ci
plugin_db_changes 35 MyISAM latin1_swedish_ci
plugin_hooks 76 MyISAM latin1_swedish_ci
plugin_notification_lists 1 MyISAM latin1_swedish_ci
plugin_realms 12 MyISAM latin1_swedish_ci
plugin_rrdexport_datasource 1 MyISAM latin1_swedish_ci
plugin_rrdexport_schedules 1 MyISAM latin1_swedish_ci
plugin_thold_contacts 9 MyISAM latin1_swedish_ci
plugin_thold_host_failed 49 MyISAM latin1_swedish_ci
plugin_thold_log 1334 MyISAM latin1_swedish_ci
plugin_thold_template_contact 1 MyISAM latin1_swedish_ci
plugin_thold_threshold_contact 789 MyISAM latin1_swedish_ci
poller 0 MyISAM latin1_swedish_ci
poller_command 0 MyISAM latin1_swedish_ci
poller_item 227720 MyISAM latin1_swedish_ci
poller_output 29424 MyISAM latin1_swedish_ci
poller_output_boost 177854 MEMORY latin1_swedish_ci
poller_output_boost_arch_1489136748 654027 MEMORY latin1_swedish_ci
poller_output_boost_processes 0 MEMORY latin1_swedish_ci
poller_output_rt 1 MyISAM latin1_swedish_ci
poller_reindex 960 MyISAM latin1_swedish_ci
poller_time 8 MyISAM latin1_swedish_ci
rra 6 MyISAM latin1_swedish_ci
rra_cf 12 MyISAM latin1_swedish_ci
settings 194 MyISAM latin1_swedish_ci
settings_graphs 210 MyISAM latin1_swedish_ci
settings_tree 3 MyISAM latin1_swedish_ci
snmp_query 19 MyISAM latin1_swedish_ci
snmp_query_graph 41 MyISAM latin1_swedish_ci
snmp_query_graph_rrd 97 MyISAM latin1_swedish_ci
snmp_query_graph_rrd_sv 82 MyISAM latin1_swedish_ci
snmp_query_graph_sv 49 MyISAM latin1_swedish_ci
thold_data 1578 MyISAM latin1_swedish_ci
thold_template 2 MyISAM latin1_swedish_ci
user_auth 17 MyISAM latin1_swedish_ci
user_auth_perms 12 MyISAM latin1_swedish_ci
user_auth_realm 126 MyISAM latin1_swedish_ci
user_log 3625 MyISAM latin1_swedish_ci
version 1 MyISAM latin1_swedish_ci
weathermap_auth 8 MyISAM latin1_swedish_ci
weathermap_data 238 MyISAM latin1_swedish_ci
weathermap_groups 1 MyISAM latin1_swedish_ci
weathermap_maps 3 MyISAM latin1_swedish_ci
weathermap_settings 0 MyISAM latin1_swedish_ci
The Following Tables were Skipped Due to being INNODB
stat_hub_link_type_list
stat_interface_storage
stat_interfaces_list
stat_interfaces_tmp_sums
stat_interfaces_tmp_vals
stat_pop_list
stat_pop_soglie
stat_sitiull_interf_list
stat_sitiull_list
stat_sitiull_storage
stat_ull_tmp_sums
stat_ull_tmp_vals
stats_login
PHP Module Information
apache2handler

Apache Version Apache/2.2.22 (Ubuntu)
Apache API Version 20051115
Server Administrator webmaster@localhost
Hostname:Port netmonitor.sire.tiscali.sys:80
User/Group www-data(33)/33
Max Requests Per Child: 0 - Keep Alive: on - Max Per Connection: 100
Timeouts Connection: 300 - Keep-Alive: 5
Virtual Server Yes
Server Root /etc/apache2
Loaded Modules core mod_log_config mod_logio prefork http_core mod_so mod_alias mod_auth_basic mod_authn_file mod_authz_default mod_authz_groupfile mod_authz_host mod_authz_user mod_autoindex mod_cgi mod_deflate mod_dir mod_env mod_headers mod_mime mod_negotiation mod_php5 mod_reqtimeout mod_rewrite mod_setenvif mod_status

Directive Local Value Master Value
engine 1 1
last_modified 0 0
xbithack 0 0

Apache Environment

Variable Value
HTTP_HOST netmonitor.sire.tiscali.sys
HTTP_CONNECTION keep-alive
HTTP_UPGRADE_INSECURE_REQUESTS 1
HTTP_USER_AGENT Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36
HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
HTTP_REFERER http://netmonitor.sire.tiscali.sys/cacti/utilities.php
HTTP_ACCEPT_ENCODING gzip, deflate, sdch
HTTP_ACCEPT_LANGUAGE it-IT,it;q=0.8,en-US;q=0.6,en;q=0.4
HTTP_COOKIE gsScrollPos=; Cacti=ohgea3d9ff6hboshlc3q9kpoh6; clickedFolder=tree_12%5Etree_7%5Etree_7_leaf_174183%5Etree_7_leaf_174421%5Etree_7_leaf_175401%5Etree_1%5Etree_1_leaf_174607%5Etree_14%5Etree_14_leaf_174372%5Etree_25%5Etree_26%5Etree_26_leaf_174574%5Etree_26_leaf_174626%5Etree_14_leaf_174380%5Etree_54%5Etree_14_leaf_174373%5Etree_14_leaf_174374%5Etree_14_leaf_174376%5Etree_14_leaf_175437%5Etree_14_leaf_175439%5Etree_8%5Etree_8_leaf_175092%5Etree_8_leaf_175096%5E; highlightedTreeviewLink=tree_8_leaf_175096
PATH /usr/local/bin:/usr/bin:/bin
SERVER_SIGNATURE <address>Apache/2.2.22 (Ubuntu) Server at netmonitor.sire.tiscali.sys Port 80</address>
SERVER_SOFTWARE Apache/2.2.22 (Ubuntu)
SERVER_NAME netmonitor.sire.tiscali.sys
SERVER_ADDR 10.39.90.38
SERVER_PORT 80
REMOTE_ADDR 10.139.244.44
DOCUMENT_ROOT /var/www
SERVER_ADMIN webmaster@localhost
SCRIPT_FILENAME /var/www/cacti/utilities.php
REMOTE_PORT 51486
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING action=view_tech
REQUEST_URI /cacti/utilities.php?action=view_tech
SCRIPT_NAME /cacti/utilities.php

HTTP Headers Information

HTTP Request Headers
HTTP Request GET /cacti/utilities.php?action=view_tech HTTP/1.1
Host netmonitor.sire.tiscali.sys
Connection keep-alive
Upgrade-Insecure-Requests 1
User-Agent Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36
Accept text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
Referer http://netmonitor.sire.tiscali.sys/cacti/utilities.php
Accept-Encoding gzip, deflate, sdch
Accept-Language it-IT,it;q=0.8,en-US;q=0.6,en;q=0.4
Cookie gsScrollPos=; Cacti=ohgea3d9ff6hboshlc3q9kpoh6; clickedFolder=tree_12%5Etree_7%5Etree_7_leaf_174183%5Etree_7_leaf_174421%5Etree_7_leaf_175401%5Etree_1%5Etree_1_leaf_174607%5Etree_14%5Etree_14_leaf_174372%5Etree_25%5Etree_26%5Etree_26_leaf_174574%5Etree_26_leaf_174626%5Etree_14_leaf_174380%5Etree_54%5Etree_14_leaf_174373%5Etree_14_leaf_174374%5Etree_14_leaf_174376%5Etree_14_leaf_175437%5Etree_14_leaf_175439%5Etree_8%5Etree_8_leaf_175092%5Etree_8_leaf_175096%5E; highlightedTreeviewLink=tree_8_leaf_175096
HTTP Response Headers
X-Powered-By PHP/5.3.10-1ubuntu3.24
Expires Thu, 19 Nov 1981 08:52:00 GMT
Last-Modified Fri, 10 Mar 2017 09:10:19 GMT
Cache-Control no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Pragma no-cache
P3P CP="CAO PSA OUR"

bcmath

BCMath support enabled

Directive Local Value Master Value
bcmath.scale 0 0

bz2

BZip2 Support Enabled
Stream Wrapper support compress.bzip2://
Stream Filter support bzip2.decompress, bzip2.compress
BZip2 Version 1.0.6, 6-Sept-2010

calendar

Calendar support enabled

Core

PHP Version 5.3.10-1ubuntu3.24

Directive Local Value Master Value
allow_call_time_pass_reference Off Off
allow_url_fopen On On
allow_url_include Off Off
always_populate_raw_post_data Off Off
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_globals_jit On On
auto_prepend_file no value no value
browscap no value no value
default_charset no value no value
default_mimetype text/html text/html
define_syslog_variables Off Off
disable_classes no value no value
disable_functions pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,
display_errors Off Off
display_startup_errors Off Off
doc_root no value no value
docref_ext no value no value
docref_root no value no value
enable_dl Off Off
error_append_string no value no value
error_log no value no value
error_prepend_string no value no value
error_reporting 22527 22527
exit_on_timeout Off Off
expose_php On On
extension_dir /usr/lib/php5/20090626 /usr/lib/php5/20090626
file_uploads On On
highlight.bg #FFFFFF #FFFFFF
highlight.comment #FF8000 #FF8000
highlight.default #0000BB #0000BB
highlight.html #000000 #000000
highlight.keyword #007700 #007700
highlight.string #DD0000 #DD0000
html_errors Off Off
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path .:/usr/share/php:/usr/share/pear .:/usr/share/php:/usr/share/pear
log_errors On On
log_errors_max_len 1024 1024
magic_quotes_gpc Off Off
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.add_x_header On On
mail.force_extra_parameters no value no value
mail.log no value no value
max_execution_time 300 300
max_file_uploads 20 20
max_input_nesting_level 64 64
max_input_time 300 300
max_input_vars 2000 2000
memory_limit 2560M 2560M
open_basedir no value no value
output_buffering 4096 4096
output_handler no value no value
post_max_size 8M 8M
precision 14 14
realpath_cache_size 16K 16K
realpath_cache_ttl 120 120
register_argc_argv Off Off
register_globals Off Off
register_long_arrays Off Off
report_memleaks On On
report_zend_debug On On
request_order GP GP
safe_mode Off Off
safe_mode_exec_dir no value no value
safe_mode_gid Off Off
safe_mode_include_dir no value no value
sendmail_from no value no value
sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i
serialize_precision 17 17
short_open_tag On On
SMTP localhost localhost
smtp_port 25 25
sql.safe_mode Off Off
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 2M 2M
upload_tmp_dir no value no value
user_dir no value no value
user_ini.cache_ttl 300 300
user_ini.filename .user.ini .user.ini
variables_order GPCS GPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
zend.enable_gc On On

ctype

ctype functions enabled

curl

cURL support enabled
cURL Information 7.22.0
Age 3
Features
AsynchDNS No
Debug No
GSS-Negotiate Yes
IDN Yes
IPv6 Yes
Largefile Yes
NTLM Yes
SPNEGO No
SSL Yes
SSPI No
krb4 No
libz Yes
CharConv No
Protocols dict, file, ftp, ftps, gopher, http, https, imap, imaps, ldap, pop3, pop3s, rtmp, rtsp, smtp, smtps, telnet, tftp
Host x86_64-pc-linux-gnu
SSL Version OpenSSL/1.0.1
ZLib Version 1.2.3.4

date

date/time support enabled
"Olson" Timezone Database Version 0.system
Timezone Database internal
Default timezone Europe/Rome

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 Europe/Rome Europe/Rome

dba

DBA support enabled
Supported handlers cdb cdb_make db4 inifile flatfile

Directive Local Value Master Value
dba.default_handler flatfile flatfile

dom

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

ereg

Regex Library Bundled library enabled

exif

EXIF Support enabled
EXIF Version 1.4 $Id: exif.c 321634 2012-01-01 13:15:04Z felipe $
Supported EXIF Version 0220
Supported filetypes JPEG,TIFF

Directive Local Value Master Value
exif.decode_jis_intel JIS JIS
exif.decode_jis_motorola JIS JIS
exif.decode_unicode_intel UCS-2LE UCS-2LE
exif.decode_unicode_motorola UCS-2BE UCS-2BE
exif.encode_jis no value no value
exif.encode_unicode ISO-8859-15 ISO-8859-15

fileinfo

fileinfo support enabled
version 1.0.5-dev

filter

Input Validation and Filtering enabled
Revision $Revision: 321634 $

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

ftp

FTP support enabled

gd

GD Support enabled
GD Version 2.0
FreeType Support enabled
FreeType Linkage with freetype
FreeType Version 2.4.8
T1Lib Support enabled
GIF Read Support enabled
GIF Create Support enabled
JPEG Support enabled
libJPEG Version unknown
PNG Support enabled
libPNG Version 1.2.46
WBMP Support enabled

Directive Local Value Master Value
gd.jpeg_ignore_warning 0 0

gettext

GetText Support enabled

hash

hash support enabled
Hashing Engines md2 md4 md5 sha1 sha224 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost adler32 crc32 crc32b salsa10 salsa20 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 glibc
iconv library version 2.15

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

json

json support enabled
json version 1.2.1

libxml

libXML support active
libXML Compiled Version 2.7.8
libXML Loaded Version 20708
libXML streams enabled

mbstring

Multibyte Support enabled
Multibyte string engine libmbfl
HTTP input encoding translation disabled

mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.

Multibyte (japanese) regex support enabled
Multibyte regex (oniguruma) backtrack check On
Multibyte regex (oniguruma) version 4.7.1

Directive Local Value Master Value
mbstring.detect_order no value no value
mbstring.encoding_translation Off Off
mbstring.func_overload 0 0
mbstring.http_input pass pass
mbstring.http_output pass pass
mbstring.http_output_conv_mimetypes ^(text/|application/xhtml\+xml) ^(text/|application/xhtml\+xml)
mbstring.internal_encoding no value no value
mbstring.language neutral neutral
mbstring.strict_detection Off Off
mbstring.substitute_character no value no value

mcrypt

mcrypt support enabled
mcrypt_filter support enabled
Version 2.5.8
Api No 20021217
Supported ciphers cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes
Supported modes cbc cfb ctr ecb ncfb nofb ofb stream

Directive Local Value Master Value
mcrypt.algorithms_dir no value no value
mcrypt.modes_dir no value no value

mhash

MHASH support Enabled
MHASH API Version Emulated Support

mysql

MySQL Support enabled
Active Persistent Links 1
Active Links 1
Client API version 5.5.52-MariaDB
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/x86_64-linux-gnu -lmysqlclient_r

Directive Local Value Master Value
mysql.allow_local_infile On On
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 /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

mysqli

MysqlI Support enabled
Client API library version 5.5.52-MariaDB
Active Persistent Links 0
Inactive Persistent Links 0
Active Links 0
Client API header version 5.5.50
MYSQLI_SOCKET /var/run/mysqld/mysqld.sock

Directive Local Value Master Value
mysqli.allow_local_infile On On
mysqli.allow_persistent On On
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.max_persistent Unlimited Unlimited
mysqli.reconnect Off Off

openssl

OpenSSL support enabled
OpenSSL Library Version OpenSSL 1.0.1 14 Mar 2012
OpenSSL Header Version OpenSSL 1.0.1 14 Mar 2012

pcre

PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 8.12 2011-01-15

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

PDO

PDO support enabled
PDO drivers mysql

pdo_mysql

PDO Driver for MySQL enabled
Client API version 5.5.52-MariaDB

Directive Local Value Master Value
pdo_mysql.default_socket /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock

Phar

Phar: PHP Archive support enabled
Phar EXT version 2.0.1
Phar API version 1.1.1
SVN revision $Revision: 321634 $
Phar-based phar archives enabled
Tar-based phar archives enabled
ZIP-based phar archives enabled
gzip compression enabled
bzip2 compression enabled
Native OpenSSL support enabled

Phar based on pear/PHP_Archive, original concept by Davey Shafik.
Phar fully realized by Gregory Beaver and Marcus Boerger.
Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.

Directive Local Value Master Value
phar.cache_list no value no value
phar.readonly On On
phar.require_hash On On

posix

Revision $Revision: 321634 $

Reflection

Reflection enabled
Version $Revision: 321634 $

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 Off Off
session.bug_compat_warn Off Off
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 1000 1000
session.gc_maxlifetime 1440 1440
session.gc_probability 0 0
session.hash_bits_per_character 5 5
session.hash_function 0 0
session.name Cacti PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path /var/lib/php5 /var/lib/php5
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies On On
session.use_trans_sid 0 0

shmop

shmop support enabled

SimpleXML

Simplexml support enabled
Revision $Revision: 321634 $
Schema support enabled

snmp

NET-SNMP Support enabled
NET-SNMP Version 5.4.3

soap

Soap Client enabled
Soap Server enabled

Directive Local Value Master Value
soap.wsdl_cache 1 1
soap.wsdl_cache_dir /tmp /tmp
soap.wsdl_cache_enabled 1 1
soap.wsdl_cache_limit 5 5
soap.wsdl_cache_ttl 86400 86400

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, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException

standard

Dynamic Library Support enabled
Path to sendmail /usr/sbin/sendmail -t -i

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
from no value no value
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=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry
user_agent no value no value

sysvmsg

sysvmsg support enabled
Revision $Revision: 321634 $

tokenizer

Tokenizer Support enabled

wddx

WDDX Support enabled
WDDX Session Serializer enabled

xml

XML Support active
XML Namespace Support active
libxml2 Version 2.7.8

xmlreader

XMLReader enabled

xmlwriter

XMLWriter enabled

zip

Zip enabled
Extension Version $Id: php_zip.c 321634 2012-01-01 13:15:04Z felipe $
Zip version 1.9.1
Libzip version 0.9.0

zlib

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

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
sysvsem
sysvshm


Any hint will be appreciated.

Thanks a lot

Best Regards

Antonello
User avatar
Osiris
Cacti Guru User
Posts: 1424
Joined: Mon Jan 05, 2015 10:10 am

Re: The table 'poller_output_boost' is full

Post by Osiris »

You need to increase the size of the poller output boost table. Carefully re irew the README.
Before history, there was a paradise, now dust.
antokapo
Posts: 48
Joined: Fri Nov 20, 2015 4:06 am

Re: The table 'poller_output_boost' is full

Post by antokapo »

Hi

Yes, it was clear for me, the table poller_output_boost is a memory table and i have to increase its size, but even if i set tmp_table_size and max_heap_size to 4 GB (!!) table became full at night.

Next step is , as suggested in the boost plugin page, to set the output field to varchar (50) instead of the default varchar(512) .

I'll let you know .

Antonello
User avatar
Osiris
Cacti Guru User
Posts: 1424
Joined: Mon Jan 05, 2015 10:10 am

Re: The table 'poller_output_boost' is full

Post by Osiris »

Whatever makes sense. You can check the max length from the Utilities page. Then trim as applicable. The new heap table size requires a MySQL restart through, which is catestrophic to any data in that table, so generally convert it to InnoDB before restarting, then convert back to memory afterwards.
Before history, there was a paradise, now dust.
antokapo
Posts: 48
Joined: Fri Nov 20, 2015 4:06 am

Re: The table 'poller_output_boost' is full

Post by antokapo »

Hi
I resolved altering the field of the poller_output_boost :

alter table poller_output, modify column output varchar(50) not null default "", engine=memory;

alter table poller_output_boost, modify column output varchar(50) not null default "";

as advised in the plugin home page.

A
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests