crate / crate/cratedb-guide

Feedback on /admin/troubleshooting: How to investigate throttling, and why

Open
#498 1 comment 1 reaction 0 assignees View on GitHub
Dominant language
No language data
Stars
3
Forks
4
Avg merge
3d 18h
Merged PRs (30d)
1

Description

### Documentation feedback


- Page title: Troubleshooting
- Page URL: https://cratedb.com/docs/guide/admin/troubleshooting/index.html
- Source: https://github.com/crate/cratedb-guide/blob/main/docs/admin/troubleshooting/index.md

---

In a future variant of the troubleshooting section, it could elaborate about hands-on details, like how to investigate CrateDB's throttling mechanisms.

One could enable logging to see when the related throttle mechanism kicks in by:
```sql
SET GLOBAL 'logger.io.crate.execution.engine.indexing' = 'DEBUG';
```
Or, if this creates too much noise, more concrete:
```sql
SET GLOBAL 'logger.io.crate.execution.engine.indexing.BatchIteratorBackpressureExecutor' = 'DEBUG';
```
Afterwards there should be log entries like:
```text
Pausing consumption jobId={} delayInMs={}
Resuming consumption jobId={}
```
This may help to understand if throttling is valid or not.

Please note that mostly the throttling is not just kicking in because of CPU load, but also, or even more likely, because of memory/heap saturation.

Thanks, @seut.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.