RRD not graphing

Accounts

Same here with todays (28th Dec, 2010) snapshot.

php: /status_rrd_graph_img.php: Failed to create graph with error code 1, the error is: ERROR: start (1293523200) should be less than end (1293498069)/usr/bin/nice -n20 /usr/local/bin/rrdtool graph /tmp/wan-traffic.rrd-8hour.png –start 1293523200 --end 1293498069 --vertical-label "bits/sec" --color SHADEA#eeeeee --color SHADEB#eeeeee --title "hostname - WAN :: Traffic - 7 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

mromero

Jimp, the error I was getting was the same as quoted by another user:

"Some of the graphs show up. Others are blurred out with a big red message to see the log."

On first upgrade to today's 27 Dec build the graphs were running good, now about fours later I check and they are back with the same error as at above with the error on the first graph at the top.

This I simply do not understand. Wish I could be of more help >:(

@jimp:

@mromero:

On the other box where I did a fresh install of the 26 December build, but which curiously has a date file of the 25 the December the RRD graphs are broken. i38

The same error message or something different?

mromero

Here is the error from the system log:

php: /status_rrd_graph_img.php: Failed to create graph with error code 1, the error is: ERROR: start (1293523200) should be less than end (1293504141)/usr/bin/nice -n20 /usr/local/bin/rrdtool graph /tmp/system-processor.rrd-8hour.png –start 1293523200 --end 1293504141 --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

johnpoz

Just updated to latest build
Version 2.0-BETA5 (i386)
built on Mon Dec 27 19:14:40 EST 2010

this is error
php: /status_rrd_graph_img.php: Failed to create graph with error code 1, the error is: ERROR: start (1293544800) should be less than end (1293517954)/usr/bin/nice -n20 /usr/local/bin/rrdtool graph /tmp/wan-traffic.rrd-8hour.png –start 1293544800 --end 1293517954 --vertical-label "bits/sec" --color SHADEA#eeeeee --color SHADEB#eeeeee --title "hostname - WAN :: Traffic - 7 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

jeebsion

@johnpoz:

Just updated to latest build
Version 2.0-BETA5 (i386)
built on Mon Dec 27 19:14:40 EST 2010

this is error
php: /status_rrd_graph_img.php: Failed to create graph with error code 1, the error is: ERROR: start (1293544800) should be less than end (1293517954)/usr/bin/nice -n20 /usr/local/bin/rrdtool graph /tmp/wan-traffic.rrd-8hour.png –start 1293544800 --end 1293517954 --vertical-label "bits/sec" --color SHADEA#eeeeee --color SHADEB#eeeeee --title "hostname - WAN :: Traffic - 7 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

I've updated to latest snapshot and all went well :-)

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.