Title
#users-public
p

Petr Postulka

11/21/2022, 4:23 PM
hi all, quick question, when we query data from questdb instance we get no data and UI shows only error with no explanation - see screenshot below. In the log file of quest there is no error and only the following. Is it somehow related to response buffer is too small message?
Nov 21 16:15:04 questdb-sophon-raw-data-0 questdb[15121]: 2022-11-21T16:15:04.461795Z I http-server connected [ip=172.16.32.251, fd=9]
Nov 21 16:15:04 questdb-sophon-raw-data-0 questdb[15121]: 2022-11-21T16:15:04.461936Z I i.q.c.h.p.JsonQueryProcessorState [9] exec [q='select * from 'table_name'']
Nov 21 16:15:04 questdb-sophon-raw-data-0 questdb[15121]: 2022-11-21T16:15:04.461945Z I i.q.c.h.p.QueryCache miss [thread=questdb-worker-10, sql=select * from 'table_name']
Nov 21 16:15:04 questdb-sophon-raw-data-0 questdb[15121]: 2022-11-21T16:15:04.462234Z I i.q.g.SqlCompiler plan [q=`**** from (select [****] from table_name timestamp (recorder_ts))`, fd=9]
Nov 21 16:15:04 questdb-sophon-raw-data-0 questdb[15121]: 2022-11-21T16:15:04.462409Z I i.q.c.h.p.JsonQueryProcessorState [9] execute-new [skip: 0, stop: 1000]
Nov 21 16:15:05 questdb-sophon-raw-data-0 questdb[15121]: 2022-11-21T16:15:05.605549Z I i.q.c.h.p.JsonQueryProcessorState [9] Response buffer is too small, state=5
Nov 21 16:15:05 questdb-sophon-raw-data-0 questdb[15121]: 2022-11-21T16:15:05.605562Z I http-server scheduling disconnect [fd=9, reason=11]
Nov 21 16:15:05 questdb-sophon-raw-data-0 questdb[15121]: 2022-11-21T16:15:05.605582Z I http-server disconnected [ip=172.16.32.251, fd=9, src=queue]
Nov 21 16:15:05 questdb-sophon-raw-data-0 questdb[15121]: 2022-11-21T16:15:05.605680Z I i.q.c.h.p.QueryCache push [thread=questdb-worker-13, sql=select * from 'table_name']
Nov 21 16:19:59 questdb-sophon-raw-data-0 questdb[15121]: 2022-11-21T16:19:59.663314Z I i.q.c.p.ReaderPool closed 'table_name' [at=0:0, reason=IDLE]
Jaromir Hamala

Jaromir Hamala

11/21/2022, 5:11 PM
hi Petr, is there a chance you have super wide rows? with tons of columns so even a single row does not fit into a buffer? that’s a wild guess anyway.
p

Petr Postulka

11/21/2022, 5:12 PM
I don't think there many columns but in single column there can be very long string i believe
Jaromir Hamala

Jaromir Hamala

11/21/2022, 5:14 PM
is it long as in “It does not fit into my screen anymore, I need a wider display, boss” or as in “100s of kilobytes in a single row” long ?
p

Petr Postulka

11/21/2022, 5:15 PM
Second option 😃
Jaromir Hamala

Jaromir Hamala

11/21/2022, 5:17 PM
ok, that could explain it. you can play with the
http.send.buffer.size
property. it’s 2MB by default.
p

Petr Postulka

11/21/2022, 5:18 PM
thx