Out of Memory error

Hello everyone,

I’m a beginner and this is just my second week of using influxdb. I’m getting this issue when I execute a query.

Query used:

select * from “sample”."_" where time < ‘2018-05-08 00:25:00’

Output:

select * from “sample”."_" where time < ‘2018-05-08 00:25:00’
fatal error: runtime: out of memory

runtime stack:
runtime.throw(0x77077f, 0x16)
/usr/local/go/src/runtime/panic.go:605 +0x95
runtime.sysMap(0xc597c00000, 0x800000, 0xc420158600, 0x94b618)
/usr/local/go/src/runtime/mem_linux.go:216 +0x1d0
runtime.(*mheap).sysAlloc(0x9324a0, 0x800000, 0x7fe55affcd28)
/usr/local/go/src/runtime/malloc.go:470 +0xd7
runtime.(*mheap).grow(0x9324a0, 0x400, 0x0)
/usr/local/go/src/runtime/mheap.go:887 +0x60
runtime.(*mheap).allocSpanLocked(0x9324a0, 0x400, 0x94b628, 0x0)
/usr/local/go/src/runtime/mheap.go:800 +0x334
runtime.(*mheap).alloc_m(0x9324a0, 0x400, 0xffffffffffff0101, 0xc420158600)
/usr/local/go/src/runtime/mheap.go:666 +0x118
runtime.(*mheap).alloc.func1()
/usr/local/go/src/runtime/mheap.go:733 +0x4d
runtime.systemstack(0x7fe55affce10)
/usr/local/go/src/runtime/asm_amd64.s:360 +0xab
runtime.(*mheap).alloc(0x9324a0, 0x400, 0x7fe543010101, 0x7fe55affce90)
/usr/local/go/src/runtime/mheap.go:732 +0xa1
runtime.largeAlloc(0x7ffe00, 0x450101, 0xc597800000)
/usr/local/go/src/runtime/malloc.go:827 +0x98
runtime.mallocgc.func1()
/usr/local/go/src/runtime/malloc.go:722 +0x46
runtime.systemstack(0xc42001d900)
/usr/local/go/src/runtime/asm_amd64.s:344 +0x79
runtime.mstart()
/usr/local/go/src/runtime/proc.go:1135

