Select query somtimes returns "BadRequest"



I am trying to select some data from InfluxDB using the InfluxData.Net library and somtimes it fails.
The query selects some value before specific timestamp like so:
SELECT “Int” FROM “db” WHERE “TagName”=‘MachineStatusMessage.1’ AND “time” < ‘2017-12-15T05:08:51Z’ ORDER BY time DESC LIMIT 1

The data is there but the result is:

Exception Type: InfluxData.Net.Common.Infrastructure.InfluxDataApiException
Error message: InfluxData API responded with status code=BadRequest, response=query interrupted
Stack trace:
at InfluxData.Net.InfluxDb.Helpers.ResponseExtensions.Validate(QueryResponse queryResponse, Boolean throwOnWarning)
at InfluxData.Net.InfluxDb.ClientModules.ClientModuleBase.ResolveSingleGetSeriesResultChunked(IInfluxDataApiResponse response)
at InfluxData.Net.InfluxDb.ClientModules.ClientModuleBase.d__12.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at InfluxData.Net.InfluxDb.ClientModules.BasicClientModule.d__1.MoveNext()

Any ideas what is happening here?


Still experiencing this issue. Can anyone point me in the right direction here? @jackzampolin , @daniel ?