RRD not graphing

clarknova

Sometimes all my graphs show up fine, other times some graphs are blurred out. Seems like it was always shortly after midnight locally when this happened.

johnpoz

The seems to have gone away this morning? Updating now to the current snap.. Lets see if comes back?

jimp

clarknova may be on to something, it may only show up during a specific time frame if there is an issue with date calculation.

jeebsion

hrmm .. it happened again with latest snap:

php: /status_rrd_graph_img.php: Failed to create graph with error code 1, the error is: ERROR: start (1293580800) should be less than end (1293553000)/usr/bin/nice -n20 /usr/local/bin/rrdtool graph /tmp/wan-traffic.rrd-8hour.png –start 1293580800 --end 1293553000 --vertical-label "bits/sec" --color SHADEA#eeeeee --color SHADEB#eeeeee --title "hostname - WAN :: Traffic - 8 hours - 1 minute average" --height 200 --width 620 DEF:wan-in_bytes_pass=/var/db/rrd/wan-traffic.rrd:inpass:AVERAGE DEF:wan-out_bytes_pass=/var/db/rrd/wan-traffic.rrd:outpass:AVERAGE DEF:wan-in_bytes_block=/var/db/rrd/wan-traffic.rrd:inblock:AVERAGE DEF:wan-out_bytes_block=/var/db/rrd/wan-traffic.rrd:outblock:AVERAGE CDEF:"wan-in_bits_pass=wan-in_bytes_pass,8," CDEF:"wan-out_bits_pass=wan-out_bytes_pass,8," CDEF:"wan-in_bits_block=wan-in_bytes_block,8," CDEF:"wan-out_bits_block=wan-out_bytes_block,8," CDEF:"wan-in_bytes=wan-in_bytes_pass,wan-in_bytes_block,+" CDEF:"wan-out_bytes=wan-out_bytes_pass,wan-out_bytes_blo

mikesamo

got same issue under 2.0-BETA5 (i386) built on Sun Dec 26 01:43:40 EST 2010

Dec 28 03:25:02 php: /status_rrd_graph_img.php: Failed to create graph with error code 1, the error is: ERROR: start (1293541200) should be less than end (1293524702)/usr/bin/nice -n20 /usr/local/bin/rrdtool graph /tmp/system-processor.rrd-8hour.png –start 1293541200 --end 1293524702 --vertical-label "utilization, number" --color SHADEA#eeeeee --color SHADEB#eeeeee --title "hostname - System :: Processor - 5 hours - 1 minute average" --height 200 --width 620 DEF:"user=/var/db/rrd/system-processor.rrd:user:AVERAGE" DEF:"nice=/var/db/rrd/system-processor.rrd:nice:AVERAGE" DEF:"system=/var/db/rrd/system-processor.rrd:system:AVERAGE" DEF:"interrupt=/var/db/rrd/system-processor.rrd:interrupt:AVERAGE" DEF:"processes=/var/db/rrd/system-processor.rrd:processes:AVERAGE" AREA:"user#990000:user" AREA:"nice#a83c3c:nice:STACK" AREA:"system#b36666:system:STACK" AREA:"interrupt#bd9090:interrupt:STACK" LINE2:"processes#cccccc:processes" COMMENT:"\n" COMMENT:" minimum average maximum current

Dec 28 03:25:02 php: /status_rrd_graph_img.php: start 1293541200 is smaller than end 1293519019

but in some hours in the day the graphic display ok.
like now there is no error.

rrdgraph_system_ok.png_thumb

AhnHEL

When mine is blurred out, I just switch to Previous Period from Current Period and the graphs will display.

jimp

I checked in what might be a fix for this:

https://rcs.pfsense.org/projects/pfsense/repos/mainline/commits/c23b4f0d80d389007cf058d0f17a65001a644811

johnpoz

sure looks like its time related, it was working fine this morning.. But now its 12:30am here and this is what I get

Tried changing that – do have to restart rrd backend or something? Still getting error

Dec 29 00:42:27
php: /status_rrd_graph_img.php: Failed to create graph with error code 1, the error is: ERROR: start (1293631200) should be less than end (1293604947)/usr/bin/nice -n20 /usr/local/bin/rrdtool graph /tmp/WAN-quality.rrd-8hour.png \ --start 1293631200 --end 1293604947 \ --title "hostname - WAN :: Quality - 7 hours - 1 minute average" \ --color SHADEA#eeeeee --color SHADEB#eeeeee \ --vertical-label "ms / %" \ --height 200 --width 620 \ --lower-limit 0 \ DEF:delayraw=/var/db/rrd/WAN-quality.rrd:delay:AVERAGE \ DEF:loss=/var/db/rrd/WAN-quality.rrd:loss:AVERAGE \ "CDEF:delay=delayraw,1000," \ "CDEF:roundavg=delay,PREV(delay),+,2,/" \ "CDEF:loss10=loss,-1," \ "CDEF:r0=delay,20,MIN" \ "CDEF:r1=delay,60,MIN" \ "CDEF:r2=delay,180,MIN" \ "CDEF:r3=delay,420,MIN" \ COMMENT:" Delay Packet loss\n" \ AREA:delay#990000:"> 420 ms" \ GPRINT:delay:MIN:" Min: %7.2lf ms" \ GPRINT:loss:MIN:" Min: %3.1lf %%\n" \ AREA:r3#a83c3c:"180-420 ms" \ GPR

