Running a cpu-only instance (8 cpu, 52gb) I get the following error:
“Query execution failed with error Ran out of slots in the query output buffer”
The query is
select
m,
m.col1,
round(sum(m.col2)) as val
from my_table m
where
m.col2 is not null and m.col2 > 0
and m.col3 in (1) and m.col4 in (17) and 10 + m.col5 * 10000 + m.col6 in (1234) and m.col6 = 231
group by m.col1
order by round(sum(m.col2)) desc
limit 1000
“my_table” has 792948 rows.
At the time of error memory_summary showed less than 100 MB used.
The error no longer occurs after restarting omnisci_server.
OmniSQL Version: 5.3.2-20200803-a970373210
Is there a configuration parameter that can help with this?
Thanks!
Ray