goroutine 1 [running]:
runtime.systemstack_switch()
/usr/local/go/src/runtime/asm_amd64.s:298 fp=0xc42019e468 sp=0xc42019e460 pc=0x4568c0
runtime.mallocgc(0x7ffe00, 0x6f5820, 0x200001, 0x200000)
/usr/local/go/src/runtime/malloc.go:721 +0x7ae fp=0xc42019e510 sp=0xc42019e468 pc=0x411fae
runtime.makeslice(0x6f5820, 0x3ffe00, 0x7ffe00, 0xc42019e580, 0x5a2dce, 0xc5790f9ef8)
/usr/local/go/src/runtime/slice.go:54 +0x77 fp=0xc42019e540 sp=0xc42019e510 pc=0x4424f7
encoding/json.(*Decoder).refill(0xc5790f9dc0, 0x2c, 0x7)
/usr/local/go/src/encoding/json/stream.go:146 +0x184 fp=0xc42019e5b8 sp=0xc42019e540 pc=0x5a4654
encoding/json.(*Decoder).readValue(0xc5790f9dc0, 0x0, 0x0, 0x412238)
/usr/local/go/src/encoding/json/stream.go:128 +0x275 fp=0xc42019e630 sp=0xc42019e5b8 pc=0x5a42d5
encoding/json.(*Decoder).Decode(0xc5790f9dc0, 0x6ece80, 0xc579057c40, 0x1b020b, 0x0)
/usr/local/go/src/encoding/json/stream.go:57 +0x78 fp=0xc42019e680 sp=0xc42019e630 pc=0x5a3d78
github.com/influxdata/influxdb/client.(*Result).UnmarshalJSON(0xc420109a00, 0xc57991800c, 0x64fbe9, 0x7ffdf4, 0x0, 0x7fe562c62058)
/go/src/github.com/influxdata/influxdb/client/influxdb.go:474 +0xe0 fp=0xc42019e6e8 sp=0xc42019e680 pc=0x623020
encoding/json.(*decodeState).object(0xc5790f9c28, 0x72fe20, 0xc420109a00, 0x199)
/usr/local/go/src/encoding/json/decode.go:601 +0x1b77 fp=0xc42019e938 sp=0xc42019e6e8 pc=0x594d67
encoding/json.(*decodeState).value(0xc5790f9c28, 0x72fe20, 0xc420109a00, 0x199)
/usr/local/go/src/encoding/json/decode.go:405 +0x2e4 fp=0xc42019e9b8 sp=0xc42019e938 pc=0x591ec4
encoding/json.(*decodeState).array(0xc5790f9c28, 0x6f0160, 0xc42014b1d0, 0x197)
/usr/local/go/src/encoding/json/decode.go:558 +0x1d6 fp=0xc42019ead8 sp=0xc42019e9b8 pc=0x592806
encoding/json.(*decodeState).value(0xc5790f9c28, 0x6f0160, 0xc42014b1d0, 0x197)
/usr/local/go/src/encoding/json/decode.go:402 +0x277 fp=0xc42019eb58 sp=0xc42019ead8 pc=0x591e57
encoding/json.(*decodeState).object(0xc5790f9c28, 0x6ece40, 0xc42014b1d0, 0x16)
/usr/local/go/src/encoding/json/decode.go:736 +0x1284 fp=0xc42019eda8 sp=0xc42019eb58 pc=0x594474
encoding/json.(*decodeState).value(0xc5790f9c28, 0x6ece40, 0xc42014b1d0, 0x16)
/usr/local/go/src/encoding/json/decode.go:405 +0x2e4 fp=0xc42019ee28 sp=0xc42019eda8 pc=0x591ec4
encoding/json.(*decodeState).unmarshal(0xc5790f9c28, 0x6ece40, 0xc42014b1d0, 0x0, 0x0)
/usr/local/go/src/encoding/json/decode.go:187 +0x20e fp=0xc42019eea0 sp=0xc42019ee28 pc=0x5913ce
encoding/json.(*Decoder).Decode(0xc5790f9c00, 0x6ece40, 0xc42014b1d0, 0x1b0208, 0x0)
/usr/local/go/src/encoding/json/stream.go:67 +0x1b0 fp=0xc42019eef0 sp=0xc42019eea0 pc=0x5a3eb0
github.com/influxdata/influxdb/client.(*Response).UnmarshalJSON(0xc42014b110, 0xc421220001, 0x64fbf7, 0x7ffdff, 0x2500, 0x7fe562c62030)
/go/src/github.com/influxdata/influxdb/client/influxdb.go:518 +0xe0 fp=0xc42019ef58 sp=0xc42019eef0 pc=0x623410
encoding/json.(*decodeState).object(0xc4201f4028, 0x714fc0, 0xc42014b110, 0x16)
/usr/local/go/src/encoding/json/decode.go:601 +0x1b77 fp=0xc42019f1a8 sp=0xc42019ef58 pc=0x594d67
encoding/json.(*decodeState).value(0xc4201f4028, 0x714fc0, 0xc42014b110, 0x16)
/usr/local/go/src/encoding/json/decode.go:405 +0x2e4 fp=0xc42019f228 sp=0xc42019f1a8 pc=0x591ec4
encoding/json.(*decodeState).unmarshal(0xc4201f4028, 0x714fc0, 0xc42014b110, 0x0, 0x0)
/usr/local/go/src/encoding/json/decode.go:187 +0x20e fp=0xc42019f2a0 sp=0xc42019f228 pc=0x5913ce
encoding/json.(*Decoder).Decode(0xc4201f4000, 0x714fc0, 0xc42014b110, 0x1, 0xc420109900)
/usr/local/go/src/encoding/json/stream.go:67 +0x1b0 fp=0xc42019f2f0 sp=0xc42019f2a0 pc=0x5a3eb0
github.com/influxdata/influxdb/client.(*ChunkedResponse).NextResponse(0xc420126100, 0xc54c8b6d80, 0x1, 0x4a)
/go/src/github.com/influxdata/influxdb/client/influxdb.go:578 +0x5d fp=0xc42019f358 sp=0xc42019f2f0 pc=0x62380d
github.com/influxdata/influxdb/client.(*Client).QueryContext(0xc4200f20e0, 0x8f5da0, 0xc420052fc0, 0xc4200fe740, 0x3d, 0xc420017020, 0xa, 0x1, 0x0, 0x0, …)
/go/src/github.com/influxdata/influxdb/client/influxdb.go:244 +0x5d5 fp=0xc42019f5b0 sp=0xc42019f358 pc=0x6207c5
github.com/influxdata/influxdb/cmd/influx/cli.(*CommandLine).ExecuteQuery(0xc42010c000, 0xc4200fe740, 0x3d, 0x0, 0x0)
/go/src/github.com/influxdata/influxdb/cmd/influx/cli/cli.go:795 +0x1c9 fp=0xc42019f820 sp=0xc42019f5b0 pc=0x6b87f9
github.com/influxdata/influxdb/cmd/influx/cli.(*CommandLine).ParseCommand(0xc42010c000, 0xc4200fe740, 0x3d, 0xc4200fe740, 0x3d)
/go/src/github.com/influxdata/influxdb/cmd/influx/cli/cli.go:307 +0x11a fp=0xc42019f8b0 sp=0xc42019f820 pc=0x6b424a
github.com/influxdata/influxdb/cmd/influx/cli.(*CommandLine).mainLoop(0xc42010c000, 0x0, 0x0)
/go/src/github.com/influxdata/influxdb/cmd/influx/cli/cli.go:245 +0x1b3 fp=0xc42019f9f0 sp=0xc42019f8b0 pc=0x6b3f13
github.com/influxdata/influxdb/cmd/influx/cli.(*CommandLine).Run(0xc42010c000, 0x0, 0x0)
/go/src/github.com/influxdata/influxdb/cmd/influx/cli/cli.go:223 +0x753 fp=0xc42019feb8 sp=0xc42019f9f0 pc=0x6b3293
main.main()
/go/src/github.com/influxdata/influxdb/cmd/influx/main.go:124 +0x86b fp=0xc42019ff80 sp=0xc42019feb8 pc=0x6bee0b
runtime.main()
/usr/local/go/src/runtime/proc.go:195 +0x226 fp=0xc42019ffe0 sp=0xc42019ff80 pc=0x42cb26
runtime.goexit()
/usr/local/go/src/runtime/asm_amd64.s:2337 +0x1 fp=0xc42019ffe8 sp=0xc42019ffe0 pc=0x4594f1

