Fatal error: runtime: out of memory while query data

Would you please suggest whether any parameter I set incorrectly? The select query triggered by influx cli.

ts=2020-06-17T05:43:13.654506Z lvl=info msg=“Executing query” log_id=0NS4hDl0000 service=query query=“SELECT * FROM bardata.autogen.bardata WHERE time >= ‘2009-01-04’ AND time <= ‘2011-03-02’”
fatal error: runtime: out of memory

runtime stack:
runtime.throw(0x16670d8, 0x16)
/usr/local/go/src/runtime/panic.go:774 +0x72
runtime.sysMap(0xca5c000000, 0x4000000, 0x35a6c78)
/usr/local/go/src/runtime/mem_linux.go:169 +0xc5
runtime.(*mheap).sysAlloc(0x358dc80, 0x4000, 0x4000, 0x7efed77fdd80)
/usr/local/go/src/runtime/malloc.go:701 +0x1cd
runtime.(*mheap).grow(0x358dc80, 0x2, 0xffffffff)
/usr/local/go/src/runtime/mheap.go:1255 +0xa3
runtime.(*mheap).allocSpanLocked(0x358dc80, 0x2, 0x35a6c88, 0x7ef72cc64360)
/usr/local/go/src/runtime/mheap.go:1170 +0x266
runtime.(*mheap).alloc_m(0x358dc80, 0x2, 0x450075, 0x7ef72cc64360)
/usr/local/go/src/runtime/mheap.go:1022 +0xc2
/usr/local/go/src/runtime/mheap.go:1093 +0x4c
/usr/local/go/src/runtime/asm_amd64.s:370 +0x66

Here is my config file, InfluxDB version: 1.8, AWS EC2, RAM: 64G


dir = “/influxdb/data/meta”


dir = “/influxdb/data/db”

wal-dir = “/influxdb/wal”

series-id-set-cache-size = 100












enabled = true

bind-address = “:8089”

database = “bardata”

read-buffer = 10737418240




dir = “/influxdb/data/hh”

It’s very simple. You don’t have enough of memory (RAM) to select point from over 2 years.
time >= ‘2009-01-04’ AND time <= ‘2011-03-02’”

Thanks Bedas! But there are still 50% free memory in server, would you please share where to tune the InfluxDB memory larger?