InfluxDB.Net icon indicating copy to clipboard operation
InfluxDB.Net copied to clipboard

Need Help: Unable to read data from the transport connection: The connection was closed.

Open ReactRS opened this issue 7 years ago • 0 comments

Hi,

We are using the library InfluxDB.Net Release 8.0.1 to read data from Influx DB hosted in the cloud. We have 1-minute interval data stored in the cloud database. We have a requirement to generate .csv report based on user request. The REST call works seamlessly for MultiQueryAsync (190 Queries, each query reading different Data Point) for three weeks worth of data. i.e 190 Columns * 1446 Rows per day * 21 = 5,769,540 data points.

However when we try to read a month worth of Data: the Influx DB call fails with the below exception InnerException = {"Unable to read data from the transport connection: The connection was closed."}

at System.Net.ConnectStream.EndRead(IAsyncResult asyncResult) at System.IO.Stream.<>c.<BeginEndReadAsync>b__43_1(Stream stream, IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory1.FromAsyncTrimPromise1.Complete(TInstance thisRef, Func`3 endMethod, IAsyncResult asyncResult, Boolean requiresSynchronization) --- 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 System.Net.Http.HttpClientHandler.WebExceptionWrapperStream.<ReadAsync>d__4.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 System.Net.Http.StreamToStreamCopy.<CopyAsyncAnyStreamToAnyStreamCore>d__3.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 System.Net.Http.HttpContent.<LoadIntoBufferAsyncCore>d__49.MoveNext()

If anyone has experience with resolving this issue please share your inputs. The Client Request is handled by WebAPI2.0, below is the code snippet. image

ReactRS avatar Oct 12 '18 22:10 ReactRS