On current snap
2.0-BETA5 (i386)
built on Tue Dec 28 05:36:55 EST 2010

1230amproblem.jpg_thumb

lustenbe

Same behavior here, but I am not so sure that it is time related. I am using latest snapshot 2.0-BETA5 (i386)
built on Wed Dec 29 00:07:16 EST 2010

Dec 29 10:40:42
php: /status_rrd_graph_img.php: Failed to create graph with error code 1, the error is: ERROR: No DS called 'inpass' in '/var/db/rrd/wan-traffic.rrd'/usr/bin/nice -n20 /usr/local/bin/rrdtool graph /tmp/wan-traffic.rrd-quarter.png –start 1285797600 --end 1293615640 --vertical-label "bits/sec" --color SHADEA#eeeeee --color SHADEB#eeeeee --title "hostname - WAN :: Traffic - 3 months - 1 day average" --height 200 --width 620 DEF:wan-in_bytes_pass=/var/db/rrd/wan-traffic.rrd:inpass:AVERAGE DEF:wan-out_bytes_pass=/var/db/rrd/wan-traffic.rrd:outpass:AVERAGE DEF:wan-in_bytes_block=/var/db/rrd/wan-traffic.rrd:inblock:AVERAGE DEF:wan-out_bytes_block=/var/db/rrd/wan-traffic.rrd:outblock:AVERAGE CDEF:"wan-in_bits_pass=wan-in_bytes_pass,8," CDEF:"wan-out_bits_pass=wan-out_bytes_pass,8," CDEF:"wan-in_bits_block=wan-in_bytes_block,8," CDEF:"wan-out_bits_block=wan-out_bytes_block,8," CDEF:"wan-in_bytes=wan-in_bytes_pass,wan-in_bytes_block,+" CDEF:"wan-out_bytes=wan-out_bytes_pass,wan-out_bytes_bloc

johnpoz

Has to be time related.. Since they are working fine this morning.

workingrrd.jpg_thumb

jimp

Has anyone been able to make out a pattern, working time vs non-working time? This happened before and it was a noon/midnight switch.

johnpoz

Well I can tell you it was not working from like 12:30 til 3 something in the morning.. But now at 9:30 its working..

I would assume tz are also involved, Im set to america/chicago

mromero

Latest snapshot of today i386

Dec 31 04:00:41 php: /status_rrd_graph_img.php: Failed to create graph with error code 1, the error is: ERROR: start (1293782400) should be less than end (1293768041)/usr/bin/nice -n20 /usr/local/bin/rrdtool graph /tmp/system-processor.rrd-8hour.png –start 1293782400 --end 1293768041 --vertical-label "utilization, number" --color SHADEA#eeeeee --color SHADEB#eeeeee --title "hostname - System :: Processor - 4 hours - 1 minute average" --height 200 --width 620 DEF:"user=/var/db/rrd/system-processor.rrd:user:AVERAGE" DEF:"nice=/var/db/rrd/system-processor.rrd:nice:AVERAGE" DEF:"system=/var/db/rrd/system-processor.rrd:system:AVERAGE" DEF:"interrupt=/var/db/rrd/system-processor.rrd:interrupt:AVERAGE" DEF:"processes=/var/db/rrd/system-processor.rrd:processes:AVERAGE" AREA:"user#990000:user" AREA:"nice#a83c3c:nice:STACK" AREA:"system#b36666:system:STACK" AREA:"interrupt#bd9090:interrupt:STACK" LINE2:"processes#cccccc:processes" COMMENT:"\n" COMMENT:" minimum average maximum current

clarknova

I've been keeping an eye on my graphs since 23h30 and the first one died promptly at midnight with this message in the log:

Jan 2 00:01:00 php: /status_rrd_graph_img.php: Failed to create graph with error code 1, the error is: ERROR: start (1293980400) should be less than end (1293951660)/usr/bin/nice -n20 /usr/local/bin/rrdtool graph /tmp/wan-traffic.rrd-8hour.png –start 1293980400 --end 1293951660 --vertical-label "bits/sec" --color SHADEA#eeeeee --color SHADEB#eeeeee --title "hostname - WAN :: Traffic - 8 hours - 1 minute average" --height 200 --width 620 DEF:wan-in_bytes_pass=/var/db/rrd/wan-traffic.rrd:inpass:AVERAGE DEF:wan-out_bytes_pass=/var/db/rrd/wan-traffic.rrd:outpass:AVERAGE DEF:wan-in_bytes_block=/var/db/rrd/wan-traffic.rrd:inblock:AVERAGE DEF:wan-out_bytes_block=/var/db/rrd/wan-traffic.rrd:outblock:AVERAGE CDEF:"wan-in_bits_pass=wan-in_bytes_pass,8," CDEF:"wan-out_bits_pass=wan-out_bytes_pass,8," CDEF:"wan-in_bits_block=wan-in_bytes_block,8," CDEF:"wan-out_bits_block=wan-out_bytes_block,8," CDEF:"wan-in_bytes=wan-in_bytes_pass,wan-in_bytes_block,+" CDEF:"wan-out_bytes=wan-out_bytes_pass,wan-out_bytes_blo

