flux service die after run a query

[win434545299]

Steps to reproduce:

{"query":"from(bucket:"mds_variables") |> range(start: 2021-08-31T16:00:00Z ,stop: 2022-04-10T16:00:00Z)|> filter(fn: (r) => r._measurement == "variable" and r.var_id == "527" and r._field == "value" and r._value != 0)|> unique(column: "_value")|> sort(columns: ["_time"], desc: false)|> timeShift(duration: 8h, columns: ["_start", "_stop", "_time"])|> limit(n: 10, offset: -1)","type":"flux","params":{},"dialect":{"header":true,"delimiter":",","annotations":["datatype","group","default"],"commentPrefix":"#","dateTimeFormat":"RFC3339"}}

flux log:

panic: runtime error: slice bounds out of range [-1:]

goroutine 7218 [running]:
github.com/apache/arrow/go/v7/arrow/array.(*Int64).setData(0xc004fdf500, 0xc00218ba40)
/go/pkg/mod/github.com/apache/arrow/go/v7@v7.0.0/arrow/array/numeric.gen.go:80 +0x154
github.com/apache/arrow/go/v7/arrow/array.NewInt64Data(...)
/go/pkg/mod/github.com/apache/arrow/go/v7@v7.0.0/arrow/array/numeric.gen.go:39
github.com/apache/arrow/go/v7/arrow/array.init.0.func10({0x9562120, 0xc00218ba40})
/go/pkg/mod/github.com/apache/arrow/go/v7@v7.0.0/arrow/array/array.go:160 +0x5a
github.com/apache/arrow/go/v7/arrow/array.MakeFromData({0x9562120, 0xc00218ba40})
/go/pkg/mod/github.com/apache/arrow/go/v7@v7.0.0/arrow/array/array.go:133 +0x57
github.com/apache/arrow/go/v7/arrow/array.NewSlice({0x956e998, 0xc003c1e440}, 0xc003c1e440, 0xc004fe45b0)
/go/pkg/mod/github.com/apache/arrow/go/v7@v7.0.0/arrow/array/array.go:144 +0x54
github.com/influxdata/flux/array.Slice({0x955e7f8, 0xc003c1e440}, 0x0, 0x2030004)
/go/pkg/mod/github.com/influxdata/flux@v0.161.0/array/array.go:202 +0x79
github.com/influxdata/flux/arrow.Slice(...)
/go/pkg/mod/github.com/influxdata/flux@v0.161.0/arrow/utils.go:130
github.com/influxdata/flux/stdlib/universe.(*limitTransformation).limitTable.func1({0x9572188, 0xc004faa5c0})
/go/pkg/mod/github.com/influxdata/flux@v0.161.0/stdlib/universe/limit.go:175 +0x1e5
github.com/influxdata/flux/execute/table.(*BufferedTable).Do(0x1a, 0xc001063960)
/go/pkg/mod/github.com/influxdata/flux@v0.161.0/execute/table/buffered.go:69 +0x19b
github.com/influxdata/flux/stdlib/universe.(*limitTransformation).limitTable(0xc0068d8990, {0x9532598, 0x1a}, 0xc004fdf480, {0x953e6d8, 0xc0069fefa0})
/go/pkg/mod/github.com/influxdata/flux@v0.161.0/stdlib/universe/limit.go:145 +0xdf
github.com/influxdata/flux/stdlib/universe.(*limitTransformation).Process.func1({0x9532598, 0xc004fdf440}, 0xc0034f7380)
/go/pkg/mod/github.com/influxdata/flux@v0.161.0/stdlib/universe/limit.go:135 +0x3e
github.com/influxdata/flux/internal/execute/table.StreamWithContext.func1()
/go/pkg/mod/github.com/influxdata/flux@v0.161.0/internal/execute/table/stream.go:109 +0xa6
created by github.com/influxdata/flux/internal/execute/table.StreamWithContext
/go/pkg/mod/github.com/influxdata/flux@v0.161.0/internal/execute/table/stream.go:106 +0x225

Specifications:

• Client Version: 5.0
• InfluxDB Version: 2.2
• JDK Version: zulu1.8
• Platform: windows

[bednar]

Hi @win434545299,

thanks for using our client. It is server related issue.

Regards

[mhilton]

Expanding the query above comes out as:

from(bucket:"mds_variables")
  |> range(start: 2021-08-31T16:00:00Z ,stop: 2022-04-10T16:00:00Z)
  |> filter(fn: (r) => r._measurement == "variable" and r.var_id == "527" and r._field == "value" and r._value != 0)
  |> unique(column: "_value")|> sort(columns: ["_time"], desc: false)
  |> timeShift(duration: 8h, columns: ["_start", "_stop", "_time"])
  |> limit(n: 10, offset: -1)

I wouldn't expect an offset of -1 to do anything good, but probably shouldn't panic.

[philjb]

@win434545299 - do you recall (I know it was a couple years ago) why you have a limit with a negative offset?