Issue with Queues in RRD Mailreport package

rdlugosz

I searched but did not find any threads related to the mailreport package. This is a pretty nice tool that will send you daily, weekly, monthly, etc emails containing that period's RRD Graphs.

Anyway, I'm having a small issue related to the content of the email. I have the following graphs set up in a daily report:
WAN :: Traffic
WAN :: Quality
WAN :: Queues
WAN :: Queuedrops
System :: States
System :: Processor

It works great the first time after a reboot, but any subsequent daily emails will show up missing the graphs for Queues and Queuedrops.

Seems strange, but I'm sure there's a perfectly reasonable explanation.

jimp

I haven't seen that myself but then I don't use the queue graph there. (Disclaimer: I wrote that package)

So the graph is completely missing and doesn't show up at all? Or it's a broken image? Or … ?

rdlugosz

@jimp:

So the graph is completely missing and doesn't show up at all? Or it's a broken image? Or … ?

Completely missing. After a reboot the email will contain 6 attached images. Then, any subsequent email reports will only contain 4 attachments. I just rebooted today, so if for some reason I don't see 6 images tomorrow morning I'll let you know.

Here's a screen grab of the config page
https://skitch.com/rdlugosz/gdafm/pfsense.localdomain-status-edit-mail-reports

Thanks & let me know if there's anything else I can provide that you think would be useful…

edit: should mention that I'm running version 1.1 of your package and pfSense version: 2.0-RELEASE (i386) built on Tue Sep 13 17:00:00 EDT 2011

jimp

Can you post the "<mailreports>" section of your config.xml so I can see what it's looking for?</mailreports>

jimp

Also, does it show up when you click "send now" on the report? Is it only missing during the daily automatic e-mail?

rdlugosz

Tried hitting "Send Now" twice just now and both emails contained all six graphs. Interesting.

Here's another interesting twist. I've gotten an handful of reports in the last couple of days which actually contain the Queues graph (so 5 attachments out of 6 expected). The most recent Weekly report contained just four.

It would seem that there's no exact consistency as I had previously suggested.

mailreports section of config:

	 <mailreports><schedule><frequency>daily</frequency>
			<timeofday>5</timeofday>
			<submit>Save</submit>
			<id>0</id>
			 <row><graph>wan-traffic.rrd</graph>

				<timespan>day</timespan>
				<period>absolute</period>
				<submit>Save</submit>
				<reportid>0</reportid></row> 
			 <row><graph>WAN-quality.rrd</graph>

				<timespan>day</timespan>
				<period>absolute</period>
				<submit>Save</submit>
				<reportid>0</reportid>
				<id>1</id></row> 
			 <row><graph>wan-queues.rrd</graph>

				<timespan>day</timespan>
				<period>absolute</period>
				<submit>Save</submit>
				<reportid>0</reportid>
				<id>2</id></row> 
			 <row><graph>wan-queuedrops.rrd</graph>

				<timespan>day</timespan>
				<period>absolute</period>
				<submit>Save</submit>
				<reportid>0</reportid>
				<id>3</id></row> 
			 <row><graph>system-states.rrd</graph>

				<timespan>day</timespan>
				<period>absolute</period>
				<submit>Save</submit>
				<reportid>0</reportid>
				<id>4</id></row> 
			 <row><graph>system-processor.rrd</graph>

				<timespan>day</timespan>
				<period>absolute</period>
				<submit>Save</submit>
				<reportid>0</reportid>
				<id>5</id></row> 
			<schedule_friendly>Daily at 05:00</schedule_friendly></schedule> 
		 <schedule><frequency>weekly</frequency>
			<dayofweek>1</dayofweek>
			<timeofday>5</timeofday>
			<submit>Save</submit>
			<id>1</id>
			 <row><graph>wan-traffic.rrd</graph>

				<timespan>week</timespan>
				<period>absolute</period>
				<submit>Save</submit>
				<reportid>1</reportid></row> 
			 <row><graph>WAN-quality.rrd</graph>

				<timespan>week</timespan>
				<period>absolute</period>
				<submit>Save</submit>
				<reportid>1</reportid></row> 
			 <row><graph>wan-queues.rrd</graph>

				<timespan>week</timespan>
				<period>absolute</period>
				<submit>Save</submit>
				<reportid>1</reportid></row> 
			 <row><graph>wan-queuedrops.rrd</graph>

				<timespan>week</timespan>
				<period>absolute</period>
				<submit>Save</submit>
				<reportid>1</reportid></row> 
			 <row><graph>system-states.rrd</graph>

				<timespan>week</timespan>
				<period>absolute</period>
				<submit>Save</submit>
				<reportid>1</reportid></row> 
			 <row><graph>system-processor.rrd</graph>

				<timespan>week</timespan>
				<period>absolute</period>
				<submit>Save</submit>
				<reportid>1</reportid></row> 
			<schedule_friendly>Weekly, on monday at 05:00</schedule_friendly></schedule> 
		 <schedule><frequency>monthly</frequency>
			<dayofmonth>1</dayofmonth>
			<timeofday>0</timeofday>
			<submit>Save</submit>
			<id>2</id>
			 <row><graph>wan-traffic.rrd</graph>

				<timespan>month</timespan>
				<period>absolute</period>
				<submit>Save</submit>
				<reportid>2</reportid></row> 
			 <row><graph>WAN-quality.rrd</graph>

				<timespan>month</timespan>
				<period>absolute</period>
				<submit>Save</submit>
				<reportid>2</reportid></row> 
			 <row><graph>wan-queues.rrd</graph>

				<timespan>month</timespan>
				<period>absolute</period>
				<submit>Save</submit>
				<reportid>2</reportid></row> 
			 <row><graph>wan-queuedrops.rrd</graph>

				<timespan>month</timespan>
				<period>absolute</period>
				<submit>Save</submit>
				<reportid>2</reportid></row> 
			 <row><graph>system-states.rrd</graph>

				<timespan>month</timespan>
				<period>absolute</period>
				<submit>Save</submit>
				<reportid>2</reportid></row> 
			 <row><graph>system-processor.rrd</graph>

				<timespan>month</timespan>
				<period>absolute</period>
				<submit>Save</submit>
				<reportid>2</reportid></row> 
			<schedule_friendly>Monthly, on day 1 at 00:00</schedule_friendly></schedule></mailreports>

Thanks for continuing to look into this. I hope you are considering it to be a low priority issue.

jimp

Yeah I get that it's low :-)

I've had mine running a few days now and they've come through OK every time. The code path is the same regardless of the report being run, so unless the file is actually missing at the time the report is run, I don't see what could be failing to attach just the queue graphs.

rdlugosz

So… for the past two days the daily reports have included all six graphs & there's been no reboots, etc. Maybe we just chalk this up to strange issues that occasionally happen?

jimp

Not sure, but it's possible it's a timing issue that only pops up at certain times, where the rrd file is being updated by the system when the report is being run and it can't find the file at the moment it's trying to attach it.

Not sure what else it might be…