Common triggers
- Streaming graph bottlenecks. Typical causes include join amplification, insufficient resources, and suboptimal streaming queries such as over-window queries and joins.
- Compaction write stalls that result in longer barrier synchronization times.
Diagnosis
- Check CPU and memory utilization for all nodes. If the nodes are fully utilized, the project might have insufficient resources.
- Run
SHOW JOBSand check for jobs that are being created. Backfilling a newly created job can increase pressure on the project.