Liath.WW

Just in case it helps, I posted in another thread similar to this one: http://forum.pfsense.org/index.php/topic,27910.msg163645.html#msg163645

I noticed there were some messages on my logs that seemed related, but I wasn't sure, so I posted them there.

Could a mod merge these threads? seems to be useful information in all of them, and it may help to have all of them in one thread and prevent crossposting. Perhaps something is posted in two different threads that may make the issue more obvious if seen all at once as well, so that this bug can be resolved.

jimp

@clarknova:

I've been keeping an eye on my graphs since 23h30 and the first one died promptly at midnight with this message in the log:

Are you on the most current snap? One that includes these commits?

https://rcs.pfsense.org/projects/pfsense/repos/mainline/commits/29640ceef3b1ee281dae21ab41cd2ff5703f43c8
https://rcs.pfsense.org/projects/pfsense/repos/mainline/commits/97acf64675592e2e623eb22b3d1adcc63c109b2a

clarknova

Oops, no. Sorry. I haven't been on site in over a week and didn't want to upgrade remotely because of the pppoe issues. I'll be there in 36 hours or so and update then.

soconfused

RRD graphs are now working past midnight with pfSense-Full-Update-2.0-BETA5-20110101-1309. Tried all display options with success.

JWU42

EDIT - PROBLEM SOLVED

Was braindead and forgot that it wasn't a clean install but an upgrade from the last CD I burned (May 2010 timeframe). Just did a clean install from this mornings liveCD and all is well.

===================
Seems a different issue than those above but under the same topic. Clean install this morning (2.0-BETA5 (i386) built on Mon Jan 3 03:26:07 EST 2011).

Error message in log is below…

php: /status_rrd_graph_img.php: Failed to create graph with error code 1, the error is: ERROR: '/var/db/rrd/wan-traffic.rrd' is not an RRD file/usr/bin/nice -n20 /usr/local/bin/rrdtool graph /tmp/wan-traffic.rrd-month.png –start 1291307056 --end 1294071856 --vertical-label "bits/sec" --color SHADEA#eeeeee --color SHADEB#eeeeee --title "hostname - WAN :: Traffic - 1 month - 1 hour average" --height 200 --width 620 DEF:wan-in_bytes_pass=/var/db/rrd/wan-traffic.rrd:inpass:AVERAGE DEF:wan-out_bytes_pass=/var/db/rrd/wan-traffic.rrd:outpass:AVERAGE DEF:wan-in_bytes_block=/var/db/rrd/wan-traffic.rrd:inblock:AVERAGE DEF:wan-out_bytes_block=/var/db/rrd/wan-traffic.rrd:outblock:AVERAGE CDEF:"wan-in_bits_pass=wan-in_bytes_pass,8," CDEF:"wan-out_bits_pass=wan-out_bytes_pass,8," CDEF:"wan-in_bits_block=wan-in_bytes_block,8," CDEF:"wan-out_bits_block=wan-out_bytes_block,8," CDEF:"wan-in_bytes=wan-in_bytes_pass,wan-in_bytes_block,+" CDEF:"wan-out_bytes=wan-out_bytes_pass,wan-out_bytes_block,+" CDE

Same issue for System, Packets and Quality…

The systems has been up for 58 minutes - if that matters...

AhnHEL

I'm on AMD64 and I see these errors on bootup. Seems to only apply to the Traffic Shaper Graphs but the graphs are displaying correctly, just an annoying bootup error.

Jan 1 01:31:50 php: : The command '/usr/bin/nice -n20 /usr/local/bin/rrdtool update /var/db/rrd/lan-queuedrops.rrd -t :lan N:U' returned exit code '1', the output was 'ERROR: unknown DS name '''
Jan 1 01:31:50 php: : The command '/usr/bin/nice -n20 /usr/local/bin/rrdtool update /var/db/rrd/lan-queues.rrd -t :lan N:U' returned exit code '1', the output was 'ERROR: unknown DS name '''
Jan 1 01:31:50 php: : The command '/usr/bin/nice -n20 /usr/local/bin/rrdtool update /var/db/rrd/wan-queuedrops.rrd -t :wan:qACK:qDefault:qGames N:U:U:U:U' returned exit code '1', the output was 'ERROR: unknown DS name '''
Jan 1 01:31:50 php: : The command '/usr/bin/nice -n20 /usr/local/bin/rrdtool update /var/db/rrd/wan-queues.rrd -t :wan:qACK:qDefault:qGames N:U:U:U:U' returned exit code '1', the output was 'ERROR: unknown DS name '''