microsoft / Kusto-Query-Language

Kusto Query Language is a simple and productive language for querying Big Data.
Apache License 2.0
511 stars 97 forks source link

Problem with `series_decompose` #15

Closed krzysztofkroczak closed 4 years ago

krzysztofkroczak commented 4 years ago

I've got exception while executing this:

customEvents
| where name == "algorithm.comparison.substitution" 
| project samples = parse_json(tostring(customDimensions["payload.samples"]))
| extend b = samples.bulk
| extend r = samples.rowByRow
| extend bulk_stats = series_stats_dynamic(b)
| extend rowByRow_stats = series_stats_dynamic(r)
| extend series_decompose(b, 0, 'linefit')

where customDimensions["payload.samples"]) looks like that {"bulk":[48.8009,53.8592,...],"rowByRow":[66.3999,64.3826,...]}

The query was aborted by the server.
Details: Partial query failure: 0x80131620 (message: 'An exception has been thrown when reading the stream.: ', details: 'Source: System.ServiceModel
System.IO.IOException: An exception has been thrown when reading the stream. ---> System.ServiceModel.CommunicationException: The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was '01:00:00'. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host
at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.ServiceModel.Channels.SocketConnection.ReadCore(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout, Boolean closing)
--- End of inner exception stack trace ---
at System.ServiceModel.Channels.SocketConnection.ReadCore(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout, Boolean closing)
at System.ServiceModel.Channels.SocketConnection.Read(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout)
at System.ServiceModel.Channels.DelegatingConnection.Read(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout)
at System.ServiceModel.Channels.SingletonConnectionReader.SingletonInputConnectionStream.ReadCore(Byte[] buffer, Int32 offset, Int32 count)
at System.ServiceModel.Channels.SingletonConnectionReader.SingletonInputConnectionStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at System.IO.Stream.ReadByte()
at System.ServiceModel.Channels.MaxMessageSizeStream.ReadByte()
at System.Xml.XmlBufferReader.TryEnsureByte()
at System.Xml.XmlBinaryReader.ReadNode()
at System.Xml.XmlBaseReader.MoveToContent()
at System.ServiceModel.Dispatcher.StreamFormatter.MessageBodyStream.Read(Byte[] buffer, Int32 offset, Int32 count)
--- End of inner exception stack trace ---
at System.ServiceModel.Dispatcher.StreamFormatter.MessageBodyStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at Kusto.Cloud.Platform.Utils.StreamChainBase.Read(Byte[] buffer, Int32 offset, Int32 count) in C:\source\Src\Common\Kusto.Cloud.Platform\IO\StreamChainBase.cs:line 250
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Kusto.Cloud.Platform.Utils.StreamChainBase.Read(Byte[] buffer, Int32 offset, Int32 count) in C:\source\Src\Common\Kusto.Cloud.Platform\IO\StreamChainBase.cs:line 260
at Kusto.DataNode.Interop.StreamSource.Read(IntPtr buf, Int32 cb) in C:\source\Src\Engine\DataNode\ExtentService\Interop\Streams.cs:line 61')
Request id: 2b3b4217-d75b-4014-beae-12376ea08f01
Need Help?
Recommendations on writing efficient log queries.
sloutsky commented 4 years ago

The issue itself doesn't relate to the KQL. Please use StackOverflow with tag 'kusto' to demonstrate the problem (please include input data sample with datatable() operator, and describe what output you would like to achieve)