Hi,
As old GH bug #6223 came back again.
Seem that rrdcached and mysql agent drawing doesn’t cope togever.
I have :
$config[‘rrdcached’] = “unix:/var/run/rrdcached.sock”;
$config[‘rrdtool_version’] = “1.6.0”;
====================================
Component | Version
--------- | -------
LibreNMS | 1.50-33-g36e709e
DB Schema | 2019_02_10_220000_add_dates_to_fdb (132)
PHP | 7.3.3-1+0~20190307202245.32+stretch~1.gbp32ebb2
MySQL | 10.1.37-MariaDB-0+deb9u1
RRDTool | 1.6.0
SNMP | NET-SNMP 5.7.3
====================================
But when trying to draw I have the following error :
RRDTool Command
rrdtool graph /tmp/9MySj0bVB3ve28TO --alt-autoscale-max --rigid -E --start 1554799200 --end 1554885600 --width 1296 --height 300 -c BACK#EEEEEE00 -c SHADEA#EEEEEE00 -c SHADEB#EEEEEE00 -c FONT#000000 -c CANVAS#FFFFFF00 -c GRID#a5a5a5 -c MGRID#FF9999 -c FRAME#5e5e5e -c ARROW#5e5e5e -R normal --font LEGEND:8:DejaVuSansMono --font AXIS:7:DejaVuSansMono --font-render-mode normal --alt-autoscale-max --rigid -E --start 1554799200 --end 1554885600 --width 1296 --height 300 -c BACK#EEEEEE00 -c SHADEA#EEEEEE00 -c SHADEB#EEEEEE00 -c FONT#000000 -c CANVAS#FFFFFF00 -c GRID#a5a5a5 -c MGRID#FF9999 -c FRAME#5e5e5e -c ARROW#5e5e5e -R normal --font LEGEND:8:DejaVuSansMono --font AXIS:7:DejaVuSansMono --font-render-mode normal COMMENT:'Connections Now Min Max Avg\l' DEF:ds0=galera01/app-mysql-143.rrd:MaCs:AVERAGE DEF:ds0min=galera01/app-mysql-143.rrd:MaCs:MIN DEF:ds0max=galera01/app-mysql-143.rrd:MaCs:MAX DEF:ds1=galera01/app-mysql-143.rrd:MUCs:AVERAGE DEF:ds1min=galera01/app-mysql-143.rrd:MUCs:MIN DEF:ds1max=galera01/app-mysql-143.rrd:MUCs:MAX DEF:ds2=galera01/app-mysql-143.rrd:ACs:AVERAGE DEF:ds2min=galera01/app-mysql-143.rrd:ACs:MIN DEF:ds2max=galera01/app-mysql-143.rrd:ACs:MAX DEF:ds3=galera01/app-mysql-143.rrd:AdCs:AVERAGE DEF:ds3min=galera01/app-mysql-143.rrd:AdCs:MIN DEF:ds3max=galera01/app-mysql-143.rrd:AdCs:MAX DEF:ds4=galera01/app-mysql-143.rrd:TCd:AVERAGE DEF:ds4min=galera01/app-mysql-143.rrd:TCd:MIN DEF:ds4max=galera01/app-mysql-143.rrd:TCd:MAX DEF:ds5=galera01/app-mysql-143.rrd:Cs:AVERAGE DEF:ds5min=galera01/app-mysql-143.rrd:Cs:MIN DEF:ds5max=galera01/app-mysql-143.rrd:Cs:MAX LINE1.25:ds0#CC0000:'Max Connection ' GPRINT:ds0:LAST:%5.2lf%s GPRINT:ds0min:MIN:%5.2lf%s GPRINT:ds0max:MAX:%5.2lf%s GPRINT:ds0:AVERAGE:'%5.2lf%s\n' LINE1.25:ds1#008C00:'Max Used Conne ' GPRINT:ds1:LAST:%5.2lf%s GPRINT:ds1min:MIN:%5.2lf%s GPRINT:ds1max:MAX:%5.2lf%s GPRINT:ds1:AVERAGE:'%5.2lf%s\n' LINE1.25:ds2#4096EE:'Aborted Client ' GPRINT:ds2:LAST:%5.2lf%s GPRINT:ds2min:MIN:%5.2lf%s GPRINT:ds2max:MAX:%5.2lf%s GPRINT:ds2:AVERAGE:'%5.2lf%s\n' LINE1.25:ds3#73880A:'Aborted Connec ' GPRINT:ds3:LAST:%5.2lf%s GPRINT:ds3min:MIN:%5.2lf%s GPRINT:ds3max:MAX:%5.2lf%s GPRINT:ds3:AVERAGE:'%5.2lf%s\n' LINE1.25:ds4#D01F3C:'Threads Connec ' GPRINT:ds4:LAST:%5.2lf%s GPRINT:ds4min:MIN:%5.2lf%s GPRINT:ds4max:MAX:%5.2lf%s GPRINT:ds4:AVERAGE:'%5.2lf%s\n' LINE1.25:ds5#36393D:'New Connection ' GPRINT:ds5:LAST:%5.2lf%s GPRINT:ds5min:MIN:%5.2lf%s GPRINT:ds5max:MAX:%5.2lf%s GPRINT:ds5:AVERAGE:'%5.2lf%s\n' HRULE:0#555555 --daemon unix:/var/run/rrdcached.sock
RRDTool Output
ERROR: rrdc_fetch: Got 292 lines, expected 295
Is there any way to fix that ?
Regards