/boxes?date= returns nothing #107

Activity

1. noerw

   added

   bug

   on Aug 15, 2017
2. noerw commented on Aug 24, 2017

   

   noerw

   on Aug 24, 2017

   MemberAuthor

   More actions

   sometimes an empty response is returned, sometimes

   {"code":"InternalServerError","message":"connection 16 to 172.31.46.193:27017 timed out"}
   
3. ubergesundheit commented on Aug 24, 2017

   

   ubergesundheit

   on Aug 24, 2017

   Member

   More actions

   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.