Hey, first huge thanks for QuestDB, it is awesome in many ways and have been using/prototyping around it for some time now and most of the time it just seems to work 🙂 Now, of course to something that is not working... When I run a query like:

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 get a silent error in the web-ui and the server logs give me the error:

2023-05-24T07:18:21.027359Z C i.q.c.h.p.JsonQueryProcessorState [861] error [msg=`could not mmap  [size=4799952, offset=0, fd=64977, memUsed=293434354166, fileLen=4800512]`, errno=12, q=`<the query above>`

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?

Hi Daniel. Have you tried https://questdb.io/docs/troubleshooting/faq/#why-do-i-see-errno12-mmap-messages-in-the-server-logs ?

Thanks for that link, not sure why my google-fu did not lead me there 🙂 I will report back once I've tested it.