late-teacher-86348
10/21/2022, 7:56 PM500: Code: 241. DB::Exception: Memory limit (total) exceeded: would use 7.46 GiB (attempt to allocate chunk of 0 bytes), maximum: 7.00 GiB: While executing AggregatingTransform. (MEMORY_LIMIT_EXCEEDED) (version 22.3.8.40.altinitystable (altinity build))
These failing queries run quickly in ClickHouse itself. The difference appears to be that GrowthBook runs the queries in parallel.
Solutions to our problem (beyond increasing RAM) are something like:
1. Not running GrowthBook queries in parallel
2. Allowing some way to manually update guardrail metrics (so we can run them one at a time ourselves)
Happy to provide more info if needed!future-teacher-7046
late-teacher-86348
10/21/2022, 7:58 PMfuture-teacher-7046
late-teacher-86348
10/21/2022, 8:03 PM