/boxes?date= returns nothing

[noerw]

https://api.opensensemap.org/boxes?date=2017-08-06T00:00:00Z,2017-08-10T12:49:51Z

[noerw]

sometimes an empty response is returned, sometimes

{"code":"InternalServerError","message":"connection 16 to 172.31.46.193:27017 timed out"}

[ubergesundheit]

Seems the aggregation executed when requesting the route with date parameters does not receive data in time thus timing out. (

openSenseMap-API/lib/controllers/boxesController.js

Lines 530 to 548 in 42a55ec

	execStreamBoxesToClientPromise = Measurement.aggregate([
	{
	$match: {
	createdAt: {
	'$gt': fromDate.toDate(),
	'$lt': toDate.toDate()
	}
	}
	},
	{
	$group: {
	_id: '$sensor_id',
	value: { $first: '$value' },
	createdAt: { $first: '$createdAt' },
	sensor_id: { $first: '$sensor_id' }
	},
	},
	{ $project: { value: 1, createdAt: 1, sensor_id: 1, _id: 0 } }
	])

)

I have no particular plans, but in the long run I have to think about speeding up the aggregation or using some trick to cache the information if there is data for a particular timeframe or not.