Daniel Wedlund05/24/2023, 7:23 AM
I get a silent error in the web-ui and the server logs give me the error:
select ct.timestamp as ct_ts, p.timestamp as p_ts from sensora as ct ASOF JOIN sensorb as p where p.timestamp between '2023-05-22T18:28:17.461000Z' and '2023-05-22T19:32:40.238000Z'
I can without a problem query the two tables for the given time-range without a problem and the results are 150MB for one table and 24MB for the other table. I am a bit stumped on what to change/fix in terms of config to make this run successfully. My QuestDB instance runs inside docker under WSL2 on windows. The host machine has some 44 cores and 768GB RAM and is currently not running anything else that consumes those resources. Any ideas what to do/test?
2023-05-24T07:18:21.027359Z C i.q.c.h.p.JsonQueryProcessorState  error [msg=`could not mmap [size=4799952, offset=0, fd=64977, memUsed=293434354166, fileLen=4800512]`, errno=12, q=`<the query above>`
Bolek Ziobrowski05/24/2023, 7:41 AM
Daniel Wedlund05/24/2023, 7:42 AM
[wsl2] kernelCommandLine = "sysctl.vm.max_map_count=262144"