goroutine 5 [syscall, 2 minutes]:
os/signal.signal_recv(0x0)
/usr/local/go/src/runtime/sigqueue.go:131 +0xa6
os/signal.loop()
/usr/local/go/src/os/signal/signal_unix.go:22 +0x22
created by os/signal.init.0
/usr/local/go/src/os/signal/signal_unix.go:28 +0x41

goroutine 18 [select, 2 minutes]:
net/http.(*persistConn).readLoop(0xc42008ec60)
/usr/local/go/src/net/http/transport.go:1654 +0x7a7
created by net/http.(*Transport).dialConn
/usr/local/go/src/net/http/transport.go:1186 +0xa2e

goroutine 19 [select, 2 minutes]:
net/http.(*persistConn).writeLoop(0xc42008ec60)
/usr/local/go/src/net/http/transport.go:1759 +0x165
created by net/http.(*Transport).dialConn
/usr/local/go/src/net/http/transport.go:1187 +0xa53

goroutine 34 [select, 2 minutes, locked to thread]:
runtime.gopark(0x782b90, 0x0, 0x76b5ee, 0x6, 0x18, 0x1)
/usr/local/go/src/runtime/proc.go:287 +0x12c
runtime.selectgo(0xc42015e750, 0xc420156060)
/usr/local/go/src/runtime/select.go:395 +0x1149
runtime.ensureSigM.func1()
/usr/local/go/src/runtime/signal_unix.go:511 +0x220
runtime.goexit()
/usr/local/go/src/runtime/asm_amd64.s:2337 +0x1

goroutine 9 [select, 2 minutes]:
github.com/influxdata/influxdb/cmd/influx/cli.(*CommandLine).ExecuteQuery.func2(0xc42006e720, 0xc42010c000, 0xc4201e8890)
/go/src/github.com/influxdata/influxdb/cmd/influx/cli/cli.go:787 +0xe2
created by github.com/influxdata/influxdb/cmd/influx/cli.(*CommandLine).ExecuteQuery
/go/src/github.com/influxdata/influxdb/cmd/influx/cli/cli.go:786 +0x695